1.
Concept Introduction:
Inventory Turnover ratio: It tells the company about how many times the inventory is available of cost of goods sold. It helps us in the calculation of the number of days in which the inventory is sold by the company. It helps to make a better record of inventory.
To Calculate: Inventory turnover of 2 companies.
1.
Answer to Problem 2BTN
Company 1st => (Current year)= 53.18times.
(Previous year)= 60.43 times.
Company 2nd => (Current year)= infinite.
(Previous year)= 51.63 times.
Explanation of Solution
2.
Concept Introduction:
Inventory Turnover ratio: It tells company about how many times inventory available of cost of goods sold. It helps us in calculation of no. of days in which inventory is sold by company. It helps in to make better record of inventory.
To Calculate: Day’s sales of inventory.
2.
Answer to Problem 2BTN
Company 1st (Current Year) = 6.86 days
(Previous Year) = 6 days
(2 Year Back) = 3.29 days
Company 2nd (Current Year) = 0
(Previous Year) = 7.07 days
(2 Year Back) = 10.73 days
Explanation of Solution
Concept Introduction:
Inventory Turnover ratio: It tells company about how many times inventory available of cost of goods sold. It helps us in calculation of no. of days in which inventory is sold by company. It helps in to make better record of inventory.
Requirement-2:
To Calculate:
Comment on above findings.
Answer to Problem 2BTN
Company 1st have higher inventory turnover than the industry average.
Company 2nd have higher inventory turnover ratio in 2 years out of 3 years.
Explanation of Solution
Company 1st have inventory turnover is more than the 40 (industry average). Company have inventory turnover ratio is 53.18 times in current year, 60.43 in previous year and 111 times before 2 years.
Company 2nd have inventory turnover is more than the 40 (industry average) in 2 years. Company have inventory turnover ratio is infinite in current year, 51.63 times in previous year and 34 times (less than industry average.) Before 2 years.
Want to see more full solutions like this?
Chapter 5 Solutions
Financial Accounting: Information for Decisions
- Financial statement data for years ending December 31 for Tango Company follow: a. Determine the inventory turnover for 20Y7 and 20Y6. b. Determine the days sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y6 to 20Y7 indicate a favorable or an unfavorable trend?arrow_forwardFinancial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?arrow_forwardUse the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreenss Year +1 revenue growth rate, gross profit margin, and inventory turnover will be identical to Year 12. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance.arrow_forward
- Last year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forwardCompute Altoona Companys (a) inventory turnover ratio and (b) number of days sales in inventory ratio, using the following information.arrow_forwardThe following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forward
- The general merchandise retail industry has a number of segments represented by the following companies: For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports (in millions) for these three companies: a. Determine the inventory turnover ratio for all three companies. Round all calculations to one decimal place. b. Determine the number of days sales in inventory for all three companies. Use 365 days and round all calculations to one decimal place. c. Interpret these results based on each companys merchandising concept.arrow_forwardUse a spreadsheet and the following excerpts from Hileah Companys financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days sales in inventory, for the year 2018.arrow_forwardAnalyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?arrow_forward
- Inventory Analysis Singleton Inc. reported the following information for the current year: Required: Compute Singletons (a) gross profit ratio, (b) inventory turnover ratio, and (c) average days to sell inventory. (Note: Round all answers to two decimal places.)arrow_forwardUse the following information relating to Shana Company to calculate the inventory turnover ratio and the number of days sales in inventory ratio.arrow_forwardHabicht Company was formed in 2018 to produce a single product. The production and sales for the next 4 years were as follows: Required: 1. Determine the gross profit for each year under each of the following periodic inventory methods: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places.) 2. Next Level Explain whether the companys return on assets (net income divided by average total assets) would be higher under FIFO or LIFO.arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Individual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENTFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning