investorscraft@gmail.com

Intrinsic value of Microsoft Corporation (MSFT)

Previous Close$252.56
Intrinsic Value
Upside potential
Previous Close
$252.56

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Cash & ST Investments
Total debt
Market cap, m$
1,898,999

Based on fiscal year data as of 2021-06-30 and quarterly data as of 2022-03-31.

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %17.5NaN
Revenue, $168088NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m98172NaN
Operating income, $m69916NaN
EBITDA, $m80816NaN
Interest expense (income), $mNaN
Earnings before tax, $m71102NaN
Tax expense, $m9831NaN
Net income, $m61271NaN

BALANCE SHEET

Cash and short-term investments, $m130334NaN
Total assets, $m333779NaN
Adjusted assets (=assets-cash), $m203445NaN
Average production assets, $m115804NaN
Working capital, $m95749NaN
Total debt, $m82278NaN
Total liabilities, $m191791NaN
Total equity, $m141988NaN
Debt-to-equity ratio0.579NaN
Adjusted equity ratio0.110NaN

CASH FLOW

Net income, $m61271NaN
Depreciation, amort., depletion, $m10900NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m76740NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-20622NaN
Free cash flow, $m97362NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m95749
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenu