Bank Loan CMA Data Maker, MPBF & Term Loan DSCR Studio

Prepare 4-year auto-tallied Bank CMA Data Reports (CC/OD/Mudra MPBF) or check Term Loan DSCR & FOIR Eligibility—with instant CA-style View & Download PDF statements.

1. Enterprise & Proposed Bank Facility Details
2. 4-Year Financial Figures (Enter in Exact ₹ — Balance Sheet Auto-Tallies!)
Financial Line Item (in ₹) FY 2024-25 (Audited) FY 2025-26 (Actual) FY 2026-27 (Estimated) FY 2027-28 (Projected)
Eligible MPBF (Nayak 20% Turnover)
₹ 12,80,000
Eligible MPBF (Tandon Method II)
₹ 22,67,609
Estimated Year Current Ratio
2.14x
Debt-Equity (TOL / TNW)
0.81x
✓ Balance Sheet 100% Tallied Across All 4 Years
⬇ Download 2-Page CMA PDF
Save your 2-Page CA-Style CMA Data Report PDF:
⬇ Download 2-Page CMA PDF

A. Term Loan & Projected Cash Accrual Inputs

B. FOIR Income-Based Max Loan Eligibility

Average Debt Service Coverage Ratio (DSCR)
2.09x
Minimum Yearly DSCR
1.88x
Monthly Term Loan EMI
₹ 53,735
Max Eligible Loan via FOIR Norm
₹ 23,26,241

⬇ Download DSCR Appraisal PDF

Year-by-Year Term Loan DSCR Appraisal Schedule

YearProjected PAT (₹)Gross Cash Accrual (₹)Interest (₹)Principal (₹)Total Debt Service (₹)DSCR
✓ Aligned with RBI MSME & Credit Underwriting Norms Reviewed by: HelYou24 Credit & Tax Documentation Desk Updated:
Quick Answer — How Bank CMA Data & MPBF Are Calculated: A Bank CMA (Credit Monitoring Arrangement) Report projects 4 years of Operating Profit, auto-tallied Balance Sheets, and Working Capital limits. For MSMEs up to ₹5 Crore, banks calculate Cash Credit eligibility using the RBI Nayak Committee Method at 20% of projected annual turnover (with 5% borrower margin), while Term Loans are appraised using DSCR ≥ 1.50x.

What Is CMA Data and Why Do Indian Banks Require Both MPBF & DSCR?

Whenever an Indian MSME proprietor, trader, manufacturer, or service enterprise applies for business credit, bank sanctioning officers evaluate two distinct repayment metrics depending on the loan type:

  • Working Capital Cash Credit (CC) / Overdraft (OD): Evaluated via 4-Year CMA Data & MPBF (Operating Statement, Tallied Balance Sheet, Current Ratio, and Nayak/Tandon Working Capital Gap).
  • Machinery, Shop, PMEGP, CGTMSE, or Mudra Term Loan: Evaluated via Debt Service Coverage Ratio (DSCR), verifying whether annual business cash accruals comfortably cover principal plus interest obligations every year.

Nayak Committee Turnover Method vs. Tandon Committee Method II

Appraisal ParameterNayak Committee Turnover MethodTandon Committee (2nd Method)
Target BorrowersMSME Working Capital limits up to ₹5 CroreLarger working capital limits (>₹5 Cr) or long cycles
Working Capital Need25% of Projected Annual TurnoverActual projected Total Current Assets (CA)
Borrower Margin5% of Projected Annual Turnover25% of Total Current Assets
Eligible Bank MPBF20% of Projected Annual TurnoverTotal CA − Trade Creditors − 25% of CA
Benchmark Current Ratio1.20x – 1.25xMinimum 1.33x

How Banks Calculate DSCR & FOIR Eligibility

Credit officers never judge Term Loan affordability using Net Profit alone because Depreciation is a non-cash accounting deduction and Term Loan Interest is part of the debt obligation being tested. Therefore, standard Indian banking appraisal uses: DSCR = (Net Profit After Tax + Depreciation + Annual Term Loan Interest) ÷ (Annual Term Loan Interest + Annual Principal Repayment). An average DSCR of 1.50x to 2.00x signals healthy cash-flow cushion, whereas a DSCR below 1.25x usually prompts the bank to extend loan tenure or reduce the sanctioned loan amount.

Indian MSME Business Loan, Cash Credit (CC/OD), CGTMSE & Mudra Benchmarks

Choosing the right credit facility before submitting your CMA Data and DSCR file can reduce annual interest costs by 2% to 5%:

MSME Credit Facility Typical Sanction Limit Indicative Bank Rate Primary Appraisal Metric
Secured Cash Credit (CC) / Working Capital OD ₹10 Lakh to ₹5 Crore+ 9.00% – 11.50% p.a. (Repo-linked) 4-Year CMA Data + 20% Turnover MPBF + Stock/Debtor Statement
PMMY Mudra Loan (Shishu / Kishore / Tarun Plus) Up to ₹20 Lakh 9.50% – 12.75% p.a. ITR Computation PDF + Simplified CMA / DSCR ≥ 1.25x
CGTMSE Collateral-Free MSME Term / WC Loan Up to ₹5 Crore (MSE units) 9.75% – 13.00% + CGTMSE Guarantee Fee Udyam Registration + Average DSCR ≥ 1.50x & TOL/TNW ≤ 3.0x
Loan Against Property (LAP) / Commercial Mortgage ₹15 Lakh to ₹10 Crore 8.90% – 10.75% p.a. (10–15 Yrs) Property LTV (60%–70%) + 3 Years ITR Computation + FOIR ≤ 55%

Systematic Bank Loan Document Checklist (India)

1. MSME Cash Credit (CC) / Overdraft (OD)

  • Last 2–3 Years ITR-V + 2-Page Computation of Income PDF
  • 4-Year Tallied CMA Data Report PDF (Generated above)
  • Udyam MSME Registration & GST Registration Certificate
  • Last 12 Months GSTR-3B Summary & Current A/c Bank Statement

2. Mudra (Kishore/Tarun) & CGTMSE Collateral-Free

  • PAN, Aadhaar, Shop Act / Trade License & Udyam Certificate
  • Latest ITR Computation PDF & 6–12 Months Bank Statement
  • DSCR Repayment Schedule & Machinery/Stock Supplier Quotation
  • Zero third-party collateral under CGTMSE cover up to eligible cap

3. Salaried / Self-Employed Home Loan

  • Salaried: Last 3 Months Salary Slips + 2 Years Form 16 & ITR Computation
  • Self-Employed: Last 3 Years ITR + Computation PDF + P&L / Balance Sheet
  • Check exact monthly installment on Home Loan EMI Schedule
  • Property Chain Deeds, Approved Map & Bank Legal/Valuation Report

4. Machinery / Commercial Project Term Loan

  • Year-by-Year Term Loan DSCR Appraisal PDF (Avg DSCR ≥ 1.50x)
  • Original Proforma Invoice / Authorised Dealer Quotation
  • Promoter Margin Proof (typically 15%–25% own contribution)
  • Pollution NOC / Factory License & Electricity Load Sanction (if mfg.)

Frequently Asked Questions (CMA Data & DSCR)

What is CMA Data in bank loan applications?

CMA stands for Credit Monitoring Arrangement. It is a standardized 4-year financial projection report mandated by RBI lending norms that banks review to assess historical performance, projected profitability, tallied Balance Sheet liquidity, and Maximum Permissible Bank Finance (MPBF) before sanctioning Cash Credit (CC), Overdraft (OD), Mudra, or Working Capital facilities.

What is DSCR (Debt Service Coverage Ratio) and when do banks check it?

While MPBF is used for revolving Working Capital (CC/OD) limits, banks use DSCR to underwrite Machinery, Shop, Factory, Mudra, or Commercial Term Loans. DSCR equals (Net Profit After Tax + Depreciation + Annual Term Loan Interest) divided by (Annual Term Loan Interest + Principal Installments). Indian PSU and private banks generally consider an Average DSCR of 1.50x to 2.00x strong, with 1.25x as the minimum acceptable floor.

How does the RBI / Nayak Committee 20% Turnover Method calculate CC limit?

For MSME units seeking working capital up to Rs. 5 Crore, the Nayak Committee Turnover Method assesses Gross Working Capital at 25% of projected annual sales, requires a minimum 5% borrower margin from Net Working Capital, and sanctions 20% of projected annual turnover as eligible Bank Cash Credit (MPBF).

How does FOIR determine personal, home, or business loan eligibility?

FOIR (Fixed Obligation to Income Ratio) measures the maximum share of your net monthly income (typically 45% to 55%) that can go toward servicing all monthly EMIs combined, including existing loans and the proposed loan.

Does HelYou24 automatically tally the 4-year Balance Sheet in CMA Data?

Yes. Our CMA engine links retained profit after drawings to Proprietor Capital / Net Worth and automatically balances liquid cash reserves so Total Capital & Liabilities equal Total Assets across Audited, Actual, Estimated, and Projected columns.

What documents must be submitted along with CMA Data for an MSME Bank Loan?

Standard MSME loan files require: (1) Last 2–3 years ITR Acknowledgements + 2-page Computation of Total Income PDFs, (2) 4-Year CMA Data Report PDF, (3) Udyam MSME Registration Certificate, (4) Last 12 months GSTR-3B & Bank Statements, (5) Business KYC/GST Certificate, and (6) Quotation/Project Report (if applying for a Term Loan).