Financial Statements, Objectives and Strategies, and Ratios (25 points) Financia

Financial Statements, Objectives and Strategies, and Ratios (25 points)
Financial statements (5 points): Manually input 3 years of financial statement data (income statements, balance sheets, and cash flow statements) for your companies into your Excel spreadsheet. These numbers will be found in the company’s most recent year-end annual reports. Use Excel formulas as much as possible in your spreadsheet design. Complete separate worksheets for each company, but all work should be in one Excel file.
Business objectives and impact on the financial statements (10 points): Briefly discuss the current goals and objectives of each company and how they could potentially impact the financial statements. The objectives and goals can usually be found in the annual reports under CEO comments and business summaries.
Relevant ratios and discussion (10 points): Briefly discuss 10 ratios you think are important to the analysis of your two companies. Make sure to include ratios from the different categories. In your Excel spreadsheet, create a worksheet that shows ratio formulas and calculates ratios for the two most recent fiscal years for each company (i.e., current ratio for fiscal year 01, year 02). You do not have to calculate the ratios yet, but you will be comparing the ratios of each company to industry averages in the final project deliverable (10 points).
Include APA in-text citations and a reference list of your sources or points will be deducted.
Written content should be completed in a separate Word document.
I also attached the project that i had work on part 1