It is fairly easy to create a model for this kind of investment calculation in a spread sheet (like Excell or QuattroPro).I'd start with year number in the first column, calculate the return from previous years balance at the interest rate in col 2, put salary in next column calculated from previous years salary at raise rate shown, and then this years 5% contribution, and % employers match. Add up all of this years increases in a subtotal column if you like and then add them to last years balance at end of year to get the end of year value.I would use the copy feature and a year no=last year no +1 and copy down for 30 rows to calculate year numbers.Then once formulas are set up right in the first row, copy them down for all 30 rows to get your final number.This essentially gives you a financial model of what the account should be worth (and what your salary should be) for the next 30 years. I did this back in 1983, and was surprised at how closely the real numbers tracked the calculation. It is fun to see if you are ahead of the curve or falling behind.
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra