Problem No. 1 Cash Conversion CycleChastain Corporation is trying to determine the effect of its inventory turnover ratio and dayssales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were$204000; its cost of goods sold is 80% of sales; and it earned a net profit of 5%, or $10200. Itturned over its inventory 5 times during the year, and its DSO was 35.5 days. The firm had fixedassets totaling $50000. Chastain's payables deferral period is 45 days. Assume 365 days inyear 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 8.1times. What would Chastain's cash conversion cycle, total assets turnover, and ROAhave been if the inventory turnover had been 8.1 for 2016? Round your answers to twodecimal places. Do not round intermediate calculations. 1 Cash conversion cycle23Sales4 Cost of good sold%5 Net profit margin678310Original Inventory turnover ratioDSOFixed assetsPayables deferral period11 Calculate inventory conversion period:12 Inventory13 Inventory conversion period (days)1415161718Calculate cash conversion cycle:Cash conversion cycle (daya)13 Accounts receivable20 Total apot21 Total assets turnover22Calculate total assets turnover:31 Inventory conversion period (days)32$204,00080.00%5.00%535.5$50,0004523 Calculate return on assets:24 Not income25 Return on appeto (ROA)2627 Revised inventory turnover ratio2823 Calculate inventory conversion period:30 Inventory3334 Cash conversion cycle (days)3536 Calculate total assets turnover:37 Accounts receivable38 Total assets394041Calculate cash conversion cycle:Total appeto turnoverBCalculate return on assets:42 Not income43 Return on at (ROA)44458.1сDEFG

Answered: Chastain Corporation is trying to…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Libscomb Technologies' annual sales are $6,974,991 and all sales are made on credit, it purchases $3,511,535 of materials each year (and this is its cost of goods sold). Libscomb also has $550,869 of inventory, $522,928 of accounts receivable, and $477,584 of accounts payable. Assume a 365 day year. What is Libscomb’s Inventory Turnover?
General Forge and Foundry Company has a quick ratio of 2.00; $33,750 in cash; $18,750 in accounts receivable; some inventory; total current assets of $75,000; and total current liabilities of $26,250. In its most recent annual report, General Forge reported annual sales of $100,000 and a cost of goods sold equal to 65% of annual sales. How many times is General Forge and Foundry Company selling and replacing its inventory? O 4.44x O 3.179x O 0.35x O 2.89x
Suppose the 2022 income statement for McDonald's Corporation shows cost of goods sold $4,878.8 million and operating expenses (including depreciation expense of $1,226.0 million) $10,671.1 million. The comparative balance sheets for the year show that inventory decreased $7.4 million, prepaid expenses increased $43.4 million, accounts payable (inventory suppliers) increased $19.1 million, and accrued expenses payable increased $195.8 million. Using the direct method, compute (a) cash payments to suppliers and (b) cash payments for operating expenses. (Enter answers in millions to 1 decimal place, e.g. 527.5.) Cash payments to suppliers $ Cash payments for operating expenses $ million million
Last year, Jumpin' Trampolines (JT) had a quick ratio of 1.0, a current ratio of 1.8, an inventory turnover of 3.5, total current assets of $67,500, and cash and equivalents of $15,00. If the cost of goods sold equaled 70 percent of sales, what were JT's annual sales and DSO?
Smith Corporation had Sales of $2,350,000 in 2021 and $2,125,000 in 2020. Cost of Good Sold were $1,400,000 in 2021 and $1,325,000 in 2020. a. What was the percentage change in Sales year to year? b. What was the percentage change in Cost of Goods Sold year to year? c. Relative to the percentage in Sales, would you say the percentage change on Cost of Goods Sold was favorable or unfavorable? d. Is this an example of horizontal or vertical analysis?
In 2016, the Allen corporation had sales of $63 million, total assets of $44 million, and total liabilities of $15 million. The interest rate on the company’s debt is 5.7 percent, and it’s tax rate is 35 percent. The operating profit margin is 14 percent. A. Compute the firm’s 2016 net operating income and net income The firm’s 2016 net operating income is Round to two decimal places.
You are trying to prepare financial statements for Bartlett Pickle Company, but seem to be missing its balance sheet. You have Bartlett's income statement, which shows sales last year were $300 million with a gross profit margin of 30 percent. You also know that credit sales equaled three-quarters of Bartlett's total revenues last year. In adlon, Bartlett had a collection period of 40 days, a payables period of 30 days, and an inventory turnover of 7 times based on cost of oods sold. Calculate Bartlett's year-ending balance for accounts receivable, inventory, and accounts payable. Note: Round your answers to 1 decimal place. Bartlett's year-ending balance (million) Accounts receivable Inventory Accounts payable BV3
For 2021, Walmart and Target had the following information (all values are in millions of dollars): Assume a 365-day year. a. What is each company's accounts receivable days? b. What is each company's inventory turnover? c. Which company is managing its accounts receivable and inventory more efficiently? Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Walmart Target (Income Statement) Sales 572,762 106,007 Cost of Goods Sold (Income Statement) 428,997 74,962 Accounts Receivable (Balance Sheet) 8,279 830 Inventory (Balance She 56,519 13,902 = X
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 $285000; its cost of goods sold is 80% of sales; and it earned a net profit of 6%, or $17100. It turned over its inventory 6 times during the year, and its DSO was 35 days. The firm had fixed assets totaling $37000. Chastain's payables deferral period is 40 days. Assume 365 days in year for your calculations. 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 8.9 times. What would Chastain's cash conversion cycle, total assets…
Adams Furniture has a quick ratio of 2.00x, $37,575 in cash, $20,875 in accounts receivable, some inventory, total current assets of $83,500, and total current liabilities of $29,225. The company reported annual sales of $100,000 in the most recent annual report. Additionally, the company’s cost of goods sold is 75% of sales. Over the past year, how often did Adams Furniture sell and replace its inventory? 8.01x 3.29x 2.86x 2.99x
For the year ended December 31, 2022, Settles Incorporated earned an ROI of 10.5%. Sales for the year were $9 million, and average asset turnover was 2.1. Average stockholders' equity was $2.8 million. Required: Calculate Settles Incorporated's margin and net income. Note: Round "Margin" answer to 1 decimal place. Enter the net income answer in dollars, i.e., $5 million should be entered as 5,000,000. Calculate Settles Incorporated's return on equity. Note: Round your answer to 1 decimal place.
Libscomb Technologies' annual sales are $6,997,444 and all sales are made on credit, it purchases $3,879,449 of materials each year (and this is its cost of goods sold). Libscomb also has $530,851 of inventory, $490,754 of accounts receivable, and $417,441 of accounts payable. Assume a 365 day year. What is Libscomb’s Receivables Turnover?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS