Switch to:
Microsoft Corp  (NAS:MSFT) Net-Net Working Capital: \$-1.10 Mil (As of Sep. 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 Sep. 2017 was \$-1.10.

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

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

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 Sep. 2017 is calculated as

 Net-Net Working Capital Per Share (Q: Sep. 2017 ) = (Cash And Cash Equivalents + 0.75 * Accounts Receivable + 0.5 * Total Inventories - Total Liabilities - Preferred Stock / Shares Outstanding (Diluted Average) = (138471 + 0.75 * 14561 + 0.5 * 3211 - 159450 - 0) / 7715.43 = -1.10

* 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 the Internet

###### Wall Street Breakfast Tencent Tops Facebook Valuation

- Seekingalpha 2017-11-21 07:00:23

###### Tencent's \$292 Billion Rally Ousts Facebook From Global Top Five

- Bloomberg 2017-11-21 03:31:23

###### Apple Needs to Reach This Share Price to be Worth \$1 Trillion

- theStreet 2017-11-20 20:28:00

###### Lower S And P 500 P E Ratio

- Seekingalpha 2017-11-20 15:40:03

###### 10 best Black Friday tech deals from Amazon, Best Buy, Walmart and more

- theStreet 2017-11-20 15:38:00

###### Apple and big tech will drive total 2017 corporate cash stockpile up to \$1.9 trillion

- MarketWatch 2017-11-20 14:56:00

###### This is the most hated, and the most loved, stock among hedge funds

- MarketWatch 2017-11-20 14:07:00

###### Salesforce earnings: Analyst surveys pointing to a strong quarter

- MarketWatch 2017-11-20 13:53:00

###### Six promising stocks to buy when the biotech correction ends

- MarketWatch 2017-11-20 12:39:00

###### 10 Stocks Hedge Fund Billionaires Are Buying

- Fool 2017-11-20 11:49:00

###### 27 Stock Portfolio

- Seekingalpha 2017-11-20 11:42:14

###### Amazon launches a cloud service for US intelligence agencies

- cnbc 2017-11-20 11:34:56

###### Hong Kong's Tencent beats China's Alibaba to the \$500 billion market cap club

- MarketWatch 2017-11-20 10:54:00

###### Tracking Jeffrey Ubbens Valueact Portfolio Q3 2017 Update

- Seekingalpha 2017-11-20 04:47:24

###### Consumers Love the 'Death Star' That Is Amazon -- Jim Cramer's Top Thoughts

- theStreet 2017-11-20 01:00:00

###### The most sought-after job in America pays \$110,000 a year — if you have this skill

- MarketWatch 2017-11-19 11:00: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)