=IFERROR([Total Current Assets] / [Total Current Liabilities], 0) Step 4: Apply Formatting and Validation Rules

Raw material costs, manufacturing power, labor, and depreciation.

: Check that the generated Debt-Equity and Current Ratios fall within acceptable bank limits (typically a Current Ratio > 1.33). Fortrisk Consulting

To help tailor a template specific to your business needs, let me know:

What is the total or working capital limit you are applying for?

Measures short-term liquidity (Ideal range: 1.33 to 2.0).

Populate Columns B and C using audited balance sheets and profit & loss statements provided by your chartered accountant. Never hardcode totals; use =SUM() formulas to maintain model integrity. Step 3: Define Growth Assumptions

A complete, bank-ready CMA data report consists of seven distinct spreadsheets or statements. Each sheet serves a specific analytical purpose, building upon the previous data points.

Organize your columns horizontally to represent consecutive financial years: Column A: Financial Particulars Column B: Audited Year 1 (e.g., FY 2024) Column C: Audited Year 2 (e.g., FY 2025) Column D: Estimated Year (e.g., FY 2026) Column E: Projected Year 1 (e.g., FY 2027) Column F: Projected Year 2 (e.g., FY 2028) Step 2: Input Historical Audited Data

A professional CMA Excel template typically consists of the following key statements: Name of Statement Description Current & Proposed Limits