Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On October 1, 2014 Allaroo Inc. borrowed $876.000 by signing a five-year installment note bearing interest at 7% Complete the installment note amortization schedule for
On October 1, 2014 Allaroo Inc. borrowed $876.000 by signing a five-year installment note bearing interest at 7% 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 $1 over n compounding periods with a periodic rate of I. Similarly, use PVA(n;) to calculate the present value of an annuity. E.g., the present value of $1,000 with a periodic rate 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 formula is: Principal balance + PVA(n:i), where n = the number payments and i = the interest rate. For example, if $10,000 is borrowed 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(4;5), which equals payments of $2.820. Equal Total Payments Table Period Ending Beginning BalanPeriodic Interest ExpeRestuction of Notes Pavlotal Notes Pavm: Endina Balance September 30, 20 September 30, 20 September 30, 20 September 30, 20 September 20.20 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