A weekly cash decision worksheet

Synthetic educational example — not client data or performance. All prices, quantities and collateral figures are hypothetical. This is not an investment recommendation, company forecast, real exchange specification or proposed remedy.

business cash shortfall and debt pressure. The existing public turnaround page calls for a 13-week forecast while its linked runway engine has thirteen monthly periods. A weekly worksheet therefore fills a specific gap without replacing that calculator.

Method and assumptions

closing cash = opening cash + receipts + financing − operating outflows − debt service. Next week's opening equals prior week's closing. No automatic financing plug. Flag shortfalls; do not hide negative cash. Clearly label weeks as calendar intervals chosen by the user.

opening 100; receipts 80; operating outflows 105; debt service 10; financing 0; closing 65. With an illustrative minimum cash floor of 75, the gap is 10. A delayed receipt of 20 moves closing cash to 45 and the gap to 30. These are arithmetic assumptions, not a company forecast or a remedy recommendation.

Values below are USD thousands. W01–W13 are labels for calendar intervals chosen by the user. Financing remains an explicit input; there is no automatic financing plug. Blank worksheet cells mean unknown, not zero. Operating outflows are aggregated in the supplied example; payroll, suppliers, tax payments and other obligations must be distinguished when preparing an actual forecast.

Download the worked 13-week CSV · Download a blank worksheet · Original supplied data

Base case — USD thousands
Input / output	W01	W02	W03	W04	W05	W06	W07	W08	W09	W10	W11	W12	W13
opening cash	100	65	50	55	40	40	30	35	15	10	10	15	35
cash receipts	80	90	110	100	105	95	120	85	100	115	110	125	105
financing	0	0	0	0	0	0	0	0	0	0	0	0	0
operating outflows	105	105	105	105	105	105	105	105	105	105	105	105	105
debt service	10	0	0	10	0	0	10	0	0	10	0	0	10
closing cash	65	50	55	40	40	30	35	15	10	10	15	35	25
assumed minimum cash floor	75	75	75	75	75	75	75	75	75	75	75	75	75
floor shortfall	10	25	20	35	35	45	40	60	65	65	60	40	50

Receipt of 20 delayed from W01 to W03 — USD thousands
Input / output	W01	W02	W03	W04	W05	W06	W07	W08	W09	W10	W11	W12	W13
opening cash	100	45	30	55	40	40	30	35	15	10	10	15	35
cash receipts	60	90	130	100	105	95	120	85	100	115	110	125	105
financing	0	0	0	0	0	0	0	0	0	0	0	0	0
operating outflows	105	105	105	105	105	105	105	105	105	105	105	105	105
debt service	10	0	0	10	0	0	10	0	0	10	0	0	10
closing cash	45	30	55	40	40	30	35	15	10	10	15	35	25
assumed minimum cash floor	75	75	75	75	75	75	75	75	75	75	75	75	75
floor shortfall	30	45	20	35	35	45	40	60	65	65	60	40	50

Turnaround service page · Existing monthly runway calculator