Finxora Logo
Sign In
Punjab National Bank Financial Projection Format for a Loan
Back to Blog

Punjab National Bank Financial Projection Format for a Loan

FINXORA
7 min read
PNB
financial projection
banking
finance
analysis

What PNB and other lenders expect in a borrower's financial projection format, the sections it carries and how the assumptions behind each year are read.

Whose projections are being discussed

Search for a financial projection format in connection with Punjab National Bank and two different documents come up. The first is the bank's own published financial results, analysed by investors and rating agencies. The second, and the one that matters when a business applies for credit, is the projection pack the borrower submits with the loan proposal. That pack shows what the applicant business expects to earn, what it will own and owe, and how it will service the instalments. This article is about the borrower's pack.

PNB, like every Indian bank, works from its own internal appraisal template rather than one published form. The statements inside are common to the industry; the checklist, the annexures and the year span vary with the facility, the amount and the branch. Confirm the current requirement with the relationship manager, then prepare the projections in the order a credit officer reads them.

What the projection pack has to answer

Historical accounts show what a business has done. Projections show what it is expected to do, and a bank sanctioning a loan lends against the second. Three questions decide how the file is read:

  • Can the business repay? The cash generated by operations against the instalments and interest falling due.
  • How much working capital does the cycle need? Stock, receivables and creditors decide whether the limit proposed is adequate or padded.
  • Are the assumptions defensible? Capacity, market, order book and cost behaviour behind the sales and expense figures.

Files rarely fail on arithmetic alone. They fail because sales growth is not supported by capacity, because the assumptions are left unexplained, or because the statements contradict one another.

The year span

A common presentation carries the last audited year, the current year's provisional figures and two or three projected years. Term loans usually need projections covering the repayment period, which can be longer than three years. Where the facility is a working capital limit, the same years are used, but the pack also carries the current assets and current liabilities working behind the limit.

The sections, in order

Assumptions sheet

Place the drivers first so every later figure can be traced: growth in volume and in realised rate, capacity and utilisation, raw material and other direct costs as a percentage of sales, employee and overhead costs, interest rates on existing and proposed borrowings, and the working capital cycle in days. A credit officer reads the assumptions before the statements, and it is the quickest way to show that the numbers were built rather than typed.

Operating statement

Sales through direct costs, gross profit, indirect expenses, interest, depreciation, tax and net profit, for each year with the historical years alongside. Keep the schedules behind depreciation and interest visible, because those two lines are where projections usually drift from the loan terms actually proposed.

Projected balance sheet

Capital, reserves, borrowings, current liabilities and assets for each year. Each year's closing position should carry into the next year's opening figures so that reserves, loan balances and depreciation stay consistent, and the difference between the two sides is zero rather than a balancing entry.

Cash flow and fund flow

The cash flow statement reconciles opening cash to closing cash through operating, investing and financing movements. The fund flow statement shows sources and uses of long-term funds. Together they explain how the projected profit turns into cash, or why it does not.

Debt service and DSCR

DSCR is the debt service coverage ratio: net profit plus depreciation plus term-loan interest, divided by principal plus interest for the year. It is shown for every projected year with an average beside it, because the average over the repayment period is what the appraisal usually quotes. Repayment capacity below one in an early year, even with a stronger average, invites a question about the moratorium or the repayment structure.

Ratio analysis

Liquidity, profitability, leverage and solvency ratios, each with its formula and read as a trend. Current ratio, debt-equity, total outside liabilities to net worth, interest coverage and the return ratios are the ones that carry into the credit note.

Working capital working, where a limit is sought

A cash credit or overdraft proposal needs the current assets and current liabilities statement with holding levels, the maximum permissible bank finance under both Tandon Committee methods, and the turnover-method requirement where the borrower is an MSME within that threshold. The MPBF working is described in more detail below.

MPBF in a projection pack

  • Method I = 75% x (Total Current Assets - Other Current Liabilities), where other current liabilities means current liabilities excluding bank borrowings, leaving the borrower a margin of 25% of the working capital gap.
  • Method II = 75% x Total Current Assets - Other Current Liabilities, leaving a margin of 25% of total current assets.

Both are shown so the branch can apply whichever its policy follows. Method II is the stricter reading and normally gives the lower figure. Where the turnover method applies instead, the working capital requirement is 25% of projected annual turnover, the borrower margin is 5% of turnover and bank finance is up to 20% of turnover.

Presentation mistakes that slow a PNB file down

  • Projections in a different layout from the bank's checklist, which means the figures are re-keyed before appraisal.
  • Interest computed at a rate that does not match the loan terms in the proposal.
  • Reserves that do not roll forward, so the projected balance sheet and the profit and loss account tell different stories.
  • Working capital days that improve every year without any stated change in credit or inventory policy.
  • DSCR shown only as an average, hiding a year where cover falls below one.
  • Documents attached in a different order from the statements, so the officer cannot tie the audited accounts to year one of the pack.

Preparing projections that stay consistent

Finxora's project report and CMA report modules build the whole pack from one set of inputs. You enter the promoter and business profile, the project cost and means of finance, and the revenue and expense assumptions, and the profit and loss account, projected balance sheet, cash flow, depreciation chart, EMI schedules, DSCR, ratio analysis, break-even and the turnover and MPBF working all derive from those figures. Change one assumption and every dependent statement recalculates, which is what keeps the pack consistent when the branch asks for a revised year.

The project report supports several term loans, each with its own amount, tenure and repayment schedule, a moratorium, and a subsidy entered as a flat amount or a percentage of the loan, released upfront or after a delay. Panels for ratio analysis cover current and quick ratios, gross and net profit margins, ROCE, debt-equity, TOL/TNW, interest coverage, proprietary and solvency ratios and promoter contribution, each with its formula shown.

Revenue and expense rows can be marked seasonal and spread only over the months the business operates, which matters for units whose year is not flat. Exports come as PDF, Word or Excel, and the Excel output keeps the figures available for the branch's own working. Historical years can be seeded from a balance sheet already prepared in Finxora, and the balance sheet module can read a trial balance exported from Tally as XML, avoiding a second round of keying in.

Open a filled project report sample to compare the section order with the bank's checklist, then read the project report software page or the CMA report software page depending on whether the proposal is a term loan or a working capital limit.

A last check before the file goes in

  1. Every assumption on the sheet is used by a figure in the statements.
  2. The balance sheet balances in every projected year.
  3. Interest and depreciation match the loan and asset schedules.
  4. DSCR is shown year by year with the average.
  5. The limit requested agrees with the MPBF or turnover-method working.

A complete projection pack does not promise a sanction. It lets the credit team read the proposal as a coherent case, which is the most any borrower can prepare for.

Frequently Asked Questions

Published on February 21, 2026

Updated on June 02, 2026

Back to Blog

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