Data Analytics Case Net Income and Cash Flows LO1-2 This case introduces you to data analysis in a very basic way by allowing you to quickly extract, visualize, and compare financial data over a span of ten years for two (hypothetical) publicly traded companies: Discount Goods and Big Store. For this case, assume you are an analyst conducting introductory research into the relative merits of investing in these companies. For this initial look, you want to visualize the pattern of net income and of net operating cash flows over the past ten years for the two companies. Required: Use Tableau to create charts depicting (a) the trend of net income and (b) the trend of net operating cash flows over the period 2012-2021 for each of the two companies. Based upon what you find, answer the following questions: 1. One of the companies reported a huge loss on its income statement related to a foreign expatriation of properties in one of the years. Which company, which year, and what was the amount of net income or net loss that resulted for that year? 2. What was the amount of net operating cash flow in the year of the loss for the company reporting the loss? 3. Which company reported the largest percentage change in net erating cash flows between 2012 and 2021, and what was the percentage change for that company (rounded to nearest whole percentage point)? 4. Which company reported the largest percentage change in net income between 2012 and 2021, and what was the percentage change for that company (rounded to nearest whole percentage point)? Operating Cash Flows : Discount Goods vs. Big Store Store Big Store Discount Goods 31,530 30K 28,978 28,564 27,389 26,843 26,249 26,480 27,617 26,138 25,591 25K 24,255 23,643 24,160 23,667 24,151 23,257 23,427 23,316 21,854 20K 19,729 Value Store: Big Store 2018: 23,643 15K 10K SK OK Net Income /(Loss) : Discount Goods vs. Big Store Store Big Store Discount Goods 29,893 30K 29,111 26,658 26,036 25,956 25K 24,329 22,116 20,866 20K 17,099 16,695 18,282 17,520 17,756 16,387 16,993 14,883 15,080 15K 14,293 13,708 10K Value SK OK -5K -10K -15K -14,542 2012 2013 2014 2015 2016 2017 2018 2019 2016 Data Analytics Case Net Income and Cash Flows LO1-2 This case introduces you to data analysis in a very basic way by allowing you to quickly extract, visualize, and compare financial data over a span of ten years for two (hypothetical) publicly traded companies: Discount Goods and Big Store. For this case, assume you are an analyst conducting introductory research into the relative merits of investing in these companies. For this initial look, you want to visualize the pattern of net income and of net operating cash flows over the past ten years for the two companies. Required: Use Tableau to create charts depicting (a) the trend of net income and (b) the trend of net operating cash flows over the period 2012-2021 for each of the two companies. Based upon what you find, answer the following questions: 1. One of the companies reported a huge loss on its income statement related to a foreign expatriation of properties in one of the years. Which company, which year, and what was the amount of net income or net loss that resulted for that year? 2. What was the amount of net operating cash flow in the year of the loss for the company reporting the loss? 3. Which company reported the largest percentage change in net erating cash flows between 2012 and 2021, and what was the percentage change for that company (rounded to nearest whole percentage point)? 4. Which company reported the largest percentage change in net income between 2012 and 2021, and what was the percentage change for that company (rounded to nearest whole percentage point)? Operating Cash Flows : Discount Goods vs. Big Store Store Big Store Discount Goods 31,530 30K 28,978 28,564 27,389 26,843 26,249 26,480 27,617 26,138 25,591 25K 24,255 23,643 24,160 23,667 24,151 23,257 23,427 23,316 21,854 20K 19,729 Value Store: Big Store 2018: 23,643 15K 10K SK OK Net Income /(Loss) : Discount Goods vs. Big Store Store Big Store Discount Goods 29,893 30K 29,111 26,658 26,036 25,956 25K 24,329 22,116 20,866 20K 17,099 16,695 18,282 17,520 17,756 16,387 16,993 14,883 15,080 15K 14,293 13,708 10K Value SK OK -5K -10K -15K -14,542 2012 2013 2014 2015 2016 2017 2018 2019 2016