Projected Financials Review for MSME Loans: Tests That Work
Last reviewed: November 2026
Projected financials review for MSME loans is the lender's test of whether a borrower's forecast turnover, margins and cash flows are supported by its own history and by independent data such as Goods and Services Tax (GST) returns and bank credits. It is the step that stops a hopeful spreadsheet from becoming a sanctioned limit.
This guide is for chief credit officers and micro, small and medium enterprise (MSME) credit heads at banks and non-banking financial companies (NBFCs). It covers the reconciliation method, four formulas, a variance threshold table and a review note template, then closes with a full worked example after showing how Digiqt's Custom AI Development team can automate the testing.
At a Glance
- Base year before growth. Projections built on a turnover that GST returns and bank credits do not support are wrong from line one.
- Earned growth only. Compare projected growth with the historical compound annual growth rate (CAGR), not with the borrower's ambition.
- Coverage on reviewed numbers. A haircut to sales can push the debt service coverage ratio (DSCR) below your floor.
- Thresholds in policy, so every credit officer haircuts the same way.
What Is Projected Financials Review for MSME Loans?
Projected financials review for MSME loans is a lender-side check on the forecast the borrower or its accountant submits, usually in credit monitoring arrangement (CMA) data format. It is not CMA preparation; it is the credit team asking whether each projected line can happen.
Estimated vs projected figures: in CMA data, "estimated" covers the current financial year still running, while "projected" covers future years. Estimated figures can be tested against year-to-date returns and statements, so they deserve tighter tolerances.
Why Does Projected Turnover Drive the Loan Amount?
Projected turnover drives the loan amount because many working capital limits are a percentage of it. The Reserve Bank of India's (RBI) MSME Frequently Asked Questions (updated 29 July 2025) state that "As per Nayak Committee Report, working capital limits to SSI units is computed on the basis of minimum 20%" of estimated turnover, up to a credit limit of ₹5 crore, where SSI means small-scale industry.
The same answer adds that banks should appraise genuine working capital needs, so the 20% figure is a floor for computation, not a substitute for review.
How Much Exposure Can Unchecked MSME Projections Add?
Unchecked MSME projections add exposure equal to the inflated share of turnover times your lending percentage. In this illustrative portfolio, a lender sanctions 300 MSME working capital limits a year at an average requested ₹1.5 crore.
| Measure | Value |
|---|---|
| Limits sanctioned a year | ₹450 crore |
| Average projection inflation not caught | 15% |
| Limits backed by sales that never happen | ₹58.7 crore |
| Effect | Drawing power runs short, accounts drift towards special mention status |
Which Data Should You Test Projected Financials Against?
Test projected financials against five independent data sets, each matched to the projection line it can confirm.
| Projection Line | Test Against | Where It Comes From |
|---|---|---|
| Base-year turnover | GSTR-3B outward supplies and audited sales | GST returns, spread financial statements |
| Cash realisation | Net business credits in bank statements | Statements or the account aggregator |
| Seasonality | Month-wise GSTR-3B values | GST return extraction |
| Margins | Three years of audited profit and loss | Income tax returns (ITR) and audited accounts |
| Working capital days | Past debtor, inventory and creditor days | Balance sheets and stock statements |
How Do You Reconcile GSTR-3B Turnover With Bank Credits?
Convert GST turnover into invoice value, then strip non-business credits from the bank side. GSTR-3B is the monthly GST summary return in which Table 3.1 reports outward supplies.
Invoice value = Σ 12 months of outward taxable supplies × (1 + weighted GST rate)
Net business credits = total credits − loan disbursals − own-account transfers − reversals − capital introduced
Gap % = (net business credits − invoice value) ÷ invoice value × 100
A large positive gap can mean unbilled cash sales; a large negative gap can mean book entries without collections. Our guide to GST-based MSME lending covers using these returns for eligibility.
Which Formulas Test MSME Projections?
Four formulas test most MSME projections: historical CAGR, DSCR, current ratio and working capital days.
| Formula | Calculation | What It Tells You |
|---|---|---|
| Historical CAGR | (latest turnover ÷ turnover n years ago)^(1 ÷ n) − 1 | Growth the business has actually delivered |
| DSCR | (profit after tax + depreciation + term-loan interest) ÷ (term-loan interest + principal repayment) | Cash available per rupee of term debt service |
| Current ratio | current assets ÷ current liabilities | Short-term liquidity cushion |
| Debtor days | trade receivables ÷ sales × 365 | How long customers take to pay |
| Inventory days | inventory ÷ cost of sales × 365 | How long stock sits |
| Creditor days | trade payables ÷ purchases × 365 | How long suppliers wait |
A current ratio of 1.33 is a long-standing banking benchmark from the Tandon Committee's second method of lending, though each lender sets its own floor.
What Variance Thresholds Should a Credit Policy Use?
A credit policy should set variance thresholds for six projection lines, with a fixed action at each band. This illustrative table is a starting point for your board-approved policy.
| Test | Accept | Ask for Evidence | Haircut |
|---|---|---|---|
| Projected growth vs three-year CAGR | Up to +10 percentage points | +10 to +25 points | Above +25: cap at CAGR + 10 |
| Estimated year vs year-to-date GST run rate | Within ±10% | ±10–20% | Beyond 20%: use run rate |
| GST invoice value vs net bank credits | Within ±10% | ±10–25% | Beyond 25%: use the lower figure |
| Projected operating margin vs three-year average | Within 2 points | 2–5 points | Above 5: use average |
| Projected debtor or inventory days vs history | Within 15 days | 15–30 days | Above 30: use history |
| Projected volume vs installed capacity | Under 85% utilisation | 85–100% | Above 100% without capital spend: cap |
When an officer accepts a projection outside these bands, log it through credit policy deviation tracking. The committee then sees how often projections pass above policy, by branch and by officer.
What Should a Projected Financials Review Note Contain?
A projected financials review note should contain eight items so the sanctioning authority sees what was tested and what changed. Paste these into your appraisal template.
- Base-year turnover from audited accounts, GSTR-3B and net bank credits, with gap %.
- Three-year CAGR and projected growth, with the difference in percentage points.
- Projected and historical operating margin.
- Projected and historical debtor, inventory and creditor days.
- Capacity utilisation implied by projected volume.
- Order book or contract evidence collected.
- Haircuts applied, with the policy threshold triggered.
- DSCR and current ratio on reviewed numbers.
Are your credit officers rebuilding every MSME projection in Excel?
Scope an AI Model That Tests MSME Projections
Start with a discovery sprint on your own past files, or talk to our AI team about your credit workflow.
How Can Custom AI Development Automate Projection Reviews?
Custom AI development can automate projection reviews by building a model that reads GST, bank and financial data, runs every test above and explains each flag in plain language. Digiqt's AI development team works through a discovery sprint, feasibility study, model selection, validation and deployment with continuous improvement.
| Step | Before the Model | With a Model Built by Digiqt |
|---|---|---|
| Base-year check | Analyst adds GSTR-3B months by hand | Automated reconciliation with gap % |
| Growth and margin tests | Judgement varies by officer | Policy thresholds applied the same way every time |
| Explanation | Notes in the appraisal | Explainable artificial intelligence (AI) shows which input drove each flag |
| Portfolio view | None | Analytics and reporting across branches, batch or real time |
| Start | Large project | Minimum viable product (MVP) or proof of concept (POC) first |
Outputs can feed your credit decision engine, your MSME loan origination software and annual working capital limit renewal.
How Does a Projected Financials Review Work on a Real File?
A projected financials review on a real file runs the reconciliation, the growth test and the coverage test in that order. Here is an illustrative manufacturer seeking a working capital limit and a term loan.
- History: audited turnover ₹4.0 crore (financial year, or FY, 2023-24), ₹4.6 crore (FY 2024-25) and ₹5.2 crore (FY 2025-26).
- Reconciliation: GSTR-3B taxable supplies for FY 2025-26 total ₹5.05 crore; at 18% GST, invoice value is ₹5.96 crore. Net business credits are ₹5.95 crore, a gap of −0.2%, so the base year holds.
- Growth sanity check: CAGR = (5.2 ÷ 4.0)^(1 ÷ 2) − 1 = 14.0%. The borrower projects ₹7.5 crore, growth of 44%, which is 30 points above CAGR.
- Haircut: reviewed turnover = ₹5.2 crore × 1.24 = ₹6.45 crore.
- Limit: 20% of ₹7.5 crore is ₹1.50 crore; 20% of ₹6.45 crore is ₹1.29 crore, so ₹21 lakh of the request is unsupported.
- Coverage: on the borrower's numbers, DSCR = (45 + 15 + 18) ÷ (18 + 40) = 1.34, in ₹ lakh. On reviewed sales, profit after tax falls to ₹32 lakh and DSCR = 65 ÷ 58 = 1.12, below a 1.25 floor.
The decision: sanction the reviewed limit and restructure the term loan tenure, or ask for signed orders that justify the gap.
Want every projection haircut explained the same way, in every branch?
Book an AI Discovery Sprint for MSME Credit
Bring three anonymised appraisal files, or visit Digiqt to request a consultation on projection testing.



