A burn rate and runway spreadsheet gives founders, operators, and small business owners a simple way to see how long cash is likely to last under current conditions. The real value is not just the first calculation. It is the habit of revisiting the model whenever payroll changes, revenue slips, a supplier raises prices, or a funding plan shifts. In this guide, you will learn how to build a practical burn rate spreadsheet in Excel or Google Sheets, which inputs matter most, how to avoid common mistakes, and how to use the model for day-to-day decisions instead of treating it as a one-time finance exercise.
Overview
A burn rate spreadsheet tracks how much cash your business uses over time and turns that into an estimated runway, usually measured in months. For startups, this is often the clearest early-warning metric in the business. For small businesses, it is just as useful when cash inflows are uneven, margins are tight, or expansion plans require careful timing.
At its simplest, the model answers two questions:
- How much cash are we losing or consuming each month?
- Given our current cash balance, how many months do we have before cash runs out?
A basic formula looks like this:
Burn rate = cash outflows - cash inflows
Runway = current cash balance / monthly net burn
If monthly burn is positive, you are using cash. If it is zero or negative because the business is cash-flow positive, the runway question changes. In that case, the spreadsheet is still useful for stress testing slower sales, delayed customer payments, new hires, or seasonal dips.
This is why a burn rate spreadsheet is more than a static finance template. It becomes an operating tool. When paired with a monthly expense tracker and a simple revenue forecast, it can support hiring decisions, budget cuts, pricing reviews, and fundraising timing.
For spreadsheet users, the good news is that this model does not need advanced finance software. A clean workbook in Excel or a monthly burn tracker Google Sheets file can handle most small business and startup use cases. The key is to separate raw inputs from formulas, define assumptions clearly, and update it on a regular schedule.
How to estimate
You can build a useful runway calculator Excel model with four blocks: opening cash, monthly inflows, monthly outflows, and ending cash. From there, calculate net burn and runway.
Step 1: Start with opening cash
Use the actual cash available to operate the business, not a rough guess. Depending on your setup, you may want to include only unrestricted cash and exclude deposits, reserves, or funds earmarked for taxes.
Step 2: List monthly cash inflows
Examples include:
- Customer collections
- Subscription revenue received
- Consulting or project payments
- Loan proceeds, if applicable
- Owner contributions or outside funding
Cash inflows should reflect timing, not just booked revenue. If a sale is invoiced in January but paid in March, cash enters in March.
Step 3: List monthly cash outflows
Common outflows include:
- Payroll and contractor payments
- Rent and utilities
- Software subscriptions
- Marketing spend
- Inventory purchases
- Insurance
- Debt payments
- Taxes
- Equipment or one-time purchases
This is where many models become too optimistic. If a cost is real and recurring, include it. If a one-time cost is likely in the planning period, include it in the specific month when you expect to pay it.
Step 4: Calculate net cash flow
For each month:
Net cash flow = total inflows - total outflows
If net cash flow is negative, the absolute value is your monthly burn for that period.
Step 5: Project ending cash
Ending cash = opening cash + net cash flow
The next month’s opening cash should equal the prior month’s ending cash.
Step 6: Estimate runway
There are two common approaches:
- Simple runway: current cash divided by the latest monthly net burn
- Projected runway: month-by-month forecast until ending cash reaches zero
The simple version is fast and useful for a dashboard. The projected version is better because it can reflect seasonality, planned hiring, funding assumptions, and step changes in expense.
Suggested spreadsheet layout
In either Excel or Google Sheets, use tabs like these:
- Assumptions: growth rates, hiring dates, payment timing, scenario toggles
- Monthly forecast: inflows, outflows, net cash flow, ending cash
- Dashboard: current cash, burn rate, runway, chart of cash balance over time
A very practical layout uses months across columns and line items down rows. That makes it easy to copy formulas horizontally and update assumptions in one place.
Helpful formulas
- SUM for category totals
- IF for conditional hiring or one-time costs
- MIN and MAX for guardrails
- FORECAST or trend methods for simple revenue assumptions
- Data validation for scenario selection
If you want to go further, link your burn model to a Monthly Expense Tracker Spreadsheet for Small Business Category Control so actual costs feed your assumptions more accurately. For revenue-side forecasting, a companion model like Sales Forecast Spreadsheet Methods: Run Rate, Weighted Pipeline, and Seasonality can make the inflow side more realistic.
Inputs and assumptions
The quality of a startup cash runway template depends less on formula complexity and more on the discipline of its inputs. A plain model with sensible assumptions is usually more useful than a polished workbook built on weak estimates.
1. Cash balance
Use a number you can verify. If cash is split across accounts, decide whether all of it is available for operations. A common mistake is counting cash that is reserved for taxes, customer refunds, or debt covenants.
2. Revenue versus cash collections
Runway is a cash question. If customers pay late, your spreadsheet should show that delay. For subscription businesses, this may be straightforward. For service businesses or wholesale operations, it may not be.
3. Fixed versus variable expenses
Separate costs into categories:
- Fixed: rent, most salaries, insurance, software base fees
- Variable: ad spend, commissions, shipping, payment processing, materials
- Step-change: planned hires, office move, annual renewals, equipment purchases
This separation helps you see which costs can change quickly if runway becomes tight.
4. Timing assumptions
Even accurate annual totals can produce a poor runway forecast if timing is wrong. Annual insurance paid in one month should appear as a lump sum in that month unless you intentionally smooth it for planning purposes. The same applies to tax payments, annual software renewals, and inventory buys.
5. Founder pay and deferred costs
If founders are taking reduced pay temporarily, document that as an assumption. A runway model that only works because essential compensation is deferred can give false confidence. The same goes for unpaid vendors, delayed maintenance, or postponed tax obligations.
6. Hiring plan
Hiring usually changes runway more than small software savings do. Put each planned hire into the spreadsheet with a start month and fully loaded monthly cost. If you are comparing options, build a scenario for each.
7. Funding assumptions
If you expect a loan, grant, or investor funding, keep that line separate from operating revenue. It can be useful to maintain two views:
- Runway without new funding
- Runway including assumed funding
This keeps the model honest. If outside cash is uncertain, it should not be hidden inside the operating forecast.
8. Scenario logic
A good cash runway forecast should not rely on one story. Use a base case, downside case, and upside case. If you want a ready structure for that, see Scenario Planning Spreadsheet: Best Case, Base Case, and Worst Case Models.
Common mistakes to avoid
- Using revenue instead of cash receipts
- Ignoring taxes, debt service, or annual renewals
- Smoothing all expenses evenly across the year
- Leaving out one-time but likely costs
- Failing to update assumptions after a headcount or pricing change
- Using only one average burn figure when monthly burn clearly varies
If your business has higher uncertainty, consider adding a range-based view using methods from Monte Carlo Simulation in Excel and Google Sheets for Forecast Risk Ranges. That can help you understand not just one runway estimate, but a reasonable spread of possible outcomes.
Worked examples
Here are two simple examples to show how the spreadsheet behaves.
Example 1: Early-stage startup with recurring software costs and payroll
Assume a startup begins the month with $120,000 in cash. Monthly cash collections are $18,000. Monthly cash outflows are $38,000. Net cash flow is therefore negative $20,000.
Monthly net burn = $38,000 - $18,000 = $20,000
Simple runway = $120,000 / $20,000 = 6 months
In a spreadsheet, that simple answer is useful, but a month-by-month view adds more context. If the company plans to hire one employee in month three for an added $5,000 monthly cost and expects collections to improve to $24,000 by month four, the runway no longer follows a straight line. The spreadsheet will show a dip from the hire followed by partial recovery from revenue growth.
This is exactly why a projected runway model is better than a single headline metric. It lets you test whether the hire should happen now, later, or only after collections improve.
Example 2: Small business with seasonal revenue
A services business starts with $80,000 in cash. Expenses are relatively stable at $22,000 per month. Cash inflows vary: $15,000, $18,000, $30,000, $34,000, $20,000, and $16,000 over six months.
If you use a simple average, you might underestimate the stress created by the first two months. The business is burning cash early, then rebuilding later. A proper spreadsheet will show ending cash each month:
- Month 1 ending cash: $73,000
- Month 2 ending cash: $69,000
- Month 3 ending cash: $77,000
- Month 4 ending cash: $89,000
- Month 5 ending cash: $87,000
- Month 6 ending cash: $81,000
Although the business survives comfortably in this example, the monthly pattern matters. If month-one or month-two collections are delayed further, the owner may need to cut discretionary spending or negotiate payment timing with vendors. A runway model makes that visible before the pressure becomes urgent.
How to use worked examples in your own sheet
When you build the model, create a duplicate scenario tab and test questions such as:
- What happens if revenue is 15% lower for three months?
- What happens if a planned hire is pushed back by one quarter?
- What happens if software and contractor costs rise together?
- What happens if funding arrives two months later than expected?
These are practical planning questions, not academic ones. They help you decide whether to freeze hiring, adjust pricing, reduce ad spend, or seek financing earlier.
If you want to prioritize which cuts or investments matter most, a simple decision framework like Weighted Scoring Model Spreadsheet for Vendor, Hire, and Project Decisions can pair well with the burn model.
When to recalculate
A runway spreadsheet earns its keep when it is updated regularly. The right review schedule depends on how quickly your business changes, but for many startups and small businesses, a monthly update is the minimum. In periods of volatility, weekly may be more appropriate.
Recalculate when any of these changes happen:
- A new hire starts or a role is eliminated
- Payroll costs change
- Prices from vendors or software tools increase
- Marketing spend is raised or cut
- Revenue collection timing slows
- A large customer is won, lost, or delayed
- Inventory purchasing changes
- Debt payments begin or reset
- Funding timing changes
- Taxes or annual renewals come due
Use a simple monthly process
- Update actual cash balance from bank records.
- Replace old assumptions with actual inflows and outflows from the last month.
- Roll the forecast forward by one month.
- Compare base case versus downside case.
- Note the action threshold, such as pausing hiring if runway falls below a chosen level.
Turn the spreadsheet into a decision tool
The most useful runway models are tied to operating decisions. Add a short summary block at the top of your dashboard with:
- Current cash
- Average burn last 3 months
- Projected burn next 3 months
- Runway in months
- Largest expense categories
- Next major cash event
If you present this to a team or leadership group, keep the dashboard clean. A guide like Excel Dashboard Design Best Practices for Readable KPI Reporting can help make the output easier to scan.
A practical final checklist
- Track cash, not just revenue.
- Model monthly timing, not annual averages alone.
- Separate fixed, variable, and one-time costs.
- Keep funding assumptions visible and separate.
- Maintain base, upside, and downside cases.
- Update the workbook whenever inputs materially change.
If you build your spreadsheet this way, it becomes a repeatable finance habit rather than a one-off exercise. That is what gives a burn rate and runway model lasting value. Each new cost, customer, funding plan, or pricing change becomes a reason to return to the sheet, refresh the assumptions, and make a better decision before cash pressure forces one.
