Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the prior chapters Applying Tableaus, you examined two ( hypothetical ) publicly traded companies, GPS Corporation and Tru, Incorporated, as to their pattern of

In the prior chapters Applying Tableaus, you examined two (hypothetical) publicly traded companies, GPS Corporation and Tru, Incorporated, 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.Tableau Instructions:For this case, you will create calculations to determine the effective tax rate so you can compare and contrast the effect of the 2017 Tax Act on the two companies.Follow these steps to create the charts youll use for this case:Download the Excel file GPS_Tru_Financials.Open Tableau and connect to the Excel file.Click on the Sheet 1 tab, at the bottom of the canvas, to the right of the Data Source at the bottom of the screen. Drag Company and Year to the Columns shelf. Change Year to discrete by right-clicking and selecting Discrete.Drag Provision for income tax and Deferred income taxes under Measure Names into the Rows shelf.Add labels to the bars by clicking on "Label" under the Marks card and clicking the box "Show mark labels." Format the labels according to preference and, if desired, edit the color of the years on the "Marks card" by dragging "Year" from tables (not columns) on to the Color Marks card.Change the title of the sheet to be "Provision for Income Taxes and Deferred Tax Liability Trend 20122021" by double-clicking the tab at the bottom of the page and typing the new title.Click on the New Worksheet tab on the lower left (Sheet 2 should open) and follow the procedure outlined above for the company and year. Drag "Provision for income taxes" and "Income from continuing operations" under Measure Names into the Rows shelf. Change each to discrete by right-clicking and selecting "Discrete."Create a calculated field by clicking the "Analysis" tab at the top of the screen and selecting "Create Calculated Field." Name the calculation "Effective Tax Rate." In the Calculation Editor window, drag "Provision for income taxes" and type a division sign. Then type "(", drag "Income from continuing operations," type an addition sign, drag "Provision for income taxes," and type ")" from the Rows shelf. Make sure the calculation is valid and click OK.Drag the newly created "Effective Tax Rate" to the Rows shelf. Click on the "Show Me" and select "side-by-side bars." Add labels to the bars by clicking on "Label" under the Marks card and clicking the box "Show mark labels." Format the labels according to preference and edit the color on the Marks card if desired. If you want to see a line chart instead of the bars, click on Automatic under the Marks card and select Line.Change the marks to percentages by right-clicking on AGG(Effective Tax Rate) in the Rows Shelf and clicking Format. When the format bar appears on the left, choose Pane. Under default, format the number as Percentage with 2 decimal places.Change the title of the sheet to be "Effect of the Tax Cuts and Jobs Act of 2017" by double-clicking the tab at the bottom of the page and typing the new title.Format all other labels according to preference.Save your work.Required:Based upon your output, answer the following questions:Is Tru, Incorporateds provision for income tax (a) higher, (b) lower, or (c) roughly the same over the period 2018-2021 than in previous years?Did Tru, Incorporateds deferred tax liability appear to benefit from the Tax Act?What is the effective tax rate for GPS in 2017?What is the effective tax rate for GPS in 2018?
\table[[\table[[ in 000s
\table[[\table[[ in 000s
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Stacey Whitecotton, Robert Libby, Fred Phillips

2nd edition

9780077493677, 78025516, 77493672, 9780077826482, 978-0078025518

Students also viewed these Accounting questions

Question

List one of the facultys publications in APA style.

Answered: 1 week ago