I need assistance with this project.

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 companys financial statements and providing an in-depth report on the companys 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.

• • Create a in-depth Financial Statement analysis report with the following elements (use chapter 9 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) Chapter 9 (pages 323-351) summary Exhibit 10 page 342. 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 9 (pages 323-351) summary Exhibit 10 page 342. 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. 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%

Work output:

Excel spreadsheet with clear ratio analysis performed so it can be graded

Word document - in-depth Financial Statement analysis report

Due October 15th

Remember- pick a company you want to learn about. Go to that company's website and go to Investor information section. You need Audited Financial Statements which are usually available on the website. Pick one that does provided audited financials. START NOW!! Tables and PDFs do not get along! -some stray characters in table- but you will understand the idea. Note: Be sure to use audited financial statements. Financial Statement Analysis Project (100 points) This project will cover the topics / concepts covered in the class. PRINT THIS OUT AND START WORKING ON THIS AS SOON AS POSSIBLE. Below are the requirements of the Financial Statement Analysis, 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 a in-depth Financial Statement analysis report with the following elements (use chapter 9 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) Chapter 9 (pages 323-351) - summary Exhibit 10 page 342. 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 9 (pages 323-351) - summary Exhibit 10 page 342. 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. 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% 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; worth 100 points 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. Enjoy