MSFT / DCF Model v1.0

Microsoft Corporation (MSFT)

Fair Value$398

Assumptions

Adjust component growth drivers

FY25 $120.8B
Implied CAGR+12.8%
Adjust each component below to flex the segment outlook.
Components

Office Commercial

FY25 revenue $60.0B

13.0%

Base

Microsoft 365 commercial cloud revenue grew 17% YoY, with Copilot and E5 mix driving ARPU while paid seats expanded 6%.

M365 commercial cloud revenue+17% YoY

Office Consumer

FY25 revenue $8.0B

5.0%

Base

Consumer cloud revenue jumped 26% with premium tiers lifting ARPU; subscriptions rose 7% past 90M households.

Consumer cloud revenue+26% YoY

LinkedIn

FY25 revenue $20.0B

10.0%

Base

LinkedIn revenue grew 10% YoY, fueled by marketing solutions while Talent Solutions softened alongside the hiring market.

LinkedIn members1.3B

Dynamics 365

FY25 revenue $33.0B

16.0%

Base

Dynamics 365 maintained high-teens momentum with broad-based demand across workloads and Fabric-driven analytics pull-through.

Dynamics 365 revenue+18% YoY
FY25 $106.3B
Implied CAGR+23.9%
Adjust each component below to flex the segment outlook.
FY25 $54.6B
Implied CAGR+5.8%
Adjust each component below to flex the segment outlook.

Valuation Model

Microsoft Corporation (MSFT)

Real-time financial projections and AI-written summary

Enterprise Value

$2.95T

Fair Value $398 | Upside -19.4%

Generating updated DCF summary...

Discounted Cash Flow Model

WACC (Discount Rate)

8.9%

Terminal Growth

3.5%

Implied Fair Value

$398

Metric ($B)2026202720282029203020312032203320342035
Productivity & Business Processes137.0154.0171.0188.0204.0219.0234.0249.0265.0281.0
% YoY12.4%11.0%9.9%8.5%7.4%6.8%6.4%6.4%6.0%
Intelligent Cloud132.0163.0199.0238.0279.0321.0369.0421.0477.0536.0
% YoY23.5%22.1%19.6%17.2%15.1%15.0%14.1%13.3%12.4%
More Personal Computing59.064.068.072.075.078.081.084.087.090.0
% YoY8.5%6.3%5.9%4.2%4.0%3.8%3.7%3.6%3.4%
Total Revenue328.0381.0438.0498.0558.0618.0684.0754.0829.0907.0
% YoY16.2%15.0%13.7%12.0%10.8%10.7%10.2%9.9%9.4%
FCF Margin25.5%25.5%26.0%26.5%27.0%27.0%27.0%27.0%27.0%27.0%
Free Cash Flow83.697.2113.9132.0150.7166.9184.7203.6223.8244.9
% YoY16.3%17.2%15.9%14.2%10.7%10.7%10.2%9.9%9.4%
Discount Factor0.9180.8430.7740.7110.6530.5990.5500.5050.4640.426
Present Value76.781.988.293.998.4100.0101.6102.8103.8104.3

PV of 10yr FCF

$951.6B

PV Terminal Val

$2.0T

Enterprise Value

$3.0T

Equity Value

$3.0T

Revenue Trajectory by Segment

Projected revenue breakdown (10-Year)

Segment ($B)2026202720282029203020312032203320342035
Productivity & Business Processes137.0B154.0B171.0B188.0B204.0B219.0B234.0B249.0B265.0B281.0B
Intelligent Cloud132.0B163.0B199.0B238.0B279.0B321.0B369.0B421.0B477.0B536.0B
More Personal Computing59.0B64.0B68.0B72.0B75.0B78.0B81.0B84.0B87.0B90.0B
Total Revenue328.0B381.0B438.0B498.0B558.0B618.0B684.0B754.0B829.0B907.0B

Sensitivity Matrix

Impact of WACC & Growth assumptions

Overvalued
Fair
Undervalued
WACC \ Growth3.0%3.5%4.0%4.5%
8.4%
$413
$443
$480
$527
8.9%
$374
$398
$427
$463
9.4%
$342
$361
$384
$412
9.9%
$314
$330
$348
$370

Investment Recommendation

Thesis & risk assessment

RatingHOLD
Target Price
$398

12-month price objective

Upside vs Market
-19.0%

Current price $494

Suggested Entry
$420 – $450

Represents -15% to -9% vs current price

Bull Case Catalysts
  • Azure AI capacity additions beat targets
  • Copilot adoption exceeds 40% penetration
  • Cloud margins rebound to 72%+
  • Bing AI hits >5% U.S. share
  • Gaming synergies >$1B annually
Bear Risks
  • AI monetization lags investment
  • AWS/Google share gains
  • Activision or AI regulation
  • Prolonged capex drag on margins
  • Enterprise IT slowdown

This automated valuation is for informational purposes only and does not constitute financial advice. Outputs depend on user-defined assumptions and may differ materially from future market performance.