Question: Using the financial statement file and the two data files for payroll, perform some analytical tests. You will need to perform some analytical test on

Using the financial statement file and the two data files for payroll, perform some analytical tests.

  • You will need to perform some analytical test on the financial statements using Excel.This may be a horizontal and/or vertical analysis, ratios, etc.
  • You will then need to perform some analytical tests on payroll files using IDEA that you think may be necessary.Remember there are tutorial videos on the IDEA website to assist you.
  • Write a 1-2 sentence explanation for each analysis you are performing and printscreen your results along with the history log when you have completed the analysis in IDEA to turn in this week.

please refer to https://www.homeworkmarket.com/questions/writing-project-auditing for the 3 documents needed to complete the question.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

The owner of a small snack food and potato chip manufacturer, California Crunch Company, has asked you to investigate a possible issue with the company's payroll. They have provided you with this...

Q:

California Crunch Company Statements of Income For the year ended December 31, 2018 2017 Net Sales (less returns & allowances) $ 8,353,542 $ 7,998,832 4% Cost of Goods Sold 3,745,623 3,621,532 3%...

Q:

Part 2: The owner of a small snack food and potato chip manufacturer, California Crunch Company, has asked you to investigate a possible issue with the company's payroll. They have provided you with...

Q:

Requirements: Writing, using software, and interpreting results is a large part of your learning experience. These assignments are designed to improve your use of technology and communication skills....

Q:

Using the financial statement file and the data file for travel expenses perform some analytical tests. You will need to perform some analytical test on the financial statements using Excel. This may...

Q:

This project is split into four (4) parts with one (1) part due each week of the course. Based on your readings, use of technology, research of literature, and other sources do the following: Part...

Q:

Part 2 - Using the financial statement file and the payroll data file perform some analytical tests. You will need to develop some analytical tests using the Income Statement data using Excel. It can...

Q:

Using the financial statements file and the payroll data file perform some analytical tests. You will need to develop some analytical tests using the Income Statement data using Excel. It can be...

Q:

1. 1. An auditor makes separate compliance and substantive tests in the client's accounts payable area, which appears to have good internal control. If the auditor uses statistical sampling for both...

Q:

Problem Statement The retail marketing department of a bank is planning to develop campaigns that more effectively target potential loan customers. The goal is to increase the conversion rate with...

Q:

In reference to Applied Example 7. 3 on page 316: a. Explain why the numerical values on this table do not form a sampling distribution. b. Explain how this repeated gathering of data differs from...

Q:

Community Bank has a loan receivable from IMS Chocolates. IMS is six months late in making payments to the bank, and Jan French, a Community Bank vice president, is assisting IMS to restructure its...

Q:

3. True or False. The extensional meaning of a term consists of the members of the class denoted by the term.

Q:

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....