What the CMA data format is for
CMA stands for Credit Monitoring Arrangement. It is the financial pack Indian banks ask for when a business applies for a cash credit, overdraft or working capital demand loan, and again at every annual review of the limit. The pack answers a narrow question: how much short-term finance does the operating cycle support, and how will the borrower service it?
Working capital lenders read the pack year by year. They compare the latest audited accounts with the provisional year and the projections, watch how inventory, receivables and payables move, and test whether the borrowing proposed sits inside the assessed limit. An Excel file is useful only when those year columns are linked, so a change in sales flows through every statement instead of starting a fresh reconciliation.
Schedules the standard CMA format carries
Banks follow a common structure even when the cover page and annexures differ. A complete workbook carries these schedules:
- Operating statement — sales, direct and indirect costs, interest, tax and net profit for each year.
- Analysis of balance sheet — capital, reserves, borrowings, current liabilities and current assets, year on year.
- Comparative statement of current assets and current liabilities — with changes and movement ratios.
- Computation of maximum permissible bank finance (MPBF) — under the first and the second method.
- Fund flow statement — sources and uses of long-term funds across the reporting years.
- Cash flow statement and DSCR analysis for debt servicing comfort.
- Turnover method computation alongside the MPBF methods.
- Ratio analysis covering liquidity, profitability, leverage, activity, expense and growth.
- Depreciation schedule linked to the fixed assets in the balance sheet.
- EMI repayment schedule for any term loan attached to the borrower.
How many years, and how to label them
Most proposals carry three to five historical years, the current year's provisional figures and one or two projected years. The exact mix depends on the bank and on the age of the business. Keep the same number of columns and the same line heads in every year, and label each column as audited, provisional or projected so no estimate is mistaken for an audited result.
Seasonality deserves its own note. If nine months of a seasonal business are actual and three are estimated, the estimate should follow the demand pattern rather than a straight average of the year, because a cash credit limit is drawn against the peak requirement.
A sheet order that keeps the workbook readable
An order that credit teams and reviewers recognise:
- Cover page with the borrower's name, the facility sought, the periods covered and the reporting units.
- Assumptions sheet listing sales growth, margins, credit and holding periods, and interest rates.
- Operating statement for every year, historical and projected.
- Balance sheet analysis and the comparative statement of current assets and current liabilities.
- MPBF computation and the turnover method working.
- Fund flow statement, cash flow statement and DSCR.
- Ratio analysis, depreciation chart and EMI schedule.
One input sheet behind all of them keeps the arithmetic honest. Each statement should reference those inputs rather than repeat the numbers, so a revised sales figure does not have to be chased through seven tabs by hand.
MPBF and the turnover method in Excel
Two working capital computations decide the limit, and both belong in the workbook.
MPBF, first method (Tandon Committee) = 75% of (total current assets minus current liabilities other than bank borrowings). The borrower brings the remaining 25% of the working capital gap as margin.
MPBF, second method = 75% of total current assets minus current liabilities other than bank borrowings. The 25% margin is measured on total current assets, so the permissible finance is lower and the current ratio is higher than under the first method.
Turnover method (Nayak Committee), used for smaller MSME requirements: working capital requirement = 25% of projected annual turnover, the borrower's margin is 5% of turnover, and bank finance is up to 20% of turnover.
Which method applies depends on the bank's policy and the size of the limit. Show the computation the bank asks for, and preferably both, so the difference between them is visible in one place rather than in two files.
Mistakes that delay a working capital proposal
- Hard-typed totals that stop matching the lines above them after a single edit.
- Current assets and current liabilities that differ between the comparative statement and the MPBF computation.
- Ratios entered as fixed numbers instead of formulas, so they no longer move with the figures.
- Holding periods that do not reconcile with the inventory and receivables shown in the balance sheet.
- A projected year that grows sales without growing the working capital that funds them.
- Copied sheets that still carry the previous borrower's links.
Four checks catch most of these: total assets equal total liabilities and equity in every year; closing balances carry into the next year's opening figures; the working capital computations use the same current assets and current liabilities as the statements; and every ratio is calculated from the figures shown.
When a CMA tool pays off
A linked template is manageable for one file. At the second or third borrower, or when a bank asks for a revised projection in the middle of an appraisal, the maintenance effort begins to show. A CMA tool assembles the schedules from one set of inputs instead.
Finxora's CMA report software builds the operating statement, balance sheet analysis, MPBF under both methods and the turnover method from the figures you enter, calculates 20+ financial ratios across liquidity, profitability, leverage and activity, and exports a formatted PDF, Excel workbook or Word document. Audited and provisional years prepared in the balance sheet module can seed the historical columns, so the same figures run across documents. A filled sample report shows how the statements and ratio tables print before you settle on a format.
Before you submit
Read the pack the way a credit officer will. Check the current ratio, the debt-equity position and TOL/TNW against the movement shown, confirm that DSCR covers the repayment instalments, and walk each holding level — inventory, receivables, payables — back to the balance sheet. Then compare the format with the one your bank shared, because branch requirements vary. The tools hub and the CMA plans page are useful starting points.
