Skip to content
SimulateFin

Churn crisis: SaaS ROI & cash runway model

Acquisition is working, retention is not. Watch the runway collapse. This scenario starts at $95K MRR with 14 engineers and 8.5% monthly churn — cash turns negative in month 13. Every control below is live; changing one re-runs the full five-year projection.

Runs out of cash

Cash turns negative in month 13.

Year-5 ARR
$460.3K

From $1.1M today — 0.4x over 5 years.

5-year net profit
-$10.6M

On $3.7M of cumulative revenue.

Break-even
Never

Costs exceed gross profit for all 60 months.

Cash runway
1y

Balance hits zero in month 13.

LTV : CAC
1.0x

LTV $3.3K against $3.2K acquisition cost.

CAC payback
11 mo

Net revenue retention 98.5% per month.

5-year projection · Realistic case

60 monthly periods, compounded. Hover for exact figures.

  • Cash balance
  • Cumulative net profit

Reference

Definitions for every metric on this page — LTV, CAC payback, churn, runway, burn multiple — are in the glossary, and the FAQ on the full simulator explains how each is computed.

Metric glossary →Metric FAQ →In-depth guides →

Start from a profile

Software strategy

Licence part of the surface area, build the rest. Carries a share of both costs.

USD
$0$500K
%
0%25%
%
0%15%
USD
$10$5K
USD
$0$25K
%
20%95%
0120
USD
$40K$400K
h
0 h800 h
USD
$20$400
USD
$0$2K
USD
$0$5M
mo
1 mo36 mo
FTE
0 FTE20 FTE

What these numbers mean

A plain-language reading of the projection above. Every figure updates as you move the controls. Current verdict: Runs out of cash.

Where the revenue goes

Starting from $95K in monthly recurring revenue, 8.5% monthly churn exceeds 7.0% organic growth, so the base contracts by 1.5% a month before any paid acquisition. Re-investing 55% of operating profit at a $3.2K acquisition cost adds a compounding second engine on top. After 60 months the model lands at $460.3K of annual recurring revenue — 0.4x today's $1.1M.

What the cost base is made of

In month one the business spends $205.4K. Engineering payroll is $169.8K of that — 83% of every operating dollar — across 14 engineers at $145K fully loaded, plus $3.8K of contract engineering at $95 an hour. Infrastructure starts at $14.2K and reaches $12.7K by month 60, because $55 of cloud spend rides on every $1K of MRR. With salary inflation at 4.5% and price inflation at 3.4%, the total monthly cost base ends the period at $241.1K.

Break-even and runway

Operating profit never turns positive inside 60 months: gross profit of $26.9K at the end of the period is still short of a $241.1K cost base. Peak monthly burn reaches $214.2K, and the opening $1.8M runs dry in month 13.

Unit economics

At $400 ARPA and 70% gross margin, each account contributes $280 of gross profit a month. Against 8.5% monthly revenue churn that implies a lifetime value of $3.3K, and an LTV:CAC ratio of 1.0x, which sits below the conventional 3:1 bar — the business earns back acquisition cost, but slowly enough that growth has to be financed. Acquisition cost is repaid after 11 mo of gross profit.

Build, buy, or both

On the hybrid path, the software itself costs $755.9K over five years — $106.7K in licences and $649.2K in build and maintenance. Holding every other assumption constant, "Buy SaaS" would end the period $518.8K better off, largely because the maintenance FTE on an internal system is a permanent cost that never amortises away.

Conservative, realistic, aggressive

The same inputs run three ways. The spread between the outer columns is the honest output of any five-year model — treat the middle column as a midpoint, not a forecast.

Five-year outcomes under conservative, realistic and aggressive assumptions
MetricConservativeGrowth misses plan, churn runs hot, costs drift up.RealisticYour inputs, taken at face value.AggressiveAcquisition compounds, retention improves, costs hold flat.
Year-5 ARRRecurring revenue exiting month 60.$12.3K$460.3K$12.2M
5-year net profitCumulative profit after re-investment.-$13.8M-$10.6M-$871K
Ending cashBalance at month 60.-$12M-$8.8M$929K
Break-evenFirst month operating profit is positive.NeverNeverMonth 36
Cash runwayMonths before the cash balance reaches zero.9 mo1y1y 5mo
Lowest cash balanceDeepest point of the cash trough.-$12M-$8.8M-$832.8K
LTV : CACLifetime value against acquisition cost.0.8x1.0x1.4x

Build vs. buy, head to head

Identical assumptions, three software paths. Select one to load it into the simulator.

How a company that looks fine dies

Everything on the acquisition side of this business works. Seven percent monthly growth is genuinely strong, the sales motion is clearly functioning, and a board deck built on new-logo counts would read well for several quarters in a row. The company still fails, and it fails in a specific and instructive way: at eight and a half percent monthly revenue churn against seven percent growth, the installed base shrinks every single month. Revenue is lower in year two than in year one, lower again in year three, and lower every year after that. The company ends the five years materially smaller than it started, having sold hard the entire time.

The unit economics explain it in one line. The average account here lasts a shade under twelve months, and it takes very nearly that long for the account to repay its own acquisition cost out of gross profit. The typical customer pays back what they cost to win in roughly the month they cancel. The LTV:CAC ratio lands a hair above one — technically not inverted, practically indistinguishable from it. There is no margin for a bad cohort, a pricing mistake or a competitor discount, because there is no margin at all. Every customer is a break-even trade, and the business is running that trade at volume.

This next part is the most useful thing on the page and it takes ten seconds to check. The re-investment rate is set at fifty-five percent, and it does absolutely nothing. Across all sixty months the model spends nothing on paid acquisition, because it only re-invests positive operating profit and this profile never has any — not once, in five years. Move the control from zero to ninety and every output is identical to the last decimal. The same applies to CAC: lowering it improves the printed ratio and changes neither the runway nor the ending cash, for exactly the same reason. Any growth plan that funds itself from operating profit is not a plan here. It is a description of a company that does not exist.

Retention is the right lever, and on this balance sheet it is not sufficient on its own. Take churn from eight and a half to three percent and the business becomes fundamentally sound — it breaks even inside the third year and finishes the fifth with real cash. It still runs through zero on the way there, because the fix takes time to compound and the cost base does not pause while it does. Retention alone would need to get all the way down near one and a half percent to keep the cash balance positive throughout, which is not a realistic ask of a company currently at eight and a half. What the model is saying is that this needs two moves, not one, and most teams in this position spend a year looking for the single one.

The second move is the cost base, and the combination is what works. Hold churn at three percent and take the team from fourteen engineers to ten, and the company stays solvent the whole way through and breaks even in the second year. Cutting headcount by itself is not a fix — halving the team roughly doubles the runway and the model still never reaches a single profitable month across sixty of them — but it buys the quarters that the retention work needs in order to land. Cuts alone extend the failure. Retention alone arrives too late. Together they are a company.

Outrunning the problem with acquisition is the option most teams reach for, and the model prices it honestly: organic growth would have to roughly double, to something over fourteen percent a month sustained for five years, before growth alone keeps this business solvent. That is not a plan, it is a hope with a spreadsheet attached. And there is a final indignity worth noticing on this profile. The strategy is set to Hybrid, which means it carries both a licence bill and an internal platform to maintain — and across five years that software decision costs roughly a fifth of every dollar the business collects. On a healthy company that is a line item. On this one it is a meaningful share of the total, because the denominator has been shrinking the whole time. When retention goes, everything else stops being a rounding error.

What to move, and what happens when you do

Monthly revenue churn
The only input that changes the outcome. At three percent the business becomes viable but still passes through zero; it would need to reach roughly one and a half percent to stay cash-positive on retention alone.
Engineering headcount
Buys time and nothing else. Halving the team roughly doubles the runway and the model still never records a profitable month. Paired with churn at three percent, though, it is the difference between solvent and not.
Re-investment rate
Completely inert here. There is never a month of positive operating profit to re-invest, so every value from zero to ninety produces identical results. Check it yourself — it is the fastest way to see how deep the problem goes.
CAC
Same story. Lowering it improves the LTV:CAC reading on the tiles above and moves neither the runway nor the ending cash, because no acquisition spend ever happens on this profile.
Organic MRR growth
Would need to roughly double and stay there for five years for growth alone to save this. Worth setting once, to price what "we will grow through it" is actually asking for.

Churn crisis: five years at the default inputs

Year-by-year projection for the Churn crisis scenario at its default inputs
YearEnding ARRRevenueOperating costNet profitEnding cash
Year 1$950,910$1,034,740$2,483,851-$1,759,532$40,468
Year 2$793,185$863,110$2,515,056-$1,910,879-$1,870,411
Year 3$661,621$719,947$2,616,746-$2,112,782-$3,983,194
Year 4$551,879$600,531$2,724,622-$2,304,250-$6,287,444
Year 5$460,340$500,922$2,838,685-$2,488,039-$8,775,483
Five years of a company that never has a profitable month: revenue falls in every one of them while the cost base carries on.