Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle?
Average inventory = $75,000
Annual sales = $600,000
Annual cost of goods sold = $360,000
Average accounts receivable = $180,000
Average accounts payable = $37,000
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $.
| Parameter | Linkage | $ |
| Sales | S | 600,000.00 |
| Inventory | I | 75,000.00 |
| Receivables | R | 180,000.00 |
| Payables | P | 37,000.00 |
| COGS | COGS | 360,000.00 |
| Parameter | Linkage | Days |
| Inventory Conversion Period | A = I/COGS x 365 | 76.04 |
| Average Collection period | B = R/S x 365 | 109.50 |
| Average Payment Period | C = P/COGS x 365 | 37.51 |
| Cash Conversion Cycle (CCC) | A + B - C | 148.03 |
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory = $75,000 Annual sales = $600,000 Annual cost of goods sold = $360,000 Average accounts receivable = $180,000...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365 day year, what is the firm's present cash conversion cycle? Enter your answer rounded to two decimal places. For example, if your answer is 123.45% or 1.2345 then enter...
Your consulting firm was recently hired to improve the performance of Shin-Soenen Inc, which is highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory = $75,000 Annual sales = $775,000 Annual cost of goods sold = $465,000 Average accounts receivable = $160,000...
Please show in Excel!
Your consulting firm was recently hired to improve the performance of Rumpke, which has been experiencing cash shortages due to its high growth rate. You want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory $75,000 Annual sales $500,000 Annual cost of goods sold $360,000 Average accounts receivable $160,000 Average accounts payable $25,000 ACP/DSO ICP PDP CCC 167.4944
12. Marshall Inc. recently hired your conting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high a th me. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365day year, what is the firm's present cash conversion cycle! $75.000 $600,000 $360,000 $160,000 $25,000 Average inventory Annual sales - Annual cost of goods sold - Average accounts...
vi А B С D E F G H Your consulting firm was recently hired to improve the performance of Rumpke, which has been experiencing cash shortages due to its high growth rate. You want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? 1 4 Average inventory Annual sales Annual cost of goods sold Average accounts receivable Average accounts payable $75,000 $500,000 $360,000 $160,000 $25,000...
To estimate the company's WACC, Marshall Inc. recently hired you as a consultant. You have obtained the following information. (1) The firm's existing noncallable bonds which mature in 40 years, have an 5.00% annual coupon, a par value of $1,000, and a market price of $950. You have done some research and estimate the cost of issuing additional debt would cost you similarly to the existing bonds. (2) The company's current tax rate is 40%, but the tax rate is...
Introduction William Livingston has recently been hired as the CEO of Electrics, Inc. Previously he had been the marketing manager for a large manufacturing company and had established a reputation for identifying new consumer trends. Electrics Inc. is a California-based generator manufacturing company. The company is well known for manufacturing large, heavy-duty generators at a reasonable cost. One of its greatest achievements is that its generators can be easily modified or customized for different applications. The company is considering an...
[The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Last Year 0 Lydex Company Comparative Balance Sheet This Year Assets Current assets: Cash $ 890,000 Marketable securities Accounts...
Required information [The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year $ 940,000 2,620,000 3,580,000 250,000 7,390,000 9,480,000 $...