Question

Consider the following data for Nike Inc: In 2009 it had $19,000 million in sales with a 10% growth rate in 2010, but then sl
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Base-case valuation table:

Formula 0 2009 Time (n) Year Growth rate (g) Sales (5) EBIT Increase in NWC 1 2010 10.00% 21010.01 2101.0 191.00 2 2011 9.00%

Using this base-case table, by varying the required numbers, range of prices can be found, for the given sub-parts.

a). Lowest share price = $66.49 (at initial growth rate of 7%)

Highest share price = $72.94 (at initial growth rate of 11%)

b). Lowest share price = $64.12 (at initial revenue EBIT margin of 9%)

Highest share price = $78.44 (at initial revenue EBIT margin of 11%)

c). Lowest share price = $51.98 (at a WACC of 12%)

Highest share price = $78.79 (at a WACC of 9.50%)

d). Lowest share price = $58.24 (initial growth rate of 11%, initial EBIT margin of 11% and WACC of 12%)

Highest share price = $66.05 (initial growth rate of 7%, initial EBIT margin of 9% and WACC of 9.50%)

Note: Due to the answer word limit constraint, valuation tables for all scenarios have not been posted.

Add a comment
Know the answer?
Add Answer to:
Consider the following data for Nike Inc: In 2009 it had $19,000 million in sales with...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following data for Nike Inc.: In 2009 it had $19,300 million in sales with a 10% growth rate in 2010, but...

    Consider the following data for Nike Inc.: In 2009 it had $19,300 million in 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 net working 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 Nike​ Inc.: In 2009 it had $19.100 million in sales with a 10​% growth rate in​ 2010, bu...

    Consider the following data for Nike​ Inc.: In 2009 it had $19.100 million in 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 net working 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 Nike Inc : In 2009 it had $19.300 million in sales...

    Consider the following data for Nike Inc : In 2009 it had $19.300 million in sales with a 10% growth rate in 2010, but then slows by 1% to the long-un growth ate of 5% by 2015, Nike expects EBIT to be 10% of sales, increases in net working capital requirements to be 10% of any increases equal depreciation expenses. Nike also has $2.300 million in cash, $32 million in debt, 486 million shares outstanding, a tax rate of 24%,...

  • Consider the following data for Nike Inc. In 2009 it had $19.100 million n sales with a 10% growt...

    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 Nike Inc. In 2009 it had S19, 150 million in sales...

    Consider the following data for Nike Inc. In 2009 it had S19, 150 million in sales with a 10% growth ate in 2010 but then slows by 1% to the long un gowth rate of 5% by 2015 Nike expects E Tto be 10% sales ncreases nne work ng capital equ ements to be 10% of any creases n sales and capital expenditures to equal depreciation expenses. Nike also has S2.300 million in cash $32 million in de 486 million...

  • 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,335​mil...

    Suppose that in July​ 2013, Nike Inc. had sales of $25,339 million, EBITDA of $3,258 ​million, excess cash of $3,335​million, $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...

  • Sora Industries has 70 million outstanding shares, $121 million in debt, $53 million in cash, and...

    Sora Industries has 70 million outstanding shares, $121 million in debt, $53 million in cash, and the following projected free cash flow for the next four years: 433.0 Earnings and FCF Forecast ($ million) 1 Sales 2 Growth vs. Prior Year 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 40% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow...

  • this is business 241 question... need help P 10-8 (similar to) Sora Industries has 65 million outstanding shares, $123 million in debt, $46 million in cash, and the following projected free ca...

    this is business 241 question... need help P 10-8 (similar to) Sora Industries has 65 million outstanding shares, $123 million in debt, $46 million in cash, and the following projected free cash flow for the next four years: Year012 3 4 Earnings and FCF Forecast (s million) 1 Sales 433.0 468.0 516.0547.0 574.3 2 Growth vs. Prior Year 8.1% 10.3% 6.0% 5.0% 3 Cost of Goods Sold 4 Gross Profit (313.6) (345.7) (366.5) (384.8) 154.4 180.5 (93.6) (103.2) (109.4) (114.9)...

  • 3.6 FCF Forecast ($ million) Year 0 1 2 3 4 Sales 240 270 290 310...

    3.6 FCF Forecast ($ million) Year 0 1 2 3 4 Sales 240 270 290 310 325.5 Growth vs. Prior Year 12.5% 7.4% 6.9% 5.0% EBIT (10% of Sales) 27.00 29.00 31.00 32.55 Less: Income Tax (37%) (9.99) 10.73 11.47 12.44 Less: Increase in NWC (12% of Change in Sales). 24 24 1.86 Free Cash Flow 13.41 15.87 17.13 18.65 Banco Industries expect sales to grow at a rapid rate over the next three years, but settle to an industry...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT