Retirement planning can be made endlessly complicated with terminology and complicated spreadsheets.
Many physicians get so intimidated by the alphabet soup of retirement planning that they often just throw their hands up and not do any financial planning.
I wanted to make a calculator that breaks down retirement planning into as few variables as possible, while maintaining its essential principles.
The Simple Retirement Planning Spreadsheet
With this spreadsheet, all you have to do is enter your age, current net worth, pre-tax income, post-tax income, annual spending, and expected investment returns.
As other calculators have done, you can adjust your investment returns based on average (4%), below-average (2%), or above-average (6%) market scenarios.
(If you’re reading this on your phone, it’s best to turn your phone horizontally and view the spreadsheet in landscape mode.)
The Big Questions This Spreadsheet Answers
This simple spreadsheet is designed to answer two important questions:
1. I want to have a certain lifestyle and spend $X a year — when will I have enough money to retire?
This is the typical way the retirement question is framed. A physician has a set income and spending lifestyle — this spreadsheet will tell them when they will be financially independent.
2. What kind of lifestyle can I have and still retire by age X?
While most physicians save too little, there are some physicians who probably spend too little and save too much. For them, this spreadsheet will explain how much they can “loosen the pursestrings” and still retire by a certain age.
Adjust the “Annual Spending” cell in the spreadsheet and see your FI age go up as you increase spending and vice versa.
If you’re a resident or medical student and are not sure what kind of lifestyle a certain amount of money will get you, see which one of these four hypothetical physician lifestyles fits how you’d like to spend your money.
Join the WSP Community and Download This Spreadsheet
I hope you like this simple retirement calculator. When I first made the spreadsheet, it changed my perspective on spending and saving for retirement. I hope it will do the same for some of you.
If you want to play with this spreadsheet offline, I can send you an e-mail so you can download it. You’ll also get new post notifications and the WSP newsletter.
What do you think? Do you like the spreadsheet? Have you ever made your own spreadsheets for retirement planning?