Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please insert a table as look like in the questions and put the answer in it right place. Consider the following data for the airline

please insert a table as look like in the questions and put the answer in it right place. image text in transcribed
image text in transcribed
Consider the following data for the airline industry for July 2018 (EV = enterprise value, Book = equity book value). Suppose Alaska Air (ALK) has 123 million shares outstanding. Estimate Alaska Air's share value using each of the five valuation multiples, based on the median valuation multiple of the other seven airlines shown (excluding Alaska Air). Calculate Alaska Air's share values using each of the five valuation multiples below: (Round the median to two decimal places. Round the share price to the nearest cent. Round the EV and market cap to the nearest integer.) EV/Sales EVEBITDA EV/EBIT PIE P/Book Alaska Air 1.02 5.1 6.7 7.7 12.5 Median Implied EV Implied market cap $ implied share price $ $ $ $ $ $ $ $ $ $ Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Market Enterprise Company Name Capitalization Value (EV) EV/Sales Alaska Air (ALK) 7.286 8,207 1.02X American Airlines (AAL) 17,879 37,327 0.87% Delta Air Lines (DAL) 35,580 44,164 1.02% Hawaiian (HA) 2,023 2,057 0.73% JetBlue Airways (JBLU) 5,450 5,814 0.80x SkyWest (SKYW) 2,909 5,040 1.56x Southwest Airlines (LUV) 30,318 30,691 1.44x United Continental (UAL) 21,961 31,393 0.80x Source: Capital EV/EBITDA 5.1X 5.7x 5.7x 3.4x 4.1x 7.2x 6.9x 5.7x EV/EBIT 6.7x 8.2x 8.Ox 4.1x 5.9x 12.6x PIE 7.7x 10,5x 10.8x 5.8x 4.9x 6.6x 8.6x 11.4x Forward PIE 12.5x 8.2x 8.8x 7.2x 10.8x 11.8x 12.3x 9.3x 8.9x 9.2x

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

Auditing And GRC Automation In SAP

Authors: Maxim Chuprunov

1st Edition

3642353010, 9783642353017

More Books

Students also viewed these Accounting questions

Question

What is the purpose of a trial balance?

Answered: 1 week ago