Annual loan interest rate: 4.2% repayment method: equal principal and interest.
Number of installments, principal, interest, monthly repayment amount, loan balance
0 100000.0
1 1,9 16.87 350.00 2,266.87 98,083. 13
2 1,923.58 343.29 2,266.87 96, 159.56
3 1,930.3 1 336.56 2,266.87 94,229.25
4 1,937.06 329.80 2,266.87 92,292. 19
5 1,943.84 323.02 2,266.87 90,348.34
6 1,950.65 3 16.22 2,266.87 88,397.70
7 1,957.47 309.39 2,266.87 86,440.22
8 1,964.33 302.54 2,266.87 84,475.90
9 1,97 1.20 295.67 2,266.87 82,504.70
10 1,978. 10 288.77 2,266.87 80,526.60
1 1 1,985.02 28 1.84 2,266.87 78,54 1.57
12 1,99 1.97 274.90 2,266.87 76,549.60
13 1,998.94 267.92 2,266.87 74,550.66
14 2,005.94 260.93 2,266.87 72,544.72
15 2,0 12.96 253.9 1 2,266.87 70,53 1.76
16 2,020.00 246.86 2,266.87 68,5 1 1.76
17 2,027.07 239.79 2,266.87 66,484.68
18 2,034. 17 232.70 2,266.87 64,450.5 1
19 2,04 1.29 225.58 2,266.87 62,409.22
20 2,048.43 2 18.43 2,266.87 60,360.79
2 1 2,055.60 2 1 1.26 2,266.87 58,305. 19
22 2,062.80 204.07 2,266.87 56,242.39
23 2,070.02 196.85 2,266.87 54, 172.37
24 2,077.26 189.60 2,266.87 52,095. 1 1
25 2,084.53 182.33 2,266.87 50,0 10.58
26 2,09 1.83 175.04 2,266.87 47,9 18.75
27 2,099. 15 167.72 2,266.87 45,8 19.60
28 2, 106.50 160.37 2,266.87 43,7 13. 10
29 2, 1 13.87 153.00 2,266.87 4 1,599.23
30 2, 12 1.27 145.60 2,266.87 39,477.96
3 1 2, 128.69 138. 17 2,266.87 37,349.27
32 2, 136. 14 130.72 2,266.87 35,2 13. 12
33 2, 143.62 123.25 2,266.87 33,069.50
34 2, 15 1. 12 1 15.74 2,266.87 30,9 18.38
35 2, 158.65 108.2 1 2,266.87 28,759.73
36 2, 166.2 1 100.66 2,266.87 26,593.52
37 2, 173.79 93.08 2,266.87 24,4 19.73
38 2, 18 1.40 85.47 2,266.87 22,238.34
39 2, 189.03 77.83 2,266.87 20,049.30
40 2, 196.69 70. 17 2,266.87 17,852.6 1
4 1 2,204.38 62.48 2,266.87 15,648.23
42 2,2 12. 10 54.77 2,266.87 13,436. 13
43 2,2 19.84 47.03 2,266.87 1 1,2 16.29
44 2,227.6 1 39.26 2,266.87 8,988.68
45 2,235.4 1 3 1.46 2,266.87 6,753.28
46 2,243.23 23.64 2,266.87 4,5 10.05
47 2,25 1.08 15.79 2,266.87 2,258.97
48 2,258.96 7.9 1 2,266.87 0.00
Total100,000.008,809.58
The interest should be 8809.58.