← Reporting portfolio

Margin Max / Financial & operating control

13-week cash forecast

See the weekly cash position and the effect of one delayed collection.

Worked example · Illustrative receipts and payments. One consistent dataset drives the tables and headline balances; the delay scenario changes timing only, with no assumed new revenue.

13-week cash forecast overview

Weekly cash movement

WeekOpening cashReceiptsPaymentsNet movementClosing cash
1$250,000$120,000$105,000$15,000$265,000
2$265,000$90,000$115,000−$25,000$240,000
3$240,000$110,000$120,000−$10,000$230,000
4$230,000$130,000$110,000$20,000$250,000
5$250,000$85,000$125,000−$40,000$210,000
6$210,000$125,000$115,000$10,000$220,000
7$220,000$90,000$130,000−$40,000$180,000
8$180,000$100,000$110,000−$10,000$170,000
9$170,000$135,000$120,000$15,000$185,000
10$185,000$105,000$110,000−$5,000$180,000
11$180,000$120,000$125,000−$5,000$175,000
12$175,000$110,000$115,000−$5,000$170,000
13$170,000$140,000$120,000$20,000$190,000

Delayed-collection sensitivity

WeekBase closing cashDelay scenarioDifference
4$250,000$190,000−$60,000
5$210,000$150,000−$60,000
6$220,000$160,000−$60,000
7$180,000$180,000$0

Forecast assumptions

Receipts represent expected cash collection, not recognized revenue. Payments include payroll, suppliers and other operating commitments. No new borrowing, owner distributions or investment cash flows are assumed. Closing cash rolls into the following week.

Collection sensitivity

A $60,000 receipt moves from Week 4 to Week 7. Weeks 4–6 cash is therefore $60,000 below base, returning to base in Week 7. The scenario low point is $150,000 in Week 5. Assign collection ownership and update the forecast weekly.