Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. a) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. b) Alternatively, how much would she have to invest in equal monthly amounts starting at the end of the current year or month respectively.
Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. a) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. b) Alternatively, how much would she have to invest in equal monthly amounts starting at the end of the current year or month respectively. c) Looking at these numbers, most people would think this is affordable. Why do you think most Americans are not saving for their retirement? Discuss what you believe to be the real reason most 23 year olds (like Bella) are not saving for retirement. What do you think we can do to change this trend?
Provide your work in Excel.
How would I write the formulas in excel?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
