The spreadsheet that predicted our startup’s death was built in an afternoon and ignored for nine weeks. In 2026, when fundraising is built on efficiency and every investor asks about burn multiple, ignoring that file feels almost insane. But at the time, it was easier to call the model “too conservative” than to admit it was right.
Why We Created a Death-Prediction Spreadsheet in the First Place
Every founder updates a cash projection. Ours looked like every other optimistic hockey-stick chart. The problem wasn’t that we lacked a model; it was that our model assumed success. We decided to build a spreadsheet that asked a different question: if nothing changes, when do we die? No new strategic partnership, no surprise price increases, no “conversion will improve next quarter.” Just current cash, current burn, current revenue, and current growth efficiency.
The result was uncomfortable. It was also accurate.
The Formula That Showed Up in the Last Row
The first metric in the spreadsheet was the one every founder knows:
Naive Runway = Cash ÷ Net Burn
That gives you the date the bank account reaches zero. But it doesn’t tell you when the business stops being credible. For that, we used a second line:
Burn Multiple = Net Burn ÷ New Recurring Revenue
Net burn meant total cash spent minus total cash received from customers. New recurring revenue meant the monthly recurring revenue added from new customers and expansion in that same month. If the burn multiple was 2, we were spending $2 to create $1 of recurring revenue. That’s not automatically a crime in early-stage startups, but it has to trend toward 1 over time. Ours wasn’t.
Then came the number we should have lived by:
Effective Runway = Cash ÷ (Net Burn × Burn Multiple)
When we first calculated it, Cash was $1.2 million, Net Burn was $60,000 per month, and Burn Multiple was 3.2. The naive runway said 20 months. The effective runway said roughly 6 months. That second number felt like a typo, so we moved on. It wasn’t a typo.
The Two Ratios That Actually Predict a Startup’s Death
Burn multiple tells you how expensive growth is. A second ratio tells you whether that growth is durable:
Quick Ratio = (New MRR + Expansion MRR) ÷ (Churned MRR + Contraction MRR)
A quick ratio below 1.0 means your wins from new and existing customers aren’t enough to outrun the revenue you lose to downgrades and cancellations. Ours sat at 0.8 for three consecutive months. The spreadsheet flagged that too. When we looked at the flags together, the message was obvious: we were paying more and more to get less and less durable revenue.
That combination is the startup death prediction spreadsheet in its most honest form. In our model, the flag was simple:
- Danger when
Effective Runwayis less than 6 months - Critical when
Quick Ratiostays below 1.0 for two consecutive months
We hit both conditions in the same quarter. We still didn’t act.
Why We Ignored the Spreadsheet Until It Was Too Late
There are a thousand reasons not to trust a bad-news spreadsheet. We used most of them.
First, we assumed the input data was flawed. “The accounting export isn’t matching the bank statement,” we said. That was true, but the discrepancy was small. The trend was not.
Second, we anchored to the optimistic number. The naive runway said 20 months, so we mentally rounded up to “a year and a half to fix this.” The effective runway said six months, which would have meant changing the business model immediately. That was too painful to hold.
Third, we let a short-term revenue spike distract us. In Month 5, we signed an implementation-heavy deal that produced a large one-time payment. Cash went up, net burn looked better, and we stopped updating the spreadsheet. But that payment wasn’t recurring revenue. It didn’t improve the burn multiple. It was a sugar rush, not a cure.
By the time we updated the full model again, the effective runway was down to four months. We sold the company for near-zero rather than shutting down, but the spreadsheet had already predicted that outcome. It was off by only a few weeks.
How to Build Your Own Startup Death-Prediction Spreadsheet
If you want to avoid our mistake, build this before you need it. Use a separate column for each month and the formulas above. Here’s the minimum layout:
- Cash at the start of the month
- Gross burn, net burn, and new recurring revenue
- Churned and contraction MRR
- Naive runway, burn multiple, effective runway, and quick ratio
- A flag that appears when the thresholds we used are crossed
Update it on the same day every week. Not monthly. Not when you remember. The spreadsheet’s job is not to make you feel bad; it’s to make you pay attention to the shape of your company’s current operating state.
What We Should Have Done Differently
We should have treated the effective runway formula as a commitment device. Every month, we should have asked: “If nothing changes, how many months do we have before investors stop believing in our conversion curve?” That number should have been printed at the top of every board deck and every investor update.
We should have tied specific decisions to the flags. When effective runway dropped below 9 months, plan a serious cost reduction. When it dropped below 6 months, make the reduction immediately. When quick ratio was below 1.0 for two months, stop increasing gross burn entirely. These are simple tripwires. We didn’t set them.
In the end, the spreadsheet that predicted our startup’s death wasn’t the villain. It was a mirror. We ignored it because it showed us a company we didn’t want to admit we had built. If you build your own, don’t treat it as a fortune-teller. Treat it as a boundary line. You don’t have to believe the exact date in the cell, but you should respect the distance between where you are and where that formula says you’re heading.
