The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (2024)

2K Shares

The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (1)

As it is the start of a new year, many people began to get their minds refocused on all-things-budgeting. I love starting of the new year right with organized finances, and I want to show you that it is not hard at all with the right framework! The framework that I’m referring to is the 50/30/20 Budget.

I’ve been using this method to track my expenses for several years, and it is just so easy to follow! In this post I’ll explain what this budget is, how to use it, and provide a FREE 50/30/20 budget spreadsheet and calculator that you can use to get started right away!

Table of Contents

The 50/30/20 Budget Spreadsheet

If you just want the download and don’t want to wait until the end – you can grab your 50/30/20 spreadsheet below. It includes both the 50/30/20 budget template and calculator. For more information / instructions – keep reading!

Why Set a Budget?

Maybe the most important question of them all, as I’ve mentioned in this post . For those of you who have been following me for a while, you may wonder why I’m focusing on this topic at all. As part of my (in-progress) re branding, I’ll be incorporating some money tips from time to time, as it is a major factor in traveling as much as possible.

If you know where your money is going and track expenses, you are put in a position where you can allocate your money to the things you like to do too. And if you stick to your budget, you are very likely to hit still hit your savings targets / reduce debt without any issues. Isn’t that a place where we all want to be? The 50/30/20 budget spreadsheet that I’ll provide in this post will help you do just that.

The 50/30/20 Budget Explained

The 50/30/20 Budget is one that was made popular by the book “All Your Worth: The Ulitmate Lifetime Money Plan”, written by Senator Elizabeth Warren and her daughter, Amelia Warren Tyagi. The intention of this book is to help the reader master their finances by allocating a set percentage to three categories of money:

50% – Needs or Must-Haves

The “needs” are the items that you have to purchase in order to survive and those bills that you have to pay off each month. This may vary a bit from person to person, but here are a few examples:

  • Groceries
  • Utilities
  • Rent / Mortgage / Car Payments
  • Health Insurance
  • Minimum Debt Payments

Note that this category does not include seemingly related items, such as restaurants, as eating out is not necessary but eating is. Keep that in mind as you make the budget your own.

30% – Wants

The “wants” category includes all the expenses you make to enhance your quality of life. Example categories include:

  • Entertainment (Movies, concerts, etc.)
  • Cable TV
  • Eating Out
  • Travel 😉
  • Hobbies

This category will vary the most as “wants” are very particular to the individual. Add what’s most important to you here when you personalize your spreadsheet.

RELATED: How to Budget for Travel

20% – Savings / Debt

This category is entirely devoted to increasing the size of your bank accounts. The smallest of the three categories, this one includes the following:

  • Saving Accounts (Includes building an emergency fund)
  • Retirement Accounts
  • Investments (ETFs, Stocks, Real Estate, etc.)
  • Debt Repayment (Anything greater than the minimum)

The last item may seem like it doesn’t fit, but keep in mind that any payments that you make greater than the principal will give you savings in the long run.

The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (2)

Download the FREE 50/30/20 Budget Template and Calculator

So now that you know what the budget is, let’s start taking action to put this budget into use now! In the download below, you’ll access a Google Sheets spreadsheet.

This spreadsheet has two tabs: The first helps you calculate the amount of money that goes into each category, while the second is an automated template that you can use to keep track of your monthly budget.

Note: It does not matter if you are starting in January or December, it’s never to late in the year to start budgeting!

How to Use the 50/30/20 Calculator

The first tab of the spreadsheet includes the 50/30/20 Calculator. To use this form, just add in your total after-tax income, and the rest of the budget will be calculated for you automatically!

If you don’t make a standard income from month-to-month, calculate your average after-tax income for the past three months and add that value to the form.

One thing I’ll add is that while the percentages are a great starting point, you’ll likely have to modify a bit yourself when you start using the spreadsheet. However, this should only be due to circ*mstances outside your control (e.g., high bills, large debts).

How to Use the Spreadsheet

The second tab of the spreadsheet includes the monthly budget tracker. To use this form, you must first review the categories in each budget group, and update based on your personal expenses. There are open categories (marked other) that you can use to add additional categories, if necessary. If you do need to do this, be sure to make the same updates on the list on the “dropdown” tab so that expenses pull in appropriately.

Once the categories are updated, add in the values for each one. As you do this, make sure your total for each group does not exceed the amounts set on the “50 30 20 Calculator” tab.

You are now ready to start adding your expenses in the “Tracking Expenses” table. The most important thing here is to use the drop down to elect the proper category for each expense. That will pull in each value automatically to the totals on the left-hand side.

If you have questions at any time, feel free to email me at [emailprotected].

The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (3)

50/30/20 Budget Example : Couple Making $125,000

Now, let’s put this into practice shall we? In our first example, let’s assume there is a couple (John and Mary) that jointly makes $125,000/year (after tax) that lives in Washington, DC. They have 1 daughter that they are raising as well. Using the 50/30/20 budget calculator, here’s what the breakdown of their expenses would be:

CategoryTotal Amount
Monthly Income$10,416
Needs$5,208
Wants$3,125
Savings / Debt$2,083

Note: For the purposes of this example, let’s assume both are paid monthly.

Needs – 50% of $125,000 Salary

Now, $5,208 may seem like a lot of money, but in DC you’ll find that your dollars don’t go as far as they do in most of the US. Here are some estimations on what her monthly expenses might be:

  • Housing: They own a home in the Capitol Hill neighborhood, and pay $3,000/month for their mortgage
  • Utilities: For gas, electric, and water, they typically pay $200/month
  • Groceries: The family shops at the local Safeway for groceries and spends around $700/month on groceries
  • Car Insurance and Maintenance: They only own one car since they live close to public transport, and are done with car payments. They spend about $100/month for insurance, and an average of $12/month for maintenance. (The car is still in good condition.)
  • Transportation: Both John and Mary usually take public transportation to work on the bus / subway. During the week, they may also incorporate the use of Uber in the mix, and when driving during the weekend, the usually incur parking fees. They pay a total of $550/month total on transportation costs for their MetroCard, Ubers, gas, and parking fees
  • Health Insurance: John’s job provides solid health coverage, and since everyone in the family is healthy, they have opted for a high-deductible spending plan. Cost – $150/month for family coverage (health + dental)
  • Childcare Costs: Their daughter is of elementary school age, so their costs are extremely high, but they still set aside $500/ month for any babysitting / childcare costs, as well as extracurricular activities

Total amount spent/month: $5,212 on Needs. Note they are just slightly over by $4.

Wants – 30% of $125,000 Salary

As shown in the prior section, the family has $3,125 to spend on Wants each month. Let’s get into how they may use this bucket of money:

  • TV/Internet: The family does not subscribe to cable TV, but does pay $70/month for subscriptions to Netflix, Hulu TV, and HBO Max. In addition, they pay for high-speed internet, since John often works from home. Their internet subscription costs $60/month
  • Entertainment: They set aside $200/month for entertainment costs. This includes anything from trips to paid museums, concerts, or local shows (such as those at the Kennedy Center)
  • Restaurants: John and Mary plan to eat out about 1x/week as a family and may also pick up lunch during the work week. They spend $600/month on all eating out expenses
  • Travel: Exploring new places both in the US and internationally is a high priority for the family. They save $700/month towards travel so that they always have a pool of money to pull from
  • Hobbies: Mary is a hobby photographer, and spends around $150/month on new gadgets for her camera

Total amount spent per month: $1,780 on Wants. Note, they have saved $1345/month, let’s see how they make the most of this in the next category.

Savings/Debt – 20% of $125,000 Salary

Let’s get into my favorite category – the one that’s focused on building wealth / getting rich. Please note that John and Mary have no debts outside of their mortgage. As a refresher, the couple has $2,083 allocated towards this bucket:

  • High-Interest Savings Account: They have built up their savings to cover 3 months of expenses, and typically add around $200/month to keep it growing
  • Retirement Account (401K): The couple puts up to their company match each month into their individual retirement accounts. Both of their companies match up to 6% of their salaries. They spend a total of $625/month towards their retirement account
  • Health Savings Account: Since they have a High-Deductible Health Plan, they are eligible for an HSA. As this can be used as an investment account, they opt to max out their investment and add $592/month into the account
  • Roth IRA: With the additional money left over from the “Wants” category, John and Mary fully fund their Roth IRAs for the year. They both add $800/month to their accounts
  • Taxable Brokerage Account: John and Mary set aside the additional $411/month to invest as they please in ETFs and individual stocks
  • Giving: Giving back is important to the couple, and they set aside $800/month towards charitable causes

Total Amount Spent: John and Mary have spent $3,428 in this category, successfully allocating money saved in the “Wants” category to building wealth.

RELATED: 5 Easy Ways to Save More Money

A Few Budgeting Tips

As you build your budget, there are a few important to keep a few things in mind.

  • Set realistic goals – Don’t set savings goals that you can’t reach, for example
  • Understand your spending habits – As a best practice, it’s a great idea to average out your expenses for the past few months to get a realistic picture of how you spend money. This is particularly useful for informing the “wants” group of your budget.
  • Keep track of your expenses regularly – I recommend tracking your expenses at least bi-weekly, and more if you know you are a spender.
  • Modify the percentages of each group, if necessary – If you are really focused on paying down debt, for example, you may want to increase the amount of money allocated to the “savings/debt” group and decrease the “wants” group.

RELATED: The Best Course for Improving Your Money Mindset

Planning for the Year Ahead

Now that you have the information and the tools you need to start your 50/30/20 Budget, get started tracking your budget today! Once you know where you money is going, you will be amazed how you can refocus your expenses on the things that you want to do or the places that you want to go.

#travelwandergrow

Related Posts:

  • The Best Course for Improving Your Money Mindset
  • How to Budget for Travel
  • The Zero-Based Budgeting Method
  • Things Rich People Do to Build Wealth
The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (4)
The 50/30/20 Budget Spreadsheet and Calculator (with Examples) - TravelWanderGrow (2024)

FAQs

How do you create a 50/30/20 budget spreadsheet? ›

Here's a quick rundown of the various categories of the 50 30 20 budget rule and how to use them:
  1. Needs: 50% Half of your earnings should go toward the things you need. ...
  2. Wants: 30% Life isn't all about needs and savings. ...
  3. Savings: 20% The last category in a 50 30 20 budget is for savings. ...
  4. Additional resources.

What is the 50 30 20 rule of budgeting examples? ›

For example, if you earn ₹ 1 lakh, you can allocate ₹ 50,000 to your needs, ₹ 30,000 to your wants and ₹ 20,000 to your savings, every month.

How to calculate the 50/30/20 rule? ›

Those will become part of your budget. The 50-30-20 rule recommends putting 50% of your money toward needs, 30% toward wants, and 20% toward savings. The savings category also includes money you will need to realize your future goals.

Is there a 50/30/20 app? ›

Moneywyn: 50/30/20 Budget Rule on the App Store.

Is the 50/30/20 rule realistic? ›

For many people, the 50/30/20 rule works extremely well—it provides significant room in your budget for discretionary spending while setting aside income to pay down debt and save. But the exact breakdown between “needs,” “wants” and savings may not be ideal for everyone.

What is the best free app for budgeting? ›

The best budgeting apps, ranked*
RankingPlatform nameAverage app rating
1Rocket Money4.3
2Simplifi3.4
3YNAB4.7
4Monarch Money4.4
10 more rows
Feb 23, 2024

What is the financial formula 50 30 20? ›

Here, 50 per cent of your income should go towards living expenses (needs), like household expenses, groceries; 20 per cent (savings) towards savings for your short, medium, long-term goals; and 30 per cent towards spending (wants), including outings, food and travel.

What is one negative thing about the 50/30/20 rule of budgeting? ›

It may not work for everyone. Depending on your income and expenses, the 50/30/20 rule may not be realistic for your individual financial situation. You may need to allocate a higher percentage to necessities or a lower percentage to wants in order to make ends meet. It doesn't account for irregular expenses.

How to survive on $3,000 a month? ›

Calculating your target budget

If you make $3000 a month after taxes, then 50% ($1500) would go toward needs, the next 30% ($900) goes toward your wants or discretionary spending, and the remaining 20% ($600) goes toward your savings.

When should you not use the 50 30 20 rule? ›

The 50/30/20 has worked for some people — especially in past years when the cost of living was lower — but it's especially unfeasible for low-income Americans and people who live in expensive cities like San Francisco or New York. There, it's next to impossible to find a rent or mortgage at half your take-home salary.

What is the 50/30/20 budget biweekly? ›

It's a simple rule of thumb that suggests you put up to 50% of your after-tax income toward things you need, 30% toward things you want, and 20% toward savings.

Is 50/30/20 gross or net? ›

50% of your net income should go towards living expenses and essentials (Needs), 20% of your net income should go towards debt reduction and savings (Debt Reduction and Savings), and 30% of your net income should go towards discretionary spending (Wants).

What is the best budgeting tool? ›

Best Budgeting Apps Of May 2024
  • YNAB (You Need A Budget): Best for Setting Goals.
  • Empower Personal Dashboard™: Best for Tracking Net Worth.
  • Goodbudget: Best for Envelope Budgeting.
  • Oportun (formerly Digit): Best for Passive Saving.
  • PocketGuard: Best for Tracking Spending.
  • Stash: Best for Automated Investing.
4 days ago

How to budget money for beginners? ›

Try the 50/30/20 rule as a simple budgeting framework. Allow up to 50% of your income for needs, including debt minimums. Leave 30% of your income for wants. Commit 20% of your income to savings and debt repayment beyond minimums.

What is the 50 30 20 rule budget Excel? ›

50% of your income goes to NEEDS: core living expenses – rent, mortgage, groceries, bills, transportation, insurance. 30% goes to WANTS: entertainment, eating out, certain subscriptions, fun stuff! 20% goes to FREEDOM: eliminating debts and saving for emergencies and then retirement.

What is the 50 30 20 rule in Excel? ›

If you want to make a budget and increase your savings account in daily life, you should definitely use 50/30/20 method. 50/30/20 means that you spend 50% of your budget on your needs and 30% on wants. Then, you will save the rest 20%. If you are interested, we recommend you our 50/30/20 Budget Template in Excel!

How to make your own budget spreadsheet? ›

How to create a budget spreadsheet
  1. Choose a spreadsheet program or template.
  2. Create categories for income and expense items.
  3. Set your budget period (weekly, monthly, etc.).
  4. Enter your numbers and use simple formulas to streamline calculations.
  5. Consider visual aids and other features.

Does Microsoft Excel have a budget template? ›

DIY with the Personal budget template

Prefer to do things yourself? This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses.

Top Articles
Latest Posts
Article information

Author: Carmelo Roob

Last Updated:

Views: 6670

Rating: 4.4 / 5 (65 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Carmelo Roob

Birthday: 1995-01-09

Address: Apt. 915 481 Sipes Cliff, New Gonzalobury, CO 80176

Phone: +6773780339780

Job: Sales Executive

Hobby: Gaming, Jogging, Rugby, Video gaming, Handball, Ice skating, Web surfing

Introduction: My name is Carmelo Roob, I am a modern, handsome, delightful, comfortable, attractive, vast, good person who loves writing and wants to share my knowledge and understanding with you.