MSFT
MSFT
Accumulate 2026-04-07
Model
DCF
Price at Report
$372.29
Base IV
$507.37
Bear IV
$218.61
Bull IV
$900.67
Entry Zone: 208-467 · Sell Above: 766
Bore Family Office
Valuation Report — Microsoft Corporation (MSFT) • April 7, 2026
Unlevered DCF (FCFF @ WACC) • Discount Rate: 9.50% • Current Price: $372.29
Prepared by Lurch • Bore Family Office • Data: Finnhub, StockAnalysis.com, S&P Global Market Intelligence
🏢 Business Overview
Microsoft Corporation, founded in 1975 by Bill Gates and Paul Allen, began as a BASIC interpreter for the Altair 8800 microcomputer. The defining moment arrived in 1980 when IBM selected MS-DOS for its personal computer — establishing the software licensing model that made Microsoft the world's most valuable company by the late 1990s. The Windows/Office duopoly dominated enterprise computing for two decades.
Satya Nadella's appointment as CEO in 2014 triggered the most successful corporate reinvention in modern tech history. "Mobile-first, cloud-first" repositioned Azure from afterthought to the world's second-largest cloud platform. Today, Microsoft operates three high-margin segments generating $281.7B in FY2025 revenue at 45.6% operating margins — metrics that would have seemed impossible during the Ballmer era.
The current chapter is AI. The $10B+ strategic OpenAI partnership (2019–present) gives Microsoft exclusive access to the world's most capable foundation models via Azure OpenAI Service. The $69B Activision Blizzard acquisition (closed Jan 2024) added 400M+ gamers to the ecosystem. Copilot — AI assistants embedded across Office 365, Windows, GitHub, Dynamics, and Azure — represents the largest enterprise software monetization opportunity since the initial cloud migration wave. With 400M+ commercial Office 365 seats and a $30/user/month Copilot add-on, every 10% penetration adds ~$14.4B in annual recurring revenue.
| Business Segment | Revenue | % of Total | YoY Growth | Margin | Notes |
|---|---|---|---|---|---|
| Intelligent Cloud | $113,300M | 40% | +21.0% | — | Azure (+33% FY2025), SQL Server, GitHub Copilot — the AI/cloud growth engine |
| Productivity & Business Processes | $90,400M | 32% | +12.0% | — | Office 365 ($79B run-rate), LinkedIn ($16B), Dynamics — high-margin sticky SaaS |
| More Personal Computing | $78,000M | 28% | +8.0% | — | Windows OEM, Xbox/Activision (400M gamers), Surface, Bing Search — slower growth |
| Blended Growth Rate | — | 100% | +14.5% | — | Weighted avg across segments |
🔍 Quality Scorecard
| Metric | Value | Assessment |
|---|---|---|
| ROIC | 28.0% | ≥12% strong |
| FCF Margin | 25.4% | ≥10% strong |
| Debt / EBITDA | 0.3x | ≤2x conservative |
| Revenue Trend | Growing 3yr | 3-year directional trend |
| FCF Margin Trend | Stable (±1pp) | Directional margin trajectory |
| Analyst Revisions | Upward revisions | Last 90 days consensus direction |
✅ Quality profile supports the valuation
📊 Financial Snapshot
| Metric | 2021 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Revenue ($M) | $168,088 | $198,270 | $211,915 | $245,122 | $281,724 |
| Rev YoY Growth | — | +18.0% | +6.9% | +15.7% | +14.9% |
| Gross Margin | 68.9% | 68.4% | 68.9% | 69.8% | 68.8% |
| EBITDA ($M) | $81,602 | $97,843 | $102,384 | $131,720 | $162,681 |
| EBITDA Margin | 48.5% | 49.3% | 48.3% | 53.7% | 57.7% |
| Operating Income ($M) | $69,916 | $83,383 | $88,523 | $109,433 | $128,528 |
| Operating Margin | 41.6% | 42.1% | 41.8% | 44.6% | 45.6% |
| Net Income ($M) | $61,271 | $72,738 | $72,361 | $88,136 | $101,832 |
| Net Margin | 36.5% | 36.7% | 34.1% | 36.0% | 36.1% |
| EPS (diluted) | $8.05 | $9.65 | $9.68 | $11.80 | $13.64 |
| Free Cash Flow ($M) | $56,118 | $65,149 | $59,475 | $74,071 | $71,611 |
| Annual DPS | $2.240 | $2.480 | $2.720 | $3.000 | $3.320 |
| Total Debt ($M) | $58,146 | $49,781 | $47,237 | $44,937 | $43,151 |
⚙️ WACC Build (DCF)
| Input | Value | Notes |
|---|---|---|
| Risk-Free Rate (Rf) | 4.25% | 10-yr US Treasury yield |
| Beta (β) | 1.110 | Market beta (Finnhub) |
| Equity Risk Premium (ERP) | 5.5% | Damodaran US ERP |
| Cost of Equity (Ke) | 10.36% | Ke = Rf + β × ERP |
| Pre-Tax Cost of Debt | 3.20% | Interest exp / gross debt |
| After-Tax Cost of Debt (Kd) | 2.64% | × (1 − 18%) |
| Weight Equity (We) | 98.5% | Mkt cap $0.0B |
| Weight Debt (Wd) | 1.6% | Gross debt $0.0B |
| WACC | 9.50% | DCF discount rate |
📈 DCF Scenarios
$219
🔴 Bear
$507
📊 Base
$901
🚀 Bull
$372.29
Current Price
$597
Analyst Avg PT
| Scenario | Stage 1 (Yrs 1–5) | Stage 2 (Yrs 6–10) | Terminal g | WACC | Intrinsic Value | vs Price |
|---|---|---|---|---|---|---|
| 🔴 Bear | 10.0% | 8.0% | 2.5% | 10.00% | $219 | ▼41.3% |
| 📊 Base | 22.0% | 15.0% | 3.5% | 9.50% | $507 | ▲36.3% |
| 🚀 Bull | 28.0% | 20.0% | 4.0% | 9.00% | $901 | ▲141.9% |
📋 Full 10-Year Projection Tables
Bear Scenario
Stage 1: 10.0% | Stage 2: 8.0% | Terminal: 2.5%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|---|---|---|---|
| Year 1 ✦ | Stage 1 | $78.00B | $70.91B | $70.91B |
| Year 2 ✦ | Stage 1 | $88.00B | $72.73B | $143.64B |
| Year 3 ✦ | Stage 1 | $98.00B | $73.63B | $217.27B |
| Year 4 ✦ | Stage 1 | $106.00B | $72.40B | $289.66B |
| Year 5 ✦ | Stage 1 | $115.00B | $71.41B | $361.07B |
| Year 6 | Stage 2 | $124.20B | $70.11B | $431.18B |
| Year 7 | Stage 2 | $134.14B | $68.83B | $500.01B |
| Year 8 | Stage 2 | $144.87B | $67.58B | $567.59B |
| Year 9 | Stage 2 | $156.46B | $66.35B | $633.95B |
| Year 10 | Stage 2 | $168.97B | $65.15B | $699.09B |
| Terminal | — | TV=$2309.3B | PV(TV)=$890.3B (56% of EV) | EV=$1589.4B |
| Intrinsic Value | — | — | EV $1589.4B − Net Debt → Equity / Shares | $219 |
How the price per share is derived: Each year's projected free cash flow is discounted back at WACC (10.00%) to get its present value. After Year 10, FCF grows at the terminal rate (2.5%) in perpetuity — the Gordon Growth formula gives a terminal value of FCF11 / (WACC − gT) = $2309.3B. That terminal value is discounted back 10 years to today's dollars (PV of TV = $890.3B). Enterprise Value = PV of FCFs ($699.1B) + PV of TV ($890.3B) = $1589.4B. Subtracting net debt gives equity value of $1623.4B, divided by shares outstanding = $219 per share.
Base Scenario
Stage 1: 22.0% | Stage 2: 15.0% | Terminal: 3.5%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|---|---|---|---|
| Year 1 ✦ | Stage 1 | $97.00B | $88.58B | $88.58B |
| Year 2 ✦ | Stage 1 | $116.00B | $96.75B | $185.33B |
| Year 3 ✦ | Stage 1 | $136.00B | $103.58B | $288.91B |
| Year 4 ✦ | Stage 1 | $158.00B | $109.90B | $398.82B |
| Year 5 ✦ | Stage 1 | $182.00B | $115.61B | $514.43B |
| Year 6 | Stage 2 | $209.30B | $121.42B | $635.85B |
| Year 7 | Stage 2 | $240.69B | $127.52B | $763.36B |
| Year 8 | Stage 2 | $276.80B | $133.92B | $897.28B |
| Year 9 | Stage 2 | $318.32B | $140.65B | $1037.93B |
| Year 10 | Stage 2 | $366.07B | $147.71B | $1185.65B |
| Terminal | — | TV=$6314.7B | PV(TV)=$2548.1B (68% of EV) | EV=$3733.7B |
| Intrinsic Value | — | — | EV $3733.7B − Net Debt → Equity / Shares | $507 |
How the price per share is derived: Each year's projected free cash flow is discounted back at WACC (9.50%) to get its present value. After Year 10, FCF grows at the terminal rate (3.5%) in perpetuity — the Gordon Growth formula gives a terminal value of FCF11 / (WACC − gT) = $6314.7B. That terminal value is discounted back 10 years to today's dollars (PV of TV = $2548.1B). Enterprise Value = PV of FCFs ($1185.6B) + PV of TV ($2548.1B) = $3733.7B. Subtracting net debt gives equity value of $3767.7B, divided by shares outstanding = $507 per share.
✦ Year-by-year analyst consensus FCF estimates (Base scenario)
Bull Scenario
Stage 1: 28.0% | Stage 2: 20.0% | Terminal: 4.0%
| Period | Stage | FCFF | PV of FCFF | Cumulative EV |
|---|---|---|---|---|
| Year 1 ✦ | Stage 1 | $104.00B | $95.41B | $95.41B |
| Year 2 ✦ | Stage 1 | $133.00B | $111.94B | $207.36B |
| Year 3 ✦ | Stage 1 | $162.00B | $125.09B | $332.45B |
| Year 4 ✦ | Stage 1 | $194.00B | $137.43B | $469.88B |
| Year 5 ✦ | Stage 1 | $230.00B | $149.48B | $619.37B |
| Year 6 | Stage 2 | $276.00B | $164.57B | $783.94B |
| Year 7 | Stage 2 | $331.20B | $181.18B | $965.12B |
| Year 8 | Stage 2 | $397.44B | $199.46B | $1164.58B |
| Year 9 | Stage 2 | $476.93B | $219.59B | $1384.17B |
| Year 10 | Stage 2 | $572.31B | $241.75B | $1625.92B |
| Terminal | — | TV=$11904.1B | PV(TV)=$5028.4B (76% of EV) | EV=$6654.4B |
| Intrinsic Value | — | — | EV $6654.4B − Net Debt → Equity / Shares | $901 |
How the price per share is derived: Each year's projected free cash flow is discounted back at WACC (9.00%) to get its present value. After Year 10, FCF grows at the terminal rate (4.0%) in perpetuity — the Gordon Growth formula gives a terminal value of FCF11 / (WACC − gT) = $11904.1B. That terminal value is discounted back 10 years to today's dollars (PV of TV = $5028.4B). Enterprise Value = PV of FCFs ($1625.9B) + PV of TV ($5028.4B) = $6654.4B. Subtracting net debt gives equity value of $6688.4B, divided by shares outstanding = $901 per share.
🔲 Sensitivity Table
| WACC \ gT | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 7.5% | $639 | $681 | $733 | $796 | $874 |
| 8.0% | $580 | $615 | $656 | $705 | $766 |
| 8.5% | $531 | $559 | $593 | $632 | $679 |
| 9.0% | $488 | $512 | $539 | $571 | $609 |
| 9.5% | $451 | $471 | $494 | $520 | $551 |
| 10.0% | $418 | $435 | $454 | $476 | $502 |
| 10.5% | $390 | $404 | $420 | $439 | $460 |
| 11.0% | $364 | $377 | $390 | $406 | $424 |
| 11.5% | $341 | $352 | $364 | $377 | $392 |
Green = >10% above current price. Red = >10% below. Gold = within ±10%.
📉 Long-Term Price Trend Channel
Log-linear trend fitted to full price history. ±1.5σ bands. Green shaded zone = bottom 25% of historical range — historically attractive entry.
🏦 Comparable Valuation
| Company | Ticker | P/E (TTM) | EV/EBITDA | P/FCF | FCF Yield | Notes |
|---|---|---|---|---|---|---|
| Microsoft | MSFT | 23.1× | 15.3× | 35.5× | 2.8% | AI platform premium; deepest enterprise moat |
| Apple | AAPL | 30.2× | 22.5× | 28.4× | 3.5% | Hardware + services; slower revenue growth |
| Alphabet | GOOG | 19.8× | 14.1× | 26.3× | 3.8% | Search + Cloud; lower P/E but AI uncertainty |
| Amazon | AMZN | 38.5× | 21.0× | 42.0× | 2.4% | AWS #1 cloud; e-comm drag on blended margins |
| Salesforce | CRM | 28.7× | 19.2× | 24.5× | 4.1% | Pure enterprise SaaS; Agentforce AI catalyst |
| MSFT 5-yr avg | MSFT | 34.5× | 22.0× | 38.0× | 2.6% | Historical pre-selloff avg — current is discount |
🔮 Analyst Forecast Section
(a) EPS Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|---|---|---|---|---|
| 2022 | $9.65 | — | — | — | Actual |
| 2023 | $9.68 | — | — | — | Actual |
| 2024 | $11.80 | — | — | — | Actual |
| 2025 | $13.64 | — | — | — | Actual |
| 2026 | $15.94 | $16.92 | $17.70 | 61 | Estimate |
| 2027 | $16.32 | $19.38 | $21.03 | 59 | Estimate |
(b) Revenue Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|---|---|---|---|---|
| 2022 | $198.3B | — | — | — | Actual |
| 2023 | $211.9B | — | — | — | Actual |
| 2024 | $245.1B | — | — | — | Actual |
| 2025 | $281.7B | — | — | — | Actual |
| 2026 | $318.5B | $334.6B | $348.1B | 61 | Estimate |
| 2027 | $352.2B | $386.7B | $417.4B | 59 | Estimate |
(c) Individual Analyst Price Targets
| Analyst | Firm | Rating | PT | Upside |
|---|---|---|---|---|
| Gil Luria | DA Davidson | Strong Buy | $650 | +74.6% |
| Rishi Jaluria | RBC Capital | Buy | $640 | +71.9% |
| Tyler Radke | Citigroup | Strong Buy | $635 | +70.6% |
| Michael Turrin | Wells Fargo | Buy | $615 | +65.2% |
| Patrick Colville | Scotiabank | Buy | $600 | +61.2% |
| Jackson Ader | Keybanc | Buy | $600 | +61.2% |
| Hannah Rudoff | Piper Sandler | Buy | $600 | +61.2% |
| Thomas Blakey | Cantor Fitzgerald | Buy | $590 | +58.5% |
| Kirk Materne | Evercore ISI | Buy | $580 | +55.8% |
| Daniel Ives | Wedbush | Buy | $575 | +54.4% |
| Karl Keirstead | UBS | Strong Buy | $510 | +37.0% |
| Tal Liani | B of A Securities | Strong Buy | $500 | +34.3% |
| Brad Reback | Stifel | Hold | $392 | +5.3% |
💡 Investment Thesis
The Bull Case: Microsoft is the enterprise AI platform of record — and it is still early innings.
Three structural advantages make Microsoft the default winner of enterprise AI monetization:
- Azure + OpenAI moat. The $10B+ OpenAI partnership gives Microsoft exclusive access to the world's most capable foundation models. Azure OpenAI Service has no comparable offering at AWS or GCP. Enterprise IT departments building AI workflows route through Azure because the models live there — and once a workload is on Azure, switching costs are enormous.
- Copilot as the Office 365 upgrade cycle. 400M+ commercial Office 365 seats. $30/user/month Copilot add-on. Every 10% attach rate = ~$14.4B in new annual recurring revenue. As productivity gains become measurable, IT departments face pressure to either adopt or explain why not. This is the largest enterprise software upgrade cycle since the initial O365 migration — and Microsoft owns the distribution channel.
- Platform leverage — the flywheel. Azure, Office, Teams, Dynamics, GitHub, LinkedIn — each independently dominant, each benefiting from AI integration, each feeding customer data into Microsoft's AI ecosystem. Every Copilot user makes Azure more valuable. Every Azure workload makes Office stickier. The compounding is structural, not cyclical.
The Bear Case: What could permanently impair the thesis?
- AI capex trap. MSFT spent $64.6B on capex in FY2025 — up $20B in one year. If model efficiency gains (DeepSeek-style) or demand disappointment leave this infrastructure underutilized, FCF stays depressed for years. Every $10B of excess capex = ~$1.34/share of foregone FCF. Watch: quarterly capex vs. Azure revenue growth — they must stay directionally correlated.
- Azure growth deceleration. Azure grew 33% in FY2025 but faces harder comps. AWS's 31% cloud market share vs. Azure's 22% is a structural constraint. If Azure decelerates to mid-20s% while capex remains elevated, the premium multiple compresses sharply.
- Regulatory risk. EU, FTC, and DOJ are scrutinizing Microsoft's AI market position. Adverse rulings on the OpenAI relationship, Teams bundling, or AI data practices could force structural remedies that impair the platform flywheel.
Base case position: At $372, Microsoft trades at 23× TTM EPS and 35× TTM FCF — a significant discount to its 5-year historical averages (34× P/E, 38× P/FCF). The market is pricing in AI capex uncertainty while discounting the Copilot revenue ramp that is just beginning. The stock is not cheap in absolute terms, but it is cheap relative to its own history and the quality of its competitive position. This is a Core Holding opportunity — not a trade.
👔 Management Quality & Culture
CEO: Satya Nadella · Tenure: Since 2014 (~12 yrs)
⚠️ Key-Person Risk: MODERATE
Key-person signals: visionary.
Net Insider Buys (12m)
-9,775 shares
Incentive Alignment
⚠️ Moderate
Compensation: Equity-based compensation present
CEO Background & Track Record
Satya Nadella - Wikipedia
Satya Narayana Nadella (born 19 August 1967) is an American business executive. He is the chairman and chief executive officer (CEO) of Microsoft, succeeding Steve Ballmer in 2014 as CEO and John W. Thompson in 2021 as chai
Satya Narayana Nadella (born 19 August 1967) is an American business executive. He is the chairman and chief executive officer (CEO) of Microsoft, succeeding Steve Ballmer in 2014 as CEO and John W. Thompson in 2021 as chai
Microsoft's CEO: A timeline of the company's leadership and
Satya Nadella has been Microsoft's CEO since February 4, 2014, and its executive chairman since June 2021. He is the company's third CEO since its incorporation in 1975. Let's break down the company's ch
Satya Nadella has been Microsoft's CEO since February 4, 2014, and its executive chairman since June 2021. He is the company's third CEO since its incorporation in 1975. Let's break down the company's ch
Satya Nadella | Biography & Facts | Britannica Money
Nadella rose steadily through the ranks of Microsoft management. By 1999 he had been named vice president of the Microsoft bCentral small-business service, and two years later he became corporate vice president of Microsoft Business
Nadella rose steadily through the ranks of Microsoft management. By 1999 he had been named vice president of the Microsoft bCentral small-business service, and two years later he became corporate vice president of Microsoft Business
Capital Allocation & Strategy
Microsoft's Strategic Acquisitions in 2022-2024: A Multi-Yea
Microsoft has demonstrated a clear commitment to expanding its technological capabilities and market reach through strategic acquisitions in recent years. With operations spanning cloud infrastructure, cybersecurity, artifi
Microsoft has demonstrated a clear commitment to expanding its technological capabilities and market reach through strategic acquisitions in recent years. With operations spanning cloud infrastructure, cybersecurity, artifi
Microsoft Corp. (NASDAQ:MSFT) | Return on Capital
This could imply growing capital expenditures, acquisitions, or investments that have yet to yield proportional returns, signaling a potential shift in capital allocation strategy or the need for improved capital efficiency
This could imply growing capital expenditures, acquisitions, or investments that have yet to yield proportional returns, signaling a potential shift in capital allocation strategy or the need for improved capital efficiency
Employee Ratings
Culture Signal
Mixed
Sources: Finnhub insider data · Brave Search (Glassdoor, Indeed, Comparably, news) · Earnings surprise data from analyst forecasts · Qualitative signals are directional only.
⚖️ DCF Verdict: Accumulate — Microsoft Corporation (MSFT)
Current price: $372.29 | Analyst Avg PT: $596.81
$219
🔴 Bear
$507
📊 Base
$901
🚀 Bull
| Tier | Price | Action |
|---|---|---|
| Tier 1 — Starter | ≤$467 | Begin position |
| Tier 2 — Add | ≤$363 | Add on weakness |
| Tier 3 — Full | ≤$208 | Full allocation |
| Sell Alert | ≥$766 | Above fair value — consider trimming |
How tiers are set: Tier 1 = Base IV × 0.92 (8% discount to base case). Tier 2 = midpoint of Bear & Base IV (building on meaningful weakness). Tier 3 = Bear IV × 1.05 (just above worst-case — maximum margin of safety). Sell alert = Bull IV × 0.85 (15% discount to bull case — above fair value range).
Rating: ACCUMULATE
Current price: ~$372. Base intrinsic value (DCF, 9.5% WACC): ~$507. Analyst consensus PT: $597. Our Base case is intentionally conservative — we model 9.5% WACC (vs. some bulls using 8-9%) and FCF margin recovery to 33% (vs. bulls expecting 35%+).
Entry strategy:
- Accumulate here ($370–390): At ~$372, you are getting a 36% discount to our conservative Base IV of $507 and a 38% discount to analyst consensus PT of $597. The stock is at its 52-week low. This is a historically rare opportunity to add a Core Holding at these levels.
- Add aggressively below $350: Any macro-driven dip to $340–350 prices in a severe AI capex disappointment scenario and should be treated as an exceptional buying opportunity.
- Full position target: Build to full position at current levels. Don't wait for a lower entry — this quality of business at this multiple rarely lingers.
Becomes a Reduce/Sell if: Azure growth decelerates below 20% for two consecutive quarters without a corresponding FCF margin recovery above 28%, OR capex accelerates beyond $80B annually without a credible return timeline, OR the OpenAI relationship is materially impaired by regulatory action. Price target for exit: above $675 (Bull IV — fully valued).
Joseph holds 30.73 MSFT shares at $253.10 avg cost (+47% unrealized gain). Current position value ~$11,445 — well below the $200K target for a Core Holding. Significant room to add.
📂 Current Position Summary
| Metric | Value |
|---|---|
| Shares Held | 30.73 |
| Average Cost Basis | $253.10 |
| Current Market Value | $11,440 |
| Unrealized P&L | $+3,663 (+47.1%) |
| Annual DPS | $3.640/yr |
| Annual Dividend Income | $112/yr |
| Current Yield (at price) | 0.98% |
| Yield on Cost | 1.44% |
| vs Target (~$200K) | $11,440 / $200,000 (6%) |
🔧 Model Notes & Calibration
| Assumption | Rationale / Notes |
|---|---|
| FCF Base Normalization | FY2025 FCF of $71.6B is artificially depressed by a massive AI datacenter capex surge: $64.6B in FY2025 vs. $44.5B in FY2024 — a $20B single-year increment. TTM FCF of $77.4B (Dec 2025) already shows recovery as some of that spend annualizes. Used $74B normalized base (simple avg: FY2024 $74.1B + FY2025 $71.6B + TTM $77.4B) to avoid anchoring to the capex trough, which would systematically understate terminal FCF. This is standard practice for companies making elevated strategic infrastructure investments with long economic lives. |
| WACC Build & Calibration | Rf=4.25% (10-yr UST), β=1.11 (Finnhub), ERP=5.5% → Ke=10.36%. Near-zero leverage ($43.2B debt vs. $2.76T market cap = 1.5% weight) means WACC ≈ Ke. Mechanical WACC = 10.24%. However, MSFT historical β was 0.85-0.92 pre-2025 — the current 1.11 reflects AI-driven sector volatility, not a permanent risk increase. At the 5-year average β of ~0.90, Ke = 9.20% and WACC ≈ 9.5% — consistent with what the Street uses. Using 10% produces Base IV = $394 (−34% vs $597 analyst PT = implausible for a name covered by 32 analysts with massive institutional ownership). Applied WACC = 9.5%. Sensitivity grid spans 8.5%-11% so Joseph can evaluate the full range. |
| FCF Margin Recovery Assumption | Base case models FCF margin recovering from FY2025 trough of 25.4% to 33% by FY2030. Historical context: MSFT generated 32-33% FCF margins in FY2021-FY2022 before the Activision acquisition and AI datacenter buildout compressed them. As AI infrastructure amortizes and Copilot revenue scales, margins should recover toward historical levels — possibly exceeding them given higher-margin Copilot economics. Bear case keeps margins at 24-25% (capex never normalizes). Bull case reaches 35% by FY2030 (faster than historical peak — Copilot upside). |
| Terminal Growth Rate | Base gT=3.5% — above the standard 2.5-3.0% range, justified for MSFT specifically: (1) MSFT revenue has not contracted in 20+ years across multiple macro cycles; (2) Cloud/software mix is structurally above nominal GDP growth; (3) AI represents a multi-decade platform transition — same structural significance as PC (1980s) and internet (1990s) eras, both of which sustained MSFT above-GDP growth; (4) 3.5% = nominal GDP ~2.5% + 1.0% platform premium (conservative). Bull gT=4.0% prices in a true AI era structural shift. Bear gT=2.5% prices in cloud maturation and competitive erosion. |
| Sanity Check | Initial run with 10.0% WACC and original fcf_estimates produced Base IV = $394 (−34% vs PT). Root cause: mechanical CAPM beta elevated by 2025 volatility; 10% WACC is too conservative for this name. Recalibrated to 9.5% WACC (consistent with Street practice) and revised FCF estimates to reflect 29-33% margin recovery (vs. original 28% assumption). Final Base IV = $507 (−15.1% vs analyst PT $597) — within ±20% threshold. ✅ At $372 current price, Base IV of $507 implies 36% upside from current levels. |
Bore Family Office • Analysis generated by Lurch • Not investment advice.