Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 2021 2020 2018 $ $ $ 2019 $ 357,357 261,800 330,822 220,581 178,305 129,482 670,044 446,696 32,296 26,042 24,372 15, 289 Sales Cost of goods sold Accounts receivable 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. Trend Percent for Net Sales: I Denominator: 1 1 1 1 I Numerator: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: I 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? / T / 1 Trend Percent for Accounts Receivable: Numerator: I Denominator: / 1 / 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? E = = = = = = = = 2017 $ 192,500 94, 325 13, 148 = Trend percent % % % % % Trend percent % % % % % Trend percent % % % % %

Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 2021 2020 2018 $ $ $ 2019 $ 357,357 261,800 330,822 220,581 178,305 129,482 670,044 446,696 32,296 26,042 24,372 15, 289 Sales Cost of goods sold Accounts receivable 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. Trend Percent for Net Sales: I Denominator: 1 1 1 1 I Numerator: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: I 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? / T / 1 Trend Percent for Accounts Receivable: Numerator: I Denominator: / 1 / 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? E = = = = = = = = 2017 $ 192,500 94, 325 13, 148 = Trend percent % % % % % Trend percent % % % % % Trend percent % % % % %

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

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.
Compute trend percents for the following accounts using 2015 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.
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
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. Sales $ 666,761 $ 432,962 $ 344,990 $ 249,090 $ 180,500 Cost of goods sold 329,263 213,901 172,445 124,054 88,445 Accounts receivable 32,138 25,242 23,632 14,547 12,328
Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: Numerator: 2024 $ 628,449 322,959 30,417 Numerator: 1 ( ( 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? Trend Percent for Net Sales: 2023 $ 408,084 209,773 23,750 } ( } 2022 2021 $ 334,495 $ 232, 288 173,642 22,846 Denominator: Trend Percent for Cost of Goods Sold: S Denominator: } } 1 1 1 2024: 2023: 2022: 2021: 2020: Is the trend percent for Cost of Goods Sold favourable or unfavourable? 1 Trend Percent for Accounts Receivable: Denominator: 1 2024: 1 2023: 1 2022: } 2021: 1 2020: 1 Is the trend percent for Accounts Receivable favourable or unfavourable? 119,917 13,589 || II II II = 11 "I = Trend percent = 111111 = = = 11 = = = 2020 $ 170,800 87,108 11,683 Trend percent…
Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 754,236 372,126 36,731 Numerator: 1 2023 $ 499,494 246,502 29,121 Trend Percent for Net Sales: 1 1 1 1 1 1 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2022 $394,857 196,780 27,127 Prev Denominator: Trend Percent for Cost of Goods Sold: 1 Denominator: 5 of 8 2021 $ 265,005 131,752 15,529 = Next > 2020 $ 196,300 96,187 13,407 Trend percent % % % % %
Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whe situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 564,662 296,074 27,273 Numerator: 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2023 $364,298 191,135 21,275 1 1 1 Trend Percent for Net Sales: 1 $ 1 1 2022 293,789 156,170. 20,095 Denominator: Trend Percent for Cost of Goods Sold: Denominator: 2024: 2023: 2022: 2021: 2020: is the trend percent for Cost of Goods Sold favourable or unfavourable? 2021 2020 $ 212,122 $ 158,300 111,503 12,430 = 82,316 10,828 Trend percent Trend percent % de 2 % *** % % % % % % % %
Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. 2024 2023 Sales Cost of goods sold Accounts receivable $ 553,119 290,122 26,882 $ 363,894 190,775 21,215 2022 $ 292,284 155,088 20,021 2021 $ 210,276 110,844 12,322 2020 $ 159,300 82,836 10,928 2024: 2023: 2022: 2021: 2020: Numerator: Trend Percent for Net Sales: 1 Is the trend percent for Net Sales favourable or unfavourable? 2024: 2023: 2022: 2021: 2020: Denominator: = Trend percent 0 % 0% 0% 0% 0 % Trend Percent for Cost of Goods Sold: Numerator: Denominator: Is the trend percent for Cost of Goods Sold favourable or unfavourable? = Trend percent 0% 0% 0% 0% 0%
Required 1. Compute each year’s current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as the base year. Round percents to two decimals. Analysis Component 4. Comment on any significant relations revealed by the ratios and percents computed.
2021 Sales Cost of goods sold Accounts receivable $ 282,880 128,200 18,100 2020 $ 270,800 122,080 17,300 2019 $ 252,600 115,280 16,400 2018 $ 234,560 106,440 15,200 2017 $ 150,000 67,000 9,000 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. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: 1 = Trend percent 1 = % = % 1 Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: = % = % Trend percent = % = % 2021: 2020: 2019: 1 1 = 2018: = 2017: = Is the trend percent for Cost of Goods Sold favorable or unfavorable?
For calculating trend percentages any year is selected as a. Current year b. Previous year c. Base year d. None of these
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (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 2020 2019 $ 442,035 266,105 175,930 62,769 39,783 $ 338,635 212,324 126,311 46,732 29,800 76,532 49,779 10, 205 Sales $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 150,400 84,600 31,020 19,505 50,525 34,075 102,552 73,378 13,648 Income tax expense 6,917 Net income $ 59,730 $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets $ 55,578 $ 37,199 $ 49,726 4,570 56,095 Current assets Long-term investments Plant assets, net 900 104,820 95,143 Total assets $ 160,398 $ 133,242 $ 110,391 Liabilities and Equity $ 19,318 $ 23,418 68,000 8,500 60, 480 Current liabilities $ 19,853 Common…