Detailed Project Reports & Financial Modelling: The Process, Start to Finish
The mechanics of Detailed Project Reports & Financial Modelling are what clients ask about once they have decided to proceed. The questions below are the ones raised most often in practice; the full scope of the service is on the Detailed Project Reports & Financial Modelling page.
How long does it take PNPC to prepare a complete DPR and financial model?
The end-to-end timeline from engagement scoping to a submission-ready document depends on project complexity and how quickly the promoter can provide technical inputs — machinery quotations, land documents, and consultant reports; the timeline is confirmed at scoping. Larger or more technically complex projects, or projects requiring coordination with external technical consultants, can take longer. Bank sanction timelines after submission depend entirely on the lender's own internal process and are outside our control, though a well-prepared DPR materially reduces query cycles.
In practice: The single biggest driver of delay on our side is not the drafting — it is waiting on promoter-side technical inputs like machinery quotations. We flag exactly what we need on Day 1 so promoters can start gathering it in parallel with our early-stage work.
Can a DPR be used to apply for a CGTMSE guarantee?
Yes. CGTMSE (Credit Guarantee Fund Trust for Micro and Small Enterprises) provides collateral-free credit guarantee cover for eligible micro and small enterprise loans, and the underlying loan application — including the DPR — follows the lending bank's normal appraisal process, with the guarantee cover applied for by the bank based on the borrower's eligibility under the scheme. The DPR itself does not change format for CGTMSE purposes in most cases, but the borrower's eligibility (loan quantum, enterprise category, sector) must be confirmed against current CGTMSE scheme guidelines, which are periodically revised.
In practice: CGTMSE eligibility criteria — coverage limits, guarantee fee structure, eligible sectors — are revised by the trust from time to time. We confirm current guidelines with the lending bank at the time of application rather than relying on a fixed figure, since the specifics can change.
How is capacity utilisation ramp-up assumed in a realistic DPR?
Almost no project achieves full rated capacity utilisation from its first year of commercial operation. A credible DPR builds a phased ramp-up — commonly starting well below full capacity in Year 1 and scaling up over subsequent years based on realistic market absorption, operational stabilisation, and, where relevant, comparable project benchmarks in the same industry. A DPR that assumes near-full capacity utilisation from Year 1 without justification is one of the fastest ways to lose credibility with an experienced credit appraiser.
In practice: ' Overly optimistic ramp-up assumptions are the single most common credibility gap we correct in DPRs promoters have attempted to draft themselves.
How much does a DPR and financial model engagement with PNPC cost?
PNPC agrees a fixed, written fee for each DPR engagement, scoped to the project's complexity, scale, and the specific lender or scheme format required. The fee is confirmed in writing before work begins. Fees for a straightforward MSME-scale DPR are naturally lower than for a large, technically complex, multi-crore project requiring extensive coordination with external technical consultants and a full sensitivity-testing exercise.
In practice: We provide a written scope and fee letter for every DPR engagement before starting. If a project's scope changes materially during preparation — for instance, a promoter decides mid-engagement to also add a subsidy scheme application — we discuss and confirm any fee revision before proceeding, not after.
What is the difference between project IRR and equity IRR, and why do both appear in the DPR?
Project IRR measures the return generated by the total project investment (debt plus equity combined), independent of how it is financed — it answers whether the underlying project itself is economically viable. Equity IRR measures the return specifically to the promoter's equity investment, after accounting for debt servicing — it reflects the return the promoter actually earns given the specific financing structure. A project can show an attractive project IRR while equity IRR is compressed by high leverage, or vice versa, so both figures serve different audiences: the lender cares more about project viability and debt service capacity, while the promoter cares more about equity IRR.
In practice: We present both figures clearly and explain the difference to promoters directly — the two are easy to confuse, and confusing them can lead to the wrong conclusion about whether a project is 'worth it' from the equity perspective.
How does depreciation get treated in the project financial model, and does it matter for the loan appraisal?
Depreciation is computed on plant, machinery, buildings, and other fixed assets, typically based on the useful lives prescribed under Schedule II of the Companies Act 2013 for accounting purposes (from which the applicable straight-line or written-down-value depreciation rate is derived), and separately under the Income-tax Act rates for computing taxable income (which can differ from accounting depreciation, requiring a separate tax computation line in the model). Depreciation is a non-cash expense, so while it reduces book profit and taxable income, it is added back in the cash flow statement — this addback is a key contributor to the cash available for debt servicing that feeds directly into the DSCR calculation.
In practice: Two common errors in a DPR are omitting depreciation entirely from the P&L (overstating profit) or failing to add it back correctly in the cash flow (understating DSCR) — both errors materially distort the numbers a credit committee relies on.
What is 'margin money' in the context of a project DPR and Means of Finance schedule?
Margin money in a project finance context most commonly refers to the promoter's own contribution towards the working capital requirement of the project (as distinct from the promoter's contribution to the fixed capital cost) — banks typically finance only a portion of the assessed working capital requirement, with the balance expected to come from the promoter as margin. It can also refer, in a subsidy-scheme context, to the promoter's required own contribution as a condition of receiving scheme support. The exact margin percentage and how it is computed depends on the lender's working capital assessment methodology and any applicable scheme guideline.
In practice: Margin money requirements are sometimes overlooked by promoters focused only on the fixed-asset project cost — we build the working capital margin into the Means of Finance schedule from the start so there is no funding gap discovered mid-implementation.
How does GST treatment factor into the financial model's revenue and cost projections?
, net of GST), since GST is a pass-through tax collected on behalf of the government and does not form part of the project's own revenue or cost economics, except to the extent input tax credit is not fully available (which does affect landed cost in specific scenarios, such as blocked credits under Section 17(5) of the CGST Act). Working capital assumptions in the model do need to account for the GST payment and refund cycle, since this affects the cash conversion cycle even though it does not affect the P&L directly.
In practice: We flag specifically where a project involves any blocked GST credit scenario or an inverted duty structure, since these do have a genuine cash-flow and cost impact that a generic model can easily miss.
What sensitivity scenarios does PNPC typically build into the financial model?
Common sensitivity scenarios include: a lower capacity utilisation ramp-up than the base case, an input-cost escalation beyond the base assumption, a delayed project implementation timeline (pushing back the revenue-generation start date while interest during construction continues to accrue), and an interest rate increase on the term loan. We compute the resulting DSCR, IRR, and break-even impact under each scenario, so the promoter and the lender can both see how resilient the project is to realistic adverse conditions, not just how it performs under an optimistic base case.
In practice: A DPR that presents only a single base-case scenario, with no downside sensitivity, is treated by experienced credit analysts as either incomplete or as evidence the preparer has not stress-tested their own assumptions. We build sensitivity analysis as standard, not as an optional add-on.
Where this sits in the wider engagement
Detailed Project Reports & Financial Modelling rarely arrives on its own. The statutory basis and the current requirements are set out on the Detailed Project Reports & Financial Modelling service page, and the related services are grouped under Corporate Finance.
What PNPC does
PNPC Global has practised since 1986 across India and the UAE. On Detailed Project Reports & Financial Modelling we take the work end to end — reviewing the facts, preparing and filing what is required, and dealing with the authority through to closure.