New tax accountants are expected to possess strong technical tax and data analytic skills. This case provides an opportunity to improve students’ corporate tax and accounting for income taxes knowledge and experience with professional tax workpapers. It also provides exposure to two powerful data analytic platforms, Tableau and Excel. Students must complete a set of tax workpapers including a Schedule M-3 reconciliation. Students begin to view tax through an analytical mindset, gaining familiarity with descriptive data for tax analyses. This case helps students calculate GAAP and cash effective tax rates, taxable income, and temporary and permanent book-tax differences and formulate a professional written communication. Students also complete tax workpapers; benchmark tax data across time and industry peers; clean, format, and combine data using Excel and Tableau; and analyze and visualize data using Tableau.
Skip Nav Destination
Close
Article navigation
Research Article|
January 22 2021
Incorporating Data Analytics in a Technical Tax Setting: A Case Using Excel and Tableau to Examine a Firm’s Schedule M-3 and Tax Risk
Stacie K. Laplante
;
Stacie K. Laplante
University of Wisconsin-Madison
975 University Avenue
UNITED STATES
Madison
WI
53706
608-262-8773
2146746668
Search for other works by this author on:
Mary E. Vernon
Mary E. Vernon
University of Wisconsin-Madison
Search for other works by this author on:
Issues in Accounting Education (2021)
Article history
Received:
January 31 2020
Revision Received:
July 28 2020
Revision Received:
November 03 2020
Accepted:
November 17 2020
Citation
Stacie K. Laplante, Mary E. Vernon; Incorporating Data Analytics in a Technical Tax Setting: A Case Using Excel and Tableau to Examine a Firm’s Schedule M-3 and Tax Risk. Issues in Accounting Education 2021; doi: https://doi.org/10.2308/ISSUES-2020-007
Download citation file:
Close
Sign in
Don't already have an account? Register
Client Account
You could not be signed in. Please check your email address / username and password and try again.
Sign in via your Institution
Sign in via your Institution
13
Views
0
Citations