How to Prepare CMA Data for a Bank Loan
CMA data is the pack an Indian bank asks for before sanctioning working capital finance and at every annual renewal. CMA stands for Credit Monitoring Arrangement: past and projected operating statements, balance sheet analyses, fund flow and cash flow statements, ratio analysis and the maximum permissible bank finance. Prepared well, it shows the business as a going concern and the amount of short term finance its operating cycle can support. Prepared badly, it delays sanction or reduces the limit. This guide walks through the preparation from the first document to the final submission, merging the practical steps that usually live in separate checklists.
Step 1: Understand the Bank's Requirements
Before collecting figures, confirm what the bank wants. Ask the relationship manager for the CMA format, the number of projected years, whether the turnover method is required and whether a project report accompanies the working capital proposal. Different banks emphasise different annexures, and some schemes add their own. Knowing the format first avoids rebuilding the file after the first review.
Step 2: Gather the Financial Records
The quality of the CMA depends on the quality of the inputs. Collect:
- Audited balance sheets and profit and loss accounts for the last three years.
- The current year's provisional statements.
- Bank statements for all operating accounts for the last twelve months.
- Income tax and GST returns.
- Stock and book debts statements already submitted to the bank.
- Details of existing limits, term loans, interest rates and repayment schedules.
- Capital expenditure plans and any subsidy approvals.
Organise these by year so the historical series is easy to check. Where the balance sheet has already been prepared in Finxora, the audited and provisional years can seed the CMA report directly.
Step 3: Prepare the Financial Statements
The core of the pack is accuracy and consistency across statements and years.
Operating Statement
Carry sales, direct costs, gross profit, indirect expenses, interest, depreciation, tax and net profit for every year. Keep the classification of costs consistent across years so the trend reads cleanly.
Balance Sheet Analysis
Present capital, reserves, borrowings, current liabilities and current assets year on year. Closing balances must carry forward into the next year's opening balances.
Cash Flow and Fund Flow
The fund flow statement shows sources and uses of long term funds; the cash flow statement shows operating, investing and financing cash. Both must agree with the operating statement and the balance sheet.
Step 4: Calculate the Ratios
Finxora computes the full CMA ratio set from the operating statement and balance sheet figures and measures each one against bank benchmarks. Review at least:
- Liquidity: current ratio and quick ratio.
- Profitability: gross profit ratio, net profit ratio and return on capital employed.
- Leverage: debt equity ratio, total outside liabilities to net worth, and interest coverage.
- Activity: stock turnover, receivables turnover and payables turnover.
- Debt service: DSCR where a term loan is involved.
Compare the ratios with industry levels and explain any movement rather than leaving the credit officer to interpret it.
Step 5: Project the Future Years
Projections usually run one to three years ahead and must be built from drivers, not from a single growth percentage. Set sales growth by product or customer, gross margin, the working capital cycle in days, existing loan repayments and planned capital expenditure. Write down every assumption in the assumptions section, with the basis for it. A projection that cannot be explained will not be accepted.
Step 6: Compute MPBF and Working Capital
The maximum permissible bank finance decides the limit. Compute Method I and Method II from the same balance sheet and place the turnover method requirement beside them:
- Method I: 75 percent of (current assets minus current liabilities other than bank borrowings).
- Method II: 75 percent of current assets, minus current liabilities other than bank borrowings.
- Turnover method: total working-capital requirement is 25 percent of projected annual turnover, with a 5 percent borrower margin and 20 percent bank finance, subject to the bank's current requirements and policy.
The bank takes the lower of Method I and Method II, so both must be in the file. Excess borrowing and margins on working capital should be shown alongside. Seeing all three readings together lets you defend the assessed limit.
Step 7: Analyse Trends and Add Commentary
Numbers alone do not secure a limit. Add written commentary that covers revenue growth and its drivers, movement in margins, cash flow patterns, significant ratio changes, seasonality and any major event such as an acquisition or a new product. Be transparent about negative trends and state the corrective steps. The commentary is what converts data into a credit decision.
Step 8: Prepare the Loan Repayment Schedule
Where a term loan is part of the proposal, include a repayment schedule showing the loan amount, interest rate, repayment frequency and period, and demonstrate the ability to repay from projected cash flows. A sensitivity case showing the effect of lower sales or higher costs on the schedule strengthens the file.
Step 9: Document Assumptions and Supporting Data
Clearly document all assumptions underlying the projections, including sales growth, cost ratios, working capital days, capital expenditure and interest rates. Provide supporting data such as market research, industry benchmarks and historical trends. The more transparent and well supported the assumptions, the more credible the pack.
Step 10: Review, Refine and Submit
Before submission, check the file for accuracy, consistency and completeness. Confirm that all calculations agree, that historical and projected figures use the same treatment, and that supporting documents are attached. Have a financial professional review the pack where the amount is large. Submit with the loan application and follow up with the bank, keeping copies of everything submitted.
Common Mistakes to Avoid
- Using different accounting treatment across years, which breaks trend analysis.
- Projecting sales without linking stock and receivables to the working capital cycle.
- Presenting only one MPBF method when the bank computes both.
- Omitting the turnover method when the sanction letter asks for it.
- Leaving assumptions undocumented, which forces a second round of questions.
For the related preparation guidance, see what a CMA report for a bank loan contains.
How Finxora Helps
Finxora prepares the complete CMA data pack from one set of inputs, with the operating statement, balance sheet analysis, comparative statement of current assets and current liabilities, MPBF under both methods, fund flow and cash flow statements, turnover method computation, ratio analysis, sensitivity and break even analysis, depreciation and EMI schedules, and an AI drafted business introduction that stays editable. Saved figures stay linked across years and projections link across statements, so a change in sales growth flows through to the balance sheet, the fund flow and the MPBF without retyping. See the CMA report software page, the sample reports and CMA pricing.
