Question: Question 6 [10 points) On May 1 2014 Vision Consulting Inc borrowed 51 008,000 by signing a four-year installment note bearing interest at 8% Complete

 Question 6 [10 points) On May 1 2014 Vision Consulting Inc

Question 6 [10 points) On May 1 2014 Vision Consulting Inc borrowed 51 008,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 tunctions for these calculations Enter PV(n:) in a value box to calculate the present value of $1 over compounding periods with a periodic rate of Saritarty, use PVA(n:1) to calculate the present value of an annuity Eg the present value of $1.000 with a periodic rate of 3 and 2 compounding periods can be entered as 1000-PV2,3) To use the built in PV functions to calculate the payment, the formulas Principal balance - PW) whoren the number of payments and is the interest rate For example, $10,000 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 payment is calculated by entering the following in the value box 10000 / PVA(45), which equals payments of $2 820 Equal Total Payments Period Endino Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Notes Payment Endng Balance Ann 30, 2015 April 30, 2016 April 30, 2017 April 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!