Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tableau Dashboard Activity 02-1: Individual Tax Return IRS Examination Coverage (Static) Skip to question Individual Tax Return IRS Examination Coverage There are several contributing factors

Tableau Dashboard Activity 02-1: Individual Tax Return IRS Examination Coverage (Static)

Skip to question

Individual Tax Return IRS Examination Coverage

There are several contributing factors which may ultimately trigger an audit of an Individual income tax return by the Internal Revenue Service ("IRS"). Each year, the IRS publishes a Data Book reporting tax statistics and figures on revenue collection, refunds, tax law enforcement, taxpayer assistance, and more. The Data Book includes information about returns selected for audit. The following Tableau visualization is a scatter plot produced using the 2019 Internal Revenue Service Data Book Publication 55B individual tax return data from Table 17b: Examination Coverage: Recommended and Average Recommended Additional Tax After Examination, by Type and Size of Return (source: https://www.irs.gov/pub/irs-pdf/p55b.pdf). Additionally, prior year data has been included for reference (source: 2018 Internal Revenue Service Data Book Publication 55B individual tax return data from Table 9a: Examination Coverage: Recommended and Average Recommended Additional Tax After Examination, by Type and Size of Return https://www.irs.gov/pub/irs-prior/p55b--2019.pdf).

The visualization is constructed as follows:

  • Each plotted ring represents one of thirteen specific categories of individual income tax return:

    Returns with total positive income under $200,000:

    Nonbusiness returns without Earned Income Tax Credit:

    (1) Without Schedules C, E, F, or Form 2106

    (2) With Schedule E or Form 2106

    Business returns without Earned Income Tax Credit:

    Nonfarm business returns by size of total gross receipts:

    (3) Under $25,000

    (4) $25,000 under $100,000

    (5) $100,000 under $200,000

    (6) $200,000 or more

    (7) Farm returns

    Business and nonbusiness returns with Earned Income Tax Credit by size of total gross receipts:

    (8) Under $25,000

    (9) $25,000 or more

    Returns with total positive income of at least $200,000 and under $1,000,000:

    (10) Nonbusiness returns

    (11) Business returns

    (12) Returns with total positive income of $1,000,000 or more

    (13) International returns

  • The ring size is based on the total number of returns examined for the category.
  • The ring shading is based on the total recommended additional tax (in thousands) upon examination for the category.
  • The X axis plots the total number of returns filed in the category.
  • The Y axis plots the percentage of returns examined in the category.

With the 2018 selected in the Year of Data dropdown box at the top, mouse-over the visualization to reveal specific amounts for use in answering the following questions.

Individual Tax Return IRS Examination Coverage - Part 1 (Static)

Required:

  1. Which category had the greatest number of returns filed but the least percentage of returns examined?
  2. Which category had the highest percentage of returns examined?
  3. Which category had the second greatest amount of recommended additional tax upon examination?
  4. What percentage of Category 7, Farm Returns, were reviewed?
  5. What is the differing tax return component between Category 3 and Category 8?
  6. Based on the visualization, does filing a tax return with an Earned Income Tax Credit and a Schedule C with under $25,000 of total gross receipts increase the likelihood of an examination?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Essential Controller An Introduction To What Every Financial Manager Must Know

Authors: Steven M. Bragg

2nd Edition

1118169972, 9781118169971

More Books

Students also viewed these Accounting questions

Question

Identify and explain at least three types of earnings management.

Answered: 1 week ago

Question

How do childhood experiences affect self-esteem?

Answered: 1 week ago