What a financial projection format means in a loan file
When a business applies to HDFC Bank or any other Indian bank for a term loan or a working capital limit, the branch asks for the last few years of financial statements along with projections for the years the loan will run. The projections are presented in a fixed order that lets a credit officer follow the business from the past into the future without hunting for figures. That order is what people mean by a financial projection format.
It is worth separating this from the bank's own published financial results. The projection format discussed here belongs to the borrower's file: it shows what the applicant business expects to earn, what it will own and owe, and how it will service the instalments. Each bank's credit team works with its own appraisal templates, and the exact requirements change with the facility, the amount and the branch, so confirm the current checklist with the relationship manager before you prepare the file.
Why banks ask for projections
Historical accounts show what a business has done. Projections show what it is expected to do, and a bank sanctioning a loan is lending against the second. The credit officer uses them to judge three things:
- Repayment capacity - the cash the business will generate against the instalments.
- Working capital need - how much short-term finance the operating cycle can support.
- Risk - whether the assumptions behind the sales and cost figures are realistic for the market the business operates in.
Weak projections rarely fail on the arithmetic alone. They fail when the sales growth is not supported by capacity, when the assumptions are not stated, or when the statements contradict each other.
The projection pack, section by section
Borrower and promoter profile
Constitution, activity, location and year of commencement, with PAN, GST registration where applicable, Udyam registration and the particulars of partners or directors. For a proprietary concern, the promoter's experience and existing business are part of the profile.
Assumptions schedule
A short statement of the basis for every projection: sales growth, capacity and utilisation, selling price, raw material cost, wage inflation, interest rates and the working capital cycle. A bank can accept an ambitious assumption that is explained; it cannot accept an unexplained one.
Projected operating statement
Sales through gross profit, earnings before interest, depreciation, interest, depreciation, tax and net profit for each year, with the last audited year as the starting point and the current year's provisional figures beside it. A typical pack shows two or three projected years.
Projected balance sheet
Capital and reserves, borrowings, current liabilities and current assets for every year, with closing balances carried into the following year's opening figures. The balance sheet should tally in each projected year, which is the first check a credit officer runs.
Cash flow and fund flow statements
Cash generated from operations against the outflows for interest, principal repayment, capital expenditure and drawings. Instalments belong in the projections themselves, not only in the repayment table, because the cash flow is what demonstrates that they can be met.
Debt service and DSCR
DSCR is receipts divided by repayments, where receipts are net profit plus depreciation plus term-loan interest and repayments are principal plus interest. The format shows the figure for every projected year along with the average, which is the number the appraisal usually turns on.
Ratio analysis
Current ratio, quick ratio, debt-equity, total outside liabilities to net worth, total term liabilities to net worth, interest coverage, gross and net profit ratios, stock turnover and return on capital employed, each measured against usual banking benchmarks and tracked across years.
Working capital assessment
Where the proposal includes a cash credit or overdraft limit, the pack carries the current assets and current liabilities working with the maximum permissible bank finance. For MSME limits, the turnover method computes the requirement as a share of projected turnover, and the borrower margin and the bank share follow from it.
How the statements stay consistent
The sections are not independent. Sales flow into the operating statement, which produces the profit that moves into the balance sheet and the cash flow; the balance sheet supplies the current assets and liabilities for the working capital assessment and the ratio set; and the debt service working draws on the profit, depreciation and loan balances. A change to one assumption therefore moves several statements at once, which is why the pack is easier to keep right in software that links them than in separate spreadsheets.
Preparing a projection pack
- Assemble the base year figures: audited balance sheets and profit and loss accounts, and the current year's provisional numbers.
- Decide the projection years and enter the assumptions for each one.
- Build the operating statement, balance sheet and cash flow, and check that the balance sheet tallies every year.
- Add the loan schedule, the DSCR working and the ratio analysis.
- Where a working capital limit is sought, add the current assets and current liabilities working and the permissible bank finance computation.
- Review before submission, then export a print-ready file with a cover page and the annexures the branch asked for.
Mistakes that slow an appraisal
- Balance sheets that do not tally in a projected year.
- Instalments missing from the projected cash flow.
- Growth rates with no capacity or market support behind them.
- Assumptions left unexplained, or changed between the file and the discussion with the bank.
- Statements in different units, so the reader has to convert figures mentally.
How Finxora prepares the same pack
Finxora's project report software builds the projections from one set of inputs: the project cost and means of finance, month-wise revenue and expenses, the projected profit and loss account and balance sheet, cash flow, the depreciation chart, one EMI schedule per loan, year-wise DSCR with an average row, ratio analysis, break-even, and the turnover method and MPBF working together. Assumptions can be entered by hand or drafted with AI and edited, and a change in one figure recalculates the statements that depend on it. The project master can be tagged as Mudra, PMEGP or Normal MSME, and the finished report exports as PDF, Word or Excel.
The project report software page lists every section the generator produces, and the samples page carries a complete report in the order a bank reads it, including the projection years. A proposal that also carries a working capital limit needs CMA data alongside the project report, and the CMA report software page covers that pack.
Requirements vary from bank to bank, so treat any published structure as a guide and prepare the file against the checklist the branch provides.
