Question: I am specifically trying to do this problem in excel, but have gotten a few different answers. Any tips would be appreciated! You will get

I am specifically trying to do this problem in excel, but have gotten a few different answers. Any tips would be appreciated!

You will get some practice calculating FV and FVA's that we learned about in this chapter for this DB, while also hopefully showing you something that could help you in your personal life!. Here try using the future value tables to show yourself the difference that waiting 10 years to start saving for retirement can make. Assume you are 27 and start saving $3,000/year. You do this for 10 years before circumstances prevent you from saving any more, but the money that has amassed will continue to sit and earn 2%, like it has from when you first started saving, until you retire at age 67 (another 30 years). So you will first use the FVA (Future Value of an Annuity) of $1 chart for $3,000 at 2% for 10 years; then use that resulting number in a FV of $1 chart for 30 years (periods) at 2% to see how much you would have at retirement. Next, assume you wait until age 37 to start saving, but no circumstances cause you to stop (A very rare occurrence in real life! Unexpected things almost always will happen to derail your best saving intentions!). SO for this one, you will use just the FVA chart, still using $3,000 and 2%. Show your work and results, as well as comments.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!