: Banks typically mandate a Current Ratio of 1.33 or higher . If your Excel model outputs a ratio below this, it signals a working capital deficit that may stall loan approval.
: Indicators of operational efficiency. Step-by-Step Guide to Preparing a CMA Data Report in Excel
Provide provisional or estimated figures for the ongoing financial year. If audited statements are not yet available, these should be as accurate as possible based on your current performance.
This section isolates the company's short-term liquidity position. It lists individual working capital components like raw materials, work-in-progress, finished goods, sundry debtors, and creditors. The net holding periods calculated here directly feed into the working capital cycle formula. 5. Calculation of Maximum Permissible Bank Finance (MPBF) cma data report in excel format new
: Tracks where capital is sourced and how it is utilized over time.
A standard bank-approved CMA report is divided into several interconnected sheets: Operating Statement
Nothing signals professionalism to a bank's credit committee like a clean, well-organised, and internally consistent Excel workbook. It shows that you have taken the time to understand their requirements and have prepared your application with care. : Banks typically mandate a Current Ratio of 1
What is the ? (e.g., manufacturing, services, trading)
This is the most critical calculation in the entire CMA report. Following standard banking guidelines (such as the Tandon or Nayak Committee recommendations), this formula determines the maximum amount of working capital a bank can lend to the business based on its current assets and liabilities. 6. Fund Flow Statement
To pass banking audits, use exact formulas for critical metrics. Build these natively into your Excel sheets: Step-by-Step Guide to Preparing a CMA Data Report
Keep inventory and debtor days relatively stable across projection columns unless a structural change in business operations justifies an adjustment.
The historical columns in your CMA template must perfectly match your audited financial statements. However, the estimated and projected columns require logical economic modeling:
: Company Mitra offers a standard editable Excel format for general banking purposes.
If you manage a portfolio of 50 properties, generating 50 separate PDFs is madness. A allows you to analyze all 50 properties on one consolidated spreadsheet. Use filters, conditional formatting, and charts to spot outliers instantly.
Split of limits across different consortium or multiple banking partners. Statement II: Operating Statement (Profit & Loss Account)