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

###### 8 Hot Products Your Tech-Savvy Friends Will Love

- Fool 2017-11-23 10:00:00

###### Navigating Cloudy Waters Understanding Cloud Computing Majors

- Seekingalpha 2017-11-23 06:24:25

###### The 3 Dividend Stocks You'll Wish You'd Bought 10 Years From Now

- Fool 2017-11-23 06:15:00

###### Zimbabwe and Bitcoin Remain Entwined; Microsoft's Holiday Wish List -- ICYMI

- theStreet 2017-11-22 18:07:00

###### JP Morgan Launches US Dividend ETF

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

###### One stock is conspicuously absent from Goldman Sachs’ top 5 hedge fund favorites

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

###### These 3 Stocks Are Up More Than 30% So Far in 2017, and They Aren't Slowing Down

- Fool 2017-11-22 14:05: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

###### Amazon's cloud is about to announce a huge deal with health technology company Cerner

- cnbc 2017-11-22 13:22:34

###### Microsoft's Black Friday deals include huge savings on Xbox One S, Surface Pro, laptops and more

- cnbc 2017-11-22 12:11:10

###### 5 companies that could be on Microsoft's shopping list

- theStreet 2017-11-22 11:19:00

###### 10 psychological retail tricks that make you overspend on Black Friday

- MarketWatch 2017-11-22 11:12:00

###### Apple (AAPL) Expands in AR, Acquires Headset Maker Vrvana

- Zacks 2017-11-22 09:37:00

###### Salesforce (CRM) Q3 Earnings & Sales Top, Lifts FY18 View

- Zacks 2017-11-22 09:36:00

- Zacks 2017-11-22 09:32:00

###### China's Great Firewall Strengthens as Microsoft's Skype Vanishes From App Stores

- theStreet 2017-11-22 08:57:00

###### Apple (AAPL) Withdraws Skype From China App Store

- Zacks 2017-11-22 08:36:00

###### Trading Quality Stocks Short Term Rates Higher Update

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

###### Wall Street Breakfast Traders Digest Fed Minutes Thanksgiving

- Seekingalpha 2017-11-22 06:25:03

###### Amd Wins Cpu Speed Contest Nvidia Gains Gpu Market Share

- Seekingalpha 2017-11-22 00:57:02

###### Forget Bitcoin: You're Better Off Buying These 3 Stocks

- Fool 2017-11-21 21:11:00

###### HPE shares tank on earnings and Meg Whitman departure news: 7 key takeaways

- theStreet 2017-11-21 18:29:00

###### Quality Dividend ETFs to Tackle Uncertainty

- Zacks 2017-11-21 16:43:00

###### Closing Bell: Stocks Finish Tuesday Strong as Tech, Healthcare Take the Lead

- theStreet 2017-11-21 16:32: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)