CMA Data Excel Format

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

CMA data is almost always prepared as an Excel workbook, with a sheet per form. What separates a bank-ready file from a fragile one is linking: the forms should flow from each other through formulas, not hold hand-typed numbers that quietly disagree. This is the practical companion to our CMA data format guide.

Why Excel — and why linking matters
How the workbook is structured
Template pitfalls to avoid
On downloadable templates
Frequently asked questions

Why Excel — and why linking matters

Excel suits CMA because the seven forms are interdependent calculations. The strength of a good workbook is that a change in one input — say, projected sales — ripples correctly through receivables, the balance sheet, MPBF and the ratios. When forms are instead filled with standalone typed figures, they drift out of agreement, and an inconsistent CMA is a rejected CMA.

How the workbook is structured

A sound CMA workbook typically has:

An assumptions / inputs sheet — growth rate, margins, holding periods for stock, receivables and creditors — feeding everything else.
A sheet per Form I–VII, each pulling from the inputs and from prior forms by formula.
A ratio sheet (Form VII) that computes automatically, so current ratio, turnover and the rest are never hand-entered.
Clear separation of actuals (from audited financials) and projections (formula-driven).

Built this way, the MPBF in Form V is an output of the model, which is exactly what a credit officer wants to see.

Template pitfalls to avoid

Hard-typed figures where formulas should link — the number-one cause of forms that don't reconcile.
Balance sheet that doesn't balance after edits — a red flag on sight.
Ratios entered manually to look right, rather than computed — easily caught.
Projections inconsistent with the DPR — the two documents must agree.
Unrealistic assumptions — sudden margin jumps or an impossibly short operating cycle.

On downloadable templates

A generic Excel template can give you the skeleton, but it cannot supply your assumptions or guarantee the links are intact for your business. Plugging your figures into a template you don't fully understand is how inconsistencies creep in. If the limit matters, it is worth having the workbook built and checked by someone who knows how banks read it — and who will make the numbers defensible, not just presentable.

Frequently asked questions

Is CMA data always made in Excel?

Almost always — the seven forms are interdependent calculations that Excel handles well through linked, formula-driven sheets.

Why do my CMA forms not reconcile?

Usually because numbers were hard-typed where they should link by formula, so a change in one form didn't flow to the others. A properly linked workbook avoids this.

Can I just download a CMA Excel template?

A template gives the structure, but the assumptions and the integrity of the links must be right for your business. A template filled without understanding often produces inconsistent, rejected reports.

Should the balance sheet in CMA always balance?

Yes. A balance sheet that doesn't tally after edits is an immediate red flag at appraisal and a sign the workbook's links are broken.

Get a properly linked CMA workbook

We build CMA in Excel the right way — assumptions driving formula-linked forms, ratios computed, everything reconciling and consistent with your DPR. The first assessment is free.

CMA Data in Excel

Contents