Cash Velocity Excel Calculator

This tool estimates how long it takes to convert a dollar paid for inventory into a dollar received on sales.

by CFO.University
A Community of Member-Scholars, Companies and Trusted Advisors committed to the development of Chief Financial OfficersFollow 18

171 views|Start the discussion!|Bookmark Add to cart - $20.00

Description
The Cash Velocity Calculator estimates how long it takes on average to convert a dollar paid for inventory into a dollar received on sales. Using some basic figures from your financial statements you’ll have a transparent view of where your working capital is invested and how improvements in terms or operations will impact cash. Use this tool to teach your executive team and staff about working capital and cash management.

This tool uses the beginning and ending balances for you working capital accounts to calculate an estimate for the average “days” outstanding. This includes the average number of days to collect accounts receivable, the average number of days materials stay in inventory and the average number of days we use to pay vendors (payables). Receivables and Inventory use cash while Payables are a source of cash.

All the calculations in the Cash Velocity Calculator are done for you based on your inputs.

We can improve our cash velocity through 1) reducing uses of cash by decreasing the days outstanding for our uses of cash, receivables and inventory or 2) increasing sources of cash by expanding the days outstanding payables.

Cash Velocity Days = DSO + DII – DPO

It may seem counterintuitive but the lower the cash velocity days the quicker sales are being converted to cash.

A nice feature of the Cash Velocity Calculator is it calculates the working capital changes you can expect from any percentage change you anticipate in your collection or payment terms or changes in production or logistics that will impact inventory.

The example on the Cash Velocity tab in the tool shows just how simple it is to get started and predict the result of meeting an improvement goal.

This Best Practice includes
1 Excel file