Form IV: Comparative Statement of Current Assets & Liabilities – Used specifically to calculate working capital gaps. Form V: MPBF Calculation
Automatic calculations of financial health indicators.
This statement focuses purely on working capital changes. It helps the bank understand the company's liquidity position by analyzing how inventory cycles, debtor collection periods, and creditor payment schedules change over time. 5. Calculation of Maximum Permissible Bank Finance (MPBF)
The official, authoritative method to download data is through the . The process involves: cma data report in excel format new
: Check that the generated Debt-Equity and Current Ratios fall within acceptable bank limits (typically a Current Ratio > 1.33). Fortrisk Consulting
Using outdated or generic templates is a common reason for loan delays or rejections. New tools like "CMA Builder" are emerging to address this. They allow businesses to generate "banker-ready" CMA formats in Excel that automatically map audited data, calculate ratios, flag inconsistencies, and even generate 5-year projections based on industry norms.
If you'd like to customize this framework for your specific industry, let me know: Form IV: Comparative Statement of Current Assets &
– A comparative Profit & Loss account showing historical and projected performance. Form III: Analysis of Balance Sheet
Raw material costs, manufacturing power, labor, and depreciation.
: two years of audited history, one provisional year, and two years of future projections Core Components of a CMA Excel Report It helps the bank understand the company's liquidity
Preparing a CMA report can be complex, but it follows a logical flow:
: Stick to one clean font family across all sheets. Arial, Calibri, or Segoe UI at 10pt or 11pt work best.
Ensure the audited figures match your income tax returns.