Header menu logo FSharp.Finance.Personal

InterestFirstTests014

Day Datestamp Advances Scheduled payment Window Payment due Actual payments Net effect Payment status Balance status Actuarial interest New interest Interest portion Principal portion Interest balance Principal balance Settlement figure
0 2023-06-07 200.00 n/a 0 0.00 n/a 0.00 none scheduled open 0.0000 0.0000 0.00 0.00 110.5500 200.00 200.00
3 2023-06-10 n/a original 77.64 1 77.64 n/a 0.00 missed payment open 4.8000 0.0000 0.00 0.00 110.5500 200.00 204.80
33 2023-07-10 n/a original 77.64 2 77.64 n/a 0.00 paid later in full open 48.0000 0.0000 0.00 0.00 110.5500 200.00 252.80
39 2023-07-16 n/a n/a 2 0.00 confirmed 88.00 88.00 extra payment open 9.6000 0.0000 88.00 0.00 22.5500 200.00 174.40
64 2023-08-10 n/a original 77.64 3 77.64 n/a 0.00 missed payment open 40.0000 0.0000 0.00 0.00 22.5500 200.00 214.40
95 2023-09-10 n/a original 77.63 4 77.63 n/a 0.00 missed payment open 49.6000 41.4500 0.00 0.00 64.0000 200.00 264.00
128 2023-10-13 n/a n/a 5 0.00 confirmed 126.00 126.00 extra payment open 48.0000 48.0000 112.00 14.00 0.0000 186.00 186.00
132 2023-10-17 n/a n/a 5 0.00 confirmed 98.00 98.00 extra payment open 0.0000 0.0000 0.00 98.00 0.0000 88.00 88.00
133 2023-10-18 n/a n/a 5 0.00 confirmed 100.00 100.00 extra payment refund due 0.0000 0.0000 0.00 100.00 0.0000 -12.00 -12.00
✓ 429 2024-08-09 n/a n/a 14 0.00 n/a -12.78 generated closed -0.7785 -0.7785 -0.78 -12.00 0.0000 0.00 0.00

Key: ★ = evaluation day; ✓ = settlement day

Final Stats

Generated settlement: -12.78 on day 429 Final balance status: closed
Effective interest rate: 0.2321911422 % per day Final cost-to-borrowing ratio: 99.61 %
Required scheduled payment count: 4 Last required scheduled payment day: 95
Final actual payment count: 4 Last actual payment day: 133

Description

Realistic example 0004ffd74fbb with overpayment

Generated: see details

Basic Parameters

Evaluation Date 2024-08-09
Start Date 2023-06-07
Principal 200.00
Schedule options
config: auto-generate schedule schedule length: payment count 4
unit-period config: monthly from 2023-06 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: add-on
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: 0 day(s) rate on negative balance: 8 % per year
promotional rates: n/a
Fee options no fee
Charge options no charges
Settlement dayn/a
Trim unrequired paymentsfalse

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 110.55 200.00 0.0000 0.00 0.00
3 77.64 4.8000 77.64 0.00 32.91 200.00 4.8000 77.64 0.00
33 77.64 48.0000 32.91 44.73 0.00 155.27 52.8000 110.55 44.73
64 77.64 38.5070 0.00 77.64 0.00 77.63 91.3070 110.55 122.37
95 77.63 19.2522 0.00 77.63 0.00 0.00 110.5592 110.55 200.00

Initial Stats

Initial interest balance: 110.55 Initial cost-to-borrowing ratio: 55.28 % Initial APR: 4168.3 %
Level payment: 77.64 Final payment: 77.63 Last scheduled payment day: 95
Total scheduled payments: 310.55 Total principal: 200.00 Total interest: 110.55

Type something to start searching.