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

10 minutes left please
10 minutes left please Question 3 [10 points) On October 1, 2014

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!