Switch to:
GuruFocus has detected 4 Warning Signs with Sherwin-Williams Co \$SHW.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Sherwin-Williams Co (NYSE:SHW)
Accounts Receivable
\$1,357 Mil (As of Mar. 2017)

Accounts Receivable are created when a customer has received a product but has not yet paid for that product. Sherwin-Williams Co's accounts receivables for the quarter that ended in Mar. 2017 was \$1,357 Mil.

Accounts receivable can be measured by Days Sales Outstanding. Sherwin-Williams Co's Days Sales Outstanding for the quarter that ended in Mar. 2017 was 44.84.

In Ben Grahams calculation of liquidation value, accounts receivable are only considered to be worth 75% of book value. Sherwin-Williams Co's Liquidation Value for the quarter that ended in Mar. 2017 was \$-2,264 Mil.

Definition

Accounts Receivable is money owed to a business by customers and shown on its Balance Sheet as an asset.

Explanation

1. Accounts Receivable are created when a customer has received a product but has not yet paid for that product. Days sales outstanding measures of the average number of days that a company takes to collect revenue after a sale has been made. It is a financial ratio that illustrates how well a company's accounts receivables are being managed.

Sherwin-Williams Co's Days Sales Outstanding for the quarter that ended in Mar. 2017 is calculated as:

 Days Sales Outstanding = Account Receivable / Revenue * Days in Period = 1356.851 / 2761.387 * 91 = 44.84

2. In Ben Grahams calculation of liquidation value, Sherwin-Williams Co's accounts receivable are only considered to be worth 75% of book value:

Sherwin-Williams Co's liquidation value for the quarter that ended in Mar. 2017 is calculated as:

 Liquidation value = Cash and Cash Equivalents - Total Liabilities + (0.75 * Account Receivable) + (0.5 * Inventory) = 1017.808 - 4923.553 + 0.75 * 1356.851 + 0.5 * 1247.688 = -2,264

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

Be Aware

Net receivables tells us a great deal about the different competitors in the same industry. In competitive industries, some attempt to gain advantage by offering better credit terms, causing increase in sales and receivables.

If company consistently shows lower % Net receivables to gross sales than competitors, then it usually has some kind of competitive advantage which requires further digging.

Average Days Sales Outstanding is a good indicator for measuring a companys sales channel and customers. A company may book great revenue and earnings growth but never receive payment from their customers. This may force a write-off in the future and depress future earnings.

Related Terms

Historical Data

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

Sherwin-Williams Co Annual Data

 Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 Dec16 Accts Rec. 871 770 696 917 990 1,033 1,098 1,131 1,114 1,231

Sherwin-Williams Co Quarterly Data

 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Accts Rec. 1,131 1,235 1,454 1,414 1,114 1,291 1,473 1,458 1,231 1,357
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)