Plan your work-Audited financial statements required as the basis.

Pick a corporation you want to learn about.

Go to theirwebsite =>> investor section and download the last 2 AUDITED financial statements.If concerned ask me.

Review the project rubric and structure your project.

You need to reasonably cover the corporation's issues - positive and negative- based on the analyses performed.

YES- provide the Excel spreadsheet with your calculations.

So two documents- the Excel file and The Word analysis document.

• Download Attachments:

Financial Statement Analysis Project Rubric This project will cover the topics / concepts covered in the class. START as soon as possible. Below are the requirements of the Financial Statement Analysis Project, which is due at the end of week six: Financial Statement Analysis General Description: In order to reinforce the concepts and provide practical application of concepts learned in class, a project requiring students to complete a Financial Statement Analysis is included as part of this course. Specific Requirements: The Financial Statement (F/S) analysis should involve downloading a company's financial statements and providing an in-depth report on the company's economic condition through ratio analysis and answering of specific questions. You choose a company from the internet- maybe one which you always wanted to know about. Be careful to not become 'bogged down' in the volume of data in an annual Report/ Financial Statement. Choose carefully. o Create an in-depth Financial Statement analysis report with the following elements (use chapter 17 as a guide for this project): Perform a Horizontal Analysis of the financial statements (Balance Sheet Assets/ Liabilities and Equity; Current Assets; Comparative Income statement and Retained Earnings) as illustrated in the text Chapter 17 summary Exhibit 13- page 848). A minimum of 20 ratios must be calculated- show work in a separate schedule. Approximate worth 20% Perform a Vertical Analysis of the financial statements (Balance Sheet Assets/ Liabilities and Equity; Current Assets; Comparative Income statement) Chapter 17 summary Exhibit 13- page 848). A minimum of 20 ratios must be calculated- show work in a separate schedule. Approximate worth 20%. Perform a Solvency and Profitability Analysis of the financial statements. Calculate at least 10 ratios. Chapter 17 (pages 801825) - Approximate worth 20% Create an in-depth Financial Statement Analysis report discussing the above F/S analyses. This report must convey the results of the Horizontal Analysis, Vertical Analysis, the Solvency Analysis and Profitability Analysis of the financial statements. Detail the following expected future results and perceived issues of the chosen corporation. Approximate worth 40% NOTE: A summary of Analytical Measures can be reviewed on Chapter 17 summary Exhibit 13- page 848).. Work output: 1. Excel spreadsheet with clear ratio analysis performed so it can be graded 2. Word document - in-depth Financial Statement analysis report Due at end of week 6 Required Financial Statement analysis project Grading Rubric: 90 - 100% F/S analysis project meets all requirements in length and content; shows excellent understanding of the material; AND grammar, structure, and spelling are at college level. 80 - 89% F/S analysis project meets all requirements in length and content; shows a good understanding of the material; AND grammar, structure, and spelling are at college level. 70 - 79% F/S analysis project meets all requirements in length and content; shows some understanding of the material; AND/OR grammar, structure, and spelling need some improvement. 62 - 69% F/S analysis project meets bare minimum requirements in length and content; lacks some key understanding of the material; AND/OR grammar, structure, and spelling need a lot of improvement. 0 - 62% F/S analysis project study does not meet minimum requirements in length and content; OR grammar, structure, and spelling are not at college level