Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data table (Click on the following icon in order to copy its contents into a spreadsheet.) 2014 2015 2016 2017 4,398 5,206 7,942 11,700 Sales
Data table (Click on the following icon in order to copy its contents into a spreadsheet.) 2014 2015 2016 2017 4,398 5,206 7,942 11,700 Sales Net Receivables-Total 618 820 1,044 1,306 Acounts payable 438 673 680 1,590 Inventories-Total 324 455 646 375 2018 18,406 2,228 2,489 340 (Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for the Crimson Mfg. Company follow: Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in inventory for each of the 5 years. (Assume a 365-day year. Hint: Assume that the firm's cost of goods sold equals 70% of sales.) What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? b. Calculate Crimson's cash conversion cycle for each of the 5 years. Evaluate the firm's overall management of its working capital. Assume a 365-day year. a. Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in inventory for each of the 5 years. Assume a 365-day year. Hint: Assume that the firm's cost of goods sold equals 70% of sales. (Round to two decimal places.) 2014 2015 2016 2017 2018 Days of sales outstanding (DSO) (Round to two decimal places.) 2014 2015 2016 2017 2018 Days of sales in inventory (DSI) (Round to two decimal places.) 2014 2015 2016 2017 2018 Days of payables outstanding (DPO) What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? "Crimson has made dramatic improvement to its working capital management by making a reduction in the firm's cash conversion cycle." Is the above statement true of false? (Select from the drop-down menu.) b. Calculate Crimson's cash conversion cycle for each of the 5 years. Assume a 365-day year. (Round to two decimal places.) 2014 2015 2016 2017 2018 Cash conversion cycle (CCC)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started