# Credit Portfolio CDO Model Structure credit default swap portfolios into tranches with stress-tested waterfall payouts. Model correlated defaults across the portfolio, calculate expected loss by tranche, and price spreads for senior, mezzanine, and equity positions. - Canonical: https://finamodel.com/templates/credit-portfolio-cdo-model - Excel download: https://finamodel.com/templates/credit-portfolio-cdo.xlsx - Category: Credit - Model type: Portfolio - Difficulty: Advanced - Audiences: Credit & risk, Fund managers, Structured finance, Credit traders, Risk managers, Underwriters - Tags: Securitization, CDO, Waterfall, Stress testing ## Overview This credit portfolio CDO (Collateralised Debt Obligation) model structures a $500M diversified corporate loan portfolio into senior, mezzanine, and equity tranches, calculates interest cash flow waterfalls, and projects returns for each tranche under base and stress scenarios. It includes default assumptions (1.5–3% annual CDR), recovery rates (60–75% for senior loans), and reinvestment mechanics during the ramp-up period. The model generates interest income from the collateral pool (weighted average coupon 5.5–7.0%), pays management fees, senior-to-equity interest coupons, and equity residual distributions via a priority waterfall. Overcollateralisation (OC) and interest coverage (IC) test triggers divert excess cash to note paydown if the portfolio deteriorates. The model includes a portfolio schedule showing performing par, defaults, recoveries, reinvestment, and closing par; a tranche schedule showing note balances, interest expense per tranche, and principal paydowns; and a waterfall section implementing the priority cascade: trustee fees → senior interest → OC/IC tests → mezzanine tranches (A, B, C in order) → equity residual. Returns sheets calculate equity IRR, MOIC, cumulative distributions, and DPI/RVPI metrics. Output includes covenant compliance flags, detailed loss analysis, and equity cash flow sensitivity to default rate and recovery rate. This model is used by CLO managers building and monitoring credit portfolios; rating agencies evaluating portfolio credit quality and tranche sizing; and equity investors assessing expected returns and downside risk. It addresses the complex priority of payments and covenant mechanics that make CDOs fundamentally different from linear loan models. ## What's included - Credit exposures by counterparty and tenor - Correlation and copula assumptions for default scenarios - Tranching structure: senior, mezzanine, and equity - Attachment and detachment points by tranche - Loss waterfall and yield enhancement by tranche - Tranching structure: senior, mezzanine, equity ## How the Credit Portfolio CDO Model Works: A Template Walkthrough This credit portfolio CDO model template evaluates whether structuring a collateralised debt obligation from a diversified corporate credit portfolio makes sense. It captures correlated defaults, tranche-specific waterfall payouts, and stress-tested spread returns. The underlying model calculates expected loss by tranche and prices senior, mezzanine, and equity positions, allowing assessment of risk-return characteristics for each layer. ### Key Operating Drivers: Portfolio, Defaults, and Tranches The model revolves around a static portfolio of corporate credit assets, typically $500 million in par value, as targeted in this template. Portfolio performance is driven by the weighted average coupon, which for leveraged loans equals a base rate (SOFR) plus a spread, and for high-yield bonds a fixed rate. - Defaults reduce performing par over time, with recovery rates applied to gross defaults to determine net losses. The capital structure is tranched: senior AAA notes (60–65% of capital), mezzanine tranches at progressively higher spreads, and an equity layer (8–12%) that absorbs first losses but receives residual cash flows. - These drivers feed directly into interest income and interest expense calculations. ### Calculation Flow: From Portfolio to Waterfall The model follows a sequential, non-circular flow. Interest income is computed on opening performing par using a base rate plus weighted average spread for collateral. - Defaults and recoveries roll forward the performing par schedule, adjusting for reinvestment during the reinvestment period (years 1–5) or principal paydowns thereafter. Interest due on each tranche is calculated on opening balances at the applicable base rate plus tranche spread. - The waterfall then distributes available interest: trustee and admin fees, senior interest, senior OC/IC tests, mezzanine interest in order of seniority, subordinated management fees, and finally equity residual. Principal proceeds follow a separate waterfall after reinvestment, paying down notes from senior to equity. Overcollateralisation and interest coverage ratios are tested per period, triggering diversion of excess spread to senior note paydown if thresholds are breached. ### Outputs: Returns, Ratios, and Validation Metrics The model generates period-by-period cash flows for each tranche, including interest payments, principal paydowns, and equity distributions. Key outputs include the equity IRR and MOIC, computed from the equity cash flow stream with an initial negative investment and positive periodic distributions. - Overcollateralisation (performing par divided by notes outstanding at or above each tranche) and interest coverage (interest income divided by tranche interest due) are reported per tranche to monitor structural health. Validation checks ensure waterfall integrity, non-negative tranche balances, and sanity bounds for IRR (0–30%) and MOIC (0–5x). - These outputs help assess whether the structure can withstand stress scenarios and deliver the target equity return. ### Practical Use: Stress Testing and Structural Assessment This template is built for evaluating CDO structuring and investment decisions. Users can vary assumptions such as default rates, recovery rates, base rate levels, and tranche spreads to see how each tranche’s risk-return profile changes. - The model explicitly handles stress scenarios by incorporating OC/IC test triggers that divert cash flows to senior notes when thresholds are breached, simulating realistic protective mechanisms. It also distinguishes between reinvestment and amortisation periods, ensuring that principal proceeds are recycled or used to pay down notes appropriately. - The checks sheet flags common pitfalls like negative equity distributions or misordered waterfalls, making the model a practical tool for assessing whether a proposed CDO structure meets return targets under varying credit conditions. ## Correlated default scenarios at scale Run thousands of correlated default scenarios and calculate tranche loss distributions and expected shortfall across the portfolio. ## Rating transition and downgrade modeling Apply rating transition matrices to model probabilistic downgrades and their impact on default probability and expected loss by tranche. ## Spread pricing and tranche valuation Calculate OAS spreads and expected returns by tranche given the simulated loss distribution, supporting secondary market trading and deal pricing. ## Correlated default scenarios at scale Run thousands of correlated default scenarios and calculate tranche loss distributions and expected shortfall across the portfolio. ## Rating transition and downgrade modeling Apply rating transition matrices to model probabilistic downgrades and their impact on default probability and expected loss by tranche. ## Spread pricing and tranche valuation Calculate OAS spreads and expected returns by tranche given the simulated loss distribution, supporting secondary market trading and deal pricing. ## Features - **Monte Carlo scenarios:** Run thousands of correlated default scenarios and calculate tranche loss distributions and expected shortfall. - **Rating transition modeling:** Use rating matrices to model probabilistic downgrades and their impact on default probability. - **Valuation and spread pricing:** Calculate OAS spreads and expected returns by tranche given the loss distribution. ## Use cases - **CDO issuance and underwriting:** Model deal economics and rating agency stress scenarios to size tranches and set pricing. - **Risk monitoring:** Track portfolio concentration, correlation changes, and subordination impacts on each tranche's expected loss. - **Mark-to-market and trading:** Use the model to fair-value tranches and identify trading opportunities in secondary markets. ## Frequently asked questions ### What is a CDO? A CDO (Collateralized Debt Obligation) pools credit exposures and issues tranched notes with different risk and return profiles, where senior tranches absorb losses last. ### What is an attachment point? The attachment point is the portfolio loss level at which a tranche begins to absorb losses. For example, a mezzanine tranche might attach at 5 percent and detach at 10 percent. ### What correlation assumptions should I use? Base correlations on realized values during stress periods. Use 0.3 to 0.5 for investment-grade portfolios and higher values for high-yield or concentrated sectors. ### How do I calculate expected loss by tranche? Run Monte Carlo simulations, sort outcomes by total portfolio loss magnitude, and calculate the mean loss that falls within each tranche band. ### Who uses CDO models? Structured finance teams, credit traders, risk managers, and underwriters use them for CDO issuance, secondary market valuation, and portfolio risk monitoring. ## Related templates - [Collateral Pool Model](https://finamodel.com/templates/collateral-pool-model) - [ABS CLO Model](https://finamodel.com/templates/abs-clo-model) - [Loan Portfolio CDR Model](https://finamodel.com/templates/loan-portfolio-cdr-model)