Marrow Lane Picture Framing (fictional) Fictional sample. The business and every amount are made up. 2 Nov – 30 Jan

Yes: you stay above your $5,000 floor for all 90 days, and the tightest day is Fri 15 Jan, with $6,480.

If your biggest payment, Tidewater Hotel invoice ($9,800), comes two weeks late, you drop below the floor on Mon 30 Nov: the tightest day becomes Tue 1 Dec, with $660.

2 Nov16 Nov30 Nov14 Dec28 Dec11 Jan25 Jan$0$5,000$10,000$15,000$20,000$25,000Floor $5,000Tightest $6,480 · 15 JanIf late $660 · 1 Dec2 Nov30 Nov28 Dec25 Jan$0$10,000$20,000$30,000Floor $5,000Tightest $6,480 · 15 JanIf late $660 · 1 Dec
Balance on day one$11,400
Your floor$5,000
Tightest day15 Jan
Balance that day$6,480
Above floor that day$1,480
Balance on day 90$12,480

Assumed, and still missing

Open the workbook: cash-runway.xlsx