EdgeCaseTest004
Day | Datestamp | Advances | Scheduled payment | Window | Payment due | Actual payments | Net effect | Payment status | Balance status | New charges | Charges portion | Actuarial interest | New interest | Interest portion | Fee rebate if settled | Fee rebate | Fee portion | Principal portion | Charges balance | Interest balance | Fee balance | Principal balance | Settlement figure |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2020-10-08 | 500.00 | n/a | 0 | 0.00 | n/a | 0.00 | none scheduled | open | n/a | 0.00 | 0.0000 | 0.0000 | 0.00 | 772.35 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0000 | 772.35 | 500.00 | 1,272.35 |
8 | 2020-10-16 | n/a | original 225.00 | 1 | 225.00 | 225.00 failed (insufficient funds) 225.00 failed (insufficient funds) 225.00 failed (insufficient funds) |
0.00 | missed payment | open | insufficient funds 10.00 | 0.00 | 2.7748 | 2.7748 | 0.00 | 747.14 | 0.00 | 0.00 | 0.00 | 10.00 | 2.7748 | 772.35 | 500.00 | 537.98 |
11 | 2020-10-19 | n/a | n/a | 1 | 0.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 1.0405 | 1.0405 | 0.00 | 737.68 | 0.00 | 0.00 | 0.00 | 10.00 | 3.8153 | 772.35 | 500.00 | 548.48 |
14 | 2020-10-22 | n/a | n/a | 1 | 0.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 1.0405 | 1.0405 | 0.00 | 728.22 | 0.00 | 0.00 | 0.00 | 10.00 | 4.8558 | 772.35 | 500.00 | 558.98 |
39 | 2020-11-16 | n/a | original 225.00 | 2 | 225.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | missed payment | open | n/a | 0.00 | 8.6712 | 8.6712 | 0.00 | 649.41 | 0.00 | 0.00 | 0.00 | 10.00 | 13.5270 | 772.35 | 500.00 | 646.46 |
42 | 2020-11-19 | n/a | n/a | 2 | 0.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 1.0405 | 1.0405 | 0.00 | 639.95 | 0.00 | 0.00 | 0.00 | 10.00 | 14.5675 | 772.35 | 500.00 | 656.96 |
45 | 2020-11-22 | n/a | n/a | 2 | 0.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 1.0405 | 1.0405 | 0.00 | 630.49 | 0.00 | 0.00 | 0.00 | 10.00 | 15.6081 | 772.35 | 500.00 | 667.46 |
69 | 2020-12-16 | n/a | original 225.00 | 3 | 225.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | paid later in full | open | n/a | 0.00 | 8.3243 | 8.3243 | 0.00 | 554.84 | 0.00 | 0.00 | 0.00 | 10.00 | 23.9324 | 772.35 | 500.00 | 751.44 |
72 | 2020-12-19 | n/a | n/a | 3 | 0.00 | confirmed 225.00 225.00 failed 225.00 failed |
225.00 | extra payment | open | n/a | 10.00 | 1.0405 | 1.0405 | 24.97 | 545.38 | 0.00 | 115.36 | 74.67 | 0.00 | 0.0000 | 656.99 | 425.33 | 536.94 |
75 | 2020-12-22 | n/a | n/a | 3 | 0.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.8851 | 0.8851 | 0.00 | 535.92 | 0.00 | 0.00 | 0.00 | 0.00 | 0.8851 | 656.99 | 425.33 | 547.28 |
100 | 2021-01-16 | n/a | original 225.00 | 4 | 225.00 | 225.00 failed 225.00 failed 225.00 failed |
0.00 | paid later in full | open | n/a | 0.00 | 7.3761 | 7.3761 | 0.00 | 457.11 | 0.00 | 0.00 | 0.00 | 0.00 | 8.2612 | 656.99 | 425.33 | 633.47 |
103 | 2021-01-19 | n/a | n/a | 4 | 0.00 | 237.00 failed 237.00 failed 237.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.8851 | 0.8851 | 0.00 | 447.65 | 0.00 | 0.00 | 0.00 | 0.00 | 9.1463 | 656.99 | 425.33 | 643.81 |
106 | 2021-01-22 | n/a | n/a | 4 | 0.00 | confirmed 249.00 225.00 failed 225.00 failed |
249.00 | extra payment | open | n/a | 0.00 | 0.8851 | 0.8851 | 10.03 | 438.20 | 0.00 | 145.07 | 93.90 | 0.00 | 0.0000 | 511.92 | 331.43 | 405.15 |
214 | 2021-05-10 | n/a | original 250.00 | 5 | 250.00 | 250.00 failed 250.00 failed 250.00 failed |
0.00 | missed payment | open | n/a | 0.00 | 24.8291 | 24.8291 | 0.00 | 97.73 | 0.00 | 0.00 | 0.00 | 0.00 | 24.8291 | 511.92 | 331.43 | 770.44 |
217 | 2021-05-13 | n/a | n/a | 5 | 0.00 | 250.00 failed 250.00 failed 250.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.6897 | 0.6897 | 0.00 | 88.27 | 0.00 | 0.00 | 0.00 | 0.00 | 25.5188 | 511.92 | 331.43 | 780.59 |
220 | 2021-05-16 | n/a | n/a | 5 | 0.00 | 250.00 failed 250.00 failed 250.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.6897 | 0.6897 | 0.00 | 78.82 | 0.00 | 0.00 | 0.00 | 0.00 | 26.2085 | 511.92 | 331.43 | 790.73 |
245 | 2021-06-10 | n/a | original 276.00 | 6 | 276.00 | 250.00 failed 250.00 failed 250.00 failed 250.00 failed |
0.00 | paid later in full | open | n/a | 0.00 | 5.7475 | 5.7475 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 31.9560 | 511.92 | 331.43 | 875.30 |
248 | 2021-06-13 | n/a | n/a | 6 | 0.00 | 250.00 failed 250.00 failed 250.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.6897 | 0.6897 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 32.6457 | 511.92 | 331.43 | 875.99 |
251 | 2021-06-16 | n/a | n/a | 6 | 0.00 | 250.00 failed 250.00 failed 250.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.6897 | 0.6897 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 33.3354 | 511.92 | 331.43 | 876.68 |
379 | 2021-10-22 | n/a | n/a | 6 | 0.00 | 175.00 failed 175.00 failed 175.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 29.4271 | 29.4271 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 62.7626 | 511.92 | 331.43 | 906.11 |
380 | 2021-10-23 | n/a | n/a | 6 | 0.00 | confirmed 175.00 | 175.00 | extra payment | open | n/a | 0.00 | 0.2299 | 0.2299 | 62.99 | 0.00 | 0.00 | 68.00 | 44.01 | 0.00 | 0.0000 | 443.92 | 287.42 | 731.34 |
407 | 2021-11-19 | n/a | n/a | 6 | 0.00 | confirmed 175.00 | 175.00 | extra payment | open | n/a | 0.00 | 5.3829 | 5.3829 | 5.38 | 0.00 | 0.00 | 102.97 | 66.65 | 0.00 | 0.0000 | 340.95 | 220.77 | 561.72 |
435 | 2021-12-17 | n/a | n/a | 6 | 0.00 | 176.00 failed 176.00 failed 176.00 failed 176.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 4.2875 | 4.2875 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.2875 | 340.95 | 220.77 | 566.00 |
438 | 2021-12-20 | n/a | n/a | 6 | 0.00 | 176.00 failed 176.00 failed 176.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.4594 | 0.4594 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.7469 | 340.95 | 220.77 | 566.46 |
441 | 2021-12-23 | n/a | n/a | 6 | 0.00 | 176.00 failed 176.00 failed 176.00 failed |
0.00 | nothing due | open | n/a | 0.00 | 0.4594 | 0.4594 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.2063 | 340.95 | 220.77 | 566.92 |
475 | 2022-01-26 | n/a | n/a | 6 | 0.00 | confirmed 176.00 | 176.00 | extra payment | open | n/a | 0.00 | 5.2063 | 5.2063 | 10.41 | 0.00 | 0.00 | 100.52 | 65.07 | 0.00 | 0.0000 | 240.43 | 155.70 | 396.13 |
✓ 1251 | 2024-03-12 | n/a | n/a | 6 | 0.00 | n/a | 479.92 | generated | closed | n/a | 0.00 | 83.7972 | 83.7972 | 83.79 | 0.00 | 0.00 | 240.43 | 155.70 | 0.00 | 0.0000 | 0.00 | 0.00 | 0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
Generated settlement: 479.92 on day 1251 | Final balance status: closed |
Effective interest rate: 0.01241243811 % per day | Final cost-to-borrowing ratio: 195.98 % |
Required scheduled payment count: 6 | Last required scheduled payment day: 245 |
Final actual payment count: 71 | Last actual payment day: 475 |
Description
Only one insufficient funds charge per day
Generated: see details
Basic Parameters
Evaluation Date | 2024-03-12 | ||||||||||||||
Start Date | 2020-10-08 | ||||||||||||||
Principal | 500.00 | ||||||||||||||
Schedule options |
|
||||||||||||||
Payment options |
|
||||||||||||||
Fee options |
|
||||||||||||||
Interest options |
|
Advanced Parameters
Payment options |
|
||||||||
Interest options |
|
||||||||
Fee options |
|
||||||||
Charge options |
|
||||||||
Settlement day | n/a | ||||||||
Trim unrequired payments | false |
Initial Schedule
Day | Scheduled payment | Actuarial interest | Interest portion | Principal portion | Interest balance | Principal balance | Total actuarial interest | Total interest | Total principal |
---|---|---|---|---|---|---|---|---|---|
0 | 0.00 | 0.0000 | 0.00 | 0.00 | 0.00 | 1,272.35 | 0.0000 | 0.00 | 0.00 |
8 | 225.00 | 2.7748 | 2.77 | 222.23 | 0.00 | 1,050.12 | 2.7748 | 2.77 | 222.23 |
39 | 225.00 | 8.8742 | 8.87 | 216.13 | 0.00 | 833.99 | 11.6490 | 11.64 | 438.36 |
69 | 225.00 | 6.8204 | 6.82 | 218.18 | 0.00 | 615.81 | 18.4694 | 18.46 | 656.54 |
100 | 225.00 | 5.2040 | 5.20 | 219.80 | 0.00 | 396.01 | 23.6735 | 23.66 | 876.34 |
214 | 250.00 | 12.3067 | 12.30 | 237.70 | 0.00 | 158.31 | 35.9801 | 35.96 | 1,114.04 |
245 | 276.00 | 1.3378 | 1.33 | 274.67 | 0.00 | -116.36 | 37.3180 | 37.29 | 1,388.71 |
Initial Stats
Initial interest balance: 0.00 | Initial cost-to-borrowing ratio: 58.3 % | Initial APR: 257.704 % |
Level payment: 225.00 | Final payment: 276.00 | Last scheduled payment day: 245 |
Total scheduled payments: 1,426.00 | Total principal: 1,388.71 | Total interest: 37.29 |