Suppose your business borrow $15,000 from the bank in order to buy a new car by signing a promissory note payable. The bank charges 6% APR, compounded monthly. You will make equal monthly payments at the end of each month for two years. 1. Complete an amortization schedule in Excel for all 24 months that shows the table headers and columns below. 2. Prepare the journal entry for the first payment (Mo. #1).