Finxora Logo
Sign In
CMA Data Format: Meaning, Components and Excel Structure
Back to Blog

CMA Data Format: Meaning, Components and Excel Structure

FINXORA
5 min read
CMA
data format
excel
financial analysis
metadata

Understand the Indian bank CMA data format, its linked statements, MPBF calculations and the checks needed when preparing or reviewing an Excel workbook.

What CMA data means in a bank loan file

CMA stands for Credit Monitoring Arrangement. In an Indian bank-loan proposal, CMA data is the financial pack used to examine operating performance, financial position and working capital requirements. It combines historical accounts, provisional figures and projections in linked statements. The purpose is to explain the borrowing requirement through numbers the credit team can reconcile.

An Excel CMA format is a workbook arrangement for those statements, not a separate type of financial data. Its value comes from consistent inputs and transparent calculations. Before selecting a template, obtain the bank's checklist and confirm the periods, assessment method, amount unit and annexures required. Requirements vary by bank and proposal.

Set the reporting columns first

Label each year with both its end date and status: audited, provisional or projected. The distinction tells the reader which figures come from completed accounts and which depend on estimates. Do not present a forecast as audited merely because it occupies a column next to historical figures.

Use the same reporting period and amount unit throughout the workbook. If the operating statement is in lakh and a loan schedule is in actual rupees, convert through an explicit formula. Display the chosen unit on each output sheet. Short first periods, changes in year-end and estimates based on partial-year results need clear explanation.

The main components of a CMA pack

StatementWhat it explains
Operating statementSales, expenses, interest, tax and profit
Balance sheet analysisCapital, borrowings, other liabilities and assets
Current assets and liabilitiesWorking capital gap and operating-cycle funding
MPBF assessmentBorrower margin and assessed bank finance
Fund flowSources and applications of funds between periods
Ratio analysisLiquidity, leverage, profitability and activity measures

Some proposals also require cash flow, DSCR, depreciation, repayment and other schedules. Follow the requested scope rather than assuming every workbook uses identical form numbers or headings. Supporting detail should explain the main statements without creating competing versions of the same figure.

Operating statement: project the business before the totals

Enter historical sales and expenses from the accounts and document adjustments. For projected years, explain how sales arise from volume, selling price, capacity or customer demand. A percentage increase may be a convenient input, but it still needs a commercial basis.

Separate operating expenses, finance costs and other items consistently. Compare the projected gross margin and net margin with history. If profitability improves sharply, identify the reason, such as a documented change in product mix or capacity utilisation. Interest should connect with borrowing assumptions rather than remaining a fixed number while debt changes.

Balance sheet and operating-cycle schedules

The balance sheet shows the financial position supporting the operating plan. Link fixed assets to additions and depreciation, reserves to retained profits, and borrowings to drawdowns and repayments. Review promoter funds separately from external liabilities. Classification affects both ratios and the working capital assessment.

Current assets commonly include inventory, receivables, cash and other relevant balances. Other current liabilities for MPBF calculations exclude bank borrowings. Keep that definition visible so bank finance is not deducted in the wrong place. Holding levels should reflect how the business purchases, produces, sells and collects.

For a trading business, test receivable days against the credit actually offered to customers. For a manufacturer, distinguish raw materials, work in progress and finished goods where relevant. Do not apply sales-based days to every balance without checking whether the denominator should instead be cost or consumption.

MPBF formulas and a worked example

The Tandon Committee methods use different margin bases. MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). MPBF Method II = 75% x Total Current Assets - Other Current Liabilities. Other current liabilities mean current liabilities excluding bank borrowings.

Assume total current assets of Rs 80 lakh and other current liabilities of Rs 20 lakh. The working capital gap is Rs 60 lakh. Under Method I, assessed finance is 75% x Rs 60 lakh = Rs 45 lakh, leaving a borrower margin of Rs 15 lakh. Under Method II, it is 75% x Rs 80 lakh minus Rs 20 lakh = Rs 40 lakh, leaving a margin of Rs 20 lakh.

The turnover method associated with the Nayak Committee MSME framework uses working capital requirement of 25% of projected annual turnover, borrower margin of 5% of turnover and bank finance up to 20% of turnover. Applicability and sanction depend on the bank's assessment. These calculations do not establish an automatic entitlement to a limit.

Organise the Excel workbook for review

  1. Create a control sheet for entity details, periods and amount units.
  2. Keep historical inputs separate from projection assumptions.
  3. Build supporting schedules for assets, debt and holding levels.
  4. Link statement outputs to the same source cells.
  5. Add reconciliation checks and a visible exception summary.
  6. Set print areas and repeat year headings on long schedules.

Use consistent signs for liabilities, expenses and cash movements. Avoid hard-coded totals inside formula areas, and document any override. A workbook should make it possible to trace a result back to its inputs without searching through hidden sheets or unexplained external links.

Review ratios and fund flow together

Current ratio, TOL/TNW and activity ratios describe different aspects of the same financial position. State definitions and investigate movements. A projected improvement in liquidity may be unrealistic if the cash flow shows persistent funding shortages or if additional long-term assets are being financed from short-term borrowing.

The fund flow statement should explain how changes in long-term sources and applications relate to working capital movement. It is not interchangeable with a cash flow statement. Reconcile the statements rather than copying identical headings into both and assuming they communicate the same analysis.

Use software without skipping financial judgement

Finxora's CMA report software prepares linked statements, MPBF under both methods, turnover-method computation and 20+ financial ratios. It exports PDF, Excel and Word reports. Review the sample reports to compare the output with your lender's requirements, and see CMA plans for the available offering.

Before submission, reconcile historical figures to source accounts, test the balance sheet, verify repayment and interest links, and inspect every projected assumption. A complete CMA format explains the requirement and exposes uncertainty. Its role is to support a credit decision with a consistent financial record.

Frequently Asked Questions

Published on February 24, 2026

Updated on April 22, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.