What a CMA report is, and who it is for
CMA stands for Credit Monitoring Arrangement: the data pack an Indian bank asks for when it sanctions a working capital limit, and again when it reviews that limit each year. It is not one statement but a set of interlinked ones — the operating statement for the past and projected years, the analysis of the 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, the DSCR and the ratio analysis.
The consultant's work is not confined to filling in figures. It is to present the borrower's case in the form the credit team reads, with a history that supports the projections and answers ready for the questions that follow. That is why the job starts well before any software is opened.
Step 1: collect, and verify, the documents
Start with three years of audited financial statements and income tax returns, the latest provisional accounts, twelve months of bank statements, the GST returns, and the sanction letters with repayment schedules for every existing facility. Add the security details, the promoter's net worth statement, and the order or utilisation evidence behind the sales projections.
Verification is what separates a professional file from a hastily typed one. Bank statements show whether the turnover in the accounts was actually collected, and whether EMIs, statutory dues or cheques bounced during the year. GST returns can be matched against declared turnover, and an existing loan's sanctioned limit and outstanding should agree with its repayment schedule. Differences found at this stage are a question for the client; differences found later become a question from the bank.
Step 2: build the historical years
The historical years carry the auditor's figures, entered as they stand, with the provisional year clearly marked as provisional. The balance sheet must tally and the profit and loss account must agree with the returns filed. A CMA that quietly diverges from the income tax return invites an explanation at exactly the wrong moment, so align the two before moving on. Closing balances carry forward from year to year, and where the figures already exist in a structured statement, or in a trial balance exported from Tally as XML, they can be imported rather than keyed in again.
Step 3: set the projection assumptions
Projections decide the outcome, because they are the part the borrower and the consultant control. Build sales from capacity, utilisation and selling price rather than a round growth percentage, and carry the working capital cycle through as debtor days, creditor days and stock holding, so the projected current assets follow the trade the business actually does.
Give interest its own line for each facility at the rate charged, and let each term loan's repayment sit in the schedule it belongs to. Allow for tax at the applicable rate, and keep a depreciation schedule that ties to the fixed assets in the balance sheet. Where a new limit is proposed, the projections should show what the extra finance does: the turnover it supports, the stock it funds and the interest it costs. Keep the assumptions consistent from year to year, because a margin that jumps in year three without an explanation is the first thing a credit officer will query.
Step 4: compute the ratios the credit team tests
Ratios are read together, not one at a time. The current ratio is compared with the Tandon working reference of about 1.33; TOL/TNW measures how much of the net worth sits outside the business; debt-equity and interest coverage test the comfort behind the borrowing; and the DSCR shows whether the cash generated can carry the principal and interest falling due each year.
- DSCR = (net profit after tax + depreciation + term loan interest) ÷ (term loan principal + interest) for the year, with the average DSCR shown alongside.
- MPBF Method I = 75% × (total current assets − current liabilities other than bank borrowings).
- MPBF Method II = 75% × total current assets − current liabilities other than bank borrowings.
Method I leaves the borrower a margin of 25% of the working capital gap, while Method II requires 25% of total current assets. Where a small MSME is assessed on the turnover method, the working capital requirement is taken as 25% of projected annual turnover, the borrower's margin as 5%, and bank finance up to 20% of turnover. Banks apply the method their credit policy prefers, and a good file shows the working so the officer can lay the bank's own ceiling beside it.
Step 5: present the file the way it is read
The comparative statement earns its place because it shows movement: what grew, how the increase was funded, and whether the ratios improved. Explanations belong beside the figures they explain, not in an annexure nobody opens. Keep the annexures the checklist names, make sure the years run consecutively, and export a clean PDF with year columns and ratio tables formatted for print.
Where the same borrower also has a term loan proposal, the CMA data and the project report should agree on the common years, the existing loans and the promoter contribution. Two packs that contradict each other raise more questions than either one answers on its own.
Where software earns its place in the practice
A consultant may run dozens of files at once, each with its own renewal date. Working on spreadsheets means every amendment has to be carried through each statement by hand, and a link missed once shows up as a balance sheet that does not tally.
Finxora's CMA report software keeps one set of inputs behind the operating statement, balance sheet, comparative statement, fund flow, cash flow, DSCR, ratio analysis, turnover method and MPBF, so a change in an assumption recalculates the pack and the download keeps the bank's format. Historical figures can come from a balance sheet prepared in the same account, or from a Tally trial-balance XML import, and each borrower's master stays saved for the next renewal. See CMA report software for the statements produced, the samples library for a filled CMA report you can read before signing up, and the CMA pricing page for the plans.
Software does not choose the assumptions or answer the bank's queries. Those remain the consultant's work, which is exactly where the value of a good loan consultant sits.
