UnitedHealth Group Financial Model
Health Insurance Company Financials Example (Free Excel Download)
UnitedHealth Group is a diversified health care company operating through two distinct but complementary platforms: UnitedHealthcare (health benefits) and Optum (health services).
professionals from Deloitte
Used by professionals from
About this model
To forecast UnitedHealth Group's consolidated earnings and cash flows to determine equity valuation, specifically assessing the impact of Medicare Advantage rate pressures, Medical Care Ratio (MCR) trends, and the growth trajectory of Optum's value-based care model.
UnitedHealth Group is a diversified health care company operating through two distinct but complementary platforms: UnitedHealthcare (health benefits) and Optum (health services). The company collects premiums to assume medical risk and provides care delivery, pharmacy benefits management, and health care technology services.
- UnitedHealthcare (UHC): Represents approximately 54% of consolidated revenue (post-eliminations), providing health care benefits to employers, individuals, and Medicare/Medicaid beneficiaries.
- Optum: Represents approximately 46% of consolidated revenue (post-eliminations), operating through Optum Health (care delivery), Optum Insight (data and analytics), and Optum Rx (pharmacy benefit management).
- Key Geographies: Predominantly the United States. The company significantly reduced its international footprint by selling its Brazil operations (Amil) in early 2024.
- Business Model: A hybrid of risk-based managed care (collecting premiums upfront and paying medical claims later) and fee-for-service/transactional health services. This creates a negative working capital advantage.
- Competitive Position: The largest US health insurer by covered lives and revenue. Key competitors include CVS Health (Aetna), Elevance Health, Cigna, and Humana.
- Recent Major Events: The Q1 2024 Change Healthcare cyberattack caused significant business disruption and direct response costs. The company also divested its Brazil operations in early 2024, resulting in a $7.1 billion loss, and is currently navigating multi-year Medicare Advantage funding reductions from the Centers for Medicare & Medicaid Services (CMS).
The downloadable UnitedHealth 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 & AssumptionsUnitedHealth Group financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $287.60B | $324.16B | $371.62B | $400.28B | $447.57B |
| Gross profit | $256.56B | $290.46B | $332.85B | $353.58B | $396.91B |
| Operating income | $23.97B | $28.43B | $32.36B | $32.29B | $18.96B |
| Net income | $17.29B | $20.12B | $22.38B | $14.40B | $12.06B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for UnitedHealth Group
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
UnitedHealthcare (UHC)
- Employer & Individual: Commercial risk and fee-based plans.
- *Driver*: Commercial Members x Premium/Fee per Member.
- *Historical Growth*: 4-6% CAGR.
- *Dynamics*: Highly competitive, tied to US employment levels.
- Medicare & Retirement: Medicare Advantage and Medigap.
- *Driver*: Medicare Members x Premium per Member.
- *Historical Growth*: 8-10% CAGR.
- *Dynamics*: Heavily regulated by CMS. Currently facing headwinds from CMS rate cuts and elevated senior care utilisation.
- Community & State: Medicaid managed care.
- *Driver*: Medicaid Members x State Premium Rates.
- *Historical Growth*: 6-8% CAGR.
- *Dynamics*: Subject to state-level Medicaid redeterminations which impact membership volumes.
- Global: International health businesses.
- *Driver*: International Members x Premium per Member.
- *Dynamics*: Revenue dropped significantly in 2024 following the Brazil divestiture.
Optum
- Optum Health: Direct care delivery and value-based care.
- *Driver*: Value-Based Patients (4.7 million in 2024) x Revenue per Patient.
- *Historical Growth*: 15-20% CAGR.
- *Dynamics*: Driven by acquiring physician groups and transitioning patients from fee-for-service to capitated value-based care.
- Optum Insight: Health care technology, data, and revenue cycle management.
- *Driver*: Contract Backlog ($32.8 billion at end of 2024) x Realisation Rate.
- *Historical Growth*: 10-15% CAGR.
- *Dynamics*: High-margin software and services, temporarily disrupted by the 2024 cyberattack.
- Optum Rx: Pharmacy benefit manager (PBM).
- *Driver*: Adjusted Scripts x Revenue per Script.
- *Historical Growth*: 8-12% CAGR.
- *Dynamics*: High volume, low margin. Facing regulatory scrutiny over PBM pricing models.
*Note on Revenue Recognition*: A massive portion of Optum's revenue comes from serving UHC members. This requires a dedicated "Eliminations" line to prevent double-counting consolidated revenue.
Cost Structure
Medical Costs (Cost of Goods Sold equivalent for UHC)
- Medical Costs: The cost of paying hospital and physician claims for UHC members. This is the largest single expense line.
- Medical Care Ratio (MCR): Medical Costs divided by Premium Revenue. The 2024 MCR was 85.5% (up from 83.2% in 2023 due to Medicare funding reductions and elevated care activity).
- Dynamics: Highly sensitive to utilisation spikes (e.g., increased outpatient surgeries or specialty drug prescriptions).
Cost of Products Sold (Cost of Goods Sold equivalent for Optum)
- Pharmacy Costs: The cost of purchasing drugs for Optum Rx.
- Dynamics: Scales linearly with Optum Rx script volume.
Operating Expenses
- Operating Costs: Includes SG&A, depreciation, and amortisation.
- Operating Cost Ratio: Total Operating Costs divided by Total Revenues. The 2024 ratio was 13.2% (improved from 14.7% in 2023 due to efficiency gains and portfolio refinement).
- Restructuring / One-Time Charges: 2024 included massive non-recurring items, specifically the $7.1 billion Brazil sale loss and approximately $1.15 to $1.35 per share in cyberattack impacts.
Margin Profile
- Consolidated Operating Margin: Typically 8.0% to 8.5%.
- UHC Operating Margin: Typically 5.0% to 5.5%.
- Optum Operating Margin: Typically 6.5% to 7.5% (Optum Insight is the highest margin sub-segment, often exceeding 15%).
Balance Sheet Structure
- Total Assets: Approximately $270 billion to $280 billion.
- Cash & Investments: Significant portfolio of cash and short-term investments generated by collecting premiums before paying claims (float).
- Goodwill & Intangibles: Represents over 40% of total assets, reflecting a history of serial acquisitions (Change Healthcare, LHC Group, Amedisys).
- Medical Costs Payable: The most critical liability. Represents Incurred But Not Reported (IBNR) medical claims.
- Days Claims Payable (DCP): Measures the adequacy of medical reserves. Stood at 47.0 days at the end of 2024.
- Working Capital Profile: Structurally negative. The company funds growth through its working capital because it collects cash premiums upfront and pays provider claims 40 to 50 days later.
Capital Expenditure & Investment
- Capex as % of Revenue: Very low, typically 0.8% to 1.2% of total revenue.
- Capex Composition: Heavily weighted towards capitalised software development for Optum Insight and clinic build-outs for Optum Health.
- M&A Pattern: Highly acquisitive. The company acts as a serial acquirer, routinely spending $5 billion to $10 billion annually on bolt-on physician groups and health tech assets.
Debt & Capital Structure
- Total Debt: Approximately $60 billion to $65 billion.
- Leverage: Debt/EBITDA is conservatively managed, typically sitting between 1.3x and 1.5x.
- Credit Rating: A+ (S&P) / A (Fitch), allowing for very low cost of debt.
- Interest Rate Profile: Predominantly fixed-rate senior unsecured notes with staggered maturities.
- Share Repurchases: Highly active. The company routinely returns capital, repurchasing shares and paying dividends totalling over $16 billion in 2024.
- Dividend Policy: Steady annual increases. The annualised dividend is approximately $8.40 per share, representing a payout ratio of roughly 30%.
Cash Flow Characteristics
- Operating Cash Flow (OCF): Exceptionally strong. Generated $24.2 billion in 2024.
- OCF Conversion: OCF is typically 1.5x to 2.0x Net Income. This is driven by the continuous growth of the Medical Costs Payable float and high non-cash amortisation charges.
- Free Cash Flow Margin: Typically 5.0% to 6.5% of revenue.
- Cash Tax Rate: Generally tracks close to the GAAP effective tax rate of 21% to 22%.
Sheet Structure
- Assumptions: Hardcoded drivers for memberships, premium yields, MCR, Operating Cost Ratio, and capital allocation.
- Memberships: Granular build of covered lives for UHC (Employer & Individual, Medicare & Retirement, Community & State) and Optum value-based patients.
- Revenue Build: Segmented revenue calculations for the four UHC segments and three Optum segments, culminating in a critical Intersegment Eliminations row.
- Cost Build: Calculation of Medical Costs (driven by MCR), Cost of Products Sold, and Operating Costs (driven by Operating Cost Ratio).
- Income Statement: Consolidated GAAP view from Total Revenues down to Net Earnings Attributable to UnitedHealth Group.
- Balance Sheet: Standard format highlighting Cash, Medical Receivables, Goodwill, Medical Costs Payable, and Debt.
- Cash Flow Statement: Indirect method starting from Net Income, highlighting the change in Medical Costs Payable as the primary working capital driver.
- Debt Schedule: Roll-forward of senior notes, commercial paper, and interest expense calculation.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value using the perpetuity growth method.
Key Financial Relationships
- `UHC Premium Revenue = Total UHC Members x Average Premium per Member`
- `Optum Health Revenue = Value-Based Patients x Average Revenue per Patient + Fee-for-Service Revenue`
- `Optum Rx Revenue = Adjusted Scripts x Average Revenue per Script`
- `Total Consolidated Revenue = UHC Revenue + Optum Revenue - Intersegment Eliminations`
- `Medical Costs = UHC Premium Revenue x Medical Care Ratio (MCR)`
- `Operating Costs = Total Consolidated Revenue x Operating Cost Ratio`
- `Medical Costs Payable = (Medical Costs / 365) x Days Claims Payable (DCP)`
- `Change in Medical Costs Payable = Current Period Medical Costs Payable - Prior Period Medical Costs Payable` (Key OCF driver)
- `Net Earnings Margin = Net Earnings / Total Consolidated Revenue`
- `Free Cash Flow = Operating Cash Flow - Capital Expenditures`
Cross-Sheet Dependencies
- The Memberships sheet dictates the volume inputs for the Revenue Build.
- The Revenue Build feeds the top line of the Income Statement and acts as the denominator for margin calculations in the Cost Build.
- The Cost Build calculates Medical Costs, which feeds directly into the Balance Sheet to calculate Medical Costs Payable via the DCP assumption.
- The Balance Sheet feeds the Cash Flow Statement, where the period-over-period change in Medical Costs Payable generates the bulk of working capital cash flow.
- The Debt Schedule calculates interest expense, which flows back to the Income Statement, creating a circular reference if a cash sweep is enabled.
Sign Convention
- Revenues and Memberships: Positive.
- Intersegment Eliminations: Negative (subtracted from gross segment revenues).
- Expenses (Medical Costs, Operating Costs): Positive in the Cost Build sheet, but subtracted in the Income Statement to arrive at operating earnings.
- Cash Flow: Inflows are positive, outflows (capex, dividends, share repurchases) are negative.
Things Most Likely to Go Wrong
- Ignoring Intersegment Eliminations: UHC pays Optum Rx billions for PBM services. Failing to model the Eliminations line will overstate consolidated revenue by more than $100 billion.
- Mismodelling the MCR: The Medical Care Ratio is highly sensitive. A 100 basis point error in MCR assumptions swings operating income by roughly $3 billion.
- DCP Disconnect: Days Claims Payable must be calculated using only Medical Costs as the denominator, not Total Operating Costs.
- Using GAAP instead of Adjusted Earnings for Base Year: 2024 GAAP earnings include a $7.1 billion loss on the Brazil sale and massive cyberattack costs. The model must use 2024 Adjusted Earnings as the run-rate base for forecasting.
- Double Counting Float: The company generates significant investment income from its float. Do not model this as a separate operating business; it belongs below operating earnings as Investment and Other Income.
- Misunderstanding Part D Seasonality: Changes to the Medicare Part D programme in 2025 shifted costs and revenues between quarters. Annual models are fine, but quarterly models must account for this new seasonality.
- Overestimating Capex: Unlike hospitals, managed care is asset-light. Capex should not exceed 1.5% of revenue.
- Ignoring Share Count Reduction: The company aggressively buys back shares. Failing to reduce the diluted share count over the forecast period will artificially depress EPS.
Validation Checks
- "Medical Care Ratio (MCR) should be in the 83.0% to 86.0% range; flag if outside this band."
- "Operating Cost Ratio should be in the 13.0% to 15.0% range."
- "Days Claims Payable (DCP) should remain between 45 and 50 days to ensure adequate medical reserving."
- "Intersegment Eliminations should be roughly negative 25% to 30% of Total Gross Revenue."
- "OCF / Net Income conversion should be >1.3x (company has structurally strong cash conversion)."
- "Debt/EBITDA should remain below 2.0x per rating agency guidance."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Capex as % of revenue should not exceed 1.5%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| UHC Employer & Individual Growth | 4.0 | % | Historical trend and stable commercial market |
| UHC Medicare & Retirement Growth | 5.0 | % | Reflects CMS rate pressures offsetting demographic tailwinds |
| Optum Health Revenue Growth | 12.0 | % | Continued expansion of value-based care patients |
| Optum Rx Revenue Growth | 8.0 | % | Steady script volume growth and drug price inflation |
| Intersegment Eliminations | -26.0 | % | Historical average of gross segment revenues |
| Medical Care Ratio (MCR) | 85.5 | % | Based on full year 2024 actuals |
| Operating Cost Ratio | 13.2 | % | Based on full year 2024 actuals |
| Days Claims Payable (DCP) | 47.0 | Days | Based on Q4 2024 actuals |
| Capex as % of Revenue | 1.0 | % | Historical average |
| Effective Tax Rate | 22.0 | % | Historical GAAP average |
| Annual Share Repurchases | 8,000 | $ Millions | Consistent with recent capital return programmes |
| Annualised Dividend per Share | 8.40 | $ | Current run-rate |
| Cost of Debt | 4.5 | % | Weighted average interest rate on senior notes |
| WACC | 7.5 | % | Low beta, highly stable cash flows |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term GDP and healthcare inflation |
Data Sources & Benchmarks
- Filings: SEC EDGAR for UnitedHealth Group (UNH) 10-K, 10-Q, and 8-K filings. The Investor Relations page provides supplemental financial data books which are critical for membership volume history.
- Peers for Benchmarking: Elevance Health (ELV), CVS Health (CVS), Cigna (CI), and Humana (HUM).
- Industry Data: CMS.gov for annual Medicare Advantage Advance Notices and Final Rate Announcements.
- Consensus Estimates: FactSet or Bloomberg for forward-looking EPS and MCR consensus to validate model outputs.
Sources
Do more with the UnitedHealth Group model
Frequently asked
What is UnitedHealth Group's core business model?+
UnitedHealth Group operates through two main platforms: UnitedHealthcare, which provides health benefits, and Optum, which offers health services like care delivery and pharmacy benefits management. Its business model is a hybrid of risk-based managed care and fee-for-service health services.
How does UnitedHealth Group generate its revenue?+
The company generates revenue primarily by collecting premiums for assuming medical risk through UnitedHealthcare and through fee-for-service and transactional health services provided by Optum. UnitedHealthcare accounts for approximately 54% of consolidated revenue, while Optum contributes about 46%.
What is UnitedHealth Group's typical capital expenditure as a percentage of revenue?+
UnitedHealth Group's capital expenditure is notably low, generally ranging from 0.8% to 1.2% of total revenue. This capital spending is primarily directed towards capitalized software development for Optum Insight and building out clinics for Optum Health.
How does UnitedHealth Group's negative working capital profile benefit its operations?+
UnitedHealth Group benefits from a structurally negative working capital profile because it collects cash premiums upfront from members before paying provider claims, typically 40 to 50 days later. This 'float' allows the company to fund its growth through its working capital.
What key factors are important for valuing UnitedHealth Group's equity?+
Key factors for valuing UnitedHealth Group's equity include assessing the impact of Medicare Advantage rate pressures, analyzing Medical Care Ratio (MCR) trends, and evaluating the growth trajectory of Optum's value-based care model. These elements are crucial for forecasting consolidated earnings and cash flows.
Can I download an Excel financial model for UnitedHealth Group (UNH)?+
Yes, an Excel financial model for UnitedHealth Group (UNH) is available for download. This model forecasts earnings and cash flows from FY2026 to FY2030, incorporating key assumptions like revenue growth and tax rate.
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 Health Insurance Company Financial Models
Browse another company in the same sector.
Cigna
The Cigna Group is a global health company that operates a massive pharmacy benefit manager (PBM) and a major commercial health insurance business.
Centene
Centene Corporation is a leading managed care organisation (MCO) focused primarily on government-sponsored healthcare programmes, serving uninsured and under-insured individuals.
CVS Health
CVS Health is a vertically integrated health solutions company that operates across the entire healthcare spectrum, providing health insurance, pharmacy benefit management, and retail pharmacy services.
Elevance Health
Elevance Health (formerly Anthem) is one of the largest managed healthcare companies in the United States, serving approximately 45.2 million medical members as of December 2025.
Humana
Humana is a managed healthcare company in the United States focused on government-sponsored programmes, particularly Medicare Advantage, operating as both a health insurance risk-bearing entity and a direct provider of healthcare services.
Explore more Healthcare financial model templates.
