Official Suggested Answer
Working Notes:
Debt = ₹ 45,00,000
Interest = ₹ 45,00,000 x 12.5% = 5,62,500
Debt to Equity = 1.5:1 = Total Debt / Shareholders' Equity
Equity = ₹ 30,00,000
Return on Shareholder's funds = 54% = Net Profit after taxes / Equity shareholders' fund × 100
Profit after tax (PAT) = 54% x Equity = ₹ 16,20,000
Profit before tax (PBT)(1-25%) = Profit after tax
= ₹ 16,20,000 / 75% = ₹ 21,60,000
Earning before interest and tax (EBIT) = PBT + Interest
= ₹ 21,60,000 + ₹ 5,62,500
= ₹ 27,22,500
(i) Interest Coverage Ratio = EBIT / Interest
= ₹ 27,22,500 / ₹ 5,62,500
= 4.84 Times
(ii) Operating Profit Ratio = 1 - Operating Ratio
= 1 – 0.85 = 0.15 or 15%
0.15 = Operating Profit / Sales × 100
Sales = EBIT or Operating Profit / 0.15
= ₹ 27,22,500 / 0.15
= ₹ 1,81,50,000
Operating ratio = Operating expenses / Cost of goods sold (COGS) = 2:6 = 1:3
Operating expenses = 1/3 COGS
Operating cost = Sales – Operating profit
= ₹ 1,81,50,000 - ₹ 27,22,500
= ₹ 1,54,27,500
₹ 1,54,27,500 = COGS + Operating expenses
₹ 1,54,27,500 = COGS + 1/3 COGS
COGS = ₹ 1,15,70,625
Gross profit = Sales – COGS
= 1,81,50,000 – 1,15,70,625
= ₹ 65,79,375
Gross Profit ratio = Gross Profit / Sales × 100
= 65,79,375 / 1,81,50,000
= 0.3625 or 36.25%
Gross profit and sales can be calculated in alternative way also. However, there will be no change in GP ratio i.e 36.25%
(iii) Current Ratio = Current Assets / Current Liabilities = 1.8
Current Assets = 1.8 Current Liabilities
Total of Balance sheet liability = Equity + Debt + Current Liabilities
= 30,00,000 + 45,00,000 + CL ……….(2)
Total Balance sheet asset = Fixed Assets + Current Assets
= 39 lakhs + CA = 39 + 1.8CL …….(3)
Equating 2 and 3,
75,00,000 + CL = 39,00,000 + 1.8CL
0.8CL = 36,00,000
CL = ₹ 45,00,000
Current Assets = 1.8 CL = 1.8 x 45 lakhs = ₹ 81,00,000
Source: ICAI Board of Studies. open source PDF ↗
Worked Solution
✓ VerifiedSolution: Financial Ratio Analysis — Theme Ltd
(i) Interest Coverage Ratio
Debt = ₹45,00,000 at 12.5%, so Interest = ₹5,62,500.
Equity (from Debt:Equity = 1.5:1) = 45,00,000 ÷ 1.5 = ₹30,00,000.
Return on Shareholder's Fund = 54%, so Net Profit After Tax = 54% × 30,00,000 = ₹16,20,000.
Net Profit Before Tax (at 25% tax) = 16,20,000 ÷ 0.75 = ₹21,60,000.
EBIT = Net Profit Before Tax + Interest = 21,60,000 + 5,62,500 = ₹27,22,500.
Interest Coverage Ratio = EBIT ÷ Interest = 27,22,500 ÷ 5,62,500 = 4.84 times
---
(ii) Gross Profit Ratio
Operating Ratio = 85% means (COGS + Operating Expenses) = 85% of Sales, so Operating Profit = 15% of Sales.
Since Operating Profit = EBIT = ₹27,22,500:
Sales = 27,22,500 ÷ 0.15 = ₹1,81,50,000
Ratio of Operating Expenses : COGS = 2:6. Combined they are 8 parts = 85% of Sales.
COGS = (6/8) × 85% of Sales = 63.75% of Sales = 63.75% × 1,81,50,000 = ₹1,15,70,625.
Gross Profit = Sales − COGS = 1,81,50,000 − 1,15,70,625 = ₹65,79,375.
Gross Profit Ratio = 65,79,375 ÷ 1,81,50,000 × 100 = 36.25%
---
(iii) Current Assets
Total Long-term Funds = Equity + Debt = 30,00,000 + 45,00,000 = ₹75,00,000.
Net Working Capital (NWC) = Long-term Funds − Fixed Assets = 75,00,000 − 39,00,000 = ₹36,00,000.
From Current Ratio = CA/CL = 1.8 and CA − CL = 36,00,000:
0.8 × CL = 36,00,000 → CL = ₹45,00,000 → CA = 1.8 × 45,00,000 = ₹81,00,000.
Current Assets = ₹81,00,000
Write it like this
1The skeleton
- Establish Equity first from Debt:Equity = 1.5:1 — write this as Step 1 on your sheet before touching any other ratio, because literally every part (i), (ii), and (iii) chains back to Equity = ₹30,00,000; examiners reward sequential logic.
- Work EBIT backwards via the tax chain — go NPAT → NPBT → EBIT, showing each arrow explicitly; if you jump straight to EBIT without showing the ÷0.75 step, you lose a method mark even if your final number is right.
- Anchor GP Ratio on the Operating Profit = EBIT insight — write 'Since no non-operating income/expense is given, Operating Profit = EBIT' as a one-liner; this justifies using ₹27,22,500 to derive Sales and stops the examiner questioning your logic.
- Split COGS using the 2:6 ratio explicitly — show 'COGS = 6/8 × 85% of Sales' as a separate line; telescoping this into one step hides your working and risks zero marks on the sub-step even if your GP% is correct.
- Use the Balance Sheet identity for Current Assets — state 'NWC = Long-term Funds − Fixed Assets' before applying Current Ratio; examiner expects this route, not a plug-and-pray with random CL values.
- Box each final answer with its name and unit — 'Interest Coverage Ratio = 4.84 times', 'GP Ratio = 36.25%', 'Current Assets = ₹81,00,000'; unboxed answers buried in working get missed during rapid scanning.
2Examiner-rewarded phrases
3Common trap
The killer mistake is using Total Capital Employed (Equity + Debt = ₹75,00,000) instead of just Equity (₹30,00,000) when applying the 54% Return on Shareholder's Fund — that single wrong base blows up NPAT, EBIT, Sales, and GP Ratio in a domino, costing you 6+ marks across all three parts even though your ratio mechanics are perfect.