Early settlement quote reconciliation · Calculation guide

Reconstruct a quoted settlement amount and find the unexplained difference.

Calculation guide

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

Reconstructed payoff = principal + previously accrued interest + per-diem interest × new days + fees − credits.

Inputs

Principal outstanding

Example entry 10000 (in the selected currency).

Previously accrued interest

Example entry 15 (in the selected currency).

Quoted daily interest

Example entry 2 (in the selected currency).

Elapsed days

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

Fees

Example entry 50 (in the selected currency).

Credits applied

Example entry 5 (in the selected currency).

Quoted payoff amount

Example entry 10090 (in the selected currency).

Worked example

InputValue
Principal outstanding10,000
Previously accrued interest15
Quoted daily interest2
Elapsed days10
Fees50
Credits applied5
Quoted payoff amount10,090
ResultValue
Reconstructed settlement10,080
Quote minus reconstruction10

Calculation steps

Reconstructed settlement = ((((Principal outstanding + Previously accrued interest) + (Quoted daily interest × Elapsed days)) + Fees) − Credits applied)

((((10,000 + 15) + (2 × 10)) + 50) − 5) = 10,080

Quote minus reconstruction = (Quoted payoff amount − Reconstructed settlement)

(10,090 − 10,080) = 10

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding10,00011,000Reconstructed settlement10,08011,080
Previously accrued interest1517Reconstructed settlement10,08010,082
Quoted daily interest23Reconstructed settlement10,08010,090
Elapsed days1011Reconstructed settlement10,08010,082
Fees5055Reconstructed settlement10,08010,085
Credits applied56Reconstructed settlement10,08010,079
Quoted payoff amount10,09011,099Quote minus reconstruction101,019
Early settlement quote reconciliation →

Sources