Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. If you haven’t completed any of the prior data analytics cases, follow the instructions listed in the Chapter 1 Data Analytics case to get set up. You will need to watch the videos referred to in the Chapters 1 - 3 Data Analytics cases. No additional videos are required for this case. All short training videos can be found here: https:// www.tableau.com/learn/training#getting-started. 

In the Data Analytics Cases in the previous chapter, you used Tableau to examine a data set and create charts to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. as to their pattern of leasing facilities, their transition to the new lease accounting standard in 2019, and the effect of that transition on debt covenants. In this case, you examine the effect of the Tax Cuts and Jobs Act of 2017 on these companies’ operations and financial position.

Required: 

For each of the two companies in the ten-year period, 2012-2021, use Tableau to calculate and display the trends for (a) the provision for income taxes (b) the deferred tax liability, and (c) effective tax rate. Based upon what you find, answer the following questions: 

1. Is Tru, Inc.’s provision for income tax (a) higher, (b) lower, or (c) roughly the same over the period 2018-2021 than in previous years? 

2. Did Tru, Inc.’s deferred tax liability appear to benefit from the Tax Act? 

3. What is the effective tax rate for GPS in 2017 (calculated as the provision for income tax divided by income from continuing operations plus provision for income tax)? 

4. What is the effective tax rate for GPS in 2018 (calculated as the provision for income tax divided by income from continuing operations plus provision for income tax)?