Chat on WhatsApp
CMA Data Knowledge Series

CMA Data for Term Loan — DSCR, Format & Project Report Explained

Understand exactly what your bank needs to sanction a term loan — the project cost, means of finance, repayment schedule, and the all-important DSCR.

DSCR Explained
Means of Finance
Repayment Schedule
8 Sheets Covered
Get Free Consultancy for 100% Approval

🔑 Want to See the Complete CMA Format?

The full sample format — every sheet, with real numbers — is yours free. Just fill the quick form below and it unlocks instantly.

What is CMA Data for a Term Loan?

A term loan is a loan taken for a fixed period to fund a specific asset or project — buying machinery, constructing a building, setting up a hotel, or expanding a factory. It is repaid in fixed monthly EMIs over the loan tenure.

CMA Data for a term loan is the financial report that proves to the bank two things: (1) the project is viable, and (2) the business will generate enough cash to repay the EMIs comfortably for the entire tenure. Unlike working capital CMA, a term loan CMA projects financials across the full repayment period — often 8 to 11 years.

The heart of a term loan CMA is the DSCR — Debt Service Coverage Ratio. If your DSCR is below the bank's threshold, the loan is rejected or reduced, no matter how promising the project looks. We explain DSCR in full further down this page.

Term Loan CMA vs Working Capital CMA

Both use the same 7-sheet CMA structure, but the focus and extra schedules are completely different:

AspectWorking Capital CMATerm Loan CMA
PurposeDay-to-day operations (CC / OD limit)Fund a fixed asset or project (machine, building)
Key RatioMPBF & Current RatioDSCR (Debt Service Coverage Ratio)
Projection Years1 actual + 2–6 yearsFull loan tenure (often 8–11 years)
Extra SchedulesMPBF / Turnover MethodRepayment Schedule + DSCR + ISCR
Repaid ViaRotating limit, renewed yearlyFixed monthly EMIs
Want the working capital side instead? Read our complete CMA Data for Working Capital Loan guide →

Project Cost & Means of Finance

Before anything else, a term loan CMA states the total project cost and how it will be funded — called the Means of Finance. The bank funds a part (the term loan); you contribute the rest (promoter's margin). Banks typically expect the promoter to fund 25%–40% of the project.

Real Example — Hotel & Resort Project

Total Project Cost
₹7.98 Cr
Land, civil work, interiors, equipment
Bank Term Loan
₹4.75 Cr
≈ 60% — funded by the bank
Promoter's Contribution
₹3.23 Cr
≈ 40% — your own margin
Why the margin matters: A higher promoter contribution lowers the loan amount, reduces EMIs, improves DSCR, and gives the bank confidence that you have real stake in the project. Too low a margin is one of the most common reasons term loan files get rejected.
Debt-Equity Ratio: This means-of-finance split also decides your Debt-Equity Ratio (Term Loan ÷ Promoter's Equity). Banks expect this to be not more than 3 : 1 — your equity must be at least one-third of the loan. In the example above, ₹4.75 Cr loan against ₹3.23 Cr equity gives a healthy ratio of about 1.47 : 1.

All 8 Sheets in a Term Loan CMA

A term loan CMA carries the standard 7 CMA sheets plus a loan repayment schedule — and the financial indicators sheet adds DSCR & ISCR. Here is each one:

1

Operating Statement

The projected Profit & Loss across the entire loan tenure — revenue ramping up as the project becomes operational.

  • Revenue streams (e.g. rental, restaurant income)
  • Cost of sales, power, labour, maintenance
  • Depreciation & interest on the new term loan
  • Net profit / loss — often a loss in year 1, turning profitable
A first-year or moratorium-year loss is normal for new projects — banks expect the ramp-up. What matters is profitability and DSCR from the repayment years onward.
2

Liabilities Statement

Shows the new term loan split between current and term portions, plus net worth.

  • Term Loan (New) under Term Liabilities — reducing each year
  • Instalments due within 1 year shifted to Current Liabilities
  • Promoter's capital additions & retained profit in Net Worth
3

Assets Statement

The asset created by the project, depreciating year on year, plus current assets.

  • Gross Block (building, equipment) less depreciation = Net Block
  • Capital Work-in-Progress during construction phase
  • Cash, receivables, and other current assets
4

Performance & Financial Indicators

All key ratios — and for term loans this sheet highlights repayment-capacity ratios.

  • TOL/TNW, Current Ratio, PBDIT/Interest
  • Cash Accrual (profit + depreciation) — the source of EMI
  • ROCE, PAT/Sales, asset turnover
All ratios explained in detail →
5

DSCR & ISCR Statement

The defining schedule of a term loan CMA — proving the business can service its debt.

  • DSCR — covers both principal + interest repayment
  • ISCR — Interest Coverage Ratio (interest only)
  • Year-wise DSCR plus the all-important Average DSCR
See DSCR explained with example ↓
6

Fund Flow Statement

Sources & uses of funds across the project life, and movement of net worth.

  • Sources: profit, depreciation, capital, term loan drawdown
  • Uses: fixed asset purchase, term loan repayment, drawings
  • Long-term surplus / deficit and TNW movement
7

Depreciation Chart

Asset-wise depreciation for every year of the loan, as per the Income Tax Act.

  • Civil building & interiors @ 10%
  • Plant, equipment, HVAC, utilities @ 15%
  • Opening WDV, additions, depreciation, closing WDV per year
8

Loan Repayment Schedule

A month-by-month EMI amortisation table for the entire tenure — unique to term loans.

  • Loan amount, interest rate, tenure & EMI
  • Monthly split of principal vs interest
  • Opening & closing balance until the loan reaches zero
  • Supports the moratorium / repayment holiday period

DSCR — The Ratio That Decides Term Loan Approval

DSCR (Debt Service Coverage Ratio) measures whether your business generates enough cash to pay its loan obligations — both principal and interest — each year. It is the first thing a credit officer checks on a term loan file.

Repayment Capacity

DSCR

(Net Profit + Depreciation + Interest on Term Loan)
÷
(Term Loan Instalment + Interest)
Bank Expects Min 1.25  |  Avg 1.75–2+

What it means: A DSCR of 1.25 means for every ₹1 of loan repayment due, the business earns ₹1.25 of cash — a 25% safety cushion, which is the minimum banks accept. The higher the DSCR, the more comfortably you repay even in a weak year.

Two numbers banks look at: the year-wise DSCR (each individual year should ideally stay above 1.25 once repayment starts) and the Average DSCR over the whole tenure (the headline number for sanction).

Numerator = cash available: Net Profit + Depreciation (a non-cash expense added back) + Interest. Denominator = debt to be serviced: the principal instalment + interest for that year.

Real Example — DSCR of the Hotel Project

Here is how the DSCR builds up over the repayment years of the ₹4.75 Cr term loan example (figures in ₹ Lacs):

YearCash Available (PAT + Dep + Int)Debt Serviced (Principal + Int)DSCR
Year 2 (ramp-up)₹62.00₹70.320.88
Year 3₹165.00₹78.712.10
Year 4₹167.95₹78.712.13
Year 5₹180.36₹78.712.29
Year 6₹194.20₹78.712.47
Year 7₹209.39₹78.712.66
Average DSCR (whole tenure)3.34 — well above the 1.25 minimum ✓3.34
Notice Year 2 has a DSCR below 1 — that is the ramp-up / moratorium phase when the project is just starting. Banks accept this if the early years are covered by a repayment holiday and the average DSCR stays strong. Structuring the moratorium correctly is a key part of a well-prepared term loan CMA.
Closely related: ISCR (Interest Service Coverage Ratio) checks cash against interest alone. It is always higher than DSCR. Learn how every ratio is read in our CMA Ratios guide →

Planning a Project or Expansion?

Send us your project cost and loan requirement on WhatsApp. We'll tell you the DSCR you can expect and whether your project is bank-ready — free.

Other Ratios Banks Check on a Term Loan

DSCR leads, but credit officers also confirm these before sanctioning a term loan:

RatioWhy It Matters for Term LoansBank ExpectsLearn More
Average DSCROverall repayment comfort across tenureMin 1.25 (avg 1.75–2+)
ISCRAbility to cover interest aloneAbove 1.5 times
Debt-Equity RatioLoan funding vs promoter's own equity in the projectNot more than 3 : 1
TOL / TNWLeverage after taking the new loanBelow 3 (ideally ≤ 2)
Promoter ContributionOwner's skin in the project25%–40% of project cost
Current RatioShort-term liquidity stays healthyMinimum 1.33 : 1

Documents Required for Term Loan CMA

Term loans need project details on top of the usual financials. Share these and we handle the rest:

🏗
Project Cost EstimateQuotations for land, civil work, machinery, interiors — the basis of project cost
💵
Means of FinanceHow much you'll contribute vs how much loan you need
📄
Last 2–3 Years ITR & FinancialsFor existing businesses — to establish track record
📊
Revenue Projections / Business PlanExpected occupancy, capacity, pricing, or sales for the new project
🏢
Registration & KYCGST, Udyam (MSME), partnership deed / incorporation, PAN, Aadhaar
📁
Loan TermsRequested amount, interest rate, tenure, and the bank you're applying to
New project, no past financials? Term loans for greenfield projects are assessed entirely on projected viability and DSCR. We build realistic, defensible projections that satisfy bank appraisal norms. WhatsApp us to discuss →

How We Prepare Your Term Loan CMA in 24 Hours

1

Free Project Discussion

Share your project cost, contribution, and loan requirement on WhatsApp. We confirm feasibility and the DSCR you can realistically show.

2

Document Collection

Send your cost estimates, financials, and projections. We review and confirm what's needed.

3

Expert Preparation

We build all 8 sheets — operating statement, balance sheet, DSCR & ISCR, fund flow, depreciation, and the full EMI repayment schedule — tuned to your bank's format and tenure.

4

Review & Delivery

We walk you through the DSCR and key numbers on a call, then deliver a clean, ready-to-submit PDF report.

5

Unlimited Revisions

If the bank's appraisal team asks for changes in tenure, moratorium, or projections, we revise free until your loan is sanctioned.

Unlock the Complete CMA Format — Free

Fill the form and get the complete CMA format instantly. Want free consultancy too? Just tick the box — it’s optional.


🔒 Don't Leave Without the Real Format

Reading helps — but seeing the actual sample CMA makes it click. Fill the short form and we'll instantly unlock the complete format samples.

Frequently Asked Questions

What is a good DSCR for a term loan?
Most banks require a minimum DSCR of 1.25 in each repayment year and an average DSCR of around 1.75 to 2 over the loan tenure. A higher average DSCR (like 2.5–3) makes approval much easier and may help you negotiate a better interest rate. Early ramp-up years can have a lower DSCR if a moratorium covers them.
How many years should a term loan CMA project?
A term loan CMA must cover the entire loan tenure plus the moratorium period. For a 7–10 year loan, that means projecting 8 to 11 years of financials. Each year's DSCR is shown so the bank can see repayment comfort throughout the loan life.
What is a moratorium and how does it affect DSCR?
A moratorium (repayment holiday) is an initial period — often 6 to 18 months — where you pay only interest, or nothing, while the project becomes operational. It allows a low or negative DSCR in the early ramp-up phase without hurting the file, because principal repayment starts only once the business generates cash. We structure the moratorium correctly in your repayment schedule.
How much promoter contribution do I need?
Banks generally expect the promoter to fund 25% to 40% of the total project cost as margin money. The exact figure depends on the project type, your profile, and the bank's policy. A higher contribution lowers your EMI, improves DSCR, and strengthens the application.
Can I get a term loan for a brand-new project with no history?
Yes. Greenfield (new) projects are assessed on projected viability and DSCR rather than past financials. Many banks and schemes (MUDRA, CGTMSE, Stand-Up India, PMEGP) fund new projects. The key is a credible, well-documented project report with realistic projections — exactly what we prepare.
Do you provide the term loan CMA in Excel?
We deliver a clean, ready-to-submit PDF report formatted the way your bank expects — including the operating statement, DSCR/ISCR, depreciation chart, and full repayment schedule. We explain every key number to you on a call before submission.

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top