13-week cash forecast
Opening cash
$48,214,900
Wk 1 · Jul 21
Projected close wk 13
$53,061,300
+$4,846,400
Lowest weekly balance
$44,902,100
Wk 6 · Aug 25
Projected inflows
$24,180,600
13-week total
Projected outflows
$19,334,200
13-week total
Rolling 13-week forecast
Net positiveNet negative
| Week | Opening | AR inflow | Other in | AP outflow | Payroll | Net | Closing |
|---|---|---|---|---|---|---|---|
| Wk 1 · Jul 21 | $48,214,900 | $1,620,400 | $182,000 | −$742,300 | −$0 | +$1,060,100 | $49,275,000 |
| 13-week total | — | $21,486,200 | $2,694,400 | −$12,918,600 | −$6,415,600 | +$4,846,400 | $53,061,300 |
Forecast assumptions
Receipts are phased from the open AR ledger using the trailing 90-day collection curve. Top 20 customers are modelled individually; the tail is pooled at portfolio DSO.
Gross payroll plus employer taxes are posted to the settlement week. EMEA and US cycles are consolidated to USD at the booking-day rate.
EUR/USD and GBP/USD are frozen at the 2026-07-20 spot. Sensitivity to a ±5% move is reported on the scenarios screen.
Manual adjustments
- −$620,000
Delayed capex — plant B
Wk 4