Class 16 Ratio Analysis Problem Set 3 Kroger and Sprouts Solution

Accounting supervalu one of the largest grocery retailers in the United states.is

Collins corporation, operates department stores located primarily in the Southwest, Southeast, and Midwest. In its 2019 second-quarter report, the company reported Cost of Goods Sold of $7,900 million, ending inventory for the second quarter of $9,100 million, and ending inventory for the previous quarter of $9,100 million. Determine the amount of merchandise purchases for the second quarter. (Enter your answer in millions.) Merchandise Purchases million

I need help with this study guide question

[The following information applies to the questions displayed below.] The Slumber Store (TSS) is a national wholesaler of beds, mattresses, pillows, and sheets. Key totals from TSS's most recent and forecasted financial statements are presented in the table below. From the income statement Sales Revenue Cost of Goods Sold Gross Profit From the balance sheet Inventories Last Year This Year Next Year $ 560,000 $ 615,000 346,500 405,250 213,500 209,750 $770,000 556,300 213,700 Last Year This Year Next Year $ 88,000 $ 101,808 $ 179,825 Required: 1. Use the financial statement totals to compute the company's actual inventory turnover ratio for this year and its forecasted inventory turnover ratio for next year. Also compute the days-to-sell for this year (actual) and next year (forecasted). Is inventory turnover expected to improve or worsen next year? 2. Use the financial statement totals to compute the company's actual gross profit percentage for this year and its forecasted gross profit…

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).     TargetCorporation   Wal-MartStores, Inc.     Income Statement Data for Year Net sales     $66,400     $414,000   Cost of goods sold     45,000     302,000   Selling and administrative expenses     15,500     81,000   Interest expense     650     1,900   Other income (expense)     (80 )   (400 ) Income tax expense     1,400     7,300   Net income     $ 3,770     $ 21,400                       Balance Sheet Data(End of Year) Current assets     $17,000     $47,000   Noncurrent assets     26,700     120,000   Total assets     $43,700     $167,000   Current liabilities     $11,000     $56,000   Long-term debt     16,800     45,000   Total stockholders’ equity     15,900     66,000   Total liabilities and stockholders’ equity     $43,700     $167,000…

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).     TargetCorporation   Wal-MartStores, Inc.     Income Statement Data for Year Net sales     $66,400     $414,000   Cost of goods sold     45,000     302,000   Selling and administrative expenses     15,500     81,000   Interest expense     650     1,900   Other income (expense)     (80 )   (400 ) Income tax expense     1,400     7,300   Net income     $ 3,770     $ 21,400                       Balance Sheet Data(End of Year) Current assets     $17,000     $47,000   Noncurrent assets     26,700     120,000   Total assets     $43,700     $167,000   Current liabilities     $11,000     $56,000   Long-term debt     16,800     45,000   Total stockholders’ equity     15,900     66,000   Total liabilities and stockholders’ equity     $43,700     $167,000…

Please help me

I need help with this questions

Suppose selected comparative statement data for the giant bookseller Barnes & Noble are as follows. All balance sheet data are as of the end of the fiscal year (in millions).     2022   2021 Net sales   $5,250.5   $5,600.7 Cost of goods sold   3,000.0   3,800.7 Net income   85.3   160.6 Accounts receivable   75.1   100.0 Inventory   1,250.1   1,350.1 Total assets   2,850.0   3,150.0 Total common stockholders’ equity   880.0   1,100.5 Compute the following ratios for 2022. (Round asset turnover to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%) (a)   Profit margin   enter profit margin in percentages rounded to 1 decimal places  % (b)   Asset turnover   enter a number for asset turnover in times rounded to 2 decimal places  times (c)   Return on assets   enter return on assets in percentages rounded to 1 decimal place  % (d)   Return on common stockholders’ equity   enter…

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).     TargetCorporation   Wal-MartStores, Inc.     Income Statement Data for Year Net sales     $65,300     $417,000   Cost of goods sold     45,000     301,000   Selling and administrative expenses     14,000     79,000   Interest expense     660     1,800   Other income (expense)     (85 )   (380 ) Income tax expense     1,500     7,100   Net income     $ 4,055     $ 27,720                       Balance Sheet Data(End of Year) Current assets     $16,000     $50,000   Noncurrent assets     27,400     121,000   Total assets     $43,400     $171,000   Current liabilities     $11,000     $54,000   Long-term debt     17,800     43,000   Total stockholders’ equity     14,600     74,000   Total liabilities and stockholders’ equity     $43,400     $171,000…

Selected hypothetical comparative statement data for the giant bookseller Barnes & Noble are presented here. All balance sheet data are as of the end of the fiscal year (in millions).     2022   2021 Net sales   $5,050.3   $4,900.0 Cost of goods sold   3,300.3   4,201.1 Net income   65.1   100.0 Accounts receivable   75.1   102.2 Inventory   1,150.0   1,250.0 Total assets   2,850.0   3,150.0 Total common stockholders’ equity   900.2   1,140.9 Compute the following ratios for 2022. (Round asset turnover to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%) (a)   Profit margin   enter profit margin in percentages rounded to 1 decimal place  % (b)   Asset turnover   enter asset turnover in times rounded to 2 decimal places  times (c)   Return on assets   enter return on assets in percentages rounded to 1 decimal place  % (d)   Return on common stockholders’ equity   enter return on common…

Selected hypothetical comparative statement data for the giant bookseller Barnes & Noble are presented here. All balance sheet data are as of the end of the fiscal year (in millions).     2022   2021 Net sales   $4,950.2   $5,700.8 Cost of goods sold   3,500.5   3,800.7 Net income   75.2   170.7 Accounts receivable   65.0   103.3 Inventory   1,150.0   1,350.1 Total assets   2,950.1   3,250.1 Total common stockholders’ equity   970.9   1,140.9 Compute the following ratios for 2022. (Round asset turnover to 2 decimal places, e.g 1.83 and all other answers to 1 decimal place, e.g. 1.8 or 2.5%) (a)   Profit margin   enter profit margin in percentages rounded to 1 decimal place  % (b)   Asset turnover   enter asset turnover in times rounded to 2 decimal places  times (c)   Return on assets   enter return on assets in percentages rounded to 1 decimal place  % (d)   Return on common stockholders’ equity   enter return on common…

4

calculate the gross profit and cost of goods sold for MBI for fiscal 2019?

Sprinkle Top Ltd. and Coffee Shop Inc. are both specialty food chains. The two companies reported these figures, in thousands: (Click the icon to view Sprinkle Top's financial statements.) (Click the icon to view Coffee Shop's financial statements.) Requirements 1. Compute gross profit percentage and the rate of inventory turnover for Sprinkle Top and Coffee Shop for 2020. 2. Based on these statistics, which company looks more profitable? Why? What other expense category should we consider in evaluating these two companies? Requirement 1. Compute gross profit percentage and the rate of inventory turnover for Sprinkle Top and Coffee Shop for 2020. (Round gross profit percentage to one decimal place, X.X%, and the inventory turnover rate to one decimal place, X.X.) Company Sprinkle Top Coffee Shop Gross profit percentage % % Inventory turnover rate times times

The following information is taken from the financial statements of Down Home Deli for the last three years. The owner, John Walton is quite pleased to see that his sales are growing steadily. 2018 2017 2016 Sales $ 61,500 $ 50,400 $ 42,000 Cost of goods sold 27,670 21,170 16,800 Operating income 7,530 6,050 4,620 Net income 3,075 4,030 2,940 Instructions: (a) Calculate gross profit margin, profit margin, and profit margin using operating income. (b) Comment on whether the Deli is, in fact, doing better over the three years as John believes.

Dillard’s, Inc. , operates department stores located primarily in the Southwest, Southeast, and Midwest. In its 2013 third-quarter report, the company reported Cost of Goods Sold of $1.0 billion,ending inventory for the third quarter of $1.8 billion, and ending inventory for the previous quarterof $1.5 billion. Determine the amount of merchandise purchases for the third quarter.

Here are comparative financial statement data for Oriole Company and Ivanhoe Company, two competitors. All data are as of December 31, 2027, and December 31, 2026. Oriole Company Ivanhoe Company 2027 2026 2027 2026 Net sales $1,774,000 $531,000 Cost of goods sold 961,508 298,953 Operating expenses 237,716 79,119 Interest expense 7,096 Income tax expense 62,090 3,717 29,736 Current assets 324,900 $314,400 82,400 $79,100 Plant assets (net) 523,200 510,000 139,000 127,800 Current liabilities 65.000 75,200 36,000 30,100 Long-term liabilities 116,200 89,000 29,300 25,500 Common stock, $10 par 491,000 491,000 121,000 121,000 Retained earnings 175,900 169.200 35,100 30,300 (a) Prepare 2027 income statements for both companies, then prepare a vertical analysis for each. (Round percentages to 1 decimal place, e.g. 2.5%.) (b1) Condensed Income Statement For the Year Ended December 31, 2027 Oriole Company Dollars $1,774,000 961,508 Ivanhoe Company Dollars Percent Percent % $531,000 % 298,953…

Compute the gross profit ratio on these financial accounting question

Landseeker's Restaurants reported cost of goods sold of $342 million and accounts payable of $64 million for 2020. In 2019, cost of goods sold was $278 million and accounts payable was $52 million. Landseeker's accounts payable turnover ratio in 2020 is closest to: Multiple Choice O 5.35 5.90 5.34 4.79

Here are comparative financial statement data for Bramble Company and Debra Company, two competitors. All data are as of December 31, 2022, and December 31, 2021.     Bramble Company   Debra Company     2022   2021   2022   2021 Net sales   $1,896,000       $561,000     Cost of goods sold   1,020,048       297,330     Operating expenses   257,856       79,662     Interest expense   7,584       3,927     Income tax expense   54,984       6,171     Current assets   322,500   $310,000   83,500   $78,000 Plant assets (net)   520,800   500,300   139,800   123,000 Current liabilities   64,200   75,600   34,400   29,600 Long-term liabilities   108,400   90,400   28,400   26,000 Common stock, $10 par   498,000   498,000   122,500   122,500 Retained earnings   172,700   146,300   38,000   22,900   Compute the 2022 return on assets and the return on common stockholders’ equity ratios for both companies. (Round answers to 1 decimal…

Here are comparative financial statement data for Bramble Company and Debra Company, two competitors. All data are as of December 31, 2022, and December 31, 2021.     Bramble Company   Debra company     2022   2021   2022   2021 Net sales   $1,896,000       $561,000     Cost of goods sold   1,020,048       297,330     Operating expenses   257,856       79,662     Interest expense   7,584       3,927     Income tax expense   54,984       6,171     Current assets   322,500   $310,000   83,500   $78,000 Plant assets (net)   520,800   500,300   139,800   123,000 Current liabilities   64,200   75,600   34,400   29,600 Long-term liabilities   108,400   90,400   28,400   26,000 Common stock, $10 par   498,000   498,000   122,500   122,500 Retained earnings   172,700   146,300   38,000   22,900 (a)     Prepare a vertical analysis of the 2022 income statement data for Bramble Company and Debra Company. (Round…

Provide solution with calculation