# Prudential Financial (PRU) Financial Model Free Excel 3-statement financial model and company analysis for Prudential Financial. - Canonical: https://finamodel.com/companies/prudential-financial - Industry: Insurance - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/PRU.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded drivers for AUM growth, premium growth, investment yields, mortality ratios, and capital return targets. 2. **PGIM Segment**: AUM roll-forward (beginning balance, inflows, outflows, market action), average fee rates, asset management fees, and segment operating expenses. 3. **US Businesses Segment**: Premium revenue, policy charges, net investment income, policyholder benefits, DAC amortisation, and segment Adjusted Operating Income. 4. **International Businesses Segment**: Constant currency premium growth, JPY to USD exchange rate impacts, net investment spread, and segment Adjusted Operating Income. 5. **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. 6. **Balance Sheet**: Investment portfolio breakdown, DAC, Separate Account assets, future policy benefits, debt, and equity. 7. **Statutory Capital & Liquidity**: Holding company liquid assets roll-forward, dividends from subsidiaries, holding company expenses, and shareholder distributions. 8. **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 1. PGIM Asset Management Fees = Average AUM x Blended Fee Rate 2. US Businesses Net Investment Income = Average General Account Assets x Earned Portfolio Yield 3. US Businesses Interest Credited = Average Policyholder Account Balances x Average Crediting Rate 4. Net Investment Spread = US Businesses Net Investment Income less US Businesses Interest Credited 5. International Businesses USD Revenue = JPY Revenue x (Average JPY to USD Exchange Rate) 6. Total Segment Adjusted Operating Income = PGIM AOI + US Businesses AOI + International Businesses AOI + Corporate & Other AOI 7. GAAP Net Income = Total Segment Adjusted Operating Income + Realised Investment Gains/Losses + Change in Value of Market Risk Benefits 8. Operating Return on Equity = Annualised Adjusted Operating Income / Average Adjusted Book Value 9. Adjusted Book Value = Total GAAP Equity less Accumulated Other Comprehensive Income and Market Risk Benefit adjustments 10. 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). --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/prudential-financial/forecast)