Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Fill in the table with answers in bold
image text in transcribed
image text in transcribed
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

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

Living Off The State A Critical Guide To UK Royal Finance

Authors: Jon Temple

1st Edition

0955831113, 9780955831119

More Books

Students also viewed these Finance questions

Question

Explain the nature of human resource management.

Answered: 1 week ago

Question

Write a note on Quality circles.

Answered: 1 week ago

Question

Describe how to measure the quality of work life.

Answered: 1 week ago