Days Inventory Outstanding (DIO) is calculated by := Inventory / Cost of Sales * 365
=(1.5/14)*365=39 days
Cash Conversion cycle = Days Inventory Outstanding (DIO) + Days Sales Outstanding (DSO) – Days Payable Outstanding (DPO)
Days sales outstanding = 1.2/14*365=31
Days payable outstanding =1.3/14 *365 =34
Cash conversion cycle = 39+31-34= 36 days.
Question 5 (8 points) Find the Cash-to-Cash Cycle Time if the annual sales is $14 million, cost of goods sold is S10 million, average inventory is SI.5 million, accounts receivable is S1.2 million...
1. In 2016, Syntax Corp has average inventory of $5 million, average receivable of $3 million, and average payable of $2 million. It had sales of $20 million and cost of goods sold of $15 million. a) What's inventory period, receivable period and payable period? b) What's the operating cycle and cash cycle?
Annual sales $9,700,000 Cost of goods sold $7,275,000 Inventory $3,200,000 Accounts receivable $1,800,000 Accounts payable $2,400,000 Blue Ostrich's CFO is interested in determining the length of time funds are tied up in working capital. Use the information in the preceding table to complete the following table. (Note: Use 365 days as the length of a year in all calculations, and round all values to two decimal places.) Value Inventory conversion period Average collection period Payables deferral period Cash conversion cycle...
Margetis Inc. carries an average inventory of $750,000. Its annual sales are $10 million, its cost of goods sold is 75% of annual sales, and its average collectionperiod is twice as long as its inventory conversion period. The firm buys on terms of net 30 days, and it pays on time. Its new CFO wants to decrease the cashconversion cycle by 10 days, based on a 365-day year. He believes he can reduce the average inventory to $647,260 with no...
A company reports annual sales of $5 million, cost of goods sold of $2 million, inventory of $0.5 million, and net income of $0.75 million. What are the company's annual inventory turns?
XYZ Company has annual sales of $622531. The cost of goods sold are $317825. The firm has an accounts receivable balance of $16073, an accounts payable balance of $21911 and inventory of $30330. What is the lengh of time between paying for materials and collecting on receivables?That is, what is the cash conversion cycle? Assume 365 days.
Cash Retained earnings Cost of goods sold Salaries and wages expense Prepaid insurance Inventory Accounts receivable Sales revenue Notes payable Accounts payable Service revenue Interest expense $ 85,100 124,400 435,100 118,800 7,800 64,500 90,000 593,100 6,600 56,700 5,400 1,880 (a) In each case, identify whether the item is an asset, liability, stockholders' equity, revenue, or expense item. Revenue Cash Revenue Retained earnings Expense Cost of goods sold Salaries and wages expense Prepaid insurance Inventory Accounts receivable # + Sales revenue...
Cold Chiller Corporation (CCC) has annual sales of $10 million, cost of goods sold of 60 percent, average age of inventory of 80 days, average collection period of 35 days, average payment period of 30 days, and purchases that are 60 percent of cost of goods sold. How much does CCC have invested in its cash conversion cycle assuming a 365-day year?
Jordan Air Inc. has average inventory of $1,000,000. Its estimated annual sales are 15 million and the firm estimates its receivables collection period to be twice as long as its inventory conversion period. The firm pays its trade credit on time; its terms are net 30. The firm wants to decrease its cash conversion cycle by 10 days. It believes that it can reduce its average inventory to $900,000. Assume a 360-day year and that sales will not change. Cost...
Hanse, Inc., has a cash cycle of 37.5 days, an operating cycle of 51 days, and an inventory period of 21 days. The company reported cost of goods sold in the amount of $359,000, and credit sales were $582,000. What is the company’s average balance in accounts payable and accounts receivable? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Net Sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end $1,095,000 657,000 44,250 18,000 226,000 158,400 Required: a. Calculate the inventory turnover for 2019. (Round your answer to 2 decimal places.) b. Calculate the number of days' sales in inventory for 2019, using year-end inventories. (Use 365 days a year. Round your answer to 1 decimal place.) c. Calculate the accounts receivable turnover for 2019. (Round...