I need help to done the assignment as in attached file. Please kindly suggest the way to do it or may be advise the similar project what have an answer already. Thank you in advance.

Financial Reporting and Analysis Group Projects 1 and 2 ACCT6351 Spring 2015 You will be analyzing the following firms: a. Ford Motors. b. General Motors. For these firms, download the financial statements from the company's website or www.sec.gov (i.e., EDGAR online). Project 1 The required tasks are detailed below: (1) Prepare common-size balance sheet and income statements for both companies. Note: Compute for the most recent three years, and a three year average. (2) compute the ratios for both companies. Liquidity Days' sales in receivables; Accounts receivable turnover in days; Days' sales in inventory; Inventory turnover in days; Current ratio; acid-test ratio; Long-term debt-paying ability Time's interest earned; Debt ratio; Debt to tangible net worth ratio; Operating cash flow/total debt; Profitability Net profit margin; Total asset turnover; Return on assets; Return on investment; Return on total equity; Gross profit margin; Investor Analysis Price/earnings ratio; Dividend payout; Dividend yield; Operating cash flow/cash dividends. Project 2 The complete report will be turned in as Project 2. (i.e., you should incorporate Project 1 in Project 2.) Two separate files for Project 2 are not acceptable. The required tasks are detailed below: (1) Comment on the analytical results of the two companies based on your work in Project 1. Your comments should concentrate on the trends across the companies. Also discuss strategy perspectives, including evaluating and identifying their future strategies. In addition to contrasting the ratios between the companies, you should interpret the numbers and make suggestions as to why the ratio of one company might be higher/lower than the other. You should provide a summary of the financial performance of the firms, as well as a recommendations section where you provide suggestions for ways to improve financial performance of the firms. (e.g., if a ratio is low for a particular reason, what are some ways the company may correct that in the future?) Note: General discussions of the ratios are given in our textbook, which will help you structure your comments. (2) Prepare projected GAAP Income Statements and Balance Sheets for both companies for the next year. List the assumptions used in your work. (3) Write a conclusive summary on the firms you have studied. Based upon your conclusions, recommend the better performing firm for potential investment. Your conclusions should be based upon, and specifically reference, the analyses prepared in this report. Report Format Requirements: A. Report body requirements: 1. Cover page. List the title of the project, your name, and semester/year. 2. Abstract or Executive Summary. This is a separate page. It should cover the purpose of the project, the major findings, and the conclusions/recommendations, in summary form. 3. Table of Contents. 4. Main body. Use the following sequence for report content: a. Introduction to the two companies and to the purpose of the report b. Analytical section. This should include all your numerical analyses. This is where you will discuss the results of, comments on, and conclusions about, the Common Size, and the ratio analyses for both companies. c. Summary of the financial performance of the firms, as well as suggestions to improve financial performance of the firms. d. Pro forma financial statements and summaries on these pro forma financial statements for both companies. e. Conclusions and recommendation for investment. 5. References. List all major reference sources. 6. Appendices. Include tables of your numerical analyses. For reference convenience, assign a title to each separate item, such as Table 1, Exhibit 1, etc. B. Typesetting requirements: 1. Use size 12 font. Times New Roman is preferred. 2. Single space between lines. 3. Number pages in accordance with the APA style guide. 4. One inch on all sides. 5. Do not right justify text. Use left justify. C. Miscellaneous The total report (Projects 1 and 2 combined) should not exceed 30 pages. Plagiarism Plagiarism will not be tolerated. Evidence of plagiarism will result in a grade of \"F\" to the course and be subject to appropriate disciplines