What CMA data consists of
| Statement | What it shows |
|---|---|
| Particulars of existing and proposed limits | Current facilities against what is being sought |
| Operating statement | Past and projected P&L, typically two years actual plus projections |
| Analysis of balance sheet | Assets and liabilities in the bank's classification |
| Comparative statement of current assets and liabilities | The basis for working capital assessment |
| Calculation of MPBF | Maximum permissible bank finance |
| Fund flow statement | Movement of funds between years |
| Ratio analysis | Current ratio, TOL/TNW, DSCR and turnover ratios |
MPBF, in practice
Maximum permissible bank finance works from the borrower's current assets and current liabilities to the amount a bank may lend against the working capital gap. The borrower funds a margin from long-term sources; the bank funds the rest. Getting the classification of current assets right — what counts, at what holding level — is what moves the MPBF number, and it is the part banks query most.
Where CMA preparation goes wrong
- Projected holding levels that contradict the operating statement's cycle.
- Current assets classified inconsistently between the balance sheet analysis and the comparative statement.
- Ratios computed from a different version of the figures than the statements show.
- Projections revised in one statement but not carried through the rest.
How this tool handles it
- One input set drives every statement, so revisions propagate automatically.
- Working capital, MPBF and the ratio set are derived, not typed.
- Multi-year projections with percentage-based growth assumptions.
- Export to PDF for submission and to Excel for the client's file.