Intrinsic value of Microsoft Corporation (MSFT)

Previos Close

$216.23

STOCK VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate, %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Revenue / Adjusted assets

Based on fiscal year data as of 2020-06-30 and quarterly data as of 2020-06-30.

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.

Premium membership allows you to recalculate the intrinsic value for different input parameters.

MEMBERSHIP

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045

INCOME STATEMENT

Revenue growth rate, %NaN
Revenue, $NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $mNaN
Operating income, $mNaN
EBITDA, $mNaN
Interest expense (income), $mNaN
Earnings before tax, $mNaN
Tax expense, $mNaN
Net income, $mNaN

BALANCE SHEET

Cash and short-term investments, $mNaN
Total assets, $mNaN
Adjusted assets (=assets-cash), $mNaN
Average production assets, $mNaN
Working capital, $mNaN
Total debt, $mNaN
Total liabilities, $mNaN
Total equity, $mNaN
Debt-to-equity ratioNaN
Adjusted equity ratioNaN

CASH FLOW

Net income, $mNaN
Depreciation, amort., depletion, $mNaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $mNaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Cash from investing activities, $mNaN
Free cash flow, $mNaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow (-), $mNaN
Cash flow adjustment, $mNaN
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN

Company description

Microsoft Corporation develops, licenses, and supports software, services, devices, and solutions worldwide. Its Productivity and Business Processes segment offers Office, Exchange, SharePoint, Microsoft Teams, Office 365 Security and Compliance, and Skype for Business, as well as related Client Access Licenses (CAL); Skype, Outlook.com, and OneDrive; LinkedIn that includes Talent, Learning, Sales, and Marketing solutions, as well as premium subscriptions; and Dynamics 365, a set of cloud-based and on-premises business solutions for small and medium businesses, large organizations, and divisions of enterprises. Its Intelligent Cloud segment licenses SQL and Windows Servers, Visual Studio, System Center, and related CALs; GitHub that provides a collaboration platform and code hosting service for developers; and Azure, a cloud platform. It also offers support services and Microsoft consulting services to assist customers in developing, deploying, and managing Microsoft server and desktop solutions; and training and certification to developers and IT professionals on various Microsoft products. Its More Personal Computing segment provides Windows original equipment manufacturer (OEM) licensing and other non-volume licensing of the Windows operating system; Windows Commercial, such as volume licensing of the Windows operating system, Windows cloud services, and other Windows commercial offerings; patent licensing; Windows Internet of Things; and MSN advertising. It also offers Surface, PC accessories, PCs, tablets, gaming and entertainment consoles, and other intelligent devices; Gaming, including Xbox hardware, and Xbox content and services; video games and third-party video game royalties; and Search, including Bing and Microsoft advertising. It sells its products through OEMs, distributors, and resellers; and directly through digital marketplaces, online stores, and retail stores. The company was founded in 1975 and is headquartered in Redmond, Washington.