Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started