Question

In: Finance

Widget Inc. is expected to have the following free cash flows: Year 1 2 3 4...

  1. Widget Inc. is expected to have the following free cash flows:

Year

1

2

3

4

5

FCF $Millions

22

27

32

36

38

After then, the free cash flows are expected to grow at the industry average of 5% per year. Using the discounted free cash flow model and the weighted average cost of capital of 10%:

a. Estimate Widget Inc. enterprise value

b. If Widget Inc. has 10 million in cash, 3 million in debt, and 10 million shares outstanding what is their estimated share price?

Solutions

Expert Solution

Following table shows the calculation of enterprise value:

Year FCF $Millions Discount factor Discounted CF
1 22 1/1.10^1 = 0.909090909 22*0.909090909090909 = 20
2 27 1/1.10^2 = 0.826446281 27*0.826446280991735 = 22.31404959
3 32 1/1.10^3 = 0.751314801 32*0.751314800901578 = 24.04207363
4 36 1/1.10^4 = 0.683013455 36*0.683013455365071 = 24.58848439
5 38 1/1.10^5 = 0.620921323 38*0.620921323059155 = 23.59501028
5 798 1/1.10^5 = 0.620921323 798*0.620921323059155 = 495.4952158
Enterprise Value= sum of all Discounted CF = 610.0348337
  • As after year 5 the FCF are expected to grow at 5% for perpetuity, we need to calculate the terminal value using the following formula
  • We have calculated the enterprise value as $ 610.0348337 million
    • Enterprise value = Market value of Equity+Market value of Debt - Cash and cash equivalents
    • 610.0348337 million = Market value of Equity + 3 million -10 million
    • Market value of Equity = 610.0348337 - 3 million -+10 million = 617.0348337 million
    • Per share price = Market value of Equity / number of shares = 617.0348337 million/ 10 million = $61.70348337

Related Solutions

Covan, Inc. is expected to have the following free cash? flow: Year 1 2 3 4...
Covan, Inc. is expected to have the following free cash? flow: Year 1 2 3 4 FCF 11 13 14 15 Grow by 4 % per year a. Covan has 8 million shares outstanding, $2 million in excess cash, and it has no debt. If its cost of capital is 12 %, what should be its stock price? b. Covan reinvests all its FCF and has no plans to add debt or change its cash holdings (it does not invest...
Covan, Inc. is expected to have the following free cash? flow: Year 1 2 3 4...
Covan, Inc. is expected to have the following free cash? flow: Year 1 2 3 4 FCF 13 15 16 17 Grow by 3 % per year a. Covan has 6 million shares? outstanding, ?$3 million in excess? cash, and it has no debt. If its cost of capital is 10 %?, what should be its stock? price? b. Covan reinvests all its FCF and has no plans to add debt or change its cash holdings? (it does not invest...
​Covan, Inc. is expected to have the following free cash​ flow: Year 1 2 3 4...
​Covan, Inc. is expected to have the following free cash​ flow: Year 1 2 3 4 times times times••• FCF 1010 1212 1313 1414 Grow by 3 %3% per year a. Covan has 88 million shares​ outstanding, ​$44 million in excess​ cash, and it has no debt. If its cost of capital is 11 %11%​, what should be its stock​ price? b. Covan adds its FCF to​ cash, and has no plans to add debt. If you plan to sell...
​Covan, Inc. is expected to have the following free cash​ flow: Year 1 2 3 4...
​Covan, Inc. is expected to have the following free cash​ flow: Year 1 2 3 4 times times times••• FCF 10 12 13 14 Grow by 5%per year a. Covan has 8 million shares​ outstanding, ​$3 million in excess​ cash, and it has no debt. If its cost of capital is 13%​, what should be its stock​ price? (round to nearest cent) b. Covan adds its FCF to​ cash, and has no plans to add debt. If you plan to...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 -$ 152 $22 $39 $58 $82 Project 2          −826 0 0 7,010 −6,506 Project 3 21 41 61 80   −247 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest1%​). c. What is the NPV of each project if the cost of capital is 5%​?20 %50%​? a. For which of these...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 −$151 $ 21 $ 39 $ 59 $ 80 Project 2                                                −824 00 00 6,999 −6,501 Project 3 2020 40 62 81 −245 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest 1%​). c. What is the NPV of each project if the cost of capital is 5%​? 20%​? 50%​? a....
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4...
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4 CFA −$2,050    $750    $760    $770    $780 CFB −$4,300 $1,500 $1,518 $1,536 $1,554 Both projects have a required return of 10.25%. What are NPV and IRR of the two projects? If project A and B are mutually exclusive, what is your decision with regard to accepting vs. rejecting each project? Why? What is the crossover rate?
Hadley Inc. forecasts the year-end free cash flows (in millions) shown below. Year 1 2 3...
Hadley Inc. forecasts the year-end free cash flows (in millions) shown below. Year 1 2 3 4 5 FCF -$22.95 $38.5 $43.9 $52.2 $56.4 The weighted average cost of capital is 10%, and the FCFs are expected to continue growing at a 3% rate after Year 5. The firm has $24 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 21 million shares outstanding. What is the value of the stock price...
Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4...
Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4 775,000 5 775,000 Year Project B Expected Cash Flows ($) 0 (1,050,000) 1 650,000 2 500,000 3 226,250 4 137,500 5 62,500 Metrics Payback Period (in years) (A)3.54 (B)1.8 Discounted payback period (in years) (A)4.58 (B)2.72 Net Present Value (NPV) (A)$160,816 (B)$151,742 Internal Rate of Return (A)18.90% (B)23.84% Profitability Index (A)1.13 (B)1.14 Modified Internal Rate of Return (MIRR) (A)17.82% (B)18.15% a). What are some...
You have 3 projects with the following cash​ flows: Year    0       1   2     ...
You have 3 projects with the following cash​ flows: Year    0       1   2      3         4 Project 1   -$149   $19   $42   $61      $79 Project 2   -827      0   0   7,002   -6,508 Project 3   18          39   62   81      -247 a. For which of these projects is the IRR rule​ reliable?_______. b. Estimate the IRR for each project​ (to the nearest 1 %​).________. c. What is the NPV of each project if the cost of capital is 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT