Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...

90.2K

Verified Solution

Question

Finance

Chastain Corporation is trying to determine the effect of itsinventory turnover ratio and days sales outstanding (DSO) on itscash conversion cycle. Chastain's 2016 sales (all on credit) were$193000; its cost of goods sold is 80% of sales; and it earned anet profit of 2%, or $3860. It turned over its inventory 6 timesduring the year, and its DSO was 37 days. The firm had fixed assetstotaling $37000. Chastain's payables deferral period is 35 days.Assume 365 days in year for your calculations. The data has beencollected in the Microsoft Excel Online file below. Open thespreadsheet and perform the required analysis to answer thequestions below.
Open spreadsheet
Calculate Chastain's cash conversion cycle. Round your answer totwo decimal places. Do not round intermediate calculations.
days
Assuming Chastain holds negligible amounts of cash andmarketable securities, calculate its total assets turnover and ROA.Round your answers to two decimal places. Do not round intermediatecalculations.
Total assets turnover
ROA %
Suppose Chastain's managers believe that the inventory turnovercan be raised to 8.7 times. What would Chastain's cash conversioncycle, total assets turnover, and ROA have been if the inventoryturnover had been 8.7 for 2016? Round your answers to two decimalplaces. Do not round intermediate calculations.
Cash conversion cycle days
Total assets turnover
ROA %

Answer & Explanation Solved by verified expert

3.7 Ratings (386 Votes)

a Inventory turnover 6 No of days in a year 365 Days of inventory on hand No of days in a year Inventory turnover 365 6 608333 Cash conversion cycle Days of inventory on hand Days of sales outstanding Payables deferral period 608333 37 35 628333 6283 days rounded to two decimal places b sales credit sales 193000 Cost of goods sold 80 of sales 80 of 193000 154400 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Chastain Corporation is trying to determine the effect of itsinventory turnover ratio and days sales outstanding (DSO) on itscash conversion cycle. Chastain's 2016 sales (all on credit) were$193000; its cost of goods sold is 80% of sales; and it earned anet profit of 2%, or $3860. It turned over its inventory 6 timesduring the year, and its DSO was 37 days. The firm had fixed assetstotaling $37000. Chastain's payables deferral period is 35 days.Assume 365 days in year for your calculations. The data has beencollected in the Microsoft Excel Online file below. Open thespreadsheet and perform the required analysis to answer thequestions below.Open spreadsheetCalculate Chastain's cash conversion cycle. Round your answer totwo decimal places. Do not round intermediate calculations.daysAssuming Chastain holds negligible amounts of cash andmarketable securities, calculate its total assets turnover and ROA.Round your answers to two decimal places. Do not round intermediatecalculations.Total assets turnover ROA%Suppose Chastain's managers believe that the inventory turnovercan be raised to 8.7 times. What would Chastain's cash conversioncycle, total assets turnover, and ROA have been if the inventoryturnover had been 8.7 for 2016? Round your answers to two decimalplaces. Do not round intermediate calculations.Cash conversion cycledaysTotal assets turnover ROA%