Header menu logo FSharp.Finance.Personal

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
config: custom schedule
day: 8 scheduled payment: original 225.00
day: 39 scheduled payment: original 225.00
day: 69 scheduled payment: original 225.00
day: 100 scheduled payment: original 225.00
day: 214 scheduled payment: original 250.00
day: 245 scheduled payment: original 276.00
Payment options
rounding: rounded up
level-payment option: lower final payment
Fee options
fee type: CAB/CSO fee 154.47 % rounding: rounded down
fee amortisation: amortise proportionately
Interest options
standard rate: 9.95 % per year method: actuarial
rounding: rounded down APR method: US CFPB actuarial to 3 d.p.
cap: total n/a; daily n/a

Advanced Parameters

Payment options
scheduling: as scheduled timeout: 3 days
minimum: defer or write off up to 0.50
Interest options
initial grace period: 3 day(s) rate on negative balance: zero
promotional rates: n/a
Fee options
settlement rebate: pro-rata rebate
Charge options
Type Charge Grouping Holidays
insufficient funds 10.00one charge per dayn/a
Settlement dayn/a
Trim unrequired paymentsfalse

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

Type something to start searching.