On April 1, 2020, Clyde Barrow Company bought a delivery truck for $54,000 on a 8%, five-year installment note. You have been tasked with preparing an amortization table in Excel for the bookkeeper to assist him in recording the monthly payments, with the first payment starting on May 1, 2020. Prepare a monthly amortization table for the loan showing the payment date, payment, principal part of the payment, the interest portion of the payment, and the remaining bylance. At the top of the table, be sure to show the calculation of the monthly payment and, below the table, show the monthly journal entry to record the first payment on May 1at. Everything should be set up so that if the interest rate or the principal of the loan were 7 changed, the rest of the table will update appropriately