Prudential Financial Financial Model
Insurance Company Financials Example (Free Excel Download)
Prudential Financial is a diversified global financial services institution providing life insurance, annuities, retirement-related services, mutual funds, and investment management.
professionals from Deloitte
Used by professionals from
About this model
This model provides a Sum-of-the-Parts valuation and statutory capital generation forecast to help an equity research analyst determine whether Prudential Financial can sustain its 15 percent operating ROE and fund its $2.9 billion annual capital return programme.
Prudential Financial is a diversified global financial services institution providing life insurance, annuities, retirement-related services, mutual funds, and investment management. The business operates through three primary segments: PGIM (Asset Management), US Businesses (Retirement Strategies, Group Insurance, Individual Life), and International Businesses (primarily Japan and emerging markets). The company is actively shifting its business model from capital-intensive traditional variable annuities towards capital-light asset management and fee-based retirement strategies. Prudential holds a dominant competitive position in the US pension risk transfer market and the Japanese life insurance market. Recent strategic actions include the divestiture of traditional variable annuity blocks and the implementation of a voluntary 90-day suspension of new sales in Japan to address employee misconduct in early 2026.
The downloadable Prudential Financial 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 & AssumptionsPrudential Financial financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $71.25B | $56.88B | $53.98B | $70.41B | $60.77B |
| Total benefits and expenses | $61.55B | $61.83B | $50.91B | $67.20B | $56.12B |
| Add: Dividends and undistributed earnings allocated to participating unvested share-based payment awards—Basic | $115.0M | $25.0M | $29.0M | $32.0M | $41.0M |
| Net income | $8.87B | -$1.65B | $2.49B | $2.73B | $3.58B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Prudential Financial
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
PGIM (Asset Management)
- Segment name: PGIM
- Revenue driver formula: Average Assets Under Management x Blended Fee Margin + Incentive Fees
- Historical growth rate: 3 to 5 percent CAGR, heavily dependent on equity and fixed income market appreciation.
- Key growth levers and headwinds: Institutional net flows, retail mutual fund performance, and private credit expansion.
- Pricing dynamics: Highly competitive, with fee compression in public fixed income and equities, offset by higher-margin private alternatives.
- Revenue recognition notes: Asset management fees are recognised over time as services are performed.
- Seasonality: Incentive fees often crystallise in the fourth quarter.
US Businesses
- Segment name: U.S. Businesses
- Revenue driver formula: Earned Premiums + Policy Charges and Fee Income + Net Investment Income
- Historical growth rate: 1 to 3 percent CAGR.
- Key growth levers and headwinds: Jumbo pension risk transfer transactions and fixed annuity sales drive growth, while the run-off of legacy variable annuities acts as a headwind.
- Pricing dynamics: Actuarially priced based on mortality, longevity, and interest rate assumptions.
- Revenue recognition notes: Premiums for traditional life products are recognised when due, whereas universal life and annuity receipts are recorded as deposits (liabilities) rather than revenue.
International Businesses
- Segment name: International Businesses
- Revenue driver formula: Earned Premiums + Net Investment Income (translated to USD)
- Historical growth rate: 2 to 4 percent constant currency CAGR.
- Key growth levers and headwinds: Growth in Brazilian distribution and Japanese retirement products, offset by JPY to USD currency fluctuations and regulatory scrutiny in Japan.
- Pricing dynamics: Highly regulated pricing in Japan with a focus on USD-denominated products sold to Japanese consumers.
- Seasonality: Fourth quarter often sees higher sales volumes in Japan due to year-end tax planning.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Policyholders benefits (death claims, annuity payouts), interest credited to policyholders account balances, and dividends to policyholders.
- Gross margin range: Not applicable in traditional terms; instead, the company targets a net investment spread and an underwriting benefit ratio.
- Key input costs: Mortality experience, longevity experience, and interest rates.
- How COGS scales with revenue: Claims scale with the size of the in-force block and demographic trends, while interest credited scales with account balances and prevailing interest rates.
Operating Expenses
- R&D: Not applicable for life insurance.
- SG&A: General and administrative expenses include employee compensation, technology investments, and distribution commissions.
- Depreciation & Amortisation: Primarily the amortisation of Deferred Policy Acquisition Costs (DAC), which represents capitalised commissions and underwriting costs amortised over the expected life of the policies.
- Stock-Based Compensation: Minimal relative to total revenue, typically less than 1 percent.
- Restructuring / one-time charges: Occasional severance and real estate footprint reduction charges, typically excluded from Adjusted Operating Income.
Margin Profile
- Gross margin, EBITDA margin, operating margin, net margin: The company targets an operating Return on Equity of approximately 15 percent.
- Margin trend: Expanding due to cost-cutting initiatives and a shift towards higher-margin, capital-light businesses.
- Segment-level margins: PGIM operates with a pre-tax margin of roughly 25 to 30 percent, while insurance segments are evaluated on net investment spread and underwriting margins.
Balance Sheet Structure
- Total assets: Approximately $700 billion to $750 billion.
- Key asset categories: Fixed maturities (investment grade corporate and government bonds), commercial mortgage loans, and Separate Account assets.
- Goodwill & intangibles: Represents a small percentage of total assets, primarily related to historical acquisitions in the asset management space.
- Working capital profile: Not a relevant metric for life insurers; liquidity is measured by holding company cash (typically targeted above $3 billion) and highly liquid assets.
- PP&E: Immaterial.
- Right-of-use assets / operating leases: Immaterial relative to the massive investment portfolio.
- Separate Accounts: Assets and liabilities must match exactly, representing funds invested by policyholders where the policyholder bears the investment risk.
Capital Expenditure & Investment
- Capex as % of revenue: Less than 1 percent, primarily internal software development and IT infrastructure.
- Maintenance capex vs. growth capex: Heavily skewed towards technology modernisation and digital distribution platforms.
- Major capex programmes underway or planned: Cloud migration and artificial intelligence underwriting tools.
- Capitalised software / development costs: Material component of the small capex budget.
- M&A pattern: Bolt-on acquisitions in asset management (private credit and wealth management) and reinsurance transactions to offload legacy liabilities.
- Typical acquisition multiple paid: 10x to 12x earnings for asset management bolt-ons.
Debt & Capital Structure
- Total debt: Approximately $20 billion in long-term debt.
- Debt/Capital ratio: Targeted around 25 percent.
- Credit rating: A-range for the holding company, AA-range for the primary insurance operating subsidiaries.
- Key debt instruments: Senior unsecured notes, subordinated debt, and junior subordinated (hybrid) capital securities.
- Maturity profile: Well-laddered with average maturities exceeding 10 years.
- Interest rate profile: Predominantly fixed rate to match long-duration liabilities.
- Covenants: Standard debt-to-capital and minimum net worth covenants.
- Share repurchase programme: Highly active, with $1.0 billion repurchased in 2025.
- Dividend policy: $5.60 annual dividend per share in 2025, representing a yield of approximately 5.6 percent and a payout ratio of roughly 40 percent of Adjusted Operating Income.
Cash Flow Characteristics
- Operating cash flow conversion: Highly variable due to the timing of premium receipts, claim payouts, and investment portfolio turnover.
- Free cash flow margin: Evaluated based on statutory capital generation rather than GAAP free cash flow.
- Major non-cash items that bridge net income to OCF: Amortisation of DAC, depreciation, realised investment gains and losses, and changes in the fair value of market risk benefits.
- Working capital cash flow impact: Irrelevant for this business model.
- Capex intensity: Extremely low.
- Cash tax rate vs. GAAP effective tax rate: Typically aligns closely with the statutory US corporate rate of 21 percent, adjusted for tax-advantaged investments and foreign operations.
Sheet Structure
- Assumptions: Hardcoded drivers for AUM growth, premium growth, investment yields, mortality ratios, and capital return targets.
- PGIM Segment: AUM roll-forward (beginning balance, inflows, outflows, market action), average fee rates, asset management fees, and segment operating expenses.
- US Businesses Segment: Premium revenue, policy charges, net investment income, policyholder benefits, DAC amortisation, and segment Adjusted Operating Income.
- International Businesses Segment: Constant currency premium growth, JPY to USD exchange rate impacts, net investment spread, and segment Adjusted Operating Income.
- Consolidated Income Statement: Aggregation of segment Adjusted Operating Income, reconciliation to GAAP Net Income (adding back realised investment gains and market experience updates), and EPS calculations.
- Balance Sheet: Investment portfolio breakdown, DAC, Separate Account assets, future policy benefits, debt, and equity.
- Statutory Capital & Liquidity: Holding company liquid assets roll-forward, dividends from subsidiaries, holding company expenses, and shareholder distributions.
- Valuation: Sum-of-the-Parts valuation applying a P/E multiple to PGIM and a Price/Book multiple to the insurance segments, alongside a Dividend Discount Model.
Key Financial Relationships
- PGIM Asset Management Fees = Average AUM x Blended Fee Rate
- US Businesses Net Investment Income = Average General Account Assets x Earned Portfolio Yield
- US Businesses Interest Credited = Average Policyholder Account Balances x Average Crediting Rate
- Net Investment Spread = US Businesses Net Investment Income less US Businesses Interest Credited
- International Businesses USD Revenue = JPY Revenue x (Average JPY to USD Exchange Rate)
- Total Segment Adjusted Operating Income = PGIM AOI + US Businesses AOI + International Businesses AOI + Corporate & Other AOI
- GAAP Net Income = Total Segment Adjusted Operating Income + Realised Investment Gains/Losses + Change in Value of Market Risk Benefits
- Operating Return on Equity = Annualised Adjusted Operating Income / Average Adjusted Book Value
- Adjusted Book Value = Total GAAP Equity less Accumulated Other Comprehensive Income and Market Risk Benefit adjustments
- Holding Company Cash Ending Balance = Beginning Balance + Dividends from Subsidiaries less Holding Company Interest Expense less Share Repurchases less Common Dividends
Cross-Sheet Dependencies
The Assumptions sheet drives the AUM roll-forward in the PGIM Segment and the premium growth in the US Businesses Segment and International Businesses Segment. The segment sheets calculate Adjusted Operating Income, which feeds directly into the Consolidated Income Statement. The net investment income lines in the segment sheets depend on the asset balances projected in the Balance Sheet. The Consolidated Income Statement generates GAAP Net Income, which flows into Retained Earnings on the Balance Sheet. The Statutory Capital & Liquidity sheet relies on the segment earnings to estimate subsidiary dividend capacity, which in turn dictates the capacity for share repurchases and dividends that flow back to the Balance Sheet equity accounts. A circularity risk exists if interest expense on new debt is driven by cash shortfalls, which lowers net income and further reduces cash.
Sign Convention
Revenues, premiums, fee income, and investment income are entered and displayed as positive numbers. Expenses, policyholder benefits, interest credited, and DAC amortisation are entered as negative numbers in calculation logic but may be displayed as positive numbers with a subtraction operator in the income statement. Balance sheet assets are positive. Balance sheet liabilities and equity are positive. Cash inflows are positive, and cash outflows are negative.
Things Most Likely to Go Wrong
- Confusing GAAP Net Income with Adjusted Operating Income. The model must explicitly bridge the two, as management and Wall Street value the company on AOI.
- Failing to match Separate Account Assets and Separate Account Liabilities. These must always be exactly equal on the balance sheet.
- Ignoring the impact of the JPY to USD exchange rate. International Businesses revenue and earnings are highly sensitive to the Yen, and the model must include a currency translation mechanism.
- Miscalculating Adjusted Book Value. The model must strip out Accumulated Other Comprehensive Income (AOCI) from GAAP equity to calculate the denominator for Operating ROE.
- Overestimating free cash flow. GAAP operating cash flow is not available for dividends; the model must use statutory dividend capacity from the operating subsidiaries to the holding company.
- Mishandling Deferred Policy Acquisition Costs (DAC). DAC must be capitalised on the balance sheet and amortised through the income statement over the life of the policies.
- Excluding Corporate & Other expenses. Segment AOI does not equal consolidated AOI until holding company interest expense and corporate overhead are deducted.
- Misinterpreting the 2026 Japan sales suspension. The model must reflect a temporary dip in International Businesses sales for the first half of 2026 due to the 90-day voluntary suspension.
Validation Checks
- Separate Account Assets must exactly equal Separate Account Liabilities in every forecast period.
- Total Assets must equal Total Liabilities plus Equity in every period.
- Operating Return on Equity should remain in the 13 to 15 percent range based on management targets.
- Holding company highly liquid assets must not fall below the $3.0 billion minimum target.
- The dividend payout ratio (Common Dividends / Adjusted Operating Income) should remain between 35 and 45 percent.
- PGIM pre-tax operating margin should remain between 25 and 30 percent.
- Debt-to-Capital ratio should remain near the 25 percent target.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| PGIM AUM Growth Rate | 5.0 | % | Aligns with recent historical market appreciation and net inflow trends. |
| PGIM Blended Fee Rate | 35 | bps | Reflects the mix of institutional fixed income and higher-fee retail/alternative assets. |
| US Businesses Premium Growth | 2.0 | % | Steady growth in pension risk transfer offset by individual life run-off. |
| International Premium Growth (Constant Currency) | 4.0 | % | Driven by expansion in Brazilian markets and Japanese retirement products. |
| General Account Investment Yield | 4.5 | % | Reflects the current interest rate environment and portfolio turnover. |
| Policyholder Crediting Rate | 3.0 | % | Average guaranteed and discretionary rates on annuity and universal life blocks. |
| Effective Tax Rate (on AOI) | 20.0 | % | Slightly below the US statutory rate due to tax-advantaged investments. |
| Annual Share Repurchases | 1000 | USD Millions | Matches the 2024 and 2025 actual share repurchase run-rate. |
| Annual Dividend Per Share | 5.60 | USD | Actual 2025 annualised dividend rate following the recent 4 percent increase. |
| Target Holding Company Liquidity | 3000 | USD Millions | Management's stated minimum liquidity buffer at the parent company level. |
| Cost of Equity (Ke) | 9.5 | % | Standard assumption for a large-cap life insurer with moderate market sensitivity. |
| Terminal Price/Adjusted Book Multiple | 1.1 | x | Reflects a 15 percent Operating ROE against a 9.5 percent Cost of Equity. |
Data Sources & Benchmarks
- Where to find this company's filings: SEC EDGAR for Prudential Financial (PRU) 10-K and 10-Q filings, and the Prudential Financial Investor Relations page for quarterly financial supplements.
- Key peers for benchmarking: MetLife (MET), Principal Financial Group (PFG), Aflac (AFL), and Equitable Holdings (EQH).
- Industry data sources: AM Best for statutory insurance data and LIMRA for US life insurance and annuity sales figures.
- Consensus estimates source: FactSet or Bloomberg for Wall Street AOI and EPS estimates.
Sources
- Prudential Financial Q4 2025 Earnings Release and Financial Supplement (prudential.com).
- Prudential Financial Q3 2025 Earnings Call Transcript (fool.com).
- Seeking Alpha: Prudential Financial Valuation and Yield Analysis (seekingalpha.com).
- Prudential Financial Investor Relations Website (prudential.com).
Do more with the Prudential Financial model
Frequently asked
What services does Prudential Financial offer?+
Prudential Financial is a diversified global financial services institution providing life insurance, annuities, retirement-related services, mutual funds, and investment management. The company operates through three primary segments: PGIM (Asset Management), US Businesses, and International Businesses, with a strategic shift towards capital-light asset management and fee-based retirement strategies.
How does Prudential Financial generate its revenue?+
Prudential Financial generates revenue through diverse drivers, including average assets under management and blended fee margins for its PGIM segment, and earned premiums, policy charges, fee income, and net investment income for its US Businesses. Growth is influenced by factors like equity and fixed income market appreciation, institutional net flows, and jumbo pension risk transfer transactions.
What is the assumed revenue growth rate for Prudential Financial in financial models?+
A key assumption for Prudential Financial's revenue growth in financial models is approximately -4.5%. This reflects the company's active shift from capital-intensive traditional variable annuities towards capital-light asset management and fee-based retirement strategies, which impacts overall revenue dynamics.
What is Prudential Financial's capital expenditure profile?+
Prudential Financial's capital expenditure is less than 1 percent of revenue, primarily focused on internal software development and IT infrastructure. This capex is heavily skewed towards technology modernization, cloud migration, and artificial intelligence underwriting tools.
What is the purpose of the financial model for Prudential Financial?+
The financial model for Prudential Financial provides a Sum-of-the-Parts valuation and statutory capital generation forecast. This helps equity research analysts determine whether the company can sustain its 15 percent operating ROE and fund its $2.9 billion annual capital return program.
Can I download an Excel financial model for Prudential Financial?+
Yes, an Excel financial model for Prudential Financial is available for download. This model provides a forecast horizon from FY2026 to FY2030, offering detailed assumptions for analysis.
Have more financial modelling questions? Contact us
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.
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.
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.
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.
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.
Arthur J. Gallagher & Co.
Arthur J.
Allstate
The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States.
Aon
Aon plc is a leading global professional services firm providing a broad range of risk, retirement, and health solutions.
Berkshire Hathaway
Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.
Explore more Financial Services financial model templates.
