$ 100,000 $ 90,000 $80,000 $70,000 $ 60,000 $ 50,000 $ 40,000 $30,000 Total Revenues Over time - JKotlow $20,000 $10,000 SO Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, 2018 2019 Feb. 01, Jan. 30, 2021 2020 #1 Total Revenues Over Time $25,000 $20,000 $15,000 $10,000 $5,000 Change in Revenue over time JKotlow Plot Area $ (5,000) $ (10,000) Jan. 28, 2017 Feb. 03, 2018 Feb. 02, 2019 Feb. 01, 2020 Jan. 30, 2021 #2 Change In Revenue Over Time $100,000 $90,000 $80,000 Percentage change In Revenue JKotlow $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 SO Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb 01, n. 30, 2021 2018 2019 2020 Plot Area #3 Percentage change in Revenue Cost of sales JKotlow $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 50 Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb. 01, Jan. 30, 2021 2018 2019 2020 #4 Cost of sales $100,000 $90,000 $ 80,000 $70,000 $ 60,000 $ 50,000 $40,000 $30,000 Gross Margin JKotlow $20,000 $10,000 $0 Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb. 01, n. 30, 2021 2018 2019 2020 Horizontal (Category) Axis #5 Gross Margin Net earnings JKotlow $100,000 $90,000 $ 80,000 $70,000 $ 60,000 $50,000 $40,000 $30,000 $ 20,000 $ 10,000 $0 Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb. 01, Jan. 30, 2021 2018 2019 2020 #6 Net earnings $100,000 $90,000 Change in Revenue over time JKotlow $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 50 Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb. 01, Chart Area 2018 2019 2020 #7 Change in revenue over time Prcentage change in Revenue JKotlow $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 50 Jan. 30, 2016 Jan. 28, 2017 Feb. 03, Feb. 02, Feb. 01, Jan. 30, 2021 2018 2019 2020 #8 Percentage change in revenue 15 et's Revernis Margin and a) Briefly explain how Target's Revenues, Gross Margin, and Net Earnings have changed over time by looking at your charts (#1, 5, 6) arts #1. Do you find this comparison Compare Charts #1, 2 and 3. Do you find this comparison helpful? What 'story' can you tell? 5. Do you find this comparison c) Now, compare #1, 4, and 5. Do you find this comparison helpful? What 'story' can you tell now? Do you have anyon ideas or would you be interested in doing further analysis on any particular line item to see if it is driving the movement of your charted lines? #2-3 charts against 7-8 charts tons d) Now, compare #2-3 charts against #7-8 charts (same Revenue information, however you have manipulated the data using a different horizontal analysis methods). d1) If you were in the Marketing department, trying to convince your boss to give you additional funds for a new Ad campaign, which version of horizontal analysis might help you tell your story better? Tryms to d2) If you were an Investment Banker, trying to convince your client to buy stock in this company, which version of horizontal analysis might help you tell your story better? Efor your work you must