Analytics in Audit and Tax (Using Excel) You are required to complete both parts A and B

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. Download Data Files Here (Links to an external site.).

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