Ch 10: FORECASTING FINANCIAL STATEMENTS — V1: Direct Practical & Computation Tables
CS Executive
📚 Corporate Accounting & Financial Management
📖 Ch.10 — FORECASTING FINANCIAL STATEMENTS
⭐ V1: Previous Year Question (PYQ)
⚡ Free Mode (Answers Locked)
⏱ Duration: 90 Mins
🎯 Total Marks: 50
Passed at: 20 Marks
Max Attempts: 10
⚖️ Statutory Applicability: Applicable for ICSI CS Executive Examinations (December 2026 Attempt - Syllabus 2022)
Exhaustive ICSI CS Executive Test Series with 4-Tier Rubrics, Statutory Analysis, and Real-world Corporate Problem Scenarios.
📑 Exam Questions
5 Questions • Total 50 MarksQuestion 1: PRACTICAL NUMERICAL: Percentage of Sales Method for financial forecasting.
10 Marks
📌 Companies Act, 2013 sections 77 and 179 compliance for debt creation and board approval.
From the following Balance Sheet of M/s Omega Ltd. as at 31st March, 2024 and the related operational data, prepare a Pro Forma Balance Sheet as at 31st March, 2025 using the Percentage of Sales Method, assuming a projected 20% increase in sales for the financial year 2024-25.
### Balance Sheet as at 31st March, 2024
| Liabilities | Amount (₹) | Assets | Amount (₹) |
|---|---|---|---|
| Equity Share Capital (₹10 each) | 10,00,000 | Fixed Assets (Net) | 12,00,000 |
| General Reserve | 3,00,000 | Inventory | 4,00,000 |
| Profit & Loss Account | 2,00,000 | Accounts Receivable | 3,00,000 |
| 10% Debentures | 5,00,000 | Cash and Bank Balance | 1,00,000 |
| Accounts Payable | 3,00,000 | | |
| Outstanding Expenses | 2,00,000 | | |
| **Total** | **25,00,000** | **Total** | **25,00,000** |
### Additional Information:
1. Sales for the year ended 31st March, 2024 were ₹20,00,000.
2. The firm operates at full capacity. Therefore, fixed assets and spontaneous current assets/liabilities vary directly with sales.
3. Net Profit Margin for the year 2024-25 is projected at 10% on projected sales.
4. The company intends to maintain a dividend payout ratio of 40% of the projected net profit.
5. Any external financing requirement (balancing figure) will be raised through the issue of 12% Bank Term Loans.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 2: PRACTICAL NUMERICAL: Calculation of External Financing Needed (EFN) formula with projected sales growth, dividend payout, and retention ratio.
10 Marks
📌 Compliance with Companies Act 2013 provisions for capital alteration and SEBI guidelines for fund raising.
Alpha Ltd. presents its summarized Balance Sheet as at 31st March, 2023, and Income Statement for the year ended 31st March, 2023. The company is evaluating its External Financing Needed (EFN) for the upcoming financial year 2023-24 based on projected sales growth, maintaining its current operational ratios, and managing its dividend payout policy. You are required to calculate the EFN and provide an exhaustive, step-by-step ICSI-compliant model solution including journal entries for any fund-raising adjustments and detailed working notes.
Table 1: Balance Sheet Extract of Alpha Ltd. as at 31st March, 2023
| Liabilities & Equity | Amount (₹ in Lakhs) | Assets | Amount (₹ in Lakhs) |
| :--- | :--- | :--- | :--- |
| Equity Share Capital (₹10 each) | 5,000 | Net Fixed Assets | 8,000 |
| General Reserves & Surplus | 3,000 | Inventories | 2,500 |
| 10% Long-Term Debentures | 2,000 | Accounts Receivable | 1,500 |
| Accounts Payable | 1,200 | Cash and Bank Balances | 500 |
| Accrued Expenses | 800 | | |
| **Total Liabilities & Equity** | **12,000** | **Total Assets** | **12,000** |
Table 2: Income Statement Extract & Operating Parameters for the Year Ended 31st March, 2023
| Particulars | Financial Metric / Value |
| :--- | :--- |
| Total Sales (S_0) | ₹15,000 Lakhs |
| Cost of Goods Sold & Operating Expenses (Excluding Depreciation) | ₹11,250 Lakhs |
| Depreciation | ₹750 Lakhs |
| Earnings Before Interest and Tax (EBIT) | ₹3,000 Lakhs |
| Interest on 10% Debentures | ₹200 Lakhs |
| Earnings Before Tax (EBT) | ₹2,800 Lakhs |
| Provision for Tax (at 30%) | ₹840 Lakhs |
| Earnings After Tax (EAT / Net Income) | ₹1,960 Lakhs |
| Dividends Paid (D_0) | ₹784 Lakhs |
| Projected Sales Growth Rate (g) | 20% |
| Spontaneous Asset and Liability Relationship | Assets and spontaneous liabilities vary directly with Sales |
| Target Dividend Payout Ratio | 40% |
| Addition to Retained Earnings Ratio (Retention Ratio, b) | 60% |
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 3: Preparation of Projected Statement of Profit and Loss and Projected Balance Sheet.
10 Marks
📌 Compliance with Schedule III of the Companies Act, 2013 and applicable Accounting Standards for financial forecasting.
Alpha Limited provides you with the following financial data for the year ended 31st March 2024 and projected parameters for the year ending 31st March 2025. You are required to prepare the Projected Statement of Profit and Loss and the Projected Balance Sheet as at 31st March 2025 in accordance with Schedule III of the Companies Act, 2013.
### Balance Sheet as at 31st March 2024
| Liabilities | Amount (₹ in Lakhs) | Assets | Amount (₹ in Lakhs) |
|---|---|---|---|
| Equity Share Capital (₹10 each) | 500.00 | Property, Plant & Equipment (Gross) | 600.00 |
| General Reserve | 150.00 | Less: Accumulated Depreciation | (150.00) |
| Retained Earnings | 100.00 | Current Assets: | |
| 10% Long-term Debt | 200.00 | - Inventories | 120.00 |
| Current Liabilities: | | - Trade Receivables | 180.00 |
| - Trade Payables | 90.00 | - Cash and Cash Equivalents | 50.00 |
| - Outstanding Expenses | 10.00 | | |
| **Total** | **1,050.00** | **Total** | **1,050.00** |
### Projected Parameters for 2024-25:
1. Revenue from Operations is expected to increase by 20% over the previous year's revenue of ₹800.00 Lakhs.
2. Cost of Materials Consumed is expected to remain at 50% of Revenue from Operations.
3. Employee Benefit Expenses are projected at ₹120.00 Lakhs, including a 10% inflationary increase.
4. Other Expenses are estimated at 10% of Revenue from Operations.
5. Depreciation is to be charged at 15% on the closing Gross Block of Property, Plant & Equipment. A new machinery costing ₹100.00 Lakhs is to be purchased on 1st October 2024.
6. Finance Costs on 10% Long-term Debt will be paid regularly. Assume no repayment or fresh borrowing of long-term debt.
7. Tax Rate is 30%.
8. Dividend of 12% on Equity Share Capital is proposed to be paid for the year.
9. Current Assets and Current Liabilities relationship with Revenue:
- Inventories: Maintain 60 days of Cost of Goods Sold (COGS) (Assume 360 days a year).
- Trade Receivables: Maintain 45 days of Revenue from Operations.
- Trade Payables: Maintain 30 days of Material Consumption.
- Outstanding Expenses: Estimated at ₹12.00 Lakhs.
- Cash and Cash Equivalents: Balancing figure.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 4: Comprehensive review of key exam provisions of FORECASTING FINANCIAL STATEMENTS (Part 4)
10 Marks
📌 Companies Act, 2013 compliance regarding capital alteration and debt limits.
Alpha Limited presents its financial position for the year ended 31st March, 2024, and requests you to forecast its financial statements for the year ending 31st March, 2025, using the Percentage of Sales (EOS) method. Review the given financial data and projected parameters to prepare the Pro Forma Balance Sheet and calculate the External Financing Needed (EFN).
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Question 5: Comprehensive review of key exam provisions of FORECASTING FINANCIAL STATEMENTS (Part 5)
10 Marks
📌 Applicable provisions of Companies Act, 2013 regarding capital raising and financial disclosures.
From the following summarized Balance Sheet of Beta Ltd. as at 31st March, 2024 and additional financial projections for the year 2024-25, prepare a Pro Forma Balance Sheet as at 31st March, 2025 and compute the External Financing Needed (EFN) using the Percentage of Sales Method.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement