How to Create a Burn Rate Chart in Excel

Running out of cash is one of the most common reasons businesses fail, which makes tracking your “burn rate” absolutely vital. Understanding how quickly you're spending your capital is the first step to managing it effectively. This article will show you exactly how to calculate your company's burn rate and create a clean, easy-to-read burn rate chart using Microsoft Excel.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is Burn Rate?

At its core, burn rate is the speed at which your company is spending its cash reserves. It’s typically measured on a monthly basis. This metric is especially critical for startups and pre-profitability companies that rely on investor funding to operate. Knowing your burn rate helps you understand your financial health and forecast how long you can continue operating before you need to raise more money or become profitable - a timeframe often called your "runway."

Gross Burn vs. Net Burn

There are two types of burn rates you should know, and the difference is simple but important:

• Gross Burn Rate: This is the total amount of cash your company spends in a month. It includes all of your operating expenses like salaries, rent, marketing costs, software subscriptions, and inventory.
• Net Burn Rate: This is the number most founders and investors focus on. It’s your Gross Burn Rate minus any cash you brought in during the same month (your revenue). Essentially, it's the net amount of money the company loses each month.

Net Burn = Expenses - Revenue

If your company has $20,000 in monthly revenue and $50,000 in monthly expenses, your net burn is -$30,000. This means you "burned" through $30,000 of your cash reserves that month. The goal, of course, is to get this number to zero and then into positive territory (profitability).

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Why a Chart Is Better Than a Spreadsheet

You can calculate your burn rate in a single cell, but rows and columns of numbers don’t tell a story. Visualizing your burn rate in a chart turns complex data into an at-a-glance insight. A well-designed chart can help you:

• Spot Trends Instantly: Is your burn increasing or decreasing over time? A line sloping upwards toward zero is a great sign, while a downward trend might be a signal to cut costs.
• Communicate with Stakeholders: A chart is a powerful tool for showing investors, advisors, and your team how the business is performing. It’s much more effective in a board meeting than a dense spreadsheet.
• Make Informed Decisions: Seeing the gap between your revenue and expenses month-over-month can highlight the impact of a new marketing campaign, a recent hire, or a change in pricing.

Step 1: Gather Your Financial Data

Before you can build your chart, you need to collect your financial data. The two key ingredients are your monthly cash inflows (revenue) and cash outflows (expenses). For the most accurate picture, you should use data from your accounting software (like QuickBooks or Xero), payment processors (like Stripe), and bank account statements.

Create a simple table in Excel or Google Sheets. All you need are three columns to start:

• Month: The period you're measuring (e.g., Jan-24, Feb-24).
• Cash In (Revenue): All the cash received during that month.
• Cash Out (Expenses): All the cash spent during that month.

Step 2: Calculate Burn Rate and Runway in Excel

Now that your data is organized, you can use simple formulas to calculate your net burn and your cash runway. Add two new columns to your table: "Net Burn" and "Runway (Months)."

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Calculate Net Burn

Your net burn is your monthly expenses minus your monthly revenue. If your revenue is in column B and your expenses are in column C, the formula is straightforward.

1. In the first cell of your "Net Burn" column (let's say it's D2), type the following formula:

=C2-B2

1. Press Enter. This will calculate the net cash flow for that month. A positive number indicates cash burn.
2. Click on the bottom-right corner of cell D2 (the fill handle) and drag it down to apply the formula to the rest of your months.

Calculate Runway

Your runway tells you how many months your company can survive at its current burn rate before running out of money. To calculate this, you first need to know your current total cash balance.

1. Find a separate, empty cell outside your table to input your current cash balance. For this example, let's say it's cell G2 and your cash balance is $250,000.
2. Back in your table, in the first cell of the "Runway (Months)" column (E2), you'll divide your total cash by your monthly burn. Since burn is a positive number, use the ABS function to ensure it remains positive for the calculation.
3. Type this formula into cell E2. We use $G$2 to lock the cash balance cell so it doesn't change when you drag the formula down.

=$G$2/ABS(D2)

1. Drag the formula down to calculate the runway based on each month's burn rate.

Step 3: How to Create a Burn Rate Chart in Excel

With the calculations complete, creating the chart is the easy part. We're going to create a "combo chart" - one that uses both columns and a line. This is the most effective way to visualize revenue, expenses, and the burn rate all at once.

1. Select Your Data: Highlight the columns you want to visualize: 'Month', 'Cash In (Revenue)', 'Cash Out (Expenses)', and 'Net Burn'. Make sure to include the header row.
2. Insert a Combo Chart:
3. Configure the Chart Type:
4. Create the Chart: Click OK. Excel will instantly generate the chart and place it on your worksheet.

Step 4: Customize and Interpret Your Chart

Your chart is created, but a few quick customizations will make it clearer and more professional. Right-click different elements of the chart to modify them.

• Add a Clear Title: Change the default "Chart Title" to something descriptive, like "Monthly Financials & Net Burn Rate."
• Label Your Axes: Click the "+" icon next to the chart and check "Axis Titles." Label the primary vertical axis (left) as "Amount ($) - Revenue/Expenses" and the secondary vertical axis (right) as "Amount ($) - Net Burn."
• Adjust Colors: For quick visual cues, consider making the 'Cash In' columns green, 'Cash Out' columns red, and the 'Net Burn' line a distinct color like blue or dark gray. You can change colors by right-clicking a data series and selecting 'Format Data Series'.
• Remove Clutter: You can remove the horizontal gridlines for a cleaner look. Click on them and press 'Delete'.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Read Your New Chart

Your finished chart tells a clear story. The green columns represent money coming in, and the red columns show money going out. The blue line is the result: your net profit or loss. When the line is below the zero mark, you're burning cash. The trend of that line over several months is the most important insight - you want to see it climbing toward profitability.

Final Thoughts

By transforming raw numbers in a spreadsheet into an intuitive chart, you've created a powerful tool for monitoring your business's financial health. An Excel burn rate chart helps you spot trends, communicate progress, and stay on top of the single most important resource you have: cash.

Of course, manually exporting data and updating Excel sheets each month can quickly become a time-consuming routine. That’s precisely why we built Graphed. We automate the process by connecting directly to your financial tools like QuickBooks and Stripe, along with your marketing and sales platforms. This gives you a live, up-to-date view of your burn rate, customer acquisition costs, and other vital metrics in a real-time dashboard, so you can spend less time building reports and more time acting on the insights they provide.