QuoteTest025
| 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-05-05 |
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 |
| 5 |
2023-05-10 |
n/a |
original 87.68 |
1 |
87.68 |
confirmed 111.00 |
n/a |
111.00 |
overpayment |
open |
10.0000 |
10.0000 |
10.00 |
101.00 |
0.0000 |
149.00 |
149.00 |
| 21 |
2023-05-26 |
n/a |
n/a |
1 |
0.00 |
confirmed 181.01 |
n/a |
181.01 |
extra payment |
refund due |
19.0720 |
19.0720 |
19.07 |
161.94 |
0.0000 |
-12.94 |
-12.94 |
| 36 |
2023-06-10 |
n/a |
original 87.68 |
2 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
-0.0425 |
-0.0425 |
0.00 |
0.00 |
-0.0425 |
-12.94 |
-12.99 |
| 66 |
2023-07-10 |
n/a |
original 87.68 |
3 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
-0.0851 |
-0.0851 |
0.00 |
0.00 |
-0.1276 |
-12.94 |
-13.07 |
| 97 |
2023-08-10 |
n/a |
original 87.67 |
4 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
-0.0879 |
-0.0879 |
0.00 |
0.00 |
-0.2155 |
-12.94 |
-13.16 |
| ✓ 336 |
2024-04-05 |
n/a |
n/a |
11 |
0.00 |
n/a |
-13.84 |
-13.84 |
generated |
closed |
-0.6778 |
-0.6778 |
-0.90 |
-12.94 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -13.84 on day 336 |
Final balance status: closed |
| Effective interest rate: 0.03353571429 % per day |
Final cost-to-borrowing ratio: 11.27 % |
| Required scheduled payment count: 1 |
Last required scheduled payment day: 5 |
| Final actual payment count: 2 |
Last actual payment day: 21 |
Description
Quote with long period of negative interest accruing
Generated: see details
Basic Parameters
| Evaluation Date |
2024-04-05 |
| Start Date |
2023-05-05 |
| Principal |
250.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 4 |
| unit-period config: monthly from 2023-05 on 10 |
|
| 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: 8 % per year |
| promotional rates: n/a |
|
| Fee options |
no fee
|
| Charge options |
no charges
|
| Settlement day | on evaluation day |
| 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 |
| 5 |
87.68 |
10.0000 |
10.00 |
77.68 |
0.00 |
172.32 |
10.0000 |
10.00 |
77.68 |
| 36 |
87.68 |
42.7354 |
42.73 |
44.95 |
0.00 |
127.37 |
52.7354 |
52.73 |
122.63 |
| 66 |
87.68 |
30.5688 |
30.56 |
57.12 |
0.00 |
70.25 |
83.3042 |
83.29 |
179.75 |
| 97 |
87.67 |
17.4220 |
17.42 |
70.25 |
0.00 |
0.00 |
100.7262 |
100.71 |
250.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 40.28 % |
Initial APR: 1301.8 % |
| Level payment: 87.68 |
Final payment: 87.67 |
Last scheduled payment day: 97 |
| Total scheduled payments: 350.71 |
Total principal: 250.00 |
Total interest: 100.71 |
FSharp.Finance.Personal