The CLO Value Calculator estimates tranche fair value and expected yield using cash flow projections and default, recovery, and prepayment assumptions.
Report an issue
Spotted a wrong result, broken field, or typo? Tell us below and we’ll fix it fast.
What Is a CLO Value Calculator?
A CLO Value Calculator estimates what each tranche of a collateralized loan obligation is worth today. It projects interest and principal cash flows from a pool of leveraged loans. Then it routes those cash flows through the CLO waterfall and discounts them to the present.
The result is a fair value per tranche, plus metrics like discount margin, yield, duration, and sensitivity to defaults or prepayments. The tool also shows how overcollateralization and interest coverage tests influence cash flow timing. With a clear breakdown, you can see which assumptions drive value the most.
Equations Used by the CLO Value Calculator
The calculator relies on bond math plus structured finance rules. It models defaults and prepayments on the collateral. It then applies the waterfall, fees, and triggers to allocate cash to each tranche before discounting.
- Present Value of a Tranche: PV = Σ [E(CF_t) / (1 + r_t)^t], where E(CF_t) is expected cash at time t and r_t is the discount rate.
- Expected Collateral Loss: E(Loss_t) = PD_t × (1 − RR), where PD_t is period default probability and RR is recovery rate.
- Expected Interest Proceeds: E(INT_t) = Collateral Par_t × (Index_t + WAC Spread) × DayCount_t − Fees_t.
- Prepayment Conversion: SMM = 1 − (1 − CPR)^(1/12); Prepaid_t = SMM × Performing Par_{t−1}.
- Discount Margin/Yield: Price = Σ [Coupon Cash_t / (1 + Index_t + DM)^{t}] + Σ [Principal_t / (1 + Index_t + DM)^{t}].
- Coverage Tests: OC = Collateral Par / Tranche Par; IC = Interest Proceeds / Tranche Interest Due; breaches redirect cash per docs.
These equations work together. Losses reduce par, prepayments change timing, and tests can trap interest to pay down seniors. The calculator solves each period, then discounts tranche cash flows. It reports both price and rate metrics like NPV, DM, and yield to maturity or call.
The Mechanics Behind CLO Value
Understanding the flow of money is key. A CLO collects interest and principal from the loan pool. It pays expenses and manager fees, runs coverage tests, and then allocates cash down the capital stack.
- Reinvestment Period: Early years usually reinvest principal into new loans at an assumed spread and quality.
- Waterfall: Senior fees and expenses, senior interest, junior interest, then principal paydowns starting from the top tranche.
- Coverage Tests: If OC or IC tests fail, excess interest may be diverted to pay down senior notes until tests cure.
- Default and Recovery: Defaults reduce par; recoveries arrive after a lag and are often applied as principal proceeds.
- Amortization: After reinvestment ends, principal is used to amortize tranches sequentially unless the docs allow pro rata.
- Call/Refi: Optional or clean-up calls can change horizon and exit price; they must be modeled explicitly.
Value depends on how much and how quickly each tranche gets paid. Senior tranches benefit from diverted cash when tests fail. Mezzanine and equity depend more on reinvestment returns and recovery timing. The waterfall rules tie these outcomes to your inputs.
What You Need to Use the CLO Value Calculator
Gather a small set of facts and assumptions before you run scenarios. You do not need a full trustee report, but accuracy improves with detail. Start with the term sheet and any recent investor reports.
- Tranche details: coupon or spread, day count, payment frequency, and attachment/detachment points.
- Collateral profile: current par, weighted average coupon/spread, and reinvestment spread assumption.
- Default and recovery: annual default rate path or vector, recovery rate, and loss lag.
- Prepayment: CPR or SMM during and after reinvestment, plus any ramp assumptions.
- Discount curve or required return: forward index curve and target discount margin in bps.
- Expenses and fees: senior expenses, manager fee, and incentive fee rules if applicable.
Reasonable ranges help. Annual default rates often range from 1% to 10% depending on credit cycles. Recovery may sit between 40% and 70% for senior secured loans. Edge cases like zero defaults, negative rates, or immediate test breaches are supported, but interpret with care.
Using the CLO Value Calculator: A Walkthrough
Here’s a concise overview before we dive into the key points:
- Select the CLO deal and tranche or set up a custom structure with attachment and detachment points.
- Enter collateral inputs: current par, weighted average spread, and the reinvestment period length.
- Set assumptions for default, recovery, and prepayment, including any stress vectors by year.
- Choose the discount curve or enter a target discount margin for each tranche you value.
- Input fees and expenses, then define coverage test thresholds if not auto-loaded from docs.
- Run the model to generate cash flows, price, yield, DM, and a period-by-period breakdown.
These points provide quick orientation—use them alongside the full explanations in this page.
Example Scenarios
Scenario 1: Senior AAA tranche at 120 bps over term SOFR. Collateral assumptions are 3% annual defaults, 60% recovery, and 8% CPR during reinvestment. Using a forward curve and a 140 bps target DM, the calculator projects $4.20 of interest per $100 annually and rapid amortization once reinvestment ends. The present value per $100 par is 101.8, implying a slight premium to par and a yield close to the index plus DM. What this means: Under moderate credit stress, senior notes remain near or above par, supported by waterfall protection and test-driven deleveraging.
Scenario 2: Equity tranche with a 4-year reinvestment period. Collateral earns index plus 400 bps, defaults average 5% annually, recovery is 55%, and CPR is 6%. After fees, residual cash flows yield an annualized IRR of 13.2% and an expected total multiple of 1.35x over 7 years, assuming no call. If a call at year 5 at 1% premium is modeled, IRR rises to 15.8% but the multiple falls slightly due to shorter duration. What this means: Equity value is highly sensitive to reinvestment spread, call timing, and default paths.
Accuracy & Limitations
The calculator aims for clarity and speed while reflecting common CLO features. Still, every deal has its own footnotes. Your results depend on your inputs, the legal terms, and the market curve you choose.
- Model risk: Simplified default timing or recovery lags can overstate or understate cash flow timing.
- Data quality: Using stale collateral par or misstated fees shifts value materially.
- Path dependency: Coverage test breaches are scenario-dependent and can differ under small changes.
- Market curves: Discount rates and forward indices change daily; snapshot your run date.
- Structural nuances: Reinvestment covenants, trading restrictions, and caps/floors may require custom toggles.
Use the tool for scenario analysis, not a single-point truth. Cross-check against trustee reports, the indenture, and dealer runs. When decisions are large, validate assumptions with independent models.
Units & Conversions
CLO valuation mixes currencies, percentages, bps, and time units. Misreading a unit can move price by points. Use these conversions to translate your inputs and to read outputs consistently.
| From | To | How to convert | Example |
|---|---|---|---|
| Percent (%) | Decimal | Divide by 100 | 5% → 0.05 |
| bps | Percent (%) | Divide by 100 | 150 bps → 1.50% |
| Years | Months | Multiply by 12 | 3 years → 36 months |
| Millions | Dollars | Multiply by 1,000,000 | 1.5 million → $1,500,000 |
| CPR | SMM | SMM = 1 − (1 − CPR)^(1/12) | 6% CPR → ~0.515% SMM |
Read the table left to right to convert an input before entering it. For example, if a dealer quotes 175 bps, enter 1.75% or 0.0175 as needed. Keep units consistent across defaults, recovery, and fees to avoid compounding errors.
Common Issues & Fixes
Most problems come from mismatched inputs or missing structural terms. The calculator flags extreme values and failed tests, but you should still sanity-check the outputs.
- Prices look too high or low: Confirm the discount curve, day count, and payment frequency match the docs.
- Equity cash flows vanish: Check if OC tests breach early; reduce defaults or increase recovery to see sensitivity.
- Waterfall seems wrong: Ensure attachment/detachment and tranche sizes match the capital stack.
- Negative interest periods: Verify floors on index or coupons if the benchmark dips below zero.
When results surprise you, run a baseline with simple, conservative assumptions. Change one input at a time to see which factor drives the move. Save scenarios for easy comparison.
FAQ about CLO Value Calculator
Does the calculator handle floating-rate benchmarks?
Yes. It projects forward coupons using your chosen index curve and any tranche floors, then discounts cash flows using your DM or curve.
Can I model a call or refinancing?
You can set an optional call date and premium. The model will stop cash flows at the call and include the call price in value.
How do I choose a discount margin?
Start with recent dealer quotes for similar tranches, then adjust for liquidity, structure quality, and your default scenario.
Will it reflect coverage test triggers accurately?
It applies standard OC and IC test logic each period. If a deal has custom triggers, enter the thresholds or use a saved template.
Key Terms in CLO Value
Attachment/Detachment Points
The tranche’s loss boundaries as a percent of collateral. Losses hit after the attachment level and end at the detachment level.
Discount Margin
The extra yield over the benchmark required by investors. It is used to discount floating-rate cash flows.
Reinvestment Period
The window when principal proceeds are used to buy new loans. It extends collateral life and impacts equity cash flows.
Overcollateralization Test
A ratio of collateral par to tranche par. If it falls below a threshold, cash is diverted to pay down senior notes.
Interest Coverage Test
A ratio of interest income to interest due. Breaches can redirect interest to protect senior tranches.
Constant Prepayment Rate (CPR)
An annualized rate that measures how fast loans prepay. It converts to a monthly SMM for cash flow timing.
Recovery Rate
The percent of par expected to be recovered after a default. It reduces loss severity in the model.
Weighted Average Life
The time-weighted average to principal repayment. Shorter WAL reduces discounting and price sensitivity.
Sources & Further Reading
Here’s a concise overview before we dive into the key points:
- S&P Global Ratings: CLO Primer
- Moody’s CLO Rating Methodology
- Bank for International Settlements: Collateralized Loan Obligations overview
- CFA Institute: Fixed-Income Mathematics and DCF Concepts
- U.S. SEC: Structured Finance Resources
These points provide quick orientation—use them alongside the full explanations in this page.
Disclaimer: This tool is for educational estimates. Consider professional advice for decisions.