Free, CA-built CMA data format in Excel – ready for your bank
All six RBI forms, MPBF (Tandon Method I & II), the Nayak turnover method, a term-loan DSCR schedule and auto-calculated ratios – across two audited, one provisional and three projected years.
⬇️ Download the CMA Data Excel (free)Every bank asks for CMA data before sanctioning or renewing a working-capital limit or a term loan – but most templates floating around are locked, out of date, or built for a different bank’s format. This one is different: it follows the standard Credit Monitoring Arrangement layout, every figure flows through live formulas, and apart from the branded instructions sheet, every sheet is left open for you to edit so you can adapt it to any loan, any bank and any business.
What you get
- All six CMA forms (Form I to Form VI) in the standard sequence banks expect.
- MPBF computed both ways – Tandon Committee Method I and Method II, side by side.
- Nayak (turnover) method for MSE working-capital limits up to ₹5 crore.
- Term-loan repayment schedule with DSCR, year by year, plus an average DSCR.
- A ratios sheet that computes current ratio, debt-equity, TOL/TNW, interest cover, margins, ROCE and holding periods automatically.
- A worked sample (a healthy manufacturing SME) already filled in, so you can see exactly how every number flows – then overwrite it with yours.
What is CMA data?
CMA (Credit Monitoring Arrangement) data is the structured financial statement a borrower submits to a bank to support a working-capital or term-loan proposal. It presents the business’s past performance (audited years), the current year (provisional/estimated) and the future (projected years) in a single comparable format, so the banker can assess the funding requirement, the repayment capacity and the health of the business. The core of CMA is the assessment of the working-capital gap and the Maximum Permissible Bank Finance (MPBF).
What’s inside the workbook
Who should use this CMA template
- Chartered Accountants and their staff preparing CMA data for clients’ loan proposals and renewals.
- Businesses and MSMEs applying for a cash credit / overdraft limit, a working-capital demand loan or a term loan.
- Finance and accounts teams who want a projection model that can be adapted to a specific bank’s format.
- Consultants and loan advisors who need a fast, editable starting point rather than a locked black box.
How to use the CMA Excel
- Download and open the workbook, then read the Instructions sheet – it explains the colour legend (blue = your input, black = formula, green = link).
- On each Form, edit the financial-year labels in the header, then replace the blue sample figures with your own – two audited years, one provisional year and three projected years.
- Enter the working-capital detail on Form IV; the current-asset and current-liability lines on Form III update automatically.
- Check Form V for the MPBF and the Turnover Method sheet for the Nayak limit, and fill the term-loan parameters on the Term Loan & DSCR sheet.
- Review the Ratios sheet – current ratio, DSCR and debt-equity are what the banker looks at first.
Working-capital assessment methods included
MPBF – Tandon Committee Method I & II
The Maximum Permissible Bank Finance is the working-capital gap that a bank can fund. Under Method I, the borrower brings a margin of 25% of the working-capital gap; under Method II, the margin is 25% of total current assets (which pushes the current ratio towards 1.33:1). The workbook computes both, so you can present whichever your bank uses.
Nayak Committee turnover method
For micro and small enterprises with working-capital limits up to ₹5 crore, banks often use the simplified turnover method: working capital is taken at 25% of projected annual turnover, the bank finances 20% of turnover and the borrower brings a 5% margin. The workbook applies this on a dedicated sheet.
Term loan & DSCR
For a term loan, the banker’s key test is the Debt-Service Coverage Ratio – profit after tax plus depreciation plus interest, divided by the instalment plus interest. Lenders typically look for an average DSCR of at least 1.5 to 2.0. The workbook builds a year-wise schedule and the average automatically.
Ratios the banker will check
| Ratio | What it shows | Typical comfort level |
|---|---|---|
| Current ratio | Short-term liquidity | 1.33 and above |
| Debt-equity ratio | Long-term leverage | Up to about 2:1 |
| TOL / TNW | Total outside liabilities to net worth | Lower is safer |
| Interest coverage | Ability to service interest | Comfortably above 1.5 |
| DSCR | Ability to repay a term loan | Average 1.5 to 2.0 |
| Inventory & debtor holding | Working-capital efficiency | In line with the industry |
Why this CMA template is different
Frequently asked questions
Is this CMA data Excel really free?
Yes. Download it, use it for as many clients or proposals as you like, and edit it freely. There is no sign-up and no watermark.
Can I edit the sheets, or are they locked?
Only the branded Instructions sheet is protected. Every other sheet – all six forms, MPBF, the turnover method, the term-loan schedule and the ratios – is fully open, so you can change line items, add rows or adapt the model to a specific bank’s template.
How many years does it cover?
Six columns: two audited years, one current provisional/estimated year and three projected years – the standard span banks expect. You can relabel the years to match your case.
Does it calculate MPBF automatically?
Yes. Form V computes the Maximum Permissible Bank Finance under both Tandon Method I and Method II from the current assets and liabilities you enter, and a separate sheet applies the Nayak turnover method for small limits.
Does it include a term-loan DSCR calculation?
Yes. The Term Loan & DSCR sheet builds a year-wise repayment schedule and computes the Debt-Service Coverage Ratio and its average automatically.
What amounts should I enter – rupees, thousands or lakhs?
Any one unit, as long as you keep it consistent across all sheets. The sample is presented in ₹ lakhs.
Will the numbers balance?
The current-asset and current-liability lines on the balance sheet link from the working-capital sheet, so the two tie automatically. A check row on Form III confirms that total assets equal total liabilities.
Related tools
Built by CalcGuru – free, CA-built utilities for accountants and businesses. Need help with your CMA or loan proposal? Ask a CA.