Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 3 [10 points) On April 1, 2014 Star inc borrowed 5828.000 by signing a four year installment note beaning interest at 8% Complete the
Question 3 [10 points) On April 1, 2014 Star inc borrowed 5828.000 by signing a four year installment note beaning interest at 8% 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 in:1) in a value box to calculate the present value of St overn compounding periods with a periodic rate of Similarly, PVA(nto calculate the present value of an annuity. Eg the present value of 1,000 with a periodic tate of 3% and 2 compounding periods can be entered as 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 interest rate. For example, $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 payment is calculated by entering the following in the value box 10000 / PVA4.5)which equals payments of 2,820 En Tol Payments Table Period Ending Beginning Balance Periodic interest Expense Reduction of Notel Playa Total Notes Payment Ending Balance March 31, 2015 March 31, 2010 March 31, 2017 March 31. 2018 Total
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started