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
| Schedule | Purpose | Main consistency check |
|---|---|---|
| Borrower and assumptions | Identify the entity, periods and projection basis | Same details throughout the report |
| Operating statement | Explain sales, costs, interest and profit | Profit agrees with the balance-sheet movement |
| Balance sheet | Show assets, liabilities and net worth | Both sides balance for each year |
| Current assets and liabilities | Explain the working capital cycle | Classifications agree with the balance sheet |
| MPBF and turnover method | Present working capital assessment | Inputs and margin definitions are consistent |
| Fund flow, cash flow and ratios | Explain financing movements and financial capacity | Use 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
- Check totals and the balance-sheet equation for every year.
- Trace important formulas and identify any overwritten calculation cells.
- Reconcile opening and closing cash, loans and capital movements.
- Review print areas, year headings, decimal places and amount units.
- 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.
