Company Valuation: Microsoft Corporation

Data adjusted to current consolidation scope
Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
Market Cap 1 1,920,840 2,532,081 3,321,869 3,697,022 2,770,955 3,666,586 - -
Change - 31.82% 31.19% 11.29% -25.05% 32.32% - -
Enterprise Value (EV) 1 1,865,864 2,468,056 3,291,263 3,645,608 2,734,406 3,620,120 3,618,096 3,766,155
Change - 32.27% 33.35% 10.77% -24.99% 32.39% -0.06% 4.09%
P/E 26.6x 35.2x 37.9x 36.5x 20.8x 25.1x 20.9x 17.1x
PBR 11.5x 12.3x 12.4x 10.8x 6.26x 6.42x 5.02x 3.91x
PEG - 113.23x 1.7x 2.3x 0.7x 2.58x 1.1x 0.8x
Capitalization / Revenue 9.69x 11.9x 13.6x 13.1x 8.35x 9.38x 7.84x 6.45x
EV / Revenue 9.41x 11.6x 13.4x 12.9x 8.24x 9.26x 7.74x 6.63x
EV / EBITDA 19.1x 23.8x 25x 22.4x 13.8x 15.1x 12.3x 10.2x
EV / EBIT 22.4x 27.5x 30.1x 28.4x 17.6x 19.9x 16.7x 14.3x
EV / FCF 28.6x 41.5x 44.4x 50.9x 40.8x 112x 79x 40x
FCF Yield 3.49% 2.41% 2.25% 1.96% 2.45% 0.89% 1.27% 2.5%
Dividend per Share 2 2.48 2.72 3 3.32 3.64 3.968 4.26 4.421
Rate of return 0.97% 0.8% 0.67% 0.67% 0.98% 0.8% 0.86% 0.9%
EPS 2 9.65 9.68 11.8 13.64 17.95 19.7 23.59 28.89
Distribution rate 25.7% 28.1% 25.4% 24.3% 20.3% 20.1% 18.1% 15.3%
Net sales 1 198,270 211,915 245,122 281,724 331,839 391,037 467,439 568,207
EBITDA 1 97,843 103,555 131,720 162,681 198,685 238,986 294,297 369,739
EBIT 1 83,383 89,694 109,433 128,528 155,237 182,205 216,963 263,201
Net income 1 72,738 72,361 88,136 101,832 133,749 146,917 175,834 212,952
Net Debt 1 -54,976 -64,025 -30,606 -51,414 -36,549 -46,466 -48,490 99,570
Reference price 2 256.83 340.54 446.95 497.41 373.02 493.78 493.78 493.78
Nbr of stocks (in thousands) 7,479,033 7,435,488 7,432,306 7,432,544 7,428,435 7,425,545 - -
Announcement Date 7/26/22 A 7/25/23 A 7/30/24 A 7/30/25 A 7/29/26 A - - -
1USD in Million2USD
Estimates

P/E, Detailed evolution



P/E (Y) EV / Sales (Y) EV / EBITDA (Y) Dividend Yield (Y) Capi.($)
25.07x9.26x15.15x0.8% 3,667B
116.4x50.67x82.24x-.--% 427B
410.75x17.46x69.02x-.--% 82.56B
58.87x12.44x26.23x-.--% 77.91B
96.92x8.29x21x-.--% 73.77B
34.34x1.66x13.29x-.--% 62.34B
194.07x6.2x23.93x-.--% 48.61B
111.51x4.4x21.39x-.--% 38.42B
28.38x5.87x28.18x-.--% 37.45B
-32.7x4.65x26.41x-.--% 34.16B
Average 104.36x 12.09x 32.68x 0.08% 454.87B
Weighted average by Cap. 44.64x 13.09x 23.02x 0.65%

Y-o-Y evolution of P/E

Historical PBR trend

Evolution Enterprise Value / Sales

Change in Enterprise Value/EBITDA



Year-on-year evolution of the Yield

  1. Stock Market
  2. Stocks
  3. MSFT Stock
  4. Valuation Microsoft Corporation
-40%: Exceptional extension
d
:
:
SEIZE THE OFFER!