CMA Data for Working Capital Loan — Format, Sheets & Calculation Explained
Everything you need to understand CMA Data before applying for a Cash Credit, Overdraft, or Working Capital limit from any bank in India.
📄 What You Will Learn on This Page
- What is CMA Data for Working Capital?
- Why Banks Need CMA Data Before Sanctioning WC Limit
- All 7 Sheets in CMA Data — Format & What to Fill
- How Banks Calculate Your Working Capital Limit (MPBF)
- Key Financial Ratios Banks Check & Acceptable Limits
- Documents Required for CMA Data Preparation
- How We Prepare Your CMA in 24 Hours
- Frequently Asked Questions
🔑 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 Working Capital?
Reading time: 3 minCMA stands for Credit Monitoring Arrangement. CMA Data is a structured financial report that banks in India require before sanctioning any working capital facility — Cash Credit (CC), Overdraft (OD), or Working Capital Demand Loan (WCDL).
It was introduced by the Reserve Bank of India based on the recommendations of the Tandon Committee and later refined by the Chore Committee. The report presents your business's financial health across past, present, and projected future years — all in one standardised format that every bank understands.
Working Capital Loans That Require CMA Data
Any of the following facilities from any scheduled bank will require CMA Data when the limit exceeds ₹10 lakhs:
- Cash Credit (CC) — rotating limit against stock and debtors
- Overdraft (OD) — limit against property or FD security
- Working Capital Demand Loan (WCDL) — short-term repayable limit
- Bill Discounting / Invoice Financing
- Packing Credit / Pre-shipment Finance (for exporters)
Don't Want to Prepare CMA Data Yourself?
We prepare bank-ready CMA Data in 24 hours for just ₹999. Free consultation — no obligation.
Why Banks Need CMA Data Before Sanctioning Working Capital
Reading time: 2 minBanks are not just checking your creditworthiness — they are calculating the exact amount of working capital your business genuinely needs. This prevents two major problems:
Giving you more limit than your business needs leads to misuse of funds and creates an NPA (Non-Performing Asset) risk for the bank.
Giving you less than required means your business can't operate smoothly, and you'll default on the loan anyway.
The CMA Data gives the bank a scientific basis for the right limit amount using your actual business numbers — not guesswork. This is why a well-prepared CMA Data directly improves your chances of loan approval and getting the right limit sanctioned.
All 7 Sheets in CMA Data — Format & What to Fill
Reading time: 8 min — This is the most important sectionA complete CMA Data for Working Capital consists of 7 mandatory financial statements. Each sheet must cover 1 actual year + 6 projected years (7 columns total). Here is a detailed explanation of each sheet:
Operating Statement (Profit & Loss Projection)
This is your Profit & Loss Statement in projected form. It shows the bank how your business earns money and what it spends, year by year.
Key rows to fill:
- Gross Sales (Sale of Goods / Services separately)
- Less Taxes / Deductions → Net Sales
- % rise or fall in Net Sales (YoY growth %)
- Cost of Sales (Raw Material, Power, Direct Labour, Depreciation)
- Cost of Production and Cost of Goods Sold
- Salary, Admin & General Expenses
- Operating Profit Before Interest
- Interest on Working Capital Loan
- Net Profit / Loss After Tax
- Drawings / Dividend Paid
- Retained Profit (added back to capital)
Liabilities Statement (Balance Sheet — Liabilities Side)
This sheet shows all your financial obligations — what your business owes to banks, suppliers, and other parties.
Three parts of this sheet:
- Current Liabilities: Bank CC/OD limit, Sundry Creditors (suppliers), advance from customers, other provisions due within 1 year
- Term Liabilities: Unsecured loans, vehicle loans, term loans, deferred payment credits (due after 1 year)
- Net Worth: Opening Capital + Additions − Deductions + Retained Profit from Operating Statement
Assets Statement (Balance Sheet — Assets Side)
The mirror of the Liabilities sheet — every rupee in liabilities must be matched by an equal rupee in assets. Total Assets = Total Liabilities.
What to include:
- Current Assets: Cash & Bank Balance, Trade Receivables (Debtors), Closing Inventory (Stock), Advance to suppliers, TDS receivable
- Non-Current Assets (Fixed Assets): Gross Block (land, building, machinery, furniture) minus Accumulated Depreciation = Net Block
- Other Non-Current Assets: Security deposits, DTA, debtors > 6 months
Performance & Financial Indicators (Key Ratios)
This is the sheet bank managers turn to first. It automatically calculates all key ratios from Sheets 1–3. No manual entry is needed — these are formula-driven.
Three ratio groups:
- General Indicators: Turnover, Net Profit, Cash Accrual, Net Worth, NWC, Current Ratio, TOL/TNW
- Efficiency Ratios: Net Sales/TTA, Operating Cost %, Bank Finance/Current Assets %, Inventory+Receivable days
- Risk Rating Ratios: Current Ratio, TOL/TNW, PBDIT/Interest (Interest Coverage), PAT/Sales, ROCE, INV+REC/Sales days
Fund Flow Statement
This sheet tracks where money came from and where it went in your business — the movement of long-term funds. Banks use this to check financial discipline.
Two parts:
- Sources of Funds: Net Profit After Tax, Depreciation added back, Increase in Capital, Increase in Term Loans, Decrease in Fixed Assets
- Uses of Funds: Purchase of Fixed Assets, Repayment of Term Loans, Drawings/Dividend paid
Below the fund flow, the Movement of TNW (Total Net Worth) shows how your net worth changes year to year — this is a key indicator of business health.
Working Capital Assessment — MPBF Calculation
This is the most critical sheet for working capital loans. It calculates your Maximum Permissible Bank Finance (MPBF) — the exact limit you are eligible for.
Two methods calculated:
- Method 1 (Traditional): Based on actual current assets, current liabilities, and margin money
- Method 2 (Turnover Method — Nayak Committee): Based on 25% of projected annual turnover
The bank will sanction the lower of the two MPBF figures. Your requested loan amount must not exceed this.
🔗 See MPBF calculation with example below ↓Depreciation Chart
A year-by-year breakdown of depreciation on all fixed assets — required to support the depreciation figures used in Sheets 1 and 3.
Columns in this sheet:
- Asset name (Furniture, Machinery, Building etc.)
- Opening written-down value
- Additions during the year
- Applicable depreciation rate (as per Income Tax Act)
- Depreciation for assets >180 days in use
- Depreciation for assets <180 days (half rate)
- Closing written-down value (= Opening − Dep + Additions)
How Banks Calculate Your Working Capital Limit (MPBF)
Reading time: 4 minBanks do not just accept the loan amount you ask for. They calculate the Maximum Permissible Bank Finance (MPBF) — and will only sanction up to this amount. There are two methods:
Method 1 — Traditional Method
Used for businesses with established financial history- Total Current Assets (TCA) — Inventory + Receivables + Cash & Bank + Other CA
- Less: Current Liabilities (Other than Bank Borrowing) — Sundry Creditors, Provisions etc.
- Working Capital Gap = TCA − CL (excluding bank limit)
- Less: Margin — 25% on Inventory, 40% on Receivables (borrower's own contribution)
- MPBF = Working Capital Gap − Margin
Method 2 — Turnover Method
Nayak Committee — used for limits up to ₹5 crore (most MSMEs)- Projected Annual Turnover (A)
- 25% of Turnover (B) = Gross Working Capital Requirement
- 5% of Turnover (C) = Minimum margin to be contributed by borrower
- Net Working Capital available (D) = Current Assets − Current Liabilities
- E = Higher of C or D (bank takes the higher margin requirement)
- MPBF = B − E
Example: MPBF Calculation for a ₹54 Lakh Turnover Business
| Particulars | Method 1 (Traditional) | Method 2 (Turnover) |
|---|---|---|
| Projected Turnover | ₹54.00 Lacs | ₹54.00 Lacs |
| Total Current Assets | ₹13.43 Lacs | 25% of Turnover = ₹13.50 Lacs |
| Less: Current Liabilities (excl. bank) | ₹0.11 Lacs | — |
| Working Capital Gap | ₹13.32 Lacs | — |
| Margin Required | ₹3.05 Lacs (25% inv + 40% rec) | ₹3.32 Lacs (NWC, higher than 5%) |
| MPBF (Max Bank Finance) | ₹10.27 Lacs | ₹10.18 Lacs |
| Bank Sanctions (Lower of Two) | ₹10.00 Lacs ✓ | |
Key Financial Ratios Banks Check in CMA Data
Reading time: 4 minBanks do not just look at profit and turnover. They run your CMA Data through a set of financial ratios that determine your credit risk. Here are the most critical ones — what they mean, how they are calculated, and what range banks accept:
| Ratio Name | Formula | Bank Expects | If Below Range | Learn More |
|---|---|---|---|---|
| Current Ratio | Current Assets ÷ Current Liabilities | Minimum 1.33 : 1 | Indicates liquidity risk — may reduce sanctioned limit | What is good Current Ratio? → |
| TOL/TNW | Total Outside Liabilities ÷ Total Net Worth | Below 3 : 1 (ideally ≤ 2) | High leverage — bank considers you over-borrowed | TOL/TNW explained → |
| PBDIT / Interest | Profit before Dep, Interest & Tax ÷ Annual Interest | Minimum 1.5 times | Cannot comfortably service interest — high default risk | Interest Coverage → |
| Net Working Capital (NWC) | Current Assets − Current Liabilities (excl. bank) | Must be positive & growing | Negative NWC = business running on borrowed short-term funds | NWC explained → |
| PAT / Net Sales % | Net Profit After Tax ÷ Net Sales × 100 | Higher the better (min 5%+) | Very thin margins suggest business cannot sustain repayment | Profit Margin → |
| ROCE % | PBDIT ÷ Total Assets × 100 | Above 10% (higher = better) | Poor return on assets — funds not being used efficiently | ROCE Guide → |
| Inventory + Receivables Days | (Inventory + Debtors) ÷ Net Sales × 365 | Lower the better (under 90 days) | Too much money stuck in stock/debtors — cash flow risk | INV+REC Days → |
| Operating Cost / Sales % | Total Operating Cost ÷ Net Sales × 100 | Below 90% (ideally 75-85%) | Very high cost structure — profitability at risk | Cost Ratio → |
Not Sure if Your Business Ratios Are Bank-Ready?
Share your numbers with us on WhatsApp. We'll tell you honestly whether your financials qualify — for free.
Documents Required to Prepare CMA Data
Reading time: 2 minYou only need to share these basic documents with us. We handle all the preparation, calculations, and formatting.
How Khemchandani Finance Prepares Your CMA Data in 24 Hours
Reading time: 2 minWe have prepared CMA Data for hundreds of businesses across Madhya Pradesh and India — from small kirana stores to manufacturing units. Here is our simple, hassle-free process:
Free WhatsApp Consultation
Tell us about your business, the loan amount, and which bank you are applying to. We'll confirm your eligibility and what documents to arrange — completely free, no obligation.
Document Submission
Share your ITR, balance sheet, GST returns, and bank statements with us securely via WhatsApp or email. We review and confirm receipt.
Expert CMA Preparation
Our financial expert prepares all 7 sheets — Operating Statement, Liabilities, Assets, Financial Indicators, Fund Flow, MPBF Assessment, and Depreciation Chart. Projections are kept realistic and justified so the bank credit team is satisfied.
Review Call & Delivery
We walk you through the key numbers on a quick call. You receive the final CMA Data as a clean, ready-to-submit PDF report — formatted exactly the way your bank expects it.
Unlimited Revisions Until Sanctioned
If your bank manager asks for any changes — revised projections, different format, additional ratios — we revise at no extra cost. We stay with you until your loan is sanctioned.
Banks We Prepare CMA Data For
Simple Pricing — No Hidden Charges
One price. Everything included. No surprises.
- All 7 CMA Sheets — Complete Report
- Bank-specific formatting (SBI / HDFC / Canara etc.)
- Delivered in 24 hours
- Ready-to-submit PDF report
- Unlimited revisions until loan is sanctioned
- Free consultation call included
- 7-Day Money Back Guarantee
🔒 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 about CMA Data for Working Capital
Common questions answered by our CMA expertsUnlock 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 →