Calculation guide
Overpayments require separate credit accounting.
I += outstanding principal × annual rate × days / 365. Allocate payment to interest, then principal.
Inputs
Opening date
Enter the calendar date in the date field.
Valuation date
Enter the calendar date in the date field.
Opening unpaid principal
Example entry 1000 (in the selected currency).
Annual simple interest (%)
Example entry 10 %. Allowed range 0 to 100.
Effective date
Enter the calendar date in the date field.
New principal due
Example entry 0 (in the selected currency).
Payment received
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening date | 2025-01-01 |
| Valuation date | 2026-01-01 |
| Opening unpaid principal | 1,000 |
| Annual simple interest (%) | 10% |
Dated charges and payments
| Effective date | New principal due | Payment received |
|---|---|---|
| 2026-01-01 | 0 | 200 |
| Result | Value |
|---|---|
| Closing arrears including interest | 900 |
| Unpaid principal | 900 |
| Unpaid simple interest | 0 |
Interpreting the result
A payment smaller than accrued interest leaves the principal unchanged. Future interest continues to accrue on that principal.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening date | 2025-01-01 | 2025-01-02 | Closing arrears including interest | 900 | 899.726027 |
| Valuation date | 2026-01-01 | 2026-01-02 | Closing arrears including interest | 900 | 900.246575 |
| Opening unpaid principal | 1,000 | 1,100 | Closing arrears including interest | 900 | 1,010 |
| Annual simple interest (%) | 10% | 11% | Closing arrears including interest | 900 | 910 |
| Effective date (row 1) | 2026-01-01 | 2025-12-31 | Closing arrears including interest | 900 | 899.972528 |
| New principal due (row 1) | 0 | 1 | Closing arrears including interest | 900 | 901 |
| Payment received (row 1) | 200 | 220 | Closing arrears including interest | 900 | 880 |
