Question: 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.  please insert a table as look like in the questions and
put the answer in it right place. Consider the following data for

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!