Interest and principal on an irregular first instalment · Calculation guide

Split the first payment using its actual accrual interval.

Calculation guide

Use actual elapsed days and the contract day basis. No intermediate rounding, penalties or compounding.

Interest = principal × APR × days / (100 × day basis); payment first covers interest.

Inputs

Principal outstanding

Example entry 20000 (in the selected currency).

Nominal annual interest rate

Example entry 6 %. Allowed range 0 to 100.

Elapsed days

Example entry 40. Allowed range 0 to 3660. Use whole numbers.

Contractual day basis

Example entry 365. Allowed range 360 to 366. Use whole numbers.

Payment

Example entry 500 (in the selected currency).

Worked example

InputValue
Principal outstanding20,000
Nominal annual interest rate6%
Elapsed days40
Contractual day basis365
Payment500
ResultValue
Interest131.506849
Principal paid368.493151
Remaining principal19,631.506849
Unpaid interest0

Calculation steps

Interest = ((((Principal outstanding × Nominal annual interest rate) × Elapsed days) ÷ 100) ÷ Contractual day basis)

((((20,000 × 6) × 40) ÷ 100) ÷ 365) = 131.506849

Principal paid = min(Principal outstanding, max(0, (Payment − Interest)))

min(20,000, max(0, (500 − 131.506849))) = 368.493151

Remaining principal = (Principal outstanding − Principal paid)

(20,000 − 368.493151) = 19,631.506849

Unpaid interest = max(0, (Interest − Payment))

max(0, (131.506849 − 500)) = 0

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding20,00022,000Interest131.506849144.657534
Nominal annual interest rate6%7%Interest131.506849153.424658
Elapsed days4044Interest131.506849144.657534
Contractual day basis365360Interest131.506849133.333333
Payment500550Principal paid368.493151418.493151
Interest and principal on an irregular first instalment →

Sources