In: Finance
Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent.
Beginning | Repayment | Remaining | |||
Year | Balance | Payment | Interest | of Principal | Balance |
1 | $ | $ | $ | $ | $ |
2 | |||||
3 |
What percentage of the payment represents interest and what percentage represents principal for each of the 3 years? Do not round intermediate calculations. Round your answers to two decimal places.
% Interest | % Principal | |
Year 1: | % | % |
Year 2: | % | % |
Year 3: | % | % |
Why do these percentages change over time?
a
PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)] |
C = Cash flow per period |
i = interest rate |
n = number of payments |
15000= Cash Flow*((1-(1+ 9/100)^-3)/(9/100)) |
Cash Flow = 5925.82 |
Annual rate(M)= | yearly rate/1= | 9.00% | Annual payment= | 5925.82 | |
Year | Beginning balance (A) | Annual payment | Interest = M*A | Principal paid | Ending balance |
1 | 15000.00 | 5925.82 | 1350.00 | 4575.82 | 10424.18 |
2 | 10424.18 | 5925.82 | 938.18 | 4987.65 | 5436.53 |
3 | 5436.53 | 5925.82 | 489.29 | 5436.53 | 0.00 |
Where |
Interest paid = Beginning balance * Annual interest rate |
Principal = Annual payment – interest paid |
Ending balance = beginning balance – principal paid |
Beginning balance = previous Year ending balance |
b
Interest % | Principal % |
22.78% | 77.22% |
15.83% | 84.17% |
8.26% | 91.74% |
c