CMA Data · Format

CMA Data Format Explained

CMA data follows a set structure — seven interlocking statements banks read in the same order every time. Here's each form, what it must contain, and how they add up to your working-capital limit.

Last updated: · By CA Nikhil Gupta · ~9 min read

There is a broadly standard CMA data format — seven forms that move from your existing limits, through your projected performance and balance sheet, to the Maximum Permissible Bank Finance (MPBF). Understanding what each form does makes it clear why a single inconsistent number can unravel the whole report. This pairs with our overview of what CMA data is.

Contents

Why the format is fixed

Banks appraise hundreds of proposals, so they standardise. When your CMA follows the familiar Form I–VII sequence, the credit officer can move straight to the numbers that matter. A non-standard or reshuffled report just slows appraisal and invites doubt. Format here is substance, not decoration.

The seven forms, in order

FormNamePurpose
IExisting & proposed limitsCurrent facilities and what you now seek.
IIOperating statementProjected P&L — sales, costs, profit, year by year.
IIIAnalysis of balance sheetClassified assets & liabilities across years.
IVComparative current assets & liabilitiesBuild-up of stock, receivables, creditors — the working-capital cycle.
VComputation of MPBFThe eligible working-capital limit — the core output.
VIFund flow statementSources and uses of funds over the period.
VIIRatio analysisCurrent ratio, turnover, and other key ratios.

How MPBF is calculated

Form V is where the limit is set. Under the commonly-used method, the bank looks at your working-capital gap (current assets needed, less current liabilities other than bank borrowing) and expects you to fund a margin from your own funds; the balance is the Maximum Permissible Bank Finance. A widely-applied benchmark is a current ratio of about 1.33:1, which effectively means you contribute roughly a quarter of the current-asset build-up and the bank funds the rest. The exact method and margin follow the bank's own policy.

Why the forms must agree

The forms interlock: sales in Form II drive the receivables in Form IV; the balance sheet in Form III must tie to the current-asset build-up; the ratios in Form VII fall out of all of it. If the operating statement is optimistic but the balance sheet doesn't reflect it, or the ratios don't hold, the report contradicts itself — and that is exactly what a credit officer looks for. Consistency across the seven forms, and with your DPR, is what makes CMA data credible.

Frequently asked questions

How many forms are there in CMA data?

Seven — Form I (limits), II (operating statement), III (balance-sheet analysis), IV (current assets & liabilities), V (MPBF), VI (fund flow) and VII (ratios).

Which form actually decides my limit?

Form V — the computation of Maximum Permissible Bank Finance. It converts your working-capital gap and margin into the eligible bank limit.

What current ratio do banks expect in CMA data?

A common benchmark is around 1.33:1, reflecting the expectation that the borrower funds part of the current-asset build-up. Individual banks apply their own policy.

Can I use a CMA Excel template?

A template gives the structure, but the numbers must be your own, consistent across all seven forms and with your DPR. A template filled with unrealistic figures is easy for a bank to spot.

Get your CMA prepared in the correct format

We'll build all seven forms so they interlock, hold the ratios, and produce a defensible MPBF that matches your DPR. The first assessment is free.

Related reading: What is CMA Data? · CMA Data Excel Format · CMA Data for Cash Credit · Common Mistakes in CMA Data · DPR Format for an MSME Loan

CMA Data That Reads the Way Banks Appraise

CA Nikhil Gupta prepares CMA reports in the standard seven-form format, with a defensible MPBF and ratios that hold. Free assessment, no upfront fee.

Get Free Assessment on WhatsApp