Question

In: Finance

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

Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $275000; its cost of goods sold is 80% of sales; and it earned a net profit of 8%, or $22000. It turned over its inventory 6 times during the year, and its DSO was 32.5 days. The firm had fixed assets totaling $40000. Chastain's payables deferral period is 35 days. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

a. Calculate Chastain's cash conversion cycle. Round your answer to two decimal places. Do not round intermediate calculations.

b. Assuming Chastain holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Round your answers to two decimal places. Do not round intermediate calculations.

c. Suppose Chastain's managers believe that the inventory turnover can be raised to 9.3 times. What would Chastain's cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 9.3 for 2016? Round your answers to two decimal places. Do not round intermediate calculations.

Solutions

Expert Solution

a). CCC = Days Inventory outstanding + Days Sales Outstanding - Days Payable outstanding

Inventory Turnover Ratio = Cost of Goods Sold/ Average Inventory

6 = [0.80 x $275,000] / Average Inventory

Average Inventory = [0.80 x $275,000] / 6 = $36,666.67

Days Inventory Outstanding = 365/Inventory turnover ratio = 365/ 6 = 60.83 days

Days Sales Outstanding = 32.5 days

Days Payable Outstanding = 35 days

CCC = 60.83 + 32.5 - 35 = 58.33 days

b). Total Receivables = Sales / [365 / DSO] = $275,000 / [365 / 32.5] = $24,486.30

Total Assets = Fixed Assets + Total Inventory + Total Receivables

= $40,000 + $36,666.67 + $24,486.30 = $101,152.97

Total Assets Turnover= Sales/Total Assets

= $275,000/$101,152.97 = 2.72 times

ROA= Net Income / Total Assets = $22,000 / $101,152.97 = 21.75%

c). CCC = [365/9.3] + 32.5 - 35 = 36.75 days

Total Assets = Fixed Assets + Total Inventory + Total Receivables

= $40,000 + [(0.80 x $275,000) / 9.3] + $24,486.30 = $88,142.22

Total Assets Turnover= Sales/Total Assets

= $275,000/$88,142.22 = 3.12 times

ROA= Net Income / Total Assets = $22,000 / $88,142.22 = 24.96%


Related Solutions

Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $241,000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $4,820. It turned over its inventory 6 times during the year, and its DSO was 34.5 days. The firm had fixed assets totaling $27,000. Chastain's payables deferral period is 45 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2019 sales (all on credit) were $208,000, its cost of goods sold is 80% of sales, and it earned a net profit of 7%, or $14,560. It turned over its inventory 4 times during the year, and its DSO was 33 days. The firm had fixed assets totaling $44,000. Chastain's payables deferral period is 40 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $158000; its cost of goods sold is 80% of sales; and it earned a net profit of 4%, or $6320. It turned over its inventory 5 times during the year, and its DSO was 33.5 days. The firm had fixed assets totaling $49000. Chastain's payables deferral period is 45 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $100,000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $2,000. It turned over its inventory 6 times during the year, and its DSO was 34 days. The firm had fixed assets totaling $35,000. Chastain's payables deferral period is 50 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $294,000; its cost of goods sold is 80% of sales; and it earned a net profit of 3%, or $8,820. It turned over its inventory 7 times during the year, and its DSO was 36.5 days. The firm had fixed assets totaling $30,000. Chastain's payables deferral period is 45 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $127,000; its cost of goods sold is 80% of sales; and it earned a net profit of 4%, or $5,080. It turned over its inventory 5 times during the year, and its DSO was 40 days. The firm had fixed assets totaling $49,000. Chastain's payables deferral period is 40 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $193000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $3860. It turned over its inventory 6 times during the year, and its DSO was 37 days. The firm had fixed assets totaling $37000. Chastain's payables deferral period is 35 days....
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $185000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $3700. It turned over its inventory 4 times during the year, and its DSO was 37 days. The firm had fixed assets totaling $28000. Chastain's payables deferral period is 50 days....
Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales...
Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2015 sales (all on credit) were $168,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.03 times during the year. Its receivables balance at the end of the year was $13,172.98 and its payables balance at the end of the year was $7,400.17. Using this information calculate the firm's cash...
The steel company is trying to determine the effect of its inventory turnover ratio and days...
The steel company is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash flow cycle. Company’s sales last year (all on credit) were $150,000, and it earned a net profit of 6%, or $9,000. It turned over its inventory 7.5 times during the year, and its DSO was 36.5 days. Its annual cost of goods sold was $121,667. The firm had fixed assets totaling $35,000. Steel's payables deferral period is 40...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT