ACT 480 Colorado State University Practical Application of Accounting Lab 6

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.

Submit your analysis as a slide presentation. Submit any additional requirements noted in the Lab (i.e., Excel files, tables, etc.).

Your presentation should be 3-4 slides in length–not including the required cover and references slides or other requirements of the Lab–and conform to the guidelines found in the CSU Global Writing Center (Links to an external site.). Include at least two scholarly references in addition to the course textbook. The CSU Global Library (Links to an external site.) is a good place to find these references.

Requirements: 3-4 pages