The following items were taken from the financial statements of Kramer Manufacturing, Inc., over a three-year period: Item Net Sales Cost of Goods Sold Gross Profit -醉融除 2022 $226,000 150,000 $76.000 2021 $212,000 140,000 $ 72,000 2020 $200,000 125,000 $ 75,000 Instructions Using horizontal analysis and 2020 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Explain whether the trends are favorable or unfavorable for each item.

The following items were taken from the financial statements of Kramer Manufacturing, Inc., over a three-year period: Item Net Sales Cost of Goods Sold Gross Profit -醉融除 2022 $226,000 150,000 $76.000 2021 $212,000 140,000 $ 72,000 2020 $200,000 125,000 $ 75,000 Instructions Using horizontal analysis and 2020 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Explain whether the trends are favorable or unfavorable for each item.

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 83E

See similar textbooks

Similar questions

Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.
Examine the selected data over the 5-year period as shown in the table below for Dumbledore Ltd. Item Sales Cost of sales EBIT Interest NPAT Current assets Total assets current liabilities Total liabilities Equity Gross margin Interest coverage Current ratio 2021 $m 286.41 180.03 51.18 37.07 35.13 43.85 226.18 55.99 98.99 127.19 0.37 1.38 0.78 Year 2020 $m 280.80 166.69 51.08 33.70 35.10 43.20 221.75 53.58 91.66 130.09 0.41 1.52 0.81 2019 $m 275.29 154.35 50.98 30.64 35.06 42.56 217.40 51.27 84.87 132.53 0.44 1.66 0.89 2018 $m 269.89 142.91 50.88 27.85 35.03 41.93 213.13 49.06 78.58 134.56 0.47 1.83 U.OJ 2017 $m 264.60 134.19 49.88 25.32 34.51 41.31 206.93 47.40 74.48 132.44 0.49 1.97 0.87 2016 $m 252.00 126.00 48.90 24.00 34.00 40.70 200.90 45.80 70.60 130.30 0.50 2.04 0.89
The following items were taken from the financial statements of Kramer Manufacturing, Inc., over a 3-year period: Item 2021 2020 2019 Net sales $226,000 $212,000 $200,000 Cost of goods sold 150,000 140,000 125,000 Gross profit $ 76,000 $ 72,000 $ 75,000 Instructions Using horizontal analysis and 2019 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Item 2021 2020 2019 Net sales % % 100% Cost of goods sold % % 100% Gross profit % % 100% Explain whether the trends are favorable or unfavorable for each…
Use the following selected information from Corolla to determine the Year 1 and Year 2 trend percentages for net sales using Year 1 as the base. Year 2 Year 1 Net sales $ 281,200 $ 232,400 Cost of goods sold 150,900 130,590 Operating expenses 54,240 52,240 Net earnings 29,020 20,820
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
! Required information Use the following information to determine the prior year and current year trend percents for net sales using the prior year as the base year. ($ thousands) Net sales Cost of goods sold Current Year Prior Year $ 802,971 394,306 $ 454,365 135,325 Current Year: Prior Year: Determine the Prior Year and Current Year common-size percents for cost of goods sold using net sales as the base. (Enter the answers in thousands of dollars.) Common-Size Percent for Cost of Goods Sold using Net Sales as the base: Denominator: Numerator: Analysis period cost of goods sold $ $ Check my work 394,306 / 135,325 / $ 454,365 Common-size percents 0 % 29.78 %
Compute trend percent for the following accounts using 2018 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percent appears to be favorable or unfavorable. 2022 2021 2020 2019 2018 Sales $282,880 $270,800 $252,600 $234,560 $150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000
Excerpts from Dowling Company's December 31, 2021 and 2020, financial statements and key ratios are presented below (all numbers are in millions): 2021 2020 Accounts receivable (net) $ 20 $ 16 Net sales $ 115 100 Cost of goods sold $ 60 55 Net income $ 20 17 Inventory turnover 5.22 Return on assets 10.3 % Equity multiplier 2.36 Dowling's average total assets for 2021 is (rounded): Multiple Choice 32. 210. 115. 194.
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $493,000 $419,000 Cost of goods sold 281,010 213,690 83,810 Selling expenses 83,800 Administrative expenses 93,670 71,230 Income tax expense 14,790 20,950 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amour nounts as positive numbers. Innovation Quarter Inc Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $493,000 $419,000 281,010 213,690 Cost of goods sold Selling expenses 83,810 83,800 96 96 93,670 71,230 Administrative expenses
Current Attempt in Progress Operating data for Grouper Corp. are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $840,000 540,120 133,560 57,120 31,920 77,280 2021 $610,000 405,650 80,520 46,970 26,840 50,020 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Selected ratios of Company X are shown below: Inventory turnover Days' sales uncollected Days' purchases in accounts payable Total asset turnover Equity ratio Times interest earned 2021 5.3 32.4 21.0 2.6 0.8 N.A. 2020 7.1 18.3 20.0 2.5 0.8 N.A. Using the financial ratios provided, analyse the performance of Company X in 2021 compared to the previous year.
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…