815 1 2 3 4 5 F GRESEL 10 11 12 A 6 Required 7 Prepare an amortization schedule for the interest and principal payments for the five-year period. Note: Use cell references from the given Information above to complete this question. 14 B Year 15 Year 1 16 Year 2 17 Year 3 18 Year 4 19 Year 5 20 D 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. E Principal Balance on January 1 BEATIE COMPANY Amortization Schedule $200,000, 5-Year Term Note, 6% Interest Rate Cash Payments December 31 Applied to Interest Applied to Principal G Principal Balance End of Period H $200,000 $47,479 6% 5

please help me with understabd the excel formula

On January 1, Vear 1, Beatie Company borrowed $200,000 cash from Central Bank by issuing a five-vear, 6 percent note. The prinopst and hiterest are to be paid by muting annus payments in the amount of 547,479 . Payments are to be made. December 31 of eachyear beeinhing December 31, year 1