Loading...

Microsoft

Nasdaq:MSFT
Snowflake Description

Established dividend payer with reasonable growth potential.

The Snowflake is generated from 30 checks in 5 different areas, read more below.
MSFT
Nasdaq
$499B
Market Cap
Systems Software
Company description

Microsoft Corporation, a technology company, develops, licenses, and supports software products, services, and devices worldwide. More info.


Add to Portfolio Compare Print Invest
SHARE PRICE
3 Month History
MSFT
Industry
5yr Volatility vs Market

Value

 Is Microsoft undervalued based on future cash flows and its price relative to the stock market?

Value is all about what a company is worth versus what price it is available for. If you went into a grocery store and all the bananas were on sale at half price, they could be considered undervalued.
INTRINSIC VALUE BASED ON FUTURE CASH FLOWS
Here we compare the current share price of Microsoft to its discounted cash flow value.

The discounted cash flow value is simply looking at what the company is worth today, based on estimates of how much money it is expected to make in the future.

How is this discounted cash flow calculated?

  • The current share price of Microsoft is above its future cash flow value.
Often investors are willing to pay a premium for a company that has a high dividend or the potential for future growth.
PRICE RELATIVE TO MARKET
We can also value a company based on what the stock market is willing to pay for it. This is similar to the price of fruit (e.g. Mangoes or Avacados) increasing when they are out of season, or how much your home is worth.

The amount the stock market is willing to pay for Microsoft's earnings, growth and assets is considered below, and whether this is a fair price.
Price based on past earnings
Are Microsoft's earnings available for a low price, and how does this compare to other companies in the same industry?
  • Good value based on earnings compared to the Software industry average.
  • Overvalued based on earnings compared to the overall market.
Price based on expected Growth
Does Microsoft's expected growth come at a high price?
  • Poor value based on expected growth next year.
Price based on value of assets
What value do investors place on Microsoft's assets?
  • Overvalued based on assets compared to the Software industry average.
X
Value checks
We assess Microsoft's value by looking at:
  1. Is the discounted cash flow value less than 20%, or 40% of the share price? (2 checks) (Click here or on bar chart for details of DCF calculation.)
  2. Is the PE ratio less than the market average, and/ or less than the Software industry average (and greater than 0)? (2 checks)
  3. Is the PEG ratio within a reasonable range (0 to 1)? (1 check)
  4. Is the PB ratio less than the Software industry average (and greater than 0)? (1 check)
  5. Microsoft has a total score of 1/6, see the detailed checks below.

    Note: We use GAAP Earnings per Share in all our calculations including PE and PEG Ratio.
    Note 2: PEG ratio is based on analysts EPS growth expectations in 1 year (25%).

    Full details on the Value part of the Simply Wall St company analysis model.
X
Discounted cash flow (Free cash flow to Equity)

The calculations below outline how an intrinsic value for Microsoft is arrived at by discounting future cash flows to their present value. We use analyst's estimates of cash flows going forward 5 years.

See our documentation to learn about this calculation.

5 year cash flow forecast

Present value of next 5 years cash flows:
$108,311

Terminal Value

Terminal Value = FCF2021 × (1 + g) ÷ (Discount Rate – g)

Terminal Value = $26,544 × (1 + 2.5%) ÷ (11.22% – 2.5%)

Terminal value based on the Perpetuity Method where growth (g) = 2.5%:
$311,024

Present value of terminal value:
$182,800

Equity Value

Equity Value (Total value) = Present value of next 5 years cash flows + terminal value

Value = Total value / Shares Outstanding ($291,111 / 7,728)

Value per share:
$37.67

Current discount (share price of $64.62): -72%



Estimate of Discount Rate

The discount rate, or required rate of return, is estimated by calculating the Cost of Equity.

Discount rate = Cost of Equity = Risk Free Rate + (Levered Beta * Equity Risk Premium)

Discount rate = 11.22% = 2.47% + (1.161 * 7.53%)



Estimate of Bottom Up Beta

The Levered Beta is the Unlevered Beta adjusted for financial leverage. It is limited to 0.8 to 2.0 (practical range for a stable firm).

Levered Beta = Unlevered beta (1 + (1- tax rate) (Debt/Equity))

1.161 = 1.034 (1 + (1- 30%) (17.58%))

Levered Beta used in calculation = 1.161



Assumptions
  1. The risk free rate of 2.47% is from the 10 year government bond rate in United States.
  2. The bottom-up beta is estimated by analysing other companies in the same industry.
  3. The Equity Risk Premium is calculated by subtracting the risk free rate from the market return premium (10%) (source: Buffet).
  4. The dividend discount model is automatically used for companies in the following industries: Banks, Insurance, Real Estate Investment Trusts (REITs), Diversified Financial Services and Capital Markets.

Future Performance

 How is Microsoft expected to perform in the next 1 to 3 years based on estimates from 25 analysts?

    The future performance of a company is measured in the same way as past performance, by looking at estimated growth and how much profit it is expected to make.

    Future estimates come from professional analysts. Just like forecasting the weather, they don’t always get it right!
    3 year growth
    85%
    Expected earnings growth over 3 years.
    Future Earnings growth analysis
    Is Microsoft expected to grow at an attractive rate? We look at the 1 year and 3 year growth below.

    Are Microsoft's annual earnings growth expected to exceed 3.6% over the next 3 years?

    • After 1 year
    • After 3 years
    1 & 3 year estimated growth in earnings
    Past and Future Earnings per Share
    The accuracy of the analysts who estimate the future performance data can be gauged below. We look back 3 years and see if they were any good at predicting what actually occured. We also show the highest and lowest estimates looking forward to see if there is a wide range.
    Analysts growth expectations
    2 year growth check
    Super high growth metrics x1.5?

    Which of the these is expected to increase by over 50% in 2 year's time?

    • Revenue
    • Cash flow
    • Profit
    Performance in 3 years
    In the same way as past performance we look at the future estimated return (profit) compared to the available funds. We do this looking forward 3 years.
    • Microsoft is expected to perform strongly, Return on Equity (ROE) in 3 years is estimated to be above 20%.

    Improvement & Relative to industry
    • Expected to be above the Software industry average.
    • An improvement in Microsoft's performance (ROE) is expected over the next 3 years.
    X
    Future performance checks
    We assess Microsoft's future performance by looking at:
    1. Is the growth in earnings expected to beat the low risk savings rate, plus a premium to keep pace with inflation, in 1 year and 3 years? (2 checks)
    2. Does the average analyst expect Revenue to increase by 50% or more in 2 years? (1 check)
    3. Does the average analyst expect Operating Cash Flow to increase by 50% or more in 2 years? (1 check)
    4. Does the average analyst expect Net Income (Profit) to increase by 50% or more in 2 years? (1 check)
    5. Is the Return on Equity in 3 years expected to be over 20%? (1 check)
    Some of the above checks will fail if the company is expected to be loss making in the relevant year.
    Microsoft has a total score of 4/6, see the detailed checks below.

    Note: If no +3 year data is available, +2.5 year data may be used.

    Note 2: We use GAAP per Share in all our calculations.

    Full details on the Future part of the Simply Wall St company analysis model.

    Past Performance

     How has Microsoft performed over the past 5 years?

    The past performance of a company can be measured by how much growth it has experienced and how much profit it makes relative to the funds and assets it has available.
    Past earnings growth
    Below we compare Microsoft's growth in the last year to its industry (Software).
    Past Earnings growth analysis
    We also check if the company has grown in the past 5 years, and whether it has maintained that growth in the year.
    • Microsoft's earnings growth has exceeded the industry average over the past year.
    • Microsoft's 1 year earnings growth exceeds its 5 year annual average (47.4% vs -3.6%).
    • Microsoft earnings have fallen over the past 5 years.
    Profit History
    Microsoft's revenue and profit over the past 5 years is shown below, any years where they have experienced a loss will show up in red.
    Performance last year
    We want to ensure a company is making the most of what it has available. This is done by comparing the return (profit) to a company's available funds, assets and capital.
    • Strong return on shareholders funds (ROE) last year.
    • Microsoft performed worse than the Software industry average based on return on assets (ROA) last year.
    • Performance based on revenue producing assets (ROCE) has been diminishing over 3 years.
    X
    Past performance checks
    We assess Microsoft's performance over the past 5 years by checking for:
    1. Has earnings per share (EPS) increased in past 5 years? (1 check)
    2. Has the EPS growth in the last year exceeded that of the Software industry? (1 check)
    3. Is the current EPS growth higher than the average annual growth over the past 5 years? (1 check)
    4. Is the Return on Equity (ROE) higher than 20%? (1 check)
    5. Is the Return on Assets (ROA) above industry average? (1 check)
    6. Has the Return on Capital Employed (ROCE) increased from 3 years ago? (1 check)
    The above checks will fail if the company has reported a loss in the most recent earnings report. Some checks require at least 3 or 5 years worth of data.
    Microsoft has a total score of 3/6, see the detailed checks below.

    Note: We use GAAP Earnings per Share in all our calculations.

    Full details on the Past part of the Simply Wall St company analysis model.

    Health

     How is Microsoft's financial health and their level of debt?

    A company's financial position is much like your own financial position, it includes everything you own (assets) and owe (liabilities).

    The boxes below represent the relative size of what makes up Microsoft's finances.

    The net worth of a company is the difference between its assets and liabilities.
    Net Worth
    • Microsoft is able to meet its short term (1 year) commitments with its holdings of cash and other short term assets.
    • Microsoft's cash and other short term assets cover its long term commitments.
    Balance sheet
    This treemap shows a more detailed breakdown of Microsoft's finances. If any of them are yellow this indicates they may be out of proportion and red means they relate to one of the checks below.
    Assets
    Liabilities and shares
    The 'shares' portion represents any funds contributed by the owners (shareholders) and any profits.
    • Low level of unsold assets
    • Total debt is covered by short term assets.
    Historical Debt
    Nearly all companies have debt. Debt in itself isn’t bad, however if the debt is too high, or the company can’t afford to pay the interest on its debts this may have impacts in the future.

    The graphic below shows equity (available funds) and debt, we ideally want to see the red area (debt) decreasing.

    If there is any debt we look at the companies capability to repay it, and whether the level has increased over the past 5 years.
    • The level of debt (128%) compared to net worth is high (greater 40%).
    • The level of debt compared to net worth has increased over the past 5 years (20% vs 128% today).
    • Total debt is well covered by annual operating cash flow (greater than 20% of total debt).
    • Interest on debt is well covered by earnings (30.3x coverage).
    X
    Financial health checks
    We assess Microsoft's financial health by checking for:
    1. Are short term assets greater than short term liabilities? (1 check)
    2. Are short term assets greater than long term liabilities? (1 check)
    3. Has the debt to equity ratio increased in the past 5 years? (1 check)
    4. Is the debt to equity ratio over 40%? (1 check)
    5. Is the debt covered by short term assets? (1 check)
    6. Are earnings greater than 5x the interest on debt (if comapany pays interest at all)? (1 check)
    7. Microsoft has a total score of 4/6, see the detailed checks below.


    Full details on the Health part of the Simply Wall St company analysis model.

    Dividends

     What is Microsoft's current dividend yield, its reliability and sustainability?

    Dividends are regular cash payments to you from the company, similar to a bank paying you interest on a savings account.
    Annual Dividend Income
    Dividend payments
    2.43%
    Current annual income from Microsoft dividends. Estimated to be 2.59% next year.
    If you bought $2,000 of Microsoft shares you are expected to receive $49 in your first year as a dividend.
    Dividend Amount
    Here we look how much dividend is being paid, if any. Is it above what you can get in a savings account? It is up there with the best dividend paying companies?
    • Paying above low risk savings rate. (1.75%)
    • Paying below the markets top dividend payers. (3.18%)
    Historical dividend yield
    It is important to see if the dividend for a company is stable, and not wildly increasing/decreasing each year. This graph shows you the historical rate to count toward your assessment of the stock.

    We also check to see if the dividend has increased in the past 10 years.
    • Dividends per share have been stable in the past 10 years.
    • Dividends per share have increased over the past 10 years.
    Current Payout to shareholders
    What portion of Microsoft's earnings are paid to the shareholders as a dividend.
    • Dividends paid are covered by net profit (1.4x coverage).
    Future Payout to shareholders
    • Dividends after 3 years are expected to be well covered by net profit (2.1x coverage).
    X
    Income/ dividend checks
    We assess Microsoft's dividend by checking for:
    1. Firstly is the company paying a notable dividend (greater than 0.5%) - if not then the rest of the checks are ignored.
    2. Current dividend yield, is there one at all, is it higher than the low risk savings rate, and is it above the top 25% of dividend payers? (2 checks)
    3. Have they paid a dividend for 10 years, and during this period has the dividend been volatile (drop of more than 25%)? (1 check)
    4. If they have paid a dividend for 10 years has it increased in this time? (1 check)
    5. How sustainable is the dividend, can Microsoft afford to pay it from its earnings today and in 3 years (Payout ratio less than 90%)? (2 checks)
    6. Microsoft has a total score of 5/6, see the detailed checks below.


    Full details on the Dividends part of the Simply Wall St company analysis model.

    Management

     What is the CEO of Microsoft's salary, the management and board of directors tenure and is there insider trading?

    Management is one of the most important areas of a company. We look at unreasonable CEO compensation, how long the team and board of directors have been around for and insider trading.
    CEO
    Satya Nadella, image provided by Google.
    Satya Nadella
    COMPENSATION$17,692,031
    AGE50
    CEO Bio

    Mr. Satya Nadella has been the Chief Executive Officer of Microsoft Corporation since February 4, 2014. Mr. Nadella joined Microsoft in 1992 and served leadership roles in both enterprise and consumer businesses across Microsoft for over 22 years. He served as Executive Vice President of Cloud & and Enterprise Engineering Group at Microsoft Corporation until February 4, 2014 and President of Server & Tools since February 9, 2011 until February 4, 2014. He led the transformation to the cloud infrastructure and services business, which outperformed the market and took share from competition. Mr. Nadella and his team delivered the “Cloud OS”, Microsoft’s next generation backend platform. He served as Senior Vice President of Research & Development for the Online Services Division at Microsoft Corporation until February 9, 2011 and also served as Vice President of Microsoft Business Division. Mr. Nadella led Microsoft's engineering efforts in the Online Services Division, which includes the Search (Live Search), Portal (MSN) and Advertising platforms. He served as the Head of Dynamics Business Software Development at Microsoft Corporation and also served as its Corporate Vice President of Microsoft Business Solutions (MBS) and Search & Advertising Platform Group. Mr. Nadella became part of Business Solutions when the division was formed by combining the bCentral, Great Plains and Navision a/s groups. During his six years in MBS, he was responsible for Microsoft Dynamics ERP and the creation of Microsoft Dynamics CRM and Microsoft Office Small Business product lines. Before that, he served as General Manager for the Commerce Platforms Group and led the development efforts for Microsoft Commerce Server and Microsoft BizTalk Server. He was also a key member of several advanced technology incubation efforts inside Microsoft, including interactive television (ITV) and digital rights management (DRM). His first assignment at Microsoft Corporation was in the Windows Developer Relations group, where he was a Program Manager. Prior to Microsoft, Mr. Nadella served as a Member of the technology staff at Sun Microsystems Inc. He has been a Trustee of Fred Hutchinson Cancer Research Center since July 11, 2016. He has been a Non-Independent Director of Microsoft Corporation since February 4, 2014. He serves as a Director of BravoSolution US, Inc. He serves as a Member of Advisory Board at Nirvaha, Inc. He served as a Director of Riverbed Technology, Inc. from March 1, 2013 to February 2014. He served as a Director of Intelliprep Technologies Inc. Mr. Nadella earned a Bachelor's degree in Electrical Engineering from Mangalore University, a Master's degree in Computer Science from the University of Wisconsin, Milwaukee and a Master’s degree in Business Administration from the University of Chicago.

    CEO Compensation
    • CEO's compensation has been consistent with company performance over the past year.
    • CEO's compensation appears reasonable.
    Management Team Tenure

    Average tenure of the Microsoft management team:

    Management tenure
    6 years
    • The average tenure for the Microsoft management team is over 5 years, this suggests they are a seasoned and experienced team.
    Management Team

    Satya Nadella

    TITLE
    Chief Executive Officer and Non-Independent Director
    COMPENSATION
    $17,692,031
    AGE
    50

    Brad Smith

    TITLE
    President
    COMPENSATION
    $8,610,612
    AGE
    58

    Bill Gates

    TITLE
    Co-Founder
    COMPENSATION
    $0
    AGE
    62

    Amy Hood

    TITLE
    Chief Financial Officer and Executive Vice President
    COMPENSATION
    $10,374,630
    AGE
    45

    Peggy Johnson

    TITLE
    Executive Vice President of Business Development
    COMPENSATION
    $6,716,490
    AGE
    55

    Jean-Philippe Courtois

    TITLE
    President of Global Sales
    AGE
    56
    Board of Directors Tenure

    Average tenure of the Microsoft board of directors:

    Board tenure
    10.1 years
    • The average tenure for the Microsoft board of directors is over 10 years, this suggests they are a seasoned and experienced board.
    Board of Directors

    John Thompson

    TITLE
    Independent Chairman
    COMPENSATION
    $690,000
    AGE
    68

    Satya Nadella

    TITLE
    Chief Executive Officer and Non-Independent Director
    COMPENSATION
    $17,692,031
    AGE
    50

    Bill Gates

    TITLE
    Co-Founder
    COMPENSATION
    $0
    AGE
    62

    Chuck Noski

    TITLE
    Independent Director
    COMPENSATION
    $332,500
    AGE
    64

    Helmut Panke

    TITLE
    Independent Director
    COMPENSATION
    $317,500
    AGE
    71

    John Stanton

    TITLE
    Independent Director
    COMPENSATION
    $317,500
    AGE
    62
    Recent Insider Trading
    • Microsoft insiders have sold more shares than they have bought in the past 3 months.
    Who owns this company?
    X
    Management checks
    We assess Microsoft's management by checking for:
    1. Is the CEO's compensation unreasonable compared to market cap and profit (greater than 0.5% of the company's profit + 0.03% of market cap)? (1 check)
    2. Has the CEO's compensation increased more than 20% whilst the EPS is down more then 20%? (1 check)
    3. Is the average tenure of the management team less than 2 years? (1 check)
    4. Is the average tenure of the board of directors team less than 3 years? (1 check)
    5. Microsoft has a total score of 6/6, this is not included on the snowflake, see the detailed checks below.


    Note: We use the top 6 management executives and board members in our calculations.

    Note 2: Insider trading include any internal stakeholders and these transactions.

    Full details on the Management part of the Simply Wall St company analysis model.

    Company News

    Articles
    Announcements

    Company Info

    Description

    Microsoft Corporation, a technology company, develops, licenses, and supports software products, services, and devices worldwide. The company’s Productivity and Business Processes segment offers Office 365 commercial products and services for businesses, including Office, Exchange, SharePoint, and Skype, as well as related Client Access Licenses (CALs); Office 365 consumer services, such as Skype, Outlook.com, and OneDrive; Dynamics business solutions, such as financial management, customer relationship management, supply chain management, and analytics applications for small and mid-size businesses, large organizations, and divisions of enterprises; and LinkedIn online professional network. Its Intelligent Cloud segment licenses server products and cloud services, such as SQL Server, Windows Server, Visual Studio, System Center, and related CALs, as well as Azure, a cloud platform with computing, networking, storage, database, and management services; and enterprise services, such as Premier Support and Microsoft Consulting that assist in developing, deploying, and managing Microsoft server and desktop solutions, as well as provide training and certification to developers and IT professionals on Microsoft products. The company’s More Personal Computing segment comprises Windows OEM, volume, and other non-volume licensing of the Windows operating system, as well as patent licensing, Windows Embedded, MSN display advertising, and Windows Phone licensing system; devices, including Microsoft Surface, phones, and PC accessories; and search advertising, including Bing and Bing Ads. This segment also provides gaming platforms, including Xbox hardware, Xbox Live, video games, and third-party video games. The company markets and distributes its products through original equipment manufacturers (OEM), distributors, and resellers, as well as through online and Microsoft retail stores. Microsoft Corporation was founded in 1975 and is headquartered in Redmond, Washington.

    Details
    Name:Microsoft Corporation
    Ticker:MSFT
    Exchange:NasdaqGS
    Founded:1975
    Market Cap:$499,353 million
    Website:http://www.microsoft.com
    Listings
    Map

    One Microsoft Way, Redmond, 98052, United States

    Number of employees
    Street

    Current staff
    Staff numbers
    114,000
    Microsoft employees.
    Industry
    Industry:Systems Software
    Sector:Software and Services