Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your firm has been contracted to perform the fraud examination. The attorney for Southern Appalachian Insurance Company added an additional assignment: analyze the bank transactions

Your firm has been contracted to perform the fraud examination. The attorney for Southern Appalachian Insurance Company added an additional assignment: analyze the bank transactions from September 1, 2015, through February 29, 2016. Access the Study section 4-2, How to Use Excel Pivot to Analyze and Summarize Data, and download the Excel Data sheet provided before conducting the specific requirements of this case. The results of your assignment will be used as a summary schedule in your report, a schedule attached to the report, and possibly a courtroom audiovisual should you be called to testify as an expert witness. Your assignment (in general) is, as follows: Assign categories (using the dropdown choices provided) to the disbursement transactions to assist in summarizing transactions. Insert a PivotTable in a new worksheet and obtain the total quantities (count) of transactions and total dollars (sum) for each category. Make at least three new PivotTables (Exercises 1, 2, and 3): Deposits (Amount Deposit and Deposit Category) Check and Debit Card Disbursements (Check Category, Payee per Check/Debit, Amount Check/Debit) (unscrubbed) Check and Debit Card Disbursements (Check Category, Payee per Check/Debit, Amount Check/Debit) (scrubbed) Sort the total dollars per category in descending order. Enhance the scrubbed PivotTables for report and courtroom presentation purposes: Add an appropriate title and use proper "$" signs, decimal format, etc. Checklist: Make sure to ad

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Financial and Managerial Accounting

Authors: Rich Jones, Mowen, Hansen, Heitger

1st Edition

9780538751292, 324787359, 538751290, 978-0324787351

Students also viewed these Accounting questions