Humana Financial Model
Health Insurance Company Financials Example (Free Excel Download)
Humana Inc. is a leading managed healthcare company in the United States with a primary focus on government-sponsored programmes, particularly Medicare Advantage.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates Humana's equity valuation and earnings power to help an equity research analyst determine if the company's strategic pivot away from commercial insurance and its expansion of CenterWell healthcare services can offset margin pressures from rising Medicare Advantage medical costs and regulatory headwinds.
Humana Inc. is a leading managed healthcare company in the United States with a primary focus on government-sponsored programmes, particularly Medicare Advantage. The company operates as both a health insurance risk-bearing entity and a direct provider of healthcare services.
Business segments include:
- Insurance (approx. 85% of revenue): Comprises Medicare Advantage, Medicaid, and military (TRICARE) health insurance products.
- CenterWell (approx. 15% of revenue): Comprises pharmacy, primary care, and home solutions operations that serve both Humana members and external patients.
Humana operates exclusively within the United States. Its business model is a hybrid of an asset-light insurance risk pool and a capital-intensive healthcare services delivery network. Humana holds a strong competitive position as the second-largest provider of Medicare Advantage plans in the US, competing directly with UnitedHealth Group, CVS Health (Aetna), and Elevance Health. Recent major events include the complete exit from the Employer Group Commercial Medical Products business to focus entirely on government programmes, as well as a strategic exit from unprofitable Medicare Advantage counties in 2025 which resulted in a planned reduction of approximately 500,000 to 550,000 individual members.
The downloadable Humana 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 & AssumptionsHumana financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $83.06B | $92.87B | $106.37B | $117.76B | $129.66B |
| Total operating expenses | $79.92B | $89.07B | $102.36B | $115.20B | $126.96B |
| Operating income | $3.15B | $3.80B | $4.01B | $2.56B | $2.70B |
| Net income | $2.93B | $2.81B | $2.49B | $1.21B | $1.19B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Humana
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Insurance Segment
- Segment name: Insurance
- Revenue driver formula: Average Membership by Product (Medicare Advantage, Medicaid, PDP) x Premium per Member per Month (PMPM) x 12
- Historical growth rate: 8% to 11% CAGR over the last 3 years.
- Key growth levers and headwinds: Growth is driven by the aging US population aging into Medicare and state Medicaid contract wins. Headwinds include CMS rate updates, Star Ratings performance (which dictates bonus payments), and intentional membership attrition from exiting unprofitable geographic markets.
- Pricing dynamics: Regulated and contractual. Medicare Advantage premiums and rebates are determined through an annual bidding process with the Centers for Medicare & Medicaid Services (CMS).
- Revenue recognition notes: Premiums are recognised ratably over the period of coverage. Risk adjustment payments from CMS are estimated and accrued based on the acuity of the member pool.
- Seasonality: First quarter typically sees the highest enrollment due to the Annual Election Period (AEP), but revenue is recognised smoothly throughout the year.
CenterWell Segment
- Segment name: CenterWell
- Revenue driver formula: (Pharmacy Scripts x Price per Script) + (Primary Care Patients x Revenue per Patient) + (Home Health Admissions x Revenue per Admission)
- Historical growth rate: 10% to 15% CAGR.
- Key growth levers and headwinds: Driven by the transition to value-based care, expansion of primary care clinics, and high-cost specialty drug utilisation (such as GLP-1s). Headwinds include pharmacy reimbursement pressures and clinical labour shortages.
- Pricing dynamics: Fee-for-service, capitated value-based arrangements, and negotiated pharmacy dispensing fees.
- Revenue recognition notes: Recognised when services are rendered or when prescriptions are dispensed.
- Seasonality: Relatively stable, though home health admissions can dip slightly during severe winter weather in Q1.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: For Humana, COGS is represented by "Benefits Expense" (medical costs). This includes hospital inpatient/outpatient care, physician services, and pharmacy costs.
- Gross margin range: In managed care, this is measured inversely by the Benefit Ratio (Medical Loss Ratio). Humana's Benefit Ratio typically ranges from 89.0% to 91.5%, implying a "gross margin" of 8.5% to 11.0%.
- Key input costs and commodity exposures: Hospital unit costs, physician contracting rates, and prescription drug prices.
- How COGS scales with revenue: Highly linear. Medical costs scale directly with membership and utilisation. Operating leverage is minimal on the benefits line.
Operating Expenses
- R&D: Not material or separately disclosed.
- SG&A: Reported as "Operating Costs". This includes marketing, broker commissions, administrative salaries, and technology infrastructure.
- Depreciation & Amortisation: Typically 0.5% to 1.0% of revenue, heavily weighted towards amortisation of acquired intangibles and capitalised software.
- Stock-Based Compensation: Approximately 0.2% to 0.3% of revenue.
- Restructuring / one-time charges: Frequent in recent years due to the exit from the commercial insurance business and value creation initiatives, often running between $200m and $500m annually.
Margin Profile
- Gross margin (1 - Benefit Ratio): 8.5% to 11.0%.
- EBITDA margin: 4.0% to 5.5%.
- Operating margin: 3.0% to 4.5%.
- Net margin: 1.5% to 3.0%.
- Margin trend: Compressing recently due to elevated Medicare Advantage utilisation (higher inpatient admissions) and regulatory changes to risk adjustment models.
- Segment-level margins: Insurance segment operating margins are typically 3% to 4%, while CenterWell operates at slightly higher margins of 6% to 8% due to its services-based model.
Balance Sheet Structure
- Total assets: Approximately $45bn to $50bn.
- Key asset categories: Cash and cash equivalents, investment securities (statutory reserves required by state regulators), receivables, and goodwill.
- Goodwill & intangibles as % of total assets: Approximately 35% to 40%, stemming from historical acquisitions like Kindred at Home and various primary care roll-ups.
- Working capital profile:
- Days in Claims Payable (DCP): 36 to 42 days. This is the most critical working capital metric for a health insurer.
- Days Sales Outstanding (DSO): 15 to 20 days (CMS pays premiums promptly).
- Days Inventory Outstanding (DIO): Negligible (only applicable to pharmacy supplies).
- Net working capital as % of revenue: Typically negative.
- Is working capital positive or negative? Negative. Humana collects premiums upfront from CMS and pays providers later, generating a structural cash flow advantage.
- PP&E: Minimal (approx. 3% to 5% of assets), consisting mostly of clinic build-outs and IT equipment.
- Right-of-use assets / operating leases: Material due to the footprint of CenterWell primary care clinics, typically around $1.5bn to $2.0bn.
Capital Expenditure & Investment
- Capex as % of revenue: 0.8% to 1.2%.
- Maintenance capex vs. growth capex: Approximately 40% maintenance (IT infrastructure) and 60% growth (new CenterWell clinics and digital platform development).
- Major capex programmes underway or planned: Expansion of CenterWell Senior Primary Care clinics and integration of acquired assets like The Villages Health.
- Capitalised software / development costs: Highly material, representing a significant portion of total capex as the company modernises its claims processing and value-based care analytics platforms.
- M&A pattern: Bolt-on acquirer focused heavily on expanding the CenterWell footprint (primary care practices and home health agencies).
- Typical acquisition multiple paid: 12x to 15x EBITDA for clinical assets.
Debt & Capital Structure
- Total debt: Approximately $10bn to $12bn.
- Debt/EBITDA ratio: 1.5x to 2.5x.
- Credit rating: Investment grade (typically BBB+ / Baa1).
- Key debt instruments: Unsecured senior notes of varying maturities and a commercial paper programme for short-term liquidity.
- Maturity profile: Well-laddered with average maturity exceeding 5 years.
- Interest rate profile: Predominantly fixed-rate senior notes; commercial paper is floating.
- Covenants: Maximum debt-to-capitalisation ratio (typically capped around 50%). Current debt-to-capitalisation runs at approximately 40% to 42%.
- Share repurchase programme: Historically active, but occasionally paused to preserve capital for Medicare Advantage investments or M&A.
- Dividend policy: Modest payout ratio of 15% to 20%, yielding around 1.0% to 1.5%, with a history of steady annual increases.
Cash Flow Characteristics
- Operating cash flow conversion: Typically 1.2x to 1.5x of Net Income.
- Free cash flow margin: 2.0% to 3.5%.
- Major non-cash items that bridge net income to OCF: Depreciation and amortisation, stock-based compensation, and changes in unpaid claim liabilities.
- Working capital cash flow impact: Growth in membership naturally increases the unpaid claim liability balance, serving as a source of cash. Conversely, exiting markets causes this liability to run off, resulting in a use of cash.
- Capex intensity: Very low (asset-light insurance model).
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally aligned with the GAAP effective rate of 22% to 24%, though timing differences arise from deferred tax liabilities on acquired intangibles.
Sheet Structure
- Assumptions: Hardcoded inputs for membership growth, PMPM rates, Benefit Ratio, Operating Cost Ratio, DCP, and WACC.
- Membership Schedule: Roll-forward of individual Medicare Advantage, Group Medicare Advantage, Medicaid, and PDP members.
- Revenue Schedule: Calculation of Insurance segment premiums (Members x PMPM) and CenterWell segment revenues, minus intercompany eliminations.
- Benefits & Claims Schedule: Calculation of Benefits Expense based on the Benefit Ratio, and the resulting Unpaid Claim Liabilities based on DCP.
- Income Statement: Consolidated view mirroring the 10-K, including Revenues, Benefits Expense, Operating Costs, Depreciation, and Segment Income from Operations.
- Balance Sheet: Assets (Cash, Investments, Receivables, Goodwill) and Liabilities (Unpaid Claim Liabilities, Debt, Equity).
- Cash Flow Statement: Indirect method starting from Net Income, highlighting the change in Unpaid Claim Liabilities.
- Debt Schedule: Tranches of senior notes, commercial paper, interest expense calculation, and debt-to-capitalisation tracking.
- DCF Valuation: Unlevered free cash flow calculation, discount rate application, terminal value, and implied share price.
Key Financial Relationships
- `Insurance Segment Revenue = (Average Medicare Advantage Members * MA Annual PMPM) + (Average Medicaid Members * Medicaid Annual PMPM)`
- `Benefits Expense = Insurance Segment Revenue * Benefit Ratio`
- `Operating Costs = Total Consolidated Revenue * Operating Cost Ratio`
- `Unpaid Claim Liabilities = (Benefits Expense / 365) * Days in Claims Payable (DCP)`
- `CenterWell Segment Revenue = (Primary Care Patients * Revenue per Patient) + (Pharmacy Scripts * Price per Script)`
- `Intercompany Eliminations = CenterWell Revenue derived from Humana Insurance Members (historically ~60-70% of CenterWell revenue)`
- `Consolidated Revenue = Insurance Segment Revenue + CenterWell Segment Revenue - Intercompany Eliminations`
- `Segment Income from Operations = Segment Revenue - Segment Benefits Expense - Segment Operating Costs`
- `Net Investment Income = Average Cash & Investment Balance * Average Portfolio Yield`
- `Debt-to-Capitalisation = Total Debt / (Total Debt + Total Shareholders Equity)`
Cross-Sheet Dependencies
- The Membership Schedule is the foundational driver and feeds directly into the Revenue Schedule.
- The Revenue Schedule feeds the top line of the Income Statement and dictates the scale of the Benefits & Claims Schedule.
- The Benefits & Claims Schedule calculates Benefits Expense (feeding the Income Statement) and Unpaid Claim Liabilities (feeding the Balance Sheet).
- The Balance Sheet unpaid claims balance feeds the change in working capital on the Cash Flow Statement.
- The Cash Flow Statement determines the ending cash balance, which feeds back into the Balance Sheet and impacts Net Investment Income on the Income Statement (circularity risk here; use an average balance or prior period balance for interest calculations).
Sign Convention
- Revenues, membership counts, and asset balances are entered and displayed as positive numbers.
- Expenses (Benefits Expense, Operating Costs, Interest Expense) are calculated as positive numbers in their supporting schedules but subtracted (or linked as negative) in the Income Statement.
- Cash outflows (Capex, dividends, debt repayment) are represented as negative numbers on the Cash Flow Statement.
- Contra-revenue items (Intercompany Eliminations) should be subtracted from gross segment revenues.
Things Most Likely to Go Wrong
- Benefit Ratio Sensitivity: A 50 basis point error in the Benefit Ratio assumption will drastically alter operating income. The model must allow for precise decimal inputs for this metric.
- Intercompany Eliminations: Failing to eliminate CenterWell revenues generated from Humana's own insurance members will double-count consolidated revenue.
- DCP Miscalculation: Unpaid Claim Liabilities must be calculated using Benefits Expense, not Total Revenue. Using revenue will overstate the liability.
- Membership Run-off: Humana is actively exiting unprofitable Medicare Advantage counties in 2025. The model must reflect a negative growth rate for MA membership in the near term rather than defaulting to historical growth trends.
- Star Ratings Impact: CMS Star Ratings operate on a lag. Poor ratings in one year impact bonus payments and revenue two years later. The model should include a toggle for Star Ratings headwinds.
- Commercial Exit: Historical financials include the Employer Group Commercial business. Forward projections must zero out this membership and revenue stream.
- Capitalised Software: Humana capitalises significant IT development costs. This flatters operating cash flow but requires a corresponding cash outflow in investing activities.
- Regulatory Capital: The model must maintain a minimum cash and investment balance to satisfy state statutory reserve requirements; excess cash cannot be fully drained for debt paydown or buybacks.
Validation Checks
- "Benefit Ratio must be between 89.0% and 91.5%; flag if outside this band."
- "Operating Cost Ratio must be between 10.5% and 12.5%."
- "Days in Claims Payable (DCP) should remain between 36 and 42 days based on historical claims processing speeds."
- "Debt-to-Capitalisation ratio should not exceed 45% per internal company targets."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Intercompany eliminations must be negative and should approximate 60% to 70% of gross CenterWell revenue."
- "Effective tax rate should be 22% to 24%."
- "Operating Cash Flow to Net Income conversion should be >1.0x."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Individual MA Membership Growth (Year 1) | -10.0 | % | Reflects planned exit from unprofitable counties in 2025. |
| Individual MA Membership Growth (Year 2+) | 4.0 | % | Return to normalised demographic growth trends. |
| Insurance Segment PMPM Growth | 3.5 | % | Blended rate of CMS updates and risk coding trends. |
| CenterWell Revenue Growth | 12.0 | % | Continued expansion of primary care clinics and pharmacy volume. |
| Benefit Ratio (Medical Loss Ratio) | 90.4 | % | Aligns with management's recent actuals and guidance. |
| Operating Cost Ratio | 11.0 | % | Historical average, reflecting administrative cost efficiencies. |
| Days in Claims Payable (DCP) | 38 | Days | Historical average for claims processing cycle. |
| Capex as % of Revenue | 1.0 | % | Asset-light model with targeted CenterWell investments. |
| Effective Tax Rate | 23.0 | % | Standard US corporate rate plus state taxes. |
| Target Debt-to-Capitalisation | 41.0 | % | Aligns with current capital structure. |
| Average Interest Rate on Debt | 4.5 | % | Weighted average cost of existing senior notes. |
| WACC | 7.5 | % | Standard discount rate for large-cap managed care. |
| Terminal Growth Rate | 2.0 | % | Long-term GDP and inflation alignment. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Humana Inc. 10-K, 10-Q, 8-K), Humana Investor Relations page for quarterly earnings presentations and statistical supplements.
- Peers for benchmarking: UnitedHealth Group (UNH), CVS Health / Aetna (CVS), Elevance Health (ELV), Centene (CNC).
- Industry data sources: Centers for Medicare & Medicaid Services (CMS) for monthly MA enrollment files and annual rate announcements; Kaiser Family Foundation (KFF) for Medicare Advantage market share data.
- Consensus estimates: FactSet or Bloomberg for forward EPS and Benefit Ratio consensus.
Sources
- Humana Inc. Form 10-K and 10-Q filings (SEC EDGAR).
- Humana Q4 2025 Earnings Release and Financial Guidance.
- Humana Q2 2025 Earnings Release.
- Forbes: "Humana 2024 Profits Hit $1.2 Billion As Insurer Exits Unprofitable Medicare Markets".
- Healthcare Dive: "Humana hikes 2025 guidance on medical cost control, pharmacy growth".
- Zacks Equity Research: "Humana Benefits From Rising Premiums Amid High Benefit Ratio".
Do more with the Humana model
Frequently asked
What is Humana's primary business focus?+
Humana Inc. is a leading managed healthcare company in the United States, primarily focusing on government-sponsored programs like Medicare Advantage. It operates as both a health insurance risk-bearing entity and a direct provider of healthcare services through its CenterWell segment.
How does Humana generate its revenue?+
Humana generates approximately 85% of its revenue from its Insurance segment, which includes Medicare Advantage, Medicaid, and TRICARE health insurance products. The remaining 15% comes from its CenterWell segment, offering pharmacy, primary care, and home solutions to members and external patients.
What are Humana's key capital expenditure priorities?+
Humana's capital expenditure is split approximately 40% for maintenance, primarily IT infrastructure, and 60% for growth initiatives. Major growth capex programs include expanding CenterWell Senior Primary Care clinics and developing its digital platforms.
What are the main considerations for valuing Humana's equity?+
Evaluating Humana's equity valuation requires assessing its earnings power and the impact of its strategic pivot away from commercial insurance. Analysts also consider how the expansion of CenterWell services can offset margin pressures from rising Medicare Advantage medical costs and regulatory headwinds.
Can I download a financial model for Humana?+
Yes, a downloadable Excel financial model for Humana (HUM) is available, offering a forecast horizon from FY2026 to FY2030. This general corporate model helps evaluate the company's equity valuation and earnings power.
What is Humana's working capital profile?+
Humana typically has a negative net working capital profile, which provides a structural cash flow advantage. This is because the company collects premiums upfront from CMS and pays providers later.
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.
UnitedHealth Group
UnitedHealth Group is a diversified health care company operating through two distinct but complementary platforms: UnitedHealthcare (health benefits) and Optum (health services).
Explore more Healthcare financial model templates.
