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.
What You Will Learn on This Page
🔑 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?
Reading time: 3 minA 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.
Term Loan CMA vs Working Capital CMA
Know the differenceBoth use the same 7-sheet CMA structure, but the focus and extra schedules are completely different:
| Aspect | Working Capital CMA | Term Loan CMA |
|---|---|---|
| Purpose | Day-to-day operations (CC / OD limit) | Fund a fixed asset or project (machine, building) |
| Key Ratio | MPBF & Current Ratio | DSCR (Debt Service Coverage Ratio) |
| Projection Years | 1 actual + 2–6 years | Full loan tenure (often 8–11 years) |
| Extra Schedules | MPBF / Turnover Method | Repayment Schedule + DSCR + ISCR |
| Repaid Via | Rotating limit, renewed yearly | Fixed monthly EMIs |
Project Cost & Means of Finance
The starting point of every term loanBefore 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
All 8 Sheets in a Term Loan CMA
The most important sectionA 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:
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
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
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
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
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
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
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
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
The single most important numberDSCR (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.
DSCR
÷
(Term Loan Instalment + Interest)
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):
| Year | Cash Available (PAT + Dep + Int) | Debt Serviced (Principal + Int) | DSCR |
|---|---|---|---|
| Year 2 (ramp-up) | ₹62.00 | ₹70.32 | 0.88 |
| Year 3 | ₹165.00 | ₹78.71 | 2.10 |
| Year 4 | ₹167.95 | ₹78.71 | 2.13 |
| Year 5 | ₹180.36 | ₹78.71 | 2.29 |
| Year 6 | ₹194.20 | ₹78.71 | 2.47 |
| Year 7 | ₹209.39 | ₹78.71 | 2.66 |
| Average DSCR (whole tenure) | 3.34 — well above the 1.25 minimum ✓ | 3.34 | |
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
Beyond DSCRDSCR leads, but credit officers also confirm these before sanctioning a term loan:
| Ratio | Why It Matters for Term Loans | Bank Expects | Learn More |
|---|---|---|---|
| Average DSCR | Overall repayment comfort across tenure | Min 1.25 (avg 1.75–2+) | See above ↑ |
| ISCR | Ability to cover interest alone | Above 1.5 times | Interest coverage → |
| Debt-Equity Ratio | Loan funding vs promoter's own equity in the project | Not more than 3 : 1 | Means of finance ↑ |
| TOL / TNW | Leverage after taking the new loan | Below 3 (ideally ≤ 2) | TOL/TNW → |
| Promoter Contribution | Owner's skin in the project | 25%–40% of project cost | Means of finance ↑ |
| Current Ratio | Short-term liquidity stays healthy | Minimum 1.33 : 1 | Current ratio → |
Documents Required for Term Loan CMA
What to keep readyTerm loans need project details on top of the usual financials. Share these and we handle the rest:
How We Prepare Your Term Loan CMA in 24 Hours
Simple & hassle-freeFree Project Discussion
Share your project cost, contribution, and loan requirement on WhatsApp. We confirm feasibility and the DSCR you can realistically show.
Document Collection
Send your cost estimates, financials, and projections. We review and confirm what's needed.
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.
Review & Delivery
We walk you through the DSCR and key numbers on a call, then deliver a clean, ready-to-submit PDF report.
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.
✅ Thank you! Your CMA format is ready
Click below to open the complete sample CMA format on Google Drive.
View Full CMA Format →🔒 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
Term loan CMA doubts answeredContinue Learning
Ready to Fund Your Project?
Khemchandani Finance prepares bank-ready term loan CMA — with a strong, defensible DSCR — in 24 hours.
📞 +91 97554 06939 | ✉ Khemchandanifinance@gmail.com
Branch: Bhopal, Madhya Pradesh | Trusted Finance Partner Across India | khemchandanifinance.com