13-week Excel cash forecast with three scenarios by Jasper Addyman13-week Excel cash forecast with three scenarios by Jasper Addyman

13-week Excel cash forecast with three scenarios

Portfolio project
Jasper Addyman
Original studio demonstration using fictional data. I built an editable Excel model for a services business. It links 26 invoices, split payments and scheduled costs to a 13-week cash forecast. A dropdown switches Base, Downside and Upside collection assumptions. The dashboard identifies when cash falls below the minimum balance. In the base case, the low point is GBP 881 below the cash floor. The downside reaches negative GBP 33,109. I checked all three scenarios against an independent calculation and tested that the workbook flags an unmatched payment. The model includes source registers, a weekly forecast, scenario controls and a dashboard for review.
Weekly refresh example
I rolled the model forward seven days using two fictional bank exports. Opening cash reconciled to £19,700 with zero difference. I excluded one duplicate export row and kept a £400 receipt in bank cash while flagging it for invoice allocation. Under the Base assumptions, the refreshed model first drops below the £12,000 buffer in the week beginning 12 January 2027.
I verified all 13 weeks in Base, Downside and Upside against an independent calculation. The weekly handover includes the refreshed workbook, a reconciliation and a short list of decisions for the finance team. This example was built with AI assistance and tested using fictional data.

0 likes · 1 view · Nov 10, 2026

Original Excel demo linking invoices and payments to a checked 13-week cash forecast with three scenarios.

Tags