13-week Excel cash forecast with three collection scenarios

An original portfolio sample built for a fictional services business.

The brief. Show when cash could fall below a minimum balance and how collection delays change the outlook.

The workbook. I linked 26 invoices, split payments and scheduled costs to a 13-week cash forecast. A dashboard dropdown switches between base, downside and upside collection scenarios. The reconciliation flags unmatched payments so they can be resolved before reporting.

The result. The base case dips £881 below the cash floor before recovering. In the downside case, the lowest balance is negative £33,109. I checked all three scenario totals against a separate calculation and tested the unmatched-payment rule.

Tools. Microsoft Excel, scenario modelling, dashboard reporting and data validation.