Institutional Sign In

Go

Microsoft Corporation

Microsoft's Cash & Cash Equivalents fell 4.94% yoy to USD 11,356 mil in 2019

By Helgi Library - April 2, 2020

Microsoft Corporation's total assets reached USD 286,556 mil at the end of 2019, up 10.7% compared to the previous year. ...

Microsoft's Cash & Cash Equivalents remain unchanged yoy at USD mil in 2Q2019

By Helgi Library - October 12, 2020

Microsoft Corporation's total assets reached USD 286,556 mil at the end of 2Q2019, up 10.7% compared to the previous year. ...

Profit Statement 2017 2018 2019
Sales USD mil 96,571 110,360 125,843
Gross Profit USD mil 62,310 72,007 82,933
EBITDA USD mil 37,803 45,319 54,641
EBIT USD mil 29,025 35,058 42,959
Financing Cost USD mil -876 -1,416 -729
Pre-Tax Profit USD mil 29,901 36,474 43,688
Net Profit USD mil 25,489 16,571 39,240
Dividends USD mil 12,699 13,811 ...
Balance Sheet 2017 2018 2019
Total Assets USD mil 241,086 258,848 286,556
Non-Current Assets USD mil 81,235 89,186 111,004
Current Assets USD mil 159,851 169,662 175,552
Working Capital USD mil 14,583 20,526 22,205
Shareholders' Equity USD mil 72,394 82,718 102,330
Liabilities USD mil 168,692 176,130 184,226
Total Debt USD mil 86,194 76,240 72,178
Net Debt USD mil 78,531 64,294 60,822
Ratios 2017 2018 2019
ROE % 35.3 21.4 42.4
ROCE % 31.2 16.1 32.3
Gross Margin % 64.5 65.2 65.9
EBITDA Margin % 39.1 41.1 43.4
EBIT Margin % 30.1 31.8 34.1
Net Margin % 26.4 15.0 31.2
Net Debt/EBITDA 2.08 1.42 1.11
Net Debt/Equity % 1.08 0.777 0.594
Cost of Financing % -1.25 -1.74 -0.982
Valuation 2017 2018 2019
Market Capitalisation USD mil 539,390 741,209 1,054,410
Enterprise Value (EV) USD mil 617,921 805,503 1,115,230
Number Of Shares mil 7,832 7,794 7,753
Share Price USD 68.9 95.1 136
EV/EBITDA 16.3 17.8 20.4
EV/Sales 6.40 7.30 8.86
Price/Earnings (P/E) 21.2 44.7 26.9
Price/Book Value (P/BV) 7.45 8.96 10.3
Dividend Yield % 2.27 1.77 1.35

Get all company financials in excel:

Download Sample   $19.99

summary Unit 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
income statement                                            
Sales USD mil ... ... ...                         77,849 86,833 93,580 91,154 96,571    
Gross Profit USD mil ... ... ... ... ...                     57,464 59,755 60,542 58,374 62,310    
EBIT USD mil ... ... ...                         26,764 27,759 18,161 20,182 29,025    
Net Profit USD mil ... ... ...                         21,863 22,074 12,193 16,798 25,489    
ROE % ... ... ...                         30.1 26.2 14.4 22.1 35.3    
EBIT Margin % ... ... ...                         34.4 32.0 19.4 22.1 30.1    
Net Margin % ... ... ...                         28.1 25.4 13.0 18.4 26.4    
balance sheet                                            
Total Assets USD mil ... ... ... ... ... ...                   142,431 172,384 176,223 193,468 241,086    
Non-Current Assets USD mil ... ... ... ... ... ...                   40,965 58,138 51,511 53,808 81,235    
Current Assets USD mil ... ... ... ... ... ...                   101,466 114,246 124,712 139,660 159,851    
Shareholders' Equity USD mil ... ... ...                         78,944 89,784 80,083 71,997 72,394    
Liabilities USD mil ... ... ... ... ... ...                   63,487 82,600 96,140 121,471 168,692    
Non-Current Liabilities USD mil ... ... ... ... ... ...                   26,070 36,975 46,282 62,114 104,165    
Current Liabilities USD mil ... ... ... ... ... ...                   37,417 45,625 49,858 59,357 64,527    
Net Debt/EBITDA ... ... ... ... ... ...                   0.387 0.424 1.23 1.75 2.08    
Net Debt/Equity % ... ... ... ... ... ...                   0.149 0.156 0.371 0.652 1.08    
Cost of Financing % ... ... ... ... ... ... ... ...               -2.09 -0.319 -1.19 0.971 -1.25    
cash flow                                            
Total Cash From Operations USD mil ... ... ... ... ...                     28,833 32,502 29,668 33,325 39,507    
Total Cash From Investing USD mil ... ... ... ... ...                     -23,811 -18,833 -23,001 -23,950 -46,781    
Total Cash From Financing USD mil ... ... ... ... ...                     -8,148 -8,665 -9,668 -8,393 8,408    
Net Change In Cash USD mil ... ... ... ... ...                     -3,126 5,004 -3,001 982 1,134    
valuation                                            
Market Capitalisation USD mil ... ... ... ... ...                     270,616 339,320 370,027 359,223 539,390    
Number Of Shares mil ... ... ... ... ...                     8,470 8,399 8,254 8,013 7,832    
Share Price USD ... ... ... ... ...                     32.0 40.4 44.8 44.8 68.9    
Earnings Per Share (EPS) USD ... ... ... ... ...                     2.58 2.63 1.48 2.10 3.25    
Book Value Per Share USD ... ... ... ... ...                     9.32 10.7 9.70 8.99 9.24    
Dividend Per Share USD ... ... ... ... ...                     1.05 1.18 1.24 1.44 1.56    
Price/Earnings (P/E) ... ... ... ... ...                     12.4 15.4 30.3 21.4 21.2    
Price/Book Value (P/BV) ... ... ... ... ...                     3.43 3.78 4.62 4.99 7.45    
Dividend Yield % ... ... ... ... ...                     3.28 2.91 2.77 3.21 2.27    
Earnings Per Share Growth % ... ... ... ... ... ...                   29.3 1.82 -43.8 41.9 55.2    
Book Value Per Share Growth % ... ... ... ... ... ...                   19.5 14.7 -9.24 -7.39 2.88    
income statement Unit 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
income statement                                            
Sales USD mil ... ... ...                         77,849 86,833 93,580 91,154 96,571    
Cost of Goods & Services USD mil ... ... ... ... ...                     20,249 27,078 33,038 32,780 34,261    
Gross Profit USD mil ... ... ... ... ...                     57,464 59,755 60,542 58,374 62,310    
Staff Cost USD mil   ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Other Cost USD mil ... ... ... ... ...                     26,945 26,784 36,424 31,570 24,507    
EBITDA USD mil ... ... ... ... ...                     30,519 32,971 24,118 26,804 37,803    
Depreciation USD mil ... ... ... ... ...                     3,755 5,212 5,957 6,622 8,778    
EBIT USD mil ... ... ...                         26,764 27,759 18,161 20,182 29,025    
Financing Cost USD mil ... ... ... ... ...                     -288 -61.0 -346 431 -876    
Extraordinary Cost USD mil ... ... ... ... ...                     0 0 0 0 0    
Pre-Tax Profit USD mil ... ... ... ... ...                     27,052 27,820 18,507 19,751 29,901    
Tax USD mil ... ... ... ... ...                     5,189 5,746 6,314 2,953 4,412    
Net Profit USD mil ... ... ...                         21,863 22,074 12,193 16,798 25,489    
Dividends USD mil ... ... ... ...                       8,879 9,882 11,006 11,845 12,699   ...
growth rates                                            
Total Revenue Growth % ... ... ... ...                       5.60 11.5 7.77 -2.59 5.94    
Operating Cost Growth % ... ... ... ... ... ...                   -14.4 -0.598 36.0 -13.3 -22.4    
EBITDA Growth % ... ... ... ... ... ...                   23.4 8.03 -26.9 11.1 41.0    
EBIT Growth % ... ... ... ...                       23.0 3.72 -34.6 11.1 43.8    
Pre-Tax Profit Growth % ... ... ... ... ... ...                   21.5 2.84 -33.5 6.72 51.4    
Net Profit Growth % ... ... ... ...                       28.8 0.965 -44.8 37.8 51.7    
ratios                                            
ROE % ... ... ...                         30.1 26.2 14.4 22.1 35.3    
ROCE % ... ... ... ... ... ... ...                 41.8 34.4 17.6 25.2 31.2    
Gross Margin % ... ... ... ... ...                     73.8 68.8 64.7 64.0 64.5    
EBITDA Margin % ... ... ... ... ...                     39.2 38.0 25.8 29.4 39.1    
EBIT Margin % ... ... ...                         34.4 32.0 19.4 22.1 30.1    
Net Margin % ... ... ...                         28.1 25.4 13.0 18.4 26.4    
Payout Ratio % ... ... ... ...                       40.6 44.8 90.3 70.5 49.8   ...
Cost of Financing % ... ... ... ... ... ... ... ...               -2.09 -0.319 -1.19 0.971 -1.25    
Net Debt/EBITDA ... ... ... ... ... ...                   0.387 0.424 1.23 1.75 2.08    
balance sheet Unit 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
balance sheet                                            
Non-Current Assets USD mil ... ... ... ... ... ...                   40,965 58,138 51,511 53,808 81,235    
Property, Plant & Equipment USD mil ... ... ... ... ... ...                   9,991 13,011 14,731 18,356 23,734    
Intangible Assets USD mil ... ... ... ... ... ...                   3,083 6,981 4,835 3,733 10,106    
Goodwill USD mil ... ... ... ... ... ...                   14,655 20,127 16,939 17,872 35,122    
Current Assets USD mil ... ... ... ... ... ...                   101,466 114,246 124,712 139,660 159,851    
Inventories USD mil ... ... ... ... ... ...                   1,938 2,660 2,902 2,251 2,181    
Receivables USD mil ... ... ... ... ... ...                   17,486 19,544 17,908 18,277 19,792    
Cash & Cash Equivalents USD mil ... ... ... ... ... ...                   3,804 8,669 5,595 6,510 7,663    
Total Assets USD mil ... ... ... ... ... ...                   142,431 172,384 176,223 193,468 241,086    
Shareholders' Equity USD mil ... ... ...                         78,944 89,784 80,083 71,997 72,394    
Liabilities USD mil ... ... ... ... ... ...                   63,487 82,600 96,140 121,471 168,692    
Non-Current Liabilities USD mil ... ... ... ... ... ...                   26,070 36,975 46,282 62,114 104,165    
Long-Term Debt USD mil ... ... ... ... ... ...                   12,601 20,645 27,808 40,557 76,073    
Deferred Tax Liabilities USD mil ... ... ... ... ... ... ... ... ... ...           1,709 2,728 2,835 1,476 531    
Current Liabilities USD mil ... ... ... ... ... ...                   37,417 45,625 49,858 59,357 64,527    
Short-Term Debt USD mil ... ... ... ... ... ...                   2,999 2,000 7,484 12,904 10,121    
Trade Payables USD mil ... ... ... ... ... ...                   4,828 7,432 6,591 6,898 7,390    
Equity And Liabilities USD mil ... ... ... ... ... ...                   142,431 172,384 176,223 193,468 241,086    
growth rates                                            
Total Asset Growth % ... ... ... ... ... ... ...                 17.4 21.0 2.23 9.79 24.6    
Shareholders' Equity Growth % ... ... ... ...                       19.0 13.7 -10.8 -10.1 0.551    
Net Debt Growth % ... ... ... ... ... ... ...                 136 18.5 112 58.1 67.3    
Total Debt Growth % ... ... ... ... ... ... ... ... ...     ...       30.6 45.2 55.8 51.5 61.2    
ratios                                            
Total Debt USD mil ... ... ... ... ... ...                   15,600 22,645 35,292 53,461 86,194    
Net Debt USD mil ... ... ... ... ... ...                   11,796 13,976 29,697 46,951 78,531    
Working Capital USD mil ... ... ... ... ... ...                   14,596 14,772 14,219 13,630 14,583    
Capital Employed USD mil ... ... ... ... ... ...                   55,561 72,910 65,730 67,438 95,818    
Net Debt/Equity % ... ... ... ... ... ...                   0.149 0.156 0.371 0.652 1.08    
Cost of Financing % ... ... ... ... ... ... ... ...               -2.09 -0.319 -1.19 0.971 -1.25    
cash flow Unit 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
cash flow                                            
Net Profit USD mil ... ... ...                         21,863 22,074 12,193 16,798 25,489    
Depreciation USD mil ... ... ... ... ...                     3,755 5,212 5,957 6,622 8,778    
Non-Cash Items USD mil ... ... ... ... ... ... ...                 5,069 5,392 10,965 9,316 6,193    
Change in Working Capital USD mil ... ... ... ... ... ... ...                 -1,854 -176 553 589 -953    
Total Cash From Operations USD mil ... ... ... ... ...                     28,833 32,502 29,668 33,325 39,507    
Capital Expenditures USD mil ... ... ... ... ...                     -23,811 -18,833 -23,001 -23,950 -46,781    
Other Investments USD mil ... ... ... ... ...                     0 0 0 0 0    
Total Cash From Investing USD mil ... ... ... ... ...                     -23,811 -18,833 -23,001 -23,950 -46,781    
Dividends Paid USD mil ... ... ... ... ...                     -7,455 -8,879 -9,882 -11,006 -11,845    
Issuance Of Shares USD mil ... ... ... ... ...                     -4,429 -6,709 -13,809 -15,301 -11,016    
Issuance Of Debt USD mil ... ... ... ... ...                     3,736 6,923 14,023 17,914 31,269    
Total Cash From Financing USD mil ... ... ... ... ...                     -8,148 -8,665 -9,668 -8,393 8,408    
Net Change In Cash USD mil ... ... ... ... ...                     -3,126 5,004 -3,001 982 1,134    
ratios                                            
Days Sales Outstanding days ... ... ... ... ... ...                   82.0 82.2 69.8 73.2 74.8    
Days Sales Of Inventory days ... ... ... ... ... ...                   34.9 35.9 32.1 25.1 23.2    
Days Payable Outstanding days ... ... ... ... ... ...                   87.0 100 72.8 76.8 78.7    
Cash Conversion Cycle days ... ... ... ... ... ...                   29.9 17.8 29.1 21.4 19.3    
Cash Earnings USD mil ... ... ... ... ...                     25,618 27,286 18,150 23,420 34,267    
Cash Earnings Per Share USD ... ... ... ... ...                     3.02 3.25 2.20 2.92 4.38    
Price/Cash Earnings (P/CE) ... ... ... ... ...                     10.6 12.4 20.4 15.3 15.7    
Free Cash Flow USD mil ... ... ... ... ...                     5,022 13,669 6,667 9,375 -7,274    
Free Cash Flow Yield % ... ... ... ... ...                     1.86 4.03 1.80 2.61 -1.35    
other data Unit 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
other data                                            
ROA % ... ... ... ... ... ...                   16.6 14.0 7.00 9.09 11.7    
Gross Margin % ... ... ... ... ...                     73.8 68.8 64.7 64.0 64.5    
Effective Tax Rate % ... ... ... ... ...                     19.2 20.7 34.1 15.0 14.8    
Enterprise Value (EV) USD mil ... ... ... ... ... ...                   282,412 353,296 399,724 406,174 617,921    
EV/EBITDA ... ... ... ... ... ...                   9.25 10.7 16.6 15.2 16.3    
EV/Capital Employed ... ... ... ... ... ...                   5.08 4.85 6.08 6.02 6.45    
EV/Sales ... ... ... ... ... ...                   3.63 4.07 4.27 4.46 6.40    
EV/EBIT ... ... ... ... ... ...                   10.6 12.7 22.0 20.1 21.3    
Revenues From Abroad USD mil ... ... ... ... ... ... ... ... ... ... ... ... ...     36,505 ... ... ... ... ... ...
Revenues From Abroad (As % Of Total) % ... ... ... ... ... ... ... ... ... ... ... ... ...     46.9 ... ... ... ... ... ...
Revenues from Productivity and Business Processes USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 26,976 26,430 26,487 29,870    
Revenues from Intelligent Cloud USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 21,735 23,715 25,042 27,407    
Revenues from More Personal Computing USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 38,460 43,160 40,460 39,294    
Profit on Productivity and Business Processes USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 14,173 13,359 12,461 11,389    
Profit on Intelligent Cloud USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 8,446 9,871 9,358 9,127    
Profit on More Personal Computing USD mil ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 5,605 4,667 6,142 8,815    
EBIT Margin on Productivity and Business Processes % ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 52.5 50.5 47.0 38.1    
EBIT Margin on Intelligent Cloud % ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 38.9 41.6 37.4 33.3    
EBIT Margin on More Personal Computing % ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 14.6 10.8 15.2 22.4    

Get all company financials in excel:

Download Sample   $19.99

Microsoft Corporation Logo

Finance

Microsoft Corporation has been growing its sales by a year on average in the last 5 years. EBITDA has grown on average by 10.6% a year during that time to total of USD 54,641 mil in 2019, or 43.4% of sales. That’s compared to 35.8% average margin seen in last five years.

The company netted USD 39,240 mil in 2019 implying ROE of 42.4% and ROCE of 32.3%. Again, the average figures were 27.1% and 24.5%, respectively when looking at the previous 5 years.

Microsoft Corporation’s net debt amounted to USD 60,822 mil at the end of 2019, or 0.594% of equity. When compared to EBITDA, net debt was 1.11x, down when compared to average of 1.52x seen in the last 5 years.

Valuation

Microsoft Corporation stock traded at USD 136 per share at the end of 2019 resulting in a market capitalization of USD 1,054,410 mil. Over the previous five years, stock price grew by 237% or 27.5% a year on average. The closing price put stock at a 12-month trailing EV/EBITDA of 20.4x and price to earnings (PE) of 26.9x as of 2019.