Please submit vow full Excel spreadsheet with final answers highlighted. Prover formatting's  also expected.

An investment firms offers Its customers a 30-year savings plan in an IRA account 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 annual deposits are a fixed amount during the 30-year period.

• The balance of the account will be paid in full at the end of the 30-year plan.

Question I: If an investor saves $24,000 per year, what is the balance at the end of the 30-year plan?

Question 2: What is the value of the annual fixed deposit needed to secure $2,000,000 30 years finm now?

Question 3: Provide a 12 year mortgage amortization table of a $300,000 loan with an annual percentage rate of 3.875%. Also provide a graph illustration of this amortization table.

Question 4: Kate celebrates her 5 years birthday today. Her parents want to save for 4 years of her college expense, starting at age 18.

In other words, ember birthdays 18, 19, 20, 21, they plan to take out $30,000 to pay for the college tuition.

How much money her parents have to save each year on her birthday of age 5,6,7, ......to 17.

Assume the investment return is 5% per year. Also provide an education saving sinking fund chart.