Summary (Key Takeaways)
– The weighted average loan age (WALA) measures the average age (in months or years) of loans in a mortgage pool, where each loan’s age is weighted by its dollar size (either original principal or current remaining principal).
– Investors use WALA to understand seasoning of an MBS pool, to estimate prepayment risk and expected cash‑flow timing, and to help value or hedge mortgage‑backed securities.
– WALA is straightforward to calculate but must be interpreted alongside other metrics (WAM, WAL, WAC, CPR/PSA) because prepayment behavior and rate environments can change the effective life of the pool.
– Source for definitions used here: Investopedia (see reference below).
1. What WALA Measures
– Definition: WALA = the dollar‑weighted average number of months since origination for loans in the MBS pool.
– Units: Typically reported in months; convert to years by dividing by 12.
– Weighting variants: Two common weighting bases are
1. Original/nominal loan balance at issuance (shows average age by original size), and
2. Current remaining principal balance (shows average age of the currently outstanding dollars and is more sensitive to prepayments/amortization).
2. Why WALA Matters
– Seasoning: Older (more seasoned) loans historically exhibit different prepayment patterns than newly originated loans. WALA helps quantify how seasoned the pool is.
– Prepayment risk: Pools with low WALA (younger loans) may have higher early prepayment risk (and thus shorter expected lives when rates fall or loans are refinanced). Conversely, a very high WALA often implies lower incremental prepayment sensitivity, but other factors matter.
– Cash‑flow and valuation: WALA, used with WAC (weighted average coupon), WAM (weighted average maturity), and prepayment assumptions (CPR/PSA), feeds expected‑cash‑flow models used in pricing and hedging.
3. Formula(s) and Calculation
Basic formula (months):
WALA = (Σi (weight_i × age_i_months)) / (Σi weight_i)
Where weight_i = chosen dollar measure (original principal or current remaining principal) for loan i, and age_i_months = months since origination for loan i.
If using remaining balance weights:
WALA = Σi (remaining_balance_i × months_since_origination_i) / Σi (remaining_balance_i)
Convert to years:
WALA_years = WALA_months / 12
4. Worked Numerical Example
Assume three loans in a pool. Ages measured in months since origination
Loan A: original balance $200,000; remaining balance $150,000; age = 24 months
Loan B: original balance $300,000; remaining balance $250,000; age = 12 months
Loan C: original balance $500,000; remaining balance $450,000; age = 36 months
A) Weighted by original balance:
WALA_months = (200,000×24 + 300,000×12 + 500,000×36) / (200,000+300,000+500,000)
= (4,800,000 + 3,600,000 + 18,000,000) / 1,000,000
= 26.4 months → 2.2 years
B) Weighted by remaining balance:
WALA_months = (150,000×24 + 250,000×12 + 450,000×36) / (150,000+250,000+450,000)
= (3,600,000 + 3,000,000 + 16,200,000) / 850,000
= 26.12 months → ≈2.18 years
Note: Differences are often modest but can widen if prepayments/amortization are uneven.
5. WALA vs. Other Metrics
– WALA vs. WAM (Weighted Average Maturity): WALA measures how long loans have existed (age since origination). WAM measures remaining time to maturity (time until loans fully amortize if no prepayments). They are complementary — one measures seasoning, the other remaining life.
– WALA vs. WAL (Weighted Average Life): WAL is the weighted average time until principal is repaid (an expected life measure accounting for scheduled amortization and expected prepayments). WALA does not capture future prepayments — it is a historical/current seasoning statistic.
– WALA, WAC (weighted average coupon), WAM, WAL, CPR/PSA — used together for valuation and prepayment modeling.
6. Practical Steps: How to Calculate WALA (manual and automated)
Step 1 — Gather data:
• For each loan in the pool: origination date, months since origination, original principal (or remaining principal if weighting by current balance), or obtain loan‑level files/servicer reports or the MBS prospectus/REMIC schedule.
Step 2 — Choose weighting basis:
• Decide original balance or current remaining balance depending on purpose (current outstanding-dollar seasoning → remaining balance recommended).
Step 3 — Compute:
• Use the formula: sum(product of weight and age) divided by sum(weights).
• Excel formula (if balances in column B and ages in months in C): =SUMPRODUCT(B:B,C:C)/SUM(B:B)
Step 4 — Convert to years if desired: divide result by 12.
Step 5 — Update regularly:
• Recompute monthly (age increments by 1 month; remaining balance changes due to scheduled amortization and prepayments).
Step 6 — Combine with prepayment models:
• Use WALA as an input to prepayment seasoning curves (e.g., PSA) and cash‑flow models to estimate WAL and price.
Simple Python pseudocode:
balances = [150000,250000,450000] # remaining balances
ages = [24,12,36] # months
WALA_months = sum(b*a for b,a in zip(balances,ages)) / sum(balances)
WALA_years = WALA_months / 12
7. Interpretation and Trading Use
– Higher WALA suggests a pool that is more seasoned. Seasoned pools may exhibit lower marginal prepayments (especially after the initial “teaser” or early‑refinance window), but this is not guaranteed — interest‑rate environment and borrower credit factors dominate.
– Use WALA to compare pools of the same vintage/type: a pool with much lower WALA than peers may carry higher early prepayment risk.
– Combine with WAC/WAM/WAL and prepayment speed assumptions to estimate expected life and duration for hedging.
8. Limitations and Caveats
– WALA is backward-looking (age distribution) and does not itself forecast future prepayments or expected life.
– If weighting by original balance, WALA ignores the current outstanding composition; rapid prepayments can make the outstanding pool substantially different in age profile than the original weights suggest.
– Seasoning patterns can change by loan type, collateral (owner‑occupied vs investor), credit score, occupancy, interest‑rate environment, and loan features (IOs, coupons, prepayment penalties).
– Don’t rely on WALA in isolation — always pair with current remaining balance weighting, prepayment assumptions (CPR/PSA), and other pool characteristics.
9. Quick Checklist for Investors
– Obtain loan‑level or pool summary data (ages, balances, coupons).
– Choose weighting basis and be consistent when comparing pools.
– Calculate WALA monthly and track its trend.
– Use WALA together with WAC, WAM, WAL and prepayment models to estimate expected cash flows and duration.
– Stress test valuations to alternative prepayment scenarios (e.g., +/−100 bps rate shock, different CPR/PSA speeds).
– Document assumptions and any approximation (e.g., using pool‑level summaries vs full loan‑level data).
10. Further Reading / Source
– Investopedia: “Weighted Average Loan Age (WALA)” —
Editor’s note: The following topics are reserved for upcoming updates and will be expanded with detailed examples and datasets.