Auditing is the capstone course for the bachelors degree and includes the following capstone project: You will be responsible for completing Integrated Case Application--Pinnacle Manufacturing: Part 1. This integrated case is located at the end of Chapter 8 of your eText. While the directions indicate that the case is presented in 7 parts, you will focus on Part I only which involves performing analytical procedures for different phases of the audit. This project is worth 20% of your final grade. The completed project will contain a Word document and an Excel file. The Word document must contain a minimum of 900 words. The directions for Requirement d, give you a link to the eText website where you can download the excel file containing the financial statements as depicted in Figure 8-9. For your convenience, I have attached the excel file here. Please download it and save it to your computer. Once saved, you will be able to complete Requirement e. You must carefully complete the remaining requirements in your Word document. Please be sure to use APA formatting for the project and include the following first level subheadings in your paper: 1. Analyze the year to year change in account balance (Requirement a) Note: This section of your paper will contain numerical information only. Please follow the directions carefully for Requirement a. 2. Calculate five common ratios (Requirement b) Note: This section of your paper will contain numerical information only. Please follow the directions carefully for Requirement b. 3. Summary of observations regarding business risk including assessment of client's business risk (Requirement c) 4. Identify Income Statement accounts for which there is a concern about material misstatements (Requirement d) Note: This section of your paper will be completed once the Worksheet is completed. 5. Three divisional Income Statements areas of concern for material misstatement (Requirement e) Note: This section of your paper will be completed once the Worksheet is completed. 6. Useful data for evaluating the potential for misstatements (Requirement f) 7. Analysis of account balances (Requirement g) 8. Assess the likelihood that Pinnacle is likely to fail (Requirement h)