In: Finance
A loan of 1000 at a nominal rate of 12 percent convertible monthly is to be repaid by six monthly payments with the first payment due at the end of 1 month. The first three payments are x each, and the final three payments are 3x each.
Determine the sum of the principal repaid in the third payment and the interest paid in the fifth payment.
Monthly Rate = 0.12/12 = 0.01
Period | Discounting Factor [1/(1.01^period)] |
1 | 0.99009901 |
2 | 0.980296049 |
3 | 0.970590148 |
Total | 2.940985207 |
4 | 0.960980344 |
5 | 0.951465688 |
6 | 0.942045235 |
Total | 2.854491267 |
Loan Amount = [First 3 Payments*Total of Discounting Factor of first 3 payments]+[Next 3 Payments*Total of Discounting Factor of next 3 payments]
1000 = 2.940985207x + 2.854491267(3x)
1000 = 2.940985207x + 8.563473801x
1000 = 11.504459008x
Therefore, x = 1000/11.504459008 = $86.92 and 3x = 3*86.92 = $260.76
Amortization Schedule:
Period | Opening Principal (previous closing) |
Interest (opening*0.01) |
Installment | Principal Repayment (installment-interest) |
Closing Principal (opening-principal repayment) |
1 | 1000 | 10 | 86.92 | 76.92 | 923.08 |
2 | 923.08 | 9.2308 | 86.92 | 77.6892 | 845.3908 |
3 | 845.3908 | 8.453908 | 86.92 | 78.466092 = $78.47 | 766.924708 |
4 | 766.924708 | 7.66924708 | 260.76 | 253.0907529 | 513.8339551 |
5 | 513.8339551 | 5.138339551 = $5.14 | 260.76 | 255.6216604 | 258.2122946 |
6 | 258.2122946 | 2.582122946 | 260.79442 | 258.2122946 | 0 |