What automating a CMA report means
A CMA report is a fixed pack of interlinked statements: the operating statement, the analysis of balance sheet, the comparative statement of current assets and current liabilities, the computation of maximum permissible bank finance, the fund flow and cash flow statements, DSCR and the ratio analysis, all built for one borrower in the format Indian banks read. Automation does not change that pack. It changes where the arithmetic happens. Instead of linking cells across a workbook, you enter the borrower's figures once and the software builds every statement from them.
This tutorial walks through a first CMA report in Finxora, from setting up the borrower's master to downloading the PDF, and then through what changes when the same file is renewed the following year.
Before you start: the documents
- Balance sheets and profit and loss accounts for the last three years.
- Bank statements and the existing sanction letter, where a limit is already running.
- Income tax returns, and the provisional figures for the current year.
- Details of existing term loans: amount, rate, tenure and the EMI being paid.
Step 1: Set up the borrower master
Create the master with the borrower's name, constitution, PAN, GST and activity details, and choose the years the report will cover. A CMA pack normally carries the last audited years, the current provisional year and the projections the bank asks for. Keeping all of them in one master is what makes the second year's work small.
Step 2: Enter the historical years
Key in the audited and provisional figures, or pull them from a balance sheet already prepared in Finxora, which saves keying the same trial balance twice. Figures that repeat across statements, such as sales, opening stock, creditors and term-loan balances, are entered once and picked up by each statement that needs them.
Step 3: Set the projection assumptions
Sales growth, gross and net margins, the working capital cycle and existing loan details drive the projected years. You can enter them yourself, or let Generate with AI estimate starting assumptions from the firm and industry and then adjust anything you disagree with. Because the statements are linked, a change in sales growth flows through the operating statement into the balance sheet, the fund flow statement and the MPBF computation on its own.
Step 4: Review the statements the app builds
The pack covers:
- Operating statement: sales, direct and indirect costs, interest, tax and net profit for every year.
- Analysis of balance sheet: capital, reserves, borrowings, current liabilities and assets, year on year.
- Comparative statement of current assets and current liabilities, with changes and movement ratios.
- Computation of MPBF under the first method and the second method.
- Turnover method computation for working capital assessment alongside the MPBF methods.
- Fund flow statement: sources and uses of long-term funds across the reporting years.
- Cash flow statement and DSCR analysis for debt servicing comfort.
- Ratio analysis across liquidity, profitability, leverage, activity, expense and growth.
- Sensitivity analysis and break-even analysis for the projected years.
- Depreciation schedule linked to the fixed assets in the balance sheet.
- EMI schedule for term loans attached to the borrower.
- AI-drafted business introduction and project narrative, editable before download.
Two statements are worth reading together. The fund flow statement shows where long-term funds came from and where they went, while the cash flow statement shows the movement in cash during the year; a projected year where profit looks healthy but cash flow is negative usually means debtors or stock are absorbing the surplus, which is exactly what a credit officer will ask about. The comparative statement does the same work year on year, showing how each head of current assets and current liabilities moved and by how much. Reading those three before you open the download dialog saves a revision round with the bank.
Step 5: Check MPBF, DSCR and the ratios
MPBF decides the limit, so it deserves its own read. The software computes both methods from the same balance sheet:
Method I: 75% x (Total Current Assets - Other Current Liabilities).
Method II: 75% x Total Current Assets - Other Current Liabilities.
In both readings, other current liabilities means current liabilities excluding bank borrowings, and the borrower brings the balance as margin. Under Method I the margin is 25 percent of the working capital gap; under Method II it is 25 percent of total current assets. For an MSME within the turnover-method threshold, the Nayak Committee working is shown as well: the working capital requirement is 25 percent of projected annual turnover, the borrower's margin is 5 percent of turnover, and bank finance can go up to 20 percent of turnover.
DSCR is computed for every projected year as receipts (net profit plus depreciation plus term-loan interest) divided by repayments (principal plus interest), with an average DSCR row beside the yearly figures. The ratio analysis covers 20+ financial ratios, each measured against bank benchmarks, and every one of them recalculates the moment an input changes.
Step 6: Format and download
Choose which statements to include, so a renewal file and a first application can carry different annexures. If the figures need rounding for presentation, set rounding in the reporting header; the screen shows rounded values while the JSON export keeps exact figures. Add CA and UDIN details where the report goes out under the firm's signature. The finished pack exports as a formatted PDF, an Excel workbook or a Word document.
What changes at renewal
Working capital limits are normally reviewed every twelve months, and the review needs fresh CMA data: updated provisional figures and revised projections. Because the borrower's master is saved, the renewal updates those years instead of rebuilding the file, and the comparative statements show the movement the bank wants to see. Each year's closing balances become the opening figures for the next, so the history stays consistent without re-entry.
Where to see a finished pack
A filled sample CMA report in the samples library shows the operating statement, balance sheet, MPBF computation and ratio tables as they print. Compare it with the format your bank shared before you begin, then read more on the CMA report software page or see the CMA plans.
