Access Case 5 and 6 from the Fraud Examination Casebook.
Access the LinkedIn Learning activities located in the reading area.
Access the background information.
Then read the assignment information, instructions, and address the checklist items for submission.
ANDERSON INTERNAL MEDICINE (CONSPIRACY AND LOAN FRAUD)
You find suspicious the $36,000.00 check deposited into the AIM checking account on December 30, 2015. It was made payable to “Cash” and drawn on Greg Larsen’s account at Waleska Bank. Why was the $36,000.00 check deposited into AIM, and why were Larsen Convenience Store disbursements made using AIM checks? Write up the fraud examination analysis for an addendum to the original fraud examination reports for both Larsen Convenience Store and Anderson Internal Medicine that discusses the results of your review. Be sure to briefly discuss what you did or did not do and the findings (condition, criteria, cause, and effect).
Instructions:
After conferring with the attorney for Southern Appalachian Insurance Company, you prepared and he edited wording for subpoenas to the Bank of Lawrenceville and Waleska Bank to find out more information concerning the $36,000.00 check. Note: these subpoenas are not provided. Raymond T. Boone, CFE, a special agent with the insurance company’s Special Investigative Unit (SIU), subsequently interviews John Grayson, the Senior Vice President and Branch Manager for Waleska Bank in Ball Ground, Georgia.
Review the documents returned with the subpoenas and the interview of John Grayson in Chapter 7, section 7‐5, “Anderson Internal Medicine.”
Accordingly, you want to review the financial information associated with that check:
Review the documents returned with the following:
The subpoena to the Bank of Lawrenceville to obtain Anderson Internal Medicine’s demand account information for Account 7018188 for the period ending on or around December 31, 2015, including, but not limited to, the deposit ticket and front and back of the canceled check for $36,000.00, and the front and back of all canceled checks over $1,000.00 posted on or after December 30, 2015;
The subpoena to Waleska Bank to obtain the Greg Larsen’s demand account information for Account 7011176 for the period ending on or after December 31, 2015, including, but not limited to, the monthly bank statement, all deposit tickets and off‐setting items over $25,000.00, and the front and back of all canceled checks posted on or after the date of the aforementioned deposits over $25,000.00; and
The subpoena to Waleska Bank to get the credit application and the front and back of the canceled official checks associated with the $49,000.00 official check deposited into Greg Larsen’s demand account on December 28, 2015.
Review the SIU interview of John Grayson.
The results of your assignment will be used as an addendum to the original report and a courtroom audiovisual should you be called to testify as an expert witness.
This assignment is to be completed individually. In particular, all students are to perform the various fraud examination steps and submit their report narrative and audiovisual(s) for a grade. No Excel templates are provided.
NOTE: 1 Bank of Lawrenceville and Waleska Bank are part of the correspondent bank. Accordingly, all checks, including the $36,000 check, clear overnight.
Checklist:
Prepare an audiovisual (e.g., flowchart) showing the money flow from inception through final checks.
Write up the fraud examination analysis in the form of the Final Fraud Report using the short format and your exhibits, including audiovisuals for the long format for Anderson Internal Medicine that discusses the results of your review. Be sure to include condition (material error or fraud discovered), criteria (description in the type of material error or fraud and scope of analysis), cause, and effect. Please see the ACFE Long and Short Format reports.
The following sections should be part of your Final Fraud Report:
Background
Executive Summary
Scope
Methodology and Findings
Summary
Recommendations
As part of the scope, be sure to list the documents received.
Include as part of the long format, 2-4 exhibits. You can gain guidance on reports, schedules, and audiovisuals from Chapter 6 of the Fraud Examination text. Additionally, be sure to have at least one schedule for inclusion in your final fraud report, such as a lead schedule. Be sure to properly format your visualizations and exhibits.
Respond using the 7th edition APA format incorporating scholarly resources and citations
Category: fraud examination
Overview and Instructions
Assignment: Data Analytics: Helping to Solve Financial Fraud
The following Course Outcome is assessed in this assignment:
Appraise investigative techniques including interviewing and inquiry, in solving financial crimes.
Introduction:
In this assignment, you apply what you learned concerning investigative techniques, including interviewing and inquiry to resolve a financial fraud. Read the case study and then respond to the checklist items in a substantive manner.
Chapter 4: Case 4: Using Data Analytics: Analyzing and Summarizing Data with Excel Pivot
Case Adapted from the Casebook 4-1 Anderson Internal Medicine (Data Analytics): Using Data Analytics — Analyzing And Summarizing Data with Excel Pivot
History Behind The Fraud Case
The president of an unlicensed securities firm was suspected of securities fraud (i.e., selling bogus stock warrants to unsuspecting investors). The contents of 12 monthly bank statements, canceled checks, and deposit tickets of the business were scheduled (over 50 pages of transactions). How could the transactions be easily summarized? What does the schedule of transactions reveal? Were there any significant transactions? Excel Pivot came to the rescue.
In a half hour and several clicks on Excel Pivot, the Pivot tables of deposits and disbursements showed that the president used the business checking account as if it were his personal piggy bank. He primarily used debit cards to pay for two to three meals a day, every day travel and entertainment, an automobile for a girlfriend, and payments for household utilities, cell phones, and “strip clubs.” Based on the timing of receipts from customers, he celebrated at “strip clubs.” Soon after he was indicted and arrested, he read the fraud examination report and accompanying schedules. Shortly thereafter, he agreed to plead guilty to racketeering. The judge sentenced him to 20 years for racketeering.
Background
Tonya Larsen was the sole person in charge of the practice’s finances, including accounting during the period from September 1, 2015, to March 31, 2016.
After completing the examination steps in Anderson Internal Medicine cases (Cases 2 and 3), you decided to schedule the bank transactions shown on the bank statements for the six months preceding March 2016 (the month you examined in Cases 2 and 3).
Before proceeding, go to the companion website and download the Excel spreadsheet titled, Anderson Bank Transactions (Sep Oct Nov Dec Jan Feb). It is also available in a lengthy hardcopy format in Chapter 7, section 7‐4, “Using Data Analytics: Analyzing and Summarizing Data with Excel Pivot.” The downloadable version contains drop-down categories, which helps simplify the process of adding categories, whereas the hardcopy version does not. This spreadsheet contains the result of your efforts for September 1, 2015, through February 29, 2016. Based on the initial review of the Excel spreadsheet, you decide that you need to add categories to the withdrawal transactions so you can better summarize the data.
You decide to use the following categories commonly used by medical practices:
Answering Service
Automobile
Bank Charges
Basement
Books/Subscriptions
Business
Cash
Cash Deposit
Coding
Contributions
Food
Hardware
Health Insurance
Insurance
Janitorial Services
Legal & Accounting
Linen
Marketing/Promotions|
Medical Supplies/Pharmaceuticals
Medical Waste
Miscellaneous
Mortgage
Office Supplies
Parking
Printing
Repairs & Maintenance
Shipping
Taxes
Telephone
Travel
Utilities
In scanning the spreadsheet, you notice unusual names that do not fall under the common categories used by medical practices. Accordingly, you will use the following categories for those unusual transactions.
People
Unusual Transactions
To facilitate categorization, a drop‐down menu has been provided in the detail of transactions column. To use the menu, select the cell you want to use and click the down arrow that will appear to the right. Then select the category you feel is appropriate for the transaction.
Note: There are intentional spelling errors in the spreadsheet that you will identify and then sanitize (scrub) before completing the Pivot.
Summary Requirements:
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 drop‐down 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) (un‐scrubbed)
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 address all of the following in your response:
Provide the 7 irregularities noted in the first pivot table you developed.
Provide the pivot table from the first exercise.
Assess the irregularities in the data.
Determine what inquiries you would make of Anderson Internal Medicine to learn more about these irregularities.
Recommend what questions you would ask in an interview to gain more insight into these irregularities.
Provide the anomaly you determined in the deposits pivot table.
Determine the source of the anomaly.
Determine if this check is a normal deposit for Anderson Internal Medicine.
Provide the pivot table from the first exercise.
Provide the Final Excel Pivot Tables that would be included in your final fraud report to serve as an exhibit during your expert witness testimony.
This is an individual assignment. In particular, all students are to perform the various fraud examination steps and submit their Excel PivotTables for grades. NOTE: No Excel template is provided. You are to create your own Excel PivotTables by following the step‐by‐step instructions.
Remember the goal for this assignment is to show analysis for materials covered only in this Unit (not any other Unit).
Please try to use a News Article Written within the time period of the semester (as close as possible, if it is a one or two months before the semester that is okay). Use any digital newspaper outlet. Major outlets typically have a sport section with numerous articles that cover a wide range of sports and subject areas.
-New York Times
-Los Angeles Times
-The Atlantic
-etc…
Also, use the Google News Tab, as this can give you lots of news outlets. If you have any trouble finding news articles, do not hesitate to reach out to me.
The news curation should use one concept or piece of course content in making the connection to the news article (be sure to bold the concept). Please define the concept and provide a reference to its origin (A journal article, textbook, etc.). You can cite in-text or provide a reference list at the end.
Make sure that your posts include the following:
The title and date of the news article and a link to the news article.
2-3 sentence summary
1-2 sentence explanation of how part of the article connects to the course
1-2 sentence explanation of your thoughts on the topic using what you have learned in the course.
(If you write more, that’s okay)
Bullet points are fine
No need for outside research or formatting.
Tips on how to connect a concept to the news article:
A connection can come in many forms. Here are two typical ways to do it: (1) You could show a direct connection: Explain how the author of the news article discusses the concept you chose. In this instance, you can explain how the author is using the concept and any new insights you can draw. Also, evaluate it. In other words, use your philosophical tools to explain what you think about the author’s claims or use of the concept. (2) Or you could show how the author is missing an angle on their topic and explain how the concept you chose either helps support or undermine what the author of the news article is saying.
Part 1 Advance Care Planning and Analysis Read the section titled “Reflective Practice: Pants on Fire” from the chapter “Health Policy, Politics, and Professional Ethics” and address the questions below. >How do you judge Palin’s quote below, as an effective strategy to oppose Democrats’ plans for health care reform or unethical scaremongering? “And who will suffer the most when they ration care? The sick, the elderly, and the disabled, of course. The America I know and love is not one in which my parents or my baby with Down Syndrome will have to stand in front of Obama’s death panel so his bureaucrats can decide, based on a subjective judgment of their level of productivity in society, whether they are worthy of health care. Such a system is downright evil.” >Reflect on what informs your judgment: commitment to advance care planning, analysis of facts, and/or political party loyalties? >Is it right for nurses to endorse health reform legislation even if the legislation is not perfect? >Does this apply to the recently failed American Health Care Act? Reaching out a Solution In a Microsoft Word document of 5 pages formatted in APA style, you will develop a process for advocating about an issue as a nurse, from identifying a problem that needs to be solved through articulating a process for doing so. This assignment consists of answering each of the questions listed below from the “Political Analysis and Strategies” chapter of your course textbook. Write each question as a new topic area; then follow with a paragraph or two to answer the question. Let us assume that you are a school nurse in a high school. At a recent school athletic event, a spectator suffered a cardiac arrest in the stands. A coach of the home team went into the high school to fetch the automatic emergency defibrillator (AED) only to find out that it was not readily available. In the meantime, an emergency squad arrived and resuscitated the spectator. On Monday morning, you learn of the absence of the AED only to find out that it had been locked in the custodian’s closet. Reflect on the following questions outlined in the “Political Analysis and Strategies” chapter >What is the issue? >Is it my issue, and can I solve it? >Is this the real issue or merely a symptom of a larger one? >Does it need an immediate solution, or can it wait? >Is it likely to go away by itself? >Can I risk ignoring it? >What are the possible solutions? Are there risks to these solutions? >What steps would you need to take in order to solve the issue? >Does anyone else at the school need to be involved in the solution? >Where is the power leverage in the school to reach the preferred solution? Reaching a solution requires the use of power vested in the nurse. Review Box 9-1 (Sources of Power) and determine which type(s) of power the school nurse has in this situation. State your reasons for your answer. On a separate references page, cite all sources using APA format. Mason, D. J., Dickson, E. L., Perez, G. A., & McLemore, A. R. (Eds). (2020). Policy & politics in nursing and health care (8th ed.). Elsevier. ISBN: 9780323554985. American Psychological Association (2020). Publication manual of the American Psychological Association (7th ed.). American Psychological Association. ISBN: 9781433832154.
write a 2 page double spaced 12 point font paper that addresses the questions listed for this module’s part of the case study in grimes (2021)