Come, Look at This Gap: The Week Your Cash Runs Out (Before It Happens)
Profit is a theory; cash is a fact. We build a simple weekly runway sheet to spot the 'Red Week' where liquidity vanishes, long before the panic starts.
The Invisible Cliff
Come, open your banking app. Look at the balance. $45,000.
It feels safe, does it not? It is a solid, positive number. It tells you that you can pay the rent next week. It tells you that you can buy that new software license.
But this number is a lie. It is a snapshot of the past, not a map of the future. It does not know about the payroll run hitting on the 14th. It does not know that your biggest client is going to delay their payment by 15 days because their CFO is on vacation.
The Lie: We treat our current bank balance as a cushion. We assume that because we have money now, we will have money then. We rely on “Average Burn Rate,” assuming we spend money evenly.
The Truth: Cash flow is lumpy. It is jagged. It has spikes of intake and violent drops of outflow. If we average it, we smooth over the hole that will swallow us.
Finding the Red Week
We are going to build a tool that removes the blindfold. We call it the Weekly Runway.
Open a fresh sheet.
- Row 1: Dates (Week Ending 01, Week Ending 08, etc.)
- Row 2: Starting Cash (Link this to the previous week’s ending cash).
- Row 3: Confirmed Inflows (Only checks we know are clearing).
- Row 4: Committed Outflows (Rent, Payroll, Fixed Costs).
- Row 5: Ending Cash.
Now, drag this formula out for 13 weeks.
[TO EDITOR: Create a visual of a spreadsheet grid. The ‘Ending Cash’ row is green for the first 6 weeks. In Week 7, the number turns bright red and shows -$2,500. Then it returns to green in Week 8. Caption: “The Death Zone is Temporary, but Fatal.”]
staring at the Void
Do you see Week 7? That is the gap. That is the week where the line crosses zero.
In a monthly forecast, Week 7 is invisible because the big client payment in Week 8 covers it up. The monthly average says you are safe. The weekly reality says you are dead.
By visualizing this gap now—six weeks in advance—we have power. We can call the client. We can delay a vendor payment. We can bridge the gap.
Cash does not disappear; it just walks off the page when we stop looking. Project the line. Find the gap. Build the bridge before you reach the cliff.
FAQs
Why weekly? Isn't monthly enough?
No. Payroll happens on a Tuesday. Rent clears on a Friday. A monthly view hides the day you bounce a check.
My P&L says I'm profitable. Why worry?
Because you cannot pay staff with 'Net Income.' You pay them with cash. If clients pay late, profit means nothing.
What is the 'Red Week'?
It is the specific week in the future where your balance dips below zero. Once you see it, you can fix it.