How to Calculate Burn Rate in Excel

Knowing how fast your company is spending its cash is one of the most fundamental aspects of running a business. This figure, known as your burn rate, directly determines your financial runway and influences every strategic decision you make. This tutorial will walk you through exactly how to set up a simple and effective system to calculate and track your burn rate using Microsoft Excel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is Burn Rate and Why Should You Care?

In simple terms, your burn rate is the speed at which your company spends money, specifically its venture capital or startup funds, before it becomes profitable. It’s a measure of negative cash flow.

Tracking this metric is not just a bookkeeping exercise, it's about survival. A clear understanding of your burn rate tells you:

• How much time you have left: This is your "cash runway" - the number of months you can continue operating before you run out of money.
• When to fundraise: You can’t wait until you have two weeks of cash left to start talking to investors. Knowing your burn rate helps you plan fundraising rounds well in advance.
• The impact of your spending: Seeing how a new hire, a big marketing campaign, or a new software subscription affects your burn rate makes your spending decisions more tangible and data-driven.

Gross Burn Rate vs. Net Burn Rate

It's important to know the difference between two types of burn rate: Gross Burn and Net Burn. Both offer valuable context.

• Gross Burn Rate: This is the total amount of money your company spends in a month. It includes all operating expenses like salaries, rent, software fees, marketing costs, and office supplies. It’s a straightforward measure of your total cash outflow.
• Net Burn Rate: This is a more realistic picture of your financial situation. It’s calculated by taking your total monthly cash expenses (Gross Burn) and subtracting any cash you brought in (revenue).

Net Burn = Gross Burn - Revenue

If your revenue is less than your expenses, the result will be a positive number, which represents your true cash burn for the month.

For most strategic planning, you'll be focusing on Net Burn Rate because it reflects how sustainable your business is at its current state. You can be spending $100,000 a month (Gross Burn), but if you're also bringing in $80,000, your Net Burn is only $20,000.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Gather Your Financial Data

Before you open Excel, you need to collect the right information. The accuracy of your burn rate calculation depends entirely on the quality of your data. For a standard monthly analysis, you will need two main pieces of information each month:

1. Total Cash In (Revenue): All the cash that came into your bank account for a given month. This includes sales revenue, subscription fees, or any other income.
2. Total Cash Out (Expenses): All the cash that left your bank account. This is your total operating expenditure, covering salaries, rent, marketing spend, software subscriptions, utilities, etc.

The best place to find this information is your accounting software (like QuickBooks, Xero, or Stripe) or your business bank statements. For this exercise, pull your monthly totals for cash in and cash out for the last 6 to 12 months. Having a historical view provides more context than looking at a single month in isolation.

Step 2: Set Up Your Excel Spreadsheet

This is where we build the foundation for your analysis. It doesn't need to be complex, a clean, simple layout is best.

Open a new Excel sheet and create the following columns:

• Column A: Month
• Column B: Starting Cash Balance
• Column C: Cash In (Revenue)
• Column D: Cash Out (Expenses)
• Column E: Net Burn
• Column F: Ending Cash Balance

Your blank spreadsheet should look something like this:

Now, start populating the sheet with your historical data that you gathered in the previous step. Enter the months in Column A, revenue in Column C, and expenses in Column D.

Your Starting Cash Balance for the first month is the actual amount of cash you had in the bank at the beginning of that period.

Step 3: Add the Formulas to Calculate Burn Rate

With your data in place, it’s time to let Excel do the math. We'll add formulas to the Net Burn and Ending Cash Balance columns that automatically calculate the values for us.

Calculating Monthly Net Burn

Your Net Burn is your monthly revenue minus your monthly expenses. Click into Cell E2 (the first cell in your Net Burn column) and enter the following formula:

=C2-D2

This formula subtracts the cash out (D2) from the cash in (C2). If your expenses are higher than your revenue, this number will be negative - that’s your burn rate for the month.

Drag the small square at the bottom-right corner of cell E2 down to apply this formula to all the months you have data for. Excel will automatically adjust the cell references for each row.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Calculating Ending Cash Balance

Your ending cash balance for a month is simply your starting balance plus your net cash flow (or minus your net burn). In Cell F2, enter this formula:

=B2+E2

This adds the Net Burn (which will be a negative number if you're burning cash) to the Starting Cash Balance to give you the Ending Cash Balance.

The Starting Cash Balance for the next month (B3) is the same as the Ending Cash Balance of the previous month (F2). So, in Cell B3, just type:

=F2

Now, select both cells E2 and F2 simultaneously and drag the formula handle down to autofill the rest of your table. Your spreadsheet should now be fully calculated.

Step 4: Calculate Your Average Burn Rate and Cash Runway

Looking at burn month-by-month is useful, but calculating an average provides a more stable metric for future planning, especially if you have lumpy revenue or expenses.

Average Monthly Net Burn

Find an empty cell on your sheet and label it "Average Monthly Net Burn." In the cell next to it, use the AVERAGE function to calculate the average of your monthly burn rates. If your Net Burn numbers are in cells E2 to E7, the formula would be:

=AVERAGE(E2:E7)

This gives you a single, clear number that represents your typical cash burn. You can use this for forecasting.

Calculating Your Cash Runway

Now for the most important calculation: your cash runway. This tells you how long you can survive before running out of money, assuming your burn rate stays consistent.

The formula is:

Runway (in months) = Current Cash Balance / Absolute value of Average Monthly Net Burn

Find another empty cell and label it "Cash Runway (Months)." In the formula cell, reference your company’s current total cash balance and divide it by the absolute value of your average net burn. We use the absolute value (a positive version of the number) with the ABS function because you can't divide by a negative number to get runway.

If your Current Cash Balance is in F7 and your Average Monthly Net Burn is in I2, the formula would be:

=F7/ABS(I2)

The result is the number of months your company can continue to operate with its current cash and burn rate. This is the number that keeps founders up at night, and it's your primary guide for financial planning.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Visualize Your Burn Rate with a Chart

Numbers in a table are useful, but a visual chart often tells a more compelling story. Creating a simple chart in Excel can help you spot trends in your burn rate over time.

1. Select your data: Highlight the Month column and the Net Burn column. Hold down the Ctrl (or Cmd on Mac) key to select non-adjacent columns.
2. Insert a chart: Go to the Insert tab in Excel's ribbon. Look for the Charts section and select a "Column" or "Bar" chart. A simple 2D column chart works great.
3. Format your chart: Excel will generate a basic chart. Make sure to give it a clear title like "Monthly Net Burn" and check that the axes are labeled correctly.

Your chart might show that your burn is increasing, decreasing, or staying steady. It instantly makes your financial story much easier to share with your team or investors.

Final Thoughts

Manually calculating your burn rate and runway in Excel puts you in direct control of your company's financial health. It transforms abstract financial data into clear, actionable numbers that guide your hiring, spending, and fundraising strategy. By regularly updating your spreadsheet, you can maintain a constant pulse on the most vital metric for any startup's survival.

While Excel is a great starting point, keeping it updated can become another manual task on your to-do list. That's why we created Graphed. We connect directly to your financial sources like QuickBooks, Stripe, and your bank accounts to automate this entire process. You can just ask for "my burn rate and runway dashboard," and we'll instantly create a live report that stays up-to-date automatically, saving you hours of spreadsheet work and giving you back time to focus on growing your business.