EXCEL · EDITABLE

Cash-Flow Forecast Workbook

13-week rolling model · Automatic alerts
WeekInflowOutflowBufferStatus
W114,20011,8002,400OK
W212,00013,500-1,500SHORTFALL
W318,90011,2007,700OK
W410,50010,900-400WATCH
W515,60015,100500WATCH
Conditional formatting · Three scenarios · No macros