(a)
Inventory turnover ratio: This is a financial measure that is used to evaluate as to how many times a company sells or uses its inventory during an accounting period. It is calculated by using the following formula:
Days’ sales in inventory: Days’ sales in inventory are used to determine number of days a particular company takes to make sales of the inventory available with them.
Gross profit rate is the financial ratio that evaluates the money left over out of the total revenues after deducting the cost of goods sold. Thus, it shows the relationship between the gross profit and net sales. It is calculated by using the following formula:
To Calculate:
- The inventory turnover for 2016, and 2017 of Company Z.
- The days in inventory of Company Z for 2016, and 2017.
- The gross profit rate of Company Z for 2016, and 2017.
(a)
Explanation of Solution
Calculate the inventory turnover of Company Z for 2016.
Cost of goods sold = $1,288,000
Average inventory = $450,000 (1)
Calculate the inventory turnover of Company Z for 2017.
Cost of goods sold = $1,552,000
Average inventory = $560,500 (2)
Working Notes:
Calculate the average inventory for 2016.
Beginning inventory = $332,000
Ending inventory = $568,000
Calculate the average inventory for 2017.
Beginning inventory = $568,000
Ending inventory = $553,000
Calculate days in inventory of Company Z for 2016.
Total number of days = 365
Inventory turnover, 2016 = 2.86 times (a)
Calculate days in inventory of Company Z for 2017.
Total number of days = 365
Inventory turnover, 2016 = 2.77 times (a)
Calculate gross profit rate of Company Z for 2016.
Gross profit = $437,000 (3)
Sales revenue = $1,725,000
Calculate gross profit rate of Company Z for 2017.
Gross profit = $396,000 (4)
Sales revenue = $1,948,000
Working Notes:
Calculate the gross profit for 2016.
Sales revenue = $1,725,000
Cost of goods sold = $1,288,000
Calculate the gross profit for 2017.
Sales revenue = $1,948,000
Cost of goods sold = $1,552,000
Therefore, the inventory turnover of Company Z for 2016, and 2017 are 2.86 times, and 2.77 times respectively.
Therefore, the days in inventory for 2016, and 2017 are 128 days, and 132 days respectively.
Therefore, the gross profit rate of Company Z for 2016, and 2017 are 25.33%, and 20.33% respectively.
(b)
To Explain: Whether the liquidity and profitability of Company Z improve or deteriorate in 2017
(b)
Explanation of Solution
Based on the inventory turnover ratio and days’ in inventory are fluctuating in nature. Therefore, the liquidity of the company has deteriorated in the year 2016 and improved in the year 2017.
Based on the gross profit ratio, the profitability of the company has decreased.
Want to see more full solutions like this?
Chapter 6 Solutions
Bundle: Financial Accounting: Tools for Business Decision Making 8e Binder Ready Version + WileyPLUS Registration Code
- Financial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?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_forwardUse the following information relating to Clover Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.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_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_forwardFinancial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity l. Price-earnings ratio, assuming that the market price was 54.90 per share on May 29, 2016, and 52.81 per share on May 30, 2015 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forward
- Real-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory' h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardInventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?arrow_forwardI need assistance in finding the ratios for the following (see attached sheets). Calculate the following financial ratios for 2016 and 2017 10. Average collection period 11. Inventory turnover ( 2015, inventory = $1,540.9 million) 12. Days' sales in inventoryarrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning