Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Spreadsheet for calculating life of retirement assets
Old 03-11-2007, 10:34 PM   #1
Dryer sheet wannabe
Join Date: Jan 2006
Posts: 10
Spreadsheet for calculating life of retirement assets

All, I have developed a excel spreadsheet that I hope others will find useful. It takes the following variables:

yearly expenses 46000 (amount spent, the spreadsheet adjusts for taxes)
starting amount 600000 (total of IRAs and Savings)
interest rate 0.05 (user determined, I'm conservative)
SS monthly 1677 (Social Security in today's dollars)
inflation rate 0.035 (Projected inflation rate, i.e. my guess)
Age 49

The spreadsheet calculates how long before your initial assets will run out. The variables are robust i.e. can change the yearly expenses, starting amounts, or what you think would be appropriate for inflation and rate of interest you project you will earn. Also, the spreadsheet has included space for a reverse mortgage when you reach age 62.

the first two lines look like this: Social yearly
Starting Interest Projected Social Sec Adj Expenses
Age Amt Earned Expenses Pension Security for inflation Adj for inf
49 600,000.00 30,000.00 46,000.00 0.00 0.00 20,124.00 46,000.00
50 689,000.00 34,450.00 47,610.00 0.00 0.00 20,828.34 47,610.00

Hope some find this useful,


tlg501 is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Re: Spreadsheet for calculating life of retirement assets
Old 03-12-2007, 11:56 AM   #2
Full time employment: Posting here.
Join Date: Sep 2006
Posts: 608
Re: Spreadsheet for calculating life of retirement assets

Originally Posted by tlg501
Hope some find this useful,
Thanks Terry, something like this is somewhat useful, but in a limited way, because
it can produce overly-optimistic results.

The reason (if I am not mistaken) is that you assume inflation and ROR are constants.
In real life, they vary dramatically from year-to-year. Most siginificantly of all, the
premium of ROR over inflation varies dramatically and will sometimes go negative.
These periods can really hurt one's portfolio and it's critical to design your strategy
to survive them without damaging your portfolio too badly. A spreadsheet such as
your's provides little insight in this regard. That's why historically-based (like
FIRECalc) and Monte-Carlo calculators are so popular and useful.


JohnEyles is offline   Reply With Quote
Re: Spreadsheet for calculating life of retirement assets
Old 03-12-2007, 12:09 PM   #3
Thinks s/he gets paid by the post
MasterBlaster's Avatar
Join Date: Jun 2005
Posts: 4,360
Re: Spreadsheet for calculating life of retirement assets

For something similar that is very well accepted check out the "Optimal Retirement Calculator" - which goes by the name ORP...
MasterBlaster is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question for someone smarter than I mickeyd FIRE and Money 10 07-18-2006 10:08 PM
Predictors of a Happy Retirement Rich_by_the_Bay Life after FIRE 24 07-13-2006 08:59 PM
Diversifying My Retirement Funds and Confused Rob Other topics 1 10-31-2005 09:59 AM
SWR should not be constant over a Retirement Life Cut-Throat FIRE and Money 51 03-15-2004 06:01 AM
Retire early, live longer dory36 Other topics 6 02-27-2004 08:36 AM


All times are GMT -6. The time now is 10:16 AM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.