Question: How would you answer this using Excel? Please show step by step and formulas. Bill and Bob are both 35 years old today. Each wants
How would you answer this using Excel? Please show step by step and formulas.
Bill and Bob are both 35 years old today. Each wants to begin saving for his retirement. Both plan on contributing a fixed amount each year into brokerage accounts that have annual returns of 10%. Both plan on retiring at age 60, 25 years from today, and both want to have $2 million saved by age 60. The only difference is that Bill wants to begin saving today, whereas Bob wants to begin saving one year from today. In other words, Bill plans to make 26 total contributions (t = 0, 1, 2, ... 25), while Bob plans to make 25 total contributions (t = 1, 2, ... 25). How much more than Bill will Bob need to save each year in order to accumulate the same amount as Bill does by age 60?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
