In: Finance
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at the end of each of the next 4 years so that the ending balance at the end of year 4 is 0. The interest rate on the loan is 10 percent. The principal repayment in year 3 is:
| Step-1:Calculation of annual payment | |||||
| Annual payment | = | Loan amount | / | Present value of annuity of 1 | |
| = | $ 5,000 | / | 3.1698654 | ||
| = | $ 1,577.35 | ||||
| Working: | |||||
| Present value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | ||
| = | (1-(1+0.10)^-4)/0.10 | i | 10% | ||
| = | 3.1698654 | n | 4 | ||
| Step-2:Calculation of loan amortization schedule | |||||
| Year | Beginning balance | Interest Expense | Annual payment | Reduction in principal | Ending Balance |
| a | b=a*10% | c | d=c-b | e=a-d | |
| 1 | $ 5,000.00 | $ 500.00 | $ 1,577.35 | $ 1,077.35 | $ 3,922.65 |
| 2 | $ 3,922.65 | $ 392.26 | $ 1,577.35 | $ 1,185.09 | $ 2,737.56 |
| 3 | $ 2,737.56 | $ 273.76 | $ 1,577.35 | $ 1,303.60 | $ 1,433.96 |
| 4 | $ 1,433.96 | $ 143.40 | $ 1,577.35 | $ 1,433.96 | $ 0.00 |
| The principal repayment in year 3 is $ 1,303.60 | |||||