*PLEASE SHOW FORMULAS CLEARLY So I can recreate in Excel AND BRIEFLY WRITE OUT RATIONALE FOR ANSWERs to F

Thank you.

Cool Shoes (CS) had 2014 sales of $518 million. You expect sales to grow at 9% next year (2015), but, decline by 1% per year after until you settle to a long-run growth rate of 4%. You expect EBIT to be 9% of sales, increases in net working capital requirements to be 10% of any increase in sales (hint: just the increase from the prior year), and net investment to be 8% of any increase in sales. (Note: this is in excess of depreciation). Other 2014 data for Cool Shoes:

EPS = $1.65

Book value of equity = $$12.05 per share

EBITDA = $55.6 million

Excess cash = $100 million

Debt = $3 million

Shares outstanding = 21 million

Requirements formulas must show clearly they were calculated in excel where possible.

a) Using the DCF method, determine the enterprise value of CS. (Hint: Dont forget the terminal value).

b) Using the answer from part a), what is the price per share?

c) Using the information from the comparable stock prices and multiples table above, estimate the price per share using the average P/E multiple.

d) Using the information from the comparable stock prices and multiples table above, estimate the price per share using the average Enterprise Value to sales multiple.

e) Using the information from the comparable stock prices and multiples table above, estimate the price per share using the average Enterprise Value to EBITDA multiple.

f) What range of prices do you estimate based on your analysis in Reqs b-e? Summarize the Low, High, and Average.