Spreadsheet: 889979d1741076422-daily-interest-rounded-down-interest-rate-calculation
Sheet: Sheet1

Year | Date | Balance | Interest Rate | Interest Earned from previous day | Interest earned + rounded excess from previous day | Interest Paid (Interest Rounded down) | Excess Interest to be added to next day | Calculated Interest Earned same as actual interest paid | Difference |  | Actual Interest Paid
 |  |  |  |  |  |  |  |  |  |  | Daily Rate
 | 2024-10-01 00:00:00 | 2000 | 0.0199 | 0 | 0 | 0 | 0 |  |  |  | 0
 |  | 3000.07 |  |  |  |  |  |  |  |  | 0.1
 |  | 3000.19 |  |  |  |  |  |  |  |  | 0.17
 |  | 3000.29 |  |  |  |  |  |  |  |  | 0.16
 |  | 3000.4 |  |  |  |  |  |  |  |  | 0.16
 |  | 3000.51 |  |  |  |  |  |  |  |  | 0.17
 |  | 3000.62 |  |  |  |  |  |  |  |  | 0.16
 |  | 3000.73 |  |  |  |  |  |  |  |  | 0.16
 |  | 5000.84 |  |  |  |  |  |  |  |  | 0.17
 |  | 5001.02 |  |  |  |  |  |  |  |  | 0.27
 |  | 5001.2 |  |  |  |  |  |  |  |  | 0.27
 |  | 5001.39 |  |  |  |  |  |  |  |  | 0.27
 |  | 5001.57 |  |  |  |  |  |  |  |  | 0.27
 |  | 5001.75 |  |  |  |  |  |  |  |  | 0.28
 |  | 5001.93 |  |  |  |  |  |  |  |  | 0.27
 |  | 5002.12 |  |  |  |  |  |  |  |  | 0.27
 |  | 5002.3 |  |  |  |  |  |  |  |  | 0.27
 |  | 5002.48 |  |  |  |  |  |  |  |  | 0.27
 |  | 5002.66 |  |  |  |  |  |  |  |  | 0.28
 |  | 4002.85 |  |  |  |  |  |  |  |  | 0.27
 |  | 4002.99 |  |  |  |  |  |  |  |  | 0.21
 |  | 4003.13 |  |  |  |  |  |  |  |  | 0.22
 |  | 4003.28 |  |  |  |  |  |  |  |  | 0.22
 |  | 4003.43 |  |  |  |  |  |  |  |  | 0.22
 |  | 4003.58 |  |  |  |  |  |  |  |  | 0.22
 |  | 4003.72 |  |  |  |  |  |  |  |  | 0.21
 |  | 4003.86 |  |  |  |  |  |  |  |  | 0.22
 |  | 4004.01 |  |  |  |  |  |  |  |  | 0.22
 |  | 4004.16 |  |  |  |  |  |  |  |  | 0.22
 |  | 5004.3 |  |  |  |  |  |  |  |  | 0.21
 |  | 5004.49 |  |  |  |  |  |  |  |  | 0.28
 |  | 5004.67 |  |  |  |  |  |  |  |  | 0.27
 |  | 5004.85 |  |  |  |  |  |  |  |  | 0.27
 |  | 5005.03 |  |  |  |  |  |  |  |  | 0.27
 |  | 5005.21 |  |  |  |  |  |  |  |  | 0.27
 |  | 5005.4 |  |  |  |  |  |  |  |  | 0.28
 |  | 5005.58 |  |  |  |  |  |  |  |  | 0.27
 |  | 5005.76 |  |  |  |  |  |  |  |  | 0.27
 |  | 5005.94 |  |  |  |  |  |  |  |  | 0.27
 |  | 4506.13 |  |  |  |  |  |  |  |  | 0.28
 |  | 4506.29 |  |  |  |  |  |  |  |  | 0.24
 |  | 4506.46 |  |  |  |  |  |  |  |  | 0.25
 |  | 4506.62 |  |  |  |  |  |  |  |  | 0.24
 |  | 4506.79 |  |  |  |  |  |  |  |  | 0.25
 |  | 4306.95 |  |  |  |  |  |  |  |  | 0.24
 |  | 4307.1 |  |  |  |  |  |  |  |  | 0.23
 |  | 4307.26 |  |  |  |  |  |  |  |  | 0.24
 |  | 4307.42 |  |  |  |  |  |  |  |  | 0.23
 |  | 4307.58 |  |  |  |  |  |  |  |  | 0.24
 |  | 4307.73 |  |  |  |  |  |  |  |  | 0.23
 |  | 4307.89 |  |  |  |  |  |  |  |  | 0.24
 |  | 4208.04 |  |  |  |  |  |  |  |  | 0.23
 |  | 4208.2 |  |  |  |  |  |  |  |  | 0.23
 |  | 4208.35 |  |  |  |  |  |  |  |  | 0.23
 |  | 3908.51 |  |  |  |  |  |  |  |  | 0.23
 |  | 3908.65 |  |  |  |  |  |  |  |  | 0.21
 |  | 3908.79 |  |  |  |  |  |  |  |  | 0.21
 |  | 3908.93 |  |  |  |  |  |  |  |  | 0.21
 |  | 3909.08 | 0.0169 |  |  |  |  |  |  |  | 0.22
 |  | 3509.2 |  |  |  |  |  |  |  |  | 0.18
 |  | 3009.3 |  |  |  |  |  |  |  |  | 0.16
 |  | 3009.4 |  |  |  |  |  |  |  |  | 0.14
 |  | 2309.49 |  |  |  |  |  |  |  |  | 0.14
 |  | 2309.56 |  |  |  |  |  |  |  |  | 0.1
 |  | 2309.63 |  |  |  |  |  |  |  |  | 0.11
 |  | 2309.71 |  |  |  |  |  |  |  |  | 0.11
 |  | 2009.77 |  |  |  |  |  |  |  |  | 0.1
 |  | 2009.84 |  |  |  |  |  |  |  |  | 0.09999999999999999
 |  | 2009.9 |  |  |  |  |  |  |  |  | 0.09
 |  | 2009.96 |  |  |  |  |  |  |  |  | 0.09
 |  | 2010.02 |  |  |  |  |  |  |  |  | 0.09
 |  | 2010.09 |  |  |  |  |  |  |  |  | 0.09999999999999999
 |  | 2010.15 |  |  |  |  |  |  |  |  | 0.09
 |  | 2010.21 |  |  |  |  |  |  |  |  | 0.09
 |  | 2010.28 |  |  |  |  |  |  |  |  | 0.09999999999999999
 |  | 1910.34 |  |  |  |  |  |  |  |  | 0.09
 |  | 1910.4 |  |  |  |  |  |  |  |  | 0.09
 |  | 1910.46 |  |  |  |  |  |  |  |  | 0.09
 |  | 1870.51 |  |  |  |  |  |  |  |  | 0.08
 |  | 1820.57 |  |  |  |  |  |  |  |  | 0.09
 |  | 1680.62 |  |  |  |  |  |  |  |  | 0.08
 |  | 1680.68 |  |  |  |  |  |  |  |  | 0.08
 |  | 1380.73 |  |  |  |  |  |  |  |  | 0.08
 |  | 1340.77 |  |  |  |  |  |  |  |  | 0.06
 |  | 1340.81 |  |  |  |  |  |  |  |  | 0.06
 |  | 1340.86 |  |  |  |  |  |  |  |  | 0.06999999999999999
 |  | 1340.9 |  |  |  |  |  |  |  |  | 0.06
 |  | 1290.94 |  |  |  |  |  |  |  |  | 0.06
 |  | 1200.98 |  |  |  |  |  |  |  |  | 0.06
 |  | 1201.01 |  |  |  |  |  |  |  |  | 0.05
 |  | 1151.05 |  |  |  |  |  |  |  |  | 0.06
 |  | 1101.09 |  |  |  |  |  |  |  |  | 0.05
 |  | 601.13 |  |  |  |  |  |  |  |  | 0.05
 |  | 500 |  |  |  |  |  |  |  |  | 0.03
 |  | 2900.01 |  |  |  |  |  |  |  |  | 0.02
 |  | 2900.11 |  |  |  |  |  |  |  |  | 0.14
 |  | 2800.19 |  |  |  |  |  |  |  |  | 0.13
 |  | 2800.28 |  |  |  |  |  |  |  |  | 0.13
 |  | 2800.37 |  |  |  |  |  |  |  |  | 0.13
 |  | 2670.45 |  |  |  |  |  |  |  |  | 0.13
 |  | 2670.53 |  |  |  |  |  |  |  |  | 0.12
 |  | 2620.62 |  |  |  |  |  |  |  |  | 0.13
 |  | 2570.7 |  |  |  |  |  |  |  |  | 0.12
 |  | 2534.78 |  |  |  |  |  |  |  |  | 0.12
 |  | 2534.86 |  |  |  |  |  |  |  |  | 0.11
 |  | 2534.94 |  |  |  |  |  |  |  |  | 0.12
 |  | 2530.02 |  |  |  |  |  |  |  |  | 0.12
 |  | 2460.1 |  |  |  |  |  |  |  |  | 0.12
 |  | 2460.17 |  |  |  |  |  |  |  |  | 0.11
 |  | 2400.24 |  |  |  |  |  |  |  |  | 0.11
 |  | 2400.33 |  |  |  |  |  |  |  |  | 0.12
 |  | 2320.4 |  |  |  |  |  |  |  |  | 0.11
 |  | 2170.47 |  |  |  |  |  |  |  |  | 0.1
 |  | 2020.53 |  |  |  |  |  |  |  |  | 0.1
 |  | 1950.6 |  |  |  |  |  |  |  |  | 0.09999999999999999
 |  | 1755.66 |  |  |  |  |  |  |  |  | 0.09
 |  | 1755.71 |  |  |  |  |  |  |  |  | 0.08
 |  | 1655.77 |  |  |  |  |  |  |  |  | 0.08
 |  | 1430.39 |  |  |  |  |  |  |  |  | 0.08
 |  | 1430.43 |  |  |  |  |  |  |  |  | 0.06
 |  | 1430.48 |  |  |  |  |  |  |  |  | 0.07
 |  | 1400.52 |  |  |  |  |  |  |  |  | 0.07
 |  | 950.57 |  |  |  |  |  |  |  |  | 0.06
 |  | 880.59 |  |  |  |  |  |  |  |  | 0.04
 |  | 800.63 |  |  |  |  |  |  |  |  | 0.05
 |  | 800.65 |  |  |  |  |  |  |  |  | 0.03
 |  | 726.67 |  |  |  |  |  |  |  |  | 0.04
 |  | 726.69 |  |  |  |  |  |  |  |  | 0.03
 |  | 566.72 |  |  |  |  |  |  |  |  | 0.04
 |  | 366.73 |  |  |  |  |  |  |  |  | 0.02
 |  | 366.75 |  |  |  |  |  |  |  |  | 0.02
 |  | 366.76 |  |  |  |  |  |  |  |  | 0.02
 |  | 366.77 |  |  |  |  |  |  |  |  | 0.01
 |  | 316.33 |  |  |  |  |  |  |  |  | 0.02
 |  | 306.34 |  |  |  |  |  |  |  |  | 0.02
 |  | 828.16 |  |  |  |  |  |  |  |  | 0.01
 |  | 828.19 |  |  |  |  |  |  |  |  | 0.04
 |  | 828.21 |  |  |  |  |  |  |  |  | 0.04
 |  | 748.24 |  |  |  |  |  |  |  |  | 0.04
 |  | 748.26 |  |  |  |  |  |  |  |  | 0.03
 |  | 681.28 |  |  |  |  |  |  |  |  | 0.03
 |  | 581.31 |  |  |  |  |  |  |  |  | 0.04
 |  | 1053.14 |  |  |  |  |  |  |  |  | 0.02
 |  | 1053.17 |  |  |  |  |  |  |  |  | 0.05
 |  | 953.21 |  |  |  |  |  |  |  |  | 0.05
 |  | 953.23 |  |  |  |  |  |  |  |  | 0.04
 |  | 843.94 |  |  |  |  |  |  |  |  | 0.05
 |  | 363.96 |  |  |  |  |  |  |  |  | 0.04
 |  | 363.97 |  |  |  |  |  |  |  |  | 0.01
 |  | 885.79 |  |  |  |  |  |  |  |  | 0.02
 |  | 155.82 |  |  |  |  |  |  |  |  | 0.04
 |  | 155.83 |  |  |  |  |  |  |  |  | 0.01
 |  | 140.83 |  |  |  |  |  |  |  |  | 0.01
 |  | 140.84 |  |  |  |  |  |  |  |  | 0.01