What projected financial statements mean in a loan file
Projected financial statements are forward-looking statements a borrower prepares for the years a loan will run. They are not a forecast of the best possible year; they are the basis on which a bank decides whether the business can generate enough cash to repay the borrowing. In a working capital proposal they are filed as part of CMA data, and in a term-loan or scheme proposal they sit inside the project report, also called the detailed project report or DPR.
The figures are read together, not one at a time. Sales in the operating statement have to support the debtors and stock in the balance sheet; the balance sheet has to support the cash flow; and the cash flow has to leave enough each year to cover the instalment. Statements prepared separately, in different files, rarely survive that reading.
The statements banks expect
The pack usually carries four statements, all drawing on the same assumptions:
- Projected operating statement - sales, cost of sales, operating expenses, interest, depreciation, tax and net profit for each year.
- Projected balance sheet - what the business expects to own and owe at the end of each year, with closing balances carried forward to the next year's opening figures.
- Projected cash flow statement - cash from operating, investing and financing activity, showing the peak borrowing need during the year.
- Fund flow statement - sources and uses of long-term funds, which is often the summary a credit officer reads first.
Beneath them sit the supporting schedules that make the statements credible: the working capital assessment, the depreciation chart, the loan repayment or EMI schedule, and the ratio analysis.
The year-wise format
Statements are presented with one column for each year, in the order a credit team reads them: the current year as provisional figures first, then the projected years. Three years of projections is the usual request for a working capital proposal and five years for a term loan. A project report for a long-life asset can carry a much longer horizon, up to the twenty-five years the project master allows, where the plant and the repayment both justify it.
| Statement or schedule | What the bank reads from it |
|---|---|
| Operating statement | Whether the projected margin can carry interest and leave a surplus |
| Balance sheet | Net worth, leverage and whether the current ratio stays sound |
| Cash flow and fund flow | Peak funding need and how the borrowing is repaid |
| Working capital assessment | The permissible bank finance and the margin the borrower must bring |
| Ratio analysis | Liquidity, profitability, leverage and activity ratios against bank benchmarks |
| DSCR and repayment schedule | Cash available against each year's instalment |
Working capital: MPBF and the turnover method
Where the proposal is for a cash credit or overdraft limit, the projection pack includes the working capital assessment. Under the Tandon Committee methods, MPBF Method I is 75% × (total current assets − other current liabilities), and Method II is (75% × total current assets) − other current liabilities, where other current liabilities are current liabilities other than bank borrowings. In effect, Method I leaves the borrower a margin of 25% of the working capital gap, while Method II asks for a margin of 25% of total current assets.
For smaller MSME proposals the turnover method is also used. The working capital requirement is taken as 25% of the projected annual turnover, the borrower brings a margin of 5% of turnover, and bank finance is provided up to 20% of turnover. Banks often work out all three and sanction whichever reading binds.
The ratios a projection has to satisfy
Two ratios usually attract the closest reading. The current ratio is current assets divided by current liabilities, and a level between 1.33 and 2 is commonly seen as comfortable for a working capital limit. TOL/TNW is total outside liabilities divided by tangible net worth, and lenders prefer it to stay within the limit the bank has set, often around 3 for a first sanction. Requirements vary from bank to bank, so treat these as guides rather than rules.
Alongside them sit the debt service coverage ratio and the activity ratios. DSCR is net profit plus depreciation plus term-loan interest, divided by principal repayment plus interest, computed for each projected year, with an average DSCR row beside the yearly figures. Stock turnover and debtors turnover show whether the working capital cycle in the projections matches the trade the business is actually in.
Assumptions that have to hold together
The numbers are only as good as the assumptions behind them. A working set for a first projection includes capacity and capacity utilisation, selling price growth, raw material and conversion cost, collection and holding periods, salary and overhead growth, and the interest rate and repayment terms on the borrowing. Each one should be written down, and each change should flow through every statement predictably rather than being typed into one schedule alone.
Step by step
- Collect the audited balance sheets, profit and loss statements, bank statements and income tax returns for the last three years.
- Enter the historical and provisional years, so the projections start from a known position.
- Set the assumptions for sales growth, margins, the working capital cycle and the existing loans.
- Build the operating statement, then let the balance sheet, fund flow, cash flow and ratios follow from it.
- Compute the working capital limit, the DSCR and the repayment schedule.
- Review the format against a sample, then export the statements for submission.
Where Finxora fits
Finxora builds the projected pack from one set of inputs. The CMA report software produces the operating statement, balance sheet, comparative statement, MPBF under both methods, fund flow, cash flow, DSCR and the ratio analysis in the standard format Indian banks use, and exports a formatted PDF, Excel workbook or Word document. For a new unit or an expansion, the project report software carries the project cost, means of finance, projected statements, break-even and repayment schedule. Figures entered in the balance sheet module can seed the historical years instead of being keyed in again, and a filled sample shows the format before you commit your own numbers.
