Question: Fill in the table with answers in bold Data table (Click on the following icon in order to copy its contents into a spreadsheet) Company

Data table (Click on the following icon in order to copy its contents into a spreadsheet) Company Name Alaska Air (ALK) American Airlines (AAL) Delta Air Lines (DAL) Hawaiian (HA) JetBlue Airways (JBLU) SkyWest (SKYW) Southwest Airlines (LUV) United Continental (UAL) Source Capital Market Capitalization 7,286 17,879 35,580 2,023 5,450 2,909 30,318 21,961 Enterprise Value (EV) EV/Sales 8,207 1 02x 37,327 0.87% 44,164 102x 2057 0.73% 5,814 0.80x 5,040 1.56x 30,691 1.44x 31,393 0.80x EV/EBITDA 5 1x 5.7x 5.7x 3.4x 4 1x 72x 6.9x 5.7x EV/EBIT 6.7% 8.2x 8.0x 4.1x 5.9x 12 6x 8.9x 9 2x PIE 7.7% 10.5% 10 8x 5.8% 4.9x 6 6x 8.6x 11 4x Forward PIE 125x 8.2x 8.8x 7 2x 10.8x 11 8x 12 3x 93x 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 EV/EBITDA EV/EBIT P/E P/Book 1.02 51 6.7 7.7 125 Alaska Air Median Implied EV Implied market cap Implied share price s S $ S ID s S s $ $ $ $ s S $ Data table (Click on the following icon in order to copy its contents into a spreadsheet) Company Name Alaska Air (ALK) American Airlines (AAL) Delta Air Lines (DAL) Hawaiian (HA) JetBlue Airways (JBLU) SkyWest (SKYW) Southwest Airlines (LUV) United Continental (UAL) Source Capital Market Capitalization 7,286 17,879 35,580 2,023 5,450 2,909 30,318 21,961 Enterprise Value (EV) EV/Sales 8,207 1 02x 37,327 0.87% 44,164 102x 2057 0.73% 5,814 0.80x 5,040 1.56x 30,691 1.44x 31,393 0.80x EV/EBITDA 5 1x 5.7x 5.7x 3.4x 4 1x 72x 6.9x 5.7x EV/EBIT 6.7% 8.2x 8.0x 4.1x 5.9x 12 6x 8.9x 9 2x PIE 7.7% 10.5% 10 8x 5.8% 4.9x 6 6x 8.6x 11 4x Forward PIE 125x 8.2x 8.8x 7 2x 10.8x 11 8x 12 3x 93x 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 EV/EBITDA EV/EBIT P/E P/Book 1.02 51 6.7 7.7 125 Alaska Air Median Implied EV Implied market cap Implied share price s S $ S ID s S s $ $ $ $ s S $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
