Skip to content
CreditBriefAdd your pay

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.