Loading...

Microsoft

Nasdaq:MSFT
Snowflake Description

Adequate balance sheet average dividend payer.

The Snowflake is generated from 30 checks in 5 different areas, read more below.
MSFT
Nasdaq
$653B
Market Cap
  1. Home
  2. US
  3. Software
2017/12/16
Company description

Microsoft Corporation 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 analysis.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 Avocados) 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?
  • Microsoft is good value based on earnings compared to the US Software industry average.
  • Microsoft is overvalued based on earnings compared to the US market.
Price based on expected Growth
Does Microsoft's expected growth come at a high price?
  • Microsoft is poor value based on expected growth next year.
Price based on value of assets
What value do investors place on Microsoft's assets?
  • Microsoft is overvalued based on assets compared to the US 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 (22.38%).

    Full details on the Value part of the Simply Wall St company analysis model.
X
Discounted cash flow (2 Stage 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:
$132,292

Terminal Value

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

Terminal Value = $40,836 × (1 + 2.47%) ÷ (9.69% – 2.47%)

Terminal value based on the Perpetuity Method where growth (g) = 2.47%:
$579,713

Present value of terminal value:
$365,103

Equity Value

Equity Value (Total value) = Present value of next 5 years cash flows + terminal value
$497,395 = $132,292 + $365,103

Value = Total value / Shares Outstanding ($497,395 / 7,715)

Discount to Share Price

Value per share:
$64.47

Current discount (share price of $86.85): -34.7%



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 = 9.69% = 2.47% + (0.959 * 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). Note the market value of equity is used not the book value ($653,348,643,614).

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

0.959 = 0.881 (1 + (1- 35%) (13.62%))

Levered Beta used in calculation = 0.959



Assumptions
  1. The risk free rate of 2.47% is from the 10 year government bond rate in USD.
  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 (7.53%) (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 29 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!
Annual Growth Rate
10.5%
Expected annual growth in earnings.
Earnings growth vs Low Risk Savings
Is Microsoft expected to grow at an attractive rate?
  • Microsoft's earnings growth is expected to exceed the low risk savings rate of 4.5%.
Growth vs Market Checks
  • Microsoft's earnings growth is positive but not above the US market average.
  • Microsoft's revenue growth is expected to exceed the US market average.
Annual Growth Rates Comparison
Analysts growth expectations
Super high growth metrics
High Growth Checks
  • Microsoft's earnings are expected to grow by 10.5% yearly, however this is not considered high growth (20% yearly).
  • Microsoft's revenue is expected to grow by 7.6% yearly, however this is not considered high growth (20% yearly).
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 occurred. We also show the highest and lowest estimates looking forward to see if there is a wide range.
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
  • Performance (ROE) is expected to be above the current US 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 annual earnings growth rate expected to beat the low risk savings rate, plus a premium to keep pace with inflation?
  2. Is the annual earnings growth rate expected to beat the average growth rate in earnings of the US market? (1 check)
  3. Is the annual revenue growth rate expected to beat the average growth rate in revenue of the US market? (1 check)
  4. Is the annual earnings growth rate expected to be above 20%? (1 check)
  5. Is the annual revenue growth rate expected to be above 20%? (1 check)
  6. 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 3/6, see the detailed checks below.

Note 1: We use GAAP Net Income Excluding Exceptional Items for our Earnings 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 year on year growth rate is negative over the past 5 years, however the most recent earnings are above average.
  • Microsoft's 1 year earnings growth exceeds its 5 year annual average (25.9% vs -3.8%)
  • Microsoft's earnings growth has exceeded the US Software industry average in the past year (25.9% vs 17.2%).
Earnings and Revenue 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 > 20%) last year.
  • Microsoft performed worse than the US Software industry average based on Return on Assets (ROA) last year.
  • Performance based on Return on Capital Employed (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 increased in past 5 years? (1 check)
  2. Has the earnings growth in the last year exceeded that of the Software industry? (1 check)
  3. Is the recent earnings growth over the last year 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 Net Income excluding extraordinary items 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 total short term assets, assets are 1.8x debt.
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.
  • Microsoft's level of debt (99.2% of total debt) compared to net worth is high (greater than 40%).
  • The level of debt compared to net worth has increased over the past 5 years (18% vs 99.2% today).
  • Total debt is well covered by annual operating cash flow (45.4%, greater than 20% of total debt).
  • Interest on debt is well covered by earnings (EBIT is 26.5x 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 company 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
1.93%
Current annual income from Microsoft dividends. Estimated to be 2.06% next year.
If you bought $2,000 of Microsoft shares you are expected to receive $39 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 below low risk savings rate (2.25%).
  • Paying below markets top dividend payers (3.18%).
Upcoming dividend payment

Purchase Microsoft on or before the 'Buy Limit' to receive their next dividend payment.

Dividends are usually paid every 3 or 6 months, you can time your share purchase to take advantage of upcoming dividend payments.
Dividend payment calendar
Annualized Historical and Future Dividends
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.8x coverage).
Future Payout to shareholders
  • Dividends after 3 years are expected to be well covered by net profit (2.5x 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 4/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 $20,014,152
AGE 50
TENURE AS CEO 3.8 years
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. 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 has been a Director of Starbucks Corporation since March 22, 2017. 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
  • Satya's compensation has been consistent with company performance over the past year.
  • Satya's compensation appears reasonable.
Management Team Tenure

Average tenure and age of the Microsoft management team in years:

3.6
Average Tenure
55.4
Average Age
  • The tenure for the Microsoft management team is about average.
Management Team

Satya Nadella

TITLE
CEO & Non-Independent Director
COMPENSATION
$20M
AGE
50
TENURE
3.8 yrs

Brad Smith

TITLE
President
COMPENSATION
$10M
AGE
58
TENURE
2.3 yrs

Bill Gates

TITLE
Co-Founder
AGE
62
TENURE
3.8 yrs

Amy Hood

TITLE
Executive VP & CFO
COMPENSATION
$12M
AGE
45
TENURE
4.6 yrs

Jean-Philippe Courtois

TITLE
Executive VP and President of Microsoft Global Sales
COMPENSATION
$18M
AGE
56
TENURE
1.4 yrs

Peggy Johnson

TITLE
Executive Vice President of Business Development
COMPENSATION
$7M
AGE
55
TENURE
3.3 yrs

Frank Brod

TITLE
Corporate VP of Finance & Administration and Chief Accounting Officer
AGE
62

Kevin Scott

TITLE
Chief Technology Officer
TENURE
0.9 yrs

Vikas Mehta

TITLE
Director of Investor Relations

Frank Shaw

TITLE
Corporate Vice President for Corporate Communications
TENURE
8.3 yrs
Board of Directors Tenure

Average tenure and age of the Microsoft board of directors in years:

8.7
Average Tenure
59.7
Average Age
  • The tenure for the Microsoft board of directors is about average.
Board of Directors

John Thompson

TITLE
Independent Chairman
COMPENSATION
$690K
AGE
68
TENURE
3.8 yrs

Satya Nadella

TITLE
CEO & Non-Independent Director
COMPENSATION
$20M
AGE
50
TENURE
3.8 yrs

Bill Gates

TITLE
Co-Founder
AGE
62
TENURE
36.9 yrs

Chuck Noski

TITLE
Independent Director
COMPENSATION
$370K
AGE
64
TENURE
14.1 yrs

Helmut Panke

TITLE
Independent Director
COMPENSATION
$360K
AGE
71
TENURE
14.1 yrs

John Stanton

TITLE
Independent Director
COMPENSATION
$340K
AGE
62
TENURE
3.4 yrs

Teri List-Stoll

TITLE
Independent Director
COMPENSATION
$355K
AGE
54
TENURE
3.2 yrs

Charlie Scharf

TITLE
Independent Director
COMPENSATION
$325K
AGE
52
TENURE
3.2 yrs

Sandi Peterson

TITLE
Independent Director
COMPENSATION
$340K
AGE
58
TENURE
2 yrs

Padma Warrior

TITLE
Independent Director
COMPENSATION
$325K
AGE
56
TENURE
2 yrs
Recent Insider Trading
  • Microsoft insiders have only sold shares 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 0/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

Company Info

Map
Description

Microsoft Corporation 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, Skype for Business, and related Client Access Licenses (CALs); Office 365 consumer services, such as Skype, Outlook.com, and OneDrive; Dynamics business solutions, such as financial management, enterprise resource planning, 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 Microsoft 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; patent licensing, Windows Internet of Things, 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, distributors, and resellers, as well as through online and Microsoft retail stores. The company was founded in 1975 and is headquartered in Redmond, Washington.

Details
Name: Microsoft Corporation
Ticker: MSFT
Exchange: NasdaqGS
Founded: 1975
Market Cap: $653,348,643,614
Shares outstanding: 7,714,590,195
Website: http://www.microsoft.com
Address: Microsoft Corporation
One Microsoft Way,
Redmond,
Washington, 98052,
United States
Listings
Exchange Symbol Ticker Symbol Security Exchange Country Currency Listed on
NasdaqGS MSFT Common Stock Nasdaq Global Select US USD 13. Mar 1986
DB MSF Common Stock Deutsche Boerse AG DE EUR 13. Mar 1986
XTRA MSF Common Stock XETRA Trading Platform DE EUR 13. Mar 1986
SWX MSFT Common Stock SIX Swiss Exchange CH CHF 13. Mar 1986
SWX MSFT Common Stock SIX Swiss Exchange CH USD 13. Mar 1986
SEHK 4338 Common Stock The Stock Exchange of Hong Kong Ltd. HK HKD 13. Mar 1986
ENXTBR MSF Common Stock Euronext Brussels BE USD 13. Mar 1986
WBAG MSFT Common Stock Wiener Boerse AG AT EUR 13. Mar 1986
SNSE MSFT Common Stock Santiago Stock Exchange CL USD 13. Mar 1986
BVC MSFT Common Stock Bolsa de Valores de Colombia CO COP 13. Mar 1986
BMV MSFT * Common Stock Bolsa Mexicana de Valores MX MXN 13. Mar 1986
BOVESPA MSFT34 BDR EACH REPR 1 COM SHS Bolsa de Valores de Sao Paulo BR BRL 21. Dec 2011
BASE MSFT CEDEARS EACH REP 1/5 ORD USD0.000025 Buenos Aires Stock Exchange AR ARS 22. Dec 1999
Number of employees
Current staff
Staff numbers
124,000
Microsoft employees.
Industry
Industry: Systems Software
Sector: Software