Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 Sales Cost of goods sold Accounts receivable 2021 $ 579,696 292,398 28, 173 2020 $ 381,379 192, 290 22,234 2019 $ 383,888 155,094 20,786 2018 $ 207,432 105,366 12,156 2017 $ 154,800 77,400 10,573 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whet situation as revealed by the trend percents appears to be favorable or unfavorable. Trend Percent for Net Sales: Numerator: Denominator: Base year net sales 2021: 1 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? Trend percent 0 % 0 % 0 % 0 % 0 % Favorable Trend Percent for Cost of Goods Sold: Numerator: Denominator: 11 Trend percent 0 % 11 2021: 2020: 0 % 2019: 111111 0 % 2018: 0 % 0 % 0 % 0 % 2019: 2018: / 2017: Is the trend percent for Net Sales favorable or unfavorable? Favorable Trend Percent for Cost of Goods Sold: Denominator Numerator: 2021: Trend percent 0 % 0 % 0 % 0 % 2020: ENLICIENIE 2019: 0 % 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? Unfavorable Trend Percent for Accounts Receivable: Denominator: Numerator: 11 E 2021: 2020: 2019: 2018: 2017: 7 Is the trend percent for Accounts Receivable favorable or unfavorable? Trend percent 0 % 0 % 0 % 0 % 0 % Unfavorable IL TO QS 13-4 (Algo) Horizontal analysis LO P1 Compute the annual dollar changes and percent changes for each of the following accounts (Decreases should be indicated with a minus sign. Round percent change to one decimal place.) Short-term investments Accounts receivable Notes payable Current Year $ 376,765 99,717 Prior Year $ 235,858 103,183 90,168 Percent Change = & Answer is not complete. Horizontal Analysis Calculation of Percent Change Numerator Denominator Current year minus base year Base year amount Current Year Prior Year Dollar Change Percent Change S 376 765 5 235 858 IS 140,907 620 99,717 103.183 (3.466) 0 90.168 (90,168) Short-term Investments Accounts receivable Notes payable % % %