The bank's requirement determines the projection period
There is no single projection period that fits every Credit Monitoring Arrangement (CMA) report. A working capital renewal and a new term loan raise different credit questions. The renewal focuses on the operating cycle and the proposed limit; the term loan also requires evidence that cash generation can support instalments over the repayment period. Ask the bank for its required year columns before building the report.
A reference to three or five years can also be ambiguous. It may mean total statement columns, including historical years, or future projections alone. Confirm the exact financial years, the status of the current year and the period expected for repayment analysis. This prevents a technically complete report from arriving with the wrong coverage.
Separate actual, estimated and projected figures
Historical actuals show what the business has achieved. They should reconcile with the relevant accounts and supporting schedules. Identify whether each completed year's figures are audited or unaudited. Do not call a figure audited merely because the period has ended or the same number appeared in an earlier bank submission.
The current year may need an estimate based on results available to date and expectations for the remaining months. State the cut-off date for provisional accounts and explain how the full-year estimate was derived. Future years are projections based on explicit assumptions. Keeping these categories separate allows a reviewer to judge the evidence behind each column.
| Column type | Evidence | Review focus |
|---|---|---|
| Historical actual | Accounts and supporting schedules | Reconciliation and classification |
| Current-year estimate | Provisional results plus remaining-period assumptions | Seasonality and progress against plan |
| Future projection | Commercial and financing assumptions | Reasonableness and sensitivity |
Working capital renewal: focus on the operating cycle
For cash credit or overdraft renewal, the central question is how much finance the operating cycle requires. Sales, stock holding, receivable collection and supplier credit determine much of that requirement. The bank may request historical comparisons, a current-year estimate and specified forward years. Use its checklist rather than a generic article's suggested count.
Support the projected limit with a business explanation. Higher sales can increase debtors and stock even when profit improves. Conversely, faster collections may reduce funding needs without reducing turnover. Explain changes in holding levels using actual collection experience, supplier terms and the nature of inventory. A growth percentage alone does not explain a larger limit.
Term loans: cover the repayment obligation
For a term loan, confirm that cash flow and debt servicing analysis cover the proposed repayment period, including any moratorium. The bank may accept a core CMA pack with a different number of columns alongside a longer repayment schedule. Agree the presentation instead of forcing every schedule into an identical width.
If a proposal includes a seven-year repayment period, stopping the debt servicing analysis after three projected years leaves later instalments unexplained. Extend the relevant schedules through the remaining tenure or obtain the bank's specific instructions. Sensitivity analysis helps assess uncertainty; it does not replace missing repayment coverage.
Link interest and principal to the proposed repayment terms. A moratorium on principal does not by itself establish how interest is paid or capitalised. Explain the assumed disbursement timing, commercial operations date and repayment start. Where the terms remain indicative, label them as assumptions awaiting lender confirmation.
New businesses need a different evidence base
A new enterprise cannot supply operating history that does not exist. State that position directly and support projections with project cost estimates, promoter contribution evidence, capacity assumptions, quotations and commercial research. Opening balances and investment timing must connect with the first operating year.
For an expansion, distinguish the existing business from the proposed addition. Show when new capacity becomes available, how utilisation increases and which costs begin before revenue. A partial first year should not be compared with a full later year without explaining the difference. The projection horizon should capture the implementation and stabilisation periods relevant to the bank's assessment.
Build a clear year map before entering figures
- List each requested financial year in chronological order.
- Mark each column as audited actual, unaudited actual, estimate or projection.
- Record the provisional accounts cut-off date.
- Map project completion, disbursements and repayment dates to those years.
- Confirm whether the bank needs additional monthly or quarterly workings.
- Record the agreed horizon for cash flow and debt servicing schedules.
For example, a lender might request two completed years, one current-year estimate and three future years for a particular proposal. That is six columns with three projected years, not six projected years. Treat this as a possible presentation, not a universal banking rule. The agreed checklist controls the actual report.
Make later years defensible
Longer projections need more explanation because uncertainty grows with time. Split sales growth into volume, price and capacity assumptions where possible. Relate material costs to purchase terms, wages to staffing plans and overheads to actual business activity. Avoid extending every line by the same percentage simply to fill additional columns.
Review working capital independently in each year. Debtor days, inventory days and creditor days should reflect the business model rather than whichever figures produce the requested limit. Confirm that projected depreciation, asset purchases, tax and owner withdrawals are included. A balancing cash figure can conceal an unsupported funding gap if it is not reviewed.
Test weaker sales, slower collections and higher costs using reasonable scenarios. Explain whether the borrower would need a lower investment outlay, more promoter funds or different repayment terms. Keep the base case grounded in evidence; a favourable scenario should not be used to disguise a weak repayment position.
Use software to preserve consistency across years
Finxora's CMA report software links financial statements across reporting years and produces MPBF, cash flow, DSCR and ratio analysis. Its PDF, Excel and Word exports support review of the report pack. These functions help maintain consistency, while the preparer remains responsible for selecting the correct years and supporting the assumptions.
Review the sample reports against the lender's requested presentation before starting. Where a proposal centres on a new investment, discuss whether the bank also requires a Detailed Project Report. The documents can support the same application while answering different questions about the business and proposed project.
Confirm the horizon before submission
Check that opening balances agree with previous closing balances, historical totals reconcile with accounts and every year has a clear label. Reconcile repayment totals with the proposed loan and ensure the last instalment appears in the supporting schedule. Remove obsolete columns left over from an earlier application.
The appropriate number of years is the number required to explain the facility and satisfy the bank's checklist with credible evidence. Adding more columns does not strengthen an unsupported forecast. A clearly documented horizon, consistent statements and complete repayment coverage give the reviewer a sounder basis for assessing the proposal.
