Principal Financial Group logo
Principal Financial Group Financial Model

Insurance Company Financials Example (Free Excel Download)

Principal Financial Group (PFG) is a global financial services company headquartered in Des Moines, Iowa, offering retirement, asset management, and insurance solutions.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a Sum-of-the-Parts (SOTP) equity valuation and statutory capital analysis for an equity research analyst covering Principal Financial Group, evaluating its transition towards higher-return, capital-light fee businesses.

Principal Financial Group (PFG) is a global financial services company headquartered in Des Moines, Iowa, offering retirement, asset management, and insurance solutions. The business is organised into three main segments: Retirement and Income Solutions (RIS, ~45% of operating earnings), Principal Asset Management (PAM, ~35%), and Benefits and Protection (B&P, ~20%). The company operates primarily in the United States, Latin America, and Asia. PFG operates a hybrid business model, transitioning away from capital-intensive life insurance towards asset-light fee-based businesses like asset management and workplace retirement plans. PFG holds a strong competitive position in the small-to-medium business (SMB) retirement market and specialty benefits. In 2023, the company restructured its segments, combining Principal Global Investors and Principal International into the new Principal Asset Management segment, and renaming US Insurance Solutions to Benefits and Protection.

The downloadable Principal Financial Group financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsPrincipal Financial Group financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$14.43B$17.54B$13.67B$16.13B$15.63B
Income before income taxes ​ ​$2.08B$6.06B$738.8M$1.89B$1.42B
Benefits, claims and settlement expenses ​ ​$7.10B$6.37B$7.79B$8.07B$8.56B
Net income$1.76B$4.85B$670.1M$1.60B$1.26B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
-4.2%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
1.5%
Effective tax rate
15.3%
See 8 more
Capex % of revenue
3.0%
Net working capital % of revenue
0.0%
Other assets % of revenue
500.0%
Other liabilities % of revenue
500.0%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
48.6%
Buybacks % of net income
51.0%

How to build a detailed financial model for Principal Financial Group

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

For EACH revenue segment or product line:

Retirement and Income Solutions (RIS)

  • Segment name: Retirement and Income Solutions
  • Revenue driver formula: (Average Account Values x Fee Rate) + (General Account Assets x Net Investment Spread)
  • Historical growth rate: 2-5% net revenue CAGR
  • Key growth levers and headwinds: Pension Risk Transfer (PRT) sales, Workplace Savings recurring deposits, and equity market appreciation; headwinds include spread compression and participant withdrawals.
  • Pricing dynamics: Highly competitive fee environment for recordkeeping; spread income depends on the interest rate environment.
  • Revenue recognition notes: Fee revenues are recognised as services are provided; spread income is recognised over the life of the underlying assets.
  • Seasonality: Q1 typically sees higher payroll-driven deposits; Q4 often sees spikes in PRT transactions.

Principal Asset Management (PAM)

  • Segment name: Principal Asset Management (comprising Investment Management and International Pension)
  • Revenue driver formula: (Average AUM x Management Fee Rate) + Performance Fees
  • Historical growth rate: 4-7% operating revenue growth
  • Key growth levers and headwinds: Institutional flows, retail mutual fund sales, and Latin American pension contributions; headwinds include foreign exchange volatility (especially in Latin America) and active-to-passive shifts.
  • Pricing dynamics: Fee compression in public markets; higher margins maintained in private markets and alternatives.
  • Revenue recognition notes: Management fees accrued monthly based on AUM; performance fees recognised when the performance period ends and hurdles are met.
  • Seasonality: Performance fees heavily skewed to Q4.

Benefits and Protection (B&P)

  • Segment name: Benefits and Protection (comprising Specialty Benefits and Life Insurance)
  • Revenue driver formula: Earned Premiums + Policy Fees
  • Historical growth rate: 4-6% premium growth
  • Key growth levers and headwinds: Employment growth in the SMB sector and wage inflation drive group benefits; headwinds include elevated mortality or morbidity trends.
  • Pricing dynamics: Annual repricing capability in group dental, life, and disability allows for margin protection against inflation.
  • Revenue recognition notes: Premiums recognised pro-rata over the policy term.
  • Seasonality: Q1 often has higher claims in health/dental due to deductible resets.

Cost Structure

Variable Costs / COGS

  • For PAM: Pass-through expenses (sub-advisory fees, commissions) scale linearly with gross revenue.
  • For B&P: Benefits, claims, and settlement expenses (incurred loss ratio typically 56-58%).
  • For RIS: Interest credited to account balances.
  • Gross margin concept is replaced by "Operating revenues less pass-through expenses" (for PAM) and "Net Revenue" (for RIS).

Operating Expenses

  • Compensation and benefits: The largest fixed/semi-fixed cost, heavily tied to headcount and variable performance compensation.
  • IT and capitalised software: Significant ongoing investment in digital platforms for retirement plan participants.
  • Amortisation of Deferred Acquisition Costs (DAC): Capitalised costs of acquiring new insurance/investment contracts, amortised over the expected life of the contracts.
  • Restructuring / one-time charges: Occasional severance and real estate footprint reductions as the company optimises its post-pandemic operating model.

Margin Profile

  • RIS Operating Margin: Pre-tax operating earnings divided by net revenue, typically 38-41%.
  • PAM Operating Margin: Pre-tax operating earnings divided by operating revenues less pass-through expenses, typically 35-37%.
  • B&P Operating Margin: Pre-tax operating earnings divided by premium and fees, typically 15-17%.
  • Margin trend: Expanding across all segments due to disciplined expense management and scale in the asset management business.

Balance Sheet Structure

  • Total assets: Approximately $300 billion.
  • Key asset categories: Separate account assets (client money, ~50% of assets), Fixed maturity securities (backing insurance liabilities, ~30%), Commercial mortgage loans.
  • Goodwill & intangibles: Represents historical acquisitions (e.g., Institutional Retirement & Trust business from Wells Fargo).
  • Working capital profile: Not applicable in the traditional corporate sense. Liquidity is measured by holding company cash and liquid assets (target $800 million).
  • DAC (Deferred Acquisition Costs): Material asset representing upfront commissions and acquisition costs, amortised over time.
  • Liabilities: Separate account liabilities (matching the assets), Future policy benefits (reserves for life and disability claims), Investment contract liabilities.

Capital Expenditure & Investment

  • Capex as % of revenue: Minimal traditional PP&E capex; primarily software development and IT infrastructure.
  • Maintenance capex vs. growth capex: Heavily skewed towards growth (digital portals, cloud migration).
  • Capitalised software: Material component of investing cash flows.
  • M&A pattern: Bolt-on acquirer focused on emerging market pension managers and niche asset management capabilities.
  • Typical acquisition multiple paid: 10-12x EBITDA for asset management bolt-ons.

Debt & Capital Structure

  • Total debt: Approximately $4.0 to $4.5 billion of long-term debt.
  • Leverage ratio: Debt to total capital ratio typically managed around 20-25%.
  • Credit rating: A- range (S&P/Fitch) for the holding company; AA- range for the life insurance subsidiaries.
  • Key debt instruments: Senior notes, junior subordinated notes.
  • Maturity profile: Well-laddered with occasional $300-400 million maturities addressed via cash on hand or refinancing.
  • Interest rate profile: Predominantly fixed-rate senior notes.
  • Covenants: Standard debt-to-capitalisation limits.
  • Share repurchase programme: Highly active; approximately $850 million executed in 2025, with a new $1.5 billion authorisation for 2026.
  • Dividend policy: Target 40% payout ratio on net income; current annualised dividend of $3.20 per share (yielding ~3.5-4.0%).

Cash Flow Characteristics

  • Free Capital Flow (FCF) conversion: 75-85% of non-GAAP operating earnings converted to free capital flow available to the holding company.
  • Major non-cash items: Depreciation, DAC amortisation, unrealised gains/losses on investments, liability remeasurements under LDTI accounting.
  • Statutory vs GAAP cash flows: Dividends from insurance subsidiaries to the holding company are dictated by statutory accounting, not GAAP earnings.
  • Capex intensity: Very low (asset-light model).
  • Cash tax rate: Typically 16-18%, benefiting from tax-advantaged investments and dividend received deductions.

Sheet Structure

  1. Assumptions: Hardcoded drivers for AUM growth, premium growth, loss ratios, fee rates, and capital return targets.
  2. RIS Segment: Account values roll-forward (Beginning + Deposits - Withdrawals + Market Impact = Ending). Calculation of net revenue and pre-tax operating earnings.
  3. PAM Segment: AUM roll-forward by sub-segment (Investment Management, International Pension). Calculation of operating revenues less pass-through expenses and pre-tax operating earnings.
  4. B&P Segment: Premium growth projections, incurred loss ratio calculations, and operating expense ratios to derive pre-tax operating earnings.
  5. Consolidated Income Statement: Aggregation of segment pre-tax operating earnings, deduction of corporate segment losses and interest expense, calculation of non-GAAP operating earnings and GAAP net income.
  6. Balance Sheet: Investment portfolio, separate account assets/liabilities, DAC, policyholder reserves, debt, and equity.
  7. Statutory Capital & Free Capital Flow: Calculation of Risk-Based Capital (RBC), subsidiary dividends to the holding company, and holding company liquidity roll-forward.
  8. Valuation: Sum-of-the-parts (SOTP) applying different P/E multiples to RIS, PAM, and B&P earnings, plus a Dividend Discount Model (DDM) based on free capital flow generation.

Key Financial Relationships

  1. "RIS Pre-Tax Operating Earnings = RIS Net Revenue x RIS Operating Margin (target 40%)"
  2. "PAM Operating Revenues Less Pass-Through = (Average AUM x Average Management Fee Rate) + Performance Fees"
  3. "PAM Pre-Tax Operating Earnings = PAM Operating Revenues Less Pass-Through x PAM Operating Margin (target 36%)"
  4. "B&P Pre-Tax Operating Earnings = B&P Premium and Fees x B&P Operating Margin (target 16-17%)"
  5. "B&P Incurred Claims = B&P Earned Premiums x Incurred Loss Ratio (target 56-58%)"
  6. "Total Segment Pre-Tax Operating Earnings = RIS Earnings + PAM Earnings + B&P Earnings - Corporate Segment Losses"
  7. "Non-GAAP Operating Earnings = Total Segment Pre-Tax Operating Earnings - Income Taxes"
  8. "Free Capital Flow = Non-GAAP Operating Earnings x FCF Conversion Ratio (target 75-85%)"
  9. "Holding Company Cash Ending Balance = Beginning Balance + Free Capital Flow - Dividends Paid - Share Repurchases - Debt Principal Repayments"
  10. "Return on Equity (ROE) = Non-GAAP Operating Earnings / Average Stockholders' Equity (excluding AOCI)"

Cross-Sheet Dependencies

The Assumptions sheet drives the three segment sheets (RIS Segment, PAM Segment, B&P Segment). The outputs of these three sheets feed the Consolidated Income Statement to calculate total operating earnings. The Consolidated Income Statement feeds the Statutory Capital & Free Capital Flow sheet to determine how much cash can be upstreamed to the holding company. The Statutory Capital & Free Capital Flow sheet dictates the share repurchases and dividends, which loop back to the Balance Sheet (reducing equity and cash) and the Consolidated Income Statement (reducing share count for EPS calculations). Circularity risk exists in the share repurchase calculation if buybacks are modelled to occur evenly throughout the year, impacting the average share count and EPS.

Sign Convention

  • Revenues, premiums, and fee income are entered and displayed as positive numbers.
  • Expenses (benefits, claims, operating expenses, interest) are entered as positive numbers and subtracted in subtotals.
  • On the cash flow and capital roll-forward sheets, cash inflows (dividends from subsidiaries) are positive, and cash outflows (share repurchases, common dividends) are negative.
  • Net flows (deposits minus withdrawals) can be positive or negative depending on the period.

Things Most Likely to Go Wrong

  • The company adopted Long-Duration Targeted Improvements (LDTI) accounting in 2023; historical data prior to 2022 is not comparable and must not be mixed with current projections.
  • PAM revenues include significant pass-through expenses (like sub-advisory fees); modelling gross revenue instead of "operating revenues less pass-through expenses" will artificially depress the segment margin.
  • Foreign currency translation heavily impacts the International Pension sub-segment within PAM; the model must separate constant-currency organic growth from FX impacts.
  • B&P loss ratios exhibit seasonality; applying a flat annual loss ratio to quarterly models will miss the Q1 claims spike.
  • Corporate segment earnings are consistently negative (holding company interest and unallocated expenses); failing to deduct this will overstate consolidated earnings.
  • Statutory capital generation does not equal GAAP net income; using GAAP net income to drive share repurchases will result in a liquidity shortfall at the holding company.
  • Performance fees in PAM are highly volatile and skewed to Q4; straight-lining them across quarters will distort quarterly EPS estimates.
  • The AUM roll-forward must account for market appreciation/depreciation, not just net flows; omitting market impact will severely understate future fee revenues in a bull market.

Validation Checks

  • "Risk-Based Capital (RBC) ratio must remain above the 375% target; flag if it drops below this threshold."
  • "Holding company cash should not drop below the $800 million target buffer."
  • "Free Capital Flow conversion must be between 75% and 85% of non-GAAP operating earnings."
  • "Consolidated Return on Equity (ROE) should calculate to 15-17% based on management guidance."
  • "B&P Incurred Loss Ratio should remain within the 56-58% band; flag if underwriting assumptions breach this."
  • "Total capital returned to shareholders (dividends + buybacks) should not exceed Free Capital Flow generated in the period unless holding company cash is drawn down."
  • "Effective tax rate should be 16-18%; flag if it reverts to the statutory 21% rate."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
RIS Net Revenue Growth3.5%Midpoint of management 2-5% guidance
RIS Operating Margin40.0%Based on Q4 2025 actuals
PAM AUM Net Flow Rate2.0%Historical organic growth rate excluding market impact
PAM Operating Margin36.0%Based on 2025 actuals and scale benefits
B&P Premium Growth5.0%Driven by wage inflation and SMB employment trends
B&P Incurred Loss Ratio57.6%Based on 2025 actual underwriting experience
B&P Operating Margin16.5%Midpoint of recent historical performance
Corporate Segment Pre-Tax Loss400$ MillionsAnnualised run-rate for holding company expenses and interest
Effective Tax Rate17.0%Historical average reflecting tax-advantaged investments
FCF Conversion Ratio80.0%Midpoint of 75-85% management target
Annual Share Repurchases850$ MillionsMatches 2025 actual execution
Annual Dividend per Share3.20$Based on Q1 2026 declared dividend of $0.80 per quarter
Target RBC Ratio375%Stated management target for life insurance subsidiaries
Target Holding Co Cash800$ MillionsStated management liquidity buffer
SOTP Multiple - RIS9.0x P/EReflects spread-based and fee-based mix
SOTP Multiple - PAM12.0x P/EReflects capital-light asset management peers
SOTP Multiple - B&P8.5x P/EReflects traditional group benefits peers

Data Sources & Benchmarks

  • SEC EDGAR: Principal Financial Group (PFG) 10-K and 10-Q filings.
  • Investor Relations: PFG Quarterly Financial Supplements (XLS) and Earnings Presentations (crucial for segment-level AUM and net revenue reconciliations).
  • Key peers for benchmarking: Prudential Financial (PRU), MetLife (MET), Voya Financial (VOYA), Ameriprise Financial (AMP).
  • Industry data sources: LIMRA for group benefits and pension risk transfer market data; Morningstar for mutual fund flow data.
  • Consensus estimates source: FactSet or Bloomberg for non-GAAP operating earnings and segment margin consensus.

Sources

Frequently asked

What does Principal Financial Group (PFG) do?+

Principal Financial Group (PFG) is a global financial services company headquartered in Des Moines, Iowa, offering retirement, asset management, and insurance solutions. It operates through three main segments: Retirement and Income Solutions, Principal Asset Management, and Benefits and Protection. The company serves clients primarily in the United States, Latin America, and Asia.

How does Principal Financial Group generate revenue from its Retirement and Income Solutions (RIS) segment?+

Revenue in the Retirement and Income Solutions (RIS) segment is primarily driven by a combination of average account values multiplied by a fee rate, and general account assets multiplied by a net investment spread. Key growth levers include Pension Risk Transfer sales and recurring deposits from Workplace Savings. Q1 typically sees higher payroll-driven deposits, while Q4 often sees spikes in PRT transactions.

What are the key capital expenditure assumptions for Principal Financial Group in the financial model?+

The financial model assumes capital expenditure as 3% of revenue, with a focus on software development and IT infrastructure rather than traditional property, plant, and equipment. This capital is primarily skewed towards growth initiatives such as digital portals and cloud migration. The company also engages in bolt-on acquisitions for emerging market pension managers and niche asset management capabilities.

What valuation methodology is used in the financial model for Principal Financial Group?+

The financial model for Principal Financial Group employs a Sum-of-the-Parts (SOTP) equity valuation methodology. This approach helps an equity research analyst evaluate the company's equity value and its statutory capital structure. The model also provides analysis for the company's transition towards higher-return, capital-light fee businesses.

Can I download an Excel financial model for Principal Financial Group?+

Yes, an Excel financial model for Principal Financial Group is available for download. This model provides a detailed analysis, including a Sum-of-the-Parts equity valuation and statutory capital analysis. It covers a forecast horizon from FY2026 to FY2030.

What is Principal Financial Group's strategy regarding its business model transition?+

Principal Financial Group is actively transitioning its business model away from capital-intensive life insurance towards more asset-light, fee-based businesses. This strategic shift focuses on areas like asset management and workplace retirement plans, aiming for higher returns. The company holds a strong competitive position in the small-to-medium business (SMB) retirement market and specialty benefits.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Insurance Company Financial Models

Browse another company in the same sector.

ACGL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Arch Capital Group logo

Arch Capital Group

Arch Capital Group is a Bermuda-based global provider of specialty property and casualty insurance, reinsurance, and mortgage insurance, dynamically allocating capital across underwriting opportunities.

AFL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Aflac logo

Aflac

Aflac Incorporated is a leading provider of supplemental health and life insurance products, designed to pay cash benefits directly to policyholders for costs not covered by primary health insurance.

AIG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
American International Group logo

American International Group

American International Group (AIG) is a leading global insurance organisation providing property casualty insurance solutions to businesses and individuals in over 200 countries and jurisdictions.

AIZ.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Assurant logo

Assurant

Assurant is a global provider of risk management solutions, protecting consumer purchases such as mobile devices, vehicles, and homes through B2B2C partnerships with brands, telecom providers, and financial institutions.

AJG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Arthur J. Gallagher & Co. logo

Arthur J. Gallagher & Co.

Arthur J.

ALL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Allstate logo

Allstate

The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States.

AON.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Aon logo

Aon

Aon plc is a leading global professional services firm providing a broad range of risk, retirement, and health solutions.

BRK.B.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Berkshire Hathaway logo

Berkshire Hathaway

Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.

Explore more Financial Services financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview