Question
The owner of ABC Co.has asked your to look intoa possible issue withthe company's travel expenses.They have provided you with this year and last year's
The owner of ABC Co.has asked your to look intoa possible issue withthe company's travel expenses.They have provided you with this year and last year's financial statements and the detail for the travel expense account. You will be conducting some audit procedures for ABC Co. andanalyzingtheresults.
The company has 4 sales managers that travel on a regular basis:Catherine Ames, BrodyCallina, DougGartner, andUstisSoizuka.The company has issued eachof theseemployees a company Mastercardto be used for business expenses when traveling.
COURSE OBJECTIVES COVERED:2-5
PROJECT REQUIREMENTS:
This project is split into four (4) parts with one (1) part due each week of the course. Based on your readings, use of technology, research of literature, and other sources do the following:
- Part 1-Review the financial statements given to you by the owner of ABC Co..Based on the AICPA Code of Professional Conduct preparea 2-3 pagesummaryof how youplan to proceed to addressthe owner's concernsand what specific steps you would take to audit this company.
- Part 2-Using the financial statement fileand the data file for travel expensesperform some analytical tests.You will need to perform someanalytical test on the financialstatements using Excel.This may be a horizontal and/or vertical analysis,ratios, etc.
- You will then need to perform some analytical tests on thetravel expense accountfiles using IDEA that you thinkmay be necessary.Remember there are tutorial videos on the IDEA website to assist you.Write a 1-2 sentence explanation for each analysis youare performingandprintscreenyour resultsalongwith thehistorylogwhen you have completed the analysis in IDEA to turn in this week.
- Part 3-Prepare a 2-3 page analysis discussing what youfoundas a resultof your analysis and what internalcontrolsyouwould recommend to the ownerof ABC Co.
- Part 4-Present your project to the class for discussion
WRITING REQUIREMENTS:
The report should be should be 4-5 pages in total for the entire project(not including cover page, abstract, or references)
Include the Excel and IDEAscreenshot(s) or files as exhibits in your paper
Include a minimum of2 scholarly sources from the KU Library andthe AICPA
oAll sources used are to be cited in APA format
oPlease use the writing center if needed
TECHNOLOGY/COLLABORATIVE ACTIVITY:
You will be using Excel andIDEA to perform someanalysisand results will be includedas an exhibit to your paper
You will be presenting your findings from the project to the class using the voice-over feature inPowerPointorYouTube. Please be sure the audio is clear and the file or link is accessible in the Week 4 Presentation discussion board.
You will be collaborating with other classmates on their presentations and answering any questions about your own presentation.
ASSIGNMENT DUE DATE SCHEDULE:
Week 1:Submit yourpart 1 summary
Week 2:Submit your part 2 Excel and IDEA results
Week 3:Submityour part 3 analysis
Week 4:Present and discuss your project
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