ANALYTICS IN AUDIT AND TAX (USING EXCEL)
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.
SAMPLE ASSIGNMENT