CMA Data Report and DSCR: How Banks Read Your Projections

Almost every business loan of any size passes through one document: the CMA data report. It is the bank's standard way of reading your past numbers and your projections in one format, so that an analyst can compare your business with every other borrower on the branch's books.

Many rejections and delays trace back to this report, not to the business itself. The numbers do not tie together, the assumptions are optimistic without support, or the DSCR only works in a best-case year. This guide explains what the CMA contains, how banks calculate DSCR and the other ratios, and how to build projections a credit officer can believe.

What a CMA report is and where it comes from

CMA stands for Credit Monitoring Arrangement, a scheme RBI once used to monitor large bank credit. The scheme is long gone, but banks kept its format because it forces every borrower's numbers into the same structure: past audited years, the current year estimate, and projections for the period of the loan.

For a working capital limit, the projections usually cover the next year or two. For a term loan they run over the full repayment period, because the bank needs to see that cash accruals cover every instalment. The borrower prepares the report, usually with a CA, and the bank re-works it in its own appraisal note.

The six forms in the CMA format

The standard CMA has six forms. Each answers a different question the credit officer will ask, and each must tie to the others exactly.

Form III is where most errors creep in. Classification follows the bank's rules rather than the layout of your audited accounts, so term loan instalments due within the next year, statutory dues and advances from customers must sit where the bank expects them. Unsecured loans from promoters are usually counted as quasi-equity only if they are subordinated to the bank loan and kept in the business.

• Form I: existing and proposed limits, with the banks and facilities
• Form II: operating statement, covering sales, costs, profit and cash accruals by year
• Form III: analysis of the balance sheet in the bank's classification
• Form IV: comparative statement of current assets and current liabilities, with holding periods
• Form V: computation of maximum permissible bank finance for working capital
• Form VI: fund flow statement, showing long-term and short-term sources and uses

DSCR: the number that decides a term loan

The debt service coverage ratio measures how many times your cash accruals cover the loan payments due in a year. The usual bank formula is profit after tax plus depreciation plus interest on term debt, divided by interest on term debt plus principal repayable in that year. Some banks add other non-cash charges, so ask which version your bank uses.

Many lenders look for an average DSCR of roughly 1.25 to 1.5 over the tenor, and they also check the minimum in any single year. A comfortable average with one year below 1 is a real problem, because that year needs fresh money to pay the bank.

Watch the moratorium. DSCR is tested from the year principal repayment starts, so a long moratorium improves nothing; it only moves the test later. Also check that the interest in the formula matches the interest in the operating statement, and that tax is projected at the rate that will actually apply to you.

The other ratios a banker tests

DSCR is only one of several ratios in the appraisal note. For working capital the current ratio matters most; under the second method of lending the bank expects at least 1.33, which means the promoter funds a quarter of current assets from long-term money.

The ratios must also move logically. If sales grow fast while debtor days fall and creditor days rise, the banker will ask what changed in your business to make that possible.

• Total outside liabilities to tangible net worth, TOL/TNW: how much of the business is funded by others, with a ceiling set in each bank's loan policy
• Interest coverage: operating profit divided by interest, a quick test of stress
• Holding periods: days of raw material, finished goods, debtors and creditors, compared with past years and industry norms
• Security cover: value of primary and collateral security compared with the exposure
• Debt to EBITDA: years of operating profit needed to repay the debt

Assumptions that get a CMA sent back

Credit officers are trained to find the one number that makes the rest work. The common problems are easy to predict.

Each of these can be defended if it is true. Attach the evidence: signed orders, capacity data, price contracts or a customer's letter. A projection with a written basis for every line moves through credit far faster than an optimistic one.

• Sales growth far above the past trend with no order book, capacity or new market to explain it
• Margins that improve every year while input costs and competition are ignored
• Holding periods shorter than you have ever achieved, which shrinks the working capital need on paper
• Capex without matching depreciation, or loans without matching interest
• Projections that do not tie back to the last audited balance sheet

Sensitivity: how the bank stress-tests you

Most banks run their own sensitivity on your projections, cutting sales or margins or raising interest rates, and checking whether DSCR stays above 1. You are better off running the same test first and showing it in the report.

A simple table works: base case, sales lower by a tenth, margin lower by a point or two, and interest higher by a point. If the loan only works in the base case, restructure the tenor, the moratorium or the amount before the bank asks you to.

How to build a CMA the bank believes

Start from the last audited balance sheet and build forward month by month for the first year, then yearly. Link every line: sales drive debtors, purchases drive creditors and stock, capex drives depreciation, loans drive interest and repayments. The balance sheet must balance without a plug figure.

Then write a short note of assumptions in plain words, and reconcile the CMA with your stock statements and GST returns. A banker who sees that turnover, stock and debtors agree across documents trusts the projections that follow.

Frequently asked questions

Who prepares the CMA data report?

The borrower does, usually with a chartered accountant, in the format the bank prescribes. The bank then analyses it and may rework the figures in its own appraisal note. Many banks use their own templates, so ask for the format before you start.

What is a good DSCR for a bank loan?

Many lenders want an average DSCR of roughly 1.25 to 1.5 over the tenor, with no single year falling close to 1. The threshold varies by bank, sector and security, so confirm it with the lender.

Is CMA data needed for a small loan?

Smaller loans to micro and small enterprises are often assessed on simpler formats, such as the turnover method for working capital. Larger limits and most term loans still need full CMA data with projections.

How many years of projections should the CMA show?

For working capital, usually the current year estimate and the next year or two. For a term loan, projections should cover the full repayment period so the bank can test DSCR in every year.

Related guides

• Working Capital Loans: CC vs OD vs WCDL
• Project Finance for Indian Capex: Bankability, DSRA and Drawdown
• The 13-Week Cash Flow Forecast
• CMA and loan proposal support