Use Your Burn Rate

Last Updated (Text)
Nov 2021'
One of the most stressful and exciting traits of self-employment is control over your schedule. Projecting your income lets you choose how to spend your time. Here's a walkthrough of the spreadsheet I use.

Goal: Know Your Cushion

When running your own business, pain points surface quickly and burn a hole in your pocket. Every hour of boring secondary work means you're not making money from client projects or doing something you enjoy. Thankfully boring often means repetitive and software is thirsty for repetition.

Every time a project came through the door, I found myself recalculating how much I was making and spending. I needed to weigh the intrigue of the project against my near-term finances. Important, but boring, so I built a simple spreadsheet to plug-in potential projects and see how they stack up against my spending and savings goals.

Why: Reduce Decision Fatigue

Project-based income makes time management a high-stakes decision. Saying yes to one project means saying no to time for ops, personal things, and potentially better projects. You can lower the stakes by reducing the number of steps in the decision, so you:

  • Never re-crunch the same numbers
  • Respond to leads quicker
  • Quickly decide what to work on
  • Have peace of mind about spending and saving

When: For Projects and Purchases

I typically pull up this sheet whenever I'm questioning how to spend my time.

For example:

  • Deciding between projects
  • Considering a large purchase
  • Taking a break from paid work
  • Wondering if I should do things to drum up new leads

Note: This isn't bookkeeping

How To Calculate Your Cushion

We're making enough money if:

  1. We can pay our bills
  2. We can pay our taxes
  3. We can save what we want

These are the inputs we'll use to build this sheet.

① — Expenses


You don't need to write everything out like this. You just need to know your average monthly business expense. If you know that, you can skip this sheet and enter it directly in Goals.

However: The benefits of writing them all out

② — Goals


The other inputs—personal spending, taxes, and savings—live in Goals.

Enter them accordingly:

  • Personal Spending: what you spend each month on non-business expenses, like rent.
  • Taxes: your estimated cumulative tax rate, including state and local.

I divide my savings goal into three tiers:

  1. Baseline: enough to cover personal spending, business expenses, and taxes.
  2. Flat Savings: enough to cover a set savings amount. Useful if you auto-withdraw into your investment account.
  3. % Savings — enough to save a percentage of what you're making. Useful for saving strategies like 50 / 30 / 20.

Adjust Accordingly

To keep this sheet simple the goals are all based on a single monthly average.

In reality, income and expenses fluctuate throughout the year, and life events may dramatically shift how much you need to spend or save, so it's important to adjust the numbers accordingly.

Note: Track personal spending
Note: Play it safe with tax rate

③ — Projections


This is where the calculations happen.


  1. New projects in the first column.
  2. Estimated income from the project in the month(s) you expect to do the work.

The revenue rows update accordingly. The color of the cell indicates which goal you’re reaching. Once you approach blue and green, you know the projects you have planned cover your expenses and savings goals—and you're free to spend the rest of your time as you’d like.

Try It Yourself


A sheet like this is easy to setup, saves time, reduces decision fatigue, and provides peace of mind. Using tech in this way is extra clutch for solo business owners because it allows us to focus on the meat of our business. Consider other recurring decisions you have to make and which steps can be replaced with software.

Let me know if you liked this, hated this, or have an idea how to do it better. I plan to keep this site evergreen by incorporating improvements offered through feedback and anecdotal experience.

Another Use Case: Pricing

When you're just starting out, the general recommendation is to set your hourly rate to make sure you can pay your bills and save a bit.

That’s essentially the input to this sheet, so it can be calculated similarly:

  • Let's say your Baseline + 20% Savings goal is $10,000.
  • And you can work 25 billable hours per week.
  • Then you should charge at least $100 / hr. $10,000 per month / (25 hours * 4 weeks) = $100.

Another Use Case: Taxes

Take It Further

  • Instead of manually entering the tax rate, create a sheet that calculates your cumulative tax rate based on the tax bracket your projected revenue will land in and where you live.
  • Integrate with your CRM so the project list is automatically populated.