Open calculator ↗

Mortgage pool weighted average life · Calculation guide

Weight each mortgage principal collection by its timing.

Calculation guide

Enter the complete remaining principal collection scenario, including scheduled and prepaid amounts. Interest is excluded. Report life from the valuation date using months divided by twelve.

WAL = Σ(month × principal paid) / (12 × total principal).

Inputs

Months from valuation

Example entry 12. Allowed range 1 to 1200. Use whole numbers.

Scheduled principal

Example entry 200 (in the selected currency).

Prepaid principal

Example entry 100 (in the selected currency).

Worked example

Principal collections

Months from valuationScheduled principalPrepaid principal
12200100
24400300
ResultValue
Weighted average life (years)1.7
Principal collected1,000
Prepaid principal collected400

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Months from valuation (row 1)1213Weighted average life (years)1.71.725
Scheduled principal (row 1)200220Weighted average life (years)1.71.686275
Prepaid principal (row 1)100110Weighted average life (years)1.71.693069
Mortgage pool weighted average life →