Executive Summary
- Projections need 5–7 years covering P&L, Balance Sheet, and Cash Flow together
- Every assumption should trace to a defensible source, not a round number chosen for convenience
- The three statements must be internally consistent with each other, not prepared in isolation
- Sensitivity analysis on key assumptions strengthens credibility rather than undermining it
The Three Statements That Must Work Together
A complete financial projection covers Profit & Loss, Balance Sheet, and Cash Flow for 5 to 7 years, depending on loan tenure. These are not three independent exercises — net profit from the P&L flows into retained earnings on the Balance Sheet, which in turn affects the Cash Flow statement, and inconsistency between them is one of the fastest ways to undermine an otherwise solid DPR.
Every Assumption Needs a Defensible Source
Revenue growth rates, cost percentages, and margin assumptions should each trace to something specific — industry benchmark data, the promoter's prior experience, comparable business performance, or documented market research — rather than round numbers chosen because they produce an attractive result. A credit officer who asks "why 15% growth and not 10%" should get an answer grounded in evidence, not convenience.
The Most Common Disconnect Between Statements
The single most frequent inconsistency MSME Central encounters is depreciation treated differently across the DPR narrative, the P&L, and the DSCR calculation — since depreciation is added back for DSCR purposes but deducted for P&L purposes, preparers without financial modelling discipline frequently apply it inconsistently across the document, which an experienced credit officer catches immediately.
Why Sensitivity Analysis Helps, Not Hurts
Including a brief sensitivity analysis — showing how DSCR and profitability hold up under a moderately adverse scenario, such as 10% lower revenue or higher input costs — counterintuitively strengthens a DPR rather than weakening it. It signals the promoter has genuinely stress-tested the business case rather than presenting only the best-case outcome, which credit officers reviewing dozens of uniformly optimistic DPRs notice and value.
Frequently Asked Questions
How many years of financial projections are required in a DPR for bank loan?
Most PSU banks in Karnataka require financial projections covering the full loan tenure — typically 5 to 7 years for term loans. Year 1 projections should be monthly or quarterly; Years 2 onwards can be annual. The three financial statements — P&L, Balance Sheet, and Cash Flow Statement — must all be projected and must be internally consistent with each other and with the CMA data submitted alongside the DPR.
What growth rate is acceptable for revenue projections in an MSME DPR?
Revenue growth projections that are defensible based on sector benchmarks, identified market demand, and realistic capacity ramp-up are acceptable regardless of the specific percentage. A 30% growth rate is fine if the market analysis supports it with specific evidence. A 10% growth rate will be questioned if Year 1 capacity utilisation is already projected at 100%. The bank scrutinises whether the growth assumption is grounded in evidence, not whether the number is above or below an arbitrary ceiling.
Can I prepare financial projections for a DPR without a CA in Karnataka?
There is no regulatory requirement for a CA to prepare or certify DPR financial projections in all cases. However, banks treat professionally prepared projections with much higher credibility, particularly when the preparer can be held accountable for accuracy. Errors in DSCR calculation or Balance Sheet inconsistencies in self-prepared projections are common rejection causes. An MSME loan consultant or CA prepares projections with cross-form consistency checks that self-preparation routinely misses.