StockDive AI
XII
================================================================================
VALUATION SCENARIOS - DISCOUNTED CASH FLOW (DCF) ANALYSIS
================================================================================

📊 LLM-DETERMINED DCF PARAMETERS FOR UNH
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

UNH is a managed care giant facing significant near-term headwinds (Change Healthcare breach aftermath, rising medical loss ratios, DOJ investigation) that have compressed 2024-2025 earnings and FCF well below mid-cycle levels. I normalize base FCF to $17.5B reflecting partial OCF recovery from the current trough, as the roic.ai FCF/share series ($22-28 range in 2022-2023) confirms current figures are anomalously depressed. WACC reflects moderate leverage ($30B net debt) and elevated regulatory/operational uncertainty.

Scenario Parameters (LLM-selected based on fundamental analysis):
  🔻 Bear: 4.0% growth, 10.5% WACC, 2.0% terminal
     → Regulatory headwinds intensify with Medicare Advantage rate cuts, DOJ action constrains vertical integration, medical loss ratios remain structurally elevated, and Optum growth decelerates amid increased antitrust scrutiny.
  ⚖️  Base: 7.0% growth, 9.5% WACC, 2.5% terminal
     → UNH gradually recovers margins as Change Healthcare disruption fades, Optum drives mid-to-high single-digit organic growth, and underlying healthcare spending tailwinds (~5-6% market growth) support 7-9% revenue growth with modest operating leverage.
  🔺 Bull: 10.0% growth, 9.0% WACC, 2.5% terminal
     → Full margin recovery plus Optum Health and Optum Insight accelerate through AI-driven care delivery efficiencies, regulatory concerns prove manageable, and UNH extends its dominant position in the $4.5T US healthcare ecosystem with share buybacks further boosting per-share FCF growth.

Base FCF: Current 2025 FCF of $11B is severely depressed by Change Healthcare costs, elevated medical costs, and DOJ disruption. Historical roic.ai FCF/share averaged $22-28 in 2022-2023 (~$20-25B total). Normalizing to $17.5B reflects partial recovery acknowledging that some margin pressure (higher MLR, regulatory scrutiny) may persist structurally. Reported FCF for UNH is also distorted by insurance portfolio investment activity.


Stock: UNH
Current Price: $275.59
Shares Outstanding: 0.91B (905,838,620 shares)

Base Year FCF (FY 2025): $17.5B (from financial statements)

--------------------------------------------------------------------------------


BEAR CASE (Probability: 25%)
Conservative: Below-trend growth, elevated risk premium, modest recession impact

📊 CASH FLOW NOTE: LLM analysis: Current 2025 FCF of $11B is severely depressed by Change Healthcare costs, elevated medical costs, and DOJ disruption. Historical roic.ai FCF/share averaged $22-28 in 2022-2023 (~$20-25B total). Normalizing to $17.5B reflects partial recovery acknowledging that some margin pressure (higher MLR, regulatory scrutiny) may persist structurally. Reported FCF for UNH is also distorted by insurance portfolio investment activity.

ASSUMPTIONS:
  • FCF Growth Rate (Years 1-10): 4.0%
  • Discount Rate (WACC): 10.5%
  • Terminal Growth Rate: 2.0%

10-YEAR FCF PROJECTION:
Year     FCF ($M)        PV Factor    PV of FCF ($M) 
------------------------------------------------------------
1        $18,200,000,000      0.9050 $16,470,588,235
2        $18,928,000,000      0.8190 $15,501,730,104
3        $19,685,120,000      0.7412 $14,589,863,627
4        $20,472,524,800      0.6707 $13,731,636,355
5        $21,291,425,792      0.6070 $12,923,893,040
6        $22,143,082,824      0.5493 $12,163,664,038
7        $23,028,806,137      0.4971 $11,448,154,388
8        $23,949,958,382      0.4499 $10,774,733,542
9        $24,907,956,717      0.4071 $10,140,925,687
10       $25,904,274,986      0.3684 $9,544,400,646
------------------------------------------------------------
Total PV of 10-Year FCF:            $127,289,589,662

TERMINAL VALUE:
  • Year 11 FCF: $26,422,360,486
  • Terminal Value: $310,851,299,833
  • PV of Terminal Value: $114,532,807,754

VALUATION SUMMARY:
  • Enterprise Value: $241.8B
  • Less: Total Debt: $78.4B
  • Plus: Cash & Equivalents: $48.2B
  • Equity Value: $211.6B
  • Shares Outstanding: 0.91B
  • Intrinsic Value per Share: $233.60
  • Current Price: $275.59
  • Upside/Downside: -15.2%
  • Margin of Safety: -18.0%
--------------------------------------------------------------------------------


BASE CASE (Probability: 50%)
Balanced: Sustainable growth trajectory, market-appropriate discount rate, realistic perpetuity assumptions

📊 CASH FLOW NOTE: LLM analysis: Current 2025 FCF of $11B is severely depressed by Change Healthcare costs, elevated medical costs, and DOJ disruption. Historical roic.ai FCF/share averaged $22-28 in 2022-2023 (~$20-25B total). Normalizing to $17.5B reflects partial recovery acknowledging that some margin pressure (higher MLR, regulatory scrutiny) may persist structurally. Reported FCF for UNH is also distorted by insurance portfolio investment activity.

ASSUMPTIONS:
  • FCF Growth Rate (Years 1-10): 7.0%
  • Discount Rate (WACC): 9.5%
  • Terminal Growth Rate: 2.5%

10-YEAR FCF PROJECTION:
Year     FCF ($M)        PV Factor    PV of FCF ($M) 
------------------------------------------------------------
1        $18,725,000,000      0.9132 $17,100,456,621
2        $20,035,750,000      0.8340 $16,710,035,237
3        $21,438,252,500      0.7617 $16,328,527,583
4        $22,938,930,175      0.6956 $15,955,730,150
5        $24,544,655,287      0.6352 $15,591,444,073
6        $26,262,781,157      0.5801 $15,235,475,030
7        $28,101,175,838      0.5298 $14,887,633,135
8        $30,068,258,147      0.4838 $14,547,732,835
9        $32,173,036,217      0.4418 $14,215,592,816
10       $34,425,148,753      0.4035 $13,891,035,902
------------------------------------------------------------
Total PV of 10-Year FCF:            $154,463,663,383

TERMINAL VALUE:
  • Year 11 FCF: $35,285,777,471
  • Terminal Value: $504,082,535,305
  • PV of Terminal Value: $203,404,454,283

VALUATION SUMMARY:
  • Enterprise Value: $357.9B
  • Less: Total Debt: $78.4B
  • Plus: Cash & Equivalents: $48.2B
  • Equity Value: $327.6B
  • Shares Outstanding: 0.91B
  • Intrinsic Value per Share: $361.71
  • Current Price: $275.59
  • Upside/Downside: +31.2%
  • Margin of Safety: 23.8%
--------------------------------------------------------------------------------


BULL CASE (Probability: 25%)
Optimistic: Strong execution, market share gains, operating leverage, sustained competitive advantages

📊 CASH FLOW NOTE: LLM analysis: Current 2025 FCF of $11B is severely depressed by Change Healthcare costs, elevated medical costs, and DOJ disruption. Historical roic.ai FCF/share averaged $22-28 in 2022-2023 (~$20-25B total). Normalizing to $17.5B reflects partial recovery acknowledging that some margin pressure (higher MLR, regulatory scrutiny) may persist structurally. Reported FCF for UNH is also distorted by insurance portfolio investment activity.

ASSUMPTIONS:
  • FCF Growth Rate (Years 1-10): 10.0%
  • Discount Rate (WACC): 9.0%
  • Terminal Growth Rate: 2.5%

10-YEAR FCF PROJECTION:
Year     FCF ($M)        PV Factor    PV of FCF ($M) 
------------------------------------------------------------
1        $19,250,000,000      0.9174 $17,660,550,459
2        $21,175,000,000      0.8417 $17,822,573,857
3        $23,292,500,000      0.7722 $17,986,083,709
4        $25,621,750,000      0.7084 $18,151,093,652
5        $28,183,925,000      0.6499 $18,317,617,447
6        $31,002,317,500      0.5963 $18,485,668,983
7        $34,102,549,250      0.5470 $18,655,262,276
8        $37,512,804,175      0.5019 $18,826,411,471
9        $41,264,084,593      0.4604 $18,999,130,843
10       $45,390,493,052      0.4224 $19,173,434,795
------------------------------------------------------------
Total PV of 10-Year FCF:            $184,077,827,492

TERMINAL VALUE:
  • Year 11 FCF: $46,525,255,378
  • Terminal Value: $715,773,159,662
  • PV of Terminal Value: $302,350,317,927

VALUATION SUMMARY:
  • Enterprise Value: $486.4B
  • Less: Total Debt: $78.4B
  • Plus: Cash & Equivalents: $48.2B
  • Equity Value: $456.2B
  • Shares Outstanding: 0.91B
  • Intrinsic Value per Share: $503.63
  • Current Price: $275.59
  • Upside/Downside: +82.7%
  • Margin of Safety: 45.3%
--------------------------------------------------------------------------------


================================================================================
SENSITIVITY ANALYSIS - Intrinsic Value per Share
================================================================================

How intrinsic value changes with different growth and discount rates:

Growth →           3%          5%          8%         10%         12%         15%   
WACC ↓      ------------------------------------------------------------------
   8%    $   341   $   404↑  $   520↑  $   613↑  $   722↑  $   919↑ 
   9%    $   283   $   334   $   428↑  $   504↑  $   591↑  $   750↑ 
  10%    $   240↓  $   283   $   361↑  $   424↑  $   496↑  $   627↑ 
  11%    $   208↓  $   244↓  $   310   $   363↑  $   424↑  $   534↑ 
  12%    $   182↓  $   214↓  $   271   $   316   $   368↑  $   462↑ 

Current Price: $275.59
Base FCF: $17.5B
Terminal Growth: 2.5% (constant)

Legend: ↑ = 30%+ upside  |  ↓ = 10%+ downside
================================================================================

================================================================================
REVERSE DCF — WHAT IS THE MARKET PRICING IN?
================================================================================

Using IDENTICAL assumptions as Base Case DCF:
  • WACC (Discount Rate): 9.5%
  • Terminal Growth Rate: 2.5%
  • Base FCF: $17.5B
  • Current Price: $275.59

  → Market-Implied FCF Growth Rate: 3.7%
  → Base Case uses: 7.0% growth → $361.71/share

  📊 Market is pricing in LOWER growth (3.7%) than our Base Case (7.0%)
     → Potential upside if company achieves base case growth
================================================================================

================================================================================
PROBABILITY-WEIGHTED VALUATION
================================================================================

Bear Case (233.60) × 25%  = $58.40
Base Case (361.71) × 50%  = $180.85
Bull Case (503.63) × 25%  = $125.91

========================================
Weighted Average Intrinsic Value: $365.16
Current Price: $275.59
Upside/Downside: +32.5%
Margin of Safety: 24.5%
================================================================================