In July 2013, Nike had EPS of $2.52 and a book value of equity of $12.48...

In July 2013, Nike had EPS of $2.52 and a book value of equity of $12.48 per share.

a. Using the average P/E mulitple in Table 2, estimate Nike's share price.

b. What range of share prices do you estimate based on the highest and lowest P/E multiples in Table 2?

c. Using the average price-to-book value mlutiple in Table 2, estimate Nike's share price.

d. What range of share prices do you estimate based on the highest and lowest price-to-book value mulitples in Table 2?

Table 2
Name	Market Cap ($ million)	Enterprise Value ($ million)	P/E	Price/Book	Enterprise Value/Sales	Enterprise Value/ EBITDA
Nike, Inc.	55,970	54,023	23.29	5.07	2.03	15.71
Adidas AG	23,105	23,317	32.33	3.06	1.20	11.88
Puma AG	4,330	4,085	70.56	1.96	0.96	9.34
Wolverine World Wide	2,910	3,981	37.6	4.13	1.22	9.28
Steven Madden, Ltd.	2,320	2,140	18.4	3.68	1.74	10.70
Deckers Outdoor Corp.	1,990	1,923	16.74	2.67	1.36	8.73
Crocs, Inc.	1,470	1,240	11.46	2.4	1.10	6.74
Skechers U.S.A.	1,340	1,213	67.41	1.54	0.78	18.16
Weyco Group	301	325	16.53	1.71	1.11	9.69
R. G. Barry Corp.	197	174	14.92	2.31	1.19	6.44
Rocky Brands, Inc.	113	132	12.46	0.89	0.58	6.61

Please show how to solve in Excel

Expert Solution

jeff jeffy answered 1 year ago

Suppose that in July 2013, Nike Inc. had EPS of $2.45 and a book value of...

Suppose that in July 2013, Nike Inc. had EPS of $2.45 and a book value of equity of $11.78 per share. StartFraction Upper P Over Upper E EndFraction P E StartFraction Price Over Book EndFraction Price Book StartFraction Enterprise Value Over Sales EndFraction Enterprise Value Sales StartFraction Enterprise Value Over EBITDA EndFraction Enterprise Value EBITDA Average 29.84 29.84 2.44 2.44 1.12 1.12 9.76 9.76 Maximum plus + 136 136% plus + 70 70% plus + 55 55% plus + 86...

Suppose that in July 2013, Nike Inc. had EPS of $2.61 and a book value of...

Suppose that in July 2013, Nike Inc. had EPS of $2.61 and a book value of equity of $12.52 per share. p/e | price/book | enterprise value / sales | enterprise value/EBITDA AVG: 29.84 | 2.44 | 1.12 | 9.76 MAX: +136% | +70% | +55% | +86% MIN: -62% | -63% | -48% | -34% a. Using the average P/E multiple from the table above, estimate Nike's share price. b. What range of share prices do you estimate...

Suppose that in July 2013, Nike Inc. had EPS of $2.36 and a book value of...

Suppose that in July 2013, Nike Inc. had EPS of $2.36 and a book value of equity of $13.27 per share. P/e Price/Book Enterprise Value/Sales Enterprise Value/EBITDA Average 29.84 2.44 1.12 9.76 Max + 136% + 70% +55% +86% Min -62% -63% -63% - 34% a. Using the average P/E multiple from the table above, estimate Nike's share price. b. What range of share prices do you estimate based on the highest and lowest P/E multiples in the table above?...

Suppose that in July 2013, Nike Inc. had sales of $ 25 comma 245 million, EBITDA...

Suppose that in July 2013, Nike Inc. had sales of $ 25 comma 245 million, EBITDA of $ 3 comma 259 million, excess cash of $ 3 comma 333 million, $ 1 comma 395 million of debt, and 894.1 million shares outstanding. StartFraction Upper P Over Upper E EndFraction StartFraction Price Over Book EndFraction StartFraction Enterprise Value Over Sales EndFraction StartFraction Enterprise Value Over EBITDA EndFraction Average 29.84 2.44 1.12 9.76 Maximum plus136% plus70% plus55% plus86% Minimum minus62% minus63% minus48%...

Suppose that in July? 2013, Nike Inc. had sales of $25,217 million, EBITDA of $3,247 million,...

Suppose that in July? 2013, Nike Inc. had sales of $25,217 million, EBITDA of $3,247 million, excess cas of 3,337 million, $1,383 million of debt, and 901.2 shares outstanding StartFraction Upper P Over Upper E EndFractionPE StartFraction Price Over Book EndFractionPriceBook StartFraction Enterprise Value Over Sales EndFractionEnterprise ValueSales StartFraction Enterprise Value Over EBITDA EndFractionEnterprise ValueEBITDA Average 29.84 2.44 1.12 9.76 Maximum plus+136% plus+70% plus+55% plus+86% Minimum minus?626% minus?63% minus?48?% minus?34% a. Using the average enterprise value to sales multiple in...

Consider the following data for the airline industry for July 2018 (EV=enterprise value, Book=equity book value)....

Consider the following data for the airline industry for July 2018 (EV=enterprise value, Book=equity book value). Suppose Alaska Air (ALK) has 124 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. Company Name Market Capitalization Enterprise Value (EV) EV/Sales EV/EBITDA EV/EBIT P/E Forward P/E Alaska Air (ALK) 7286 8207 1.02 5.1 6.7 7.7 12.5 American Airlines (AAL) 17879 37327 0.87 5.7 8.2...

Stewart Inc.'s latest EPS was $3.50, its book value per share was $22.75, it had 162,500...

Stewart Inc.'s latest EPS was $3.50, its book value per share was $22.75, it had 162,500 shares outstanding, and its debt-to-assets ratio was 46%. How much debt was outstanding?

In December 2015, General Electric (GE) had a book value of equity of $ 97.8 billion,...

In December 2015, General Electric (GE) had a book value of equity of $ 97.8 billion, 9.4 billion shares outstanding, and a market price of $ 32.04 per share. GE also had cash of $ 102.1 billion, and total debt of $ 198.1 billion. a. What was GE's market capitalization? What was GE's market-to-book ratio? b. What was GE's book debt-equity ratio? What was GE's market debt-equity ratio? c. What was GE's enterprise value?

In early 2015, Ford Motor (F) had a book value of equity of $ 24.8 billion,...

In early 2015, Ford Motor (F) had a book value of equity of $ 24.8 billion, 4.0 billion shares outstanding, and a market price of $ 16.00 per share. Ford also had cash of $ 21.7 billion, and total debt of $ 119.2 billion. Three years later, in early 2018, Ford had a book value of equity of $ 35.0 billion, 4.0 billion shares outstanding with a market price of $ 11.00 per share, cash of $ 26.5 billion, and...

A company has an EPS of $2.40, a book value per share of $24.24,and a...

A company has an EPS of $2.40, a book value per share of $24.24, and a market/book ratio of 2.1×. What is its P/E ratio? Do not round intermediate calculations. Round your answer to two decimal places.

Question