5 pages of word document, 1 page of excel, Task: You will chose a publicly traded company and analyze their financial statements. Your ultimate goal is to make two decisions about the company: will you purchase their stock and will you lend them money. Make sure your report clearly states your decision. Procedures: 1.Choose a major publicly traded corporation to analyze (Chevrolet). You must provide a direct link to the company’s online annual report. It is your responsibility to make sure all information you will need is available. 2.After your selection has been approved you may begin your research. You may obtain information from hoovers.com (this one is good for NAICS Code, Industry average, and any additional financial data,), sec.gov (this one should be use for info to calculate the ratios), moneycentral.msn.com, your company’s website and anywhere else you choose. 3.The attached rubric will list all of the required information for this report. If you copy the work of another author make sure to give them credit for their work. 4. Your paper should be approximately 5 pages long (this does not include the actual financial statements and articles). 5. Your report should include two articles related to your company that you believe will affect your decision. These articles must be written within the last year. 6. The email should contain two attachments: the Word document and the Excel document with calculation of the ratios and their names using the excel formulas . Financial Statement Analysis Project Rubric 1. Criteria: Ratio identification. You should select 3 ratios from each of the following categories: liquidity, solvency and profitability. (data from financial statements from sec.gov should be used; ratios on the hoovers.com will be different than your calculated ones, it is ok.) 2. Criteria: Ratio Calculation. You must calculate the 9 ratios identified above for your company using Excel formula Each ratio calculated correctly using Excel formula – Should be submitted in separate excel file. 3. Criteria : NAICS Code, Industry average Industry Averages. You must include NAICS Code and the industry averages for the ratios you identified above. If the industry average is not available you should calculate the ratio for a competitor. 4. Criteria: Market Price. You must include the market price for the company’s stock on 3 dates: within one week of submission of your report, on the last date of the companies prior fiscal year, on the last date of the fiscal year from two years ago. 5. Criteria: Lending Decision. You should make a decision about whether to lend this company money using your observations. Use only facts not your opinions.You referenced most dentified ratios, industry averages, current events, trends, and market values in your decision 6. Criteria: Investing Decision. You should make a decision about whether to invest in this company using your observations. Use only facts not your opinions.You referenced most dentified ratios, industry averages, current events, trends, and market values in your decision 7. Criteria: Current Events. You should attach two recent articles (within the last year) that you believe will affect your decisions about the company (e.g. the new "green" line of cars they trying to bring to the market). You should summarize the articles and include your opinion about how the event will affect your decision and name the sourse. 8. Criteria: Sources. You identified all sources of information including at least 3 from the internet.