Free Subscription to CFO Magazine

Growing Problems: The 2007 Working Capital Survey

(continued)


How Working Capital Works

Days Sales Outstanding: AR/(total revenue/365)
Year-end trade receivables net of allowance for doubtful accounts, plus financial receivables, divided by one day of average revenue.
A decrease in DSO represents an improvement, an increase a deterioration. In the accompanying charts, companies marked with an asterisk have securitized receivables, which improve DSO through financing alternatives without improving the underlying customer-to-cash processes such as credit-risk assessment, billing, collections, and dispute management. The scorecard eliminates this distortion by adding securitized receivables back on the balance sheet before calculating DSO.

Days Inventory Outstanding: Inventory/(total revenue/365)
Year-end inventory divided by one day of average revenue.
A decrease is an improvement, an increase a deterioration.

Days Payables Outstanding: AP/(total revenue/365)
Year-end trade payables divided by one day of average revenue.
An increase in DPO is an improvement, a decrease a deterioration. For purposes of the survey, payables exclude accrued expenses.

Days Working Capital: (AR + inventory - AP)/(total revenue/365)
Year-end net working capital (trade receivables plus inventory, minus AP) divided by one day of average revenue.
The lower the number of days, the better. The percentage change is marked N/M (not meaningful) if DWC moved from a positive to a negative number or vice versa. Also, when a company has a negative DWC, an improvement will show up in our chart as a positive percentage change from 2005 to 2006.

*Note: Many companies use cost of goods sold instead of net sales when calculating DPO and DIO. Our methodology, however, uses net sales across the four working-capital categories to allow a balanced comparison. Reported sales have been adjusted for acquisitions and disposals during the year.

This year's survey uses the Global Industry Classification Standard (GICS) to categorize companies. Results from past years have been recalculated for consistency.



Reader CommentsDisplaying 3 of 3

  • Stefan Heimrich

    Aug 20, 2008 4:48 PM ET

    DIO - using COGS or Sales as Denominator

    So can you please confirm that in the 2007 NWC Study as a denominator to calculate DIO COGS instead of Sales have been … more

  • charlie Yang

    Jul 26, 2008 8:11 AM ET

    Definition of DIO and DPO

    The article gave the wrong definitions about two concepts: DIO=Average Invetory/(CGS/365) NOT (Total revenue/365) … more

  • Ivonne Lopez

    Jul 3, 2008 12:15 PM ET

    Data for WC and DPO

    I see comment that European Companies are making advancements in Working Capital, yet cannot find the survey results in … more

Post a comment | View all comments

advertisement

advertisement

We Deliver

Newsletters

Webcasts

Enter your email address to begin receiving updates on these topics.