There are two this study: + Pan One le computations of the financial ratios of me lines Analyze the financial ratios by awering questions Data Description and Requirements The Delta Air Lines foc data (Delta Air Lines Financial Statements.xls) has been provided o you, aka with de computations of the ratios (de formadas are contained in the Excel works, Ratios) The workbook inchides worksheets for Ration, Consolidated Balance Sheet, and Suements of Operations, Cash and Stockholders' Equity 1. Compte de cial ratios by applying the funds learned from class. (Note that art two into consider for the company: Fuel and expendable pats. The inquired ONLY fiant.) Nyuu mste de EXCEL functions in computation insta 2 Identify each of the following ratios that are provided in the spreadsheer for the year 2017, and provide an explanation of its ming, comparable to other years: , C + Asset Turnover leveory Tover T Debt to Act Ratin Interest Coverage Profit Margi Return on Assets Retro Equity op Based on the compusod, identify 2-3 questions you might have about the company's that you would like more information about if you were an analyst, company manager, or investor 4. Goimialariaholampah and scarch for Delta Ar Lines Inc. (DAL) Every company has a standard classification onde for what industry they're in, each The Standard Indunal Chastication code (SIC) or North American Induery astication Synem (NAICS) code Identy the SIC code for Delta Air Lines Inc. in the infande EDGAR site and the Delta Air Lines Inc. (Note: You can click on this code find other companies with the code) The other major players in the US airline industry include United Commental (UAL), American Airlines (AAL) and Southwest Airlines (UV) Choose o se one of these companies and EDGAR (www.sec.govegan chocompanysearch bn to search for the anual reports for this cagany from 2014-2017. (Note: In the Filing Type Boxer "10-K" and press Enter. Then, click on the Interactive Das button for one of the years. You can view the statements by clicking on the left menu har, or click View Excel Document to download the data Do this for each of the years) Conduct the ratio analysis for the company you chose and compare the ratione year and to those of Delta Air Lines Inc. Identify any obrvations or questions you might have. 6 Create a visualization (graph, able, etc.) to compare the two companies on at least one factor (a fuel costs, inventory levels, revenues, expenses, etc.) Your visualization should tell a clear soury about the comparative performance of the two companies. For your visualization it is clearly readable and attractive using some of the techniques you learned in the module. Provide a brief explanation of whue the visualization is supposedon sherw 7. Following the "Ratio Analysis Model" and the "oxiness Decision Model' car the end of Chapter 12 Chap 13), make a PPT presentation with your group and record a less than 10. minutes presentation to analyze the financial ratios in answering questions 2 through Din's forget to your faces in the receding One person from the group will need to upload the following documenes as your final project Excel spreablets of your selected company and the competit company with computed PPT did Recorded PPT presentation in MP form (oxing Toomasa mending tool