FINANCIAL INDEPENDENCE,
RETIRE EARLY (FIRE) ESTIMATOR
For anyone new to Excel, go to File › New › Welcome to Excel. This template will help you learn foundational concepts of Excel.
In the "Learn more" sheet, you can play with Excel features or choose a related template - including a standard retirement
estimator - to make more spreadsheets.
This simple pre-retirement calculator can assist you with goal setting and lifestyle adjustments to support your early retirement
dream. Like any simple tool, it can't replace professional financial advice customized to your personal situation, so use as a tool in
your toolbox. There is no guaranteed outcome as market events can impact your results, and there is risk associated with any
investment. Please note this estimator is for US residents.
To get started, read the instructions for each worksheet below, then, go to the "Inputs" tab to enter your values.
"Monthly expenses input" worksheet instructions
1. Fill in your monthly expenses for each category like housing, food, transportation, etc.
2. To add more rows, select the row immediately below > right click > select Insert row.
Example: to add a row above "Water and sewer" in "Housing" table, select row 10> right click > insert row. This creates a blank
row between "Gas" and "Water and "Sewer."
_x000D_ Classified as Microsoft Confidential
#
"Portfolio asset mix input" worksheet instructions
1. Fill in the portfolio asset mix table for your investment portfolio.
Example: if you have investments of $100k, of which $10k cash, $50k stocks, and $40k bonds, you can fill in 10% cash, 50% stoc
40% bond.
2. To add more rows, select the row immediately below it > right click > insert row.
Example: to add a row above "Stocks" in "Portfolio Asset Mix" table, select row 9 (Stocks) > right click > insert row. This creates a
blank row between "Cash" and "Stocks".
_x000D_ Classified as Microsoft Confidential
#
concepts of Excel.
ard retirement
ur early retirement
on, so use as a tool in
sociated with any
ues.
This creates a blank
_x000D_ Classified as Microsoft Confidential
#
10% cash, 50% stock,
rt row. This creates a
_x000D_ Classified as Microsoft Confidential
#
INPUTS
CURRENT AMOUNT AT RETIREMENT
Current age 30 Target retirement age
Household annual income from work $2,000,000 Withdrawal rate in retirement
Household annual expenses, including taxes $800,000 Retirement expenses ratio
Household annual savings $800,000
Other income in retirement
Annual savings growth rate 10.0%
Current investment portfolio $300,000 Cash from downsizing my home
Overall portfolio growth rate 12.0% Increased annual medical expenses
Sensitivity: portfolio grows higher/lower than
2%
expected
RESULTS
_x000D_ Classified as Microsoft Confidential
#
You can retire ahead of target by this
Estimated retirement age 38 many years.
Well done and stay the course!
AT RETIREMENT AMOUNT AT RETIREMENT
Annual household expenses your portfolio will
Target portfolio value needed to hit your goal $16,000,000
support
Additional portfolio value needed to hit your Difference between target & minimum
$15,700,000
goal retirement ages (years)
ESTIMATED PORTFOLIO - NOW UNTIL RETIREMENT
$20,000,000
$18,000,000
$16,000,000
$14,000,000
$12,000,000
$10,000,000
$8,000,000
$6,000,000
$4,000,000
$2,000,000
$-
30 31 32 33 34 35 36 37 38
_x000D_ Classified as Microsoft Confidential
#
$4,000,000
$2,000,000
$-
30 31 32 33 34 35 36 37 38
_x000D_ Classified as Microsoft Confidential
#
AMOUNT
60
5.0%
100%
OPTIONAL INPUTS
$0
$0
$0
_x000D_ Classified as Microsoft Confidential
#
22 years
AMOUNT
$800,000
22
ENT
37 38
_x000D_ Classified as Microsoft Confidential
#
37 38
_x000D_ Classified as Microsoft Confidential
#
FILL IN MONTHLY EXPENSES
MONTHLY EXPENSES $120,500.00
Housing Cost
Mortgage or rent $15,000.00
Phone $2,000.00
Electricity $3,000.00
Gas $1,000.00
Water and sewer $200.00
Cable $800.00
Waste removal $0.00
Maintenance or repairs $500.00
Supplies $0.00
House insurance $1,000.00
Other $0.00
Housing Subtotal $23,500.00
Food Cost
Groceries $3,000.00
Dining out $3,000.00
_x000D_ Classified as Microsoft Confidential
#
Other $0.00
Food Subtotal $6,000.00
Public transportation/rideshare Cost
Vehicle payment $500.00
Bus/taxi fare $500.00
Insurance $500.00
Licensing $0.00
Fuel $12,000.00
Maintenance $1,500.00
Other $0.00
Transportation Subtotal $15,000.00
Loans Cost
Personal $30,000.00
Student $0.00
Credit card $10,000.00
Credit card $0.00
Credit card $0.00
Other $0.00
Loan Subtotal $40,000.00
Taxes Cost
_x000D_ Classified as Microsoft Confidential
#
Federal $10,000.00
State $0.00
Local $0.00
Other $0.00
Taxes Subtotal $10,000.00
Miscellaneous Cost
Kids' school fees $25,000.00
Kids' college 529 expenses $0.00
Legal or attorney fees $0.00
Alimony $0.00
Child support $0.00
Charitable gifts $0.00
Entertainment (e.g., movies, concerts) $500.00
Personal care (e.g., spa) $0.00
Gym and fitness fees $500.00
Pet food and pet care costs $0.00
Other $0.00
Miscellaneous subtotal $26,000.00
_x000D_ Classified as Microsoft Confidential
#
FILL IN YOUR PORTFOLIO ASSET
Cumulative adjusted
growth rate, adjusted 14.3%
for inflation
Portfolio asset mix Percentages
Cash 10%
Stocks 65%
Bonds 35%
Total asset mix 110%
Assumptions CAGR real returns
Cash 3.00%
Stocks 14%
Bonds 14%
_x000D_ Classified as Microsoft Confidential
#
R PORTFOLIO ASSET
Note: Excel calculates an overall annual
growth rate based on your portfolio
asset mix and assumptions behind their
growth.
Notes
Notes
_x000D_ Classified as Microsoft Confidential
#
LEARN HOW TO
1. Create tables to organize data.
2. Create charts to visualize trends.
3. Highlight data based on conditions (conditional formatting)
To begin, we will unhide a few worksheets: right click on the "Learn More" sheet tab › Unhide. Se
"Learn Tables", "Learn Charts", and "Learn Conditional Formatting" then click "OK".
_x000D_ Classified as Microsoft Confidential
#
sheet tab › Unhide. Select
ck "OK".
_x000D_ Classified as Microsoft Confidential
#
