Finance, audit and tax toolkits · Delivered by email · Prices in ₹ inclusive of applicable taxes

Banking & Finance

CMA Data Format for Bank Loans: What Banks Want and How to Prepare It

The six CMA forms explained, how banks assess working capital (Tandon methods, the turnover method and MPBF), the ratios they look at, and the mistakes that get proposals sent back.

By DigiKits Team · · 7 min read

When you apply for a cash credit limit, a term loan or an enhancement, the bank will almost always ask for "CMA data". It is the bank's standard way of reading your past performance and your projections in one format, so the credit officer can compare you with every other borrower on the same basis.

This guide explains what goes into each of the six forms, how banks work out how much working capital they will fund, which ratios they look at, and why so many reports come back for revision.

What CMA data is, and why banks still want it

CMA stands for Credit Monitoring Arrangement. The RBI introduced it to monitor borrowers with large limits, and the six-form layout became the standard for working capital appraisal. The RBI gave banks freedom in 1997 to choose their own method of assessing working capital, so the format is no longer mandated. But most public and private sector banks still use it, because their credit appraisal templates are built around it.

A CMA report usually covers:

  • two or three years of audited actuals
  • the current year estimate (provisional figures for the year in progress)
  • projections for the next one to two years for working capital, and for the full loan tenure for a term loan

The six forms

FormTitleWhat the bank reads from it
IParticulars of existing and proposed limitsWho you bank with, what limits you have, how much you use, and what you are asking for
IIOperating statementSales, cost of sales, profit before and after tax, year by year
IIIAnalysis of balance sheetLiabilities and assets regrouped into current, term and net worth heads
IVComparative statement of current assets and current liabilitiesInventory, receivables and creditors in amount and in days or months
VComputation of MPBFThe working capital gap and how much of it the bank will fund
VIFunds flow statementLong-term sources and uses, showing whether long-term funds cover long-term uses

Form II: the operating statement

Start here, because everything flows from sales. Show gross sales, less GST if the books show it gross, then net sales. Break cost of sales into raw materials (opening stock + purchases − closing stock), power, direct labour, other manufacturing expenses and depreciation. Then selling, general and admin expenses, interest, and tax.

Banks compare the growth you project with your track record and your industry. A business that grew 8% a year for three years and now projects 40% will get questions, unless the projection is backed by an order book, new capacity or a new customer contract.

Form III: analysis of balance sheet

This is your audited balance sheet regrouped the way a banker reads it. Two rules cause most errors:

  • Current liabilities include bank borrowings for working capital, trade creditors, advances from customers, statutory dues and the instalments of term loans due within the next 12 months.
  • Unsecured loans from promoters are usually treated as quasi-equity only if they are subordinated to the bank loan with a written undertaking. Otherwise they are term liabilities.

Form IV: holding levels

Banks look at the number of days or months of each current asset:

  • raw material holding in months of consumption
  • finished goods in months of cost of sales
  • receivables in months of sales
  • creditors in months of purchases

A sudden jump in projected receivable days, or inventory holding much higher than peers, reduces the limit the bank will allow or prompts a demand for justification.

How banks work out the working capital limit

The Tandon Committee methods (MPBF)

The RBI's Tandon Committee (1975) set out three ways to work out Maximum Permissible Bank Finance. The first two are the ones banks still use.

MethodFormulaEffect
First methodMPBF = 75% × (current assets − current liabilities other than bank borrowings)You fund 25% of the working capital gap from long-term sources
Second methodMPBF = (75% × current assets) − current liabilities other than bank borrowingsYou fund 25% of total current assets; implies a minimum current ratio of 1.33
Third methodAs the second, but core current assets are funded entirely from long-term sourcesRarely used

A worked example with current assets of ₹10 crore and other current liabilities (mainly creditors) of ₹3 crore:

ItemFirst method (₹ crore)Second method (₹ crore)
Total current assets10.0010.00
Other current liabilities3.003.00
Working capital gap7.007.00
Borrower's margin1.75 (25% of gap)2.50 (25% of current assets)
MPBF5.254.50

Form V in your CMA shows exactly this computation. If your existing net working capital (long-term funds in current assets) is lower than the required margin, the shortfall is a problem the bank will ask you to fix, often by bringing in more capital or converting promoter loans into subordinated loans.

The turnover method for MSMEs

For smaller borrowers, the Nayak Committee (1991) recommended a simpler method based on turnover, which the RBI later built into its MSME lending directions. For micro and small enterprises with fund-based working capital limits of up to ₹5 crore, banks are asked to assess the limit at a minimum of 20% of projected annual turnover, with the working capital requirement taken as 25% of turnover and the borrower bringing a margin of 5% of turnover.

So a small enterprise projecting ₹8 crore of sales would normally qualify for a working capital limit of at least ₹1.6 crore, provided the projection is accepted and the other parameters are fine.

Cash budget method

For seasonal businesses (sugar, tea, construction contractors), banks may assess the limit from a monthly cash budget showing the peak funding need. Your CMA then needs monthly projections, not just annual ones.

The ratios banks look at

These are typical benchmarks used in credit appraisal. They are not RBI rules, and each bank's policy differs, so treat them as a guide.

RatioWhat it showsTypical comfort level
Current ratioCurrent assets ÷ current liabilities1.33 or more (follows from the second Tandon method)
DSCR (term loans)(PAT + depreciation + interest on term loan) ÷ (term loan instalments + interest)Average around 1.5; no year much below 1.2–1.25
TOL/TNWTotal outside liabilities ÷ tangible net worthUp to about 3:1 for manufacturing; higher may need justification
Debt–equity (term loans)Long-term debt ÷ tangible net worthAround 2:1 or lower
Interest coverageEBITDA ÷ interestComfortably above 2
Promoter's margin on projectsOwn funds as % of project costCommonly 20–25%

DSCR is the ratio that decides most term loans. Calculate it year by year in your CMA, and show both the average and the minimum.

Why CMA reports get sent back

  • Actuals don't match the audited accounts. Every figure in the past-year columns should tie to the audited balance sheet and profit and loss account, after regrouping.
  • Sales don't match GST returns or the ITR. Banks now routinely compare CMA turnover with GSTR-3B and income-tax returns. Explain any difference (for example, stock transfers between branches).
  • Projections with no basis. Growth, margins and holding periods that jump without an explanation.
  • Term loan instalments not shown as current liabilities for the next 12 months, which flatters the current ratio.
  • The limit requested doesn't follow from Form V. The amount you ask for should be the MPBF or the turnover-method figure, not a round number.
  • The funds flow in Form VI doesn't balance, or long-term uses (new machinery) are funded with short-term money.
  • Missing assumptions sheet. A one-page list of assumptions (price increases, capacity utilisation, holding periods) saves weeks of questions.

A checklist before you submit

  1. Past years tie to audited accounts, after regrouping.
  2. Sales tie to GST returns and ITR, with reconciliation notes.
  3. Current-year estimate is based on actual months to date.
  4. Term loan instalments due in 12 months are in current liabilities.
  5. Form V gives the limit you are requesting.
  6. DSCR shown year by year, with the average and minimum.
  7. Assumptions sheet attached.
  8. Project report (for term loans) uses the same numbers as the CMA.

Frequently asked questions

What does CMA stand for?

Credit Monitoring Arrangement. It was introduced by the RBI in the 1970s and 80s to monitor large borrowers. The RBI no longer prescribes the format, but most Indian banks still ask for CMA data in the same six-form structure.

How many years of data does a CMA report need?

Typically two to three years of audited actuals, the current year's estimate, and projections for the loan period: at least one to two years for working capital and the full tenure for a term loan.

What is MPBF?

Maximum Permissible Bank Finance: the most a bank will lend for working capital. Under the Tandon Committee's second method it is 75% of current assets less current liabilities other than bank borrowings.

What DSCR do banks expect?

There is no single regulatory figure. Many banks look for an average DSCR of around 1.5 over the loan tenure, and do not accept a year below roughly 1.2 to 1.25. Check your bank's credit policy.

Is the turnover method still used?

Yes, for MSE borrowers. The RBI's MSME lending directions ask banks to assess working capital limits of up to ₹5 crore at a minimum of 20% of projected annual turnover, with the borrower bringing a margin of 5% of turnover.

Sources

  1. RBI: FAQs on MSME lending (working capital assessment, Nayak Committee)
  2. RBI: Master Direction – Lending to MSME Sector (list of Master Directions)
  3. Ministry of MSME: How do banks assess working capital requirements?
  4. RBI: Master circulars (working capital finance)

General information only, not professional advice. Rules change; check the current law and your facts before acting.

← All guides