Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ne: Ratio Analysis :ription Air Lines Inc. data (Delta_Air_Lines_Financial_Statements.xls) has been provided to you, along amputations of the ratios (the formulas are contained in the

image text in transcribed
ne: Ratio Analysis :ription Air Lines Inc. data (Delta_Air_Lines_Financial_Statements.xls) has been provided to you, along amputations of the ratios (the formulas are contained in the Excel worksheet, Ratios.) The includes worksheets for Ratios, Consolidated Balance Sheet, and Statements of Operations, Stockholders' Equity. I.eview the ratios provided. (Note that there are two inventories to consider for the company: Fuel rnd expendable parts. The ratios provided ONLY takelet into account.) Identify each ofthe 'ollowing ratios that are provided in the spreadsheet for the year 2017, and provide an explanation .f its meaning, comparable to other years: ' Current Ratio Asset Turnover Inventory Turnover ' Debt to Asset Ratio Interest Coverage Prot Margin ' Return on Assets ' Return on Equity Sased on the ratios provided, identify 2-3 questions you might have about the company's rperations that you would like more information about if you were an analyst, company manager, .r investor. io to: httpszi/www.sec.gov/edgarfsearchedgar/companysearchhtml and search for Delta Air Lines no. (DAL). Every company has a standard classication code for what industry they're in, such .5 The Standard Industrial Classication code (SIC) or North American Industry Classication :ystem (NAICS) code. Identify the SIC code for Delta Air Lines Inc. in the information shown on he EDGAR site under the Delta Air Lines Inc. name. (Note: You can click on this code to nd rther companies with the same code.) .'he other major players in the U.S. airline industry include United Continental (UAL), American lirlines (AAL), and Southwest Airlines (LUV). Choose one of these companies, and use EDGAR https:ffww. sec. goviedgarf searchedgarfcompanysearchhtml) to search for the annual reports for his company from 2014-2017. (Note: In the F iling Type Box, enter "IO-K " and press Enter. "hen, click on the Interactive Data button for one of the years. You can view the statements by ticking on the left menu bar, or click View Excel Document to download the data. Do this for act: of the years.) Conduct the ratio analysis for the company you chose and compare the ratios .cross years and to those of Delta Air Lines Inc. Identify any observations or questions you might lave

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Chinese Economy Transitions And Growth

Authors: Barry Naughton

1st Edition

0262640643, 9780262640640

More Books

Students also viewed these Economics questions

Question

Define the elasticity of supply and show how it is calculated.

Answered: 1 week ago