# Insurance Portfolio Risk and Return Model Model insurance portfolio returns and risk by matching asset duration to liability duration, managing credit exposure, and forecasting investment income. Stress-test the portfolio against interest rate moves and credit spread widening to support ALM and capital adequacy planning. - Canonical: https://finamodel.com/templates/insurance-portfolio-model - Excel download: https://finamodel.com/templates/insurance-portfolio.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Intermediate - Audiences: Investors & analysts, Credit & risk, Insurance CFOs, Investment officers, Risk managers, Insurance investors - Tags: insurance-portfolio, asset-liability-matching, duration, credit-risk ## Overview This portfolio model manages insurance investment holdings by matching asset duration to liability duration, forecasting investment income, and stress-testing credit and interest rate risk. Build asset allocation across fixed income (government, corporate, MBS), equities, and alternatives; apply duration constraints; and calculate return sensitivity to spread widening, default scenarios, and rate changes. The workbook tracks fixed income holdings by maturity and credit rating, calculates portfolio duration (weighted average time to cash flow), applies duration matching to liability duration (insurers must match long-duration liabilities with assets). Credit risk: default probability assumptions by rating (AAA 0.1%, BBB 1–2%, BB 5–10%), loss-given-default (typically 40–60%), and expected loss by holding. Dividend and interest income forecasts on known coupons and yields. Mark-to-market sensitivity: 1% parallel rate shift impacts portfolio value by duration × 1% (e.g., 5-year duration portfolio loses 5% value if rates rise 100 bps). Used by insurance CFOs, asset liability managers (ALM), and portfolio managers ensuring compliance with prudential ratios (Solvency II in Europe, NAIC in US). The model reveals concentration risk and illiquidity drag: if liabilities are 8-year duration but 30% of assets are 2-year, reinvestment risk persists. Credit spread compression (tightening) benefits mark-to-market but reduces prospective yield. Benchmarks: insurance portfolios typically 60–80% fixed income, 10–20% equities, 10% alternatives; duration matched within ±1 year to liability duration. ## What's included - Asset allocation by category including fixed income, equities, and alternatives - Fixed income holdings across government bonds, corporates, MBS, and structured products - Duration matching to liability duration for interest rate immunization - Credit quality limits and default risk assumptions by rating category - Mark-to-market sensitivity and asset-liability management analysis - Asset allocation by category (fixed income, equities, alternatives) - Fixed income holdings: government, corporate, MBS, structured products - Duration matching to liability duration (for insurers) - Credit quality limits and default risk assumptions - Dividend and interest income forecasts - Mark-to-market sensitivity and ALM (asset-liability management) ## How an Insurance Portfolio Model Links Underwriting and Investment Risk This insurance portfolio model projects a mid-sized P&C insurer over five years, combining underwriting results with an investment overlay. It traces how premium, reserves and capital drive portfolio income, asset-liability matching, stress tests and NAIC RBC. The public template is a values-only preview, so formulas do not recalculate. ### Premium, Reserves and Underwriting Profitability The model builds net earned premium through a waterfall: gross written premium grows at a set rate, ceded premium is deducted at the cession rate, and net written premium is adjusted for the change in unearned premium. - Net incurred losses then equal net earned premium multiplied by the loss ratio, with reinsurance recoveries shown separately. - This keeps the gross and ceded split explicit and avoids double-counting. - A single loss reserve pool, sized as a proportion of net earned premium, drives paid claims from the reserve roll-forward, so reserve growth becomes a natural cash source as the book expands. ### Underwriting Expenses, Depreciation and Debt Costs Underwriting expenses are built as a four-part waterfall: gross commission, less deferred acquisition cost amortisation, giving net commission, plus other underwriting expenses. Total underwriting expenses are the sum of those components, not a separate formula. - The deferred acquisition cost balance rolls forward so that unearned commissions align with unearned premium, and fast growth defers commission relief. Capital expenditure scales with net earned premium, depreciation is charged on opening net PP&E, and interest expense uses the opening debt balance. - Together these drive the combined ratio and net income. ### Investment Portfolio, Income and Asset-Liability Matching The investment overlay allocates the portfolio across eight asset classes, each with a book yield, duration and NAIC charge. - Portfolio-weighted yield and duration feed investment income and the ALM schedule. - Investment income is calculated on opening invested assets to avoid circularity, while the invested asset balance itself is derived upstream from reserves, unearned premium, equity, payables and debt, net of receivables, recoveries, DAC and PP&E. - The ALM schedule compares asset duration with a liability duration weighted across short-tail and long-tail reserves, producing a duration gap and DV01 that quantify interest-rate exposure. ### Stress Testing, Capital Adequacy and Practical Use Stress tests apply parallel rate shocks, credit spread widening and equity drawdowns to portfolio market value, then recalculate post-shock capital adequacy. The capital schedule computes NAIC risk-based capital from asset, reinsurance, reserving and premium risk charges, with TAC divided by authorised control level giving the CAR. - Dividend capacity is capped by both a target CAR and a premium-to-surplus limit. A statutory-to-GAAP bridge reconciles net income and equity. - Practically, the model helps evaluate how underwriting growth, portfolio allocation and liability duration interact with capital adequacy. ## Asset-liability matching Match portfolio duration to liability duration to immunize book value from interest rate changes and ensure adequate reserves over time. ## Credit risk and default scenarios Model portfolio default risk by credit rating, apply loss rates, and stress credit spreads to calculate portfolio resilience in adverse conditions. ## Return and income forecasting Forecast investment income, reinvestment rates, and total return under different interest rate and credit spread scenarios. ## Asset-liability matching Match portfolio duration to liability duration to immunize book value from interest rate changes and ensure adequate reserves over time. ## Credit risk and default scenarios Model portfolio default risk by credit rating, apply loss rates, and stress credit spreads to calculate portfolio resilience in adverse conditions. ## Return and income forecasting Forecast investment income, reinvestment rates, and total return under different interest rate and credit spread scenarios. ## Features - **Asset-liability matching:** Match portfolio duration to liability duration to immunize book value from interest rate changes and ensure adequate reserves. - **Credit risk and default scenarios:** Model portfolio default risk by credit rating, apply loss rates, and stress credit spreads to calculate portfolio resilience. - **Return and income forecasting:** Forecast investment income, reinvestment rates, and total return under different rate and spread scenarios. ## Use cases - **Investment policy framework:** Establish asset allocation, duration, and credit risk guidelines to support underwriting strategy and capital adequacy. - **Interest rate and spread risk management:** Model portfolio sensitivity to rate and credit spread moves to guide hedging and rebalancing decisions. - **Capital adequacy planning:** Forecast investment portfolio returns and asset values to support capital needs and dividend capacity. ## Frequently asked questions ### What is duration matching and why is it important for insurers? Duration matching aligns the interest rate sensitivity of assets with liabilities. When assets and liabilities have similar duration, changes in interest rates have offsetting effects on both sides of the balance sheet, protecting book value. ### What credit quality should an insurance portfolio target? Typical insurance portfolios hold 50-70% investment grade assets. NAIC guidelines often cap below-investment-grade holdings at 10-15% of the total portfolio. ### How do I model reinvestment risk? Model coupons and principal payments reinvesting at forward-looking yields, which are often lower than current yields. Build a ladder or barbell maturity strategy to manage reinvestment schedules. ### Who uses insurance portfolio models? Insurance CFOs, investment officers, risk managers, and insurance investors use these models for investment policy frameworks, hedging decisions, and capital adequacy planning. ### What is ALM in the context of insurance investing? Asset-liability management coordinates investment portfolio decisions with the duration and cash flow profile of insurance liabilities to minimize interest rate risk and ensure claims can be paid when due. ## Related templates - [Bond Trading Model](https://finamodel.com/templates/bond-trading-model) - [Mortgage Portfolio Model](https://finamodel.com/templates/mortgage-portfolio-model) - [Fixed Income Portfolio Model](https://finamodel.com/templates/fixed-income-portfolio-model)