QuoteTest024
| 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-09-02 |
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 |
| 20 |
2023-09-22 |
n/a |
original 97.52 |
1 |
97.52 |
confirmed 200.00 |
n/a |
200.00 |
overpayment |
open |
40.0000 |
40.0000 |
40.00 |
160.00 |
0.0000 |
90.00 |
90.00 |
| 50 |
2023-10-22 |
n/a |
original 97.52 |
2 |
0.00 |
confirmed 200.00 |
n/a |
200.00 |
overpayment |
refund due |
21.6000 |
21.6000 |
21.60 |
178.40 |
0.0000 |
-88.40 |
-88.40 |
| 81 |
2023-11-22 |
n/a |
original 97.52 |
3 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
-0.6006 |
-0.6006 |
0.00 |
0.00 |
-0.6006 |
-88.40 |
-89.01 |
| 111 |
2023-12-22 |
n/a |
original 97.50 |
4 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
-0.5813 |
-0.5813 |
0.00 |
0.00 |
-1.1819 |
-88.40 |
-89.59 |
| ✓ 187 |
2024-03-07 |
n/a |
n/a |
6 |
0.00 |
n/a |
-91.06 |
-91.06 |
generated |
closed |
-1.4725 |
-1.4725 |
-2.66 |
-88.40 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -91.06 on day 187 |
Final balance status: closed |
| Effective interest rate: 0.1260748663 % per day |
Final cost-to-borrowing ratio: 23.58 % |
| Required scheduled payment count: 2 |
Last required scheduled payment day: 50 |
| Final actual payment count: 2 |
Last actual payment day: 50 |
Description
Negative interest should accrue to interest balance not principal balance
Generated: see details
Basic Parameters
| Evaluation Date |
2024-03-07 |
| Start Date |
2023-09-02 |
| Principal |
250.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 4 |
| unit-period config: monthly from 2023-09 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: 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 |
| 20 |
97.52 |
40.0000 |
40.00 |
57.52 |
0.00 |
192.48 |
40.0000 |
40.00 |
57.52 |
| 50 |
97.52 |
46.1952 |
46.19 |
51.33 |
0.00 |
141.15 |
86.1952 |
86.19 |
108.85 |
| 81 |
97.52 |
35.0052 |
35.00 |
62.52 |
0.00 |
78.63 |
121.2004 |
121.19 |
171.37 |
| 111 |
97.50 |
18.8712 |
18.87 |
78.63 |
0.00 |
0.00 |
140.0716 |
140.06 |
250.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 56.02 % |
Initial APR: 1311.3 % |
| Level payment: 97.52 |
Final payment: 97.50 |
Last scheduled payment day: 111 |
| Total scheduled payments: 390.06 |
Total principal: 250.00 |
Total interest: 140.06 |
FSharp.Finance.Personal