Chat on WhatsApp
Complete Guide — Free to Read

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.

7 Sheets Explained
MPBF Calculation
Bank Ratios Guide
Real Format Walkthrough
Need Help? WhatsApp Us Free

🔑 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?

CMA 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.

Think of CMA Data as a financial story of your business. It tells the bank: where your money comes from, where it goes, what your assets and liabilities are, and most importantly — whether you can repay the working capital limit you are asking for.

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)
For limits below ₹10 lakhs (MUDRA Shishu/Kishor loans), full CMA may be waived. However, a projected balance sheet is still strongly recommended. For anything above ₹10 lakhs, full CMA Data is mandatory across all major banks.

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

Banks are not just checking your creditworthiness — they are calculating the exact amount of working capital your business genuinely needs. This prevents two major problems:

❌ Over-financing
Giving you more limit than your business needs leads to misuse of funds and creates an NPA (Non-Performing Asset) risk for the bank.
❌ Under-financing
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

A 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:

1

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)
Tip: The growth % in Net Sales (row 4) is what banks scrutinise most. Projections that are too aggressive (above 25-30% per year for existing businesses) can raise red flags. We keep this realistic and justified.
🔗 How to fill Operating Statement correctly →
2

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
Important: The Bank Borrowing you are applying for (e.g. ₹10 lakhs CC limit) appears here under Current Liabilities from Year II onwards. This is how banks see the proposed loan in your balance sheet.
3

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
Balance check: If Total Assets ≠ Total Liabilities, your CMA is wrong and will be rejected. Every line must tie back to Sheet 1 (Operating Statement).
🔗 Understanding Current Assets vs Liabilities →
4

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
🔗 Detailed Guide: What each ratio means & bank's required range →
5

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.

Long-Term Surplus in the fund flow means your long-term sources exceed long-term uses — a very positive sign for banks. A deficit here raises concerns.
6

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 ↓
7

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)
Common depreciation rates: Furniture & Fixtures — 10%, Plant & Machinery — 15%, Computers — 40%, Vehicles — 15-20% (as per IT Act Sec. 32).
💡 Important: All 7 sheets must be internally consistent. A mistake in Sheet 1 will cause errors in Sheets 2, 3, 4, 5, and 6. This is why most people who try to prepare CMA data themselves end up with a report the bank rejects. Our experts ensure every number ties across all sheets before delivery.

How Banks Calculate Your Working Capital Limit (MPBF)

Banks 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
  1. Total Current Assets (TCA) — Inventory + Receivables + Cash & Bank + Other CA
  2. Less: Current Liabilities (Other than Bank Borrowing) — Sundry Creditors, Provisions etc.
  3. Working Capital Gap = TCA − CL (excluding bank limit)
  4. Less: Margin — 25% on Inventory, 40% on Receivables (borrower's own contribution)
  5. MPBF = Working Capital Gap − Margin
MPBF = (Current Assets − Current Liabilities) − Margin

Method 2 — Turnover Method

Nayak Committee — used for limits up to ₹5 crore (most MSMEs)
  1. Projected Annual Turnover (A)
  2. 25% of Turnover (B) = Gross Working Capital Requirement
  3. 5% of Turnover (C) = Minimum margin to be contributed by borrower
  4. Net Working Capital available (D) = Current Assets − Current Liabilities
  5. E = Higher of C or D (bank takes the higher margin requirement)
  6. MPBF = B − E
MPBF = 25% of Turnover − Higher of (5% Turnover OR NWC)

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 Lacs25% 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 ✓
The bank sanctions ₹10 lakhs — not the full ₹10.27 or ₹10.18 lacs. Banks round down and also apply their own internal margin guidelines. Your CMA report should show this calculation transparently.
🔗 Detailed MPBF Calculation Guide with More Examples →

Key Financial Ratios Banks Check in CMA Data

Banks 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
TOL/TNW Total Outside Liabilities ÷ Total Net Worth Below 3 : 1 (ideally ≤ 2) High leverage — bank considers you over-borrowed
PBDIT / Interest Profit before Dep, Interest & Tax ÷ Annual Interest Minimum 1.5 times Cannot comfortably service interest — high default risk
Net Working Capital (NWC) Current Assets − Current Liabilities (excl. bank) Must be positive & growing Negative NWC = business running on borrowed short-term funds
PAT / Net Sales % Net Profit After Tax ÷ Net Sales × 100 Higher the better (min 5%+) Very thin margins suggest business cannot sustain repayment
ROCE % PBDIT ÷ Total Assets × 100 Above 10% (higher = better) Poor return on assets — funds not being used efficiently
Inventory + Receivables Days (Inventory + Debtors) ÷ Net Sales × 365 Lower the better (under 90 days) Too much money stuck in stock/debtors — cash flow risk
Operating Cost / Sales % Total Operating Cost ÷ Net Sales × 100 Below 90% (ideally 75-85%) Very high cost structure — profitability at risk
🔗 Complete Guide: All CMA Ratios with Acceptable Ranges & Examples →

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

You only need to share these basic documents with us. We handle all the preparation, calculations, and formatting.

📄
Last 2–3 Years ITR + Computation To verify actual income and establish base year financials for projections
📈
Audited Balance Sheet & P&L CA-certified financials for past years (or provisional if not yet audited)
📋
GST Returns (GSTR-3B / GSTR-1) To verify actual monthly/annual turnover — banks cross-check this
🏢
Business Registration Documents GST Certificate, Udyam/MSME certificate, Shop Act, or Partnership Deed
🏭
Bank Statements (12 Months) Current account statement — banks check actual cash flows and average balance
📝
Loan Requirement Details Loan amount needed, purpose (CC/OD/WCDL), bank name, and proposed security
New Business / No Financials? If your business is less than 1 year old or you don't have audited accounts, we can still prepare CMA Data based on projected figures and industry benchmarks. Many banks under MUDRA and CGTMSE schemes accept projected CMA for new businesses. WhatsApp us to discuss

How Khemchandani Finance Prepares Your CMA Data in 24 Hours

We 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:

1

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.

2

Document Submission

Share your ITR, balance sheet, GST returns, and bank statements with us securely via WhatsApp or email. We review and confirm receipt.

3

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.

4

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.

5

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

SBI
HDFC Bank
ICICI Bank
Canara Bank
Punjab National Bank
Axis Bank
Union Bank of India
Bank of Baroda
Bank of India
Indian Bank
Central Bank of India
UCO Bank
All Cooperative Banks

Simple Pricing — No Hidden Charges

One price. Everything included. No surprises.

Regular Price: ₹2,999
₹999
All-Inclusive — Limited Time Offer
  • 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
Get Started — WhatsApp Now

🔒 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

How many years of projections are required in CMA Data for Working Capital?
Most banks require 1 year of actual (audited) data plus 2 years of projections for limits up to ₹5 crores. For larger limits, banks may require projections up to 5 years. At Khemchandani Finance, we prepare 1 actual year + 6 projected years (7 columns total) — this ensures your report is complete and acceptable regardless of the loan amount or bank.
What is the difference between CMA Data for Working Capital and for Term Loan?
Working Capital CMA focuses on your current assets, current liabilities, and MPBF calculation — how much CC/OD limit you need to run day-to-day operations. Term Loan CMA adds DSCR (Debt Service Coverage Ratio) calculation to show how comfortably your business will repay the EMIs over the loan tenure. The 7-sheet format is the same, but the emphasis and additional calculations differ. Learn about CMA Data for Term Loan →
Can a proprietorship or small shop get CMA Data prepared?
Absolutely. CMA Data can be prepared for any business structure — Proprietorship, Partnership, LLP, or Private Limited Company. In fact, most of our clients are small proprietorship businesses — medical stores, retail shops, traders, contractors, and service providers. The format is the same regardless of business size.
What if my business is new and has no actual financial history?
For new businesses with less than 1 year of operation, we prepare CMA Data based entirely on projected figures — using your expected orders, industry averages, and realistic growth assumptions. Many banks under MUDRA, CGTMSE, and PM SVANidhi schemes sanction working capital based on projected CMA. We clearly indicate which year is "projected" vs "actual" in the format.
Why do banks reject CMA Data reports?
The most common reasons for CMA rejection are: (1) Balance Sheet doesn't balance — Total Assets ≠ Total Liabilities, (2) Projections are unrealistically aggressive without justification, (3) Key ratios like Current Ratio or TOL/TNW are outside acceptable limits, (4) Format doesn't match the specific bank's requirement, (5) Inconsistency between sheets — figures in one sheet don't match another. Our reports are cross-verified across all 7 sheets before delivery.
Can I prepare CMA Data myself using Excel?
Yes, technically you can — but it is complex and error-prone. All 7 sheets are interconnected with formulas, and one wrong number cascades into errors across every sheet. Banks also expect specific formatting. Most people who try to prepare it themselves either get rejected or have to get it redone. At ₹999, our service is cost-effective and saves significant time and frustration.
Is CMA Data required for all working capital limits?
For limits below ₹10 lakhs (especially MUDRA loans), some banks waive the full CMA requirement. However, a simplified projected balance sheet is always helpful. For ₹10 lakhs and above, full CMA Data with all 7 sheets is mandatory at all major scheduled banks in India.
How do I share documents with Khemchandani Finance?
The simplest way is to send scanned PDF or photo copies directly on WhatsApp (+91 9755406939). You can also email documents to Khemchandanifinance@gmail.com. All client data is kept strictly confidential and used only for preparing your CMA report.

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.


Scroll to Top