Need to work in excel, using excel functions (such as sum, etc).

Exercise 10-2A Amortization schedule for an installment note On January 1, Year 1, Beatie Co. borrowed $200,000 cash from Central Bank by issuing a five-year, 6 percent note. The principal and interest are to be paid by making annual payments in the amount of $47,479. Payments are to be made December 31 of each year, beginning December 31, Year 1. Required Prepare an amortization schedule for the interest and principal payments for the five-year period