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
