Inventory Days = Average Inventory for the Quarter ÷ CGS per day
Payable Days = Average Accounts Payable for the Quarter ÷ CGS per day.
The results are show as whole numbers.
Step 3 - Calculate the Cash to Cash Cycle
Cash to Cash = Receivable Days + Inventory Days - Payable Days
NEW!!! JUST RELEASED!!!
Now you can compute the Cash to Cash cycle for an organization using the Interactive Strategic Profit Model (SPM) spreadsheet tool which is now available at shop.inventorycurve.com. Enter in financial information from the Balance Sheet and Income Statement and the spreadsheet computes and presents two versions of the SPM for an organization including the Cash to Cash Cycle calculation. Use coupon code ICSpring14 for a 20% discount off the already low price.
Have questions about the cash to cash cycle? Send me a note at David.Armstrong@inventorycurve.com
The cash to cash cycle is indicative of the business model a company chooses to use and their effectiveness at executing the model.
Dell is commonly used as the example for an extremely effective cash to cash cycle and consistently has a negative cash to cash cycle. For the quarter ending October 31, 2008, Dell had a cash to cash cycle as follows:
Receivable Days 36
Inventory Days 8
Payable Days (69)
Cash to Cash Days (25)
Cash to cash tracking can be done between different companies in the same industry segment or for different periods in time to both understand the dynamics of the business and to assess opportunities for improvement.
Normally, the lower the Cash to Cash Days, the better, but too low days in inventory can indicate service issues if the inventory is not properly planned and managed and very high days in payables may result in issues with suppliers.