Finxora Logo
Sign In
CMA Data Format in Excel: Download and Preparation Guide
Back to Blog

CMA Data Format in Excel: Download and Preparation Guide

FINXORA
6 min read
CMA
Excel
Bank Loan
Financial Analysis
Data Format

Explore the CMA Excel format for Indian bank loans, where to view samples, how the schedules connect, and which checks to complete before submission.

What a CMA Excel workbook should achieve

CMA means Credit Monitoring Arrangement. For an Indian bank loan, CMA data presents historical, provisional and projected financial information in a connected set of statements. An Excel workbook is one way to organise that information. Its value comes from traceable inputs and consistent calculations, rather than the presence of a familiar cover sheet.

Start with the lender's current checklist and requested format. Banks can ask for different year columns, annexures and assessment methods. A general workbook is a starting structure, not evidence that every bank will accept the submission unchanged. Confirm the borrower, facility, reporting periods and amount unit before entering figures.

Where to view and download a sample

Finxora's samples page provides report examples, including CMA outputs in PDF, Excel and Word. Use the sample to examine the statement order, headings and supporting workings. This article does not offer a separate blank spreadsheet attachment. A filled sample shows presentation; it should not be submitted using another business's figures.

For a report built from your own inputs, Finxora CMA report software prepares linked statements and exports an Excel workbook as well as PDF and Word reports. Review the resulting workbook against the bank's requested annexures. If you change exported figures, reconcile the complete pack before circulating a new version.

Recommended workbook structure

SchedulePurposeMain consistency check
Borrower and assumptionsIdentify the entity, periods and projection basisSame details throughout the report
Operating statementExplain sales, costs, interest and profitProfit agrees with the balance-sheet movement
Balance sheetShow assets, liabilities and net worthBoth sides balance for each year
Current assets and liabilitiesExplain the working capital cycleClassifications agree with the balance sheet
MPBF and turnover methodPresent working capital assessmentInputs and margin definitions are consistent
Fund flow, cash flow and ratiosExplain financing movements and financial capacityUse the same underlying statements

A term-loan proposal may also need depreciation, repayment, DSCR and other schedules. Include what the lender requests and what is necessary to explain the borrowing. A large pack with unexplained figures can be harder to appraise than a focused pack with clear supporting records.

Step 1: Assemble the source information

Collect signed historical financial statements, the latest provisional accounts, loan statements and relevant tax records. Keep customer and supplier ageing, inventory details, fixed-asset schedules and information about contingent obligations. Mark the source and date of each input so the reader can distinguish accounting evidence from management estimates.

Use consistent units. A workbook mixing rupees and lakhs can appear to balance while containing serious errors in supporting schedules. Label each year as audited, provisional or projected as appropriate. Do not describe a management estimate as audited merely because it appears beside audited figures.

Step 2: Enter and reconcile the operating statement

Separate revenue, direct costs, operating expenses, finance costs and tax. Check whether historical presentation is comparable across years. If a major expense moved between headings, explain the reclassification rather than presenting the change as an improvement in margins.

Base projected turnover on capacity, prices, orders, demand and achievable utilisation. Project costs using their actual drivers. A fixed rent should not automatically grow in the same proportion as turnover, while raw materials may change with output. Explain significant assumptions and avoid using a growth rate solely to achieve a desired loan figure.

Step 3: Build the balance sheet and holding levels

Link retained profit, capital contributions, drawings, fixed-asset additions, depreciation and loan repayments across years. Project inventory, receivables and supplier balances using a defensible operating cycle. Holding levels must identify their calculation base: inventory days based on cost are different from receivable days based on sales.

Review customer concentration and seasonality. An annual closing balance may understate peak stock or credit requirements. If the bank asks for peak funding, explain the additional working separately. Do not increase receivables or inventory without a business reason just to produce a larger assessment.

Step 4: Apply the working capital methods correctly

For these formulas, Other Current Liabilities means current liabilities excluding bank borrowings. Keep that definition consistent across the balance sheet and assessment schedule. Otherwise a formula can double-count or omit financing and produce a misleading borrowing requirement.

  • MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). The borrower's margin is 25% of the working capital gap.
  • MPBF Method II = 75% x Total Current Assets - Other Current Liabilities. The borrower's margin is 25% of total current assets.
  • Turnover method: working capital requirement = 25% of projected annual turnover; borrower margin = 5% of turnover; bank finance up to 20% of turnover.

For example, with current assets of Rs 100 lakh and other current liabilities of Rs 20 lakh, Method I gives Rs 60 lakh and Method II gives Rs 55 lakh. These are assessment workings, not sanctioned amounts. Applicability and the lender's final assessment depend on the borrower and facility. Do not present all methods as interchangeable entitlements.

Step 5: Review ratios and debt service

Calculate the current ratio from current assets and current liabilities using the bank's definitions. State the basis for debt-equity and TOL/TNW rather than using those labels for the same ratio. TOL/TNW compares total outside liabilities with tangible net worth; the adjustments to net worth should be transparent.

Where term debt exists, match DSCR to the profit, depreciation, interest and principal repayment schedules. A repayment holiday should agree with documented assumptions or actual sanction terms. Finxora provides 20+ financial ratios, but the preparer must still review the inputs and explain unusual movements. A calculated ratio is only as dependable as its source figures.

For the related preparation guidance, see financial statement review for a bank loan.

Step 6: Check the Excel file before sharing

  1. Check totals and the balance-sheet equation for every year.
  2. Trace important formulas and identify any overwritten calculation cells.
  3. Reconcile opening and closing cash, loans and capital movements.
  4. Review print areas, year headings, decimal places and amount units.
  5. Compare Excel, PDF and supporting documents for consistent figures.

Keep an approved version and a short change record. Remove accidental personal information before sending the workbook, while preserving the supporting evidence needed for appraisal. Ask the lender whether it requires editable Excel, a signed PDF or both. A clean submission combines the requested format with reliable figures and explanations that can withstand follow-up questions.

Frequently Asked Questions

Published on March 17, 2026

Updated on November 18, 2026

Back to Blog

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