ON EXCEL!!

excel

art B: Build an Excel model to solve each of the following two problems. Save each model in a separate orksheet. 1. A bank offers its customers a 30 -year savings plan with the following terms: - 7% interest for the first five years. 9% interest for the next 15 years, and 6% interest for the final ten years. - The deposits in the plan are annual with the first deposit scheduled a year from today. - The balance of the account will be paid in full at the end of the 30 -year plan. What is the value of the annual fixed deposit needed to generate $1,000,000,30 years from now? 1. A bank offers its customers a 30 -year savings plan with the following terms: - 7% interest for the first five years. 9% interest for the next 15 years, and 6% interest for the final ten years. - The deposits in the plan are annual with the first deposit scheduled a year from today. - The balance of the account will be paid in full at the end of the 30y ear plan. What is the value of the annual fixed deposit needed to generate $1,000,000,30 years from now