ActualPaymentTest019
| Day |
Datestamp |
Advances |
Scheduled payment |
Window |
Payment due |
Actual payments |
Generated payment |
Net effect |
Payment status |
Balance status |
Actuarial interest |
New interest |
Interest portion |
Principal portion |
Interest balance |
Principal balance |
Settlement figure |
| 0 |
2023-08-20 |
250.00 |
n/a |
0 |
0.00 |
n/a |
n/a |
0.00 |
none scheduled |
open |
0.0000 |
0.0000 |
0.00 |
0.00 |
0.0000 |
250.00 |
250.00 |
| 16 |
2023-09-05 |
n/a |
original 94.83 |
1 |
94.83 |
confirmed 116.00 |
n/a |
116.00 |
overpayment |
open |
32.0000 |
32.0000 |
32.00 |
84.00 |
0.0000 |
166.00 |
166.00 |
| 46 |
2023-10-05 |
n/a |
original 94.83 |
2 |
73.66 |
confirmed 116.00 |
n/a |
116.00 |
overpayment |
open |
39.8400 |
39.8400 |
39.84 |
76.16 |
0.0000 |
89.84 |
89.84 |
| 77 |
2023-11-05 |
n/a |
original 94.83 |
3 |
52.49 |
confirmed 116.00 |
n/a |
116.00 |
overpayment |
refund due |
22.2803 |
22.2803 |
22.28 |
93.72 |
0.0000 |
-3.88 |
-3.88 |
| 107 |
2023-12-05 |
n/a |
original 94.82 |
4 |
0.00 |
confirmed 116.00 |
n/a |
116.00 |
overpayment |
refund due |
0.0000 |
0.0000 |
0.00 |
116.00 |
0.0000 |
-119.88 |
-119.88 |
| ✓ 195 |
2024-03-02 |
n/a |
n/a |
6 |
0.00 |
n/a |
-119.88 |
-119.88 |
generated |
closed |
0.0000 |
0.0000 |
0.00 |
-119.88 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -119.88 on day 195 |
Final balance status: closed |
| Effective interest rate: 0.1930666667 % per day |
Final cost-to-borrowing ratio: 37.65 % |
| Required scheduled payment count: 4 |
Last required scheduled payment day: 107 |
| Final actual payment count: 4 |
Last actual payment day: 107 |
Description
Generated settlement figure is correct
Generated: see details
Basic Parameters
| Evaluation Date |
2024-03-02 |
| Start Date |
2023-08-20 |
| Principal |
250.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 4 |
| unit-period config: monthly from 2023-09 on 05 |
|
| Payment options |
| rounding: rounded up |
| level-payment option: lower final payment |
|
| Fee options |
no fee
|
| Interest options |
| standard rate: 0.8 % per day |
method: actuarial |
| rounding: rounded down |
APR method: UK FCA to 1 d.p. |
| cap: total 100 %; daily 0.8 % |
|
Advanced Parameters
| Payment options |
| scheduling: as scheduled |
timeout: 0 days |
| minimum: no minimum payment |
|
| Interest options |
| initial grace period: 3 day(s) |
rate on negative balance: zero |
| promotional rates: n/a |
|
| Fee options |
no fee
|
| Charge options |
no charges
|
| Settlement day | on evaluation day |
| 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 |
250.00 |
0.0000 |
0.00 |
0.00 |
| 16 |
94.83 |
32.0000 |
32.00 |
62.83 |
0.00 |
187.17 |
32.0000 |
32.00 |
62.83 |
| 46 |
94.83 |
44.9208 |
44.92 |
49.91 |
0.00 |
137.26 |
76.9208 |
76.92 |
112.74 |
| 77 |
94.83 |
34.0405 |
34.04 |
60.79 |
0.00 |
76.47 |
110.9613 |
110.96 |
173.53 |
| 107 |
94.82 |
18.3528 |
18.35 |
76.47 |
0.00 |
0.00 |
129.3141 |
129.31 |
250.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 51.72 % |
Initial APR: 1321.6 % |
| Level payment: 94.83 |
Final payment: 94.82 |
Last scheduled payment day: 107 |
| Total scheduled payments: 379.31 |
Total principal: 250.00 |
Total interest: 129.31 |
FSharp.Finance.Personal