📌 The Big Picture
What is a Ratio? What is Ratio Analysis?
A ratio is a mathematical relationship between two quantities expressed as a fraction, percentage, or proportion (e.g., 2:1). An accounting ratio is the relationship between two accounting figures drawn from financial statements.
Ratio Analysis is the technique of establishing and interpreting various ratios to draw meaningful conclusions about the financial health of a business. It converts raw financial data into standardised, comparable measures.
1. Objectives, Advantages and Limitations
O1
Objective: Assess Liquidity
Are there enough liquid assets to pay current obligations? Current Ratio and Quick Ratio answer this.
O2
Objective: Assess Solvency
Can the firm survive in the long run and service its debt? Debt-Equity and Interest Coverage Ratios measure this.
O3
Objective: Assess Efficiency
How effectively are assets being used? Turnover Ratios measure asset utilisation efficiency.
O4
Objective: Assess Profitability
Is the company earning enough relative to sales, assets, and capital? Profitability Ratios measure this.
Key Limitations of Ratio Analysis
Window dressing distorts ratios. Different accounting policies make inter-firm comparison misleading. Ratios use historical data and ignore price level changes. A single ratio tells little — ratios must be interpreted in context with industry averages and trends. They also ignore qualitative factors.
2. Master Formula Reference — All 19 Ratios
■ Category 1: Liquidity Ratios
1. Current Ratio
Current Assets ÷ Current Liabilities
Ideal: 2 : 1. Measures short-term solvency.
2. Quick Ratio (Liquid Ratio / Acid Test)
Quick Assets ÷ Current Liabilities
Quick Assets = CA − Inventories − Prepaid Expenses
Ideal: 1 : 1. More stringent test of liquidity.
■ Category 2: Solvency Ratios
3. Debt to Equity Ratio
Long-term Debt ÷ Shareholders' Funds
Lower is better. Measures financial leverage.
4. Total Assets to Debt Ratio
Total Assets ÷ Long-term Debt
Higher is safer. Assets available per rupee of debt.
5. Proprietary Ratio
Shareholders' Funds ÷ Total Assets
Higher is better. Proportion financed by equity.
6. Interest Coverage Ratio
Net Profit Before Interest & Tax ÷ Interest on Long-term Debt
Higher is better. Times interest is earned.
7. Debt to Capital Employed Ratio
Long-term Debt ÷ Capital Employed
Capital Employed = Shareholders' Funds + Long-term Debt
■ Category 3: Activity (Turnover) Ratios
8. Inventory Turnover Ratio
Cost of Revenue from Operations ÷ Average Inventory
Average Inv = (Opening + Closing) ÷ 2. Days Inv = 365 ÷ ITR.
9. Trade Receivables Turnover Ratio
Net Credit Revenue from Operations ÷ Average Trade Receivables
Debtors Collection Period = 365 ÷ TRTR (days).
10. Trade Payables Turnover Ratio
Net Credit Purchases ÷ Average Trade Payables
Payables Payment Period = 365 ÷ TPTR (days).
11. Fixed Assets Turnover Ratio
Net Revenue from Operations ÷ Net Fixed Assets
How many rupees of sales per rupee of fixed assets.
12. Net Assets Turnover Ratio
Net Revenue from Operations ÷ Net Assets (Capital Employed)
Net Assets = Capital Employed = Shareholders' Funds + LTD.
13. Working Capital Turnover Ratio
Net Revenue from Operations ÷ Working Capital
Working Capital = Current Assets − Current Liabilities.
■ Category 4: Profitability Ratios
14. Gross Profit Ratio
(Gross Profit ÷ Net Revenue from Operations) × 100
Gross Profit = Net Revenue − Cost of Revenue from Operations
15. Operating Ratio
(Operating Cost ÷ Net Revenue from Operations) × 100
Operating Cost = Cost of Revenue + Operating Expenses. Operating Ratio + Operating Profit Ratio = 100%.
16. Operating Profit Ratio
(Operating Profit ÷ Net Revenue from Operations) × 100
Operating Profit = Gross Profit − Operating Expenses = PBIT (Profit Before Interest and Tax)
17. Net Profit Ratio
(Net Profit After Tax ÷ Net Revenue from Operations) × 100
Also computed using Net Profit Before Tax as per CBSE note.
18 & 19. Return on Investment (ROI)
(Net Profit Before Interest & Tax ÷ Capital Employed) × 100
Capital Employed = Shareholders' Funds + Long-term Debt = Total Assets − Current Liabilities.
🎯 Key Definitions to Memorise:
Capital Employed = Shareholders' Funds + Long-term Debt = Total Assets − Current Liabilities
Working Capital = Current Assets − Current Liabilities
Quick Assets = Current Assets − Inventories − Prepaid Expenses
Gross Profit = Net Revenue from Operations − Cost of Revenue from Operations
Operating Profit = Gross Profit − Operating Expenses (Depreciation is included; Finance Costs are NOT)
NPBIT = Operating Profit = PBT + Interest on long-term debt
📈 Numerical 1 — Current Ratio and Quick Ratio
Question: From the following, calculate Current Ratio and Quick Ratio: Inventories ₹60,000 | Trade Receivables ₹50,000 | Cash and Bank ₹20,000 | Prepaid Expenses ₹5,000 | Short-term Investments ₹15,000 | Trade Payables ₹40,000 | Short-term Borrowings ₹30,000 | Outstanding Expenses ₹5,000
| Item | Amount (₹) | Classification |
|---|
| Inventories | 60,000 | Current Assets (excluded from Quick Assets) |
| Trade Receivables | 50,000 | Current Assets and Quick Assets |
| Cash and Bank | 20,000 | Current Assets and Quick Assets |
| Prepaid Expenses | 5,000 | Current Assets (excluded from Quick Assets) |
| Short-term Investments | 15,000 | Current Assets and Quick Assets |
| Total Current Assets | 1,50,000 | |
| Quick Assets | 85,000 | 1,50,000 − 60,000 − 5,000 |
| Trade Payables | 40,000 | Current Liabilities |
| Short-term Borrowings | 30,000 | Current Liabilities |
| Outstanding Expenses | 5,000 | Current Liabilities |
| Total Current Liabilities | 75,000 | |
📈 Numerical 2 — Solvency Ratios (All Five)
Question: Calculate all five solvency ratios from: Share Capital ₹4,00,000 | Reserves and Surplus ₹1,00,000 | Long-term Borrowings ₹2,50,000 | Total Assets ₹8,00,000 | Current Liabilities ₹50,000 | Net Profit Before Interest and Tax ₹80,000 | Interest on Long-term Debt ₹25,000
Working: Shareholders' Funds = 4,00,000 + 1,00,000 = ₹5,00,000. Capital Employed = 5,00,000 + 2,50,000 = ₹7,50,000 (also = Total Assets − CL = 8,00,000 − 50,000 = 7,50,000 ✔)
Interpretation: Debt to Equity at 0.5 means the company has only ₹0.50 of debt for every ₹1 of equity — low leverage. Proprietary Ratio of 62.5% means 62.5% of assets are funded by shareholders — a sound position. Interest Coverage of 3.2 times means profit covers interest 3.2 times — comfortable.
📈 Numerical 3 — Inventory Turnover Ratio
Question: Net Revenue from Operations ₹12,00,000 | Cost of Revenue from Operations ₹9,00,000 | Opening Inventory ₹1,20,000 | Closing Inventory ₹80,000. Calculate Inventory Turnover Ratio and Days Inventory.
Interpretation: A high ITR (9 times) means the company sells and replaces its inventory quickly — efficient stock management and low holding costs.
📈 Numerical 4 — Trade Receivables and Trade Payables Turnover
Question: Net Credit Revenue ₹8,00,000 | Opening TR ₹80,000 | Closing TR ₹1,20,000 | Net Credit Purchases ₹7,00,000 | Opening TP ₹60,000 | Closing TP ₹1,00,000. Calculate Trade Receivables Turnover and Debtors Collection Period; Trade Payables Turnover and Payment Period.
Interpretation: Debtors pay in 46 days on average, while the company pays its creditors in 42 days. This means the company collects later than it pays — a potential cash flow concern. Ideally, collection period should be less than payment period.
📈 Numerical 5 — Fixed Assets, Net Assets and Working Capital Turnover
Question: Net Revenue from Operations ₹15,00,000 | Net Fixed Assets ₹5,00,000 | Capital Employed ₹10,00,000 | Current Assets ₹4,00,000 | Current Liabilities ₹1,50,000
📈 Numerical 6 — Profitability Ratios (All Five)
Question: Net Revenue from Operations ₹10,00,000 | Cost of Revenue ₹6,00,000 | Operating Expenses ₹1,00,000 | Interest on Debt ₹50,000 | Tax ₹1,00,000 | Capital Employed ₹12,00,000
Working the P&L chain:
Gross Profit = 10,00,000 − 6,00,000 = ₹4,00,000
Operating Profit (PBIT) = 4,00,000 − 1,00,000 = ₹3,00,000
PBT = 3,00,000 − 50,000 = ₹2,50,000
PAT = 2,50,000 − 1,00,000 = ₹1,50,000
Operating Cost = Cost of Revenue + Operating Expenses = 6,00,000 + 1,00,000 = ₹7,00,000
📈 Numerical 7 — Missing Figure: Find Current Assets and Current Liabilities
Question (Board Pattern): Current Ratio = 2.5 : 1. Working Capital = ₹1,20,000. Find Current Assets and Current Liabilities.
Method: Let Current Liabilities = x. Then Current Assets = 2.5x.
Working Capital = CA − CL = 2.5x − x = 1.5x = ₹1,20,000
x = 1,20,000 ÷ 1.5 = ₹80,000 (Current Liabilities)
Current Assets = 2.5 × 80,000 = ₹2,00,000
Verify: CR = 2,00,000 ÷ 80,000 = 2.5 ✔. WC = 2,00,000 − 80,000 = 1,20,000 ✔
📈 Numerical 8 — Missing Figure: Find Inventories
Question (Board Pattern): Current Ratio = 3 : 1. Quick Ratio = 1.5 : 1. Current Liabilities = ₹60,000. Find Inventories. (Assume no prepaid expenses.)
Method:
Current Assets = 3 × 60,000 = ₹1,80,000
Quick Assets = 1.5 × 60,000 = ₹90,000
Inventories = CA − Quick Assets = 1,80,000 − 90,000 = ₹90,000
Logic: The difference between Current Assets and Quick Assets is exactly the illiquid portion — Inventories + Prepaid Expenses. If prepaid = 0, then Inventories = CA − QA.
📈 Numerical 9 — Missing Figure: Find Capital Employed from ROI
Question: ROI = 20%. Net Profit Before Interest and Tax = ₹2,40,000. Shareholders' Funds = ₹8,00,000. Find Long-term Debt.
Method:
ROI = (NPBIT / Capital Employed) × 100
20 = (2,40,000 / CE) × 100
CE = (2,40,000 / 20) × 100 = ₹12,00,000
Capital Employed = Shareholders' Funds + Long-term Debt
12,00,000 = 8,00,000 + LTD
Long-term Debt = 12,00,000 − 8,00,000 = ₹4,00,000
📈 Numerical 10 — Comprehensive: Multiple Ratios from One Data Set
Question: From the Balance Sheet extract of Jupiter Ltd., calculate: (a) Current Ratio, (b) Debt to Equity Ratio, (c) Proprietary Ratio, (d) Working Capital Turnover Ratio.
Share Capital ₹6,00,000 | General Reserve ₹2,00,000 | Surplus (P&L) ₹50,000 | 10% Debentures ₹3,00,000 | Trade Payables ₹1,00,000 | Provision for Tax ₹50,000 | Fixed Assets ₹8,00,000 | Inventories ₹2,00,000 | Trade Receivables ₹1,50,000 | Cash ₹50,000 | Net Revenue from Operations ₹12,00,000
Identification: Shareholders' Funds = 6,00,000 + 2,00,000 + 50,000 = ₹8,50,000. Long-term Debt = ₹3,00,000. Current Liabilities = 1,00,000 + 50,000 = ₹1,50,000. Total Assets = 8,50,000 + 3,00,000 + 1,50,000 = ₹13,00,000. Current Assets = 2,00,000 + 1,50,000 + 50,000 = ₹4,00,000. Working Capital = 4,00,000 − 1,50,000 = ₹2,50,000.
⚡ Quick Recall — All 19 Ratios at a Glance
Liquidity: Current = CA/CL (ideal 2:1). Quick = QA/CL (ideal 1:1). QA = CA − Inv − Prepaid.
Solvency: D/E = LTD/SF. TA/Debt = Total Assets/LTD. Proprietary = SF/TA. ICR = NPBIT/Interest. D/CE = LTD/CE.
Activity: ITR = Cost/Avg Inv. TRTR = Credit Revenue/Avg TR. TPTR = Credit Purchases/Avg TP. FATR = Revenue/Net FA. NATR = Revenue/CE. WCTR = Revenue/WC.
Profitability: GP% = (GP/Rev)x100. Op Ratio = (OC/Rev)x100. Op Profit% = (OP/Rev)x100. NP% = (PAT/Rev)x100. ROI = (NPBIT/CE)x100.
Key: Capital Employed = SF + LTD = TA − CL. Operating Profit = GP − Operating Expenses. Operating Ratio + Operating Profit Ratio = 100%.
Days: Days Inventory = 365/ITR. Debtors Collection Period = 365/TRTR. Creditors Payment Period = 365/TPTR.