Score Part 4:Trend analysis ( 27 %) 1. Please conduct a trend analysis for Guangwai Company using its income information for the years 2016 through 2020 in the table given. (18%) Item Sales 2020 Year 2019 2018 2017 2016 $1, 152, 000 $1, 292, 200 $1, 164, 800 $957, 000 $1,056,000 Cost of goods sold $820, 800 $910,000 $819,000 $653, 400 $729,600 Gross margin $331, 200 $382, 200 $345,800 $303, 600 $326,400 Item Sales Cost of goods sold Gross margin Year 2020 2019 2018 2017 2016 100% 100% 100% 2. Please draw a line graph to illustrate the results of trend analysis. Please use different lines to differentiate sales, cost of goods sold and gross margin in the line graph. (9%)