An investor has determined that they need to accumulate $1,500,000 for retirement in 35 years. How much should this investor set aside each year in order to meet this goal if they expect an average return of 9%? How much must this investor set aside each year if they only have 25 years to accumulate theirdesired $1,500,000? What if the investor waits until there are only 15 years toaccumulate the $1,500,000?

Must answer with an excel spreadsheet

thank you much!