Spreadsheet: 79843d1280079850-calculating-late-fees-and-accruing-interest-test-interest-and-penalties
Sheet: Manual Calculation

Reserve Balance
 | Interest Rate |  | 0.1 | of all outstanding balances, per year
 | Penalty |  | 0.1 | of late/missed payment anount
 | Payment Due | Past Due | Penalty Due | Interest Due | Total Due
2009-01-01 00:00:00 | 492.6 |  | 49.26000000000001 | 4.105 | 545.965
2009-02-01 00:00:00 | 492.6 | 545.965 | 103.8565 | 8.654708333333334 | 1151.076208333333
2009-03-01 00:00:00 | 492.6 | 1151.076208333333 | 164.3676208333333 | 13.69730173611111 | 1821.741130902778
2009-04-01 00:00:00 | 492.6 | 1821.741130902778 | 231.4341130902778 | 19.28617609085648 | 2565.061420083912
2009-05-01 00:00:00 | 492.6 | 2565.061420083912 | 305.7661420083912 | 25.4805118340326 | 3388.908073926335
2009-06-01 00:00:00 | 492.6 | 3388.908073926335 | 388.1508073926336 | 32.34590061605279 | 4302.004781935022
2009-07-01 00:00:00 | 492.6 | 4302.004781935022 | 479.4604781935022 | 39.95503984945852 | 5314.020299977983
2009-08-01 00:00:00 | 492.6 | 5314.020299977983 | 580.6620299977984 | 48.38850249981653 | 6435.670832475598
2009-09-01 00:00:00 | 492.6 | 6435.670832475598 | 692.8270832475599 | 57.73559027062999 | 7678.833505993789
2009-10-01 00:00:00 | 492.6 | 7678.833505993789 | 817.143350599379 | 68.09527921661491 | 9056.672135809784
2009-11-01 00:00:00 | 492.6 | 9056.672135809784 | 954.9272135809784 | 79.57726779841487 | 10583.77661718918
2009-12-01 00:00:00 | 492.6 | 10583.77661718918 | 1107.637661718918 | 92.30313847657648 | 12276.31741738467
2010-01-01 00:00:00 | 492.6 | 12276.31741738467 | 1276.891741738467 | 106.4076451448723 | 14152.21680426801
2010-02-01 00:00:00 | 492.6 | 14152.21680426801 | 1464.481680426801 | 122.0401400355668 | 16231.33862473038
2010-03-01 00:00:00 | 492.6 | 16231.33862473038 | 1672.393862473038 | 139.3661552060865 | 18535.69864240951
2010-04-01 00:00:00 | 492.6 | 18535.69864240951 | 1902.829864240951 | 158.5691553534126 | 21089.69766200387
2010-05-01 00:00:00 | 492.6 | 21089.69766200387 | 2158.229766200387 | 179.8524805166989 | 23920.37990872096
2010-06-01 00:00:00 | 492.6 | 23920.37990872096 | 2441.297990872095 | 203.4414992393413 | 27057.71939883239
2010-07-01 00:00:00 | 492.6 | 27057.71939883239 | 2755.031939883239 | 229.5859949902699 | 30534.9373337059
 | 9359.400000000003
Operating Balance
 | Interest Rate |  | 0.1 | of all outstanding balances, per year
 | Penalty |  | 0.1 | of late/missed payment anount
 | Payment Due | Past Due | Penalty Due | Interest Due | Total Due
2009-01-01 00:00:00 | 1554.19 |  | 155.419 | 12.95158333333333 | 1722.560583333333
2009-02-01 00:00:00 | 1554.19 | 1722.560583333333 | 327.6750583333334 | 27.30625486111111 | 3631.731896527778
2009-03-01 00:00:00 | 1554.19 | 3631.731896527778 | 518.5921896527778 | 43.21601580439815 | 5747.730101984954
2009-04-01 00:00:00 | 1554.19 | 5747.730101984954 | 730.1920101984954 | 60.84933418320795 | 8092.961446366657
2009-05-01 00:00:00 | 1554.19 | 8092.961446366657 | 964.7151446366657 | 80.39292871972215 | 10692.25951972305
2009-06-01 00:00:00 | 1554.19 | 10692.25951972305 | 1224.644951972305 | 102.053745997692 | 13573.14821769304
2009-07-01 00:00:00 | 1554.19 | 13573.14821769304 | 1512.733821769304 | 126.0611518141087 | 16766.13319127645
2009-08-01 00:00:00 | 1554.19 | 16766.13319127645 | 1832.032319127645 | 152.6693599273038 | 20305.0248703314
2009-09-01 00:00:00 | 1554.19 | 20305.0248703314 | 2185.92148703314 | 182.1601239194283 | 24227.29648128396
2009-10-01 00:00:00 | 1554.19 | 24227.29648128396 | 2578.148648128396 | 214.8457206773664 | 28574.48085008973
2009-11-01 00:00:00 | 1554.19 | 28574.48085008973 | 3012.867085008973 | 251.0722570840811 | 33392.61019218278
2009-12-01 00:00:00 | 1554.19 | 33392.61019218278 | 3494.680019218278 | 291.2233349348565 | 38732.70354633591
2010-01-01 00:00:00 | 1554.19 | 38732.70354633591 | 4028.689354633592 | 335.7241128861327 | 44651.30701385564
2010-02-01 00:00:00 | 1554.19 | 44651.30701385564 | 4620.549701385565 | 385.0458084487971 | 51211.09252369001
2010-03-01 00:00:00 | 1554.19 | 51211.09252369001 | 5276.528252369001 | 439.7106876974167 | 58481.52146375643
2010-04-01 00:00:00 | 1554.19 | 58481.52146375643 | 6003.571146375643 | 500.2975955313036 | 66539.58020566337
2010-05-01 00:00:00 | 1554.19 | 66539.58020566337 | 6809.377020566338 | 567.4480850471948 | 75470.59531127689
2010-06-01 00:00:00 | 1554.19 | 75470.59531127689 | 7702.47853112769 | 641.8732109273075 | 85369.1370533319
2010-07-01 00:00:00 | 1554.19 | 85369.1370533319 | 8692.33270533319 | 724.3610587777658 | 96340.02081744286
 | 29529.60999999999
Tax Balance
 | Interest Rate |  | 0.1 | of all outstanding balances, per year
 | Penalty |  | 0.1 | of late/missed payment anount
 | Payment Due | Past Due | Penalty Due | Interest Due | Total Due
2009-01-01 00:00:00 | 2531.32 |  | 253.132 | 21.09433333333333 | 2805.546333333334
2009-02-01 00:00:00 | 2531.32 | 2805.546333333334 | 533.6866333333334 | 44.47388611111111 | 5915.026852777778
2009-03-01 00:00:00 | 2531.32 | 5915.026852777778 | 844.6346852777779 | 70.38622377314816 | 9361.367761828704
2009-04-01 00:00:00 | 2531.32 | 9361.367761828704 | 1189.26877618287 | 99.10573134857253 | 13181.06226936015
2009-05-01 00:00:00 | 2531.32 | 13181.06226936015 | 1571.238226936015 | 130.9365189113346 | 17414.55701520749
2009-06-01 00:00:00 | 2531.32 | 17414.55701520749 | 1994.58770152075 | 166.2156417933958 | 22106.68035852164
2009-07-01 00:00:00 | 2531.32 | 22106.68035852164 | 2463.800035852164 | 205.316669654347 | 27307.11706402815
2009-08-01 00:00:00 | 2531.32 | 27307.11706402815 | 2983.843706402815 | 248.6536422002346 | 33070.9344126312
2009-09-01 00:00:00 | 2531.32 | 33070.9344126312 | 3560.22544126312 | 296.6854534385934 | 39459.16530733291
2009-10-01 00:00:00 | 2531.32 | 39459.16530733291 | 4199.048530733292 | 349.920710894441 | 46539.45454896065
2009-11-01 00:00:00 | 2531.32 | 46539.45454896065 | 4907.077454896064 | 408.9231212413387 | 54386.77512509804
2009-12-01 00:00:00 | 2531.32 | 54386.77512509804 | 5691.809512509804 | 474.317459375817 | 63084.22209698366
2010-01-01 00:00:00 | 2531.32 | 63084.22209698366 | 6561.554209698367 | 546.7961841415306 | 72723.89249082356
2010-02-01 00:00:00 | 2531.32 | 72723.89249082356 | 7525.521249082358 | 627.1267707568632 | 83407.8605106628
2010-03-01 00:00:00 | 2531.32 | 83407.8605106628 | 8593.91805106628 | 716.1598375888567 | 95249.25839931794
2010-04-01 00:00:00 | 2531.32 | 95249.25839931794 | 9778.057839931795 | 814.8381533276496 | 108373.4743925774
2010-05-01 00:00:00 | 2531.32 | 108373.4743925774 | 11090.47943925774 | 924.2066199381451 | 122919.4804517733
2010-06-01 00:00:00 | 2531.32 | 122919.4804517733 | 12545.08004517733 | 1045.423337098111 | 139041.3038340488
2010-07-01 00:00:00 | 2531.32 | 139041.3038340488 | 14157.26238340488 | 1179.77186528374 | 156909.6580827374
 | 48095.08
Special Assessment Balance
 | Interest Rate |  | 0.1 | of all outstanding balances, per year
 | Penalty |  | 0.1 | of late/missed payment anount
 | Payment Due | Past Due | Penalty Due | Interest Due | Total Due
2009-01-01 00:00:00 | 492.6 |  | 49.26000000000001 | 4.105 | 545.965
2009-02-01 00:00:00 | 492.6 | 545.965 | 103.8565 | 8.654708333333334 | 1151.076208333333
2009-03-01 00:00:00 | 492.6 | 1151.076208333333 | 164.3676208333333 | 13.69730173611111 | 1821.741130902778
2009-04-01 00:00:00 | 492.6 | 1821.741130902778 | 231.4341130902778 | 19.28617609085648 | 2565.061420083912
2009-05-01 00:00:00 | 492.6 | 2565.061420083912 | 305.7661420083912 | 25.4805118340326 | 3388.908073926335
2009-06-01 00:00:00 | 492.6 | 3388.908073926335 | 388.1508073926336 | 32.34590061605279 | 4302.004781935022
2009-07-01 00:00:00 | 492.6 | 4302.004781935022 | 479.4604781935022 | 39.95503984945852 | 5314.020299977983
2009-08-01 00:00:00 | 492.6 | 5314.020299977983 | 580.6620299977984 | 48.38850249981653 | 6435.670832475598
2009-09-01 00:00:00 | 492.6 | 6435.670832475598 | 692.8270832475599 | 57.73559027062999 | 7678.833505993789
2009-10-01 00:00:00 | 492.6 | 7678.833505993789 | 817.143350599379 | 68.09527921661491 | 9056.672135809784
2009-11-01 00:00:00 | 492.6 | 9056.672135809784 | 954.9272135809784 | 79.57726779841487 | 10583.77661718918
2009-12-01 00:00:00 | 492.6 | 10583.77661718918 | 1107.637661718918 | 92.30313847657648 | 12276.31741738467
2010-01-01 00:00:00 | 492.6 | 12276.31741738467 | 1276.891741738467 | 106.4076451448723 | 14152.21680426801
2010-02-01 00:00:00 | 492.6 | 14152.21680426801 | 1464.481680426801 | 122.0401400355668 | 16231.33862473038
2010-03-01 00:00:00 | 492.6 | 16231.33862473038 | 1672.393862473038 | 139.3661552060865 | 18535.69864240951
2010-04-01 00:00:00 | 492.6 | 18535.69864240951 | 1902.829864240951 | 158.5691553534126 | 21089.69766200387
2010-05-01 00:00:00 | 492.6 | 21089.69766200387 | 2158.229766200387 | 179.8524805166989 | 23920.37990872096
2010-06-01 00:00:00 | 492.6 | 23920.37990872096 | 2441.297990872095 | 203.4414992393413 | 27057.71939883239
2010-07-01 00:00:00 | 492.6 | 27057.71939883239 | 2755.031939883239 | 229.5859949902699 | 30534.9373337059