In: Finance
Loan amount = | 5000 |
Interest rate annual is 9% compounded monthly.So monthly rate = 9%/12= | 0.0075 |
Semiannual rate = ( (1+monthly rate)^no. of months in semiannual year) -1 |
|
((1+0.0075)^6)-1= | 0.0458522351 |
Total semiannual periods = | 5 |
Equal annual payments for loan formula = P* i *((1+i)^n)/((1+i)^n-1) |
|
5000*0.0458522351*((1+0.0458522351)^5)/(((1+0.0458522351)^5)-1) |
|
$1,141.66 |
So, interest and principal payment is calculated in following amortization table.
Loan amortization table |
|||||
Year | Beginning balance | Payment | Interest | Principal payment | Ending balance |
(Beg. Bal.*0.0458522351) | (Payment - interest) |
(Beg. Balance - principal payment.) |
|||
1 | 5000.00 | 1141.66 | 229.26 | 912.40 | 4087.60 |
2 | 4087.60 | 1141.66 | 187.43 | 954.24 | 3133.36 |
3 | 3133.36 | 1141.66 | 143.67 | 997.99 | 2135.36 |
4 | 2135.36 | 1141.66 | 97.91 | 1043.75 | 1091.61 |
5 | 1091.61 | 1141.66 | 50.05 | 1091.61 | 0.00 |
Total | 5708.32 | 708.32 | 5000.00 |