Projected Income Statement: Microsoft Corporation

Forecast Balance Sheet: Microsoft Corporation

balance-sheet-analysis-chart MICROSOFT-CORPORATION
Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 -73,200 -72,188 -54,976 -64,025 -30,606 -49,572 -97,882 -171,236
Change - -198.62% -176.16% -216.46% -147.8% -261.97% -297.45% -274.94%
Announcement Date 22/07/20 27/07/21 26/07/22 25/07/23 30/07/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Microsoft Corporation

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 15,441 20,622 23,886 28,107 44,477 60,677 67,503 70,068
Change - 33.55% 15.83% 17.67% 58.24% 36.42% 11.25% 3.8%
Free Cash Flow (FCF) 1 45,234 56,118 65,149 59,475 74,071 67,786 84,092 108,266
Change - 24.06% 16.09% -8.71% 24.54% -8.48% 24.05% 28.75%
Announcement Date 22/07/20 27/07/21 26/07/22 25/07/23 30/07/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Microsoft Corporation

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 45.98% 48.55% 49.35% 48.87% 53.74% 53.93% 54.43% 54.93%
EBIT Margin (%) 37.03% 41.59% 42.06% 42.33% 44.64% 44.23% 44.21% 44.5%
EBT Margin (%) 37.08% 42.3% 42.22% 42.14% 43.97% 42.99% 43.19% 43.95%
Net margin (%) 30.96% 36.45% 36.69% 34.15% 35.96% 34.95% 35.1% 35.61%
FCF margin (%) 31.63% 33.39% 32.86% 28.07% 30.22% 24.32% 26.38% 29.48%
FCF / Net Income (%) 102.15% 91.59% 89.57% 82.19% 84.04% 69.6% 75.16% 82.77%

Profitability

        
ROA 15.06% 19.3% 20.82% 35.12% 19.07% 17.98% 17.85% 18.12%
ROE 40.14% 47.08% 47.15% 38.82% 37.13% 31.34% 28.97% 27.36%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 10.8% 12.27% 12.05% 13.26% 18.14% 21.77% 21.18% 19.08%
CAPEX / EBITDA (%) 23.48% 25.27% 24.41% 27.14% 33.77% 40.37% 38.9% 34.73%
CAPEX / FCF (%) 34.14% 36.75% 36.66% 47.26% 60.05% 89.51% 80.27% 64.72%

Items per share

        
Cash flow per share 1 7.897 10.09 11.81 11.72 15.87 18.63 21.26 34.19
Change - 27.72% 17.07% -0.74% 35.41% 17.37% 14.15% 60.77%
Dividend per Share 1 2.04 2.24 2.48 2.72 3 3.259 3.577 3.977
Change - 9.8% 10.71% 9.68% 10.29% 8.63% 9.77% 11.18%
Book Value Per Share 1 15.63 18.88 22.31 27.75 36.11 46.77 60.34 75.71
Change - 20.85% 18.16% 24.36% 30.15% 29.5% 29.01% 25.48%
EPS 1 5.76 8.05 9.65 9.68 11.8 13.07 15.1 17.85
Change - 39.76% 19.88% 0.31% 21.9% 10.74% 15.51% 18.23%
Nbr of stocks (in thousands) 7,583,440 7,531,575 7,479,033 7,435,488 7,432,306 7,434,881 7,434,881 7,434,881
Announcement Date 22/07/20 27/07/21 26/07/22 25/07/23 30/07/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 33x 28.6x
PBR 9.22x 7.15x
EV / Sales 11.3x 9.75x
Yield 0.76% 0.83%
More valuation ratios * Estimated data

EPS & Dividend

eps-dividend-chart MICROSOFT-CORPORATION

Year-on-year evolution of the PER

evolution-chart MICROSOFT-CORPORATION

Year-on-year evolution of the Yield

evolution-chart MICROSOFT-CORPORATION
Trading Rating
Investor Rating
ESG Refinitiv
C+
surperformance-ratings-light-chart MICROSOFT-CORPORATIONMore Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
55
Last Close Price
431.20USD
Average target price
504.90USD
Spread / Average Target
+17.09%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. MSFT Stock
  4. Financials Microsoft Corporation
Exceptional Extension | BLACK FRIDAY -40% : Unlock Tomorrow's Top Investments with Our Exclusive Subscriber-Only Tools!
d
:
:
BENEFIT NOW