How might cash move
over the next 13 weeks?
Acme Kitchens · Starting cash at June 30, 2026 · Forecast weeks July 3–October 1, 2026 · Fictional company
What this forecast shows: Under the recorded base assumptions, cash fluctuates between $301,000.00 and $359,000.00 at the end of each forecast week. It ends $8,000.00 below the June 30 balance. This is a projection from June, not a statement of what later happened. Without a defined minimum cash requirement, it cannot establish whether the balance is enough.
Cash movement across the forecast
Customer receipts add cash; vendor payments, payroll and other operating cash use it. The model has no revolver draws or repayments in these 13 rows.
Weekly forecast
USD · outflows shown as positive amounts to subtract · weekly closing balance is the next week's opening balance.
| Week | Dates | Opening cash | Receipts | Vendor | Payroll | Other | Closing cash |
|---|---|---|---|---|---|---|---|
| 01 | 2026-07-03 – 2026-07-09 | $335,000.00 | $120,000.00 | $78,000.00 | $56,000.00 | $18,000.00 | $303,000.00 |
| 02 | 2026-07-10 – 2026-07-16 | $303,000.00 | $128,000.00 | $84,000.00 | $0.00 | $18,000.00 | $329,000.00 |
| 03 | 2026-07-17 – 2026-07-23 | $329,000.00 | $136,000.00 | $90,000.00 | $56,000.00 | $18,000.00 | $301,000.00 |
| 04 | 2026-07-24 – 2026-07-30 | $301,000.00 | $144,000.00 | $78,000.00 | $0.00 | $18,000.00 | $349,000.00 |
| 05 | 2026-07-31 – 2026-08-06 | $349,000.00 | $120,000.00 | $84,000.00 | $56,000.00 | $18,000.00 | $311,000.00 |
| 06 | 2026-08-07 – 2026-08-13 | $311,000.00 | $128,000.00 | $90,000.00 | $0.00 | $18,000.00 | $331,000.00 |
| 07 | 2026-08-14 – 2026-08-20 | $331,000.00 | $136,000.00 | $78,000.00 | $56,000.00 | $18,000.00 | $315,000.00 |
| 08 | 2026-08-21 – 2026-08-27 | $315,000.00 | $144,000.00 | $84,000.00 | $0.00 | $18,000.00 | $357,000.00 |
| 09 | 2026-08-28 – 2026-09-03 | $357,000.00 | $120,000.00 | $90,000.00 | $56,000.00 | $18,000.00 | $313,000.00 |
| 10 | 2026-09-04 – 2026-09-10 | $313,000.00 | $128,000.00 | $78,000.00 | $0.00 | $18,000.00 | $345,000.00 |
| 11 | 2026-09-11 – 2026-09-17 | $345,000.00 | $136,000.00 | $84,000.00 | $56,000.00 | $18,000.00 | $323,000.00 |
| 12 | 2026-09-18 – 2026-09-24 | $323,000.00 | $144,000.00 | $90,000.00 | $0.00 | $18,000.00 | $359,000.00 |
| 13 | 2026-09-25 – 2026-10-01 | $359,000.00 | $120,000.00 | $78,000.00 | $56,000.00 | $18,000.00 | $327,000.00 |
What an owner would check next
Set a minimum cash floor. Compare the lowest projected close with the amount Acme needs for deposits owed to customers, committed purchases, payroll and a reasonable buffer. Check whether expected receipts arrive on time. If a material collection or supplier payment shifts, update the weekly forecast and test the new low point before making a spending decision.