please answer in 20 minutes

Question 4 [10 points) On March 1, 2014 Holden Corp. borrowed $972.000 by signing a four-year installment note bearing interest at 8% Complete the installment note amortization schedule for this note assuming each payment requires equal total payments Use the built-in PV functions for these calculations, Enter Pin:1) in a value box to calculate the present value of $1 overn compounding periods with a periodic rate of Simarly, use PVA(n;/) to calculate the present value of an annully Eg the present value of 1,000 with a periodic rate of 3%, and 2 compounding periods can be entered as 1000+PV(2,3) To use the built-in PV functions to calculate the payment, the formula is Principal balance - PVA), where the number of payments and the interest rate. For example, $10.000 is borrowed by signing a four-year 5% installment note. The note requires four equal payments of accrued interest and principal. Each of the four equal payments is calculated by entering the following in the value box: 10000 / PVA 4:5), which equals payments of $2,820 Equal Total Payments Table Period Ending Beginning Balance Periodic Inforest Expense Reduction of Notes Payable Total Notes Payment Ending Elance February 28, 2015 February 29, 2010 February 28, 2017 February 28, 2018 Total