PQR Limited has the following Balance Sheets as on March 31, 2026 and March 31, 2025: Balance Sheet ₹ in lakhs March 31, 2026 March 31, 2025 Sources…
CA Intermediate · Financial Management and Strategic Management · MTP · May 2026
PQR Limited has the following Balance Sheets as on March 31, 2026 and March 31, 2025: Balance Sheet ₹ in lakhs March 31, 2026 March 31, 2025 Sources of Funds: Shareholders Funds 2,377 1,472 Loan Funds 3,570 3,083 5,947 4,555 Applications of Funds: Fixed Assets 3,466 2,900 Cash and bank 489 470 Debtors 1,495 1,168 Stock 2,867 2,407 Other Current Assets 1,567 1,404 Less: Current Liabilities (3,937) (3,794) 5,947 4,555 The Income Statement of the PQR Ltd. for the year ended is as follows: ₹ in lakhs March 31, 2026 March 31, 2025 Sales 22,165 13,882 Less: Cost of Goods sold 20,860 12,544 Gross Profit 1,305 1,338 Less: Selling, General and Administrative expenses 1,135 752 Earnings before Interest and Tax (EBIT) 170 586 Interest Expense 113 105 Profits before Tax 57 481 Tax 23 192 Profits after Tax (PAT) 34 289 CALCULATE for the year 2025-26: (i) Inventory turnover ratio (ii) Financial Leverage (iii) Return on Capital Employed (ROCE) (iv) Return on Equity (ROE) (v) Average Collection period. Take 365 days in a year
Suggested Answer and Working Notes:
Ratios for the year 2025-2026 (i) Inventory turnover ratio = COGS / Average Inventory = 20,860 / ((2,867 + 2,407) / 2) = 7.91 (ii) Financial leverage 2025-26 2024-25 EBIT 170 586 EBIT - I 57 481 = 2.98 = 1.22 (iii) ROCE = EBIT (1-t) / Average Capital Employed = 57 (1-0.4) / ((5,947 + 4,555) / 2) = 34.2 / 5251 x 100 = 0.651% [Here Return on Capital Employed (ROCE) is calculated after Tax] (iv) ROE = Profits after tax / Average shareholders' funds = 34 / ((2,377 + 1,472) / 2) = 34 / 1,924.5 = 1.77% (v) Average Collection Period* Average Sales per day = 22,165 / 365 = 60.73 lakhs Average collection period = Average Debtors / Average sales per day = ((1,495 + 1,168) / 2) / 60.73 = 1331.5 / 60.73 = 22 days
Topics: Part-A: Financial Management
Related Questions in this Topic
- Distinguish between Strategic Planning and Operational Planning.
- Cura-Stents India Ltd., a manufacturer of high-precision cardiac stents, follows stringent international quality and ste...
- EcoBuild Materials Ltd. manufactures specialised construction materials. One of its business divisions has been evaluate...
- Elite Motors Ltd., a luxury automobile manufacturer, exclusively targets ultra-high-net-worth individuals by offering pr...
- Write a short note on the key strategic drivers of an organization.