Analyze bond portfolios, loan books, ETFs, and money market funds. See maturity risk exposure, weighted contributions, and interest rate sensitivity — all in one tool.
Weighted Average Maturity is the average time until portfolio securities mature, weighted by their market value. It converts a complex multi-security portfolio into a single number representing maturity risk.
Portfolio maturity profile — how long your capital is committed. Liquidity horizon — when you can expect principal repayment. Interest rate risk exposure — sensitivity to yield curve movements.
A portfolio with 50% in 2-year bonds and 50% in 10-year bonds has a WAM of approximately 6 years — very different from holding 100% 6-year bonds. WAM tells you the true average time until your portfolio matures, weighted by how much money is in each position.
Identify every bond, loan, MBS, fund, or other security. Record the security name, type, and remaining maturity for each position.
For each security, divide its current market value by the total portfolio value. Weight = Market Value ÷ Total Portfolio. These weights must sum to 100%.
For each security, multiply its portfolio weight by its remaining maturity in years. A 50% weight × 8.5 years = 4.25 weighted years.
Add up all weighted maturity contributions from Step 3. This sum is your portfolio’s Weighted Average Maturity (WAM).
Short WAM (0–2y) = low risk. Medium (2–7y) = balanced. Long (7+y) = high rate sensitivity. Use this to guide allocation decisions.
Enter your security names, market values, and remaining maturities above. The calculator automatically computes portfolio weights, individual contributions, and the final WAM. Toggle Advanced Mode to include coupon rates for deeper analysis.
Fixed income securities maturity profile. Measures how long until coupon-paying bonds reach maturity, weighted by market value. Critical for managing interest rate risk in government and corporate bond portfolios.
Regulatory short-term risk measure. Under SEC Rule 2a-7, money market funds must maintain WAM of 60 days or less. This ensures funds remain highly liquid and low-risk, protecting investors from rate volatility.
Affected by prepayments. MBS maturity is uncertain because homeowners can prepay mortgages early. WAM for MBS portfolios must account for expected prepayment speeds, making it more complex than bond WAM.
Used in banking credit risk analysis. Banks calculate WAM across their lending portfolios (commercial loans, consumer loans, credit lines) to assess maturity mismatch risk between assets and liabilities.
Column A: Market Value
Column B: Remaining Maturity (years)
Column C: Weighted Contribution (=A2*B2/SUM($A$2:$A$10))
Cell D1: =SUMPRODUCT(A2:A10,B2:B10)/SUM(A2:A10)
Low risk, high liquidity. Portfolio matures quickly, limiting exposure to interest rate changes. Ideal for conservative investors and money market regulatory compliance.
Balanced risk-return profile. Moderate exposure to rate movements with reasonable yield potential. Most diversified bond portfolios fall in this range, offering a blend of stability and income.
High interest rate sensitivity. Significant price volatility when rates change. Rewards investors with higher yields but requires active risk management and longer investment horizons.
Higher WAM = higher sensitivity to rate changes. A 1% rate rise causes roughly WAM × 1% price decline. Lower WAM = faster reinvestment cycle — principal returns sooner, allowing reinvestment at new rates.
| Metric | What It Measures | Considers Cash Flows? | Best For |
|---|---|---|---|
| WAM | Weighted time to final maturity | No | Maturity risk, regulatory reporting |
| Duration (Macaulay) | Cash-flow-weighted time to repayment | Yes (all coupons + principal) | Price sensitivity analysis |
| Modified Duration | % price change per 1% rate change | Yes (discounted) | Interest rate risk management |
| WAL (Weighted Avg Life) | Weighted time of principal repayments | Yes (principal only) | Amortizing securities (MBS, ABS) |
| Effective Duration | Duration adjusted for option features | Yes (option-adjusted) | Callable/putable bonds |
WAM ignores interim cash flows (coupons) and only considers final maturity dates. Duration weights all cash flows by their present value, making it a more accurate measure of price sensitivity but more complex to compute.
WAL includes principal repayment schedules (amortization, prepayments), making it shorter than WAM for amortizing securities. For bullet bonds, WAM and WAL are identical because all principal returns at maturity.
Shifting capital between short-term and long-term securities directly changes WAM. Adding long-dated bonds increases WAM; adding T-bills decreases it.
As bond prices fluctuate, market-value weights shift. A sharp price decline in long-term bonds reduces their portfolio weight, lowering WAM even without any trades.
Unexpected prepayments shorten effective maturity. When homeowners refinance mortgages, MBS pool maturity drops, decreasing portfolio WAM.
If issuers call bonds before maturity (typically when rates drop), actual maturity is shorter than stated. This can significantly reduce portfolio WAM unexpectedly.
In loan portfolios, borrower refinancing replaces existing loans with new ones, resetting maturity clocks and typically changing the portfolio’s WAM profile.
WAM naturally decreases as time passes and securities approach maturity. Without new purchases, a portfolio’s WAM declines by approximately 1 year per year.
In rising rate environments, shorten WAM to reduce price declines and accelerate reinvestment at higher rates. In falling rate environments, extend WAM to lock in higher yields and benefit from price appreciation on longer-dated securities.
Central banks use WAM when managing their bond portfolios. The Fed’s “Operation Twist” specifically aimed to change the WAM of Treasury holdings to influence long-term rates without changing the overall portfolio size.
WAM alone cannot immunize a portfolio against rate changes. True immunization requires matching duration (not just maturity) of assets and liabilities. WAM is a necessary but insufficient condition for effective immunization strategies.
In CDOs, CLOs, and ABS, WAM determines tranche characteristics. Senior tranches receive principal first (shorter WAM), while equity tranches receive principal last (longer WAM). WAM is fundamental to structuring and pricing these securities.
Face/par value doesn’t reflect current market prices. A bond trading at 80% of par has less economic weight than one at 110%. Always use current market values for accurate WAM.
Mixing years and months in the same calculation produces nonsensical results. Convert all maturities to the same unit (preferably years) before computing WAM.
Floating-rate securities reset their rates periodically, effectively shortening their interest rate sensitivity. Use the next reset date as maturity for WAM purposes, not the final maturity date.
WAM and duration are related but distinct metrics. WAM measures time to maturity; duration measures price sensitivity. Using them interchangeably leads to incorrect risk assessments.
Weighted Average Maturity (WAM) is the average time until all securities in a portfolio reach maturity, weighted by their market value. It provides a single metric to assess portfolio maturity risk and interest rate exposure.
Multiply each security's market value by its remaining maturity, sum all products, then divide by total portfolio value. WAM = Σ(Market Value × Maturity) ÷ Σ(Market Value).
WAM = Σ(Weight_i × Remaining Maturity_i), where Weight_i = Market Value_i ÷ Total Portfolio Value. Each security's maturity is weighted by its proportion of total portfolio value.
Generally yes. Higher WAM indicates longer average maturity, increasing sensitivity to interest rate changes. However, it may also provide higher yields. The risk depends on your investment horizon and rate outlook.
In money market funds, WAM is regulated by SEC Rule 2a-7 and must not exceed 60 days. It ensures funds maintain short-term, liquid holdings to protect investors from interest rate volatility.
WAM measures weighted time to final maturity without considering coupon payments. Duration (Macaulay or Modified) measures price sensitivity to rate changes and accounts for all cash flows including coupons.
Yes. Use =SUMPRODUCT(ValueRange, MaturityRange) / SUM(ValueRange) in Excel. This multiplies each market value by its maturity and divides by total portfolio value.
Depends on goals: 0-2 years is conservative (low risk), 2-7 years is balanced, 7+ years is aggressive with higher rate sensitivity. Money market funds must stay under 60 days.
No. WAM only considers the time until final maturity, not intermediate coupon payments. For a metric that accounts for all cash flows, use Macaulay Duration.
Market value reflects current economic exposure. Using face value ignores premiums or discounts, leading to inaccurate maturity weighting that doesn't represent the portfolio's actual risk profile.
Portfolio allocation, market value changes, prepayments (MBS/loans), callable bonds, refinancing activity, and the natural passage of time as securities approach maturity.
In bond portfolios, WAM represents the average time until all bonds mature, weighted by market value. It's a key metric for assessing interest rate risk and portfolio characteristics.
No. WAM uses final maturity dates; WAL considers timing of principal repayments including amortization and prepayments. For bullet bonds they're identical; for amortizing securities they differ significantly.
No. Remaining maturity is always zero or positive (securities cannot mature in the past). The minimum WAM is zero, when all securities have already matured.
Higher WAM increases interest rate risk and reduces liquidity but may provide higher yields. Lower WAM reduces rate risk and provides faster reinvestment opportunities at current market rates.
Specialized purpose-built weighted average calculators — each tailored to a specific domain with unique inputs, outputs, and interactive visualizations.