Question 18.S-TP.1: The Operating and Cash Cycles Consider the following financi...
The Operating and Cash Cycles Consider the following financial statement information for the Route 66 Company:
| Ending | Beginning | Item |
| $1,401 | $1,273 | Inventory |
| 3,368 | 3,782 | Accounts receivable |
| 2,025 | 1,795 | Accounts payable |
| $14,750 | Net sales | |
| 11,375 | Cost of goods sold | |
Calculate the operating and cash cycles.
We first need the turnover ratios. Note that we use the average values for all balance sheet items and that we base the inventory and payables turnover measures on cost of goods sold:
Inventory turnover = $11,375 /[( 1,273 + 1,401) / 2 ] = 8.51 times
Receivables turnover = $14,750 /[( 3,782 + 3,368 ) / 2 ] = 4.13 times
Payables turnover = $11,375 /[( 1,795 + 2,025 ) / 2 ] = 5.96 times
We can now calculate the various periods:
Inventory period = 365 days / 8.51 times = 42.89 days
Receivables period = 365 days / 4.13 times = 88.38 days
Payables period = 365 days / 5.96 times = 61.24 days
So the time it takes to acquire inventory and sell it is about 43 days. Collection takes another 88 days, and the operating cycle is thus 43+ 88 = 131 days. The cash cycle is thus 131 days less the payables period: 131- 61 = 70 days.