Ch 10: FORECASTING FINANCIAL STATEMENTS — V2: Applied Practical Scenarios & Financial Computations
CS Executive
📚 Corporate Accounting & Financial Management
📖 Ch.10 — FORECASTING FINANCIAL STATEMENTS
📘 V2: Study Material & Test Yourself
⚡ 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 Section 134 and Section 180 compliance for financial projections and borrowings.
Sahyadri Pharma Ltd. Balance Sheet as on 31st March, 2024 and additional parameters for forecasting using Percentage of Sales Method.
🔒 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
📌 Ensure compliance with Ind AS 1 (Presentation of Financial Statements) and standard corporate financial forecasting practices.
Sahyadri Agro-Chemicals Limited presents its financial position as of 31st March, 2024. The management anticipates a substantial surge in demand and projects a 25% growth in sales for the financial year 2024-25. You are required to calculate the External Financing Needed (EFN) using the percentage-of-sales method, along with necessary financial adjustments.
🔒 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
📌 Compliant with Companies Act, 2013 presentation norms (Schedule III) and Ind AS measurement principles.
M/s Kalinga Pharma Ltd. desires to prepare a Projected Statement of Profit and Loss for the year ending 31st March 2026 and a Projected Balance Sheet as on that date for submission to its bankers for working capital expansion. From the following audited Balance Sheet as on 31st March 2025 and projected operational parameters, you are required to prepare the Projected Statement of Profit and Loss and Projected Balance Sheet along with detailed working notes.
Balance Sheet as on 31st March 2025:
| Liabilities | Amount (₹ Lakhs) | Assets | Amount (₹ Lakhs) |
| :--- | :--- | :--- | :--- |
| Equity Share Capital (₹ 10 each) | 500.00 | Land and Building | 300.00 |
| General Reserve | 150.00 | Plant and Machinery | 400.00 |
| Retained Earnings | 100.00 | Inventories (Raw Materials & Finished Goods) | 200.00 |
| 10% Long-Term Debentures | 200.00 | Trade Receivables | 150.00 |
| Trade Payables | 120.00 | Cash and Bank Balances | 50.00 |
| Short-term Bank Borrowings | 80.00 | Deferred Tax Assets | 15.00 |
| Provision for Taxation | 50.00 | | |
| Total | 1,200.00 | Total | 1,200.00 |
Projected Operational Parameters for 2025-26:
1. Sales are projected at ₹ 1,500 Lakhs, representing a 25% growth over the previous year's sales of ₹ 1,200 Lakhs.
2. Cost of Goods Sold (COGS) is estimated at 60% of Sales.
3. Operating Expenses (excluding depreciation) are estimated at 15% of Sales.
4. Depreciation is to be charged at 10% on the opening book value of Fixed Assets (Land and Building + Plant and Machinery).
5. Interest on 10% Long-Term Debentures is payable annually; short-term bank borrowings attract an average interest rate of 12% per annum on the closing balance.
6. Income Tax rate is assumed at 30% on net profit before tax.
7. Dividend proposed and paid out of current year profits is 20% on Equity Share Capital.
8. Working capital ratios and balance sheet linkages:
- Trade Receivables are maintained at 36 days of Sales (assume 360 days in a year).
- Inventories are maintained at 48 days of COGS.
- Trade Payables are maintained at 45 days of Material Purchases (Assume Material Purchases = 70% of COGS).
- New Plant and Machinery costing ₹ 100 Lakhs will be purchased on 1st October 2025, funded by internal accruals and short-term bank borrowings.
- Cash balance is the balancing figure in the Projected Balance Sheet.
🔒 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
📌 Application of Percentage of Sales Method incorporating capacity utilization constraints and spontaneous financing adjustments.
M/s Kalinga Pharma Limited wishes to project its financial statements for the financial year ending 31st March 2025 using the Percentage of Sales Method and additional financing required (AFR) model. The management has provided the current financial statements and projected operational parameters. You are required to compute the External Financing Needed (EFN) or Additional Funds Required (AFR) along with the projected Balance Sheet as on 31st March 2025.
🔒 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
📌 Companies Act, 2013 provisions regarding financial disclosures, dividend distribution compliance, and working capital forecasting standards.
Aether Dynamics Ltd. presents its financial data for forecasting the Balance Sheet and Income Statement for the financial year ending 31st March 2025 using the Additional Funds Needed (AFN) method and percentage of sales method. Based on the financial records provided in the tables below, calculate the Projected Income Statement, Projected Balance Sheet, and determine the exact Additional Funds Needed (AFN), incorporating all specified operating adjustments, spontaneous liabilities changes, and dividend payout policies.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement