UnThreaded | Threaded | Whole Thread (11) | Ignore Thread Prev | Next
Author: jpkiljan One star, 50 posts Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 757892  
Subject: Re: excel spreadsheet Date: 2/24/2000 3:30 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
Hi Kim,
I seem to do a spreadsheet like this everytime I have a decision that compares one investment path to another. The way I do it is to start with present day dollars and factor the growth of my investments into each cell for future years. That way I am always working with 2006 dollars in 2006 and 2015 dollars in 2015. As for inflation, I have been increasing my drawdown column needs by whatever I think inflation will be, but usually I don't even calculate it at all when I am just comparing investment alternatives. If were to get into this, I'd consider that my living expenses will be dropping as I approach 80 with less physical activities and I might need more during my early years of retirement. I do indeed figure current rates of taxes, and, to be conservative, I figure the current breaks on marginal rates will remain unchanged.

A simple way to figure future living expenses is to take whatever your expenses are now and adjust for the great retirement events (lower commuting costs, higher medical insurance, SS and Medicare finally kicking in, etc.) and then simply expand them by somewhere from 3% to 4% per year. Real life may hand us deflation or runaway inflation over the next 30 years, but you have to start somewhere. The other wild card is heavy uninsurable medical expenses for experimental medicin or prolonged nursing home care.

Good luck,

-- John
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (11) | Ignore Thread Prev | Next

Announcements

Foolanthropy 2014!
By working with young, first-time moms, Nurse-Family Partnership is able to truly change lives – for generations to come.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Post of the Day:
Macro Economics

Looking at Currency Ratios
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement