OPTION #1: ANALYTICS IN AUDIT AND TAX (USING EXCEL)

You are required to complete both parts A and B.

SECTION 1:

Part A:

Complete Lab 6-1 Evaluate the Master Data for Interesting Addresses (pp. 248 – 250) in your textbook.

Part B:

Your analysis should be written as an essay and include the following:

• Introduction

• Analysis

  • Headings – Part 1, Part 2, Part 3, Part 4 (i.e., Part 1: Identify the Questions) – headings are shown in the Lab.

• Communicate your findings to the audit committee and then write a brief paragraph of your analysis in layman’s terms. (For example, what were the key findings from your analysis?)

• Conclusion.

Submit your analysis as a Word document and submit any additional requirements noted in the Lab (i.e., Excel files, tables, etc.).

SECTION 2.

Part A: Complete Lab 9-1 State Sales Taxes and Create a Data Visualization (pp. 375 – 379) in your textbook.

Part B:

Your analysis should include the following:

• Introduction

• Analysis

  • Headings – Part 1, Part 2, Part 3 (i.e., Part 1: Identify the Questions) – headings are shown in the Lab.

• Communicate your findings to the tax manager – write a brief paragraph of your analysis in layman’s terms. (For example, what were the key findings from your analysis?)

• Conclusion.