This week your instructor will place you in groups to work on your course project. In your groups, compare the companies that you evaluated in Modules 01 and 02. Select a single company to work on as a group for the remainder of the project.
As part of your plan, use the spreadsheet provided below. The spreadsheet includes two tabs – one for the Analytical Ratios and another for the Horizontal Analysis. Also, insert your risk analysis into the spreadsheet on a separate tab.
Feel free to add and subtract lines on the horizontal analysis to match the financial statements of the company you have chosen. You may want to also include a horizontal analysis of the cash flow statements since these can provide additional information. Copy the financial statement data into another tab on your spreadsheet.
Each group member should submit the Audit Plan as part of the audit work papers workbook.
Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel spreadsheet. (Mac users, please remember to append the .xlsx extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below: