# Fixed Income Portfolio Model Model a fixed income portfolio with duration management, credit exposure, and yield curve strategy. No ignoring reinvestment risk or the extension risk that lengthens duration in falling rate environments. - Canonical: https://finamodel.com/templates/fixed-income-portfolio-model - Excel download: https://finamodel.com/templates/fixed-income-portfolio.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Intermediate - Audiences: Investors & analysts, Fund managers, Bond managers, Fixed income analysts, Institutional investors, Asset managers - Tags: fixed-income, duration, credit-spread, bond, yield-curve ## Overview A fixed income portfolio model projects the total return on a $50–500 million bond portfolio managed for institutional clients. Holdings are modeled by tranche (government, investment-grade corporate, high-yield corporate, MBS), with coupon income, maturity schedules, credit losses (defaults applied as a percentage of opening values by tranche), and trading activity. The model tracks weighted average duration (interest rate sensitivity) and spread duration (credit sensitivity), allowing the manager to simulate the portfolio's performance across yield curve scenarios: parallel shift, twist, steepening. Portfolio yield is straightforward (coupon income divided by AUM), but total return includes both income and capital gains/losses from price appreciation or depreciation as rates and spreads move. Credit losses (default rate times loss-given-default for each tranche) are modeled separately from market price moves. The model validates that distributions to investors do not exceed net investment income, and tracks the expense ratio (management fees, custody, admin, technology, audit) to ensure it stays within institutional norms (0.15–0.50% of AUM). Critical features include separate modeling of premium/discount amortization (a held-to-maturity bond trading at a premium converges to par, generating a drag on return relative to coupon), rebalancing mechanics, and the interaction of reinvestment rates with market yields. This template is suitable for institutional asset managers, pension funds, and insurance companies managing fixed income mandates. ## What's included - Bond-level data: issuer, coupon, maturity, credit rating, duration, and yield - Portfolio-level metrics: weighted average duration, spread duration, and credit duration - Yield curve positioning: bullet, barbell, and ladder strategies - Credit spread exposure by sector and rating - Scenario and stress testing: parallel shift, twist, and steepening - Bond-level data: issuer, coupon, maturity, credit rating, duration, yield - Portfolio-level metrics: weighted average duration, spread duration, credit duration - Yield curve positioning: bullet, barbell, ladder strategies - Interest rate sensitivity and duration gap analysis - Scenario and stress testing: parallel shift, twist, steepening ## Fixed Income Portfolio Model: How the Template Works This fixed income portfolio model template demonstrates how a portfolio of government, corporate, and mortgage-backed bonds generates income and returns over a multi-year projection. It shows how coupon income, credit losses, expenses, and reinvestment decisions flow together, helping you evaluate the business relationships that drive risk-adjusted performance for an institutional portfolio. ### Operating drivers: income, credit, and cost assumptions The model is built around four revenue sources: coupon income, realised gains or losses on sales, amortisation of purchase premium or discount, and reinvestment at current yields. Coupon income depends on the opening value of each tranche and its coupon rate, while amortisation uses the difference between purchase price and par divided by remaining maturity. - Credit losses arise from annual default rates by tranche multiplied by loss given default, and operating costs include management, custody, administration, and transaction fees. These inputs are set on an Assumptions sheet, so changing yields, default rates, or fee levels directly affects the projected outcome. - The model assumes no leverage and quarterly income distributions. ### Calculation flow: how the schedules connect The portfolio allocation schedule deploys opening capital, new contributions, maturities, and retained income across government, investment-grade corporate, high-yield corporate, and mortgage-backed tranches. It also deducts credit losses from closing values. - The income schedule then applies coupon rates to opening tranche values and adds or subtracts premium/discount amortisation. A separate credit losses schedule calculates gross defaults, applies recovery rates, and produces net losses. - The expense schedule charges fees on opening AUM to avoid circularity, and the cash flow waterfall collects coupon receipts, maturities, new capital, and asset sales, then pays for bond purchases, fees, and distributions. Finally, the portfolio summary aggregates income, losses, and expenses into net investment income and total return. ### Outputs: performance metrics and validation The returns analysis sheet presents period income return, price return, and total return, as well as annualised return, portfolio duration, yield to maturity, weighted average credit quality, and a Sharpe ratio proxy. It also shows attribution between income, credit, and rate effects. - The portfolio summary reports net investment income, realised and unrealised gains, total return in dollars and percentage, income yield, and cumulative return. A checks sheet validates that allocations sum to 100%, cash never goes negative, credit losses do not exceed tranche values, distributions are funded from available income, and the expense ratio stays between 0.10% and 1.00%. - These checks help catch common input errors without needing to trace every formula. ### Practical use: scenario testing and risk awareness You can change reinvestment yields, default rates, or distribution policy to see how the portfolio responds under different rate or credit environments. The model automatically reflects the impact on coupon income, amortisation, and cash available for reinvestment. - It also highlights reinvestment risk and extension risk because falling rates can lead to higher premium amortisation and longer effective durations, while rising rates create unrealised losses. The template is designed for a single portfolio over a five-year horizon with no leverage. - The public download is a values-only preview, so you can review the structure and logic but not edit live formulas. Use it to understand the key relationships before building or customising your own version. ## Duration and convexity analysis Measure portfolio sensitivity to yield changes and convexity effects to understand the range of bond price outcomes across rate scenarios. ## Credit spread and sector concentration Track credit spread exposure by issuer, sector, and rating to manage concentration risk within mandate guidelines. ## Yield curve strategy and positioning Model bullet, barbell, and ladder structures against yield curve scenarios to optimize income and capital return trade-offs. ## Duration and convexity analysis Measure portfolio sensitivity to yield changes and convexity effects to understand the range of bond price outcomes across rate scenarios. ## Credit spread and sector concentration Track credit spread exposure by issuer, sector, and rating to manage concentration risk within mandate guidelines. ## Yield curve strategy and positioning Model bullet, barbell, and ladder structures against yield curve scenarios to optimize income and capital return trade-offs. ## Features - **Duration and convexity analysis:** Measure portfolio sensitivity to yield changes and convexity effects for bond price movements. - **Credit spread and sector analysis:** Track credit spread exposure by issuer, sector, and rating to manage credit risk concentration. - **Yield curve strategy and positioning:** Model bullet (single maturity), barbell (short/long), and ladder strategies against yield curve scenarios. ## Use cases - **Portfolio rebalancing and risk management:** Monitor duration drift and credit concentrations; rebalance to maintain target risk profile. - **Yield curve strategy and rate outlook:** Adjust positioning based on rate expectations: extend duration if rates are expected to fall, shorten if rising. - **Bond selection and relative value:** Compare credit spreads across bonds to identify cheap/rich opportunities and optimize portfolio alpha. ## Frequently asked questions ### What is a fixed income portfolio model? A model that tracks bond holdings, calculates duration and credit exposure at the portfolio level, and stress-tests returns across yield curve scenarios. ### What is bond duration? Duration measures the average time to receive bond cash flows weighted by present value. It approximates the percentage price change for a 1% yield change. ### What is a credit spread? The yield difference between a bond and a risk-free benchmark such as a Treasury, compensating investors for credit and liquidity risk. ### What is convexity? A measure of how bond duration changes as yields move. Positive convexity means price declines decelerate as yields rise, limiting downside in rising rate environments. ### Who uses fixed income portfolio models? Bond managers, fixed income analysts, institutional investors, and asset managers use them for portfolio construction, reporting, and rate strategy decisions. ## Related templates - [Credit Portfolio CDO Model](https://finamodel.com/templates/credit-portfolio-cdo-model) - [Mortgage Portfolio Model](https://finamodel.com/templates/mortgage-portfolio-model) - [Convertible Bond Model](https://finamodel.com/templates/convertible-bond-model)