Projected Income Statement: Microsoft Corporation

Forecast Balance Sheet: Microsoft Corporation

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -72,188 -54,976 -64,025 -30,606 -51,414 -65,079 -93,947 -146,664
Change - 23.84% -16.46% 52.2% -67.99% -26.58% -44.36% -56.11%
Announcement Date 27/07/21 26/07/22 25/07/23 30/07/24 30/07/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Microsoft Corporation

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 20,622 23,886 28,107 44,477 64,551 98,215 114,563 115,563
Change - 15.83% 17.67% 58.24% 45.13% 52.15% 16.65% 0.87%
Free Cash Flow (FCF) 1 56,118 65,149 59,475 74,071 71,611 75,968 86,582 116,449
Change - 16.09% -8.71% 24.54% -3.32% 6.08% 13.97% 34.5%
Announcement Date 27/07/21 26/07/22 25/07/23 30/07/24 30/07/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Microsoft Corporation

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

Profitability

        
EBITDA Margin (%) 48.55% 49.35% 48.87% 53.74% 57.74% 61.03% 61.42% 62.88%
EBIT Margin (%) 41.59% 42.06% 42.33% 44.64% 45.62% 46.03% 46.17% 46.37%
EBT Margin (%) 42.3% 42.22% 42.14% 43.97% 43.88% 44.17% 45.53% 46.08%
Net margin (%) 36.45% 36.69% 34.15% 35.96% 36.15% 35.76% 36.92% 37.33%
FCF margin (%) 33.39% 32.86% 28.07% 30.22% 25.42% 23.26% 23.07% 26.78%
FCF / Net Income (%) 91.59% 89.57% 82.19% 84.04% 70.32% 65.03% 62.5% 71.74%

Profitability

        
ROA 19.3% 20.82% 35.12% 19.07% 18% 17.78% 17.53% 18.08%
ROE 47.08% 47.15% 38.82% 37.13% 33.28% 31.19% 27.44% 26.01%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 12.27% 12.05% 13.26% 18.14% 22.91% 30.07% 30.53% 26.57%
CAPEX / EBITDA (%) 25.27% 24.41% 27.14% 33.77% 39.68% 49.27% 49.71% 42.26%
CAPEX / FCF (%) 36.75% 36.66% 47.26% 60.05% 90.14% 129.29% 132.32% 99.24%

Items per share

        
Cash flow per share 1 10.09 11.81 11.72 15.87 18.24 22.82 28.77 36.38
Change - 17.07% -0.74% 35.41% 14.92% 25.11% 26.08% 26.46%
Dividend per Share 1 2.24 2.48 2.72 3 3.32 3.572 4.006 4.255
Change - 10.71% 9.68% 10.29% 10.67% 7.59% 12.15% 6.21%
Book Value Per Share 1 18.88 22.31 27.75 36.11 46.2 59.32 76.72 96.59
Change - 18.16% 24.36% 30.15% 27.94% 28.4% 29.33% 25.9%
EPS 1 8.05 9.65 9.68 11.8 13.64 15.68 18.6 21.93
Change - 19.88% 0.31% 21.9% 15.59% 14.93% 18.65% 17.93%
Nbr of stocks (in thousands) 7,531,575 7,479,033 7,435,488 7,432,306 7,432,544 7,432,378 7,432,378 7,432,378
Announcement Date 27/07/21 26/07/22 25/07/23 30/07/24 30/07/25 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 32.4x 27.3x
PBR 8.55x 6.61x
EV / Sales 11.3x 9.8x
Yield 0.7% 0.79%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
58
Last Close Price
507.49USD
Average target price
625.96USD
Spread / Average Target
+23.34%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. MSFT Stock
  4. Financials Microsoft Corporation
BLACK FRIDAY 40% Discount: The Best Tools Reserved for Subscribers to Identify Your Next Winning Investment!
d
:
:
BENEFIT NOW