QuoteTest022
| Day |
Datestamp |
Advances |
Scheduled payment |
Window |
Payment due |
Actual payments |
Generated payment |
Net effect |
Payment status |
Balance status |
New charges |
Charges portion |
Actuarial interest |
New interest |
Interest portion |
Principal portion |
Charges balance |
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 |
n/a |
0.00 |
0.0000 |
0.0000 |
0.00 |
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 |
n/a |
0.00 |
46.0000 |
46.0000 |
46.00 |
26.54 |
0.00 |
0.0000 |
203.46 |
203.46 |
| 53 |
2018-03-28 |
n/a |
original 111.67 |
2 |
111.67 |
72.54 failed (insufficient funds)
confirmed 72.54 |
n/a |
72.54 |
paid later in full |
open |
insufficient funds 7.50 |
7.50 |
45.5750 |
45.5750 |
45.57 |
19.47 |
0.00 |
0.0000 |
183.99 |
183.99 |
| 78 |
2018-04-22 |
n/a |
n/a |
2 |
0.00 |
confirmed 72.54
confirmed 145.07 |
n/a |
217.61 |
extra payment |
open |
n/a |
0.00 |
36.7980 |
36.7980 |
36.79 |
180.82 |
0.00 |
0.0000 |
3.17 |
3.17 |
| 84 |
2018-04-28 |
n/a |
original 111.64 |
3 |
0.00 |
n/a |
n/a |
0.00 |
nothing due |
open |
n/a |
0.00 |
0.1522 |
0.1522 |
0.00 |
0.00 |
0.00 |
0.1522 |
3.17 |
3.32 |
| ✓ 2221 |
2024-03-04 |
n/a |
n/a |
73 |
0.00 |
n/a |
57.51 |
57.51 |
generated |
closed |
n/a |
0.00 |
54.1943 |
54.1943 |
54.34 |
3.17 |
0.00 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: 57.51 on day 2221 |
Final balance status: closed |
| Effective interest rate: 0.0357653231 % per day |
Final cost-to-borrowing ratio: 82.7 % |
| Required scheduled payment count: 3 |
Last required scheduled payment day: 84 |
| Final actual payment count: 5 |
Last actual payment day: 78 |
Description
Generated settlement figure is correct when an insufficient funds penalty is charged for a failed payment
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: 8 % per year |
| promotional rates: n/a |
|
| Fee options |
no fee
|
| Charge options |
| Type |
Charge |
Grouping |
Holidays |
| insufficient funds |
7.50 | one charge per day | n/a |
|
| 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