Free Excel download

CMA Format in Excel with Formulas (Free Download)

A simplified CMA data format for cash credit and working capital limits, with MPBF worked out by formula.

CMA stands for Credit Monitoring Arrangement. CMA data is the set of financial statements and ratios banks use to assess working capital limits such as cash credit and overdraft, and to review term loans.

Download the free Excel format below. Change the yellow cells for four years (two actual, one estimate, one projected) and the totals, ratios and MPBF recalculate.

Download CMA format (Excel) — Excel file with formulas: operating statement, current assets and liabilities, current ratio and MPBF by Method I, Method II and turnover method. No sign-up needed.

What is inside the CMA Excel format

CMA data full form and meaning

CMA is Credit Monitoring Arrangement. The CMA format traces back to the RBI-led committees on bank credit, and banks today use their own versions of Forms I to VI.

The six forms are: Form I, existing and proposed limits; Form II, operating statement; Form III, analysis of balance sheet; Form IV, comparative current assets and liabilities; Form V, MPBF; Form VI, fund flow.

Mistakes to avoid in CMA data

From Excel to a full CMA report

This Excel is simplified for learning and planning. A bank CMA needs all six forms from your printed accounts. In Credlook you paste the profit and loss account and balance sheet, each head is placed on the correct Form II or Form III row, gross and net profit are checked against the printed accounts, and Forms I to VI with MPBF are produced.

Credlook.in prepares project reports and CMA documentation from details you provide. We are not a bank, NBFC, lender, or government scheme portal—documentation support only.

FAQ

What is the full form of CMA in banking?

Credit Monitoring Arrangement.

Is this CMA format in Excel free?

Yes. Download it without signing up.

Does it calculate MPBF?

Yes. It calculates MPBF by Method I, Method II and the turnover method using formulas.

How many years does CMA data cover?

Usually two or three actual years, the current year estimate and one or more projected years. The Excel has four year columns.

Is CMA format as per RBI guidelines?

The CMA structure comes from RBI-era committee recommendations, but each bank uses its own version of the forms. Follow your bank’s format for submission.

Open CMA report — Paste your profit and loss account and balance sheet; Credlook produces CMA Forms I to VI with MPBF.

Credlook.in provides project report and CMA documentation software from customer-provided details. We are not a bank, NBFC, lender, or government scheme authority.