The one number every founder must know
Ask an experienced investor what they look at first in a young startup and many will answer with a question of their own: how many months of cash do you have left? Product, team and market all matter, but none of them survive the day the bank account hits zero. Runway is the clock every early-stage company runs against, and knowing it to the month changes how you hire, how you spend and, above all, when you start raising money.
This lesson is for first-time founders, co-founders who have just inherited “the finance stuff”, early employees who prepare the board pack, and anyone working towards a pre-seed or seed round. You do not need an accounting background or a financial model with forty tabs. A bank export, five columns in Excel and three formulas are enough to answer the question with confidence.
We follow Quillbrook, a fictional two-founder startup that sells booking software to physiotherapy clinics. You play Maya Ortiz, one of the co-founders. The company opened the year with $780,000 in the bank, revenue is growing every month, and the team wants to know whether it is time to talk to investors. All names and numbers are invented for teaching, and nothing here is financial or investment advice.
The core concepts: gross burn, net burn and runway
Three definitions carry the whole lesson. They are simple, but founders mix them up surprisingly often, and investors notice.
- Gross burn is the total cash going out in a month: salaries, rent, software, contractors, marketing and so on. It tells you what the company costs to run.
- Net burn is cash out minus cash in. It is the amount by which the bank balance actually falls in a month. When investors say “burn”, they almost always mean net burn.
- Runway is the cash in the bank divided by the monthly net burn. It is the number of months the company can keep going at its current pace before the money runs out.
Two details make the calculation honest. First, the cash balance carries forward: each month’s closing cash is the previous closing cash minus that month’s net burn. In Excel that is one formula, =E2-D3, copied down. Second, the burn you divide by should reflect the company you are running today. An average over the whole year mixes in months before your last hires and makes the runway look longer than it is. A common choice is the average of the last three months, which smooths out a one-off bill without hiding a recent change.
Why does the timing matter so much? Raising a round often takes several months from the first meeting to money in the bank, and many founders plan for around four to six months. If you start with only six months of runway, you negotiate under pressure. That is why a common rule of thumb is to start fundraising when runway drops below 12 months. The lab uses 12 as the threshold, but it sits in its own cell so you can change it to your own comfort level.
Worked example: Quillbrook’s first half-year
The lab gives you six months of cash in and cash out from Quillbrook’s bank account. You add the net burn in column D and the closing cash in column E. Here is the finished table:
| Month (A) | Cash in (B) | Cash out (C) | Net burn (D) | Closing cash (E) |
|---|---|---|---|---|
| Opening (1 Jan) | $780,000 | |||
| Jan 26 | $18,000 | $78,000 | $60,000 | $720,000 |
| Feb 26 | $21,500 | $81,000 | $59,500 | $660,500 |
| Mar 26 | $24,000 | $84,500 | $60,500 | $600,000 |
| Apr 26 | $27,800 | $86,000 | $58,200 | $541,800 |
| May 26 | $30,500 | $91,000 | $60,500 | $481,300 |
| Jun 26 | $34,200 | $95,500 | $61,300 | $420,000 |
The formulas are short. In D3 you write =C3-B3 and copy it down to D8, so burn is shown as a positive amount. In E3 you write =E2-D3 and copy it down; each row picks up the closing cash of the row above. Then three summary cells finish the job:
| Cell | Label | Formula | Result |
|---|---|---|---|
| B10 | Avg net burn (last 3 months) | =AVERAGE(D6:D8) | $60,000 |
| B11 | Runway (months) | =E8/B10 | 7.0 |
| B12 | Raise when runway below (months) | input | 12 |
| B13 | Status | =IF(B11<B12,"Start raising","On track") | Start raising |
The answer is uncomfortable but clear. Quillbrook has $420,000 left at the end of June and burns about $60,000 a month, so the runway is 7.0 months. That is well below the 12-month threshold, and the status cell says Start raising. With the same burn, the opening balance of $780,000 would have given 13 months, so the company crossed the line some time in the first quarter without anyone writing it down. That is exactly the situation a monthly runway sheet prevents.
Notice what the chart does not show: a crisis. Revenue nearly doubled in six months, from $18,000 to $34,200 a month. The problem is that cash out grew at almost the same pace, from $78,000 to $95,500. The net burn therefore barely moved. Growth that is paid for by equally growing costs does not extend the runway, and the second chart makes that visible at a glance.
Why you divide by net burn, not gross burn
The lab includes a common mistake on purpose: dividing the closing cash by the average cash out instead of the net burn. For Quillbrook the average cash out of the last three months is $90,833, so that formula gives about 4.6 months instead of 7.0. It is not a crazy number, it is just an answer to a different question: how long the cash would last if all revenue stopped tomorrow. Some founders track this “zero-revenue runway” as a stress test, which is sensible, but the runway you report to investors and your board is cash divided by net burn. Label both clearly if you show both.
Three levers that change the runway
Once you know the number, the next question is what you can do about it. The runway formula has only two inputs, cash and net burn, so every action falls into one of three groups:
- Raise more cash. A priced round, a convertible note or SAFE, a grant or a loan all increase the numerator. Each has a cost, whether dilution, interest or reporting, and each takes time to arrive.
- Grow cash in. More customers, higher prices, annual plans paid upfront or faster collection of unpaid invoices all reduce net burn. Annual prepayments are especially powerful early on, because a year of revenue arrives in one month.
- Cut cash out. Pausing a hire, renegotiating a contract or cancelling unused software reduces gross burn directly. Small savings add up: $5,000 a month less burn would stretch Quillbrook’s runway from 7.0 to about 7.6 months (
=420000/55000).
A useful exercise is to calculate what each lever is worth in months. If Quillbrook cut cash out by $10,000 a month, the net burn would fall to $50,000 and the runway would grow from 7.0 to 8.4 months (=420000/50000). Writing the options down in months makes the trade-offs easy to discuss with your co-founder.
How to build a runway sheet in Excel, step by step
- Export your bank transactions for the last six to twelve months (most business banks offer a CSV download). Create a summary with one row per month and two columns: total money in and total money out. A PivotTable is the quickest way: Insert → PivotTable, put the month in Rows and the amount in Values, and split inflows from outflows.
- Put the headers in row 1: Month, Cash in, Cash out, Net burn, Closing cash. In row 2, type “Opening” and the bank balance at the start of the first month in E2.
- In D3, type
=C3-B3and press Enter. Select D3 and double-click the fill handle to copy it down. - In E3, type
=E2-D3. Copy it down the same way. Check that the last closing cash equals the real bank balance at that date. If it does not, a transaction is missing. - In B10, type
=AVERAGE(D6:D8)for the last three months. When you add a new month, move the range down by one row, or use=AVERAGE(OFFSET(D3,COUNT(D3:D100)-3,0,3))so it always takes the last three filled rows. - In B11, type
=E8/B10. Format it with one decimal: Home → Number → Number, then Decrease Decimal. - In B12, type your threshold, for example 12. Keeping it in its own cell means you can change your assumption without editing any formula.
- In B13, type
=IF(B11<B12,"Start raising","On track"). Optionally add Home → Conditional Formatting → Highlight Cells Rules → Text that Contains → “Start raising” with a red fill. - Format the money columns as currency with Ctrl+Shift+$ and freeze the header row with View → Freeze Panes → Freeze Top Row. Update the sheet on the same day every month, ideally right after the month closes.
=E8/AVERAGE(D6:D8) and so on. A runway that falls by more than one month per month means the burn is growing, and it is often the earliest warning sign you will get.
Common mistakes and how to spot them
- Burn with the wrong sign.
=B3-C3gives a negative burn and a negative runway. If your runway is below zero while the bank account is not empty, flip the subtraction. - Dividing by gross burn. If the runway looks much shorter than you expect, check that B10 averages column D, not column C.
- Using a full-year average. If you hired two people in April, a twelve-month average hides their salaries for most of the year. Use a recent window and say which one you used.
- Counting money you do not have. Signed contracts, pending grants and promised investments are not cash until they arrive. Keep them in a separate “scenario” line, not in cash in.
- Forgetting one-off payments. Annual software licences, insurance, tax payments or a deposit for a new office can make one month look very different. Look at the list of transactions, not only the totals.
- A closing balance that drifts from the bank. If E8 does not match your real bank balance, the sheet is wrong, not the bank. Reconcile every month.
- Hard-coding the threshold in the formula.
=IF(B11<12,…)works today, but nobody will find the 12 later. Reference a cell like B12 instead.
Quick reference: functions and shortcuts used
The whole runway calculation uses only basic Excel. These are the pieces worth remembering.
| Function or shortcut | What it does | Example |
|---|---|---|
=C3-B3 | Net burn: cash out − cash in | $61,300 in June |
=E2-D3 | Carry the closing cash forward | $420,000 at end of June |
AVERAGE | Average of a range | =AVERAGE(D6:D8) = $60,000 |
IF | Shows one of two results based on a test | =IF(B11<B12,"Start raising","On track") |
OFFSET + COUNT | A range that always covers the last rows | Last three months automatically |
EOMONTH | Month-end a number of months later | =EOMONTH(DATE(2026,6,30),7) = 31 Jan 2027 |
| Ctrl+Shift+$ | Currency format | Money columns |
| Ctrl+D | Fill down | Copy a formula into a selection |
| Alt+= | AutoSum | Totals in one keystroke |
The EOMONTH row is a handy extra: with the runway in B11, =EOMONTH(DATE(2026,6,30),ROUNDDOWN(B11,0)) gives the month in which the cash would run out at the current burn. A date is often more motivating for a founding team than a number of months.
Real-world uses
- The monthly founder check-in. Many founding teams look at cash, burn and runway once a month. With this sheet it is a five-minute task instead of a long debate.
- Deciding on a hire. Before you add a $7,000-a-month salary, add it to cash out for the coming months and see how many months of runway it costs. That turns “can we afford it?” into a concrete trade-off.
- Planning the fundraise. Working backwards from the date the cash runs out, minus the months a round can take, tells you when the first investor meetings should happen.
- Board meetings and investor updates. Existing investors expect cash, burn and runway in every update. Showing the same three numbers in the same format builds trust.
- Scenario planning. Copy the sheet and change one assumption: a 20% cut in cash out, or revenue that stops growing. Comparing runways side by side is the start of a real financial plan.
What you will build in the rest of this course
This first lab is free. The other nineteen labs are part of the paid course ($9.90, one-time). They all use Quillbrook, so the numbers connect from runway to the investor update at the end.
A Simple 12-Month Forecast: Growth Rate, Costs and the Gap. You turn two assumptions, monthly MRR growth and a monthly cost increase, into a twelve-month forecast and a chart for the next board meeting.
Unit Economics: CAC, LTV and Payback for One Customer. You work out what one new clinic costs to win, what it is worth over its lifetime and how many months it takes to pay back.
Pricing Tiers: MRR per Plan, ARPA and an Annual Price. You check how much each of three plans brings in, what an average account pays and what the annual plans should cost.
Hiring Plan: What Four New People Really Cost Next Year. You plan four hires with different start months and calculate the real cost per month and for the year, the input your runway needs most.
Cap Table: Price per Share and Dilution After a Seed Round. For a $1.5M seed round at a $6M pre-money valuation, you calculate the share price, the new shares and what each founder owns afterwards.
Use of Funds: Turning the Raise into a Budget and a Chart. You split the raise into a use-of-funds plan for the pitch deck, check how long it lasts and chart it.
MRR Growth: Month-over-Month, CMGR and the Best Months. You analyse a year of monthly recurring revenue: the growth of each month, the compound monthly growth rate and the strongest months.
Cohort Retention Basics: Who Is Still a Customer After 3 Months?. You turn customer counts by sign-up month into a coloured retention table and check whether a new onboarding helped.
Budget vs Actual: The Monthly Check Before the Board Meeting. You compare a month’s spending with the budget, calculate the variances and flag every line more than 10% over.
Break-Even Customers: Are We Default Alive?. You calculate how many paying clinics Quillbrook needs to cover its costs and whether it gets there before the money runs out.
Investor Update Dashboard: KPIs, Changes, Chart and Highlights. You build the numbers block of a monthly investor update: KPI changes, runway, a highlighted decline and an MRR chart.
Summary
Net burn is cash out minus cash in, =C3-B3. Closing cash carries forward with =E2-D3. Runway is the cash in the bank divided by the average net burn of a recent period, here =E8/B10, and a simple IF turns it into a decision. For Quillbrook the answer is 7.0 months and “Start raising”, even though revenue nearly doubled, because costs grew just as fast.
Scroll up to the lab and build the sheet yourself with Maya’s numbers. It takes about fifteen minutes, every formula is checked as you type, and afterwards you can paste in your own bank totals and know your runway before your next investor asks.
Frequently asked questions
How do I calculate runway in Excel?
Divide the current cash balance by the average monthly net burn, for example =E8/AVERAGE(D6:D8). The result is the number of months the cash lasts at the current pace.
What is the difference between gross burn and net burn?
Gross burn is all the cash going out in a month. Net burn is cash out minus cash in, the amount by which the bank balance actually falls, and it is the figure normally used for runway.
How many months of runway should a startup have?
There is no fixed rule, but many founders aim for 18 to 24 months after a raise and start fundraising when runway drops below about 12 months, because a round can take several months to close.
Should I use the average burn of the whole year?
Usually not. A recent window such as the last three months reflects the team and costs you have today, while a full-year average can make the runway look longer than it is.
How do I show the month the cash runs out?
Use EOMONTH with the runway in months, for example =EOMONTH(DATE(2026,6,30),ROUNDDOWN(B11,0)). It returns the month-end that many whole months after the last closing balance.
Does revenue growth always extend the runway?
Only if revenue grows faster than costs. If cash out grows by the same amount as cash in, net burn stays flat and the runway keeps shrinking month by month.
Keep going: Excel for Startup Founders: Runway, Unit Economics, Cap Table & Investor Updates
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- A Simple 12-Month Forecast: Growth Rate, Costs and the Gap
- Unit Economics: CAC, LTV and Payback for One Customer
- Pricing Tiers: MRR per Plan, ARPA and an Annual Price
- Hiring Plan: What Four New People Really Cost Next Year
- Cap Table: Price per Share and Dilution After a Seed Round
- Use of Funds: Turning the Raise into a Budget and a Chart
- MRR Growth: Month-over-Month, CMGR and the Best Months
- Cohort Retention Basics: Who Is Still a Customer After 3 Months?
- Budget vs Actual: The Monthly Check Before the Board Meeting
- Break-Even Customers: Are We Default Alive?
- Investor Update Dashboard: KPIs, Changes, Chart and Highlights
- MRR Bridge: New, Expansion, Contraction, Churn and a Waterfall Chart
- From Bank Ledger to Budget Lines: SUMIFS by Category and Month
- Annual Prepaid Plans: Cash Collected, Revenue Recognised and Deferred Revenue
- Raising Prices: New MRR, Customers Kept and the Break-Even Loss
- Capital Efficiency: Burn Multiple and Magic Number by Quarter
- Lean, Base or Growth: A Scenario Switch for the 18-Month Cash Plan
- The Option Pool Shuffle: Series A Price per Share and Founder Dilution
- Final Project: Half-Year Board Pack Dashboard