Free Subscription to CFO Magazine

Cleaner (Balance) Sheets: The 2009 Working Capital Scorecard

(continued)

Randy Myers is a contributing editor of CFO.


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.

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.

This year's survey uses the Global Industry Classification Standard to categorize companies.


LinkedIn Company Connections:
  • Church & Dwight |
  • Cliffs Natural Resources |
  • REL |
  • Atlas Air Worldwide Holdings

Reader CommentsDisplaying 3 of 6

  • Hendra Sumantri Raharjaputra

    Nov 16, 2010 10:32 PM ET

    Tax not include A/R

    If the company purchased goods for inventory, vendors will charge tax to the company. We calculate cost of good sold … more

  • Firozali A Mulla

    Mar 22, 2010 1:00 AM ET

    Hard times have inspired companies to wring lots of cash out of working capital. How much better can they get?

    CBI director-general Richard Lambert said the economic outlook is improving. The UK's economic recovery will not pick … more

  • mario harg

    Mar 17, 2010 4:54 PM ET

    Calculation formula

    I will compare the figures, for this reason I am locking for the exact calculation formula (e.g.turnover with or … more

Post a comment | View all comments

advertisement

advertisement

We Deliver

Newsletters

Webcasts

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