QuoteTest017
| 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 |
2022-11-01 |
1,500.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 |
1,500.00 |
1,500.00 |
| 14 |
2022-11-15 |
n/a |
original 491.53 |
1 |
491.53 |
confirmed 500.00 |
n/a |
500.00 |
overpayment |
open |
168.0000 |
168.0000 |
168.00 |
332.00 |
0.0000 |
1,168.00 |
1,168.00 |
| 44 |
2022-12-15 |
n/a |
original 491.53 |
2 |
483.06 |
confirmed 500.00 |
n/a |
500.00 |
overpayment |
open |
280.3200 |
280.3200 |
280.32 |
219.68 |
0.0000 |
948.32 |
948.32 |
| 75 |
2023-01-15 |
n/a |
original 491.53 |
3 |
474.59 |
confirmed 500.00 |
n/a |
500.00 |
overpayment |
open |
235.1834 |
235.1834 |
235.18 |
264.82 |
0.0000 |
683.50 |
683.50 |
| 106 |
2023-02-15 |
n/a |
original 491.53 |
4 |
466.12 |
confirmed 500.00 |
n/a |
500.00 |
overpayment |
open |
169.5080 |
169.5080 |
169.50 |
330.50 |
0.0000 |
353.00 |
353.00 |
| ✓ 134 |
2023-03-15 |
n/a |
original 491.53 |
5 |
432.07 |
confirmed 500.00 |
-67.93 |
432.07 |
generated |
closed |
79.0720 |
79.0720 |
79.07 |
353.00 |
0.0000 |
0.00 |
0.00 |
Key: ★ = evaluation day; ✓ = settlement day
Final Stats
| Generated settlement: -67.93 on day 134 |
Final balance status: closed |
| Effective interest rate: 0.4637164179 % per day |
Final cost-to-borrowing ratio: 62.14 % |
| Required scheduled payment count: 5 |
Last required scheduled payment day: 134 |
| Final actual payment count: 5 |
Last actual payment day: 134 |
Description
Loan is settled the same day as an overpayment
Generated: see details
Basic Parameters
| Evaluation Date |
2023-03-15 |
| Start Date |
2022-11-01 |
| Principal |
1,500.00 |
| Schedule options |
| config: auto-generate schedule |
schedule length: payment count 5 |
| unit-period config: monthly from 2022-11 on 15 |
|
| 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: 3 days |
| minimum: defer or write off up to 0.50 |
|
| Interest options |
| initial grace period: 3 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 |
1,500.00 |
0.0000 |
0.00 |
0.00 |
| 14 |
491.53 |
168.0000 |
168.00 |
323.53 |
0.00 |
1,176.47 |
168.0000 |
168.00 |
323.53 |
| 44 |
491.53 |
282.3528 |
282.35 |
209.18 |
0.00 |
967.29 |
450.3528 |
450.35 |
532.71 |
| 75 |
491.53 |
239.8879 |
239.88 |
251.65 |
0.00 |
715.64 |
690.2407 |
690.23 |
784.36 |
| 106 |
491.53 |
177.4787 |
177.47 |
314.06 |
0.00 |
401.58 |
867.7194 |
867.70 |
1,098.42 |
| 134 |
491.53 |
89.9539 |
89.95 |
401.58 |
0.00 |
0.00 |
957.6734 |
957.65 |
1,500.00 |
Initial Stats
| Initial interest balance: 0.00 |
Initial cost-to-borrowing ratio: 63.84 % |
Initial APR: 1314.1 % |
| Level payment: 491.53 |
Final payment: 491.53 |
Last scheduled payment day: 134 |
| Total scheduled payments: 2,457.65 |
Total principal: 1,500.00 |
Total interest: 957.65 |
FSharp.Finance.Personal