Why the format decides how the report is read
A project report, or detailed project report, is the appraisal document behind a term loan or a scheme-based MSME facility. The bank reads it to satisfy itself on three things: that the project is worth funding, that the funding pattern makes sense, and that the unit can repay from its own cash generation. The format is the frame that lets a credit officer check those three things quickly.
Banks across India work from broadly the same appraisal structure, though the checklist moves with the scheme, the amount and the branch. A report that follows the order the credit team expects, with statements that agree with each other and assumptions written down, invites fewer questions. One that leaves the reader to hunt for the repayment position invites more.
What a credit officer checks, in order
- Who is borrowing - constitution, registration, PAN, GST and Udyam details, and the promoters' experience in the line of business.
- What the project is - the product or service, the process, the location, and the schedule for setting it up.
- What it costs - each project cost line, backed by quotations.
- How it is funded - the promoter's contribution, the loan sought, and any subsidy, adding back to the cost.
- What it will earn - the projected profit and loss account, balance sheet and cash flow for the years the loan runs.
- Whether it can repay - the repayment schedule and DSCR for each year.
- How much risk sits in the case - the ratios, the working capital position, the security offered and the risks identified with their mitigation.
Project cost and means of finance
These two are read as a pair, because every rupee spent has to be traced to a source. On the cost side sit land and site development, building and civil works, plant and machinery, miscellaneous fixed assets, preliminary and preoperative expenses, and the margin money for working capital, with a contingency line. On the funding side sit the promoter's own contribution, one or more term loans, any capital subsidy, and unsecured loans from promoters or relatives.
Each cost line needs a quotation or an estimate the branch can verify, and each funding source needs evidence: a bank statement, an assessment order, a subsidy sanction or a declaration. The common failure is a cost line added late in preparation with no quotation behind it, which leaves the two sides unable to agree.
Financial projections and the three statements
The projections are where the report either holds together or falls apart. The profit and loss account starts from capacity, capacity utilisation and selling price and works down through direct costs, indirect expenses, interest, depreciation and tax to net profit. The projected balance sheet carries the previous year's closing balances forward and shows the loan drawdown, the asset created and the working capital position. The cash flow statement shows the money actually moving: capital and borrowings coming in, assets, interest, principal and drawings going out.
All three must agree. A net profit that never seems to reach the bank account, or a balance sheet that does not tally, is the first sign that the projections were assembled rather than calculated. The assumptions behind them - sales growth, price, input costs, collection period - belong in the report, so the reader can judge them instead of guessing.
Debt service, DSCR and the repayment schedule
The repayment schedule sets out, month by month, the opening balance, the EMI or principal instalment, the interest component and the closing balance for each loan. DSCR then asks whether the year's cash generation covers the year's debt service. Computed year by year as net profit after tax plus depreciation plus term loan interest, divided by the principal plus interest due, it gives the credit officer the single most telling figure in the appraisal. Banks look for a cushion above 1, with the benchmark varying by scheme, industry and security, so requirements differ from bank to bank.
A schedule that starts with a moratorium during construction, and instalments that begin once the unit is producing, is easier to defend than instalments that fall due before any revenue arrives.
Ratios and the working capital working
Ratio analysis supports the story: current ratio and quick ratio for liquidity, debt-equity and TOL/TNW for leverage, interest coverage and DSCR for debt servicing, and turnover ratios for how hard the assets work. Where the proposal includes a cash credit or overdraft limit, the report should also show the working capital assessment. MPBF Method I is 75% x (Total Current Assets - Other Current Liabilities), with other current liabilities being the current liabilities excluding bank borrowings, so the borrower funds 25% of the working capital gap. MPBF Method II is 75% x Total Current Assets - Other Current Liabilities, where the margin is 25% of total current assets. For smaller MSME limits the turnover method recommended by the Nayak Committee applies: the requirement is 25% of projected annual turnover, the borrower brings 5% of turnover, and bank finance goes up to 20%.
Sections that are often left out
- Risk and mitigation - the risks the unit carries, from demand to input prices to delays, and what the promoter will do about each.
- Sensitivity and break-even - what happens to the projections if sales fall or costs rise, and the sales level at which the unit stops losing money.
- Evidence of the promoter's contribution - statements showing where the own contribution sits, not just a figure on the funding page.
- An index, cover page and annexures - quotations, licences, land documents, power sanction and the promoter's KYC, in the order the report references them.
Common errors that weaken an application
- Growth assumptions that outrun the local market, with nothing written down to support them.
- A DSCR below 1 in the early years, or the average shown without the yearly figures.
- Statements prepared separately, so the profit and loss account, balance sheet and cash flow tell slightly different stories.
- Full capacity assumed from the first month instead of a realistic ramp-up.
- Working capital asked for without the MPBF or turnover method working shown.
- Inconsistency between the report and the returns, the GST filings or the bank statements.
Excel template or project report software
An Excel template can produce a project report, and many consultants have used one for years. Its weakness is the link between sheets. A single change to the sales assumption has to be carried through the operating statement, the balance sheet, the cash flow, the depreciation chart, the repayment schedule and DSCR by hand, and a cell that is missed shows up later as a figure that does not tie.
Dedicated software keeps those links in place. Finxora's project report software builds the project cost breakdown, means of finance, revenue and expenses, profit and loss account, projected balance sheet, cash flow, depreciation chart, EMI repayment schedules, DSCR with the average row, ratio analysis, break-even, and the turnover method and MPBF working from one set of inputs, and prints them in the sections you choose. It supports Mudra, PMEGP, Normal MSME and custom loan types, more than one term loan, a capital subsidy or interest subvention, and seasonal revenue spread across the months the business actually operates.
Open a sample project report to see the finished order, build your own in Finxora's project report software, and review the project report plans before you download the PDF, Word or Excel file for the bank.
