What an SBI CMA data Excel format is for
CMA stands for Credit Monitoring Arrangement. The pack carries the borrower's audited history, the current year's estimated figures and the projected years, arranged in the statements a bank's credit team reads before sanctioning working capital limits and at each annual review. When a branch asks for CMA data in Excel, it means an editable workbook with the schedules in its checklist, not a scanned printout.
State Bank of India, like other lenders, works from its own internal format and the checklist issued for the account. Requirements vary by branch, facility and scheme, so the branch's current checklist decides what goes into the file. A workbook found online is useful only if it matches that checklist.
Before you download anything called an SBI CMA format
A search for a free download returns dozens of spreadsheets with nothing said about who prepared them or for which facility. A familiar bank name in the file name does not establish that the bank issued the workbook or that the branch will accept it. Four checks save time:
- The source. Look for a note on who prepared the template and when. A file with no version and no author is worth less than a blank workbook with the right headings.
- The year columns. A CMA pack needs the years the bank asked for, typically two or three audited years, the current estimated year and one to three projected years, with the comparative columns the credit team expects. Templates built for a single year rarely extend cleanly.
- The statements. Compare the workbook with the bank's checklist. A template missing the fund flow statement or the MPBF computation will have to be rebuilt at the last minute.
- The unit and rounding. Ask whether figures are to be shown in rupees, thousands or lakhs, whether provisional figures are to be marked, and whether the bank wants the workbook with signed statements attached.
The statements a CMA pack usually contains
| Statement | What it shows |
|---|---|
| Operating statement | Sales, direct and indirect costs, interest, tax and net profit for each year |
| Analysis of balance sheet | Capital, reserves, borrowings, current liabilities and assets, year on year |
| Comparative statement of current assets and current liabilities | Movement in each current item and the related ratios |
| MPBF computation | Maximum permissible bank finance under the first and the second method |
| Turnover method computation | Working capital assessment for smaller MSME accounts |
| Fund flow and cash flow statements | Sources and uses of funds, and the cash position for each year |
| Ratio analysis and DSCR | Liquidity, profitability, leverage and activity ratios, with debt servicing coverage |
Working capital assessment: MPBF and the turnover method
Three figures sit at the heart of a working capital proposal, and the credit team will want all of them from the same balance sheet.
Under the first method, maximum permissible bank finance is 75% of the working capital gap, that is, 75% × (total current assets − current liabilities other than bank borrowings). The borrower brings in the remaining 25% of the gap as margin from long-term funds, and the bank finances the rest.
Under the second method, maximum permissible bank finance is (75% × total current assets) − current liabilities other than bank borrowings. Here the borrower's margin is 25% of total current assets, so this method gives a lower bank finance figure than the first method. Banks may work with either method depending on the account and the borrower's ability to fund the larger margin.
Smaller MSME accounts are often assessed under the turnover method recommended by the Nayak Committee. The working capital requirement is 25% of projected annual turnover, the borrower contributes a margin of 5% of turnover, and bank finance goes up to 20% of turnover. Which method binds is a question for the branch, which is why preparing all three readings from the same figures makes the discussion shorter. The exact requirement varies by bank and by scheme.
Errors a downloaded template does not prevent
A template carries headings and formulas; it does not carry judgement. The points a credit team raises again and again are these:
- The balance sheet in the workbook does not tally, because a schedule was edited without updating the totals.
- Current assets are stretched to support a higher limit, with receivables and stock rising faster than sales.
- Growth assumptions appear without any basis in past performance or in the order book.
- Ratios move sharply between years and no note explains the movement.
- Debt service coverage for the projected years leaves no cushion after the proposed instalments.
- The term loan schedule is missing, or the EMI in the projections does not match the proposed repayment.
- Depreciation in the operating statement does not agree with the fixed asset schedule.
- The estimated year does not reconcile with the books, and the difference goes unexplained.
When a downloaded template stops being enough
The first proposal can often be assembled in a careful workbook. The second year is where the workbook strains. A renewal needs last year's actuals in place of estimates, revised projections, and a comparative view of what moved. A second facility, an enhancement or a takeover from another bank adds statements and alters the working capital computation. Each change has to flow through the operating statement, the balance sheet, the fund flow statement and the MPBF working together, and in a hand-built file that means retyping the same figure in several places and reconciling the differences afterwards.
Preparing the pack with Finxora
Finxora's CMA report software is built for the pack banks ask for. The borrower's figures are entered once, and the app builds the operating statement, the analysis of balance sheet, the comparative statement of current assets and current liabilities, the MPBF computation under both methods, the turnover method computation, the fund flow and cash flow statements, DSCR analysis, ratio analysis covering 20+ financial ratios, sensitivity and break-even analyses, the depreciation schedule and the EMI schedule. Change an assumption and the statements recalculate together, so the working capital computation always agrees with the balance sheet in the same file. Audited and provisional figures already entered in the balance sheet module can seed the historical years of the report instead of being keyed in a second time.
The report exports as a formatted PDF for submission, or as an Excel workbook or Word document for further work, with free choice of which statements go into each download. A filled sample CMA report sits on the samples page, so the format can be compared with the branch's checklist before any data is entered, and the CMA plans are on the CMA pricing page.
Where to start
Ask the branch for its current checklist, then decide whether the file is a one-off exercise or one that will be renewed each year. For a one-off proposal a clean workbook may serve. For a borrower whose limits are reviewed annually, a single linked file saves the retyping and the reconciliation that a downloaded template leaves behind.
