Excel runway guide
How Do I Calculate Runway in Excel?
Excel can produce a useful runway estimate when the cash scope, burn definition, dates, and assumptions are explicit. Begin with the simple formula for orientation, then build a month-by-month schedule when receipts and obligations are uneven.
Two levels of calculation
Use the simple formula for a snapshot, then build the cash schedule
The shortcut gives one headline. The schedule preserves timing, which is what makes the model useful for operating decisions.
Start with a clearly defined snapshot
Put available cash in one labeled cell and monthly net burn in another. If net burn is positive and reasonably stable, divide cash by net burn to estimate months of runway. Document which accounts are included, the as-of date, and how realized inflows and outflows form the burn figure.
Do not force the formula when the business is cash-flow positive, burn changes materially, or a large dated movement dominates the result. Those cases need a schedule rather than a flat divisor.
Build one column for each month
Create rows for opening cash, expected cash collections, payroll, contractors, tools, rent, tax, debt, other commitments, one-time items, total cash out, and ending cash. Carry each month's ending cash into the next month's opening balance.
Keep expected receipts distinguishable from cash already collected. A separate status or assumption column can show which inputs are realized, committed, planned, or hypothetical.
Let dates change the result
A one-time purchase should appear in the month it is expected to be paid. A new employee should begin on the planned start date with the supported fully loaded cost. A late customer receipt should move to the period in which the cash is now expected.
This creates a non-linear cash path. The first month in which the modeled balance reaches the chosen floor provides the runway or cash-out context under those assumptions.
Add controls as the workbook grows
Excel remains useful, but a larger model needs disciplined ownership. Protect formula cells, label units and dates, use consistent signs, record assumption changes, test for broken references, and make one person accountable for the current version. The tradeoff is maintenance and governance, not a defect in the tool.
Decision variables
What changes the spreadsheet result
A model becomes trustworthy when another person can understand the inputs, formulas, timing, and ownership.
Cash scope
State which balances are available for operating use and the measurement date.
Burn definition
Use consistent realized inflows and outflows for the headline estimate.
Expected collections
Place conditional receipts on dated lines without treating them as cash already held.
Changing costs
Use start dates for hiring, renewals, commitments, and one-time purchases.
Model controls
Protect formulas, version assumptions, and assign review ownership.
Worked hypothetical
Worked hypothetical: build the first three months
A business starts with $180,000. It expects $40,000 of collections and $70,000 of cash outflow each month. A $30,000 one-time payment is due in month two.
- Month one ending cash
- $150,000$180,000 + $40,000 − $70,000.
- Month two ending cash
- $90,000$150,000 + $40,000 − $70,000 − $30,000.
- Month three ending cash
- $60,000$90,000 + $40,000 − $70,000.
The figures are hypothetical. The schedule exposes the one-time drop that a simple average can hide and gives the reviewer a formula trail to inspect.
Decision framework
Build an Excel model another person can review
- 01
Label available cash, net burn, units, dates, and the as-of period.
- 02
Carry opening and ending cash through each month with formulas.
- 03
Separate realized, expected, planned, and hypothetical values.
- 04
Place one-time items and cost changes on their actual expected dates.
- 05
Protect formulas, record assumption changes, and assign an owner.
Applying the decision in RunwayCal
Keep the same planning logic when the model becomes connected
RunwayCal uses the same core discipline: a supported starting position, dated cash movement, visible assumptions, and a period-by-period result. Planner and Runway Overview keep the model connected to the wider financial workflow.
Excel can remain useful for exploration and bespoke analysis. The choice depends on the model's complexity, collaboration needs, and the cost of maintaining definitions across versions.
Related questions
Questions that usually follow
What Excel formula calculates runway?
For a stable-burn snapshot, divide available cash by monthly net burn. Use a monthly cash schedule when burn or timing changes.
What if net burn is zero or negative?
The division does not provide a meaningful countdown. Review the time-phased cash path and the conditions behind the result instead.
Should expected revenue be included?
It can be included as a clearly labeled assumption on its expected collection date, but it should not be presented as realized cash.
Related resources
Continue with the underlying concepts
Move from a spreadsheet snapshot to a connected cash path.
Keep the formulas, timing, assumptions, and resulting runway visible together.
Explore Planner