Cash Runway Scenario Modeling: Why Your Single-Point Forecast Hides the Bridge Round You'll Need

Cash runway scenario modeling is the practice of projecting your startup's cash position under at least three independent forecasts — base, downside, and stress — instead of relying on a single linear extrapolation of current burn. The technique replaces "we have 14 months of runway" with "we have 14 months in the base case, 9 months if our top customer churns, and 5 months if our next round slips two quarters." It exists because single-point forecasts systematically hide the bridge round most venture-backed companies will end up raising.

Carta's Q2 2025 data shows that 16.6% of all cash raised by startups on its platform came through bridge rounds, up from 11.8% a year earlier. At Series A specifically, bridges accounted for 22.5% of cash raised. If you are running a venture-backed company in 2026, the base rate that your next financing event is a bridge — not a priced round — is roughly one in five. Your model should reflect that. Most do not.

Why Single-Point Cash Runway Forecasts Fail Founders

The default founder spreadsheet looks like this: take last month's ending cash, divide by last month's net burn, get a runway number, paste it into a board deck. It is mathematically correct and operationally useless. Three structural problems make it dangerous:

Burn is not stationary. Cloud bills, payroll true-ups, contractor renewals, and annual SaaS prepayments make any single month a poor predictor of the next twelve. A Q1 number that excludes the April payroll tax catch-up and the Q3 renewal cycle is structurally optimistic.
Revenue is not deterministic. A linear extrapolation assumes the pipeline converts at historical rates, that no logo churns, and that net dollar retention holds. None of those are guaranteed quarter to quarter.
Fundraising timing is not founder-controlled. Carta reported that companies raising a Series B in Q2 2024 waited a median 856 days after their Series A — nearly two and a half years. If your runway model assumes you can close a round in six months, you are not modeling the market you are operating in.

Paul Graham's 2015 essay "Default Alive or Default Dead?" framed this exact failure: founders cannot answer whether they live or die on current cash because they are not used to asking the question rigorously. He identified the "fatal pinch" as the moment a default-dead company hits roughly six months of runway with no path to growth and no time to fix it. A single-point forecast is the mechanism by which founders arrive at six months of runway thinking they had twelve.

Takeaway: Before you raise, before you cut, before you hire — replace any single runway number in your board materials with a three-scenario range. The single number lies.

The Data Behind Why Bridge Rounds Are the New Normal

The shift from priced rounds to bridges is not anecdotal. Carta's Q1 2024 report found that 42% of seed-stage investments and 43% of Series A activity on the platform were bridge rounds — the second-highest rate of the 2020s. By Q2 2025, bridge financing had stabilized as a structural feature of the market, not a downturn artifact.

The macro driver is the time-between-rounds expansion. CB Insights data suggests the median seed-to-Series-A gap stretched from roughly 18 months in 2019 to about 26 months by 2025. Median operating runway compressed from around 16 months in 2022 to roughly 12 months by 2025 as founders cut burn — operating margins on Carta improved from -138% in 2021 to -41% by end of 2024. The math doesn't reconcile: companies are operating with 12 months of runway in a market where the next priced round may take 24 months to close. The gap is filled by bridges.

The valuation tape from 2022-2023 explains why founders should plan for this:

Klarna raised $800 million in July 2022 at a $6.7 billion valuation — an 85% cut from its $45.6 billion June 2021 mark.
Stripe cut its internal valuation three times, landing near $63 billion in January 2023, down from $95 billion in 2021 (TechCrunch, PYMNTS).
Instacart moved its internal mark from $39 billion in early 2022 down through $24 billion, $15 billion, $13 billion, and finally $10 billion by late 2022 (Crunchbase).

These were not failing companies. They were three of the best-capitalized, best-managed private businesses of the decade, and each one accepted a multi-billion-dollar haircut because the alternative was running out of cash. If Stripe needs a scenario model, so do you.

Takeaway: Build your runway model assuming your next financing is a bridge at a flat or down valuation. If reality beats that assumption, you have optionality. If it doesn't, you have a plan.

How to Build a Three-Scenario Cash Runway Spreadsheet Model Step by Step

A practical scenario model has three forecasts driven by the same underlying assumption sheet. Build it in this order:

Stand up the assumption sheet. One tab, one column per driver: new bookings per month, gross margin, headcount by month, average loaded cost, software per seat, cloud cost per ARR dollar, churn rate, collections lag in days. Every other tab references this sheet. No hardcoded numbers in the P&L.
Build the base case from the last six months. Use the trailing six-month average for variable lines, the next-six-month plan for fixed lines (signed offers, lease changes, known renewals). The base case should reconcile to your current bank balance within 3%.
Build the downside case by stressing three variables. Reduce new bookings by 30%, increase churn by 50%, lengthen collections by 30 days. These are not worst-case numbers — they are the kind of misses that show up in any normal quarter when one rep underperforms and one customer drags payment.
Build the stress case as "default dead in six quarters." Zero new bookings for three months, then 50% of plan. Top customer churns in month four. No new round closes for 24 months. The output is your true minimum-survivable-cost structure.
Add a financing scenario layer. For each operating case, model: no raise, $2M bridge at flat valuation, full Series B 18 months out, full Series B 30 months out. You now have a 3x4 grid of cash positions.
Set tripwires. For each scenario, identify the month cash falls below 9 months of forward burn. That month minus six is your trigger date for action.

If you are building this in Excel, use named ranges for every driver, conditional formatting to highlight cells where cash goes negative, and a single dropdown to switch the visible scenario. A clean spreadsheet model fits on one tab plus the assumption sheet and a charts tab. If it sprawls past that, you are modeling too many things.

Takeaway: The model is not the deliverable. The deliverable is the tripwire dates that force board-level decisions before you have no decisions left to make.

The Five Tripwires Every Cash Runway Model Should Flag

A scenario model is only as useful as the alerts it generates. Hard-code these five tripwires into the spreadsheet so they fire automatically:

12-month forward runway in the base case. The standard "start raising" threshold. If you cross this without a term sheet in hand, you have already given investors leverage they will use.
9-month forward runway in the downside case. The "start cutting" threshold. Sequoia's May 16, 2022 "Adapting to Endure" memo told portfolio founders to "do the cut exercise" — model the reductions, get them ready to execute in 30 days, even if you don't pull the trigger. Treat this tripwire the same way.
6-month runway in the stress case. The "bridge or die" threshold. Below this, you are negotiating from weakness and any priced round is likely to be a down round.
Default-alive flip. The month your modeled gross profit covers operating costs at current growth. If this date moves out by more than one quarter between two consecutive board meetings, something structural broke.
Burn multiple above 2.0x. Net new ARR divided by net burn. Above 2x for two consecutive quarters and the next round is hard regardless of how much cash you have.

Takeaway: Wire these as red-cell conditional formatting in the spreadsheet and as standing slides in the board deck. If a tripwire fires, the next board meeting opens with that slide.

The Bridge Round Playbook When the Tripwire Fires

If your scenario model flags a likely bridge, work the playbook in this order before you talk to outside investors:

Run the cut exercise first. Identify 20% of operating expense you could cut in 30 days. Quantify the runway extension. This is the alternative to dilution and the leverage you bring into any bridge conversation.
Talk to inside investors first. Bridges led by existing investors price faster, signal less, and avoid the information leak of a broad outside process. Carta's Q2 2025 data shows insider-led bridges price meaningfully tighter than outsider-led extensions.
Default to SAFEs or convertible notes. Bridges are typically structured as convertibles with a discount and a cap, or as SAFEs that convert at the next priced round. This avoids fighting a down-round valuation today.
Size the bridge to reach a real milestone. A six-month bridge that lands you in the same fundraising market is a waste of dilution. Size to either (a) the next defensible ARR milestone or (b) cash-flow break-even, whichever is closer.
Get the term sheet before you announce. An announced bridge with no lead is a death spiral. Lock the lead investor, paper the round, then communicate to the team and the cap table.

Takeaway: A bridge is not a failure mode — it is a tool. The failure mode is needing one and not having modeled it.

The Practical Case for a Ready-Made Runway Template

Most founders build runway models from scratch in the same week they need them, which is the worst possible time. The model that catches the bridge round is the one that already exists when the tripwire fires — wired to your accounting export, with the three scenarios pre-built, with the conditional formatting and the assumption sheet already in place. CB Insights' analysis of 483 startup post-mortems found that 38% of failed VC-backed companies cited running out of cash as the primary cause. Most of those companies had spreadsheets. They did not have scenario models.

A ready-made cash runway scenario template — with the three cases, the financing layer, the tripwires, and the bridge-round playbook embedded — turns a two-week build into a one-hour customization. It is the difference between modeling your future and discovering it. If you do not have one in your finance folder right now, build it this quarter, before the next board meeting, before the next hire, and before the macro environment forces the question for you.