Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

https://drive.google.com/drive/folders/1kDWJIiuLeFLgT5lYn03i0lOGOR1hggJ6?usp=sharing this link is for the data set. please i need the solution for excel and report....as soon as possible.... 200399 Information Systems for Accountants

https://drive.google.com/drive/folders/1kDWJIiuLeFLgT5lYn03i0lOGOR1hggJ6?usp=sharing

this link is for the data set.

please i need the solution for excel and report....as soon as possible....

image text in transcribed
200399 Information Systems for Accountants Accounting Practical Exercise 1 You are a financial auditor and work on the ABC Building Ltd account. The Audit Partner is suspecting that the CEO (George King) has used financial statement fraud techniques to inflate net income and get higher bonuses. Your Audit Partner is suspecting the following fraud schemes having been applied to inflate net income: Concealed Cost of Goods Sold Fictitious Revenue Improper Asset Valuation The General Journal You are provided with two years of general journal data. The financial year start date is 1 June. Your Task Download the data file from vUWS to your computer. Please note that the materiality for the engagement is $100,000. It is also important to note that bookkeeping is regularly done on weekends. Analyze the general journal using the various tools and features in Excel specifically addressing the above mentioned fraud schemes. Identify no more than 25 transactions that would need to be investigated further. From these transactions narrow down and specifically identify transactions that you suspect have been applied to inflate income under the three fraud schemes stated above. Submission You will submit a brief report on vUWS in word. The report should have at minimum the following sections: Introduction - Provide a brief introduction to the audit engagement and your task. Procedures/methods - Outline the procedures that you undertook to identify the fraudulent transactions. Findings - In this section present the findings of your analysis of the GL of the audit client. Specifically identify and explain the transactions that you suspect have been applied to inflate income under the three fraud schemes - Concealed Cost of Goods Sold, Fictitious Revenue and Improper Asset Valuation. Appendix - Present the journal entries that you have identified in your findings section. Copy and paste the journal entries from the excel data file into the appendix section. Journal entries are to be presented under the relevant fraud schemes

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

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions

Question

Coping with competitive pressure and sport performance anxiety

Answered: 1 week ago