On January 1, Year 1, Beatie Company borrowed $200,000 cash from Central Bank by issuing 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. 5 6 Required 7 Prepare an amortization schedule for the interest and principal payments for the five-year period. 8 9 10 11 12 13 14 Note: Use cell references from the given information above to complete this question. Year 15 Year 1 16 Year 2 17 Year 3 18 Year 4 19 Year 5 20 21 BEATIE COMPANY Amortization Schedule $200,000, 5-Year Term Note, 6% Interest Rate Cash Principal Balance Payments on January 1 December 31 Applied to Interest Applied to Principal Principal Balance End of Period LEALT 064 1 $47,479 +

3. The principal and icterest are to be paid by making annual payments in the amount of $47,479. Payments are to be made $47,47 Deccumber 31 of esch vest, bemaning December 31 , Yes 1 Required Prepare an amortization schedule for the interest and princioal payments for the five-vear period Note. Use cell references from the gven information above to complete this