Part 1)
The following figures are extracted from the recent financial statements of a manufacturer called Technograph. The company produces custom-use monitors and has a large amount of working capital due to many purchases of electronic materials from suppliers, inventory of finished goods and work-in-process. However, due to recent hikes in loan rates the cost of financing has gone up and the management is not happy with the large amount of cash that is being tied up in the firm.
Management first wants to know how long cash is tied up in the operations, from the time it is spent on raw materials to the time it is recovered through sales.
| Starting inventory | 12843 |
|---|---|
| Ending inventory | 1293 |
| Starting Accounts Receivable | 7193 |
| Ending Accounts Receivable | 6594 |
| Starting Accounts Payable | 4384 |
| Ending Accounts Payable | 5615 |
| COGS | 112101 |
| Sales | 130721 |
What is the average Inventory? ____________________
What is the average Accounts Receivable? ____________________
What is the average Accounts Payable? ___________________
Part 2)
What is the Days of Inventory Outstanding? ____________________
What is the Days of Payables Outstanding? ____________________
What is the Days of Sales Outstanding? _______________________
Part 3)
What is the cash to cash cycle (cash conversion cycle) for the company? Answer in full days: _____________________
Part 1) The following figures are extracted from the recent financial statements of a manufacturer called...
1.Zebra Company reports the following figures for the years ending December 31, 2019 and 2018: 2019 2018 Net Sales $65,000 $40,000 Cost of Goods Sold 42,000 31,000 Gross Profit $23,000 $9,000 What are the percentage changes from 2018 to 2019 for Net Sales, Cost of Goods Sold and Gross Profit, respectively? (Round your final answers to one decimal place, X.X%) A. 100%, 155.6%, 35.5% B. 62.5%, 35.5%, 155.6% C. 100%, 0.7%, 0.4% D. 155.6%, 62.5%, 35.5% 2. Szidon Company reports...
A firm takes 30 days to collect its accounts receivables and 45 days to pay its accounts payable. Its average age of inventory is 75 days. Its annual sales are $800,000 with COGS of $350,000 and purchases of $220,000. 1. What is the firm's cash conversion cycle (CCC)? What does it measure? 2. What is the amount of resources tied up in the CCC in each of the following areas: a Inventory b Accounts receivable C Accounts payable Cash 3...
Use Revlon's financial information to answer the following questions: a. What is Revlon's operating cycle (in days/) in 2016 and 2015? Comment on the change form year to year. b. What is Revlon's cash operating cycle (in dyads)in 2016 and 2015? Comment on the change form year to year. c. Use Revlon's financial information to compare the components of Revlon's operating cycle and cash operating cycle to L'Oreal's for 2016. The following table provides the amount for L'Oreal. Balance Sheet...
Annual sales $9,700,000 Cost of goods sold $7,275,000 Inventory $3,200,000 Accounts receivable $1,800,000 Accounts payable $2,400,000 Blue Ostrich's CFO is interested in determining the length of time funds are tied up in working capital. Use the information in the preceding table to complete the following table. (Note: Use 365 days as the length of a year in all calculations, and round all values to two decimal places.) Value Inventory conversion period Average collection period Payables deferral period Cash conversion cycle...
Consider the following financial statement information for the Amaryllis Corporation: Item Beginning Ending Inventory $8,732 $9,418 Accounts receivable 3,721 4,162 Accounts payable 4,384 4,791 Net sales $138,503 Cost of goods sold 86,313 Required: Assume all sales are on credit. Calculate the operating and cash cycles. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) Operating cycle days Cash cycle days
Consider the following financial statement information for the Schwertzec Corporation: Item Beginning Ending Inventory $ 11,700 $ 12,700 Accounts receivable 6,700 7,000 Accounts payable 8,900 9,300 Credit sales $ 97,000 Cost of goods sold 77,000 Calculate the operating and cash cycles. (Use 365 days a year. Do not round intermediate calculations and round your final answers to 2 decimal places. (e.g., 32.16)) Operating cycle days Cash cycle days
Consider the following financial statement information for the Hop Corporation: Item Beginning $10,400 Ending $11,400 Inventory Accounts 5,400 5,700 receivable Accounts 7,600 8,000 payable Net sales $84,000 Cost of goods sold 64,000 Calculate the operating and cash cycles. (Use 365 days a year. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Operating cycle days days Cash cycle
Consider the following financial statement information for the Newk Corporation: Item Inventory Accounts receivable Accounts payable Credit sales Cost of goods sold Beginning $ 10,200 5,200 7,400 Ending $11,200 5,500 7,800 $82,000 62,000 Calculate the operating and cash cycles. (Use 365 days a year. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) days Operating cycle Cash cycle days
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...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...