Reference
Formula Sheet
Every formula from the four sessions, grouped by topic
Accounting fundamentals
| What | Formula |
|---|---|
| Accounting equation | Assets = Liabilities + Owners’ equity |
| Owners’ equity (net worth) | Share capital + Retained earnings |
| Retained earnings (closing) | Opening RE + Net income − Dividends |
| Capital employed | Net worth + Long-term debt |
| Working capital | Current assets − Current liabilities |
| Net income from change in equity | (Closing equity − Opening equity) + Dividends − New capital |
| Gross profit | Net sales − COGS |
| Operating profit (EBIT) | Gross profit − Operating expenses |
| Profit before tax | EBIT − Interest |
| Profit after tax | PBT − Tax |
| Cash flow identity | CFO + CFI + CFF = Net change in cash |
| Supplies consumed | Opening stock + Purchases − Closing stock |
| Book value per share | Net worth ÷ Shares outstanding |
Depreciation
| What | Formula |
|---|---|
| Depreciable amount | Cost − Residual value |
| SLM annual depreciation | (Cost − Residual) ÷ Useful life |
| Monthly depreciation | Annual depreciation ÷ 12 |
| WDV rate | 1 − (Residual ÷ Cost)^(1/n), n = useful life |
| WDV depreciation (any year) | Opening net book value × WDV rate |
| Accumulated depreciation | All depreciation charged since purchase |
| Net block | Gross block − Accumulated depreciation |
Cost and CVP
| What | Formula |
|---|---|
| Contribution per unit | Price − Variable cost per unit |
| CS ratio | Contribution per unit ÷ Price |
| Break-even units | Fixed costs ÷ Contribution per unit |
| Break-even sales | Fixed costs ÷ CS ratio |
| Units for a target profit | (Fixed costs + Target profit) ÷ Contribution per unit |
| Margin of safety | Actual sales − Break-even sales |
| Margin of safety ratio | Margin of safety ÷ Actual sales |
| Profit via margin of safety | Margin of safety sales × CS ratio |
| Weighted contribution (multi-product) | Σ (Contribution per unit × Sales-mix %) |
| Multi-product break-even | Fixed costs ÷ Weighted contribution (round up) |
| High–low variable rate | (Cost at high − Cost at low) ÷ (High volume − Low volume) |
| High–low fixed cost | Total cost at either point − (Variable rate × Volume at that point) |
Analysis tools
| What | Formula |
|---|---|
| Horizontal % change | (Change ÷ Base-year amount) × 100 |
| Trend index | (Current year ÷ Year 1) × 100 |
| Common-size P&L | Each line ÷ Net sales × 100 |
| Common-size balance sheet | Each line ÷ Total assets × 100 |
Ratios by window
| Window | Ratio | Formula | Better when |
|---|---|---|---|
| Liquidity | Current ratio | Current assets ÷ Current liabilities | Adequate: not too high or low |
| Liquidity | Quick ratio | (Current assets − Inventory) ÷ Current liabilities | Above 1.0 |
| Liquidity | Financial slack | Cash and bank ÷ Total assets × 100 | Higher = more flexibility |
| Efficiency | Total asset turnover | Sales ÷ Total assets | Higher |
| Efficiency | Fixed asset turnover | Sales ÷ Net block | Higher |
| Efficiency | Inventory turnover | COGS ÷ Average inventory | Higher |
| Efficiency | Debtors turnover | Credit sales ÷ Average debtors | Higher |
| Efficiency | Creditors turnover | Credit purchases ÷ Average creditors | Lower |
| Efficiency | DIO | 365 ÷ Inventory turnover | Lower |
| Efficiency | DSO | 365 ÷ Debtors turnover | Lower |
| Efficiency | DPO | 365 ÷ Creditors turnover | Higher |
| Efficiency | Cash conversion cycle | DIO + DSO − DPO | Lower or negative |
| Profitability | Gross margin | Gross profit ÷ Sales × 100 | Higher |
| Profitability | Operating margin | Operating profit ÷ Sales × 100 | Higher |
| Profitability | Net margin | PAT ÷ Sales × 100 | Higher |
| Profitability | ROTA | PBIAT ÷ Total assets × 100 | Higher |
| Profitability | ROCE / ROI | Operating profit ÷ Capital employed × 100 | Higher |
| Profitability | ROE / RONW | PAT ÷ Net worth × 100 | Above ROCE when leverage works |
| Profitability | EPS | (PAT − Preference dividends) ÷ Weighted average shares | Higher |
| Profitability | Payout ratio | Dividend ÷ PAT × 100 | Depends on the business |
| Leverage | Debt–equity | Long-term debt ÷ Equity | Depends on the business |
| Leverage | Interest coverage | (PBT + Interest) ÷ Interest | Above 2.0 |
| Leverage | DSCR | Operating cash flow after tax ÷ (Interest + Principal) | Above 1.0 |
| Leverage | Debt ratio | LT debt ÷ (LT debt + Equity) × 100 | Depends on the business |
ROTA, correctly
PBIAT = PAT + Interest × (1 − tax rate). Example: PAT Rs.20L, interest Rs.5L, tax 30% → PBIAT = 20 + 3.5 = Rs.23.5L. On total assets of Rs.200L, ROTA = 11.75%. Never compute it as (PAT + Interest) × (1 − tax rate).
Leverage, in two lines
- When ROTA is above the cost of debt: ROE > ROCE > ROTA. Debt is helping owners.
- When ROTA is below the cost of debt: every rupee of debt destroys equity value.