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.

* Premium members only.

Microsoft Corp Annual Data

Jun08 Jun09 Jun10 Jun11 Jun12 Jun13 Jun14 Jun15 Jun16 Jun17
Asset Turnover Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 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 Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 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


Headlines

From the Internet

JP Morgan Launches US Dividend ETF

- Zacks 2017-11-22 15:22:00

A list of richest billionaires in each country

- MarketWatch 2017-11-22 13:57:00

Chromebook Business One Good Reason Like Intel

- Seekingalpha 2017-11-22 13:34:08

Trading Quality Stocks Short Term Rates Higher Update

- Seekingalpha 2017-11-22 07:44:46

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)

GF Chat

{{numOfNotice}}
FEEDBACK