Day calculations or ratios are measures of efficiency and provide an insight into how long cash is tied up for in a business. The calculations are based on three key components of the day-to-day operations of a business: inventories, receivables and payables. These items are analyzed by calculating them as a percentage of sales as shown below:
Many companies provide a credit period on sale and receivable days shows how long on average customers are taking to pay. It is calculated as the ending receivables balance, divided by sales for the reported period, multiplied by number of days the sales represent. Often the number of days is 365, which represents one full year of business operations.
Inventory days provides the number of days of selling possible before the warehouse is emptied. This metric gives a good indication on whether a company is needlessly holding onto its inventory. Holding inventory in warehouses incurs costs to the business and might also indicate if the business is holding potential cash as unsold stock, which could be better used in other operations.
Payables shows the average number of days the business is taking to discharge its obligations to suppliers. A high positive number indicates the company has a free source of funding and can use that cash it owes to cover other costs. However, a low or even negative number suggests the business is not meeting the payment deadlines for its obligations.
Ending balance sheet amounts are commonly the basis for forecasting forward and are used in the formulas shown above. Some analysts (typically credit analysts) use an average balance figure for the period instead. However, the ending balance is preferred for forecasting.
Cash Conversion Cycle
The cash conversion cycle uses the three ratios to measure the efficiency of the business by showing how much time is needed between the acquisition of raw materials and the receipt of cash from customers. It is like an OWC calculation but expressed in days rather than monetary amounts, so inventory and receivable days (the assets) are added and payable days (the liability) is subtracted. The net product is the number of days for which funding is tied up or released.
Consider a business with the following information:
- Inventory days: 30
- Receivable days: 25
- Payable days: 50
For this business, on average it takes 30 days from the acquisition of product until its delivery to customers, following a sale. The customers then take 25 days to pay after receipt of the goods. Meanwhile, it takes the business 50 days to pay its suppliers for the product. It, therefore, takes 55 days (30 + 25) between buying product and receiving cash from customers. We can, therefore, say 50 days of this cycle is funded for free by the supplier leaving 5 days funding shortfall. This funding must come from traditional sources on which interest will be charged. It can be deduced that the shorter the cash cycle is, the more efficient the business.