Please help solve blue boxes. All information is given. Help solve using excel.
Solution:
Summary:
a. (i) Enterprise Value (Mn) = $ 51,385.39 Mn
a. (ii) Share Price Estimate = $ 59.68
b. (i) Highest Enterprice Value to Sales = 2.13
b. (ii) Lowest Enterprice Value to Sales = 2.03
I . The values provided in the Qs:
(Mn- Million)
Sales= $ 25,313 Mn
EBITA= $ 3254 Mn
Cash = $ 3337 Mn
Debt= $1390 Mn
Shares Outstanding= $ 893.6 Mn
II . Formula's Used:
1. Enterprise Value to Sales= Enterprise Value/ Sales
2. Enterprise Value = Market Capitalisation + Debt - Cash & Cash Equivalent
III. Using Values provided in the Question:
a. (i) Enterprise Value (Million)
Giv =>
Average Enterprise Value to Sales Multiple = 2.03 (Tab 10.3)
Sales= $ 25,313 Mn
Enterprise Value / Sales = 2.03
Therefore , Enterprise Value = 2.03 * 25,313
=51,385.39 Mn
(ii) Share Price Estimate
Enterprise Value = Market Capitalisation + Debt - Cash & Cash Equivalent
51,385.39 = Market Capitalisation + 1390 - 3337
Market Capitalisation = 53,332.39
Nos. of Shares = 893.6
Therefore, Share Price Estimate = $ 59.68
b.
(i) Highest Enterprice Value to Sales
Giv in Table 10.3 => Enterprise Value = $ 54,023 Mn
Sales => $ 25,313 Mn
Highest Enterprise Value / Sales = 54,023 / 25,313
= 2.13
(i) Lowest Enterprice Value to Sales
Giv in Table 10.3 => Enterprise Value / Sales = 2.03
Summary:
a. (i) Enterprise Value (Mn) = $ 51,385.39 Mn
a. (ii) Share Price Estimate = $ 59.68
b. (i) Highest Enterprice Value to Sales = 2.13
b. (ii) Lowest Enterprice Value to Sales = 2.03
Note:
1. Due to mulitple subparts, we are subject to a maximum of the first 4 subparts. Hence, remaning subparts not answered.
2. Excel answer are not possible, hence typed answers are given.
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, 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,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 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 show work via excel Table 1 Stock Prices and Multiples for the Footwear Industry, January 2006 Ticker Name Stock Price ($) Market Cap ($ Enterprise Value P/E Price/Book Enterprise Enterprise millions) ($ millions) Value/Sales 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...
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 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...
Please help solve blue boxes. Problem 10-6 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 absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a...
Consider the following data for Nike Inc. In 2009 it had $19.100 million n sales with a 10% growth rate in 2010, but then slows by 1 % to the long-run growth rate of 5% by 2015. Nike expects EBIT to be 10% of sales increases in networking capital requirements to be 10% of any increases in sales and capital expenditures to equal depreciation expenses. Nike also has $2.300 million in cash, $32 million in debt 486 million shares outstanding,...
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...
Please help me do this if you know, thank you very much and please step by step that makes me better understand. 1. Valuation of Firms The private equity firm Greylock Group LLC is looking to sell a stake in the automotive manufacturer VRT Automotive Co, a relatively new entrant in the auto parts manu- facturing industry, via an initial public offering (IPO). Greylock acquired its stake in VRT several years ago and has been able to improve the efficiency...