QuoteTest021
| 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 |
2018-02-03 |
230.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 |
230.00 |
230.00 |
| 25 |
2018-02-28 |
n/a |
original 111.67 |
1 |
111.67 |
confirmed 72.54 |
n/a |
72.54 |
paid later owing 39.13 |
open |
46.0000 |
46.0000 |
46.00 |
26.54 |
0.0000 |
203.46 |
203.46 |
| 53 |
2018-03-28 |
n/a |
original 111.67 |
2 |
111.67 |
72.54 failed
confirmed 72.54 |
n/a |
72.54 |
paid later in full |
open |
45.5750 |
45.5750 |
45.57 |
26.97 |
0.0000 |
176.49 |
176.49 |
| 78 |
2018-04-22 |
n/a |
n/a |
2 |
0.00 |
confirmed 72.54
confirmed 145.07 |
n/a |
217.61 |
extra payment |
refund due |
35.2980 |
35.2980 |
35.29 |
182.32 |
0.0000 |
-5.83 |
-5.83 |
| 84 |
2018-04-28 |
n/a |
original 111.64 |
3 |
0.00 |
n/a |
n/a |
0.00 |
no longer required |
refund due |
0.0000 |
0.0000 |
0.00 |
0.00 |
0.0000 |
-5.83 |
-5.83 |
| ✓ 2221 |
2024-03-04 |
n/a |
n/a |
73 |
0.00 |
n/a |
-5.83 |
-5.83 |
generated |
closed |
0.0000 |
0.0000 |
0.00 |
-5.83 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -5.83 on day 2221 |
Final balance status: closed |
| Effective interest rate: 0.02483409353 % per day |
Final cost-to-borrowing ratio: 55.16 % |
| Required scheduled payment count: 2 |
Last required scheduled payment day: 53 |
| Final actual payment count: 5 |
Last actual payment day: 78 |
Description
Generated settlement figure is correct
Generated: see details
Basic Parameters
| Evaluation Date |
2024-03-04 |
| Start Date |
2018-02-03 |
| Principal |
230.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 3 |
| unit-period config: monthly from 2018-02 on 28 |
|
| 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 | 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 |
230.00 |
0.0000 |
0.00 |
0.00 |
| 25 |
111.67 |
46.0000 |
46.00 |
65.67 |
0.00 |
164.33 |
46.0000 |
46.00 |
65.67 |
| 53 |
111.67 |
36.8099 |
36.80 |
74.87 |
0.00 |
89.46 |
82.8099 |
82.80 |
140.54 |
| 84 |
111.64 |
22.1861 |
22.18 |
89.46 |
0.00 |
0.00 |
104.9960 |
104.98 |
230.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 45.64 % |
Initial APR: 1306.6 % |
| Level payment: 111.67 |
Final payment: 111.64 |
Last scheduled payment day: 84 |
| Total scheduled payments: 334.98 |
Total principal: 230.00 |
Total interest: 104.98 |
FSharp.Finance.Personal