Cash flow

13-week cash forecast

A forward look at your cash runway. Inflows are your real open repair orders, outstanding invoices and upcoming bookings; outflows are the recurring costs you enter below. This is an estimate to spot a tight week early, not your bank balance.

Cash runs short in 11 weeks

Short ~$8,744 the week of Nov 1
Short ~$14,719 the week of Nov 8
Short ~$20,694 the week of Nov 15
Short ~$26,744 the week of Nov 22
Short ~$39,294 the week of Nov 29

Explain the tightest week (AI)

Running balance, next 13 weeks

Tightest point: -$82,094 the week of Jan 10

Week	Projected in	Projected out	Net	Running balance
This week of Oct 19	$8,170 WIP $1,293.15 · A/R $3,516.89 · booked $3,360	$8,501 pay $5,200 · fixed $850 · parts $2,451	-$331	$15,669
Week 2 of Oct 26	$982 A/R $981.88	$12,845 pay $5,200 · fixed $850 · monthly $6,500 · parts $295	-$11,863	$3,806
Week 3 of Nov 1	$0 —	$12,550 pay $5,200 · fixed $850 · monthly $6,500	-$12,550	-$8,744
Week 4 of Nov 8	$107 A/R $107.30	$6,082 pay $5,200 · fixed $850 · parts $32	-$5,975	-$14,719
Week 5 of Nov 15	$107 A/R $107.30	$6,082 pay $5,200 · fixed $850 · parts $32	-$5,975	-$20,694
Week 6 of Nov 22	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$26,744
Week 7 of Nov 29	$0 —	$12,550 pay $5,200 · fixed $850 · monthly $6,500	-$12,550	-$39,294
Week 8 of Dec 6	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$45,344
Week 9 of Dec 13	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$51,394
Week 10 of Dec 20	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$57,444
Week 11 of Dec 27	$0 —	$12,550 pay $5,200 · fixed $850 · monthly $6,500	-$12,550	-$69,994
Week 12 of Jan 3	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$76,044
Week 13 of Jan 10	$0 —	$6,050 pay $5,200 · fixed $850	-$6,050	-$82,094

Starting balance $16,000 · inflows from 11 open repair order(s) and upcoming bookings. Numbers round to the dollar.

13-week cash forecast

Your assumptions