On September 1, 2014 Global Filter Corp borrowed $924,000 by signing a five year installment note beaning interest at 7% Complete the installment note amortization schedule for this note assuming each payment requires equal total payments Use the bun-in PV functions for these calculations Enter Pvp:1) in a value box to calculate the present value or 51 overn compounding periods with a periodic rate att Smilarly, use PVA(0:1) to calculate the present value of an annuity. Eg the poesent value of $1,000 with a periodic rate of 3% and 2 compounding periods can be entered as 1000-PV12,5) To use the bum-in PV functions to calculate the payment, the formula is Principal tatance - PVA(n.), where the number of payments and i= the interest rate For example, 510,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 equat payments is calculated by entening the following in the value box 10000 PIVA(45), which equats payments of $2,820 Equal Tas Payments Table Penod Enging Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Notes Paymer Ending Bintance August 31, 2015 August 31, 2016 August 31, 2017 August 31, 2015 August 31, 2019 Total