Answered step by step
Verified Expert Solution
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. 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
please insert a table as look like in the questions and put the answer in it right place.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started