Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...

Question

Question

Table 1 Stock Prices and Multiples for the Footwear Industry, January 2006 Ticker Name Stock Price ($) Market Cap ($ Enterpri Suppose that in January 2006, Kenneth Cole Productions had sales of $518 million, EBITDA of $55.6 million, excess cash of $10

Please show work via excel

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Stock Prices and Multiples for the Footwear Industry, January 2006 (TABLE 1)
Ticker	Name	Stock Price ($)	Market Cap ($ millions)	Enterprise Value ($ millions)	P/E	Price/Book	Enterprise Value/Sales	Enterprise value/EBITDA
NKE	Nike	84.2	21,830	20,518	16.64	3.59	1.43	8.75
PMMAY	Puma AG	312.05	5,088	4,593	14.99	5.02	2.19	9.02
RBK	Reebok	58.72	3,514	3,451	14.91	2.41	0.9	8.58
WWW	Wolverine World Wide	22.1	1,257	1,253	17.42	2.71	1.2	9.53
BWS	Brown Shoe	43.36	800	1,019	22.62	1.91	0.47	9.09
SKX	Sketchers	17.09	683	614	17.63	2.02	0.62	6.88
SRR	Stride Rite	13.7	497	524	20.72	1.87	0.89	9.28
DECK	Deckers Outdoor	30.05	373	367	13.32	2.29	1.48	7.44
WEYS	Weco Group	19.9	230	226	11.97	1.75	1.06	6.66
RCKY	Tocky Shoes & Boots	19.96	106	232	8.66	1.12	0.92	7.55
DFZ	R.G. Barry Corp.	6.83	68	92	9.2	8.11	0.87	10.75
BOOT	LaCross Footwear	10.4	62	75	12.09	1.28	0.76	8.3
TOTAL							12.79	101.83
AVERAGE							1.06583	8.48583
	(in Million's)
Sales	518
EBITDA	55.6
Cash	100
Debt	3
Shares outstanding	21

Req. a
KCP's Enterprise value (EV)	471.81
KCP's Market capitalization	568.81
Price per share	27.09

Req. b
Highest Average enterprise value to EBIDTA multiple	10.75
Lowest Average enterprise value to EBIDTA multiple	6.66
Highest share value	$ 33.08
Lowest share value	$ 22.25

Req. c
Price per share	$ 30.91

Req. d
Highest enterprise value to sales multiple	2.19
Lowest enterprise value to sales multiple	0.47
Highest share value	$ 58.64
Lowest share value	$ 16.21

B с. D E F G H Stock Prices and Multiples for the Footwear Industry, January 2006 (TABLE 1) Ticker Name Stock Price ($) Marke B (in Millions) Sales 518 EBITDA Cash Debt 55.6 100 Shares outstanding 21 Req. a KCPs Enterprise value (EV) KCPs Market ca

Add a comment

Answer 2

Similar Homework Help Questions

Table 1 Stock Prices and Multiples for the Footwear Industry,January 2006 Ticker Name Stock Price...

Table 1 Stock Prices and Multiples for the Footwear Industry,January 2006 Ticker Name Stock Price ($) Market Cap ($ Enterprise Value P/E Price/BookEnterprise Enterprise millions) (millions) Value/Sales 1.43 2.19 |value/EBITDA 84.2 21,830 5,088 58.723,514 1,257 800 683 497 373 230 106 20,518 16.643.59 ,593 14.995.02 3,451 14.912.41 2.71 1.91 2.02 1.87 367 13.322.29 22611.97 1.75 NKE PMMAY Puma AG RBKReebok WWWWolverine World Wide BWS 8.75 9.02 8.58 9.53 9.09 6.88 9.28 7.44 6.66 7.55 10.75 Nike 312.05 22.1 43.36 17.09...
Suppose that in January 2006 Kenneth Cole Productions had sales of $522 million, EBITDA of $59.6...

Suppose that in January 2006 Kenneth Cole Productions had sales of $522 million, EBITDA of $59.6 million, excess cash of $99 million, $4.3 million of debt, and 18 million shares outstanding. Use the multipless approach to estimate KCP's value based on the following data from comparable firms: a. Using the average enterprise value to sales multiple in the table above, estimate KCP's share price. b. What range of share prices do you estimate based on the highest and lowest enterprise...
Please help solve blue boxes. All information is given. Help solve using excel. Problem 10-18 Suppose...

Please help solve blue boxes. All information is given. Help solve using excel. Problem 10-18 Suppose that in July 2013, Nike had sales of $25,313 million, EBITDA of $3,254 million, excess cash of $3,337 million, $1,390 million of debt, and 893.6 million shares outstanding. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an...

Suppose that in July 2013, Nike Inc. had sales of $25,391 million, EBITDA of $3,261 million,...

Suppose that in July 2013, Nike Inc. had sales of $25,391 million, EBITDA of $3,261 million, excess cash of $3,332 million, $1,395 million of debt, and 899.2 million shares outstanding. Average Maximum Minimum 29.84 + 136% -62% Price Book 2.44 + 70% - 63% Enterprise Value Sales 1.12 + 55% - 48% Enterprise Value EBITDA 9.76 + 86% - 34% a. Using the average enterprise value to sales multiple in the table above, estimate Nike's share price. b. What range...
Suppose that in July 2013, Nike Inc. had sales of $25,339 million, EBITDA of $3,258 million, excess cash of $3,335mil...

Suppose that in July 2013, Nike Inc. had sales of $25,339 million, EBITDA of $3,258 million, excess cash of $3,335million, $1,383 million of debt, and 884.9 million shares outstanding. P/E Price / Book Enterprise Value / Sales Enterprise Value / EBITDA Average 29.84 2.44 1.12 9.76 Maximum +136% +70% +55% +86% Minimum -62% −63% -48% -34% a. Using the average enterprise value to sales multiple in the table above, estimate Nike's share price. b. What range of share prices do...
Suppose that in January 2006 Kenneth Cole Productions had EPS of $ 1.76 and a book...

Suppose that in January 2006 Kenneth Cole Productions had EPS of $ 1.76 and a book value of equity of $ 14.32 per share. Use the multiples approach to estimate? KCP's value based on the data from comparable firms given in the following? table: LOADING.... a. Using the average? P/E multiple from the table? above, estimate? KCP's share price. (Round to the nearest cent) b. What range of share prices do you estimate based on the highest and lowest? P/E...

In addition to footwear, Kenneth Cole Productions designs and sources handbags, apparel, and other accessories. You decide, therefore, to consider comparables for KCP outside the footwear industry. You also know the following about KCP: it has sales of $5

In addition to footwear, Kenneth Cole Productions designs and sources handbags, apparel, and other accessories. You decide, therefore, to consider comparables for KCP outside the footwear industry. You also know the following about KCP: it has sales of $518 million, EBITDA of $55.6 million, excess cash of $100 million, $3 million of debt, EPS of $1.65, book value of equity of $12.05 per share, and 21 million shares outstanding.a. Suppose that Fossil, Inc., has an enterprise value to EBITDA multiple of 10.31 and a P/E multiple of 15.81....
Consider the following data for the airline industry for December 2015 (EV=enterprise value, Book=equity book value)...

Consider the following data for the airline industry for December 2015 (EV=enterprise value, Book=equity book value) Suppose Hawaiian Airlines (HA) has 52.9 million shares outstanding. Estimate Hawaiian’s share value using each of the five valuation multiples in Table, based on the median valuation multiple of the other seven airlines shown. Market Capitalization Enterprise Value (EV) EV/Sales EV/EBITDA EV/EBIT P/E P/Book Delta Air Lines (DAL) 40857 45846 1.1x 6.0x 7.6x 15.0x 4.0x American Airlines (AAL) 27249...
Table 1 Consider the following data for the airline industry in early 2018 (EV = enterprise...

Table 1 Consider the following data for the airline industry in early 2018 (EV = enterprise value, BV = book value,NM = not meaningful because divisor is negative). P/E price-earnings ratio, P/S price-to sales, P/B price to book balue Table 2 December 28,2018 December 31,2017 Company Name Market Cap EV P/E (T) P/E (F) PEG P/S P/B EV/Sales EV/EBITDA EBIT EV/EBIT EBITDA Equity Delta Air Lines (DAL) 33.61 43.46 9.69 7.35 0.54 0.76 2.96 0.99 0.6 $5,855,000 7.423 Price EPS...

Determine the Value of the firm PNC using Discount CashFlow. Table 1. Balance Sheets, PNC and Industry ($ in Thousands...

Determine the Value of the firm PNC using Discount CashFlow. Table 1. Balance Sheets, PNC and Industry ($ in Thousands) PNC Benchmark Companies % of Assets 2002 2003 2004 $346 $507 $2,017 $3,622 $6,492 $14,512 $21,004 Cash ST securities Accounts receivable Inventories Current assets Net fixed assets Total assets % of Sales $478 $700 $2,786 $5,002 $8,966 $15,208 $24,174 $625 $625 $3,852 $6,023 $11,125 $18,098 $29,223 2.85% 1.00% 0.01% 5.00% 9.00% 15.01% 20.10% 0.01% 14.24% 25.64% 42.74% 57.26% 100.00% 35.11%...

Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...

Homework Answers

Add Answer to:
Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...

Post as a guest

Earn Coins

Table 1 Stock Prices and Multiples for the Footwear Industry,January 2006 Ticker Name Stock Price...

Suppose that in January 2006 Kenneth Cole Productions had sales of $522 million, EBITDA of $59.6...

Please help solve blue boxes. All information is given. Help solve using excel. Problem 10-18 Suppose...

Suppose that in July 2013, Nike Inc. had sales of $25,391 million, EBITDA of $3,261 million,...

Suppose that in July 2013, Nike Inc. had sales of $25,339 million, EBITDA of $3,258 million, excess cash of $3,335mil...

Suppose that in January 2006 Kenneth Cole Productions had EPS of $ 1.76 and a book...

In addition to footwear, Kenneth Cole Productions designs and sources handbags, apparel, and other accessories. You decide, therefore, to consider comparables for KCP outside the footwear industry. You also know the following about KCP: it has sales of $5

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

Table 1 Consider the following data for the airline industry in early 2018 (EV = enterprise...

Determine the Value of the firm PNC using Discount CashFlow. Table 1. Balance Sheets, PNC and Industry ($ in Thousands...

Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...

Homework Answers

Add Answer to: Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...

Post as a guest

Earn Coins

Add Answer to:
Please show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January...