How to Calculate Burn Rate in Excel with AI

Tracking how much cash your business is spending is fundamental to survival, especially for startups and growing companies. Calculating your burn rate manually in a spreadsheet is a common starting point, but it's often a time-consuming process prone to error. This guide walks you through the traditional Excel method and then shows you how AI can automate the entire process, giving you faster and more reliable insights into your company's financial health.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Burn Rate (and Why You Should Care)

Your burn rate is simply the pace at which your company is spending money, specifically the negative cash flow. It tells you how long your business can continue to operate before running out of funds. Founders and managers use this metric to forecast their financial "runway" - the number of months you have until you hit zero.

Tracking burn rate isn’t just about avoiding a crisis, it’s about making smarter strategic decisions. It helps you decide when to fundraise, when to cut costs, and when to accelerate growth. There are two primary types of burn rate to understand.

Gross Burn Rate

Gross Burn measures the total amount of cash your company spends in a month on operating expenses. This includes salaries, rent, software subscriptions, marketing costs, and other overhead. It’s a straightforward look at your total cash outflow, ignoring any incoming revenue.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Net Burn Rate

Net Burn is the more commonly used metric. It represents your company's true monthly cash loss by subtracting your monthly revenue (cash in) from your Gross Burn (cash out).

Net Burn Rate = Cash Out (Expenses) - Cash In (Revenue)

For example, if your company spends $50,000 in a month and brings in $20,000 in revenue, your Net Burn for that month is $30,000. This is the figure that truly defines your runway.

Prepping Your Financial Data for Excel

Before you can run any calculations, you need to consolidate your financial data into a single, clean spreadsheet. This foundational step is often the most time-consuming part of the process.

You’ll need to pull data from various sources:

• Operating Expenses: Gather these from your accounting software (like QuickBooks or Xero), bank statements, and credit card bills. These include payroll, rent, utilities, marketing spend, and software fees.
• Revenue: Pull this from your payment processor (like Stripe), e-commerce platform (like Shopify), or accounting software.

Organize this data in a simple table. Create columns for the Month, Total Expenses (your Gross Burn), and Total Revenue. Your spreadsheet should look something like this:

Calculating Your Burn Rate: The Step-by-Step Guide

With your data organized, you can now apply some simple formulas to calculate your burn rate and runway.

Step 1: Calculate Your Monthly Net Burn

Your Net Burn is the difference between what you spend and what you earn each month. Add a fourth column to your spreadsheet called "Net Burn Rate."

In cell D2, subtract your revenue (C2) from your expenses (B2) by typing the following formula:

=B2-C2

Press Enter. To apply this formula to the rest of your months, click on cell D2, and then click and drag the small square in the bottom-right corner of the cell down the column. Excel will automatically adjust the formula for each row.

Your spreadsheet will now look like this:

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Find Your Average Net Burn Rate

While monthly burn is useful, an average gives you a more stable metric for long-term planning, smoothing out any single month's anomalies. To calculate this, use Excel's AVERAGE function.

In an empty cell, type the following formula, adjusting the range to match your "Net Burn Rate" column:

=AVERAGE(D2:D5)

In our example, this would give us an average monthly burn of $58,750.

Step 3: Determine Your Cash Runway

Now for the most important part: calculating how long your cash will last. Your runway is your current cash balance divided by your average net burn rate.

First, you'll need your most up-to-date cash balance. Let’s say your business has $500,000 in the bank.

The formula is:

Current Cash Balance / Average Net Burn Rate = Runway (in months)

Using our example:

$500,000 / $58,750 = 8.5 months

Your business has approximately 8.5 months of runway before it runs out of cash, assuming current expense and revenue trends continue.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Using AI for In-Spreadsheet Assistance

While the steps above are manageable, you can use conversational AI tools like ChatGPT to assist with the process. Think of it as a helpful assistant that can guide you, but can't do the heavy lifting of gathering and connecting the data for you.

Here’s how you could use it:

• Generating Formulas: If you're unsure about a formula, you can ask a direct question like, “Give me the Excel formula to calculate the average of cells D2 through D13.”
• Structuring Your Data: You could ask for advice on how to set up your sheet. For instance, “What columns should I create in Excel to track my monthly cash burn rate and runway?”
• Analyzing a pasted table: After calculating your burn rate, you can copy the table and paste it into the chat with a prompt like "Based on this data, what is my runway if I have $500,000 available cash?"

This approach can save a bit of time, especially if you're not an Excel whiz. However, it still relies entirely on manual data entry and regular updates. You’re still downloading CSVs, copy-pasting numbers, and manually correcting errors. Every month, you have to repeat the entire process just to get an updated view. This is where AI-native reporting tools fundamentally change the game.

Final Thoughts

Calculating your burn rate in Excel is an effective way to get a snapshot of your company's financial health. By organizing your expense and revenue data and applying a few simple formulas, you can estimate your monthly burn and cash runway. This gives you a baseline for sound decision-making.

While Excel and a little help from AI are useful, the manual process of pulling, cleaning, and updating data from different platforms every month is exactly the kind of repetitive work we built Graphed to eliminate. Instead of spending hours in spreadsheets, we allow you to connect your accounting, billing, and payment platforms directly. From there, you can just ask questions in plain English like, "Show me my net burn rate and runway for the last 6 months," and receive an interactive, real-time dashboard that updates automatically, saving you hours of invaluable time you want moving business forward.