1. Create a Data Area at the top of the Excel sheet and enter the following information:
   • Borrow Date = 10/31/21
   • Principle = 560,000
   • Annual Interest Rate = 9.00%
   • Years = 5
   • Payment: (Calculate using the PMT function)
     • Calculate the amount of the payment using the PMT function
       • =pmt(annual interest rate,years,-principle)
2. Create a Loan Amortization Table for 5 years
3. Create a general journal that includes journal entries for:
   1. Accrued interest as of December 31, 2021 (the end of its annual reporting period).
   2. The first annual payment on the note.