Exercise $10-2$A $($Static$)$ Amortization schedule for an installment note LO $10-1$

On January $1,$ Year $1,$ Beatie Company 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.

$*$ some of the answers are filled in and are correct. I was able to figure those out on my own, just need help to finish it$.$ Thank you in advance :$)$