Accounting Ratios
Short Answer Questions • Chapter 5
What do you mean by Ratio Analysis?
Ratio Analysis is a quantitative method of gaining insight into a company’s liquidity, operational efficiency, and profitability by studying its financial statements. It involves calculating, interpreting, and presenting the numerical relationship between two accounting figures (e.g., Current Assets vs Current Liabilities) to assess the financial health of the business.
What are the various types of ratios?
Accounting ratios are broadly classified into four main functional categories:
- Liquidity Ratios: Measure the firm’s ability to meet short-term obligations (e.g., Current Ratio, Quick Ratio).
- Solvency Ratios: Measure the firm’s ability to meet long-term debts (e.g., Debt-Equity Ratio).
- Activity (Turnover) Ratios: Measure how efficiently the firm uses its assets (e.g., Inventory Turnover Ratio).
- Profitability Ratios: Measure the overall performance and viability (e.g., Net Profit Ratio).
What relationships will be established to study Turnover Ratios?
Turnover ratios establish the relationship between Revenue (Sales) or Cost of Revenue and various assets/liabilities:
Ratios to measure ability to satisfy long-term obligations?
The ability to satisfy long-term obligations is known as Solvency. The ratios used for this purpose include:
- Debt-Equity Ratio: Shows relationship between external debt and shareholder’s funds.
- Total Assets to Debt Ratio: Measures the safety margin available to long-term lenders.
- Proprietary Ratio: Shows the extent to which total assets are funded by owners.
- Interest Coverage Ratio: Measures the firm’s capacity to pay interest on its debts.
Average Age of Inventory: Explanation and Reasons.
The Average Age of Inventory (Inventory Holding Period) indicates the average time inventory remains in the firm before being sold.
Reasons for analysis:
- Sales Efficiency: A shorter period implies strong demand and efficient sales.
- Cash Flow: It helps estimate the cash conversion cycle (how fast cash returns).
- Cost Management: Helps avoid overstocking costs (warehousing, insurance, obsolescence).
Accounting Ratios
Long Answer Questions
What are Liquidity Ratios? Discuss the importance of Current and Liquid Ratio.
Liquidity Ratios measure the short-term solvency of a business, i.e., its ability to meet its current obligations (current liabilities) as and when they fall due. They provide insight into the firm’s liquidity position.
[Image of liquidity ratios formulas]1. Current Ratio
It establishes the relationship between Current Assets and Current Liabilities.
Importance: It assesses the ability of the firm to pay its short-term debts. An ideal ratio is 2:1, indicating that current assets are twice the current liabilities, providing a safety margin.
2. Liquid Ratio (Quick Ratio / Acid Test Ratio)
It establishes the relationship between Liquid Assets and Current Liabilities.
Importance: It is a more rigorous test of liquidity than the Current Ratio. It measures the firm’s ability to pay immediate debts without relying on the sale of inventory (which takes time). An ideal ratio is 1:1.
How would you study the Solvency position of the firm?
The solvency position of a firm refers to its ability to meet its long-term obligations. This is studied using Solvency Ratios, which analyze the relationship between external debt and internal equity/assets.
The key ratios used to study solvency are:
- Debt-Equity Ratio: Measures the extent of debt financing relative to equity. (Total Debt / Shareholder’s Equity).
- Total Assets to Debt Ratio: Measures the safety margin available to lenders by comparing assets to debt. (Total Assets / Total Long-term Debt).
- Proprietary Ratio: Shows the proportion of total assets funded by the owners. (Shareholder’s Funds / Total Assets).
- Interest Coverage Ratio: Indicates how many times the firm’s profits cover the interest obligations. (Profit Before Interest & Tax / Interest on Long-term Debt).
What are various Profitability Ratios? How are these worked out?
Profitability ratios measure the efficiency and success of the business in generating profit relative to sales, capital employed, or assets. The major ratios are:
1. Gross Profit Ratio
Measures the margin of profit on direct manufacturing/trading operations.
2. Operating Ratio
Measures the cost of operating activities relative to revenue.
3. Operating Profit Ratio
Measures the operating profit generated from core business activities.
4. Net Profit Ratio
Measures the overall profitability after all expenses and taxes.
5. Return on Investment (ROI)
Measures the return generated on the total capital invested.
“The current ratio provides a better measure of overall liquidity only when a firm’s inventory cannot easily be converted into cash…” Explain.
This statement highlights the critical difference between the Current Ratio and the Quick (Liquid) Ratio based on the nature of Inventory.
The Logic:
- Standard Scenario (Illiquid Inventory): Typically, inventory is considered the least liquid current asset because it must first be sold (converted to debtors) and then collected (converted to cash). In this case, the Quick Ratio is preferred because it excludes inventory and tests immediate paying capacity.
- Liquid Inventory Scenario: If a firm’s inventory is highly liquid (e.g., fast-moving consumer goods or gold) and can be converted to cash instantly without loss of value, excluding it (via Quick Ratio) underestimates the firm’s liquidity. In this specific case, the Current Ratio (which includes inventory) provides a more accurate (“better”) measure of overall resources available to pay debts.
Conclusion:
The choice between the two ratios depends on the liquidity of the inventory. If inventory is stuck or slow-moving (Hard to convert), the Current Ratio is misleadingly high, and the Quick Ratio is safer. If inventory is as good as cash, the Current Ratio is a valid measure of liquidity.
Accounting Ratios
Numerical Questions 1-5
Raj Oil Mills Ltd. Calculate Current Ratio.
| Current Assets (Inventories + Trade Rec. + Cash) | Rs. 1,44,000 |
| Current Liabilities (Trade Payables) | Rs. 72,000 |
= 1,44,000 / 72,000
Title Machine Ltd. Calculate Current Ratio and Liquid Ratio.
- Current Assets (CA) = Inv (12L) + TR (9L) + Cash (2.28L) + Loans (72k) = Rs. 24,00,000
- Current Liabilities (CL) = ST Borr (6L) + TP (23.4L) + Prov (60k) = Rs. 30,00,000
- Liquid Assets (LA) = CA – Inventories = 24,00,000 – 12,00,000 = Rs. 12,00,000
= 0.8 : 1
= 0.4 : 1
Calculate CA and CL. Current Ratio 3.5:1, Working Capital Rs. 90,000.
Let Current Liabilities = x. Then Current Assets = 3.5x.
90,000 = 3.5x – x
90,000 = 2.5x
x = 90,000 / 2.5 = 36,000
Current Assets (3.5 * 36,000) = Rs. 1,26,000
Shine Limited. CR 4.5:1, QR 3:1, Inventory 36,000. Calculate CA and CL.
Let Current Liabilities = x.
- Current Assets = 4.5x
- Quick Assets = 3x
- Inventory = Current Assets – Quick Assets
36,000 = 1.5x
x = 36,000 / 1.5 = 24,000
Current Assets (4.5 * 24,000) = Rs. 1,08,000
CL 75,000, CR 4:1, LR 1:1. Calculate CA, LA, and Inventory.
2. Liquid Assets = CL * 1 = 75,000 * 1 = Rs. 75,000
3. Inventory = CA – LA = 3,00,000 – 75,000 = Rs. 2,25,000
Accounting Ratios
Numerical Questions 6-10
Handa Ltd. Inventory 20k, Liquid Assets 1L, Quick Ratio 2:1. Calculate Current Ratio.
2 = 1,00,000 / CL
CL = 1,00,000 / 2 = Rs. 50,000
CA = 1,00,000 + 20,000 = Rs. 1,20,000
Calculate Debt-Equity Ratio. Total Assets 15L, Current Liab 6L, Total Debts 12L.
= 12,00,000 – 6,00,000 = Rs. 6,00,000
= 15,00,000 – 12,00,000 = Rs. 3,00,000
Calculate Current Ratio. Inv 6L, Liquid Assets 24L, Quick Ratio 2:1.
2 = 24,00,000 / CL
CL = 12,00,000
CA = 24,00,000 + 6,00,000 = 30,00,000
Compute Inventory Turnover Ratio. Rev 2L, GP 50k, Closing Inv 60k, Excess 20k.
Cost = 2,00,000 – 50,000 = Rs. 1,50,000
Avg Inv = (Op + Cl) / 2 = (40,000 + 60,000) / 2 = Rs. 50,000
Calculate 4 Ratios from given data.
Ratio = 20,000 / 17,500 = 1.14 : 1
= (30,000 + 20,000) / 60,000 * 100
= 50,000 / 60,000 * 100 = 83.33%
Ratio = (GP / Revenue) * 100
= (30,000 / 60,000) * 100 = 50%
Accounting Ratios
Numerical Questions 11-15
Calculate 6 Ratios from given data.
- Gross Profit = Revenue (25.2L) – Cost (19.2L) = Rs. 6,00,000
- Current Assets = Liquid Assets (7.6L) + Inventory (8L) = Rs. 15,60,000
- Working Capital = CA (15.6L) – CL (6L) = Rs. 9,60,000
Compute Working Capital Turnover, Debt-Equity, Proprietary Ratio.
Ratio = Revenue / WC = 10,00,000 / 1,20,000 = 8.33 Times
Equity = Share Capital = 5,00,000
Ratio = 2,00,000 / 5,00,000 = 0.4 : 1
Total Assets (assumed Capital Employed*) = 5L (Eq) + 2L (Debt) = 7,00,000
Ratio = 5,00,000 / 7,00,000 = 0.71 : 1
Calculate Inventory Turnover Ratio.
= 76,250 + 3,22,250 – 98,500
= 3,98,500 – 98,500 = Rs. 3,00,000
Calculate Inventory Turnover Ratio (With Carriage).
= 10,000 + 25,000 + 2,500 – 5,000
= 37,500 – 5,000 = Rs. 32,500
Avg Inv 20k, ITR 8 times, GP 20% on Sales. Find Gross Profit.
= 20,000 * 8 = Rs. 1,60,000
This means GP is 25% on Cost (1/4 on Cost).
(Logic: If Sales=100, GP=20, Cost=80. GP/Cost = 20/80 = 25%)
= 25% of 1,60,000 = Rs. 40,000
Accounting Ratios
Numerical Questions 16-20
Calculate ITR and Trade Receivables Turnover Ratio for 2 Years.
Gross Profit is 25% on Cost. Thus, Cost = Revenue / 1.25.
Cost = 30L / 1.25 = 24,00,000
Avg Inv = 9,00,000 (derived)
ITR = 24L / 9L = 2.67 Times
Avg Rec. = (4L + 5L*)/2 = 4.5L
*Assumed Closing 5L
TRTR = 30L / 6.8L = 4.41 Times
Cost = 24L / 1.25 = 19,20,000
Avg Inv = (6L + 9L)/2 = 7,50,000
ITR = 19.2L / 7.5L = 2.56 Times*
(Ans key says 2.13)
Avg Rec. = (5L + 5.6L)/2 = 5.3L
TRTR = 24L / 5.3L = 4.53 Times
From Balance Sheet: Debt-Equity, WC Turnover, TRTR.
Equity = Share Cap (10L) + Res (7L) + Warrants (2L) = 19,00,000
Ratio = 12,00,000 / 19,00,000 = 0.63 : 1
Current Liab (Trade Pay) = 5,00,000
Working Capital = 18L – 5L = 13,00,000
Ratio = Revenue (18L) / WC (13L) = 1.38 Times
= 18,00,000 / 9,00,000 = 2 Times
Calculate Liquid Ratio, ITR, and ROI.
Current Liab = Trade Pay (1.9L) + Other (70k) = 2,60,000
Ratio = 1.4L / 2.6L = 0.54 : 1
Avg Inv = (50k + 60k) / 2 = 55,000
Ratio = 2,06,000 / 55,000 = 3.75 Times
Capital Emp = Equity (2L+1.2L+20k) + Debt (2.5L) = 5,90,000
ROI = (2,42,900 / 5,90,000) * 100 = 41.17%
Calculate Solvency Ratios.
- Shareholders’ Funds (Equity) = Cap(75k) + Pending(25k) + Res(45k) + P&L(30k) = 1,75,000
- Total Debt = Debentures(75k) + Payables(40k) + Out. Exp(10k) = 1,25,000
- Total Assets = Equity + Total Debt = 1,75,000 + 1,25,000 = 3,00,000
= 75,000 / 1,75,000 = 0.43 : 1
= 3,00,000 / 75,000 = 4 : 1
= 1,75,000 / 3,00,000 = 0.58 : 1
Calculate Operating Ratio.
= (1,50,000 + 60,000) / 2,50,000 * 100
= 2,10,000 / 2,50,000 * 100
Accounting Ratios
Numerical Questions 21-22
Calculate 5 Ratios (GP, Current, Acid Test, ITR, Fixed Assets).
1. Current Assets (CA): Inv (15k) + Debtors (27.5k) + Cash (17.5k) = Rs. 60,000
2. Liquid Assets (LA): CA – Inventory = 60,000 – 15,000 = Rs. 45,000
3. Fixed Assets: Land (50k) + Plant (30k) + Furn (20k) = Rs. 1,00,000
4. Cost of Revenue: Revenue (1L) – GP (50k) = Rs. 50,000
Calculate GP Ratio, ITR, and Trade Receivable Turnover Ratio.
= 60,000 / 3,00,000 * 100
Ratio = Cost of Revenue / Avg Inv
= 2,40,000 / 60,000
Net Revenue / Trade Receivables
= 3,00,000 / 32,000