IBA CMA Data Format in Excel — Download Credit Monitoring Arrangement Model
Professional financial modeling workbook incorporating all 7 statutory IBA schedules, Tandon Method II MPBF algorithms, 10-year term debt amortization, and DSCR stress testing required for PSU bank consortium sanctions.
What are the 7 mandatory statements in an IBA-compliant CMA Data model?
The Indian Banks' Association (IBA) Credit Monitoring Arrangement (CMA) framework mandates 7 interconnected statements: Form I (Existing & Proposed Credit Limits), Form II (Operating Statement / P&L Projections), Form III (Analysis of Balance Sheet Assets & Liabilities), Form IV (Comparative Current Assets & Liabilities), Form V (Working Capital Gap & MPBF Calculation under Tandon Method II), Form VI (Funds Flow Statement), and Form VII (Key Financial Ratios including DSCR, FACR, Current Ratio, and TOL/TNW).
Unlocked IBA CMA Data Model for CFOs & Promoters
Unlike generic internet templates that trigger instant bank audit rejections due to unlinked balance sheet formulas, CreditCares' CMA workbook features dynamic cross-sheet validations, historical trend consistency checks, and automated MPBF calculations tailored for SBI, PNB, Bank of Baroda, and Canara Bank syndications.
Unlock IBA CMA Data Excel Template
Enter your details to receive the unlocked Excel workbook and connect with CreditCares' financial modeling desk.
CMA Model Unlocked
Your reference request has been logged with CreditCares Syndication Desk.
Connect with Desk on WhatsAppDetailed Breakdown of the 7 CMA Statements
Each schedule fulfills a specific statutory appraisal requirement under RBI Master Directions on Corporate Lending.
Form I: Existing & Proposed Credit Limits
Consolidates fund-based limits (Cash Credit, WCDL, Term Loans) and non-fund-based limits (Letters of Credit, Bank Guarantees) across all consortium member banks, detailing sanctioned vs outstanding balances, margins, and primary/collateral security charges.
Form II: Operating Statement (P&L Analysis)
Audits historical gross sales, excise/GST, raw material consumption, power & fuel, direct wages, and SGA expenses over 3 past financial years, modeling realistic 5-to-7 year revenue trajectories supported by capacity utilization and order-book visibility.
Form III & IV: Balance Sheet Analysis & Current Asset Breakdown
Classifies liabilities into Tangible Net Worth (TNW), Quasi-Equity (unsecured promoter loans subordinated to bank debt), Long-Term Debt, and Other Current Liabilities (OCL). Form IV evaluates inventory holding periods and debtor collection cycles against industry norms.
Form V: Working Capital Gap & Tandon Method II MPBF
Computes the statutory Maximum Permissible Bank Finance (MPBF). Mandates that at least 25% of Total Current Assets (TCA) must be funded via long-term Net Working Capital (NWC), with the bank financing a maximum of 75% of the Working Capital Gap.
Form VI & VII: Funds Flow Statement & Ratio Analysis
Form VI traces cash generation and capex deployment, ensuring no diversion of short-term bank limits into long-term assets. Form VII benchmarks DSCR (≥ 1.30x), Current Ratio (≥ 1.33x), Total Outside Liabilities / Tangible Net Worth (TOL/TNW ≤ 3.0x), and Fixed Asset Coverage Ratio (FACR ≥ 1.25x).
Why Generic CA Templates Fail Bank Risk Audits
The most frequent rejection trigger in bank appraisal cells is mathematically unlinked CMA projections—where projected sales growth fails to reconcile with raw material stock days, or where current liabilities fail to tie back to MCA-audited balance sheet schedules. CreditCares conducts pre-submission algorithmic stress tests guaranteeing zero formula breaks.
Frequently Asked Questions: CMA Data Preparation
Is CMA Data mandatory for all bank loans in India? ▼
Yes, for all commercial borrowings, term loans, and working capital limits exceeding ₹5 Crore across Scheduled Commercial Banks. For exposures above ₹25 Crore, multi-bank consortiums mandate comprehensive IBA-format CMA data coupled with an independent Techno-Economic Viability (TEV) study.
Can unsecured promoter loans be counted as Net Working Capital (NWC)? ▼
Yes, provided the promoter submits a formal Non-Withdrawal Undertaking to the bank stipulating that the unsecured loans will remain subordinated to bank debt throughout the facility tenor and will not be withdrawn without prior written bank approval.
How many years of projections are required for a project loan CMA? ▼
For working capital renewals, banks typically require 2 years actuals, 1 year estimates, and 1 year projections. For term loans and project finance, the CMA must cover the entire door-to-door loan repayment life—typically 7 to 15 years—aligning with the TEV cash flow model.
Commission a Bankable CMA Data & DPR Package
Work with CreditCares' Senior Ex-Bankers and Chartered Accountants. We structure end-to-end CMA data, TEV appraisals, and loan application files tailored for swift credit committee sanctions.