PLEASE ANSWER ON EXCEL

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