Brightline Home Services · FinanceCash forecast

13-Week Cash Flow

Cash in, cash out and the closing balance for the next thirteen weeks, with the two decisions it changes.
Cash today
$388K
Oct 31
Week 13
$532K
+$144K
Lowest week
$371K
week 2
Runway
> 12 mo
at current burn

Thirteen weeks of cash, receipts and payments, rebuilt every Monday from the bank feed and the open invoices. The low point is week 2, when the quarterly insurance premium lands.

01Closing cash by week

Opening cash plus receipts minus payments, week by week. Receipts assume invoices are paid at the historical average of 23 days; payroll, rent and insurance are on their real dates.

$388K$402K$431K$452K$471K$498K$532KW1W3W5W7W9W11W13

02Where the money goes

Payments over the thirteen weeks. Payroll is two thirds; the rest is parts, rent, insurance, marketing and loan service.

Payroll$1248KParts$412KRent + utilities$168KInsurance$94KMarketing$156KLoan$78K

Decision

Hold the two tech hires until week 6, when cash clears $430K two weeks in a row.