FORMULA
š· PHRM 351 ā Finance & Business Formula Cheat Sheet (Juliet-Coded Edition)
šµ 1⣠Core Terms
Term | Meaning |
|---|---|
Revenue (aka Sales) | Total earned from selling goods/services |
COGS = Cost of Goods Sold | Direct cost to make or buy what you sell (e.g., drug acquisition + packaging) |
Expenses / Operating Costs | Overhead like rent, salaries, utilities |
Fixed Cost | Doesnāt change with sales (e.g., rent, insurance) |
Variable Cost | Changes with volume (e.g., drug inventory, vials) |
𧾠2⣠Profit & Margin Math
Formula | Description | Example |
|---|---|---|
Gross Profit = Revenue ā COGS | Profit before operating expenses | 80 ā 50 = 30 |
Gross Margin % = (Gross Profit Ć· Revenue) Ć 100 | % of sales kept after paying COGS | (30/80)Ć100 = 37.5 % |
Operating Profit (EBIT) = Gross Profit ā Operating Expenses | Earnings before interest & tax | 30 ā 10 = 20 |
Net Profit = Operating Profit ā Interest ā Taxes | āBottom lineā take-home profit | 20 ā 3 ā 2 = 15 |
Net Margin % = (Net Profit Ć· Revenue) Ć 100 | Overall profitability | (15/80)Ć100 = 18.8 % |
š 3⣠Return & Performance
Formula | Purpose | Example |
|---|---|---|
ROI % = (Net Profit Ć· Investment) Ć 100 | Return on investment | (15 / 300)Ć100 = 5 % |
ROE % = (Net Income Ć· Owner Equity) Ć 100 | Return on ownerās equity | (60 / 400)Ć100 = 15 % |
DSCR = Net Income Ć· Annual Debt Service | Lender test for loan capacity | 125 000 / 100 000 = 1.25 ā |
ā 4⣠Break-Even & Sales Math
Break-EvenĀ Units=FixedĀ CostsPriceĀ perĀ UnitĀ āĀ VariableĀ CostĀ perĀ Unit\text{Break-Even Units} = \frac{\text{Fixed Costs}}{\text{Price per Unit ā Variable Cost per Unit}}Break-EvenĀ Units=PriceĀ perĀ UnitĀ āĀ VariableĀ CostĀ perĀ UnitFixedĀ Costsā
𩵠Example: 10 000 Ć· (40 ā 30) = 1 000 units
Break-EvenĀ Revenue=Break-EvenĀ UnitsĆPriceĀ perĀ Unit\text{Break-Even Revenue} = \text{Break-Even Units} Ć \text{Price per Unit}Break-EvenĀ Revenue=Break-EvenĀ UnitsĆPriceĀ perĀ Unit
Margin of Safety % = (Actual Sales ā Break-Even Sales) Ć· Actual Sales Ć 100
š° 5⣠Cash Flow Essentials
Type | In/Out Examples | Formula |
|---|---|---|
Operating | Rx sales (+), payroll (ā) | |
Investing | Buy fridge (ā), sell property (+) | |
Financing | Bank loan (+), loan repay (ā), dividends (ā) |
NetĀ CashĀ Flow=Operating+Investing+Financing\text{Net Cash Flow} = \text{Operating} + \text{Investing} + \text{Financing}NetĀ CashĀ Flow=Operating+Investing+Financing
š§ Profit ā Cash Flow: buying stock ā uses cash now but affects profit later.
š 6⣠Growth & Compounding
A=P(1+r)tA = P(1 + r)^tA=P(1+r)t
where A = final amount, P = principal, r = rate (decimal), t = years
š” 10 000(1.06)^5 = 13 382
𧮠7⣠Depreciation (Equipment Value Drop)
Straight-LineĀ Depreciation=CostĀ āĀ SalvageĀ ValueUsefulĀ LifeĀ (years)\text{Straight-Line Depreciation} = \frac{\text{Cost ā Salvage Value}}{\text{Useful Life (years)}}Straight-LineĀ Depreciation=UsefulĀ LifeĀ (years)CostĀ āĀ SalvageĀ Valueā
Example: (10 000 ā 1 000)/5 = 1 800 per year.
š¦ 8⣠Pharmacy Ownership & Valuation (Lec 14 Extras)
Formula | Description | Example |
|---|---|---|
Pharmacy Value ā Net Profit Ć Multiplier | Quick valuation rule of thumb | 250 000 Ć 5 = 1.25 M |
Loan Payment (Amortized) | PĆr(1+r)n(1+r)nā1P Ć \frac{r(1 + r)^n}{(1 + r)^n ā 1}PĆ(1+r)nā1r(1+r)nā | Use if asked for monthly payments |
Inventory Turnover = COGS Ć· Avg Inventory | Efficiency metric | 500 000 Ć· 100 000 = 5Ć/yr |
Days in Inventory = 365 Ć· Turnover | Holding time | 365 / 5 = 73 days |
šØš¦ 9⣠Taxes & Savings (Quick Recall)
Account | Tax Treatment | Best Use |
|---|---|---|
RRSP | Tax-deductible now, taxed later | High-income years ā refund |
TFSA | After-tax in, tax-free out | Flexible savings |
FHSA | Combines both benefits | First home fund |
Corp Tax Rate (BC) | Small biz = 11 %; General = 27 % | |
LCGE | 1 M capital-gain exemption on small biz sale |
š 10⣠Mini Example (Everything in One)
Given: Price $60, COGS $35, Fixed Cost $100 000, Interest+Tax $20 000, Sales 5 000 Rx.
ā Gross Profit = (60ā35)Ć5 000 = 125 000
ā Operating Profit = 125 000ā100 000 = 25 000
ā Net Profit = 25 000ā20 000 = 5 000
ā ROI % = 5 000 Ć· 100 000 Ć 100 = 5 %
ā Break-Even Units = 100 000 Ć· (60ā35) = 4 000 units
ā Sell > 4 000 Rx to profit.
š” 11⣠Quick Memory Triggers
āGrossā = Before Expenses š°
āOperatingā = Core Business š§
āNetā = After Everything šµ
āCOGSā = What it costs to get on the shelf š¦
āBreak-evenā = Safety line ā
āROIā = Worth it or nah š