Note: A newer version of this spreadsheet has been published with the ability for the user to specify different withdrawal rate for each item. This is to account for the possible difference in criticality, flexibility, and length of time required for each expense items in retirement. This version is still perfect for use if you’d just want a high level view, but I recommend to use the new sheet for a more nuanced, and more accurate, FIRE number.

The path to Financial Independence can feel overwhelming at times. When your goal is years or even decades away, it’s easy to lose motivation along the journey. Trust me, having been on this path for almost 10 years now, I’ve definitely been there.

What I’ve discovered is that breaking this massive goal down into smaller, more manageable pieces makes all the difference. Instead of fixating on one enormous number that feels impossibly far away, I’ve found it incredibly helpful to think about FIRE in terms of the actual expenses I’ll need to cover in retirement.

This approach has several powerful benefits:

First, it forces you to think deeply about what you actually need in retirement. Do you really need that premium streaming service, or would the basic plan be just fine? Is that expensive hobby worth the extra year of work it might require? Breaking down your FIRE number this way helps you make conscious trade-offs between lifestyle and time to retirement.

Second, it creates a detailed retirement budget. Rather than guessing what you’ll spend, you’re building a comprehensive picture of your future expenses. This makes your FIRE planning much more realistic and actionable.

Third, it gives you multiple milestones to celebrate along the way. Instead of one distant finish line, you get to check off individual expense categories as you “unlock” them. Each item you fully fund feels like a genuine achievement.

Finally, it provides visual progress tracking. As someone who loves gaming and visual feedback, I wanted to see my progress in a way that felt engaging and motivating – like leveling up in a game where each expense category is a quest to complete.

That’s exactly what led me to create the spreadsheet I’m sharing today. It transforms your FIRE journey from a single overwhelming target into a series of manageable progress bars, each representing a specific aspect of your retirement lifestyle. You can literally watch yourself “unlock” different levels of financial security, from basic needs to nice-to-haves.

I’ve been using this approach for several years now, and it’s completely changed how I think about my FIRE progress. Instead of feeling discouraged by how far I still have to go, I’m motivated by seeing which expense categories I’ve already covered and which one I’m currently working toward.

I’m excited to share this tool with you and hope it helps you stay motivated on your own journey to financial independence.

Breaking the Spreadsheet Down

First, make a copy of the spreadsheet to your own Google account so that you can modify it to fit your own budget as you follow along.

Section 1: Portfolio, Withdrawal Rate, and FIRE Income

Current Portfolio Value (Cell H1)

This cell should contain the current value of your investment portfolio that you plan to use for FIRE. You can either enter the value manually or link it directly to another spreadsheet where you track your portfolio – if you choose the latter, this spreadsheet will automatically update your progress throughout.

If you need help tracking your portfolio performance, you might find my portfolio tracking spreadsheet template useful as a companion tool.

This value forms the foundation for calculating how much passive income your current portfolio can generate.

Target Withdrawal Rate (Cell H2)

Enter your planned withdrawal rate for retirement. The widely-accepted “rule of thumb” from the Trinity Study suggests 4% for a 30 year retirement, though many in the FIRE community prefer more conservative rates (both due to the longer length of their retirement and as an additional margin of safety.)

In this sheet, I personally use 3.25% to be safer since my planned retirement is longer than 30 years.

Remember: a higher withdrawal rate means higher risk of running out of money, but requires a smaller portfolio to generate your target income. A lower rate is safer but requires a larger portfolio.

Choose the rate that aligns with your risk tolerance and retirement timeline.

Current FIRE Income (Cell H3)

This cell automatically calculates your current monthly passive income potential using the formula: (Portfolio Value × Withdrawal Rate) ÷ 12. You don’t need to edit this – it updates automatically as you change the values above.

Section 2: Retirement Expenses

This is where the magic happens. Rows A4 through K26 contain all the expenses I’m planning for in retirement. Since each row works the same way, I’ll explain each column and how they work together.

Column A: Expenses

This lists all the expenses you expect to have in retirement. The example spreadsheet shows just my half of our family’s budget items.

Feel free to modify these to match your own situation.

Column B: Priority

This is where I rank each expense by importance, with lower numbers representing higher priority. This isn’t about which expenses cost more, but rather which ones I should save for first.

Priorities 0-8: Basic Needs These cover essentials for independent living: housing, food, utilities, transportation, internet, and basic insurance. These are the foundation – everything you need to take care of yourself without relying on others.

Priorities 9-12: Family Responsibilities This covers supporting children and aging parents. After securing my own basic needs, ensuring I can care for my family comes next.

Priorities 13-15: Quality of Life Improvements Items like domestic help and digital services that make life significantly easier, but aren’t strictly necessary.

Priorities 16-19: Nice to Haves Entertainment subscriptions, vacation budgets, and other lifestyle enhancements that make retirement more enjoyable.

Priorities 20-21: May Not Need These are items I might not need in retirement (like disability insurance, which becomes irrelevant when you’re not working).

This priority system helps me focus on what matters most and provides natural stopping points if I decide I’ve saved “enough.”

Column C & D: Amount & Times per Month

Enter the cost per instance and how many times per month you’ll incur that expense. These work together to calculate your total monthly cost.

For example, if you budget $1,000 per child and want 2 children, enter “1000” and “2”. For annual expenses like insurance where you only pay once per year, enter the annual cost and “0.083” (which is 1/12) for times per month.

Column E & F: Total per Month & Amount per Year

These automatically calculate your monthly and annual costs for each item. No editing needed here.

Column G: Amount to FI

This is one of the most powerful columns. It shows exactly how much portfolio value you need to afford each expense item forever, calculated by dividing the annual cost by your withdrawal rate.

This helps put each expense in perspective. Want to budget $1,000/month for travel? That requires roughly $370,000 in additional portfolio value at a 3.25% withdrawal rate. Seeing these numbers helps you make informed decisions about which lifestyle upgrades are worth the extra working years.

Column H & I: Progress % & Progress Chart

Here’s where the visual magic happens. The spreadsheet works like a waterfall – your portfolio value “fills up” expense buckets starting from the highest priority and flowing down to lower priorities.

• 100% means that expense is fully covered by your current portfolio
• 0% means you haven’t reached this expense yet
• Between 0-100% shows your current progress on that specific item

There’s always exactly one item you’re “actively working on” – the one between 0% and 100%. Once an item hits 100%, progress automatically flows to the next priority.

Column I provides a visual progress bar to make this even clearer at a glance.

Remember, your portfolio value will fluctuate with market movements, so don’t be discouraged if your progress bars move backward sometimes. I’ve written about staying calm during market crashes and why staying the course is crucial for long-term success.

Column J: Remaining

Shows how much more you need to save to fully cover each expense. Once fully funded, this changes to “DONE” – which is incredibly satisfying to see!

Column K: Cumulative Remaining

Adds up all the remaining amounts, showing how much total savings you need to afford everything up to that specific item. This helps you set intermediate goals: “I need $50,000 more to cover everything through Priority 15.” Convenient!

Section 3: Last Row – Totals

The bottom row summarizes everything:

• Total per Month (E27): Your complete monthly retirement budget
• Total Amount per Year (F27): Your annual retirement spending
• Total Amount to FI (G27): Your complete FIRE number
• Total Progress % (H27): Your overall FIRE progress
• Total Remaining (J27): How much more you need to save

Different Ways to Stay Motivated

The beauty of this spreadsheet is that you can sort it different ways depending on what motivates you most.

FIRE Lifestyle Priority: Most Critical First (Default)

Sort by Column B (Priority) in ascending order. This covers your most important needs first – the most logical approach, but potentially discouraging early on since housing costs take forever to complete.

RPG Progression: Smallest Items First

Sort by Column G (Amount to FI) in ascending order. This gives you quick wins early on – like a video game where you level up frequently at first, then progress slows as challenges get harder. Great for building momentum when starting out.

Snowball: Biggest Items First

Sort by Column G in descending order. Tackle your most expensive items first, so everything gets easier as you progress. This works well if you prefer getting the hardest work done upfront.

I often switch between these views depending on my mood and motivation level. Early in my journey, I used the RPG approach for quick wins. Now I sometimes use the Snowball method as the future items will get cleared out much faster now.

Conclusion

This spreadsheet has completely transformed how I think about my FIRE journey. Instead of feeling overwhelmed by one massive number, I now have clear visibility into my progress across different aspects of my retirement lifestyle. I can see exactly which expenses I’ve already “unlocked” and which one I’m currently working toward.

More importantly, it’s helped me make much more intentional decisions about my retirement lifestyle. When I see that adding a $200/month expense requires an additional $74,000 in portfolio value, I can make an informed choice about whether that’s worth extending my working years.

The visual progress tracking keeps me motivated in a way that a simple percentage toward my total FIRE number never could. There’s something deeply satisfying about watching those progress bars fill up and seeing items change to “DONE.”

I’m sharing this with the FIRE community because I believe tools like this can help all of us stay motivated and make better decisions on our journey to financial independence. Personal finance is deeply personal, so please adapt this spreadsheet to match your own goals and circumstances.

I’d love to hear your thoughts and feedback! How do you track your FIRE progress? What modifications would make this more useful for your situation? Have you found other creative ways to stay motivated during the long journey to FI?

If you find this helpful, please feel free to share it with friends, family, or anyone else who might benefit from a fresh perspective on FIRE planning. The more people we can help achieve financial independence, the better.

Until next time, keep making progress – one expense category at a time!
FPL