SettlementTest001
| Day |
Datestamp |
Advances |
Scheduled payment |
Window |
Payment due |
Actual payments |
Net effect |
Payment status |
Balance status |
Actuarial interest |
New interest |
Interest portion |
Principal portion |
Interest balance |
Principal balance |
Settlement figure |
| 0 |
2023-11-28 |
250.00 |
n/a |
0 |
0.00 |
n/a |
0.00 |
none scheduled |
open |
0.0000 |
0.0000 |
0.00 |
0.00 |
0.0000 |
250.00 |
250.00 |
| 24 |
2023-12-22 |
n/a |
original 100.53 |
1 |
100.53 |
confirmed 100.53 |
100.53 |
payment made |
open |
48.0000 |
48.0000 |
48.00 |
52.53 |
0.0000 |
197.47 |
197.47 |
| 55 |
2024-01-22 |
n/a |
original 100.53 |
2 |
100.53 |
confirmed 100.53 |
100.53 |
payment made |
open |
48.9726 |
48.9726 |
48.97 |
51.56 |
0.0000 |
145.91 |
145.91 |
| 86 |
2024-02-22 |
n/a |
original 100.53 |
3 |
100.53 |
confirmed 100.53 |
100.53 |
payment made |
open |
36.1857 |
36.1857 |
36.18 |
64.35 |
0.0000 |
81.56 |
81.56 |
| ✓ 112 |
2024-03-19 |
n/a |
n/a |
3 |
0.00 |
n/a |
98.52 |
generated |
closed |
16.9645 |
16.9645 |
16.96 |
81.56 |
0.0000 |
0.00 |
0.00 |
| 115 |
2024-03-22 |
n/a |
original 100.48 |
4 |
0.00 |
n/a |
0.00 |
no longer required |
closed |
0.0000 |
0.0000 |
0.00 |
0.00 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: 98.52 on day 112 |
Final balance status: closed |
| Effective interest rate: 0.5221217391 % per day |
Final cost-to-borrowing ratio: 60.04 % |
| Required scheduled payment count: 3 |
Last required scheduled payment day: 86 |
| Final actual payment count: 3 |
Last actual payment day: 86 |
Description
Final payment due on Friday: what would I pay if I paid it today?
Generated: see details
Basic Parameters
| Evaluation Date |
2024-03-19 |
| Start Date |
2023-11-28 |
| Principal |
250.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 4 |
| unit-period config: monthly from 2023-12 on 22 |
|
| 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: 0 day(s) |
rate on negative balance: zero |
| promotional rates: n/a |
|
| Fee options |
no fee
|
| Charge options |
no charges
|
| Settlement day | n/a |
| Trim unrequired payments | true |
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 |
| 24 |
100.53 |
48.0000 |
48.00 |
52.53 |
0.00 |
197.47 |
48.0000 |
48.00 |
52.53 |
| 55 |
100.53 |
48.9726 |
48.97 |
51.56 |
0.00 |
145.91 |
96.9726 |
96.97 |
104.09 |
| 86 |
100.53 |
36.1857 |
36.18 |
64.35 |
0.00 |
81.56 |
133.1582 |
133.15 |
168.44 |
| 115 |
100.48 |
18.9219 |
18.92 |
81.56 |
0.00 |
0.00 |
152.0802 |
152.07 |
250.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 60.83 % |
Initial APR: 1293.1 % |
| Level payment: 100.53 |
Final payment: 100.48 |
Last scheduled payment day: 115 |
| Total scheduled payments: 402.07 |
Total principal: 250.00 |
Total interest: 152.07 |
FSharp.Finance.Personal