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

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 da...

Full description

Saved in:
Bibliographic Details
Published in:Issues in accounting education 2021-05, Vol.36 (2), p.129-139, Article 129
Main Authors: Laplante, Stacie K., Vernon, Mary E.
Format: Article
Language:English
Subjects:
Data analysis
Income taxes
Liabilities
Spreadsheets
Students
Tax audits
Tax legislation
Tax rates
Taxation
Working papers
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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, 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; analyze and visualize data using Tableau; and access and use the IRS's SOI database. JEL Classification: H29; D89; A22; A23.
ISSN:1558-7983
0739-3172
1558-7983
DOI:10.2308/issues-2020-007