Ratio Analysis - Solutions
Ratio Analysis - Solutions
Balance Sheet
PARTICULARS Rs. Rs.
I) SOURCES OF FUNDS
A) Shareholders Funds/ Proprietors Fund/Own Funds/ Net worth/ Equity
Share Capital:
Equity Share Capital (face value ₹ 10) 2,00,000
10% Preference Share Capital 1,00,000
Total Share Capital 3,00,000
Add: Reserves & Surplus
Reserves & Surplus 2,00,000
Less: Ficticious Assets
Underwriting Commission 10,000
Shareholders Funds/ Proprietors Fund/Own Funds/ Net worth/ Equity 4,90,000
LIQUIDITY RATIOS
1.1 Current Ratio = Current Assets (CA) = Quick Assets + Non-Quick Assets
Current Liabilities (CL) Quick Liabilities + Non-Quick Liabilities
Current Ratio 1.55 :1
Current Assets 5,75,000
Current Liabilities 3,70,000
1.2 Liquid Ratio / Quick Ratio / = Quick Assets = Current Assets – Non-Quick Assets
Acid test Ratio Quick Liabilities Current Liabilities – Non-Quick Liabilities
(Use the above formula, if nothing is been specifically asked)
OR
= Quick Assets = Current Assets – Non-Quick Assets
Current Liabilities Current Liabilities
1.3 Absolute Liquid Ratio = Cash + Cash equivalents = Cash + Bank + Marketable Securities
Current Liabilities Current Liabilities
Absolute Cash Ratio 0.24 :1
Cash & Cash Equivalent 90,000
Current Liabilities 3,70,000
1.5 Inventory or Stock to Working Capital Ratio = Inventory (RM, WIP, FG) x 100
Working Capital
= Inventory (RM, WIP, FG) x 100
Current assets -Current Liabilities
Inventory To Working Capital 97.56 %
Inventory 2,00,000
Working Capital 2,05,000
ACTIVITY RATIOS
2.7 Operating Cycle Duration (i.e. Net Operating Cycle) = Stock Holding Period (+) Debtors Collection
Period (-) Creditors Payment Period
Operating Cycle Duration in number of days. 25.10 Days
Operating Cycle Duration in number of months. 0.83 Months
Operating Cycle Duration in number of weeks. 3.58 Weeks
PROFITABILITY RATIOS
4.1(b) Total Liabilities to Equity Ratio = Long Term Debt + Current Liabilities
Shareholders Funds
Total Liabilities to Equity Ratio = 0.96 :1
Long Term Borrowed Funds 1,00,000
Current Liabilities 3,70,000
Total Liabilities 4,70,000
Shareholder's Funds 4,90,000
4.2 Debt to Total Assets = Borrowed Funds (Long Term)
Total Assets
Note: Always use above formula, if nothing is been specifically asked
Debt to Total Assets Ratio = 0.10 :1
Borrowed Funds (Long Term) 1,00,000 10.42%
Total assets 9,60,000
Coverage Ratio
5.1 Interest Coverage Ratio = Profit Before Interest and Taxes
Annual Interest
Interest Coverage Ratio = 22.79 Times
Earnings Before Interest and Taxes 2,73,500
Annual Interest 12,000
7.3 Return on Capital Employed = Earnings Before Interest and Tax x 100
(ROCE) Average Capital Employed
Return on Capital Employed 46.36 %
Earnings Before Interest & Tax 2,73,500
Capital Employed = (Owner's Funds + Borrowed Funds) 5,90,000
(iii) Book Value Per Share = Total Shareholder's Fund - Preference Share Capital
Number of Equity Shares
Book Value Per Share = 20.00 Rs. per share
(i) (ii) (iii) (iv) = (ii) x 12% (v) = (iii) - (iv) (vi) = (ii) - (v)
1 300.00 124.90 36.00 88.90 211.10
2 211.10 124.90 25.33 99.57 111.52
3 111.52 124.90 13.38 111.52 -0.00
Total 300.00
Equated Installment = Loan at beginning ÷ PVAF
Particulars Year 1 Year 2 Year 3 Total
Earnings Before Interest, Tax, Depreciation & Amortisation 200.00 210.00 220.00 630.00
Less: Depreciation -150.00 -150.00 -150.00 -450.00
Earnings Before Interest & Tax 50.00 60.00 70.00 180.00
Less: Interest on term loan -36.00 -25.33 -13.38 -74.71
Net Profit Before Tax 14.00 34.67 56.62 105.29
Less: Provision for tax -4.90 -12.13 -19.82 -36.85
Net Profit After Tax 9.10 22.53 36.80 68.44
Add: Depreciation 150.00 150.00 150.00 450.00
Add: Interest on Term Loan 36.00 25.33 13.38 74.71
(a) Cash (Earnings) available for repayment of Debt 195.10 197.87 200.18 593.15
(b) Annual Installment including interest 124.90 124.90 124.90 374.71
(c) DSCR (in times) (a) ÷ (b) 1.56 1.58 1.60 1.58
(d) ICR = (EBIT ÷ Interest) (in times) 1.39 2.37 5.23 2.41
Alternatively Cash (Earnings) available for repayment of Debt =
EBITDA - Prov for Tax 204.90 222.13 239.82
PV @12% 1
1–
0 1 PVAF = (1 + r)^n
1 0.892857143 1/(1+r)^n r
2 0.797193878
3 0.711780248 1
1–
Total 2.401831268 PVAF PVAF = (1 + .12)^3
0.12
PVAF = 2.40183
EMI = P x ROI x (1 + R) N
(1 + R) N - 1
Q.8.
I Current Ratio:
Total Current Assets ÷ Total Current Liabilities Cash 21,000 Provision for Tax 50,000
Current Assets 5,56,800 Debtors 3,00,425 Commission received in Advance 10,875
Current Liabilities 3,10,000 Prepaid Insurance 15,375 Bills Payable 49,125
Current Ratio 1.80 Stock 2,00,700 Bank Overdraft 10,740
Market Investments 19,300 Sundry Creditors 1,89,260
II Liquidity Ratio: 5,56,800 3,10,000
Quick Assets ÷ Quick Liabilities
Quick Assets 3,40,725 Cash 21,000 Provision for Tax 50,000
Quick Liabilities 2,88,385 Debtors 3,00,425 Bills Payable 49,125
Quick Ratio 1.18 Market Investments 19,300 Sundry Creditors 1,89,260
3,40,725 2,88,385
III Debt Equity Ratio:
Debt ÷ Equity (or) Borrowed Funds ÷ Owners Funds
Debt or Borrowed Funds 2,00,000 15% debentures 1,60,000 Capital Reserve 1,26,000
Equity or Owners Funds 14,41,800 12% Bank Loan 40,000 General Reserve 1,20,000
Debt Equity Ratio 0.14 2,00,000 6% Preference Share Capital 2,00,000
Equity Share Capital 10,00,000
Profit and Loss Account 9,000
Share Premium 15,000
Preliminary Expenses -18,625
Calls in Arrears -9,575
14,41,800
IV Capital Gearing Ratio:
Fixed Cost Bearing Funds ÷ Variable Cost Bearing Funds
Fixed Cost Bearing Funds 4,00,000 15% debentures 1,60,000 Shareholder Fund 14,41,800
Variable Cost Bearing Funds 12,41,800 12% Bank Loan 40,000 Less: 6% Pref Share Capital -2,00,000
Capital Gearing Ratio 0.32 6% Pref Share Capital 2,00,000 12,41,800
4,00,000
V Propietary Ratio:
Proprietors Funds ÷ Total Assets x 100 Shareholder Fund 14,41,800 Copyright 1,00,000
Proprietors Funds 14,41,800 14,41,800 Cash 21,000
Total Assets 19,51,800 Plant and Machinery 4,20,000
Propietary Ratio (%) 73.87 Debtors 3,00,425
Prepaid Insurance 15,375
Land and Building 5,00,000
Fixtures 25,000
Furniture 75,000
Goodwill 1,00,000
Investments (Long Term) 1,75,000
Stock 2,00,700
Market Investments 19,300
19,51,800
Ans.9.
2018 2019 Particulars 31.12.2018 31.12.2019
a) Net Profit Ratio 2.60% 5.33% Net profit after Depreciation 1,21,600 1,60,800
Net Profit After Taxes 26,000 64,000 Less:
Sales (Given) 10,00,000 12,00,000 Directors Remuneration 60,000 20,000
Interest on Mortgage Loan 9,600 8,800
Provision for Taxation 26,000 68,000
Net Profit After Taxes 26,000 64,000
Particulars 31.12.2018 31.12.2019
b) Current Ratio 1.03 1.35 Stock in Trade 1,20,000 60,000
Current Assets 2,84,000 2,00,000 Debtors 1,60,000 80,000
Current Liabilities 2,76,000 1,48,000 Cash & Bank 4,000 60,000
2,84,000 2,00,000
Bank Overdraft 40,000 -
Creditors 1,80,000 60,000
Provision for Taxation 26,000 68,000
Dividend Declared 30,000 20,000
2,76,000 1,48,000
c) Liquidity Ratio 0.69 0.95 Particulars 31.12.2018 31.12.2019
Quick Assets 1,64,000 1,40,000 Debtors 1,60,000 80,000
Quick Liabilities 2,36,000 1,48,000 Cash & Bank 4,000 60,000
1,64,000 1,40,000
Creditors 1,80,000 60,000
Provision for Taxation 26,000 68,000
Dividend Declared 30,000 20,000
2,36,000 1,48,000
d) Debt ÷ Equity Ratio 0.66 0.89 Particulars 31.12.2018 31.12.2019
Debt 1,60,000 2,20,000 Mortgage Loan 1,60,000 2,20,000
Equity 2,44,000 2,48,000 1,60,000 2,20,000
Equity Share of Rs. 10 each 2,00,000 2,00,000
General Reserve 40,000 20,000
Profit & Loss A/c 4,000 28,000
2,44,000 2,48,000
e) Interest Coverage Ratio Particulars 31.12.2018 31.12.2019
EBIT ÷ Interest 6.42 16 Net profit after Depreciation 1,21,600 1,60,800
EBIT 61,600 1,40,800 Less: Directors Remuneration 60,000 20,000
Interest 9,600 8,800 61,600 1,40,800
Interest on Mortgage Loan 9,600 8,800
9,600 8,800
f) Net Operating Profit Ratio 6.16 11.73 Particulars 31.12.2018 31.12.2019
Operating Profit 61,600 1,40,800 Net profit after Depreciation 1,21,600 1,60,800
Sales (Given) 10,00,000 12,00,000 Less: Directors Remuneration 60,000 20,000
Operating Profit 61,600 1,40,800
Ans.10. Working:
(i) Current Ratio 2.5:1 Debtors 4,50,000 Creditors 3,00,000
Current Assets 10,00,000 Advances to Suppliers 50,000 Bank Overdraft 1,00,000
Current Liabilities 4,00,000 Stock 4,00,000 Current Liabilities 4,00,000
Bank Balance 1,00,000
Current Assets 10,00,000
(iv) Net Profit Ratio (%) 5% Net Profit before tax 9,00,000
NPAT 4,50,000 Less: Tax @ 50% 4,50,000
Sales (given) 90,00,000 Net Profit after tax 4,50,000
(vii) Debtors Turnover Ratio 24 Times Closing Debtors including advances 5,00,000
Net Credit Sales (90% of sales) 81,00,000 Less: Advances 50,000
Average Debtors 3,37,500 Closing Debtors excluding advances 4,50,000
Opening Debtors 2,25,000
(vii) Debtors Collection Period Total = Opening + Closing 6,75,000
In number of days 15.21 Average Debtors 3,37,500
(365 days ÷ 24 times)
In number of months 0.5
(12 months ÷ 24 times)
Solution to Question 11 Sources of Funds
Share Capital (20000 Equity Shares of Rs. Share Capital (20,000 Equity Shares of Rs.
1,00,000 1,00,000
10 each of Rs. 5 called up) 10 each of Rs. 5 called up)
a) Debt / Equity Ratio 0.63 Land and Building 1,25,000 Reserves and Surplus:
Machinery 50,000 General Reserve 50,000
b) Proprietary Ratio (%) 56% Stock 50,000 Profit and Loss Account 15,000
Proprietors Funds 1,60,000 Reserves and Surplus: Less: Preliminary Expenses 5,000
Total Assets 2,85,000 General Reserve 50,000 Shareholder's Fund 1,60,000
Profit and Loss Account 15,000 Borrowed Funds
c) Current Ratio 3.40 5% Debentures 1,00,000 5% Debentures 1,00,000
Current Assets 85,000 Bills Payable 7,000 Borrowed Funds 1,00,000
Current Liabilities 25,000 Bills Receivable 5,000 Total Capital Employed 2,60,000
Furniture 25,000
d) Liquid Ratio 1.40 Debtors (less than 6 months) 11,000 Application of Funds
Quick Assets 35,000 Preliminary Expenses 5,000 Fixed Assets
Quick Liabilities 25,000 Creditors 18,000 Land and Building 1,25,000
Cash on Hand 2,000 Machinery 50,000
e) Stock to Working Capital Ratio 0.83 Bank Balance (Dr.) 18,000 Working Capital
Stock 50,000 Provision for Doubtful Debts 1,000 Current Assets
Working Capital 60,000 Quick Assets
[BR + (Debtors - Prov DD) + Cash + Bank] 35,000
Non Quick Assets 50,000
Total Current Assets 85,000
Current Liabilities
Quick Liabilities 25,000
Non Quick Liabilities -
Total Current Liabilities 25,000
WC = (CA-CL) 60,000
Ans.12.
1) Profitability: Declining profitability is evident from:
(a) Decreasing gross profit margin and increasing cost of goods sold ÷ sales ratio.
(b) Decreasing net profit margin and increasing operating expense ÷ sales ratio.
(c) Over the period of 3 years, gross profit margin has declined by 3% from 30% to 27% due to
increase in COGS. Net profit margin has declined from 7% to 2% due to increase in COGS by 3% and
operating expense by 3%.
2) Operating efficiency (Activity ratios):
(a) Decreasing Debtors Turnover Ratio and increasing Average Collection Period with falling
Profitability indicates poor Debtors management If there is rise in bad-debts.
(b) Higher Average Collection Period also results in loss of opportunity cost due to additional funds
block in receivables.
3) Lower Stock Turnover Ratio and higher Stock holding period:
(a) Consistent increase in current ratio with consistent decrease in Quick Ratio shows that the levels
of inventory has been rising. This is also evident from rising stock to working after ratio. The reasons
for increasing inventory needs to be enquired into. If the product has become slow moving or
outdated then it might further affect the Profitability and liquidity negatively.
(b) Increase in Debtors and Inventory indicates excessive investment in current assets which seems
to be affecting rate of return.
4) Liquidity:
(a) Short term liquidity has improved which is evident from increasing current ratio.
(b) Immediate liquidity has been declining due to increase in inventory. However, at present it is at
comfortable level (Quick ration = 0.99:1) and the company is unlikely to encounter any serious
difficulty in paying short term obligation as and when they become due for payment.
(c) However, to avoid any liquidity crisis the company needs to maintain the ratio of current levels
and prevent any further decline.
5) Capex or Diversification plans: Investment in fixed assets seems to be higher relative to net
worth. This needs me further investigated to determine the capex plans. If there is any capital WIP
which might generate additional revenue and Profitability in future or the company is investing in
modern technology to achieve economies of scale and reduce COGS.
6) Dividend policy: The company seems to follow stable dividend policy which will have positive
impact on its market price. Even though the company has low EPS of Rs. 2.5 per share, it has paid
dividend of Rs 3 per share out of its past accumulated profits.
Conclusion: The firm’s financial position has not become so bad that it cannot be cured what is
required is thorough probe into the over investment in working capital and fixed assets.
Q.13.
(1)
There is no Bank overdraft.
Pre-paid expenses and Incomes received in advance is assumed to be Nil.
Current Ratio = Current Assets (CA) = 4.5
Current Liabilities (CL) 1
(2)
There is no Bank overdraft.
Incomes received in advance is assumed to be Nil.
Quick Ratio = Quick Assets = 3
Current Liabilities 1
Current Liabilities = Rs. 10,00,000 (given)
Quick Assets = Rs. 30,00,000
Current Assets = Quick Assets + Inventory + Prepaid expenses
Current Assets = Rs. 30,00,000 + Rs. 5,00,000 + Nil
Current Assets = Rs. 35,00,000
Current Ratio = Current Assets (CA) = 35,00,000
Current Liabilities (CL) 10,00,000
Current Ratio = 3.5:1
(3)
There is no Bank overdraft.
Incomes received in advance is assumed to be Nil.
Quick Ratio = Quick Assets = 2
Current Liabilities 1
Rs. 24,00,000 = 2 x Current Liabilities
Current Liabilities = Rs. 12,00,000
Current Assets (CA) = Quick Assets + Non-Quick Assets
Current Assets (CA) = Rs. 30,00,000
(5)
COGS = Rs. 8,00,000
GP Ratio = 20%
Sales = COGS + Gross Profit
Gross Profit = Rs. 2,00,000
Sales = Rs. 10,00,000
4 months = 1 X 12 months
Debtors Turnover Ratio
Debtors Turnover Ratio = 3 = Sales
Debtors
Net credit Sales = Sales
Average Debtors = ?
3 = 10,00,000
Debtors
Debtors = Rs. 3,33,333
(6)
Fixed Assets = 0.75:1
Shareholder's Funds
Shareholder's Funds = Rs. 15,00,000 X
0.75X + 5,00,000 = X
5,00,000 = 0.25X
X = 20,00,000
(7)
Shareholder's Funds = 20,00,000
Reserves & Surplus 0.25X
Share Capital X
0.25X + X = 20,00,000
1.25X = 20,00,000
X = 16,00,000
Share Capital = 16,00,000
Reserves & Surplus = 4,00,000
(0.25 of 16,00,000)
(8)
10% Debentures = Rs. 10,000
Return on Net worth (Return on equity) = 5%
Net Profit after Tax = 20,000
ROE = NPAT
Shareholders Fund
(2)
Quick Ratio = 1.5 = Current Assets (-) Inventory
Current Liabilities
(3)
Stock Turnover Ratio = COGS
Inventory
5 times = COGS
Rs. 4,00,000
(4)
Gross Profit Ratio = Gross Profit x 100
Net Sales
= 20%
If Sales = X, Gross Profit = 0.2X
COGS = 0.8X
0.8X = Rs. 20,00,000
X = Rs. 25,00,000
Sales = Rs. 25,00,000
(5)
2 times = COGS
Fixed Assets
Rs. 20,00,000 = 2 X Fixed Assets
Fixed Assets = Rs. 10,00,000
(6)
Average Collection Period = 12 months
Debtors Turnover Ratio
2.4 Months = 12
Debtors Turnover Ratio
(8)
Long Term Debt = 7
Shareholder's Fund = 25
Vertical Balancesheet
Sources of Funds
Shareholder's Fund 12,50,000
Long Term Debt 3,50,000
Total 16,00,000
Application of Funds
Fixed Assets 10,00,000
Working Capital 6,00,000
Current Assets = 10,00,000
Current Liabilities = 4,00,000
Total 16,00,000
Q.15.
(1)
There is no cash sales.
Gross Profit Ratio = 25%
= Gross Profit = 0.25
Net Sales
Gross Profit = 0.25 x Rs. 6,00,000
Gross Profit = Rs. 1,50,000
Sales (-) Gross Profit = COGS
COGS = Rs. 4,50,000
(2)
Average Collection Period = 12 months
Debtors Turnover Ratio
1.5 Months = 12
Debtors Turnover Ratio
Debtors Turnover Ratio = 8 Times
8 Times = Net Credit Sales
Debtors
8 Times = Rs. 6,00,000
Debtors
Debtors = Rs. 75,000
(3)
Stock Turnover Ratio = 9 Times
Stock Turnover Ratio = COGS
Closing Stock
Rs. 4,50,000 = 9 x Closing Stock
(4)
1.2 = COGS
Fixed Assets
1.2 = Rs. 4,50,000
Fixed Assets
Fixed Assets = Rs. 4,50,000
1.2
Fixed Assets = Rs. 3,75,000
(5)
Fixed Assets = 1.25 = Rs. 3,75,000
Shareholders Fund 1 1
Shareholders Fund = Rs. 3,00,000
Reserves & Surplus = 0.20
Share Capital 1
0.20X + X = Rs. 3,00,000
1.20X = Rs. 3,00,000
X = Rs. 2,50,000
Share Capital = Rs. 2,50,000
Reserves & Surplus = 0.2 x Rs. 2,50,000
Reserves & Surplus = Rs. 50,000
Capital Gearing Ratio = 0.6 Times
0.6 = Borrowed Funds
Share Capital
0.6 = Borrowed Funds
Rs. 2,50,000
Borrowed Funds = Rs. 1,50,000
(6)
Current Ratio = 1.75:1
Current Ratio = Current Assets
Current Liabilities
Current Assets = 1.75 Current Liabilities
Quick Ratio = 1.25:1
Quick Ratio = Quick Assets
Current Liabilities
Vertical Balancesheet
Sources of Funds
Shareholder's Fund 3,00,000
Share Capital = 2,50,000
Reserves & Surplus = 50,000
Borrowed Fund 1,50,000
Total 4,50,000
Application of Funds
Fixed Assets 3,75,000
Working Capital 75,000
Current Assets = 1,75,000
Current Liabilities = 1,00,000
Total 4,50,000
Q.16.
(1)
Working Capital = Rs. 33,000
Working Capital Ratio = Current Ratio = Current Assets = 1.75 times
Current Liabilities
Working Capital = Current Assets (-) Current Liabilities
Current Assets = 1.75 Current Liabilities
Working Capital = Current Assets (-) Current Liabilities
Rs. 33,000 = 1.75 Current Liabilities (-) Current Liabilities
Current Liabilities = Rs. 44,000
Current Assets = 1.75 x Rs. 44,000
Current Assets = Rs. 77,000
(2)
Earnings Per Share = Net Profit after Tax
No. of Equity Shares
0.50 = Net Profit after Tax
26,000 shares
Net Profit after Tax = Rs. 13,000
(3)
0.625 = Fixed Assets Sources of Funds
(given) Shareholders Fund (X) Shareholders Fund X
Borrowed Funds Nil
Fixed Assets = 0.625X Total X
Shareholders Fund = Fixed Assets + Working Capital Application of Funds
X = 0.625X + Rs. 33,000 Fixed Assets ?
X = Rs. 88,000 Investments Nil
Shareholders Fund = Rs. 88,000 Working Capital 33,000
Shareholders Fund = Share Capital + Reserves & Surplus Total X
Rs. 88,000 = Rs. 52,000 + Reserves & Surplus
Reserves & Surplus = Rs. 36,000
(4)
Average Collection Period = 365 Days
Debtors Turnover Ratio
73 Days = 365 Days
Debtors Turnover Ratio
Debtors Turnover Ratio = 5 Times
(5)
Quick Ratio = 1.27 = Current Assets (-) Inventory
Current Liabilities
Quick Ratio = 1.27 = Rs. 77,000 (-) Inventory
Rs. 44,000
55,880 = Rs. 77,000 (-) Inventory
Inventory = Rs. 21,120
(6)
Stock Turnover Ratio = 4 Times
Stock Turnover Ratio = COGS
Closing Stock
4 Times = COGS
Rs. 21,120
COGS = 4 x Rs. 21,120
COGS = Rs. 84,480
(7)
Sales (-) COGS = Gross Profit Sales 1,40,800
Gross Profit Ratio = 40% COGS 84,480
If Sales = X, Gross Profit = 0.4X Gross Profit 56,320
X (-) 84,480 = 0.4X (-) Operating exp. & Tax 43,320
X = 1,40,800 NPAT 13,000
Sales = Rs. 1,40,800