What a project report means in a bank loan file
A project report — the detailed project report, or DPR — is the appraisal document a bank studies before sanctioning credit. In an IDFC First Bank application, as with any Indian bank, the credit team works from the standard appraisal structure: who the promoter is, what the project costs, how that cost is funded, what the unit will earn, and whether those earnings can service the loan.
The bank does not publish a single fixed pro forma that suits every proposal. Requirements vary with the scheme, the ticket size and the branch, and the relationship manager usually shares a document checklist for the specific case. The practical approach is to prepare the standard DPR structure, then match it to that checklist and confirm anything the bank has not stated in writing.
The format at a glance
| Section | What the credit team reads in it |
|---|---|
| Cover page and index | Applicant name, type of facility, amount sought, report years and date |
| Applicant profile | Constitution, activity, location, PAN, GST and Udyam registration, promoters and their experience |
| Project narrative | Product or service, market, capacity and the reason for the investment |
| Project cost | Land, building, plant and machinery, miscellaneous fixed assets, pre-operative expenses, margin for working capital and contingency |
| Means of finance | Promoter contribution, term loan, working capital limit and subsidy, adding back to the project cost |
| Revenue and expenses | Capacity, utilisation, selling price and direct and indirect costs for each year |
| Projected statements | Profit and loss account, projected balance sheet, cash flow and depreciation for each report year |
| Debt service | Month-wise EMI schedule, DSCR for each year and the average DSCR |
| Ratios and working capital | Current ratio, TOL/TNW, debt-equity, break-even, and MPBF where the proposal carries a cash credit or overdraft |
| Annexures | Audited accounts, income tax returns, GST returns, machinery quotations, security documents and promoter net worth |
Applicant profile and project narrative
The opening pages establish who is borrowing. Give the constitution, the activity, the location with the unit address, the PAN, the GST registration and the Udyam number, and list the promoter or partners with the experience each one brings. Where the borrower already runs a business, describe it and its group concerns, because the bank will read the new proposal against the existing record.
The narrative that follows should say plainly what the unit will make or sell, to whom, and on what basis the demand is expected. Keep it factual. An ambitious market story is easy to test against the numbers that follow, and an overstated one costs credibility that the rest of the report has to earn back.
Project cost and means of finance
These two schedules must tie to the rupee. Every item of cost — land, building, plant and machinery, miscellaneous fixed assets, pre-operative expenses and contingency — has to be funded by an entry in the means of finance: promoter contribution, one or more term loans, the working capital limit and any subsidy. Banks set their own minimum promoter contribution by scheme and ticket size, so confirm the expected margin with the branch rather than assuming a figure.
Keep the machinery quotations beside the cost schedule so the numbers can be verified. Where a subsidy is claimed, show its release year and how it is applied. A subsidy credited in year one and forgotten in the projections for year two is one of the commonest inconsistencies in a submitted report.
Projections and assumptions
Banks usually want projections covering the repayment period. A term loan commonly needs five years or more, while a small-ticket request may be assessed from three; the branch will confirm what it expects. Build sales from capacity and utilisation rather than a flat growth percentage, then carry the working capital cycle through the debtor, creditor and stock days the business actually runs on.
Give interest its own line for each facility at the rate charged, and let the term loan's repayment sit in the schedule it belongs to. If a moratorium applies, or a working capital limit runs alongside the term loan, say so in the assumptions instead of burying the cost in one interest figure.
DSCR and repayment capacity
DSCR is the measure the credit team checks before it agrees a repayment schedule. It compares the cash the unit generates with the money that has to go out:
DSCR = (net profit after tax + depreciation + term loan interest) ÷ (term loan principal + interest), for the year.
Banks generally want the DSCR to stay comfortable in every year of repayment rather than averaging away a weak year, and a common working reference for a term loan is 1.5 or above. Each bank fixes its own floor for its own schemes, so read that number as the bank's benchmark, not as a rule. Show the month-wise EMI schedule behind the yearly lines, and add a sensitivity case that tests a fall in sales or a rise in costs.
Ratio analysis, break-even and MPBF
The ratio pages demonstrate liquidity, leverage and coverage. The current ratio is compared with the Tandon working reference of about 1.33, TOL/TNW with the bank's ceiling, and debt-equity with the promoter's stake. The break-even page shows the sales value at which the unit covers its fixed and variable costs, with the margin of safety above it.
Where the proposal includes a cash credit or overdraft, the file also needs the working capital computation. The two Tandon Committee methods give:
- MPBF Method I: 75% × (total current assets − current liabilities other than bank borrowings).
- MPBF Method II: 75% × total current assets − current liabilities other than bank borrowings.
Method I leaves the borrower a margin of 25% of the working capital gap, while Method II requires 25% of total current assets. For a small MSME assessed on the turnover method, the working capital requirement is taken as 25% of projected annual turnover, the borrower's margin as 5%, and bank finance up to 20% of turnover. Banks choose the method and the norms that apply to a case, so the report should show the working and let the credit team lay its own ceiling beside it.
Mistakes that send a report back
- A balance sheet that does not tally, usually because one statement was edited and the others were not.
- Projections that disagree with the income tax and GST returns filed for the existing business.
- Machinery cost without quotations, or a subsidy that appears in the cost but nowhere in the funding.
- Growth assumptions far above the unit's own past performance and the industry it operates in.
- An EMI that begins before commercial production, or a proposed working capital limit that never appears in the projected balance sheet.
- Missing security details, promoter net worth, or annexures the branch checklist names.
Preparing the file
Start from the audited accounts, carry the closing balances forward year by year so each statement rests on the one before, and fix the report years once the bank has confirmed them. A report built in software keeps the operating statement, balance sheet, cash flow, DSCR and ratio pages on the same inputs, so an amendment to one assumption does not leave the pack inconsistent. Finxora's project report software follows this structure, and a filled sample shows how the sections print before you begin — see project report software and the samples library, with the project report plans listed on the project report pricing page.
Submit the report along with the audited accounts and returns it was built from, and keep a soft copy of the file so that a branch query can be answered the same day rather than at the end of the week.
