Deere & Company is a global manufacturer and distributor of agricultural, construction, and forestry equipment. Suppose it reported the following information in its 2017 annual report.
(in millions) |
2017 |
2016 |
||
Inventories (LIFO) |
$2,512 | 3,126 | ||
Current assets |
33,200 | |||
Current liabilities |
12,550 | |||
LIFO reserve |
1,449 | |||
Cost of goods sold |
15,063 |
Compute Deere & Company’s inventory turnover for 2017.
Inventory turnover: ________
Compute Deere & Company’s days in inventory for 2017.
Days in inventory: ________ days
Compute Deere & Company’s current ratio using the 2017 data as presented, and then again after adjusting for the LIFO reserve.
Based on data presented: Current ratio- _____:1
After adjusting for LIFO reserve: Current ratio- _____:1
Deere & Company’s inventory turnover for 2017
Inventory turnover ratio = COGS/Average inventory
COGS = $15,063
Average inventory =(Beginning inventory + ending inventory)/2
= ($3,126 + $2,512)/2
= $2,819
Inventory turnover = $15,063/$2,819
= 5.34
Deere & Company’s days in inventory for 2017
= 365/ Inventory turnover ratio
= 365/5.34
= 68.35
Deere & Company’s current ratio using the 2017 data
= Current assets /current liability
= $33,200/$12,550
= 2.65
after adjusting for the LIFO reserve.
= (Current assets + LIFO reserve) /Current liability
= ($33,200 + $1,449)/$12,550
= 2.76
Deere & Company is a global manufacturer and distributor of agricultural, construction, and forestry equipment. Suppose...
Deere & Company is a global manufacturer and distributor of agricultural, construction, and forestry equipment Suppose it reported the following information in its 2022 annual report. in millions) 2022 2021 Inventories (LIFO) $2,397 3,042 Current assets 30,857 Current liabilities 12,753 LIFO reserve 1.367 Cost of goods sold 16,255 Compute Deere's inventory turnover for 2022. Round inventory turnover to 2 decimal places, s. 5.12.) Inventory turnover e Textbook and Media Compute Deere's days in inventory entory to decimal places. e. 50...
*Exercise 9-7 Nordstrom, Inc. operates department stores in numerous states. Suppose selected financial statement data (in millions) for 2017 are presented below. End of Year $ 795 2,035 Beginning of Year $ 72 1,942 Cash and cash equivalents Accounts receivable (net) Inventory Other current assets Total current assets 898 900 303 326 $4,054 $3,217 $1,601 Total current liabilities $2,014 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by...
Nordstrom, Inc. operates department stores in numerous states. Suppose selected financial statement data (in millions) for 2017 are presented below. End of Year Beginning of Year Cash and cash equivalents $ 810 $ 79 Accounts receivable (net) 2,070 1,890 Inventory 880 910 Other current assets 490 401 Total current assets $4,250 $3,280 Total current liabilities $2,040 $1,630 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities...
* Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Stores, Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Wal-Mart Target Corporation Inc. Income Statement Data for Year $66,300 $411,000 44,000 305,000 14,300 77,000 660 1,900 (80) (420) 1,500 7,200 $5,760 $19,480 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and...
12.19 (LO 3) Excel Analyzing ratios (CMA adapted) Baldwin Industries, a manufacturer of construction equipment, is considering the purchase of KayNet Cables, one of its suppliers. Baldwin's board of directors has given preliminary approval for the purchase, and several discussions have taken place between the management of the two companies. In preparation for the discussions, KayNet provided its financial data for the past three years and its financial forecasts for the next three years. Baldwin's controller. Nora Jaynes, has analyzed...
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Wal-Mart Target Income Statement Data for Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,900 45,000 15,000 $419,000 309,000 80,000 1,900 (80) 1,500 (390) 6,700 4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders" equity Total liabilities and stockholders $17,000...
Problem 9-5 Your answer is partially correct. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other Income (expense) Income tax expense Net income Wal-Mart Target Corporation Stores Inc. Income Statement Data for Year $66,900 $417,000 44,000 308,000 14,400 79,000 750 1,800 (95) (400) 1,500 6,600 $ 6,155 $ 21,200 Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year)...
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 Assets Current assets: Cash $ 970,000 $ 1,210,000 Marketable securities 0 300,000 Accounts receivable, net 2,740,000 1,840,000 Inventory 3,610,000...
Help I System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart CTAR Inc. Income Statement Data for Year $66,900 45,000 15,000 700 $419,000 309,000 80,000 1,900 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income (80) (390) 1,500 6,700 $4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term...
euucll.wipuu.com II U Kimmel, Accounting, 6e Help System Announcements Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,700 46,000 14,700 650 (95) 1,400 $ 3,855 $409,000 306,000 76,000 1,800 (420) 7,200 $ 17,580 Current assets Noncurrent assets Total assets Current liabilities Long-term...