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

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!