InterestFirstTest012
| 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 |
2022-02-28 |
400.00 |
n/a |
0 |
0.00 |
n/a |
0.00 |
none scheduled |
open |
0.0000 |
0.0000 |
0.00 |
0.00 |
333.3200 |
400.00 |
400.00 |
| 32 |
2022-04-01 |
n/a |
original 183.34 |
1 |
183.34 |
n/a |
0.00 |
paid later in full |
open |
102.4000 |
0.0000 |
0.00 |
0.00 |
333.3200 |
400.00 |
502.40 |
| 41 |
2022-04-10 |
n/a |
n/a |
1 |
0.00 |
confirmed 198.40 |
198.40 |
extra payment |
open |
28.8000 |
0.0000 |
198.40 |
0.00 |
134.9200 |
400.00 |
332.80 |
| 62 |
2022-05-01 |
n/a |
original 183.34 |
2 |
168.28 |
n/a |
0.00 |
paid later in full |
open |
67.2000 |
0.0000 |
0.00 |
0.00 |
134.9200 |
400.00 |
400.00 |
| 75 |
2022-05-14 |
n/a |
n/a |
2 |
0.00 |
confirmed 198.40 |
198.40 |
extra payment |
open |
41.6000 |
0.0000 |
134.92 |
63.48 |
0.0000 |
336.52 |
243.20 |
| 93 |
2022-06-01 |
n/a |
original 183.34 |
3 |
153.22 |
n/a |
0.00 |
paid later in full |
open |
48.4589 |
0.0000 |
0.00 |
0.00 |
0.0000 |
336.52 |
291.65 |
| 102 |
2022-06-10 |
n/a |
n/a |
3 |
0.00 |
confirmed 198.40 |
198.40 |
extra payment |
open |
24.2294 |
0.0000 |
0.00 |
198.40 |
0.0000 |
138.12 |
117.48 |
| 109 |
2022-06-17 |
n/a |
n/a |
3 |
0.00 |
confirmed 198.40 |
198.40 |
extra payment |
refund due |
7.7347 |
-12.8970 |
-12.90 |
211.30 |
0.0000 |
-73.18 |
-73.18 |
| 123 |
2022-07-01 |
n/a |
original 183.30 |
4 |
0.00 |
n/a |
0.00 |
no longer required |
refund due |
-0.2246 |
-0.2246 |
0.00 |
0.00 |
-0.2246 |
-73.18 |
-73.41 |
| 137 |
2022-07-15 |
n/a |
n/a |
4 |
0.00 |
confirmed 204.80 |
204.80 |
overpayment |
refund due |
-0.2246 |
-0.2246 |
-0.45 |
205.25 |
0.0000 |
-278.43 |
-278.43 |
| ✓ 893 |
2024-08-09 |
n/a |
n/a |
29 |
0.00 |
n/a |
-324.57 |
generated |
closed |
-46.1355 |
-46.1355 |
-46.14 |
-278.43 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -324.57 on day 893 |
Final balance status: closed |
| Effective interest rate: 0.07666013438 % per day |
Final cost-to-borrowing ratio: 68.46 % |
| Required scheduled payment count: 3 |
Last required scheduled payment day: 93 |
| Final actual payment count: 5 |
Last actual payment day: 137 |
Description
Realistic example 501ac58e62a5
Generated: see details
Basic Parameters
| Evaluation Date |
2024-08-09 |
| Start Date |
2022-02-28 |
| Principal |
400.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 4 |
| unit-period config: monthly from 2022-04 on 01 |
|
| 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 |
333.32 |
400.00 |
0.0000 |
0.00 |
0.00 |
| 32 |
183.34 |
102.4000 |
183.34 |
0.00 |
149.98 |
400.00 |
102.4000 |
183.34 |
0.00 |
| 62 |
183.34 |
96.0000 |
149.98 |
33.36 |
0.00 |
366.64 |
198.4000 |
333.32 |
33.36 |
| 93 |
183.34 |
90.9267 |
0.00 |
183.34 |
0.00 |
183.30 |
289.3267 |
333.32 |
216.70 |
| 123 |
183.30 |
43.9920 |
0.00 |
183.30 |
0.00 |
0.00 |
333.3187 |
333.32 |
400.00 |
Initial Stats
| Initial interest balance: 333.32 |
Initial cost-to-borrowing ratio: 83.33 % |
Initial APR: 1994.6 % |
| Level payment: 183.34 |
Final payment: 183.30 |
Last scheduled payment day: 123 |
| Total scheduled payments: 733.32 |
Total principal: 400.00 |
Total interest: 333.32 |
FSharp.Finance.Personal