In: Finance
In January 2018 Ms Langa took a loan of R250 000 that matures in December 2033. The bank charges an interest rate of 24% and requires her to repay in equal semi-annual instalments over the period.
b. What is the number of repayments expected to complete the schedule?
side note
a. repayment amount R31 036
Number of repaymentd = years*payment per year = (2033-2018)*2 = 30
| Semi Annual rate(M)= | yearly rate/12= | 12.00% | Semi Annual payment= | 31035.91 | |
| Half year | Beginning balance (A) | Semi Annual payment | Interest = M*A | Principal paid | Ending balance | 
| 1 | 250000.00 | 31035.91 | 30000.00 | 1035.91 | 248964.09 | 
| 2 | 248964.09 | 31035.91 | 29875.69 | 1160.22 | 247803.86 | 
| 3 | 247803.86 | 31035.91 | 29736.46 | 1299.45 | 246504.41 | 
| 4 | 246504.41 | 31035.91 | 29580.53 | 1455.39 | 245049.03 | 
| 5 | 245049.03 | 31035.91 | 29405.88 | 1630.03 | 243418.99 | 
| 6 | 243418.99 | 31035.91 | 29210.28 | 1825.64 | 241593.36 | 
| 7 | 241593.36 | 31035.91 | 28991.20 | 2044.71 | 239548.65 | 
| 8 | 239548.65 | 31035.91 | 28745.84 | 2290.08 | 237258.57 | 
| 9 | 237258.57 | 31035.91 | 28471.03 | 2564.89 | 234693.69 | 
| 10 | 234693.69 | 31035.91 | 28163.24 | 2872.67 | 231821.01 | 
| 11 | 231821.01 | 31035.91 | 27818.52 | 3217.39 | 228603.62 | 
| 12 | 228603.62 | 31035.91 | 27432.43 | 3603.48 | 225000.14 | 
| 13 | 225000.14 | 31035.91 | 27000.02 | 4035.90 | 220964.24 | 
| 14 | 220964.24 | 31035.91 | 26515.71 | 4520.21 | 216444.04 | 
| 15 | 216444.04 | 31035.91 | 25973.28 | 5062.63 | 211381.41 | 
| 16 | 211381.41 | 31035.91 | 25365.77 | 5670.15 | 205711.26 | 
| 17 | 205711.26 | 31035.91 | 24685.35 | 6350.56 | 199360.70 | 
| 18 | 199360.70 | 31035.91 | 23923.28 | 7112.63 | 192248.07 | 
| 19 | 192248.07 | 31035.91 | 23069.77 | 7966.15 | 184281.92 | 
| 20 | 184281.92 | 31035.91 | 22113.83 | 8922.08 | 175359.84 | 
| 21 | 175359.84 | 31035.91 | 21043.18 | 9992.73 | 165367.10 | 
| 22 | 165367.10 | 31035.91 | 19844.05 | 11191.86 | 154175.24 | 
| 23 | 154175.24 | 31035.91 | 18501.03 | 12534.89 | 141640.36 | 
| 24 | 141640.36 | 31035.91 | 16996.84 | 14039.07 | 127601.29 | 
| 25 | 127601.29 | 31035.91 | 15312.15 | 15723.76 | 111877.53 | 
| 26 | 111877.53 | 31035.91 | 13425.30 | 17610.61 | 94266.91 | 
| 27 | 94266.91 | 31035.91 | 11312.03 | 19723.88 | 74543.03 | 
| 28 | 74543.03 | 31035.91 | 8945.16 | 22090.75 | 52452.28 | 
| 29 | 52452.28 | 31035.91 | 6294.27 | 24741.64 | 27710.64 | 
| 30 | 27710.64 | 31035.91 | 3325.28 | 27710.64 | 0.00 | 
| Where | 
| Interest paid = Beginning balance * Semi Annual interest rate | 
| Principal = Semi Annual payment – interest paid | 
| Ending balance = beginning balance – principal paid | 
| Beginning balance = previous Half year ending balance |