Question 6 [10 points] On August 1, 2014 Holden Corp. borrowed $996,000 by signing a four-year installment note bearing interest at 7%. 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 PV(n;i) in a value box to calculate the present value of $1 over n compoun Similarly, use PVA(n;i) to calculate the present value of an annuity. E.g., the present value of $1,000 with a periodic rate of 3%, and 1000*PV(2:3). To use the built-in PV functions to calculate the payment, the formula is: Principal balance - PVA(ni), where n = the number of paym if $10,000 is borrowed by signing a four-year, 5% installment note. The note requires four equal payments of accrued interest and pr 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 Interest Expense Reduction of Notes Payable Total Notes Payment Ending Balance July 31, 2015 July 31, 2016 July 31, 2017 July 31, 2018 Total