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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started