Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT) 

Present Value of Free Cash Flow to the Firm (FCFF)

Microsoft Excel

Intrinsic Stock Value (Valuation Summary)

Microsoft Corp., free cash flow to the firm (FCFF) forecast

US$ in millions, except per share data

Microsoft Excel
Year Value FCFFt or Terminal value (TVt) Calculation Present value at 13.92%
01 FCFF0 72,929
1 FCFF1 87,271 = 72,929 × (1 + 19.66%) 76,606
2 FCFF2 102,733 = 87,271 × (1 + 17.72%) 79,159
3 FCFF3 118,936 = 102,733 × (1 + 15.77%) 80,445
4 FCFF4 135,378 = 118,936 × (1 + 13.82%) 80,377
5 FCFF5 151,459 = 135,378 × (1 + 11.88%) 78,936
5 Terminal value (TV5) 8,295,152 = 151,459 × (1 + 11.88%) ÷ (13.92%11.88%) 4,323,182
Intrinsic value of Microsoft Corp. capital 4,718,705
Less: Debt and finance lease liabilities (fair value) 86,572
Intrinsic value of Microsoft Corp. common stock 4,632,133
 
Intrinsic value of Microsoft Corp. common stock (per share) $623.24
Current share price $525.76

Based on: 10-K (reporting date: 2025-06-30).

Disclaimer!
Valuation is based on standard assumptions. There may exist specific factors relevant to stock value and omitted here. In such a case, the real stock value may differ significantly form the estimated. If you want to use the estimated intrinsic stock value in investment decision making process, do so at your own risk.


Weighted Average Cost of Capital (WACC)

Microsoft Corp., cost of capital

Microsoft Excel
Value1 Weight Required rate of return2 Calculation
Equity (fair value) 3,907,647 0.98 14.15%
Debt and finance lease liabilities (fair value) 86,572 0.02 3.67% = 4.39% × (1 – 16.37%)

Based on: 10-K (reporting date: 2025-06-30).

1 US$ in millions

   Equity (fair value) = No. shares of common stock outstanding × Current share price
= 7,432,377,655 × $525.76
= $3,907,646,875,892.80

   Debt and finance lease liabilities (fair value). See details »

2 Required rate of return on equity is estimated by using CAPM. See details »

   Required rate of return on debt. See details »

   Required rate of return on debt is after tax.

   Estimated (average) effective income tax rate
= (17.60% + 18.20% + 19.00% + 13.10% + 13.80% + 16.50%) ÷ 6
= 16.37%

WACC = 13.92%


FCFF Growth Rate (g)

FCFF growth rate (g) implied by PRAT model

Microsoft Corp., PRAT model

Microsoft Excel
Average Jun 30, 2025 Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020
Selected Financial Data (US$ in millions)
Interest expense 2,385 2,935 1,968 2,063 2,346 2,591
Net income 101,832 88,136 72,361 72,738 61,271 44,281
 
Effective income tax rate (EITR)1 17.60% 18.20% 19.00% 13.10% 13.80% 16.50%
 
Interest expense, after tax2 1,965 2,401 1,594 1,793 2,022 2,163
Add: Common stock cash dividends 24,677 22,293 20,226 18,552 16,871 15,483
Interest expense (after tax) and dividends 26,642 24,694 21,820 20,345 18,893 17,646
 
EBIT(1 – EITR)3 103,797 90,537 73,955 74,531 63,293 46,444
 
Short-term debt 6,693
Current portion of long-term debt 2,999 2,249 5,247 2,749 8,072 3,749
Current finance lease liabilities 3,172 2,349 1,197 1,060 791 540
Long-term debt, excluding current portion 40,152 42,688 41,990 47,032 50,074 59,578
Long-term finance lease liabilities 43,000 24,796 15,870 13,842 11,750 8,956
Stockholders’ equity 343,479 268,477 206,223 166,542 141,988 118,304
Total capital 432,802 347,252 270,527 231,225 212,675 191,127
Financial Ratios
Retention rate (RR)4 0.74 0.73 0.70 0.73 0.70 0.62
Return on invested capital (ROIC)5 23.98% 26.07% 27.34% 32.23% 29.76% 24.30%
Averages
RR 0.72
ROIC 27.28%
 
FCFF growth rate (g)6 19.66%

Based on: 10-K (reporting date: 2025-06-30), 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30).

1 See details »

2025 Calculations

2 Interest expense, after tax = Interest expense × (1 – EITR)
= 2,385 × (1 – 17.60%)
= 1,965

3 EBIT(1 – EITR) = Net income + Interest expense, after tax
= 101,832 + 1,965
= 103,797

4 RR = [EBIT(1 – EITR) – Interest expense (after tax) and dividends] ÷ EBIT(1 – EITR)
= [103,79726,642] ÷ 103,797
= 0.74

5 ROIC = 100 × EBIT(1 – EITR) ÷ Total capital
= 100 × 103,797 ÷ 432,802
= 23.98%

6 g = RR × ROIC
= 0.72 × 27.28%
= 19.66%


FCFF growth rate (g) implied by single-stage model

g = 100 × (Total capital, fair value0 × WACC – FCFF0) ÷ (Total capital, fair value0 + FCFF0)
= 100 × (3,994,219 × 13.92%72,929) ÷ (3,994,219 + 72,929)
= 11.88%

where:

Total capital, fair value0 = current fair value of Microsoft Corp. debt and equity (US$ in millions)
FCFF0 = the last year Microsoft Corp. free cash flow to the firm (US$ in millions)
WACC = weighted average cost of Microsoft Corp. capital


FCFF growth rate (g) forecast

Microsoft Corp., H-model

Microsoft Excel
Year Value gt
1 g1 19.66%
2 g2 17.72%
3 g3 15.77%
4 g4 13.82%
5 and thereafter g5 11.88%

where:
g1 is implied by PRAT model
g5 is implied by single-stage model
g2, g3 and g4 are calculated using linear interpolation between g1 and g5

Calculations

g2 = g1 + (g5g1) × (2 – 1) ÷ (5 – 1)
= 19.66% + (11.88%19.66%) × (2 – 1) ÷ (5 – 1)
= 17.72%

g3 = g1 + (g5g1) × (3 – 1) ÷ (5 – 1)
= 19.66% + (11.88%19.66%) × (3 – 1) ÷ (5 – 1)
= 15.77%

g4 = g1 + (g5g1) × (4 – 1) ÷ (5 – 1)
= 19.66% + (11.88%19.66%) × (4 – 1) ÷ (5 – 1)
= 13.82%