Technology

Projected Financials Review for MSME Loans: Tests That Work

|Posted by Hitul Mistry / 19 Nov 26

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.

MeasureValue
Limits sanctioned a year₹450 crore
Average projection inflation not caught15%
Limits backed by sales that never happen₹58.7 crore
EffectDrawing 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 LineTest AgainstWhere It Comes From
Base-year turnoverGSTR-3B outward supplies and audited salesGST returns, spread financial statements
Cash realisationNet business credits in bank statementsStatements or the account aggregator
SeasonalityMonth-wise GSTR-3B valuesGST return extraction
MarginsThree years of audited profit and lossIncome tax returns (ITR) and audited accounts
Working capital daysPast debtor, inventory and creditor daysBalance 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.

FormulaCalculationWhat It Tells You
Historical CAGR(latest turnover ÷ turnover n years ago)^(1 ÷ n) − 1Growth 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 ratiocurrent assets ÷ current liabilitiesShort-term liquidity cushion
Debtor daystrade receivables ÷ sales × 365How long customers take to pay
Inventory daysinventory ÷ cost of sales × 365How long stock sits
Creditor daystrade payables ÷ purchases × 365How 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.

TestAcceptAsk for EvidenceHaircut
Projected growth vs three-year CAGRUp to +10 percentage points+10 to +25 pointsAbove +25: cap at CAGR + 10
Estimated year vs year-to-date GST run rateWithin ±10%±10–20%Beyond 20%: use run rate
GST invoice value vs net bank creditsWithin ±10%±10–25%Beyond 25%: use the lower figure
Projected operating margin vs three-year averageWithin 2 points2–5 pointsAbove 5: use average
Projected debtor or inventory days vs historyWithin 15 days15–30 daysAbove 30: use history
Projected volume vs installed capacityUnder 85% utilisation85–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.

  1. Base-year turnover from audited accounts, GSTR-3B and net bank credits, with gap %.
  2. Three-year CAGR and projected growth, with the difference in percentage points.
  3. Projected and historical operating margin.
  4. Projected and historical debtor, inventory and creditor days.
  5. Capacity utilisation implied by projected volume.
  6. Order book or contract evidence collected.
  7. Haircuts applied, with the policy threshold triggered.
  8. 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.

StepBefore the ModelWith a Model Built by Digiqt
Base-year checkAnalyst adds GSTR-3B months by handAutomated reconciliation with gap %
Growth and margin testsJudgement varies by officerPolicy thresholds applied the same way every time
ExplanationNotes in the appraisalExplainable artificial intelligence (AI) shows which input drove each flag
Portfolio viewNoneAnalytics and reporting across branches, batch or real time
StartLarge projectMinimum 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.

  1. 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).
  2. 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.
  3. 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.
  4. Haircut: reviewed turnover = ₹5.2 crore × 1.24 = ₹6.45 crore.
  5. 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.
  6. 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.

Sources

Read our latest blogs and research

Featured Resources

Technology

Financial Statement Spreading for Lenders: Ratios You Trust

Financial statement spreading for lenders: what a spread must capture, a 7-step workflow, 8 checks using Schedule III and CARO disclosures, and metrics.

Read more
Technology

GST-Based MSME Lending: Underwrite From Tax Data

GST-based MSME lending guide for credit leaders: access GST returns via Account Aggregator, read the signals, set limits and avoid the traps in tax data.

Read more
Technology

Working Capital Limit Renewal: Faster MSME Annual Reviews

Working capital limit renewal for MSME lenders: why annual reviews run late, the RBI timelines involved, a 7-step renewal workflow and metrics to track.

Read more

About Us

We are a technology services company focused on enabling businesses to scale through AI-driven transformation. At the intersection of innovation, automation, and design, we help our clients rethink how technology can create real business value.

From AI-powered product development to intelligent automation and custom GenAI solutions, we bring deep technical expertise and a problem-solving mindset to every project. Whether you're a startup or an enterprise, we act as your technology partner, building scalable, future-ready solutions tailored to your industry.

Driven by curiosity and built on trust, we believe in turning complexity into clarity and ideas into impact.

Our key clients

Companies we are associated with

Life99
Edelweiss
Aura
Kotak Securities
Coverfox
Phyllo
Quantify Capital
ArtistOnGo
Unimon Energy

Our Offices

Ahmedabad

B-714, K P Epitome, near Dav International School, Makarba, Ahmedabad, Gujarat 380051

+91 99747 29554

Mumbai

C-20, G Block, WeWork, Enam Sambhav, Bandra-Kurla Complex, Mumbai, Maharashtra 400051

+91 99747 29554

Stockholm

Bäverbäcksgränd 10 12462 Bandhagen, Stockholm, Sweden.

+46 72789 9039

Malaysia

Level 23-1, Premier Suite One Mont Kiara, No 1, Jalan Kiara, Mont Kiara, 50480 Kuala Lumpur

Lewes

16192 Coastal Highway, Lewes, Delaware 19958, USA

software developers ahmedabad
ISO 9001:2015 Certified

Call us

Career: +91 90165 81674

Sales: +91 99747 29554

Email us

Career: hr@digiqt.com

Sales: hitul@digiqt.com

© Digiqt 2026, All Rights Reserved