Spreadsheet: 792199d1660768947-calculating-total-interest-for-late-payment-w-days-late-and-quarterly-interest-changing-interest-rates
Sheet: BL Daily

Due Date | 2017-07-31 00:00:00 | Days Late | Daily Rate | Int @ 1% | 2018-03-31 00:00:00 | Days Late | Daily Rate | Int @ 4% | 2018-12-31 00:00:00 | Days Late | Daily Rate | Int @ 5% | 2019-06-30 00:00:00 | Days Late | Daily Rate | Int @ 6% | 2020-06-30 00:00:00 | Days Late | Daily Rate | Int @ 5% | Paid Date | Days Late | Daily Rate | Int @ 3% | Total Int
2013-01-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.54 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2013-03-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.52 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2014-01-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.42 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2014-03-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.4 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2015-01-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.3 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2015-03-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.28 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2016-01-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.18 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2016-06-01 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.16 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2017-01-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.06 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2017-03-31 00:00:00 | 2017-07-31 00:00:00 |  |  | 0.04 | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2018-01-31 00:00:00 | 2018-01-31 00:00:00 |  |  |  | 2018-03-31 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2018-04-02 00:00:00 | 2018-04-02 00:00:00 |  |  |  | 2018-04-02 00:00:00 |  |  |  | 2018-12-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2019-01-31 00:00:00 | 2019-01-31 00:00:00 |  |  |  | 2019-01-31 00:00:00 |  |  |  | 2019-01-31 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2019-04-01 00:00:00 | 2019-04-01 00:00:00 |  |  |  | 2019-04-01 00:00:00 |  |  |  | 2019-04-01 00:00:00 |  |  |  | 2019-06-30 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2020-01-31 00:00:00 | 2020-01-31 00:00:00 |  |  |  | 2020-01-31 00:00:00 |  |  |  | 2020-01-31 00:00:00 |  |  |  | 2020-01-31 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2020-03-31 00:00:00 | 2020-03-31 00:00:00 |  |  |  | 2020-03-31 00:00:00 |  |  |  | 2020-03-31 00:00:00 |  |  |  | 2020-03-31 00:00:00 |  |  |  | 2020-06-30 00:00:00 |  |  |  | 2021-10-08 00:00:00
2021-02-01 00:00:00 | 2021-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-10-08 00:00:00
2021-03-31 00:00:00 | 2021-03-31 00:00:00 |  |  |  | 2021-03-31 00:00:00 |  |  |  | 2021-03-31 00:00:00 |  |  |  | 2021-03-31 00:00:00 |  |  |  | 2021-03-31 00:00:00 |  |  |  | 2021-10-08 00:00:00
2022-01-31 00:00:00 | 2022-01-31 00:00:00 |  |  |  | 2022-01-31 00:00:00 |  |  |  | 2022-01-31 00:00:00 |  |  |  | 2022-01-31 00:00:00 |  |  |  | 2022-01-31 00:00:00 |  |  |  | 2021-10-08 00:00:00
2022-03-31 00:00:00 | 2022-03-31 00:00:00 |  |  |  | 2022-03-31 00:00:00 |  |  |  | 2022-03-31 00:00:00 |  |  |  | 2022-03-31 00:00:00 |  |  |  | 2022-03-31 00:00:00 |  |  |  | 2021-10-08 00:00:00