Projected Income Statement: Microsoft Corporation

Forecast Balance Sheet: Microsoft Corporation

Forecast Balance Sheet - Microsoft Corporation
Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 -54,976 -64,025 -30,606 -51,414 -36,549 -51,842 -28,461 99,570
Change - -16.46% 52.2% -67.99% 28.91% -41.84% 45.1% 449.85%
Announcement Date 7/26/22 7/25/23 7/30/24 7/30/25 7/29/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Microsoft Corporation

Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 23,886 28,107 44,477 64,551 115,948 192,759 215,739 247,306
Change - 17.67% 58.24% 45.13% 79.62% 66.25% 11.92% 14.63%
Free Cash Flow (FCF) 1 65,149 59,475 74,071 71,611 66,987 34,922 49,851 100,220
Change - -8.71% 24.54% -3.32% -6.46% -47.87% 42.75% 101.04%
Announcement Date 7/26/22 7/25/23 7/30/24 7/30/25 7/29/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Microsoft Corporation

Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029

Profitability

        
EBITDA Margin (%) 49.35% 48.87% 53.74% 57.74% 59.87% 61.22% 63.22% 65.44%
EBIT Margin (%) 42.06% 42.33% 44.64% 45.62% 46.78% 46.61% 46.46% 46.12%
EBT Margin (%) 42.22% 42.14% 43.97% 43.88% 50% 46.81% 46.54% 47.46%
Net margin (%) 36.69% 34.15% 35.96% 36.15% 40.31% 37.58% 37.62% 38.02%
FCF margin (%) 32.86% 28.07% 30.22% 25.42% 20.19% 8.92% 10.65% 17.58%
FCF / Net Income (%) 89.57% 82.19% 84.04% 70.32% 50.08% 23.75% 28.3% 46.25%

Profitability

        
ROA 20.82% 35.12% 19.07% 18% 19.42% 17.99% 17.82% 18.03%
ROE 47.15% 38.82% 37.13% 33.28% 34.04% 29.1% 27.73% 26.03%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - 0.27x
Debt / Free cash flow - - - - - - - 0.99x

Capital Intensity

        
CAPEX / Current Assets (%) 12.05% 13.26% 18.14% 22.91% 34.94% 49.26% 46.07% 43.39%
CAPEX / EBITDA (%) 24.41% 27.14% 33.77% 39.68% 58.36% 80.45% 72.87% 66.3%
CAPEX / FCF (%) 36.66% 47.26% 60.05% 90.14% 173.09% 551.98% 432.76% 246.76%

Items per share

        
Cash flow per share 1 11.81 11.72 15.87 18.24 24.55 30.72 37.73 47.76
Change - -0.74% 35.41% 14.92% 34.57% 25.14% 22.83% 26.6%
Dividend per Share 1 2.48 2.72 3 3.32 3.64 3.856 4.264 4.478
Change - 9.68% 10.29% 10.67% 9.64% 5.94% 10.56% 5.03%
Book Value Per Share 1 22.31 27.75 36.11 46.2 59.56 76.93 98.43 126.3
Change - 24.36% 30.15% 27.94% 28.92% 29.15% 27.95% 28.37%
EPS 1 9.65 9.68 11.8 13.64 17.95 19.72 23.61 29.41
Change - 0.31% 21.9% 15.59% 31.6% 9.85% 19.76% 24.56%
Nbr of stocks (in thousands) 7,479,033 7,435,488 7,432,306 7,432,544 7,428,435 7,425,545 7,425,545 7,425,545
Announcement Date 7/26/22 7/25/23 7/30/24 7/30/25 7/29/26 - - -
1USD
Estimates
2027 *2028 *
P/E 27.4x 22.8x
PBR 7.01x 5.48x
EV / Sales 10.1x 8.49x
Yield 0.71% 0.79%

EPS & Dividend

EPS & Dividend - Microsoft Corporation


Y-o-Y evolution of P/E

Valuation ratios - P/E - Microsoft Corporation
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Microsoft Corporation
Trader
Investor
Global
Quality
ESG MSCI
-
MarketScreener Ratings - Microsoft Corporation
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
56
Last Close Price
539.44USD
Average target price
599.24USD
Spread / Average Target
+11.09%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Microsoft Corporation
  1. Stock Market
  2. Stocks
  3. MSFT Stock
  4. MSFT19 Stock
  5. Financials Microsoft Corporation