CMA data and the Bank of Maharashtra format
CMA stands for Credit Monitoring Arrangement. It is the financial pack an Indian bank studies before it sanctions or renews working capital finance: historical figures, the current year's provisional numbers and projections, arranged in interlinked statements. When a business asks for the Bank of Maharashtra CMA data Excel format, it usually means one thing: preparing that pack so the relationship manager's credit team can read it in the layout they already use.
There is no single public template that fits every proposal. The bank may share its own workbook, and the year columns, annexures and supporting schedules can differ between a fresh proposal, an enhancement, a renewal and a takeover from another bank. Ask the relationship manager for the applicable checklist before entering figures, and treat the structure below as the standard CMA format that most bank-specific workbooks follow.
The worksheets a CMA workbook normally carries
A typical CMA file keeps each statement on its own sheet, with a cover or general-information sheet at the front. The usual set is:
- General information — borrower name, constitution, activity, address, PAN, GSTIN, existing facilities and sanctioned limits.
- Operating statement — sales, direct and indirect costs, depreciation, 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 — the movement that drives the working capital assessment.
- MPBF computation — maximum permissible bank finance under the first and second methods.
- Fund flow and cash flow statements — sources and uses of funds, and the year-wise cash position.
- Ratio analysis and DSCR — liquidity, profitability, leverage and debt-service measures.
- Turnover method computation, depreciation schedule and EMI schedule — where the proposal includes working capital and term loans.
Filling the historical, provisional and projected years
The columns usually run left to right: two or three audited years, the current year as provisional, then two to five projected years. Every projected figure has to trace back to an assumption, so keep an assumptions sheet beside the statements — sales growth, gross margin, debtor and creditor days, stock holding, interest rates and repayment terms.
A number entered on one sheet must agree with the same number elsewhere. Sales in the operating statement feed debtors in the balance sheet; profit flows into reserves; fixed-asset additions feed the depreciation schedule. In a hand-maintained Excel file the totals are often hard-coded, and that is where the pack stops agreeing with itself.
Working capital and MPBF in the standard method
Two calculations carry the assessment. In both, other current liabilities means current liabilities excluding bank borrowings.
- Method I: MPBF = 75% × (Total Current Assets − Other Current Liabilities), and the borrower funds 25% of the working capital gap.
- Method II: MPBF = (75% × Total Current Assets) − Other Current Liabilities, with a borrower margin of 25% of total current assets.
- Turnover method (Nayak Committee, for MSMEs): the working capital requirement is 25% of projected annual turnover, the borrower brings 5% of turnover as margin, and bank finance is up to 20% of turnover.
Show both MPBF methods side by side, with the turnover-method requirement alongside, so the credit team can see which method binds. Requirements vary by bank and by facility, so confirm the method the bank applies to the proposal.
Ratios the credit team reads first
Beyond the statements, the ratio sheet is what the officer scans. Keep it correct and complete: current ratio and quick ratio for liquidity; debt-equity and total outside liabilities to net worth (TOL/TNW) for leverage; stock, debtor and creditor turnover for the operating cycle; and DSCR — net profit plus depreciation plus term-loan interest, divided by principal plus interest — for repayment comfort. Every ratio should be computed from the figures shown, not typed over them.
Errors that delay a proposal
- Hard-coded totals that stop matching after a figure is revised.
- Bank borrowings mixed into other current liabilities in the MPBF sheet.
- Projections with no assumptions sheet, so the growth rate cannot be defended.
- Mismatched year columns between the statements, or a missing audited year.
- Year-to-date figures left in a full-year column, or units shown in lacs on one sheet and rupees on another.
- An unbalanced projected balance sheet, and a cash flow that does not reconcile to it.
What a credit officer checks first
Before reading every sheet, a credit officer usually looks for four things: whether the projected balance sheet tallies, whether the current ratio holds up year on year, whether the debt-service position leaves a margin of safety, and whether the growth in sales matches the growth in working capital. A pack that answers those four questions from its own figures moves through the first reading faster than one that needs a covering note to explain each sheet.
Documents that go with the file
The workbook rarely travels alone. Along with the CMA file, the bank usually asks for the last two or three years' audited financial statements and income-tax returns, the current provisional statements, bank statements and sanction letters for existing facilities, an estimate of the working capital requirement, and the constitution and registration papers. Keeping these in one folder shortens the query list after submission.
Preparing the pack without rebuilding it in Excel
Hand-maintained workbooks are hard to keep in agreement, especially at renewal, when the provisional and projected years both change. Finxora's CMA report software keeps one set of inputs and builds the operating statement, balance sheet analysis, comparative statement, MPBF under both methods, fund flow, cash flow, DSCR, turnover-method computation and a ratio set covering 20+ financial ratios, all linked so a change in one assumption flows through the pack. The report exports as a formatted PDF, an Excel workbook or a Word document; the Excel export is useful when the bank asks for its own workbook. A filled sample sits in the samples library if you want to see the presentation first, and the CMA pricing page lists the plans.
Working in Excel remains possible, and the structure above is what to follow. The main risk is drift: a figure changed on one sheet and not on the others. Whichever route you take, reconcile the statements against each other before the file goes to the bank.
