Weighted Average Life (WAL) is a simple but important measure for any amortizing loan or security. It tells you, on average, how long each dollar of unpaid principal remains outstanding. In other words, WAL answers the question: “When, on average, will I get my principal back?” Unlike duration or simple maturity, WAL looks only at principal repayments (not interest) and weights those repayments by the time they occur.
Why WAL matters
– Credit exposure: A shorter WAL means principal comes back sooner, reducing the period your capital is exposed to credit risk.
– Liquidity and cash-flow matching: WAL helps match asset cash flows to liabilities or projected funding needs.
– Prepayment and reinvestment risk: Sooner principal return increases reinvestment risk (you must reinvest returned principal, possibly at lower rates). For mortgage-backed securities (MBS), WAL is highly sensitive to borrower prepayments.
– Relative comparison: For two otherwise similar bonds, the one with the shorter WAL returns principal faster and is generally preferred by investors who value quicker recovery of principal.
WAL versus related measures
– Maturity: Maturity is the final contractual date of the loan; WAL is the time-weighted average of when principal is repaid and is usually shorter than maturity for amortizing instruments.
– Macaulay duration: Duration accounts for both principal and interest and measures interest-rate sensitivity; WAL only uses principal payments and is a cash-flow timing metric.
How to calculate WAL — step-by-step
Step 1 — Get the principal cash‑flow schedule
Create or obtain an amortization schedule that shows, for each payment date, the amount of principal repaid (ignore interest). For monthly loans, you can aggregate to years (or compute WAL in months).
Step 2 — Choose time units
Decide whether to measure time in years, months, or other units. Be consistent. If you use months, convert later to years by dividing by 12 if desired.
Step 3 — Compute weighted principal repayments
For each payment date t, multiply the principal repayment at t by the time t (e.g., 1 year, 2 years). That gives the “time-weighted principal” for that date.
Step 4 — Sum and divide
WAL = (Sum over all t of t × principal_repayment_t) / (Sum over all t of principal_repayment_t)
Because the denominator is total principal repaid (usually equal to the original principal), the formula gives the time-weighted average time when principal is returned.
Practical Excel tip
If column A contains the times (in years) and column B contains principal repayments, use:
WAL = SUMPRODUCT(A:A, B:B) / SUM(B:B)
Worked example
Suppose a 5-year amortizing instrument repays principal as follows:
– Year 1: $500
– Year 2: $1,500
– Year 3: $4,000
– Year 4: $4,000
– Year 5: $6,000
Total principal repaid = $500 + $1,500 + $4,000 + $4,000 + $6,000 = $16,000
Compute time-weighted principal:
– Year1: 1 × $500 = $500
– Year2: 2 × $1,500 = $3,000
– Year3: 3 × $4,000 = $12,000
– Year4: 4 × $4,000 = $16,000
– Year5: 5 × $6,000 = $30,000
Sum of weighted amounts = $500 + $3,000 + $12,000 + $16,000 + $30,000 = $61,500
WAL = $61,500 / $16,000 = 3.84375 years
Interpretation: On average each dollar of principal is outstanding for about 3.84 years. By the end of ~3.84 years, approximately half the principal has been repaid in aggregate terms.
Adjustments and special cases
1. Monthly schedules
If you use months, compute WAL in months (SUMPRODUCT(months, principal)/SUM(principal)) and convert to years by dividing by 12 if needed.
2. Prepayment and refinancing assumptions
For mortgages and MBS, projected prepayment rates (e.g., CPR or PSA speeds) materially change WAL. To model realistic WAL, create alternative amortization schedules under different prepayment scenarios and compute WAL for each.
3. Callable or sinking-fund features
If the issuer can call outstanding principal or uses a sinking fund, WAL depends on the expected call or sinking schedule. Use expected call timing (or multiple scenarios) to compute an expected WAL.
4. Floating-rate and interest-only first periods
If a security pays interest-only for a period and then amortizes, early principal payments are zero, so WAL will be closer to the amortization start.
Limitations
– WAL ignores interest payments and thus does not measure price sensitivity to interest rates (duration does).
– It is an average—actual cash flows are discrete and may be lumpy; WAL can mask cash-flow concentration at specific dates.
– For securities with uncertain prepayment or call behavior, WAL depends heavily on assumptions, so present multiple scenarios.
How WAL affects investment decisions — practical steps
1. For a target liability date: choose securities whose WAL aligns with when you need principal returned.
2. For credit exposure control: prefer shorter WALs to reduce the period of principal-at-risk, all else equal.
3. For yield tradeoffs: evaluate whether a longer WAL (slower principal return) is compensated by higher yield.
4. For MBS investing: run WAL under multiple prepayment scenarios (e.g., low/medium/high CPR) to understand sensitivity.
5. For portfolio reporting: include WAL alongside duration and maturity to give a fuller picture of cash-flow timing.
Quick checklist to compute WAL reliably
– Obtain a full principal schedule (or generate one using loan terms and an amortization model).
– Decide time units (years/months).
– Use SUMPRODUCT to compute the time-weighted principal sum.
– Divide by total principal to get WAL.
– Run scenario analysis for prepayments, calls, and other contingent events.
– Document assumptions and provide WAL ranges where uncertainty exists.
Bottom line
Weighted Average Life (WAL) is a straightforward, intuitive metric that measures how long principal is outstanding on average. It’s essential for assessing credit exposure, matching cash flows, and comparing amortizing securities. Because WAL focuses solely on principal cash flows, you should use it together with measures like duration, yield, and scenario analysis to make fully informed investment or risk-management decisions.
Source
– Investopedia (overview of weighted average life)
(Continuation — original wording from previous excerpt will not be repeated. Below is new, original content that expands the article with additional sections, examples, practical steps, and a concluding summary.)
Additional sections
Why WAL matters to investors and lenders
– Liquidity and cash‑flow timing: WAL tells you, on average, how long each dollar of principal will remain outstanding. A shorter WAL implies principal is returned sooner, improving liquidity and reducing the time your capital is exposed to risk.
– Credit risk and recovery: Principal repaid earlier reduces exposure to borrower default for that portion of the loan. All else equal, securities with shorter WALs are less sensitive to credit deterioration.
– Price sensitivity and reinvestment risk: WAL is a simple gauge of how quickly principal will be returned (reinvestment risk when payments are received) and complements other measures (e.g., duration) that estimate price sensitivity to interest‑rate changes.
– Portfolio construction and matching: For institutions matching assets and liabilities, WAL helps align expected principal return patterns with future liabilities.
WAL versus related measures
– WAL vs Maturity: Maturity is when the final contractual payment is due. WAL is the average time-weighted principal recovery and typically is less than or equal to maturity for amortizing instruments.
– WAL vs Macaulay Duration: Macaulay duration also weights cash flows by time but weights total cash flows (interest + principal) and discounts them by yield. WAL weights only principal repayments and doesn’t discount.
– WAL vs Modified Duration: Modified duration measures price sensitivity to yield changes; WAL does not measure price sensitivity.
– WAL vs Average Life (sometimes used interchangeably): In many contexts, “average life” means the same as WAL. Clarify definition used in any documentation.
How WAL is used in practice
– Pricing and spread analysis: Investors compare WALs across bonds with similar credit quality and coupons to decide preferred tradeoffs between yield and timing of principal return.
– Risk limits and capital allocation: Asset managers set WAL bands for portfolios to meet duration/cash‑flow targets.
– MBS/ABS analysis: WAL is critical for MBS/ABS because prepayment behavior materially affects when principal returns. Analysts compute WAL under multiple prepayment scenarios.
Practical steps to calculate WAL (step‑by‑step)
1. Identify principal payments and their timing. For an amortizing instrument, determine the principal portion of each payment and the period (express period in years or fractions of years).
2. For each period i, multiply principal payment P_i by the time t_i (in years) until that payment occurs. This yields weighted principal W_i = P_i × t_i.
3. Sum the weighted principals: SumW = Σ W_i.
4. Sum the principal payments (total principal repaid over the horizon): SumP = Σ P_i (this should equal original principal if the schedule includes full repayment).
5. Compute WAL = SumW / SumP.
6. If working with monthly periods, express t_i in years (month number / 12) or compute WAL in months by using month counts consistently.
Formula (compact)
– WAL = (Σ t_i × P_i) / (Σ P_i)
– Where P_i = principal repaid at time t_i and t_i is measured in years (or months, consistent units).
Excel implementation
– If principal payments are in cells B2:B61 and corresponding times in years (e.g., 1/12, 2/12, …) are in A2:A61:
• WAL = SUMPRODUCT(A2:A61, B2:B61) / SUM(B2:B61)
– If you only have total payments and interest portions, compute principal as Payment – Interest for each period and then apply the same formula.
Examples
Example A — Simple amortizing loan (annual principal payments)
Consider a 5‑year amortizing instrument with principal repayments at year-end: Year 1: $2,000; Year 2: $2,500; Year 3: $3,500; Year 4: $4,500; Year 5: $7,500. Total principal = $20,000.
1) Compute weighted amounts:
– Year 1: 1 × 2,000 = 2,000
– Year 2: 2 × 2,500 = 5,000
– Year 3: 3 × 3,500 = 10,500
– Year 4: 4 × 4,500 = 18,000
– Year 5: 5 × 7,500 = 37,500
2) Sum weighted = 73,000. Sum principal = 20,000.
3) WAL = 73,000 / 20,000 = 3.65 years.
Interpretation: On average, each dollar of principal is outstanding for about 3.65 years.
Example B — Fixed‑payment mortgage (monthly amortization)
Loan: $100,000; term = 5 years (60 months); annual interest rate = 6% (monthly rate = 0.5%). Monthly payment (level payment) can be computed, then principal portions extracted.
Quick approach (outline):
1) Compute monthly payment using standard loan formula or Excel PMT function:
• Monthly payment ≈ $1,933.28
2) For the first few months, interest portion is high and principal small; principal portions grow over time.
3) Create principal column P_i for months 1..60, and times t_i in years = month / 12.
4) Compute WAL = SUMPRODUCT(t_i, P_i) / SUM(P_i).
Because a full 60‑month schedule is long, we’ll give the result (computed by constructing the schedule): WAL ≈ 2.6 years.
Meaning: Although the loan matures in 5 years, the average dollar of principal is returned after about 2.6 years due to amortization.
Example C — Effect of prepayments on WAL (mortgage-backed security)
Take the loan from Example B with scheduled WAL ≈ 2.6 years. Now assume a prepayment shock: starting month 13, an extra partial prepayment equal to 10% of the remaining principal is made each year (roughly equivalent to a faster prepayment assumption). With those prepayments, principal returns accelerate and the new WAL might fall to roughly 1.9 years (actual value depends on exact prepayment timing). This shows WAL’s sensitivity to prepayment speeds.
Example D — Bullet bond vs amortizing bond
– Bullet bond: $100,000 principal, 5‑year maturity, interest paid yearly, principal repaid at year 5. Principal payments: Year 5: $100,000. WAL = (5 × 100,000) / 100,000 = 5 years.
– Amortizing bond: $100,000 principal repaid $20,000 each year (years 1–5). Weighted sum = 1×20k + 2×20k + … + 5×20k = 300k. WAL = 300k / 100k = 3 years.
Comparison: The amortizing bond returns principal faster (WAL 3 years) vs bullet (WAL 5 years), reducing exposure to principal risk.
WAL in structured finance (MBS, ABS) and prepayment models
– Prepayment assumptions: For MBS, prepayment models express speed in terms like Constant Prepayment Rate (CPR) or PSA standard. Analysts compute WAL under alternative CPR/PSA scenarios (e.g., 100% PSA, 200% PSA) to capture sensitivity.
– Scenario analysis: Typical reporting provides WAL under multiple speeds (e.g., 0% CPR, 4% CPR, 8% CPR) so investors can see how cash‑flow timing and WAL change with borrower behavior.
– Implication for valuation: Valuing MBS requires discounting projected cash flows; WAL is a helpful summary statistic but full valuation uses discounted cash flows under scenarios.
Limitations and common pitfalls
– Ignoring interest cash flows: WAL focuses on principal only; it does not reflect the timing or amount of interest payments and thus is incomplete for price sensitivity.
– Dependence on assumptions: For instruments subject to prepayment, WAL can change materially with different prepayment assumptions; always check scenario sensitivity.
– Unit consistency: When combining monthly schedules with annual measures, ensure times are consistently expressed (i.e., use years as decimals or use months for all t_i).
– Does not equal duration: Using WAL in place of duration to measure interest rate sensitivity is incorrect.
Practical checklist before using WAL
– Verify the principal schedule: Are interest and principal components identified correctly?
– Choose time units (years/months) and keep consistent.
– For securities with prepayments, define and state the prepayment scenario(s).
– If comparing instruments, ensure you compare WALs computed on the same basis (monthly vs annual, prepayment assumptions).
– Supplement WAL with duration and convexity for interest‑rate risk analysis and with credit analysis for default risk.
Sources and further reading
– Investopedia — Weighted Average Life (WAL):
– FINRA — Bonds: Understanding Bond Basics:
– Mortgage Bankers Association (MBA) materials on prepayment models and PSA benchmark (for MBS analysis).
Concluding summary
Weighted Average Life is a straightforward yet powerful summary metric that measures the average time each dollar of principal is outstanding for an amortizing instrument. It is essential for assessing liquidity, credit exposure, and the timing of principal return, and it plays a central role when analyzing amortizing bonds and structured finance products like MBS and ABS. Compute WAL by weighting each principal repayment by its time and dividing by total principal repaid. Always complement WAL with other measures (duration, scenario analysis for prepayments, and credit metrics) to get a fuller picture of risk and return.