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 valuation | Scheduled principal | Prepaid principal |
|---|---|---|
| 12 | 200 | 100 |
| 24 | 400 | 300 |
| Result | Value |
|---|---|
| Weighted average life (years) | 1.7 |
| Principal collected | 1,000 |
| Prepaid principal collected | 400 |
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 |
|---|---|---|---|---|---|
| Months from valuation (row 1) | 12 | 13 | Weighted average life (years) | 1.7 | 1.725 |
| Scheduled principal (row 1) | 200 | 220 | Weighted average life (years) | 1.7 | 1.686275 |
| Prepaid principal (row 1) | 100 | 110 | Weighted average life (years) | 1.7 | 1.693069 |
