The first part of the assignment will be to set up the analysis in excel. Go to the Internet and find the most current year end annual report or 10K of the company you choose. Please message all students with your choice as a company can only be done by one student. It is first come first choice so pay attention to what company other students have chosen. Please attach and submit your excel spreadsheets here. This should include both the vertical and horizontal analysis for a minimum of a 2 year period of both the income statement and balance sheet of the company you have chosen. The horizontal techniques you will need to do for 2 years are the amount and percentage of change and a trend analysis for 3 years for the balance sheet. In order to do your ratios for the second year you will need to have the balances also for the third year back. For the ratio part of the assignment calculate the liquidity, solvency, profitability and market prospects ratios. Do not merely type in the answers. You must use the calculation abilities of excel in other words set up formulas where possible. I choose the company American Airlines any help?