Aflac logo
Aflac Financial Model

Insurance Company Financials Example (Free Excel Download)

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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model evaluates the equity valuation and statutory capital generation of Aflac Incorporated, focusing on the impact of USD/JPY exchange rate fluctuations, segment-level benefit ratios, and investment portfolio yields to determine the company's capacity for share repurchases and dividend growth.

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. The company operates a dual-engine business model, collecting recurring premiums and investing the float in a massive portfolio of fixed-income securities.

  • Business Segments: Aflac Japan (~54% of total revenues), Aflac U.S. (~39% of total revenues), and Other/Corporate (~7%).
  • Key Geographies: Japan and the United States.
  • Business Model Type: Asset-heavy financial institution (insurance underwriter and investment manager).
  • Competitive Position: The undisputed leader in cancer and medical insurance in Japan (in terms of policies in force) and the #1 provider of supplemental health insurance in the U.S.
  • Recent Major Events: Transitioned to the Long-Duration Targeted Improvements (LDTI) accounting standard in 2023, which fundamentally changed the presentation of deferred profit liabilities and deferred acquisition costs. The company has also faced top-line headwinds in Japan due to limited-pay products reaching paid-up status.

The downloadable Aflac 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 & AssumptionsAflac financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$21.55B$19.14B$18.70B$18.93B$17.16B
Total acquisition and operating expenses$6.21B$5.75B$5.23B$5.06B$5.34B
Total benefits and expenses$16.78B$14.90B$13.44B$12.51B$12.63B
Net income$4.23B$4.42B$4.66B$5.44B$3.65B

Forecast assumptions

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

Revenue growth
-4.3%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.9%
D&A % of revenue
0.2%
Effective tax rate
16.0%
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
489.1%
Annual debt paydown
0.0%
Interest rate on debt
4.5%
Dividend payout ratio
20.5%
Buybacks % of net income
50.1%

How to build a detailed financial model for Aflac

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

Revenue Deep Dive

Aflac Japan

  • Segment Name: Aflac Japan
  • Revenue Driver Formula: (Policies in Force x Average Premium per Policy) + Net Investment Income + Realised Investment Gains/Losses
  • Historical Growth Rate: -1% to -3% CAGR (in USD terms, heavily impacted by the weak Yen and paid-up policies).
  • Key Growth Levers and Headwinds: Aging Japanese population driving demand for third-sector products (cancer, medical), offset by a weak Yen and legacy limited-pay life products reaching premium paid-up status (meaning no new premiums are collected, though coverage remains).
  • Pricing Dynamics: Highly regulated, actuarially determined pricing based on morbidity and mortality tables.
  • Revenue Recognition Notes: Premiums are recognised as earned over the premium-paying periods of the contracts.
  • Seasonality: Generally stable, though Q1 often sees higher sales campaigns in Japan aligning with the corporate fiscal year.

Aflac U.S.

  • Segment Name: Aflac U.S.
  • Revenue Driver Formula: (New Annualised Premium Sales + Renewal Premiums) + Net Investment Income
  • Historical Growth Rate: 2% to 4% CAGR.
  • Key Growth Levers and Headwinds: Penetration of the small business market, digital sales platforms, and expansion into dental/vision. Headwinds include employment levels and wage inflation affecting voluntary benefit uptake.
  • Pricing Dynamics: Competitive voluntary benefits market; pricing is set at the employer group or individual level.
  • Revenue Recognition Notes: Earned premiums recognised pro-rata over the policy period.
  • Seasonality: Q4 is historically the strongest quarter for sales due to the U.S. open enrolment period.

Cost Structure

Variable Costs / COGS (Benefits and Claims)

  • Line-by-line breakdown: Benefits and claims (payouts for cancer treatments, accidents, hospital stays), Reserve remeasurement gains/losses.
  • Gross Margin Range: In insurance, this is viewed via the "Benefit Ratio" (Benefits / Net Earned Premiums). Aflac Japan typically runs a 60-63% benefit ratio; Aflac U.S. runs a 48-52% benefit ratio.
  • Key Input Costs: Morbidity rates, healthcare inflation, and mortality rates.
  • Scaling: Scales linearly with earned premiums, though frequency/severity of claims can cause quarterly volatility.

Operating Expenses (Acquisition and Operating)

  • Amortisation of DAC: Deferred Acquisition Costs (commissions and underwriting costs) amortised over the life of the policies.
  • Insurance Commissions: Paid to agents, brokers, and corporate partners (e.g., Japan Post).
  • Insurance Expenses: SG&A, headcount, IT infrastructure, and marketing.
  • Expense Ratios: Aflac Japan targets an expense ratio of 20-23%. Aflac U.S. targets an expense ratio of 36-39%.

Margin Profile

  • Pretax Margin: Typically 20-25% on a consolidated basis.
  • Net Margin: 18-22%, heavily skewed by realised investment gains/losses in any given year.
  • Margin Trend: Stable operating margins, though reported GAAP margins fluctuate wildly based on derivative mark-to-market and FX translation.

Balance Sheet Structure

  • Total Assets: Approximately $130B - $150B.
  • Key Asset Categories: Fixed maturity securities (corporate bonds, government bonds), Equity securities, Deferred Acquisition Costs (DAC).
  • Goodwill & Intangibles: Minimal (less than 2% of assets), as Aflac is primarily an organic grower.
  • Working Capital Profile: N/A for life/health insurance. The focus is on the investment portfolio duration matching the liability duration.
  • Liabilities: Future policy benefits (reserves for future claims), Unpaid policy claims, Deferred profit liability (DPL).
  • PP&E: Immaterial.

Capital Expenditure & Investment

  • Capex as % of Revenue: Less than 1% (primarily IT and digital platform investments).
  • Maintenance vs. Growth: Almost entirely IT infrastructure and digital sales tools.
  • Investment Portfolio: The true "capital allocation" engine. Aflac invests billions annually into fixed income, private credit, and middle-market loans to generate yield.
  • M&A Pattern: Rare bolt-on acquisitions (e.g., Argus for dental/vision), but primarily an organic business.

Debt & Capital Structure

  • Total Debt: Approximately $7B - $8B.
  • Debt/Capitalisation Ratio: Typically 20-25% (conservative for the sector).
  • Credit Rating: A- to A+ range (S&P/Moody's).
  • Key Debt Instruments: Yen-denominated senior notes (used as a natural hedge against the Japan business), USD senior notes.
  • Interest Rate Profile: Largely fixed-rate debt to match long-duration assets.
  • Share Repurchase Programme: Highly active. Aflac routinely repurchases $1B - $2B+ annually.
  • Dividend Policy: Dividend Aristocrat with 40+ years of consecutive increases. Payout ratio is typically 25-30% of adjusted earnings.

Cash Flow Characteristics

  • Operating Cash Flow: $4B - $6B annually, driven by the massive float (premiums collected upfront, claims paid later).
  • Free Cash Flow: For a life insurer, "Free Cash Flow" is best measured as Statutory Capital generated by the subsidiaries that can be dividended up to the holding company.
  • Major Non-Cash Items: Amortisation of DAC, reserve remeasurements, unrealised FX translation losses, realised investment gains/losses.
  • Cash Tax Rate: Typically 18-21%, benefiting from tax credits on certain investments.

Sheet Structure

  1. Assumptions & Scenarios: FX rates (USD/JPY), segment growth rates, benefit ratios, expense ratios, portfolio yields.
  2. Executive Summary: Consolidated dashboard, adjusted EPS, ROE, and capital return metrics.
  3. Aflac Japan Segment: JPY to USD translation, Net Earned Premiums, Net Investment Income, Benefits & Claims, Amortisation of DAC, Insurance Expenses, Pretax Income.
  4. Aflac U.S. Segment: Net Earned Premiums, Net Investment Income, Benefits & Claims, Amortisation of DAC, Insurance Expenses, Pretax Income.
  5. Corporate & Other: Corporate interest expense, net investment gains/losses, unallocated overhead.
  6. Consolidated Income Statement: Aggregation of Japan, U.S., and Corporate.
  7. Investment Portfolio: Roll-forward of fixed maturities, yield calculations, and net investment income generation.
  8. Consolidated Balance Sheet: Investments, DAC, Future Policy Benefits, Debt, Shareholders' Equity (including AOCI).
  9. Capital Return & Share Count: Dividend schedule, share repurchase schedule, basic and diluted shares outstanding.
  10. Valuation: Dividend Discount Model (DDM) and Price/Adjusted Book Value multiple valuation.

Key Financial Relationships

  1. `Aflac Japan USD Revenue = Aflac Japan JPY Revenue / USD_JPY Average Exchange Rate`
  2. `Segment Net Earned Premiums = Prior Year Net Earned Premiums * (1 + Premium Growth Rate)`
  3. `Segment Benefits and Claims = Segment Net Earned Premiums * Segment Benefit Ratio`
  4. `Segment Acquisition & Operating Expenses = Segment Total Revenue * Segment Expense Ratio`
  5. `Segment Pretax Income = Segment Total Revenue - Segment Benefits and Claims - Segment Acquisition & Operating Expenses`
  6. `Consolidated Net Investment Income = Average Investment Portfolio Balance * Blended Portfolio Yield`
  7. `Adjusted Earnings = Consolidated Net Income - Realised Investment Gains/Losses - FX Translation Impacts`
  8. `Adjusted EPS = Adjusted Earnings / Diluted Shares Outstanding`
  9. `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price)`
  10. `Dividends Paid = Annual Dividend Per Share * Shares Outstanding`

Cross-Sheet Dependencies

  • Assumptions dictates the USD/JPY exchange rate, which fundamentally drives the Aflac Japan Segment sheet.
  • Aflac Japan and Aflac U.S. sheets feed directly into the Consolidated Income Statement.
  • Investment Portfolio calculates Net Investment Income, which feeds into both Segment sheets (allocated) and the Consolidated Income Statement.
  • Consolidated Income Statement generates Net Income, which feeds Retained Earnings on the Consolidated Balance Sheet.
  • Capital Return calculates share repurchases, which reduces Cash on the Balance Sheet and reduces Share Count on the Income Statement (impacting EPS).

Sign Convention

  • Revenues, Premiums, and Investment Income: Positive.
  • Benefits, Claims, and Expenses: Positive in their specific build-up schedules, but subtracted in the Income Statement to calculate Pretax Income.
  • Cash Flow: Inflows are positive; outflows (dividends, share repurchases, debt paydown) are negative.
  • FX Translation: A weaker Yen (higher USD/JPY ratio) results in a negative impact on USD-reported revenues.

Things Most Likely to Go Wrong

  • FX Translation Errors: The model must divide JPY figures by the USD/JPY rate, not multiply. Aflac Japan is ~54% of revenue; getting the FX math wrong will break the entire model.
  • GAAP vs. Adjusted Earnings: Aflac reports massive swings in GAAP Net Income due to derivative mark-to-market and FX. The model must isolate "Adjusted Earnings" to calculate a meaningful P/E ratio.
  • LDTI Accounting Mismatch: Pre-2023 historical data uses old DAC and reserve accounting. Do not attempt to trend pre-2023 margins directly into 2024/2025 without adjusting for LDTI.
  • Paid-Up Policies in Japan: Aflac Japan's premium growth is negative because legacy policies are fully paid up. Do not model positive premium growth for Japan without a specific thesis on new product launches offsetting this structural headwind.
  • AOCI Volatility: Accumulated Other Comprehensive Income (AOCI) swings wildly with interest rates. Valuation should be based on "Adjusted Book Value" (Book Value excluding AOCI).
  • Benefit Ratio Misallocation: Do not use a consolidated benefit ratio. Japan and the U.S. have fundamentally different morbidity profiles and product mixes.

Validation Checks

  • "Aflac Japan Benefit Ratio must remain between 60.0% and 63.0%; flag if outside this range."
  • "Aflac U.S. Benefit Ratio must remain between 48.0% and 52.0%; flag if outside this range."
  • "Aflac Japan Expense Ratio must remain between 20.0% and 23.0%."
  • "Aflac U.S. Expense Ratio must remain between 36.0% and 39.0%."
  • "Total Assets must equal Total Liabilities + Shareholders' Equity in all periods."
  • "Adjusted EPS growth should be positive despite flat revenue, driven by share repurchases."
  • "Dividend payout ratio should not exceed 35% of Adjusted Earnings."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
USD/JPY Exchange Rate152.00RatioBlended average based on recent Q4 2024 / Q4 2025 actuals
Aflac Japan Premium Growth (JPY)-1.5%%Reflects runoff of limited-pay products reaching paid-up status
Aflac U.S. Premium Growth3.5%%Reflects steady growth in small business and digital voluntary benefits
Aflac Japan Benefit Ratio61.5%%Midpoint of management's 60-63% target guidance
Aflac Japan Expense Ratio21.5%%Midpoint of management's 20-23% target guidance
Aflac U.S. Benefit Ratio50.0%%Midpoint of management's 48-52% target guidance
Aflac U.S. Expense Ratio37.5%%Midpoint of management's 36-39% target guidance
Investment Portfolio Yield4.5%%Blended yield on fixed maturities in current rate environment
Effective Tax Rate19.0%%Historical average, benefiting from specific investment tax credits
Annual Share Repurchases1,500$ MillionsAligns with historical capital return run-rate
Dividend Per Share Growth5.0%%Consistent with Dividend Aristocrat track record
Cost of Equity (Ke)8.5%%Standard for large-cap, low-beta life insurers

Data Sources & Benchmarks

  • SEC EDGAR: Aflac (AFL) 10-K and 10-Q filings.
  • Investor Relations: Aflac's quarterly "Financial Supplement" is critical, as it provides the exact segment-level breakdown of premiums, NII, and ratios.
  • Key Peers: Unum Group (UNM), Globe Life (GL), Prudential Financial (PRU), MetLife (MET).
  • Industry Data: LIMRA (for U.S. supplemental health market share), Japan Ministry of Health, Labour and Welfare (for demographic and healthcare trends).

Sources

Frequently asked

What kind of insurance products does Aflac offer?+

Aflac Incorporated provides supplemental health and life insurance products to its policyholders. These products are designed to pay cash benefits directly to individuals for costs not covered by their primary health insurance plans.

How does Aflac generate its revenue?+

Aflac operates a dual-engine business model, primarily generating revenue from recurring premiums collected from its policyholders. The company also invests the substantial float from these premiums into a massive portfolio of fixed-income securities, which serves as another key revenue source.

What are the key assumptions for Aflac's financial model regarding capital expenditures?+

The financial model for Aflac incorporates a Capex_Pct_Revenue assumption of 0.03. These capital expenditures are primarily allocated to IT infrastructure and digital sales tools, reflecting the company's focus on technology investments.

What factors are crucial for Aflac's equity valuation in the financial model?+

The financial model for Aflac evaluates equity valuation by focusing on the impact of USD/JPY exchange rate fluctuations, segment-level benefit ratios, and investment portfolio yields. These factors are key to determining the company's capacity for share repurchases and dividend growth.

Can I download an Excel financial model for Aflac?+

Yes, a downloadable Excel financial model is available for Aflac. This model evaluates the company's equity valuation and statutory capital generation, with a forecast horizon extending from FY2026 to FY2030.

What are Aflac's primary business segments and key geographies?+

Aflac operates primarily through two major business segments: Aflac Japan, which accounts for approximately 54% of total revenues, and Aflac U.S., contributing about 39%. The company's key geographies are Japan and the United States, where it holds leading positions in supplemental insurance.

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.

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.

BRO.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Brown & Brown logo

Brown & Brown

Brown & Brown is a leading global insurance brokerage firm that provides risk management solutions to individuals and businesses, earning commissions and fees for placing property, casualty, and employee benefits insurance.

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