EOC Ltd is a listed company and has presented the below abridged financial statements below. Statement of Profit and Loss ₹ ₹ Sales 1,25,00,000 Cost…
CA Intermediate · Financial Management and Strategic Management · MTP · May 2024
EOC Ltd is a listed company and has presented the below abridged financial statements below. Statement of Profit and Loss ₹ ₹ Sales 1,25,00,000 Cost of goods sold (76,40,000) Gross Profit 48,60,000 Less: Operating Expenses Administrative Expenses 13,20,000 Selling and Distribution Expenses 15,90,000 (29,10,000) Operating Profit 19,50,000 Add: Non-Operating Income 3,28,000 Less: Non Operating Expenses (1,27,000) Profit before Interest and taxes 21,51,000 Less: Interest (4,39,000) Profit before tax 17,12,000 Less: Taxes (4,28,000) Profit after Tax 12,84,000 Balance Sheet Sources of Funds ₹ ₹ Owned Funds Equity Share Capital 30,00,000 Reserves and Surplus 18,00,000 48,00,000 Borrowed Funds Secured Loan 10,00,000 Unsecured Loan 4,30,000 14,30,000 Total Funds Raised 62,30,000 Application of Funds Non-Current Assets Building 7,50,000 Machinery 2,30,000 Furniture 7,60,000 Intangible Assets 50,000 17,90,000 Current Assets Inventory 38,60,000 Receivables 39,97,000 ST investments 3,00,000 Cash and Bank 2,30,000 83,87,000 Less: Current Liabilities Creditors 25,67,000 ST loans 13,80,000 (39,47,000) Total Funds Employed 62,30,000 The company has set certain standards for the upcoming year financial status. All the ratios are based on closing figures in financial statements. Equity SC to Reserves= 1 Net Profit Ratio= 15% Gross Profit Ratio= 50% Long Term Debt to Equity= 0.5 Debtor Turnover= 100 Days Creditor Turnover (based on COGS)= 100 Days Inventory= 70% of Opening inventory Cash Balance is assumed to remain same for next year You are required to - (1) CALCULATE inventory turnover ratio in days for current year (2) CALCULATE receivables turnover ratio in days for current year (3) CALCULATE the projected receivables, inventory, payables and long term debt
Suggested Answer and Working Notes:
Inventory Turnover = (Inventory / COGS) x 365 = (38,60,000 / 76,40,000) x 365 = 184.41 days = 185 days (apx) Receivables Turnover = (Receivables / Sales) x 365 = (39,97,000 / 1,25,00,000) x 365 = 116.71 days (apx) Equity to Reserves = 1 Reserves = 1 x 30,00,000 = 30,00,000 Projected profit = 30,00,000 - 18,00,000 = 12,00,000 Net Profit Margin = 15% 12,00,000 / Sales = 0.15 Sales = 80,00,000 Gross Profit = 80,00,000 x 50% = 40,00,000 COGS = 80,00,000 - 40,00,000 = 40,00,000 Projected Debtors Turnover = 100 days = (Closing Receivables / Sales) x 365 100 = (Closing Receivables / 80,00,000) x 365 Closing Receivables = (80,00,000 x 100) / 365 = 21,91,781 Projected Closing Inventory = 70% of opening inventory = 70% of 38,60,000 = 27,02,000 Projected Creditor Turnover = 100 days = (Closing Creditors / COGS) x 365 Closing Creditors = (COGS / 365) x 100 Closing Creditor = (40,00,000 / 365) x 100 = 10,95,890 Equity Share Capital + Reserves = 30,00,000 + 30,00,000 = 60,00,000 Long Term Debt to Equity = 0.5 LTD / 60,00,000 = 0.5 Long Term Debt = 0.5 x 60,00,000 Long Term Debt = 30,00,000
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.