Question

In: Accounting

You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by...

You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by the Law Firm that is representing a client. The client, the former CFO of the Public Company, is being investigated by the SEC and FBI for running a large accounting fraud scheme and funneling money to his own account after allegedly falsely invoicing sales during 2013 and 2014. The Auditing Firm, which was recently terminated, audited the Public Company and issued opinion letters in connection with the Public Company’s 2013 and 2014 annual reports.

You are just getting up to speed on the case, but the ABC Partner asked for you to help analyze the issue in connection with the Law Firm.

Assume that you received a large data file reflecting invoices and purchase orders identified by date. Assume that the CFO provided to you, through his/her attorney, a large data file concerning the CFO’s own monetary transactions, which are listed by date.

1. Generate a step-by-step guide concerning how you would go about analyzing this information. (In other words, explain how you would transition from raw data to an analysis through forensic accounting techniques).  10 points

2. More specifically, assume that you would analyze this information using Excel: identify the formulas and methods you would use to analyze the data. 10 points

Solutions

Expert Solution

1. Generate a step-by-step guide concerning how you would go about analyzing this information. (In other words, explain how you would transition from raw data to an analysis through forensic accounting techniques)

We need to use the direct forensic accounting method since we have already received all invoices and purchase order.

I will follow the below step by step approach for analyzing this information.

1. Thoroughly check the authenticity of the documents shared by CFO.

2. Cross check the invoices and purchase order with the company records.

3. Eliminate CFO's own monitory transactions that are not related to the company.

4. Cross check the purchase orders with the invoices by filtering the data as per date, period and vendor.

5. Speak to the vendors if necessary.

6. Make a note of invoices that do not have a purchase order.

7. Investigate those in invoices and get the necessary explanation for those invoices from the CFO.

8. Eliminate invoices for which CFO could provide a valid explanation.

9. Create a list of invoices for which CFO fails to provide necessary explanation.

10. Submit audit report concluding fraud against invoices for which we did not receive a proper explanation.

2. More specifically, assume that you would analyze this information using Excel: identify the formulas and methods you would use to analyze the data.

Excel is a very useful tool for analyzing and concluding a large data. Following excel formulas methods will be very useful in this scenario for analyzing and concluding the data.

1. Filter: the filter function is one of the very useful function in excel which will help us to filter the data we required from a large data. In this scenario, we need to select data by date, period and vendor. The filter function can help us do that.

2. Freeze: Freeze function freeze can be used for freeing the header when you are looking at a large data.

3. Sum: Sum function is useful for calculating the total of invoice value and purchase order value.

4. Vlookup: Vlookup function look for a value in a large data and give its respective value from the next columns. It will work only vertically.

5. Hookup: Hlookup function look for a value horizontally and give its respective value from the next rows.

6. Match: Match function can be used for matching a value in a large data and let us know in which cell the value is reported.

7. Addition: Addition function can be used for adding multiple values the same as the function we have in the calculator.


Related Solutions

You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by...
You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by the Law Firm that is representing a client. The client, the former CFO of the Public Company, is being investigated by the SEC and FBI for running a large accounting fraud scheme and funneling money to his own account after allegedly falsely invoicing sales during 2013 and 2014. The Auditing Firm, which was recently terminated, audited the Public Company and issued opinion letters in...
You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by...
You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by the Law Firm that is representing a client. The client, the former CFO of the Public Company, is being investigated by the SEC and FBI for running a large accounting fraud scheme and funneling money to his own account after allegedly falsely invoicing sales during 2013 and 2014. The Auditing Firm, which was recently terminated, audited the Public Company and issued opinion letters in...
You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by...
You are an associate at ABC LLP, a forensic accounting firm. Your company is retained by the Law Firm that is representing a client. The client, the former CFO of the Public Company, is being investigated by the SEC and FBI for running a large accounting fraud scheme and funneling money to his own account after allegedly falsely invoicing sales during 2013 and 2014. The Auditing Firm, which was recently terminated, audited the Public Company and issued opinion letters in...
You are a manager who works for Hecht LLP, a local accounting firm. Your client is...
You are a manager who works for Hecht LLP, a local accounting firm. Your client is Triox Co. Triox is a major manufacturer of pharmaceutical products. A significant part of the company's operations involves research and development. Your firm has accepted the engagement to prepare a special report regarding the operations of Triox. (more will be discussed on this in unit five). Any findings in the report will be used to dictate the interest rate for future financing. You have...
Forensic Accounting Question you have been retained to assist a client with the following situation. the...
Forensic Accounting Question you have been retained to assist a client with the following situation. the client believes that there is something wrong and he wants you to evaluate his business and its exposure to theft and fraud. in less than 250 words, describe 10 things you would do to respond to the client's concerns
You are working for Mindak LLP, an accounting consulting firm, as a research and accounting specialist....
You are working for Mindak LLP, an accounting consulting firm, as a research and accounting specialist. Rowling Inc., an important manufacturing client, has asked you to research and explain the accounting rules for property, plant and equipment issues that the company is experiencing. The client wants you to reference and briefly explain the GAAP rules provided in the FASB codification. Rowling Inc. will then use your business professional memo to look up the rules in the codification. Instructions: Research the...
You are a manager who works for Ross, Sigh LLP, a local accounting firm. Your client...
You are a manager who works for Ross, Sigh LLP, a local accounting firm. Your client is Transport Logistics (TL) transports hazardous materials from disposal facilities located in Alberta to a secure area. Upon review of the minutes of the Board of Directors, you discover that TL has set up a higher than historical average provision for contingent liabilities related to spills that occurred while transporting the hazardous materials. Required: Discuss 5 audit procedures performed during the completion of the...
You are working for Mindak LLP, an accounting consulting firm, as a research and accounting specialist.  Rowling...
You are working for Mindak LLP, an accounting consulting firm, as a research and accounting specialist.  Rowling Inc., an important manufacturing client, has asked you to research and explain the accounting rules for property, plant and equipment issues that the company is experiencing.  The client wants you to reference and briefly explain the GAAP rules provided in the FASB codification. Rowling Inc. will then use your business professional memo to look up the rules in the codification. (a) the capitalization period for...
Forensic Accounting Case Study Series – sponsored by Deloitte FAS LLP and the Deloitte Foundation Check...
Forensic Accounting Case Study Series – sponsored by Deloitte FAS LLP and the Deloitte Foundation Check Fraud – Fun & Games Corporation Case No. 2-5 1 Fun & Games Corporation Case Study Overview: This case study is designed to test the students’ understanding of the materials covered in their accounting classes, as well as to test for fraud awareness. Given that first year associates are required to exhibit a certain level of analytical skills, the case has been developed to...
You are an Analyst for the professional service firm, FINACC LLP. Your firm specializes in providing...
You are an Analyst for the professional service firm, FINACC LLP. Your firm specializes in providing a wide variety of internal business solutions for different clients. It is your first day on the job and a Manager in the Consulting area asks you for some help with an investment decision for one of your large clients, Big Spenders Inc. Ready to make an impression on your first day, you start reading the background information provided by the Manager. Additional Information...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT