Switch to:
Microsoft Corp  (NAS:MSFT) Net-Net Working Capital: \$-2.57 Mil (As of Jun. 2017)

In calculating the Net-Net Working Capital (NNWC), Benjamin Graham assumed that a company's accounts receivable is only worth 75% its value, its inventory is only worth 50% of its value, but its liabilities have to be paid in full. In addition, Graham believed that preferred stock belongs on the liability side of the balance sheet, not as part of capital and surplus. This is a conservative way of estimating the company's value.

Microsoft Corp's net-net working capital per share for the quarter that ended in Jun. 2017 was \$-2.57.

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 Net-Net Working Capital 3.32 2.32 2.12 0.85 -2.57

Microsoft Corp Quarterly Data

 Sep12 Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Net-Net Working Capital 0.85 0.60 -2.75 -2.41 -2.57

Competitive Comparison
* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap.

Calculation

Microsoft Corp's Net-Net Working Capital (NNWC) per share for the fiscal year that ended in Jun. 2017 is calculated as

 Net-Net Working Capital Per Share (A: Jun. 2017 ) = (Cash And Cash Equivalents + 0.75 * Accounts Receivable + 0.5 * Total Inventories - Total Liabilities - Preferred Stock / Shares Outstanding (Diluted Average) = (132981 + 0.75 * 19792 + 0.5 * 2181 - 168692 - 0) / 7708.00 = -2.57

Microsoft Corp's Net-Net Working Capital (NNWC) per share for the quarter that ended in Jun. 2017 is calculated as

 Net-Net Working Capital Per Share (Q: Jun. 2017 ) = (Cash And Cash Equivalents + 0.75 * Accounts Receivable + 0.5 * Total Inventories - Total Liabilities - Preferred Stock / Shares Outstanding (Diluted Average) = (132981 + 0.75 * 19792 + 0.5 * 2181 - 168692 - 0) / 7708.00 = -2.57

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

In calculating the Net-Net Working Capital (NNWC), Benjamin Graham assumed that a company's accounts receivable is only worth 75% its value, its inventory is only worth 50% of its value, but its liabilities have to be paid in full.

In addition, Graham believed that preferred stock belongs on the liability side of the balance sheet, not as part of capital and surplus. In "Security Analysis", preferred stock is dubbed "an imperfect creditorship position" that is best placed on the balance sheet alongside funded debt.

This is a conservative way of estimating the company's value.

Explanation

One research study, covering the years 1970 through 1983 showed that portfolios picked at the beginning of each year, and held for one year, returned 29.4 percent, on average, over the 13-year period, compared to 11.5 percent for the S&P 500 Index. Other studies of Graham's strategy produced similar results.

Benjamin Graham looked for companies whose market values were less than two-thirds of their net-net value. They are collected under our Net-Net screener. GuruFocus also publishes a monthly Net-Net newsletter.

Related Terms

From GuruFocus

###### Microsoft helps customers digitally transform their businesses with cloud, AI and mixed reality -- while also advancing the next frontier of computing

By PRNewswire about MSFT 2017-09-25 08:30:32

From the Internet

###### Progressive Web Apps Can Boost Microsofts App Store Cloud Computing Services

- Seekingalpha 2017-09-25 20:04:40

###### Office 365 New Microsoft Goose Lays Golden Eggs

- Seekingalpha 2017-09-25 14:56:50

###### Special Dividends Alphabet Edition

- Seekingalpha 2017-09-25 11:26:32

###### Wall Street Breakfast Elections Currencies

- Seekingalpha 2017-09-25 07:00:12

###### Cornerstone Ondemand Big Acquisition

- Seekingalpha 2017-09-25 06:17: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)