CMA data template in Excel
A six-form CMA data layout with working formulas, from the operating statement to MPBF and fund flow.
What's inside
- Form I: existing and proposed limits
- Form II: operating statement
- Form III: balance sheet, with a balance check
- Form IV: current assets and liabilities
- Form V: MPBF, Method II
- Form VI: fund flow, with a check row
Works in Excel and Google Sheets. Use made-up or anonymised figures only. Formats differ by institution, so check yours. Indicative only. Verify against your institution's policy.