! Required information Tableau Dashboard Activity 17-02: Projecting the TCJA Impact on the State Tax Deduction (Static) Projecting the TCJA Impact on the State Tax Deduction The Tax Cuts and Jobs Act (TCJA) made significant changes to several areas of the tax code including the limitation placed on the State Tax Deduction. On its website, the IRS publishes data detailing the itemized deductions claimed for a given year by state. The most recently published year available is 2017, prior to the enactment of the TCJA. To project the impact of the TCJA on the State Tax Deduction, you have created the following Tableau visualization, which uses the following assumptions and calculations: Average Tax Rate: divides Income Tax Before Credits by Taxable income Amount State Tax Deduction: sums State and local income taxes amount, Real estate taxes amount, and Personal property taxes amount 1. The State and local general sales tax amount was excluded from this analysis State Tax Deduction * ATR: multiplies the State Tax Deduction by the Average Tax Rate Impact: divides the State Tax Deduction * ATR by the Income Tax Before Credits Ranked Impact: orders the States from most impacted to least impacted (1-51) Mouse over the visualization to reveal specific amounts for use in answering the following questions. Adjust the sliders on the visual to determine proper responses. State TCJA Impact on State Tax Deduction (All) State TCJA Impact on State Tax Deduction (All) Data Visualization Projecting the TCJA Impact on the State Tax Deduction - Part 3 (Static) Select your jurisdiction. Discuss briefly the figures presented in the visual. Is the presented analysis consistent with your expectations? Why or why no Essay Toolbar navigation. BI V S = =