What the bank reads in an MSME project report
An MSME loan proposal usually reaches the bank as two things: the application and the project report. The report — the detailed project report, or DPR — is the appraisal document. It introduces the promoter and the business, costs the project, shows how that cost will be funded and projects how the unit will sell, earn and repay over the years the loan runs.
Credit teams read it as one story told in numbers. Every rupee of project cost has to appear in the means of finance, each year's profit has to flow into the projected balance sheet and the cash flow, and the repayment has to be covered by the projected surplus. A report that presents those three links clearly does most of the work of a sanction proposal; one that lists disconnected sections leaves the credit officer to reconstruct the argument.
The format, section by section
The order below follows the appraisal format Indian banks are used to. Small variations are common, so check the branch's own checklist if it circulates one.
- Cover page and index — borrower's name, activity, the facility sought and the periods projected, with page numbers for each section.
- Promoter and entity profile — constitution, activity, location, starting year, PAN, GST and Udyam details, and particulars of the promoters or partners.
- Project narrative — the written introduction to the project, its rationale and the demand it serves.
- Project cost — land, building, plant and machinery, miscellaneous fixed assets and other cost lines, item by item, with yearly totals where the project runs over more than one year.
- Means of finance — own contribution, one or more term loans, the working capital loan and any subsidy, with every source adding back to the project cost.
- Revenue and expenses — capacity, utilisation, selling price and the direct and indirect expense rows for each year, month-wise where the business needs it.
- Profit and loss account — sales through gross profit, EBDIT, interest, depreciation, tax and net profit for each projected year.
- Projected balance sheet — assets, liabilities and net worth, with closing balances carried forward year on year.
- Cash flow — inflows from capital, subsidy and borrowings against outflows for assets, interest, principal and drawings.
- Depreciation chart — asset-wise depreciation under the method you configure, feeding the operating statement and the balance sheet.
- EMI repayment schedule — month-wise opening balance, EMI, principal, interest and closing balance for each loan.
- DSCR — receipts against repayments for each year, the ratio itself and the average DSCR row.
- Ratio analysis — liquidity, profitability, leverage and solvency ratios, each with its formula.
- Break-even — break-even sales value, the break-even point as a share of sales and the margin of safety above it.
- Working capital working — the turnover method and MPBF computation, so the borrowing proposed against the project can be checked the way a credit officer would.
- Explanations and conclusion — the assumptions behind the projections and a short statement of the case.
- Annexures — quotations, layout drawings, licences, promoter documents and any market evidence the branch has asked for.
Financial projections the appraisal needs
The projections carry the application. Three to five years is the usual span, though a term loan that runs longer will be appraised over its repayment period, and a seasonal business should have its revenue and expense rows spread only over the months it actually operates rather than divided by twelve.
DSCR is the figure most credit officers turn to first. It is calculated for each year as receipts — net profit plus depreciation plus term-loan interest — divided by repayments, that is principal plus interest. A schedule of yearly DSCR readings, with the average shown beside them, answers the repayment question directly. Where a term loan starts after a moratorium, the schedule has to reflect the months in which nothing is repaid.
Two more working notes belong with the projections. Break-even shows the sales value at which the unit covers its fixed and variable costs, and the margin of safety above that point. Working capital shows how the current assets and liabilities of the projected years support the limit proposed, with the turnover method reading and the MPBF computation beside it. Ratios such as the current ratio, debt-equity and TOL/TNW give the credit officer a quick read on liquidity and leverage without rebuilding the statements.
If the project carries a subsidy, show how it is treated. A capital subsidy can be handled as a flat amount or as a percentage of the loan, released upfront or after a delay, and it can adjust either the EMI or the tenor; interest subvention works the same way. The projections should state which treatment has been adopted, because it changes the repayment schedule.
Scheme-tagged applications
Mudra, PMEGP and other MSME schemes publish their own application forms, but the financial content they ask for is the same: promoter details, project cost, means of finance, projections and repayment capacity. Preparing the report in the standard structure means the same document serves a scheme application and an ordinary term-loan proposal, with the scheme's own form completed alongside it. Which schemes a borrower is eligible for, and the limits under each, are matters for the bank or the scheme guidelines.
Preparing the report in Excel or in software
A spreadsheet can carry a project report if the formulas are kept linked: one input sheet, the project cost and funding tied to it, and every statement referencing those cells. The problems arrive with revisions. A change in the loan amount has to be followed through the depreciation chart, the EMI schedule, the DSCR, the cash flow and the balance sheet, and a missed link is easy to miss until the bank spots an unexplained difference.
Finxora's project report software builds the whole report from one set of inputs: project cost and means of finance, the projected profit and loss account, balance sheet and cash flow, depreciation, EMI schedules for one or more term loans, DSCR with an average row, ratio analysis, break-even, the turnover method and MPBF, and the explanations and conclusion. You select the sections to include and add a cover page, index and narrative before exporting a formatted PDF, Word, Excel or JSON file. A filled sample report shows the finished layout, and the project report plans page covers how to start.
Before you submit
- Project cost and means of finance agree on both sides.
- Every projected year's balance sheet tallies, and the closing figures carry forward.
- DSCR covers each year's repayment instalments, including any moratorium period.
- Assumptions for sales growth, margins and holding periods are written down and defensible.
- Subsidy and subvention treatments are stated where they apply.
- The section order matches what the branch asked for; check its checklist or an annexure note.
The tools hub carries the calculators that help with EMI and repayment workings before the report is built.
