What a project report has to do
A project report, or detailed project report, is the appraisal document a bank reads before sanctioning a term loan or a scheme loan. It introduces the promoter and the business, costs the project, shows how the cost will be funded, and projects how the unit will sell, earn and repay over the years the loan runs. Preparation is not only typing figures; it is deciding what the lender needs to see and then making every statement agree with every other statement.
The steps below follow the order in which the document is actually built. They work for a first-time borrower and for an existing business adding capacity.
Step 1: Fix the purpose and the reader
Before opening a spreadsheet, settle three things: which lender and scheme the application is going to, what that lender has asked for, and who inside the bank will read the report. A term loan for plant and machinery, a working capital enhancement and a Mudra or PMEGP application carry different expectations about the amount, the promoter contribution and the supporting statements.
Write down the decision the report must support, such as sanction of a specific term loan, and the figures that decision depends on. This keeps the document focused. A report padded with general commentary about the industry but vague on repayment is harder to appraise than a short one with a clear case.
Step 2: Gather the inputs
- Promoter and firm profile: constitution, activity, location, PAN, GST and Udyam details.
- Project cost: land, building, plant and machinery, equipment and other assets, each with a quotation or estimate.
- Means of finance: promoter contribution, term loan, working capital and any subsidy.
- Historical financials: the last three years of balance sheet, profit and loss account and income tax returns.
- Existing borrowings and their repayment schedules, with bank statements.
- Market and operating assumptions: capacity, utilisation, selling price and expense levels.
Step 3: Validate the data before projecting
Projections built on unverified inputs create work later, because a correction early in the report travels through every statement after it. Validation here means practical checks rather than a formal audit. Check that the project cost equals the means of finance, that the opening balances match the previous year's closing figures, that expense rows move in step with the activity they belong to, and that every amount sits in the units and year column it is meant for.
Checks of this kind catch mis-keyed figures, duplicated rows and expense lines that contradict the capacity assumption. It is easier to do them while the report is half built than after the download is with the bank.
Step 4: Build the projections
The projection is the heart of the report. The operating statement carries sales and expenses for each year, the profit and loss account takes it through gross profit, operating profit, interest, depreciation, tax and net profit, and the projected balance sheet holds the assets, liabilities and net worth with each year's closing figures carried forward. A cash flow statement then shows whether the money moves in the year it is needed, which is the question a projected profit and loss account cannot answer on its own.
Document the assumptions while you build, not afterwards. Growth rates, capacity utilisation, collection periods and payment periods are the levers a credit officer will test, and each one should be defensible from the business's own history or the market it operates in.
Step 5: Work out debt service
A term loan proposal stands or falls on repayment. The repayment schedule sets out the opening balance, instalment, interest, principal and closing balance for each period, and DSCR shows whether the business earns enough to cover that instalment. DSCR is calculated as receipts, being net profit plus depreciation plus term-loan interest, divided by repayments, being principal plus interest, for each projected year, with an average DSCR row alongside.
If the proposal has more than one loan, or a moratorium before repayment begins, the schedule has to reflect it. A single blended instalment for two loans of different tenures is one of the easiest weaknesses in a report for a bank to spot.
Step 6: Check the ratios and the break-even
Ratios give the lender a quick reading of the business, so they should be calculated from the statements rather than estimated separately. The current ratio speaks to liquidity, the debt-equity and TOL/TNW ratios to leverage, and interest coverage to the comfort on finance cost. Break-even analysis shows the sales value at which fixed and variable costs are covered, the break-even point as a share of sales, and the margin of safety above it.
Sensitivity analysis is worth including where the business is exposed to one variable, such as a raw material price or a seasonal pattern. Showing what happens when that variable moves is more persuasive than asserting that it will not.
Step 7: Write the narrative and review the pack
The narrative explains the business, the promoters, the product and the market in plain language, and ties the numbers to a reason. Write it after the statements are settled so that it describes what the report actually shows. Then read the whole document the way the lender will: summary first, then cost and funding, then statements, then the debt service working and the schedules at the back.
- Does every rupee of project cost appear in the means of finance?
- Do the opening balances agree with the previous year's closing figures?
- Does the balance sheet tally in every year?
- Is the tax and depreciation treatment consistent across the statements?
- Does the narrative match the projections?
How Finxora builds the report
Finxora's project report software follows the same order. You create a project master, enter the cost and the means of finance, set the revenue and expense assumptions for each year, and the app builds the profit and loss account, projected balance sheet, cash flow, depreciation chart, EMI repayment schedule, DSCR, ratio analysis, break-even and the turnover method with MPBF from those inputs. Change an assumption and every statement recalculates.
The project master supports several term loans, a moratorium, seasonal revenue rows limited to their active months, and projections up to twenty-five years. Export is available as PDF, Word or Excel after you choose the sections to include and add the cover page and index. Historical years can come from the balance sheet module, a filled sample project report shows the finished layout, and the pricing page sets out the plan options for the module.
