Question: 10 minutes left please Question 3 [10 points) On October 1, 2014 Northstar Corp borrowed $780,000 by signing a four-year installment note bearing interest Complete
Question 3 [10 points) On October 1, 2014 Northstar Corp borrowed $780,000 by signing a four-year installment note bearing interest 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;) in a value box to calculate the present value of 51 overn compounding periods with a peradicate of Similarly, use PVA(n;)) to calculate the present value of an annuity Eg the present value of $1,000 with a periodic rate of 3% and 2 compounding penods can be entered 1000-PV(2:3) To use the built-in PV functions to calculate the payment, the formulas: Principal balance - PVA), where the number of payments and the nterest rate. For example if $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(45), which equals payments of $2.820 Equal Total Payments Table Penod Ending Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Noten Payment Ending Balance September 30, 2015 September 30, 2016 September 30, 2017 September 30, 2018 Total
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
