Switch to:
Microsoft Corp  (NAS:MSFT) Asset Turnover: 0.10 (As of Sep. 2017)

Asset Turnover measures how quickly a company turns over its asset through sales. It is calculated as Revenue divided by Total Assets. Microsoft Corp's Revenue for the three months ended in Sep. 2017 was \$24,538 Mil. Microsoft Corp's Total Assets for the quarter that ended in Sep. 2017 was \$245,092 Mil. Therefore, Microsoft Corp's asset turnover for the quarter that ended in Sep. 2017 was 0.10.

Asset Turnover is linked to ROE % through Du Pont Formula. Microsoft Corp's annualized ROE % for the quarter that ended in Sep. 2017 was 32.47%. It is also linked to ROA % through Du Pont Formula. Microsoft Corp's annualized ROA % for the quarter that ended in Sep. 2017 was 10.73%.

Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Microsoft Corp Annual Data

 Jun08 Jun09 Jun10 Jun11 Jun12 Jun13 Jun14 Jun15 Jun16 Jun17 Asset Turnover 0.59 0.55 0.54 0.46 0.41

Microsoft Corp Quarterly Data

 Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Asset Turnover 0.11 0.11 0.10 0.10 0.10

Calculation

Asset Turnover measures how quickly a company turns over its asset through sales.

Microsoft Corp's Asset Turnover for the fiscal year that ended in Jun. 2017 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (A: Jun. 2017 ) / ( (Total Assets (A: Jun. 2016 ) + Total Assets (A: Jun. 2017 )) / 2 ) = 89950 / ( (193468 + 241086) / 2 ) = 89950 / 217277 = 0.41

Microsoft Corp's Asset Turnover for the quarter that ended in Sep. 2017 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (Q: Sep. 2017 ) / ( (Total Assets (Q: Jun. 2017 ) + Total Assets (Q: Sep. 2017 )) / 2 ) = 24538 / ( (241086 + 249097) / 2 ) = 24538 / 245091.5 = 0.10

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Companies with low profit margins tend to have high asset turnover, while those with high profit margins have low asset turnover. Companies in the retail industry tend to have a very high turnover ratio.

Explanation

Asset Turnover is linked to Return on Equity (ROE) through Du Pont Formula.

Microsoft Corp's annulized ROE % for the quarter that ended in Sep. 2017 is

 ROE % (Q: Sep. 2017 ) = Net Income / Total Equity = 26304 / 81020.5 = (Net Income / Revenue) * (Revenue / Total Assets) * (Total Assets / Total Equity) = (26304 / 98152) * (98152 / 245091.5) * (245091.5/ 81020.5) = Net Margin % * Asset Turnover * Leverage Ratio = 26.8 % * 0.4005 * 3.0251 = ROA % * Leverage Ratio = 10.73 % * 3.0251 = 32.47 %

Note: The Net Income data used here is four times the quarterly (Sep. 2017) net income data. The Revenue data used here is four times the quarterly (Sep. 2017) revenue data.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

It is also linked to Return on Assets (ROA) through Du Pont Formula:

Microsoft Corp's annulized ROA % for the quarter that ended in Sep. 2017 is

 ROA % (Q: Sep. 2017 ) = Net Income / Total Assets = 26304 / 245091.5 = (Net Income / Revenue) * (Revenue / Total Assets) = (26304 / 98152) * (98152 / 245091.5) = Net Margin % * Asset Turnover = 26.8 % * 0.4005 = 10.73 %

Note: The Net Income data used here is four times the quarterly (Sep. 2017) net income data. The Revenue data used here is four times the quarterly (Sep. 2017) revenue data.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Be Aware

In the article Joining The Dark Side: Pirates, Spies and Short Sellers, James Montier reported that In their US sample covering the period 1968-2003, Cooper et al find that firms with low asset growth outperformed firms with high asset growth by an astounding 20% p.a. equally weighted. Even when controlling for market, size and style, low asset growth firms outperformed high asset growth firms by 13% p.a. Therefore a company with fast asset growth may underperform.

Therefore, it is a good sign if a company's asset turnover is consistent or even increases. If a company's asset grows faster than sales, its asset turnover will decline, which can be a warning sign.

Related Terms

From the Internet

###### Google is planning to expand undersea cables to speed up cloud computing

- MarketWatch 2018-01-16 09:52:00

###### \$SPY \$QQQ \$ADDYY \$BA \$BABA \$BB \$C \$CHL \$CIOIY \$EADSY \$ERIC \$F \$FCAU \$GM \$HAS \$MAT \$MSFT \$SFTBY \$T \$TCEHY \$TTM \$XI Wall Street Breakfast Records Store Equities

- Seekingalpha 2018-01-16 07:11:15

###### \$BDX \$CNI \$CSX \$CVS \$HDB \$LMT \$LOW \$MMM \$MSFT \$NKE \$QCOM \$RTN \$SYK \$TJX \$UNP \$V \$VIG \$WBA Sales Growth Dividend Growth Danger

- Seekingalpha 2018-01-15 23:44:05

###### AMD vs. Intel: Who Will Win the CPU War in 2018?

- Fool 2018-01-15 16:31:00

###### \$CASH \$MSFT Time Take Profits Microsoft

- Seekingalpha 2018-01-15 15:26:16

###### Steve Jobs changed the future of laptops 10 years ago today

- cnbc 2018-01-15 12:56:06

###### 2 Great Stocks You Can Buy and Hold Forever

- Fool 2018-01-15 12:33:00

###### 2 No-Brainer Stocks to Buy in Tech

- Fool 2018-01-15 11:46:00

###### Amazon Won't Be Only Retailer Alive in 5 Years

- theStreet 2018-01-15 08:20:00

###### The Zacks Analyst Blog Highlights: Gartner, Alphabet, Microsoft and Apple

- Zacks 2018-01-15 07:19:00

###### The 2 Ways Apple Will Probably Spend Its Cash Hoard in 2018

- Fool 2018-01-14 13:33:00

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to \$400 per referral. ( Learn More)