Bank Loan practise in Excel

Year Total Loan start of the year Total payment Repayment Interest End of the year loan balance
1 € 174,687.02 € 15,517.00 € 1,542.04 € 13,974.96 € 173,144.99
2 € 173,144.99 € 15,517.00 € 1,665.40 € 13,851.60 € 171,479.58
3 € 171,479.58 € 15,517.00 € 1,798.63 € 13,718.37 € 169,680.95
4 € 169,680.95 € 15,517.00 € 1,942.52 € 13,574.48 € 167,738.43
5 € 167,738.43 € 15,517.00 € 2,097.93 € 13,419.07 € 165,640.50
6 € 165,640.50 € 15,517.00 € 2,265.76 € 13,251.24 € 163,374.74
7 € 163,374.74 € 15,517.00 € 2,447.02 € 13,069.98 € 160,927.72
8 € 160,927.72 € 15,517.00 € 2,642.78 € 12,874.22 € 158,284.94
9 € 158,284.94 € 15,517.00 € 2,854.20 € 12,662.80 € 155,430.73
10 € 155,430.73 € 15,517.00 € 3,082.54 € 12,434.46 € 152,348.19
11 € 152,348.19 € 15,517.00 € 3,329.14 € 12,187.86 € 149,019.05
12 € 149,019.05 € 15,517.00 € 3,595.48 € 11,921.52 € 145,423.57
13 € 145,423.57 € 15,517.00 € 3,883.11 € 11,633.89 € 141,540.46
14 € 141,540.46 € 15,517.00 € 4,193.76 € 11,323.24 € 137,346.70
15 € 137,346.70 € 15,517.00 € 4,529.26 € 10,987.74 € 132,817.43
16 € 132,817.43 € 15,517.00 € 4,891.61 € 10,625.39 € 127,925.83
17 € 127,925.83 € 15,517.00 € 5,282.93 € 10,234.07 € 122,642.89
18 € 122,642.89 € 15,517.00 € 5,705.57 € 9,811.43 € 116,937.32
19 € 116,937.32 € 15,517.00 € 6,162.01 € 9,354.99 € 110,775.31
20 € 110,775.31 € 15,517.00 € 6,654.98 € 8,862.02 € 104,120.33
21 € 104,120.33 € 15,517.00 € 7,187.37 € 8,329.63 € 96,932.96
22 € 96,932.96 € 15,517.00 € 7,762.36 € 7,754.64 € 89,170.60
23 € 89,170.60 € 15,517.00 € 8,383.35 € 7,133.65 € 80,787.24
24 € 80,787.24 € 15,517.00 € 9,054.02 € 6,462.98 € 71,733.22
25 € 71,733.22 € 15,517.00 € 9,778.34 € 5,738.66 € 61,954.88
26 € 61,954.88 € 15,517.00 € 10,560.61 € 4,956.39 € 51,394.27
27 € 51,394.27 € 15,517.00 € 11,405.46 € 4,111.54 € 39,988.81
28 € 39,988.81 € 15,517.00 € 12,317.89 € 3,199.11 € 27,670.92
29 € 27,670.92 € 15,517.00 € 13,303.33 € 2,213.67 € 14,367.59
30 € 14,367.59 € 15,517.00 € 14,367.59 € 1,149.41 € 0.00