How to Use the 60% Solution Budget Rule in Excel

Set aside 60% of your after-tax income for committed expenses, then split the rest into four equal slices for retirement, long-term savings, short-term savings, and fun money — a balanced plan that keeps saving on autopilot, calculated automatically by a free Excel template.

The60% solution budgetis a method from Elizabeth Warren’s bookAll Your Worththat sets aside60% of your after-tax income for committed expenses, then splits the remaining 40% evenly into four 10% slices: retirement, long-term savings, short-term savings, and fun money. Using an Excel60% solution budget plannermakes it practical by calculating each target automatically and tracking how your actual spending lines up with the plan.

What makes this method different is that it puts all your fixed bills first — housing, groceries, insurance, minimum debt — and then gives every other financial goal a fair, equal share of what’s left. It’s a straightforward way to make sure saving never gets skipped.

In this guide, you’ll learn how the 60% solution works, what goes into each of the five slices, and how to set it all up in Excel with a budget planner.

Quick Answer: What Is the 60% Solution Budget Rule?

The60% solutiondivides after-tax income into five parts:

60% — Committed Expenses:Every payment you’ve already committed to, including housing, utilities, groceries, transportation, insurance, and minimum debt payments.
10% — Retirement Savings:Contributions to retirement accounts.
10% — Long-Term Savings:Savings for major goals such as a home, travel, or education.
10% — Short-Term Savings:Emergency fund and near-term goals.
10% — Fun Money:Discretionary spending reserved for enjoyment.

For example, with$5,000of monthly after-tax income:

Slice	Percentage	Amount
Committed Expenses	60%	$3,000
Retirement Savings	10%	$500
Long-Term Savings	10%	$500
Short-Term Savings	10%	$500
Fun Money	10%	$500
Total	100%	$5,000

The percentages are a flexible guideline, not a strict requirement. Your split can shift based on debt, income, and life stage.

1. What Is the 60% Solution Budget Rule?

The 60% solution was introduced by Elizabeth Warren and her daughter Amelia Warren Tyagi inAll Your Worth: The Ultimate Lifetime Money Plan(2005). It was designed as a middle ground between overly simple budgets and detailed line-by-line plans.

The core idea: cover your “committed” costs first, then divide what remains equally among saving and spending goals.

60% for Committed Expenses

This is everything you’ve already promised to pay. It includes both necessities and fixed bills:

Rent or mortgage
Utilities and internet
Groceries
Transportation
Insurance premiums
Minimum debt payments
Healthcare basics
Childcare

The word “committed” is important. These are payments you can’t easily avoid month to month, regardless of how you feel about them.

10% for Retirement Savings

The first slice of the remaining 40% goes to your future. This can include 401(k) contributions, Roth IRAs, IRAs, or other retirement accounts.

Because retirement is easy to postpone, giving it a fixed 10% slice makes it a standing line item rather than an afterthought.

10% for Long-Term Savings

This slice is for goals that take years, such as:

A house down payment
A child’s education
A major trip
Starting a business

Long-term savings are typically slow and steady, which is why the method reserves a dedicated slice for them.

10% for Short-Term Savings

This covers nearer-term needs and the unexpected:

Emergency fund
A car repair fund
Holiday or gift spending
Annual insurance payments

Building a 3–6 month emergency fund usually lives here.

10% for Fun Money

The last slice is for enjoyment — dining out, hobbies, entertainment, shopping, and anything that makes the budget feel livable. Giving fun money its own equal slice helps a strict budget stay sustainable.

2. How the 60% Solution Works in Real Life

The calculation is straightforward.

Start with your monthly after-tax income. Calculate:

Committed Expenses = Income × 60%

Each remaining slice = Income × 10%

For example, with$4,000of monthly income:

Committed: $2,400
Retirement: $400
Long-term savings: $400
Short-term savings: $400
Fun: $400

An Excel60% solution budget plannercan calculate these five targets automatically.

In practice, your spending may not match the targets. If committed expenses come to $2,700 instead of $2,400, that’s 67.5% — above target. The gap tells you to either trim a fixed bill, reduce one of the 10% slices temporarily, or accept and adjust next month.

3. Why Use Excel for a 60% Solution Budget?

A calculator can give you the five target numbers. Excel can manage the whole plan.

With a60% solution Excel template, you can combine:

Monthly income
Five target amounts
Actual committed spending
Savings and retirement contributions
Fun money usage
Remaining budget per slice
Monthly comparisons

For example:

Slice	Target	Actual	Difference
Committed	$2,400	$2,700	-$300
Retirement	$400	$350	+$50
Long-Term	$400	$450	+$50
Short-Term	$400	$400	$0
Fun	$400	$500	-$100

This view shows at a glance which slice ran over and which stayed on track — far more useful than only knowing your total spending.

4. What to Include in a 60% Solution Budget Planner

A useful60% solution budget plannerhelps you compare target allocation with actual spending across all five slices.

Monthly Income

Start with monthly after-tax income. If income varies, update the amount each month rather than relying on an annual average.

Committed Expenses

Break the 60% into practical subcategories so you can see where the money goes:

Housing
Utilities
Groceries
Transportation
Insurance
Healthcare
Minimum debt payments

Retirement, Long-Term, and Short-Term Savings

Track contributions to each savings slice separately so none gets silently absorbed into another.

Fun Money

Record discretionary spending so you can see whether it stays within its own 10% slice rather than borrowing from savings.

Budget vs. Actual

The most useful part of the planner. Compare planned and actual amounts each month:

Budget:$2,400

Actual:$2,700

Difference:-$300

A negative difference means overspending in that slice. A positive value means you stayed under target.

5. How to Create a 60% Solution Budget in Excel

You can build a simple planner with a few columns and formulas.

Step 1: Enter Your Monthly Income

Create an income field at the top of the spreadsheet.

Monthly After-Tax Income: $5,000

Step 2: Calculate Your Five Targets

Use formulas:

Committed:=Income*60%
Retirement:=Income*10%
Long-Term:=Income*10%
Short-Term:=Income*10%
Fun:=Income*10%

If income is in cell B2, the formulas become=B2*60%,=B2*10%,=B2*10%,=B2*10%,=B2*10%. Excel automatically recalculates when you change income.

Step 3: Log Your Actual Spending by Slice

Group each expense into one of the five slices. For example:

Item	Slice	Budget	Actual
Rent	Committed	$1,500	$1,500
Groceries	Committed	$500	$540
401(k)	Retirement	$500	$500
Emergency fund	Short-term	$500	$500
Hobbies	Fun	$500	$550

Step 4: Compare Budget and Actual Spending

Calculate the difference per slice withDifference = Budget − Actual. Positive means under target; negative means over.

Step 5: Review the Month

At month-end, ask:

Did committed expenses stay near 60%?
Did I put the full 10% into retirement and both savings slices?
Did fun money stay within its own slice?
Where did spending run over, and what should change next month?

This turns your spreadsheet into an ongoing system instead of a one-time plan.

6. How to Adjust the 60% Solution for Your Situation

The 60% solution is a guide, not a rule set in stone. Different situations call for different splits.

When Committed Expenses Exceed 60%

In high-cost areas, housing alone can push committed costs above 60%. If fixed bills take 70% or more, you may need to temporarily reduce one or more savings slices until costs come down or income rises.

When You Have High-Interest Debt

Critics note that the 60% solution doesn’t include a dedicated debt-payoff plan. If you carry high-interest debt, consider directing part of the long-term or fun slices toward extra payments.

When You Want a Simpler Three-Bucket Plan

If five slices feel like too much, the50/30/20 Budget Planneror70/20/10 Budget Plannergives you three categories instead. Choose the framework you’ll actually maintain.

7. Common 60% Solution Budgeting Mistakes

Lumping Needs and Wants Together Without Discipline

Because the 60% committed slice combines essentials and some nonessentials, it’s easy to overspend on wants before covering essentials. Prioritize true necessities first within that slice.

Not Giving Debt Its Own Plan

The method has no built-in debt-payoff strategy. If you carry debt, assign part of a savings slice or fun money to extra payments, or you risk carrying it indefinitely.

Treating the Four 10% Slices as Optional

If short-term savings keeps getting borrowed from fun money, the emergency fund never grows. Treat each 10% slice as a real category with its own balance.

Ignoring Actual Spending

A budget is a plan. Actual spending tells you if it’s working. Review it monthly instead of setting it once and forgetting it.

Overcomplicating the Spreadsheet

You don’t need dozens of categories to start. A simple planner you update consistently beats a complex spreadsheet you abandon after two weeks.

8. Use a Ready-Made 60% Solution Budget Planner

Building a budgeting spreadsheet from scratch takes time, especially with five target slices and automatic calculations.

A ready-made60% solution budget plannerprovides a starting structure with:

Monthly income
60% committed-expense target
Four 10% target slices
Expense subcategories
Budget vs. actual spending
Remaining amounts
Monthly summary

You can customize categories and percentages to fit your situation. The goal isn’t a perfect spreadsheet — it’s making your financial decisions easier to see and understand.

If you’d rather track every transaction in detail before assigning it to a slice, pair your budget with anExpense Tracker Template.

Frequently Asked Questions

What is the 60% solution budget rule?

The 60% solution is a budgeting method from Elizabeth Warren’s bookAll Your Worth. It sets aside 60% of after-tax income for committed expenses, then splits the remaining 40% equally into four slices: retirement, long-term savings, short-term savings, and fun money.

How do I calculate a 60% solution budget?

Multiply your monthly after-tax income by 60% for committed expenses, then by 10% for each of the four remaining slices. With $5,000, that’s $3,000 committed and $500 for each of the four 10% slices.

What counts as committed expenses in the 60% solution?

Committed expenses are payments you’ve already agreed to make: rent or mortgage, utilities, groceries, transportation, insurance, minimum debt payments, and essential healthcare.

How is the 60% solution different from 50/30/20?

The 50/30/20 rule uses three categories (needs 50%, wants 30%, savings 20%). The 60% solution groups all committed bills under one 60% slice and then gives retirement, long-term savings, short-term savings, and fun money an equal 10% each.

Is the 60% solution good for paying off debt?

It can help by ensuring minimum debt payments are inside committed expenses, but it has no dedicated debt-payoff slice. If you carry high-interest debt, direct part of a savings or fun slice toward extra payments.

Conclusion: Make the 60% Solution Work for You

The60% solution budgettakes a simple idea — cover your committed bills first, then give every other goal an equal share — and turns it into a manageable monthly plan. With Excel, you can calculate all five targets automatically, track real spending, and adjust from month to month.

The goal isn’t to hit exactly 60% and four 10%s every month. The goal is to understandwhere your money goes and whether your spending supports your financial priorities.

If you want to get started quickly, use a60% Solution Budget Plannerto organize income, categorize expenses, compare budget vs. actual spending, and build a simple monthly budgeting system. You can also browse the full range of templates and guides atUse Office Toolkit.

Download the free 60% Solution Budget Planner and start organizing your monthly budget today.