How to Forecast Cash Runway for a Startup

How to Forecast Cash Runway for a Startup: A Step-by-Step Guide

Cash runway is the number of months a startup can keep operating before it runs out of money, calculated as cash on hand divided by net monthly burn. To forecast runway accurately, you build a 24-month cash model that subtracts every committed expense from every realistic cash inflow, then stress-test it against three scenarios: base, downside, and "the round slips by six months." Get this wrong and you join the 2024 wave of startups that hit the fatal pinch with no time to fix it.

This guide walks through how to forecast cash runway for a startup with the same discipline used by Carta-backed founders and YC alumni — the exact spreadsheet model logic, the benchmarks investors expect in 2026, and the warning signs that mean you should start fundraising today, not next quarter. By the end, you will have a step-by-step process you can implement in an Excel template this afternoon.

What Cash Runway Actually Means (and Why Most Founders Get It Wrong)

The textbook formula is simple: Runway (months) = Cash Balance / Net Monthly Burn. The trap is that "net burn" is not what shows up on your bank statement. It is a forward-looking estimate that must reconcile three different views of cash.

Gross burn — total monthly cash outflows: payroll, software, rent, cloud bills, contractor invoices, taxes.
Net burn — gross burn minus cash inflows from customers (collected, not invoiced).
Adjusted burn — net burn with one-time items normalized out (annual insurance premiums spread monthly, deferred AWS credits added back).

Mercury's burn rate guide makes the operative distinction clear: a startup spending $150,000 a month with $50,000 in recurring revenue has a net burn of $100,000, not $150,000. Carta's data through 2024 showed that founders who report only gross burn consistently overestimate their runway by 20–40%, because they forget to subtract collected revenue or, worse, they count invoiced revenue that has not yet been paid.

Paul Graham's 2015 essay Default Alive or Default Dead? sharpened the question every founder should answer monthly: on your current trajectory, with no new funding, will you reach profitability before the cash runs out? If you cannot answer that in under 30 seconds, your runway forecast is not operational — it is decorative.

Takeaway: Before you build a single spreadsheet cell, define which burn number you are tracking and commit to that definition for every board update going forward.

The 24-Month Runway Model: Step by Step

A useful runway forecast covers 24 months, not 12. Twelve months hides the fundraising cliff; 24 months forces you to plan the round before you need it. Here is the column structure used in most operator-grade Excel templates.

Month — sequential columns from current month to month +24.
Starting cash — the prior month's ending balance.
Cash collections — actual cash from customers, not booked revenue. SaaS founders should split this into new ARR collections, expansion, and renewals.
Other inflows — tax refunds, grant disbursements, debt drawdowns, interest on T-bills.
Payroll & contractors — gross wages plus employer taxes (multiply US salaries by roughly 1.10–1.15 to capture payroll tax, benefits, 401(k) match).
Software & infrastructure — every SaaS subscription, AWS/GCP/Azure spend, and observability tools.
Marketing & sales — paid acquisition, events, agency fees, sales tools.
Rent, insurance, legal, accounting — fixed overhead.
One-time items — annual insurance renewals, security audits, hardware purchases.
Net burn — sum of outflows minus inflows.
Ending cash — starting cash minus net burn.
Months of runway remaining — ending cash divided by trailing-three-month average net burn.

The "trailing-three-month average" in row 12 is critical. A single anomalous month — a big customer prepayment in March, an AWS reserved-instance true-up in June — will distort a point-in-time runway calculation by months. Three-month smoothing gives you the trend, not the noise.

Takeaway: If your model does not have a row for "months of runway remaining" computed automatically every month, you do not have a forecast. You have a budget.

Three Scenarios Every Forecast Must Include

A single-line runway forecast is worse than useless because it gives you false precision. Every board-ready model should run three scenarios in parallel columns or tabs.

Scenario 1: Base Case

Your honest best estimate. Revenue grows at the rate you have actually shipped over the last six months, not the rate you promised at the last board meeting. Expenses grow with the hiring plan you have committed to. This is the scenario you bet your company on.

Scenario 2: Downside Case

Revenue grows at 50% of plan. Churn ticks up 200 basis points. One enterprise deal in the pipeline slips a quarter. This is not pessimism — it is the version of reality that the 2024 fundraising market actually delivered to most Series A and B companies. Crunchbase News tracked over 150,000 tech layoffs in 2024 alone, and the majority were at companies whose base-case model never modeled the downside.

Scenario 3: Fundraising Slip

Most founders model the round closing on schedule. Model it slipping six months. JPMorgan's startup runway guidance recommends initiating a fundraise with 12–18 months of runway remaining precisely because Series A and B rounds in 2024–2025 averaged 6–9 months from first pitch to wire — and that is when things go well. If your downside-case runway dips below six months before the round closes, you are not raising from a position of strength.

Takeaway: If all three scenarios end with positive cash at month 18, you have a credible plan. If only the base case does, you have a wish.

The 2026 Benchmarks You Should Be Measuring Against

Forecasting runway in isolation tells you when you die. Benchmarking tells you whether you are healthier or sicker than your peer set — which directly affects your ability to raise the next round.

Burn Multiple — popularized by David Sacks, calculated as Net Burn ÷ Net New ARR. CFO Advisors' 2025 benchmarks place the median Series A SaaS burn multiple at 1.6×, with top quartile under 1.5×. AI-native startups are running 0.8×–1.2×, which is shifting investor expectations even for non-AI companies.
Runway at fundraise — investors increasingly expect founders to start raising with 12–18 months left. Coming in below 9 months signals desperation and depresses valuation.
Net dollar retention (SaaS) — Benchmarkit's 2025 SaaS report pegs healthy NDR at 110%+. Below 100% means churn is eating your forecast before you fundraise.
Default Alive status — Paul Graham's binary test. Plot your current growth rate against current burn; if the lines cross before cash hits zero, you are default alive and can raise from strength.

The market re-anchoring in 2025 was decisive. Boards now hold two scorecards simultaneously: growth and capital efficiency. Showing up with a runway forecast that ignores burn multiple is showing up with last cycle's pitch deck.

Takeaway: Add a "benchmarks" row to your runway model that calculates burn multiple, NDR, and gross margin monthly. Investors will ask for these in the first 15 minutes of any 2026 pitch.

Five Common Forecasting Mistakes That Kill Runway

After reviewing hundreds of founder-built spreadsheet models, these are the five errors that recur most often. Each one can compress your real runway by 3–6 months relative to what your model says.

Confusing booked revenue with cash collected. A $120,000 annual contract signed in January is $120,000 of cash if billed upfront — or $10,000 per month if billed monthly. Model the cash, not the GAAP recognition.
Forgetting payroll loading. A $150,000 base salary costs roughly $172,500 once you layer in payroll taxes, benefits, and 401(k) match. Multiply US headcount expense by 1.15 unless you have precise data.
Ignoring annual renewals. D&O insurance, SOC 2 audits, legal retainers, hardware refreshes — these arrive as one $25,000–$75,000 shock per year. Spread them monthly in your model so they do not disappear.
Modeling the hiring plan you announced, not the one you will execute. Carta's H2 2024 compensation data showed startup hiring fell 53% year-over-year in December 2024. If your model assumes 12 hires in six months, run a parallel scenario with three.
Counting unsigned pipeline as revenue. Pipeline-weighted forecasts belong in your sales meeting, not your runway forecast. Only contracted, signed revenue counts.

Takeaway: Every quarter, do a forecast-to-actual variance review. If your model was off by more than 10% on cash position, find the broken assumption before you re-run the forecast.

From Forecast to Action: The Operating Cadence

A runway forecast that gets updated quarterly is a runway forecast that has already failed. The companies that survived the 2023 SVB collapse — and the prolonged 2024 fundraising drought — were the ones running this cadence:

Weekly: Update cash collections and cash position. Track variance to model.
Monthly: Refresh the full 24-month forecast with actuals from the closed month. Recompute trailing-three-month burn and remaining runway. Send a one-page snapshot to the board.
Quarterly: Re-run all three scenarios. Refresh assumptions on growth rate, churn, and hiring plan. Decide whether to start the next round.
Trigger event: Any time runway in the downside scenario drops below 12 months, escalate to a board discussion within two weeks.

The discipline is not the spreadsheet. The discipline is the cadence. A perfectly modeled forecast that nobody reads is identical to no forecast at all.

The Practical Path Forward

Forecasting cash runway for a startup is not a one-time exercise — it is the operating system of a capital-constrained business. The mechanics are straightforward: a 24-month model, three scenarios, monthly refresh, weekly cash tracking. The hard part is doing it consistently when you are also building product, closing customers, and running the company.

This is exactly the gap a ready-made Excel template closes. Instead of spending a weekend building the model from scratch — and getting the trailing-burn calculation, scenario toggle, and benchmark formulas wrong on the first three tries — you start with a board-ready spreadsheet that already encodes the right structure. Update your numbers, hit refresh, and you have a forecast you can defend to your board, your investors, and yourself.

If you are five hours into building your own runway model and still fighting circular references in your scenarios, the template will save you that weekend — and more importantly, it will save you from the variant of "default dead" you discover too late because the math was off by one row.

How to Forecast Cash Runway for a Startup