InterestFirstTest011
| 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 |
2024-07-23 |
100.00 |
n/a |
0 |
0.00 |
n/a |
0.00 |
none scheduled |
open |
0.0000 |
0.0000 |
0.00 |
0.00 |
83.8500 |
100.00 |
100.00 |
| 10 |
2024-08-02 |
n/a |
original 36.78 |
1 |
36.78 |
confirmed 1,000.00 |
1,000.00 |
overpayment |
refund due |
8.0000 |
-75.8500 |
8.00 |
992.00 |
0.0000 |
-892.00 |
-892.00 |
| 41 |
2024-09-02 |
n/a |
original 36.78 |
2 |
0.00 |
n/a |
0.00 |
no longer required |
refund due |
-6.0607 |
-6.0607 |
0.00 |
0.00 |
-6.0607 |
-892.00 |
-898.07 |
| 71 |
2024-10-02 |
n/a |
original 36.78 |
3 |
0.00 |
n/a |
0.00 |
no longer required |
refund due |
-5.8652 |
-5.8652 |
0.00 |
0.00 |
-11.9259 |
-892.00 |
-903.93 |
| 102 |
2024-11-02 |
n/a |
original 36.78 |
4 |
0.00 |
n/a |
0.00 |
no longer required |
refund due |
-6.0607 |
-6.0607 |
0.00 |
0.00 |
-17.9866 |
-892.00 |
-909.99 |
| 132 |
2024-12-02 |
n/a |
original 36.73 |
5 |
0.00 |
n/a |
0.00 |
no longer required |
refund due |
-5.8652 |
-5.8652 |
0.00 |
0.00 |
-23.8518 |
-892.00 |
-915.86 |
| ✓ 180 |
2025-01-19 |
n/a |
n/a |
6 |
0.00 |
n/a |
-925.24 |
generated |
closed |
-9.3843 |
-9.3843 |
-33.24 |
-892.00 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -925.24 on day 180 |
Final balance status: closed |
| Effective interest rate: -0.1402222222 % per day |
Final cost-to-borrowing ratio: -25.2400000000 % |
| Required scheduled payment count: 1 |
Last required scheduled payment day: 10 |
| Final actual payment count: 1 |
Last actual payment day: 10 |
Description
Add-on interest method with small loan and massive payment leading to a refund needed
Generated: see details
Basic Parameters
| Evaluation Date |
2025-01-19 |
| Start Date |
2024-07-23 |
| Principal |
100.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 5 |
| unit-period config: monthly from 2024-08 on 02 |
|
| Payment options |
| rounding: rounded up |
| level-payment option: lower final payment |
|
| Fee options |
no fee
|
| Interest options |
| standard rate: 0.8 % per day |
method: add-on |
| 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: 3 days |
| minimum: defer or write off up to 0.50 |
|
| Interest options |
| initial grace period: 0 day(s) |
rate on negative balance: 8 % per year |
| promotional rates: n/a |
|
| Fee options |
no fee
|
| Charge options |
no charges
|
| 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 |
83.85 |
100.00 |
0.0000 |
0.00 |
0.00 |
| 10 |
36.78 |
8.0000 |
36.78 |
0.00 |
47.07 |
100.00 |
8.0000 |
36.78 |
0.00 |
| 41 |
36.78 |
24.8000 |
36.78 |
0.00 |
10.29 |
100.00 |
32.8000 |
73.56 |
0.00 |
| 71 |
36.78 |
24.0000 |
10.29 |
26.49 |
0.00 |
73.51 |
56.8000 |
83.85 |
26.49 |
| 102 |
36.78 |
18.2305 |
0.00 |
36.78 |
0.00 |
36.73 |
75.0305 |
83.85 |
63.27 |
| 132 |
36.73 |
8.8152 |
0.00 |
36.73 |
0.00 |
0.00 |
83.8457 |
83.85 |
100.00 |
Initial Stats
| Initial interest balance: 83.85 |
Initial cost-to-borrowing ratio: 83.85 % |
Initial APR: 3454.3 % |
| Level payment: 36.78 |
Final payment: 36.73 |
Last scheduled payment day: 132 |
| Total scheduled payments: 183.85 |
Total principal: 100.00 |
Total interest: 83.85 |
FSharp.Finance.Personal