Build a forecast the lender can trace
Five-year financial projections explain how a business expects to earn, use cash and repay a proposed bank loan. A credible forecast connects operating assumptions with the profit and loss account, balance sheet, cash flow and repayment schedule. It should show why the figures are reasonable, not simply present five columns of rising profits.
Confirm the projection period with the lender before starting. Five years may be requested for a particular proposal, while a longer loan or delayed project may need a different horizon. Requirements vary by bank, facility and borrower. A projection is an estimate supported by evidence; it does not assure sanction or establish that the business will achieve the forecast.
1. Define the base year and project timeline
For an existing business, start with the latest financial statements, current-period results, loan balances and outstanding receivables and payables. Reconcile the opening balance sheet before projecting the next year. For a new unit, identify pre-operative expenditure, asset purchases, promoter contributions and borrowing that occur before commercial operations.
State whether Year 1 represents a full financial year or only the months following commencement. A unit starting in October should not automatically receive twelve months of sales. Keep construction, installation, trial production and commercial operations distinct where relevant. Align the first loan drawdown and repayment dates with that timeline.
2. Create an assumption register
Document each major driver, its source and the reason for changes across years. Machinery quotations can support capital cost; customer orders and market evidence can support sales expectations. Historical records may support collection periods and gross margins. Mark assumptions that remain unconfirmed instead of presenting them as established facts.
| Driver | Evidence or explanation |
|---|---|
| Capacity and utilisation | Equipment specification, operating days and production plan |
| Selling price | Recent invoices, contracts or documented market comparison |
| Material and employee cost | Supplier quotations, consumption norms and staffing plan |
| Collection and payment periods | Historical ageing or proposed commercial terms |
| Loan terms | Proposed amount, interest, tenure and repayment basis |
Use one assumption consistently wherever it appears. If the price changes in the revenue schedule, it must change the operating statement and linked cash forecast. Avoid hard-coded totals that remain unchanged after the underlying assumption is revised.
3. Project revenue from operating drivers
For manufacturing, begin with available capacity, utilisation, saleable output and selling price. For services, use billable hours, occupied seats, customer volumes or another activity measure. For trading, explain expected volumes, product mix and margins. Separate growth from additional capacity, higher utilisation and price changes so it can be assessed.
For example, annual capacity of 20,000 units at 60% utilisation gives 12,000 units. At Rs 500 per unit, projected revenue is Rs 60 lakh, assuming all saleable output is sold. If utilisation rises to 70% with the same price, revenue becomes Rs 70 lakh. Check inventory movements if production and sales differ. These figures are illustrative assumptions, not industry benchmarks.
4. Forecast costs and operating profit
Link variable costs to the activity that causes them. Material consumption may follow production, while freight may follow dispatches. Forecast rent, core salaries, insurance and other fixed costs separately. Explain step changes such as an additional supervisor, a larger premises or equipment maintenance beginning after a warranty period.
Prepare depreciation from asset additions, commissioning dates and the selected accounting basis. Keep interest separate from operating expenses so it can be reconciled to borrowing schedules. Estimate tax using the entity's circumstances and applicable law rather than copying a generic percentage from another report. Record promoter remuneration and drawings in the appropriate places for the entity.
5. Calculate working capital
Profit does not establish how much cash is available. Customers may pay after sales are recorded, and inventory may need to be purchased before goods are sold. Estimate receivable days, inventory holding and supplier-credit periods using a stated basis. Separate raw materials, work in progress and finished goods when their cycles differ.
A simple illustration is annual credit sales of Rs 73 lakh with 30 collection days on a 365-day basis. Estimated receivables are Rs 6 lakh. Use credit sales rather than total sales where cash transactions are material. State the day-count convention and the cost or sales basis used for each holding level.
Working capital requirement and permissible bank finance are different calculations. Where the bank uses a prescribed assessment method, follow its requirements and show the borrower's margin separately. Do not assume that a cash deficit automatically becomes an approved cash-credit limit.
6. Build the financing and repayment schedules
Match project cost with sources of finance: promoter contribution, proposed term loan and any other supported source. Identify when each source becomes available. A subsidy application is not the same as a confirmed cash receipt; disclose its status and timing assumptions. Include a funding plan for delays or ineligible expenditure where necessary.
For each loan, calculate drawdowns, interest, principal repayments and closing balance. Confirm whether a moratorium covers principal only and how interest is treated. Keep existing loans separate from the proposed facility. Reconcile annual principal repayments with the movement in the balance sheet and interest expense with the profit and loss account.
7. Link all three statements
- The profit and loss account shows revenue, expenses, interest, depreciation and estimated profit.
- The balance sheet carries assets, working capital, debt and accumulated capital or reserves.
- The cash flow shows when funding, collections, purchases, assets, repayments and drawings affect cash.
Closing cash must agree between the cash flow and balance sheet. Closing debt must agree with the repayment schedule. Profits must flow into capital or reserves after the relevant distributions and adjustments. Do not force a balance sheet to tally by inserting an unexplained asset, cash balance or liability. Investigate the missing linkage.
8. Review repayment capacity and sensitivity
One commonly used DSCR presentation is net profit plus depreciation plus term-loan interest, divided by scheduled principal plus term-loan interest. Under that definition, net profit of Rs 8 lakh, depreciation of Rs 3 lakh and term-loan interest of Rs 2 lakh give a numerator of Rs 13 lakh. With principal of Rs 6 lakh and interest of Rs 2 lakh, DSCR is 1.625 times.
Use the lender's required definition and explain adjustments. Review each year's result, especially the first repayment year, rather than relying only on an average. Assess current ratio, leverage and TOL/TNW alongside cash flows; acceptable levels depend on the bank and proposal.
Test lower sales, delayed collections and higher costs. Keep the original repayment obligation in the downside case unless a change is supported. Show the resulting cash shortfall and how it would be funded. Sensitivity analysis should reveal risk, not change assumptions until every case appears comfortable.
For the related preparation guidance, see how to make financial projections.
For the related preparation guidance, see five-year cash flow projection.
9. Assemble the bank submission
Present the assumptions, project cost, means of finance, projected statements, working-capital assessment and repayment workings in a consistent amount unit. Attach supporting quotations and historical records as required. Label actual, provisional and projected periods clearly, and check that the application form uses the same loan amount as the report.
Finxora's project report software builds projected statements, repayment schedules, DSCR and break-even analysis from report inputs. Review the assumptions and calculations before export. Use the report samples to plan presentation, and discuss whether a separate Credit Monitoring Arrangement report is required for the bank's appraisal. Software supports consistency; evidence and lender-specific review remain essential.
