CMA Data & Project Report Guide for Bank Loan Approval

When an entrepreneur in Raipur approaches a bank for a ₹5 Crore Cash Credit limit expansion or a rice miller in Kalahandi applies for a ₹10 Crore Term Loan for a modern parboiled mill, the bank credit manager does not rely on audited profit and loss accounts alone. What credit processing cells (CPCs) and risk assessment committees mandate is a standardized, mathematically coherent Credit Monitoring Arrangement (CMA) Data package accompanied by a CA-certified Detailed Project Report (DPR).

In our practice at Rabi Agrawal & Associates across Chhattisgarh and Odisha, we frequently witness loan applications stalled or rejected not because the underlying business lacks commercial merit, but because the submitted CMA projections contain fundamental financial misalignments. A Current Ratio falling below bank norms, an inflated Debt Service Coverage Ratio (DSCR) that fails basic stress testing, or an improper estimation of Maximum Permissible Bank Finance (MPBF) immediately flags credit risk during automated underwriting.

This guide provides a practical, ground-level framework for preparing bank-ready CMA Data and Detailed Project Reports that navigate credit appraisal checks smoothly.

---

Practitioner Advisory: For professional assistance with compliance requirements, consult our specialized team for project report & CMA data consultant and project finance loan advisory.

What Is CMA Data and Why Do Banks Mandate It?

The Reserve Bank of India introduced the Credit Monitoring Arrangement framework to ensure that commercial banks systematically monitor the credit risk, working capital use, and debt-servicing capacity of commercial borrowers. CMA Data is a structured compilation of historical financial performance (typically 2 past audited financial years), current year estimated figures, and projected financials spanning 3 to 7 years into the future depending on the tenure of the requested loan facility.

Bank credit officers use CMA Data to answer three core questions:

1. Is the requested working capital limit proportionate to the borrower's operational cycle?
2. Will the project generate sufficient operational cash flow to repay principal and interest obligations without defaulting?
3. Is the promoter bringing in adequate long-term equity margin, or is the unit over-leveraged?

---

The 5 Core Statements of CMA Data

A standard CMA dossier consists of five distinct, interconnected analytical statements. Every line item across these statements must tie together smoothly; an error in raw material consumption in Form I will cascade into inventory valuation in Form II and skew fund flow dynamics in Form V.

Form I: Operating Statement

Form I details gross revenue, direct manufacturing costs, administrative overheads, finance costs, and net profitability.

• Gross Sales & Net Realization: Revenue projections must be backed by installed capacity, shift assumptions, and realistic order book estimates. Credit managers immediately reject hockey-stick growth projections (e.g., jumping from 40% capacity use in Year 1 to 90% in Year 2 without capital additions).
• Direct Costs & Raw Material Ratios: For steel rerolling mills in Urla or Bhanpuri, raw material (ingots/billets) forms 70–80% of sales. Credit officers check whether raw material cost percentages align with historical trends and industry averages.
• EBIDTA & Finance Costs: Operating profit before interest, depreciation, and tax must demonstrate sufficient buffer to cover term loan interest and Cash Credit interest charges.

Form II: Analysis of Balance Sheet

Form II rearranges the conventional balance sheet into financial appraisal classifications:

• Current Assets: Cash and bank balances, trade receivables (debtors), raw materials, work-in-progress, finished goods, and short-term advances.
• Current Liabilities: Trade payables (creditors), statutory liabilities (GST, TDS, PF/ESIC), short-term bank borrowings, and term loan installments due within the next 12 months.
• Net Worth: Paid-up capital, reserves and surplus, unencumbered promoter loans (treated as quasi-equity if subordinated to bank debt), less intangible assets.

Form III: Comparative Statement of Current Assets & Current Liabilities

Form III analyzes the net working capital (NWC) position and holding periods for inventory and receivables:

• Raw Material Holding Period: Calculated as (Average Raw Material Inventory / Raw Material Consumed) × 365 days`.
• Debtors Collection Period: Calculated as (Average Trade Receivables / Gross Credit Sales) × 365 days.
• Creditors Payment Period: Calculated as (Average Trade Payables / Gross Purchases) × 365 days.

If a civil contractor bidding for PWD projects in Chhattisgarh projects a 30-day collection period while state government departments historically take 90–120 days to clear running bills, credit officers will adjust the holding period downward and slash the sanctioned CC limit.

Form IV: Calculation of Maximum Permissible Bank Finance (MPBF)

Form IV establishes the statutory credit ceiling using RBI-approved assessment methodologies (discussed in detail below). It determines the total working capital gap and calculates the exact proportion to be funded by bank borrowing versus promoter equity margin.

Form V: Fund Flow Statement

Form V tracks how capital is sourced and deployed across reporting periods. Banks scrutinize this statement for diversion of funds—specifically, whether short-term working capital funds (like Cash Credit or trade payables) are being siphoned off to purchase long-term fixed assets (such as real estate or unapproved capital investments). If long-term uses exceed long-term sources, the unit displays a structural deficit that jeopardizes bank approval.

---

Working Capital Assessment Methodologies: Nayak vs. Tandon Committee

Banks assess working capital limits using two primary guidelines based on borrower size and nature of business:

1. Nayak Committee (Turnover Method)

Mandatory for MSME units with working capital limits up to ₹5 Crores:

• Total Working Capital Requirement: Assessed at a minimum of 25% of projected gross annual turnover.
• Bank Finance (MPBF): Fixed at 20% of gross annual turnover.
• Promoter Contribution: Minimum 5% of gross annual turnover brought in as net working capital (NWC).

Example: An MSME fabrication unit in Durg projecting a gross turnover of ₹4 Crore requires a total working capital of ₹1 Crore (25%). The bank provides ₹80 Lakhs (20%) as a Cash Credit limit, while the promoter must contribute ₹20 Lakhs (5%) from internal accruals or net working capital.

2. Tandon Committee Method (MPBF Method)

Applied for credit facilities exceeding ₹5 Crores or complex manufacturing setups:

• Method 1: Bank Finance = 75% of (Total Current Assets − Current Liabilities excluding Bank Borrowings). Promoter contributes 25% of the working capital gap.
• Method 2 (Standard Bank Preference): Bank Finance = (75% of Total Current Assets) − Current Liabilities excluding Bank Borrowings. Under Method 2, the borrower must finance at least 25% of total current assets out of long-term funds (Net Working Capital), ensuring a minimum Current Ratio of 1.33:1.

---

Benchmark Metrics for Bank Credit Appraisal Ratios

Bank credit processing cells compare key ratios against non-negotiable benchmark limits. The following table summarizes standard parameters applied by nationalized and private commercial banks during credit underwriting:

---

Deep Dive: Debt Service Coverage Ratio (DSCR) Calculation

Among all ratio checks, DSCR is the single most critical filter for term loan sanctions (such as machinery loans or factory building construction limits).

Statutory Formula: DSCR = (Net Profit After Tax + Depreciation + Term Loan Interest ÷ Term Loan Interest + Annual Principal Repayment)

Common Errors in DSCR Computation:

1. Including Cash Credit Interest in the Denominator: Cash Credit is an ongoing, revolving facility. Only Term Loan interest and Term Loan principal repayments belong in the DSCR denominator. CC interest is accounted for in Form I operating expenses.
2. Ignoring Unsecured Loan Servicing: If unsecured loans from promoters carry fixed repayment terms, banks insist on adding those interest payouts to the debt service obligation.
3. Unrealistic Depreciation Re-adds: Tax depreciation u/s 32 of the Income Tax Act must be accurately computed. Overstating depreciation artificially boosts numerator cash flows, which credit committees catch during financial verification.

---

Sensitivity & Stress Testing: Proving Project Resilience

Modern bank credit committees do not accept static projections. Credit appraisal memorandums (CAM) require sensitivity analysis to evaluate how project viability holds up under adverse economic shocks.

When preparing CMA Data, we perform three standard stress scenarios:

1. Raw Material Cost Escalation (+10%): Demonstrates whether operating margins can absorb input cost shocks (such as paddy price increases during lean seasons in Kalahandi or scrap metal spikes in Raipur) without dropping the DSCR below 1.25.
2. Capacity use Underperformance (-15%): Assesses the Break-Even Point (BEP). If a unit’s BEP exceeds 65% of installed capacity, credit managers treat the project as high risk.
3. Stretched Collection Cycles (+30 Days): Shows the impact on Cash Credit use. If a 30-day delay in customer payments forces the Current Ratio below 1.10, the proposal requires additional promoter margin support or liquid collateral.

---

Preparing a CA-Certified Detailed Project Report (DPR)

While CMA Data provides the numerical framework, the Detailed Project Report (DPR) tells the qualitative operational story. A loan application submitted without a structured DPR creates unnecessary credit queries and processing delays.

Key Sections of a Bank-Ready DPR:

1. Executive Summary & Promoter Profile: Background, experience, CIBIL scores (minimum 750 required for individual promoters/partners), existing business interests, and Net Worth statements backed by CA certificates.
2. Project Technical Viability: Location advantages, raw material availability, utility supply (power load sanctions from CSPDCL in CG or TPCODL in Odisha), plant layout, and machine procurement details.
3. Market Analysis & Order Book Position: Existing purchase orders, target client base, demand-supply gaps, and competitive positioning against regional manufacturers.
4. Means of Finance & Capital Cost Schedule: Detailed breakup of land, civil construction (certified by a Chartered Engineer), plant and machinery, contingency buffers, and margin money for working capital.
5. Statutory & Environmental Approvals Status:
   • Consent to Establish (CTE) / Consent to Operate (CTO) from Chhattisgarh Environment Conservation Board (CECB) or Odisha State Pollution Control Board (OSPCB).
   • Factory License, Industrial Power Connection Approval, and Local Body NOCs.
   • RERA Registration details for real estate and commercial building development projects.
6. Subsidy & Financial Incentive Integration: Integration of state industrial policy benefits—such as interest subsidies, capital investment subsidies, and electricity duty exemptions under the Chhattisgarh Industrial Policy (2024-29) or Odisha IPR 2022.

---

Sector-Specific Credit Appraisal Considerations in CG & Odisha

Standard boilerplate financial projections fail because credit officers evaluate specific regional operational risks. Here is how sector-specific nuances must be addressed in your CMA and DPR:

1. Parboiled Rice Milling Units (Kalahandi, Jayapatna & Raipur Belts)

• Seasonality & Raw Material Procurement: Paddy procurement peaks during Kharif (November–March) and Rabi (May–June). CMA inventory cycles must reflect heavy paddy stock buildup during Q3 and Q4, causing temporary spikes in CC use.
• Custom Milling Rice (CMR) Realization: Working capital projections must account for statutory outturn ratios (67% for parboiled rice), milling charges paid by state procurement agencies (MARKFED/OSCSC), and holding periods for gunny bags and byproduct sales (bran and husk).

2. Steel Rerolling & Structural Fabrication Mills (Urla & Bhanpuri, Raipur)

• Power Tariffs & Furnace Efficiency: Direct power costs account for a massive share of conversion expense. Projections must explicitly show CSPDCL power tariff slabs, power factor rebates, and specific energy consumption per metric ton of finished steel.
• Volatile Input Pricing: Steel billets and scrap rates fluctuate sharply. CMA Form I projections must incorporate dynamic raw material cost formulas rather than static annual assumptions.

3. Civil & PWD Infrastructure Contractors

• Bank Guarantee (BG) Facilities: Contractors require financial and performance Bank Guarantees alongside Cash Credit limits. CMA schedules must detail cash margins (10–25% fixed deposits) pledged against BG limits.
• Receivables & Retention Money: State PWD, Irrigation Department, and PMGSY contracts lock up 5–10% of bill values as retention money until defect liability periods expire. Form III debtor schedules must separate trade receivables from retention security deposits to prevent artificial liquidity inflation.

---

CMA Data Bank Loan Appraisal & Approval Workflow

Understanding the step-by-step path of a credit dossier through a bank's appraisal machinery helps promoters anticipate credit queries and minimize approval lead times:

---

Practical Example: Nayak Committee Working Capital Assessment

Below is a practical comparison of working capital limits assessed under the Nayak Committee Turnover Method for a medium-scale MSME unit:

---

How Rabi Agrawal & Associates Facilitates Bank Loan Approvals

Preparing a CMA report is not a clerical exercise of filling numbers into a software template; it is a financial engineering process that establishes borrower credibility before bank sanctioning authorities.

At Rabi Agrawal & Associates, our dedicated project finance desk brings ground-level experience in structuring bank dossiers for industrial, commercial, and MSME clients across Chhattisgarh and Odisha. Our advisory services include:

• End-to-End CMA Data & DPR Preparation: Drafting customized financial projections, sensitivity analyses, and bank-ready project reports certified by practicing Chartered Accountants.
• TEV & Feasibility Study Structuring: Aligning technical parameters with financial metrics for major term loan and working capital requests.
• Bank Representation & Query Resolution: Interacting directly with bank credit processing cells (CPCs), credit officers, and loan sanction committees to resolve financial ratio queries efficiently.
• Subsidy & Incentive Integration: Mapping financial proposals to State Industrial Policies to maximize capital subsidies, interest subventions, and duty exemptions.