Finxora Logo
Sign In
Axis Bank Financial Projection Format for Loan Proposals
Back to Blog

Axis Bank Financial Projection Format for Loan Proposals

FINXORA
6 min read
axis bank
financial projection
financial analysis
banking
forecasting

A borrower's projection pack is what Axis Bank reads before sanctioning credit. Here is the format, the workings behind it and the gaps that delay a sanction.

Two kinds of projection, one of them yours

Axis Bank's own published results are projected by analysts, and that is not the document a business prepares. When an applicant submits a loan proposal, the projection pack it carries is the borrower's own: the future years of its operating statement, balance sheet and cash flow, the assumptions behind them and the debt service working that follows. A private sector bank's credit team reads that pack closely, because the sanction decision rests on the borrower's ability to service the facility from its own operations.

Banks do not publish one standard projection form for every case. Axis Bank, like other lenders, works to internal appraisal templates, and the checklist changes with the facility, the amount, the borrower's constitution and the branch. Prepare the projections in the standard order banks read, and confirm the current requirement with the relationship manager.

What the credit team is testing

  • Debt service - whether the cash the business generates covers interest and instalments in each year, not only on average.
  • The operating cycle - stock, receivables and creditors, and whether the limit or the project funding matches the cycle.
  • Leverage and liquidity - debt-equity, total outside liabilities to net worth, current and quick ratios, interest coverage, read as trends across the historical, provisional and projected years.
  • Banking conduct - the turnover routed through the banking system and the behaviour of existing limits, which is weighed against the projections themselves.
  • Security and structure - what supports the facility and how the repayment is structured over the loan tenure.

The year span and the order

A common pack carries the last two or three audited years, the current year's provisional figures and two or three projected years, with longer spans for term loans whose repayment runs beyond that. The order that gets read fastest is: profile and request, assumptions, operating statement, projected balance sheet, cash flow and fund flow, debt service and DSCR, ratio analysis, and the working capital working where a limit is proposed.

Term loan pack and working capital pack

The statements overlap, but the emphasis differs, and preparing the wrong set is a common reason for a file going back.

ItemTerm loan proposalWorking capital limit
Starting pointProject cost and means of financeCurrent assets and current liabilities
Core statementsProjected P&L, balance sheet, cash flow, depreciationOperating statement, balance sheet analysis, comparative statement
Central workingEMI schedule and DSCR by yearMaximum permissible bank finance and holding levels
Supporting analysisBreak-even, project ratiosTurnover method where the MSME threshold applies
Security viewAsset created, repayment structureStock and book debts, drawing power

Where a unit seeks both, the two packs are submitted together, because the bank assesses the whole borrowing rather than each facility in isolation.

The assumptions that attract questions

Projections are judged on the reasoning behind them more than on the arithmetic. Five assumptions tend to invite the most questions:

  • Sales growth that is not tied to capacity, market size or an order position. A ramp-up volume by volume is easier to defend than a percentage applied uniformly.
  • Margins that stay flat or improve every year while input costs are assumed to be steady, which is rarely how a unit actually runs.
  • Working capital days that shorten year after year without a change in credit policy, inventory planning or supplier terms.
  • Interest and depreciation in the projections that do not match the proposed loan terms and the asset schedule.
  • Cost inflation left out altogether, which makes later years look better than the early ones without any operational reason.

Ratio readings and DSCR

Credit teams commonly read a current ratio of about 1.33 and above as comfortable, and a DSCR of about 1.5 and above as adequate, but the benchmark that applies varies with the bank, the industry and the facility, so treat these as reference points rather than rules. What matters more in the file is the direction of travel: whether liquidity and leverage improve as the projections progress, and whether any year's DSCR falls short of covering the instalment.

DSCR is computed as net profit plus depreciation plus term-loan interest, divided by principal plus interest, for each year, with an average across the repayment period. Show the yearly figures, because a healthy average can hide a weak first year that a moratorium would solve.

Sensitivity, shown rather than asserted

Rather than stating that the projections are conservative, include a short sensitivity table: sales ten percent lower, material cost ten percent higher, and a delay of one quarter in the first year of operations, each showing the resulting DSCR and break-even. This answers the obvious question before it is asked, and it shows how much room the structure leaves.

Gaps that hold a file up

  • A balance sheet that balances only through a plug figure.
  • Reserves that do not roll forward from one year to the next, so the balance sheet and the profit and loss account disagree.
  • Figures in the pack that conflict with GST returns, bank statements or the audited accounts.
  • Ratios shown without formulas, so the working cannot be traced.
  • Facilities, limits and repayment terms that differ from what was discussed with the branch.
  • A year span or annexure set different from the checklist the branch gave.

Preparing the pack so it holds together

Finxora's CMA and project report modules build the statements from one set of inputs rather than from separately maintained spreadsheets. You enter the borrower profile, the historical figures, the project cost and means of finance where a term loan is involved, and the projection assumptions, and the operating statement, projected balance sheet, cash flow, fund flow, DSCR, ratio analysis, break-even and the turnover and MPBF workings all derive from those figures. Change an assumption and every dependent statement recalculates, so the projections stay internally consistent when the branch asks for a revised year.

The ratio analysis covers 20+ financial ratios across liquidity, profitability, leverage, activity, expense and growth, each with its formula, and the MPBF page places both Tandon Committee methods beside the turnover-method requirement. Under Method I the maximum permissible bank finance is 75% of the working capital gap, that is, 75% × (total current assets − current liabilities other than bank borrowings), leaving a margin of 25% of the gap; under Method II it is (75% × total current assets) − other current liabilities, leaving a margin of 25% of total current assets. Reports export as PDF, Word or Excel, and historical years can be seeded from a balance sheet already prepared in Finxora, including one built from a Tally trial balance imported as XML.

Compare the section order with the bank's checklist using a filled sample report. Use the CMA report software page for a working capital limit and the project report software page for a term loan.

Before you send the file

  1. The year span matches the branch's requirement.
  2. Each projected year's balance sheet balances, and reserves roll forward.
  3. DSCR is shown year by year with the average and any weak year explained.
  4. The limit or loan requested agrees with the MPBF, turnover-method or project funding working.
  5. A sensitivity table is attached for the assumptions most likely to move.

Frequently Asked Questions

Published on February 21, 2026

Updated on November 18, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.