Projected financial statements explained: this guide covers what it means, who it applies to, the step-by-step process, documents required, fees, due dates and penalties in India — so you can stay compliant with confidence and avoid costly mistakes.
A lender asked for a term loan or a working capital limit wants to see where the business will stand in one, two and three years. That means projected statements: a profit and loss account, a balance sheet and a cash flow, all built from one sales forecast and all agreeing with each other. This guide shows the build step by step for a small manufacturer.
Start from a sales forecast. Project costs as a share of sales, then the profit and loss account. Project stock, debtors and creditors from days or percentages of sales, add the fixed assets and funding already agreed, and let borrowing be the balancing figure in the balance sheet. Then derive the cash flow from the changes. The three statements must agree: closing cash in the cash flow must equal cash in the balance sheet. A projection is only as sound as its assumptions, which must be written beside it.
Forecast, budget and projection
A forecast is an estimate of what is likely to happen, such as sales for the next three years. A budget is a plan with targets and responsibilities for the next year. A projection takes assumptions, such as sales growth and the loan to be taken, and shows what the statements would look like if they held. Banks commonly ask for projections in a credit monitoring arrangement format, but the layout belongs to each bank: ask for yours, and fill the same figures into it.
The steps
- Sales forecast. Based on orders in hand, past growth, capacity and the market. It drives everything.
- Percentage-of-sales approach. Items that move with sales (raw material, wages, stock, debtors, creditors) are held at a share of sales or at fixed days. Items that do not (rent, depreciation, term loan instalments) are projected separately.
- Profit and loss account. Sales less operating costs gives profit before depreciation; deduct depreciation, interest and tax; deduct dividend to find retained profit.
- Balance sheet. Fixed assets rise by new purchases less depreciation. Stock, debtors and creditors follow sales. Owners' funds rise by retained profit. The term loan follows the schedule. Cash credit or other short-term borrowing is the balancing figure.
- Cash flow. Profit plus depreciation, less the increase in working capital, less capital spending, plus new loans, less repayments and dividend.
- Check. The cash flow's closing cash equals the balance sheet's cash.
- Ratios. Compute the ratios a lender will compute; see ratio analysis.
Where a bank needs a formal report on your projections, our CMA report service prepares the data in the format the bank uses.
Worked example: Mohan Engineering
Mohan Engineering, an invented small manufacturer, wants a term loan of ₹20 lakh for a machine and continues with a cash credit limit. Figures in ₹ lakh. Assumptions (all assumed): sales rise from 200 to 240 (20 per cent); operating costs excluding depreciation stay at 80 per cent of sales; depreciation rises from 10 to 12 with the new machine; interest is 11 for Year 1; tax is 25 per cent; dividend is 3.75; stock, debtors and creditors move in line with sales; existing term loan of 40, with 8 repaid in Year 1; the new loan of 20 is drawn at the start of Year 1.
Profit and loss account
| Base year | Projected Year 1 | |
|---|---|---|
| Sales | 200.00 | 240.00 |
| Operating costs (80%) | 160.00 | 192.00 |
| Depreciation | 10.00 | 12.00 |
| EBIT | 30.00 | 36.00 |
| Interest | 8.00 | 11.00 |
| Profit before tax | 22.00 | 25.00 |
| Tax at 25% | 5.50 | 6.25 |
| Profit after tax | 16.50 | 18.75 |
| Dividend | 3.75 | |
| Retained | 15.00 |
Balance sheet
| Base year | Projected Year 1 | How projected | |
|---|---|---|---|
| Fixed assets (net) | 80 | 88 | 80 + 20 - 12 |
| Stock | 40 | 48 | 40 x 1.2 |
| Debtors | 30 | 36 | 30 x 1.2 |
| Cash | 5 | 6 | assumed |
| Total assets | 155 | 178 | |
| Owners' funds | 70 | 85 | 70 + 15 |
| Term loan | 40 | 52 | 40 + 20 - 8 |
| Creditors | 20 | 24 | 20 x 1.2 |
| Cash credit | 25 | 17 | balancing figure |
| Total | 155 | 178 |
The cash credit is the funding gap: 178 - 85 - 52 - 24 = 17. The firm needs less bank borrowing because profit and the term loan fund part of the growth.
Cash flow, Year 1
| ₹ lakh | |
|---|---|
| Profit after tax | 18.75 |
| Add depreciation | 12.00 |
| Less increase in stock (48 - 40) | (8.00) |
| Less increase in debtors (36 - 30) | (6.00) |
| Add increase in creditors (24 - 20) | 4.00 |
| Cash from operations | 20.75 |
| Purchase of machine | (20.00) |
| New term loan | 20.00 |
| Repayment of existing term loan | (8.00) |
| Dividend | (3.75) |
| Repayment of cash credit (25 - 17) | (8.00) |
| Net change in cash | 1.00 |
| Opening cash 5.00, closing cash | 6.00 |
Closing cash of 6.00 equals cash in the balance sheet: the three statements agree.
Ratios a lender will compute
| Ratio | Base year | Year 1 |
|---|---|---|
| Current ratio | 75 / 45 = 1.67 | 90 / 41 = 2.20 |
| Debt-equity (term loan plus cash credit over owners' funds) | 65 / 70 = 0.93 | 69 / 85 = 0.81 |
| Interest cover (EBIT / interest) | 30 / 8 = 3.75 | 36 / 11 = 3.27 |
| Debt service cover | not computed | (18.75 + 12 + 11) / (11 + 8) = 41.75 / 19 = 2.20 |
What the owner decides. The projection shows that the machine can be paid for from profit and the term loan, with a lower cash credit than today. The weaker point is interest cover, which falls from 3.75 to 3.27 because interest rises faster than profit. Before the application goes in, the owner tests a case where sales grow by only 10 per cent, checks the debt service cover again, and writes the assumptions on a separate page. The working capital side is estimated as shown in working capital cycle, and how banks provide it is in working capital finance from banks.
How a lender reads projections
A lender looks at whether the growth is believable against past figures and orders, whether margins are held without reason, whether working capital days are reasonable, and whether cash covers instalments with something to spare. Optimistic projections that depart from history lose credibility faster than modest ones.
Common mistakes
- Starting from a sales figure with no basis.
- Letting the balance sheet balance by a plug in cash instead of a borrowing line.
- Ignoring tax, the dividend or the instalments due.
- Holding margins constant when raw material prices may move.
- Forgetting the increase in working capital that growth needs.
- Giving the bank figures that differ from those in the books or the cash budget.
Need help with projections for a bank?
If your bank has asked for projected statements, our CMA report service builds them from your accounts and assumptions, in your bank's own format. We keep the three statements linked so that a change in sales or loan flows through, and we note every assumption beside the figures.
Key takeaways
- One sales forecast drives all three statements.
- Use percentage of sales and days for items that move with sales.
- Borrowing is the balancing figure in the balance sheet.
- Closing cash in the cash flow must equal cash in the balance sheet.
- Write the assumptions down and test a weaker case.
Read next
- Ratio analysis for a small business
- Working capital cycle and requirement
- Working capital finance from banks
Disclaimer: The methods described are standard cost accounting and financial management techniques. The worked example uses an invented business and invented figures, including any tax, interest or exchange rate, which are assumptions for illustration and not current rates. Where the article refers to a legal requirement, the linked guide and the official text should be checked. This article is general information, not legal advice; check the official text before acting.