Help to fix incorrect Excel Formula (IPMT) to calculate Interest on Loan for particular Period/Year (SEE SCREENSHOT COMPARISON FOR CORRECT VALUES)

Using the below formula, I am able to calculate correctly the values for the first column/year, but when dragging the formula down to the right, but the values are not correct.

=IPMT($B$6/12, $A15, $B$4*12, $B$2)

CURRRENT INCORRECT VALUES: IPMT YEARS 14 MONTHS 2 15 1 - 1.020,83 -1.020,83 16 2 -1.019,91 - 1.020.69 17 3 -1.018,99 - 1.020,55 18 4 -1.018,07 -1.020,41 19 5 -1.017,14 - 1.020,27 20 6 -1.016,20 -1.020,12 21 7 -1.015,26 -1.019.98 22 8 - 1.014,32 -1.019,84 23 9 -1.013,38 -1.019,69 24 10 - 1.012,43 -1.019,55 25 11 -1,011,48 -1.019,40 26 12 - -1,010,52 -1.019,26 27 3 5 6 7 8 9 10 11 12 13 14 15 - 1.020,83 - - 1.020,83 -1.020,83 - 1.020,83 - - 1.020,83 - 1.020,83 -1.020,83 -1.020,83 - 1.020,83 -1.020,83 -1.020,83 - 1.020,83 - 1.020,83 -1.020,83 -1.04 -1.020,81 -1,020,83 1.020,83 -1,020,83 - - 1.020,83 1.020,83 - 1.020,83 1.020,83 - 1.020,83 1.020,83 -1,020,83 -1,020,83 - 1.020,83 1.020,83 - 1.020,83 - 1.020,83 -1.03 - 1.020,78 - 1.020,82 - 1.020,83 1.020,83 1.020,83 - 1.020,83 - - 1.020,83 - 1.020,83 - 1.020,83 -1.020,83 - 1.020,83 - 1.020,83 1.020,83 - - 1.020,83 - 1.020,83 -1.03 - 1.020,76 -1.020,82 - 1.020,82 -1.020,83 - 1.020,83 -1.020,83 - 1.020,83 -1.020,83 -1.020,83 - 1.020,83 -1.020,83 -1.020,83 -1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 -1.01 - - 1.020,73 - 1.020,82 1.020,83 - 1.020,83 1.020,83 - - - 1.020,83 -1.020,83 - 1.020.83 -1.020.83 - 1.020,83 -1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 -1.020,83 -1.04 - 1 020,71 1.020,81 - 1.020,81 - 1.020,83 -1.020,83 - 1.020,83 -1,020,83 - 1.020,83 -1.020,83 -1,020,83 -1,020,83 -1,020,83 - 1.020,83 - 1.020,83 - - -1.020,83 1.020,83 - -10 -1.020,68 -1.020,81 - 1.020,83 -1,020,83 -1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 1.020,83 - 1.020,83 - 1.020,83 -1.0 - 1.020,66 - 1.020,80 - 1.020,83 - 1.020,83 -1.020,83 -1.020,83 -1.020,83 - 1.020,83 -1.020,83 -1.020,83 -1,020,83 - 1.020,83 -1.020,83 -1.04 - 1.020,63 -1,020,80 1.020,83 -1,020,83 -1.020,83 -1,020,83 - 1.020,83 - - - 1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 -1.020,83 - 1.020,83 -1.02 - 1.020,61 - 1.020,79 1,020,83 -1,020,83 1.020,83 - 1.020,83 - - - 1.020,83 -1.020,83 - 1.020,83 - 1.020,83 1.020,83 - 1.020,83 - 1.020,83 - 1.020,83 1,020,83 - -1.03 - 1.020,58 -1.020,79 1.020,83 - 1.020,83 -1.020,83 - 1.020,83 -1.020,83 - - - - 1.020,83 - 1.020,83 -1.020,83 - 1.020,83 - 1.020,83 -1.020,83 - -1.03 - 1.020,56 1.020,78 1.020,82 -1.020,83 -1.020,83 - - 1.020,83 - 1.020,83 -1,020,83 -1,020,83 -1,020,83 -1,020,83 -1,020,83 -1,020,83 -1.04 - - CORRECT VALUES: 1 2 - 1.020,83 -1.009,56 2 -1.019,91 -1.008,59 3 -1.018,99 -1.007.62 4 -1.018,07 -1.006,65 5 -1,017,14 -1.005,68 3 -1.016.20 -1.004,69 7 -1.015,26 -1.003,71 B -1.014,32 -1.002.72 9 -1.013,38 -1.001,73 -1.012,43 -1.000,73 1 -1.011,48 -999,73 2 -1,010,52 -998,73 3 -997,72 -996,70 -995,69 -994,67 -993,64 -992,61 -991,58 -990,54 -989,50 -988,45 -987,40 -986,34 ha -985,28 -984,22 -983,15 -982,08 -981,00 -979,92 -978,84 -977,74 -976,65 -975,55 -974,45 -973,34 5 5 -972,23 -971,11 -969,99 -968,86 -967,73 -966,60 -965,46 -964,31 -963,16 -962,01 -960,85 -959,68 6 -958,52 -957,34 -956,16 -954,98 -953,79 -952,60 7 -944,12 -942,89 -941,65 -940,41 -939,16 -937,91 -936,65 -935,39 -934,12 -932,85 -931,57 -930,29 8 -929,00 -927.70 -926,40 -925,10 -923,79 -922,48 -921,16 -919,83 -918,50 -917,16 -915,82 -914,47 9 -913,12 -911,76 -910,40 -909,03 -907,65 -906,27 -904,88 -903,49 -902.09 -900.69 -899,28 -897,87 10 -896,45 -895,02 -893,59 -892,15 -890,70 -889,25 -887,80 -886,34 -884,87 -883,39 -881,91 -880,43 11 -878,94 -877,44 -875,93 -874,42 -872,91 -871,38 -869,86 -868,32 -866,78 -865,23 -863,68 -862,12 12 -860,55 -858,98 -857.40 -855,81 -854.22 -852,62 -851,01 -849,40 -847,78 -846,16 -844,53 -842,89 13 -841,24 -839,59 -837,93 -836,27 -834,59 -832,91 -831,23 -829,54 -827,84 -826,13 -824,42 -822,69 -951,40 -950.20 -949,00 -947.78 -946,57 -945,34