================================================================================
VALUATION SCENARIOS - DISCOUNTED CASH FLOW (DCF) ANALYSIS
================================================================================

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

Apple is a mature mega-cap with exceptional ROIC (60%) and strong FCF generation, but faces law of large numbers constraints. Historical 10%+ growth rates are unsustainable at $400B+ revenue scale. Services growth provides some offset to maturing hardware, but 10-year forward FCF growth should be more conservative than historical CAGRs.

Scenario Parameters (LLM-selected based on fundamental analysis):
  🔻 Bear: 3.0% growth, 10.5% WACC, 2.0% terminal
     → Assumes iPhone maturation, China/regulatory headwinds, and Services growth deceleration. Modest FCF growth reflects market saturation and margin pressure from competition.
  ⚖️  Base: 6.0% growth, 9.5% WACC, 2.5% terminal
     → Services continues mid-teens growth offsetting hardware maturation. Buybacks enhance per-share growth. Reflects Apple's quality moat but acknowledges scale limitations at $4T market cap.
  🔺 Bull: 9.0% growth, 8.5% WACC, 2.5% terminal
     → AI/AR product cycles drive hardware refresh, Services accelerates, and emerging markets expand. Strong execution across ecosystem maintains premium margins and share gains.

Base FCF: Using calculated FCF (OCF - CapEx) of $98.77B as it represents true cash available to shareholders. Reported FCF of $126.68B appears to include non-operating items. The calculated figure aligns better with sustainable cash generation given net income of $112B and typical FCF conversion rates.


Stock: AAPL
Current Price: $274.29
Shares Outstanding: 14.78B (14,776,353,000 shares)

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

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


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

ASSUMPTIONS:
  • FCF Growth Rate (Years 1-10): 3.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        $130,477,310,000      0.9050 $118,079,013,575
2        $134,391,629,300      0.8190 $110,064,600,889
3        $138,423,378,179      0.7412 $102,594,152,864
4        $142,576,079,524      0.6707 $95,630,748,824
5        $146,853,361,910      0.6070 $89,139,974,017
6        $151,258,962,767      0.5493 $83,089,749,536
7        $155,796,731,650      0.4971 $77,450,173,776
8        $160,470,633,600      0.4499 $72,193,374,651
9        $165,284,752,608      0.4071 $67,293,371,846
10       $170,243,295,186      0.3684 $62,725,948,418
------------------------------------------------------------
Total PV of 10-Year FCF:            $878,261,108,395

TERMINAL VALUE:
  • Year 11 FCF: $173,648,161,090
  • Terminal Value: $2,042,919,542,234
  • PV of Terminal Value: $752,711,381,014

VALUATION SUMMARY:
  • Enterprise Value: $1,631.0B
  • Less: Total Debt: $103.1B
  • Plus: Cash & Equivalents: $18.8B
  • Equity Value: $1,546.7B
  • Shares Outstanding: 14.78B
  • Intrinsic Value per Share: $104.67
  • Current Price: $274.29
  • Upside/Downside: -61.8%
  • Margin of Safety: -162.0%
--------------------------------------------------------------------------------


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

ASSUMPTIONS:
  • FCF Growth Rate (Years 1-10): 6.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        $134,277,620,000      0.9132 $122,627,963,470
2        $142,334,277,200      0.8340 $118,708,348,200
3        $150,874,333,832      0.7617 $114,914,017,435
4        $159,926,793,862      0.6956 $111,240,966,650
5        $169,522,401,494      0.6352 $107,685,319,314
6        $179,693,745,583      0.5801 $104,243,322,806
7        $190,475,370,318      0.5298 $100,911,344,451
8        $201,903,892,537      0.4838 $97,685,867,688
9        $214,018,126,090      0.4418 $94,563,488,356
10       $226,859,213,655      0.4035 $91,540,911,102
------------------------------------------------------------
Total PV of 10-Year FCF:            $1,064,121,549,472

TERMINAL VALUE:
  • Year 11 FCF: $232,530,693,996
  • Terminal Value: $3,321,867,057,090
  • PV of Terminal Value: $1,340,420,483,998

VALUATION SUMMARY:
  • Enterprise Value: $2,404.5B
  • Less: Total Debt: $103.1B
  • Plus: Cash & Equivalents: $18.8B
  • Equity Value: $2,320.2B
  • Shares Outstanding: 14.78B
  • Intrinsic Value per Share: $157.02
  • Current Price: $274.29
  • Upside/Downside: -42.8%
  • Margin of Safety: -74.7%
--------------------------------------------------------------------------------


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

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

10-YEAR FCF PROJECTION:
Year     FCF ($M)        PV Factor    PV of FCF ($M) 
------------------------------------------------------------
1        $138,077,930,000      0.9217 $127,260,764,977
2        $150,504,943,700      0.8495 $127,847,220,115
3        $164,050,388,633      0.7829 $128,436,377,811
4        $178,814,923,610      0.7216 $129,028,250,520
5        $194,908,266,735      0.6650 $129,622,850,753
6        $212,450,010,741      0.6129 $130,220,191,079
7        $231,570,511,708      0.5649 $130,820,284,126
8        $252,411,857,761      0.5207 $131,423,142,578
9        $275,128,924,960      0.4799 $132,028,779,180
10       $299,890,528,206      0.4423 $132,637,206,733
------------------------------------------------------------
Total PV of 10-Year FCF:            $1,299,325,067,872

TERMINAL VALUE:
  • Year 11 FCF: $307,387,791,411
  • Terminal Value: $5,123,129,856,858
  • PV of Terminal Value: $2,265,885,615,028

VALUATION SUMMARY:
  • Enterprise Value: $3,565.2B
  • Less: Total Debt: $103.1B
  • Plus: Cash & Equivalents: $18.8B
  • Equity Value: $3,480.9B
  • Shares Outstanding: 14.78B
  • Intrinsic Value per Share: $235.57
  • Current Price: $274.29
  • Upside/Downside: -14.1%
  • Margin of Safety: -16.4%
--------------------------------------------------------------------------------


================================================================================
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%    $   160↓  $   189↓  $   240↓  $   281   $   329   $   417↑ 
   9%    $   135↓  $   158↓  $   199↓  $   233↓  $   271   $   342  
  10%    $   116↓  $   135↓  $   169↓  $   197↓  $   229↓  $   287  
  11%    $   101↓  $   118↓  $   147↓  $   170↓  $   197↓  $   246↓ 
  12%    $    90↓  $   104↓  $   129↓  $   149↓  $   173↓  $   214↓ 

Current Price: $274.29
Base FCF: $126.7B
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: $126.7B
  • Current Price: $274.29

  → Market-Implied FCF Growth Rate: 13.3%
  → Base Case uses: 6.0% growth → $157.02/share

  📊 Market is pricing in HIGHER growth (13.3%) than our Base Case (6.0%)
     → Market expects more growth than our analysis supports — potential downside risk
================================================================================

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

Bear Case (104.67) × 25%  = $26.17
Base Case (157.02) × 50%  = $78.51
Bull Case (235.57) × 25%  = $58.89

========================================
Weighted Average Intrinsic Value: $163.57
Current Price: $274.29
Upside/Downside: -40.4%
Margin of Safety: -67.7%
================================================================================