In: Finance
inventory: beginning $21,430 Ending $23,865
Accounts receivable: beginning $15,362 Ending $17,210
accounts payable: beginning $20,416 Ending $21,803
net sales for the year: $243,612
cost of goods sold for the year: $108,915
what is the cash cycle?
| Ans. | Cash cycle = Days sales in inventory + Days sales in receivables - Payable period | |||||
| 75.90 + 24.60 - 69.20 | ||||||
| 31.30 | days | |||||
| *Calculations: | ||||||
| Days sales in inventory = Average inventory / Cost of goods sold * No. of days in year | ||||||
| 22647.5 / 108915 * 365 | ||||||
| 75.90 | days | |||||
| *Average inventory = (Beginning inventory + Ending inventory) / 2 | ||||||
| (21430 + 23865) / 2 | ||||||
| 22647.5 | ||||||
| Days sales in receivables = Average receivables / Sales * No. of days in year | ||||||
| 16421 / 243612 * 365 | ||||||
| 24.60 | days | |||||
| *Average receivables = (Beginning receivables + Ending receivables) / 2 | ||||||
| (15632 + 17210) / 2 | ||||||
| 16421 | ||||||
| *Payable period = Average payable / Purchase * No. of days in year | ||||||
| 21109.5 / 111350 * 365 | ||||||
| 69.20 | days | |||||
| *Average payable = (Beginning payable + Ending payable) / 2 | ||||||
| (20416 + 21803) / 2 | ||||||
| 21109.5 | ||||||
| *Purchase = Cost of goods sold + Ending inventory - Beginning inventory | ||||||
| 108915 + 23865 - 21430 | ||||||
| 111350 | ||||||
*Payable period can also be determined by using the following formula:
Average payable / Cost of goods sold * No. of days in year