Question

In: Finance

You are asked to compute the free cash flows of a company for the next 5 years. You receive the following relevant selected

You are asked to compute the free cash flows of a company for the next 5 years. You receive the following relevant selected information from the incremental earnings forecast:

 

In additon, you know that 15% of sales and costs of goods sold must be allocated to the working capital. The weighted average cost of capital is 7%. The company expects a growth rate of its free cash flows of 2% after year 5.

a) Compute the free cash flows of the company!

b) What is the estimated firm value of the company using the Discounted Free Cash Flow Model?

Solutions

Expert Solution

  Year 0 1 2 3 4 5
  1.Sales   25.74 25.25 24.96 25.69  
  2.Working capital(Sales*15%)(Ln.1*15%) -3.861 -3.7875 -3.744 -3.8535 0 0
               
  3.COGS   15.44 15.15 14.98 15.41  
  4.Working capital(COGS*15%)(Ln.3*15%) 2.316 2.2725 2.247 2.3115 0 0
               
  5.NWC (2+4) -1.545 -1.515 -1.497 -1.542 0 0
  6.Change in NWC(Prev.-Current)   -0.03 -0.018 0.045 -1.542 0
               
  7.Unlevered net income   7.42 7.9 7.37 5.9 6.84
  8.Depreciation   0.64 0.64 0.64 0.64 0.64
a. 9.Free Cash Flows(6+7+8)             8.03 8.522 8.055 4.998 7.48
               
               
  10.Terminal FCFs(7.48*1.02/(7%-2%)           152.592
  11.Total FCFs(9+10)   8.03 8.522 8.055 4.998 160.072
  12.PV F at 7%(1/1.07^ yr.n)   0.93458 0.87344 0.81630 0.76290 0.71299
  13.PV at 7%(Ln.11*12)   7.504673 7.443445 6.575279 3.81295 114.1291
b. 14.NPV at 7%(Sum of Ln.13) 139.46547          
  ie. 139.47          

Related Solutions

You are asked to compute the free cash flows for a project with a duration of...
You are asked to compute the free cash flows for a project with a duration of 4 years. You receive the following relevant selected information: 0 1 2 3 4 5 Sales - 22.97 22.97 22.97 22.97 - Costs of goods Sold - 12.72 12.72 12.72 12.72 - Unlevered Net Income −6.56 4.71 3.45 7.35 3.96 −1.77 Depreciation - 2.95 2.95 2.95 2.95 2.95 In addition you know that 15% of sales and costs of goods sold are entering and...
Company A has the following free cash flows for the next three years: FCF1=-20million, FCF2=30million, and...
Company A has the following free cash flows for the next three years: FCF1=-20million, FCF2=30million, and FCF3=40million. After year 3, FCF is expected to grow at a constant 7% rate. WACC is 13%. What is the horizon value?What is the firm’s value today?Suppose the company has $100 million in debt and 10 million shares of stock outstanding. What is the firm’s estimated intrinsic value per share of common stock?
You expect ABC Corporation to generate the following free cash flows over the next five years:...
You expect ABC Corporation to generate the following free cash flows over the next five years: Year 1 2 3 4 5 FCF ($ millions) 75 84 96 111 120 Beginning with year six, you estimate that ABC's free cash flows will grow at 6% per year and that ABC's weighted average cost of capital is 15%. If ABC has $500 million of debt, $50 million of cash, and 14 million shares of stock outstanding, then what is the price...
The company you want to acquire has the following cash flows for the next five years....
The company you want to acquire has the following cash flows for the next five years. Assume that the cost of equity is 15.5% and the firm can borrow long term at 12% (Tax rate for the firm is 50%). The current book value of equity is $1300 and the book value of debt outstanding, which sells at par value, is $700 (book value of debt = market value of debt). The company has 50 shares. Year FCF to Firm...
UBTECH Robotics is expected to generate the following free cash flows over the next five years....
UBTECH Robotics is expected to generate the following free cash flows over the next five years. After which, the free cash flows are expected to grow at the industry average of 3% per year. Using the discounted free cash flow model and the weighted average cost of capital of 11% UBTECH Robotics FCF Forecast ($ Millions) Year 1999, 2000, 2001, 2002, 2003, 2004 FCF (Amount in Millions)$55, $45, $89, $102, $84, $87 a. Estimate the enterprise value (V0) of UBTECH...
Forecast Apple's free cash flows for each of the next five years based on Apple's free...
Forecast Apple's free cash flows for each of the next five years based on Apple's free cash flow for 9/24/2016 and 9/30/2017. Assume that the changes in operating assets and liabilities is $0 for each of the years in your forecast period (9/30/18 - 9/30/22).
The company has the following free cash flows for the next 4 years FCF1=-100, FCF2=-55, FCF3=-40,...
The company has the following free cash flows for the next 4 years FCF1=-100, FCF2=-55, FCF3=-40, FCF4=150, after year 4, the growth rate of the FCF will be 10%, and the WACC=15%, then what the firm value should be?
A company is forecasted to generate free cash flows of $45million for the next three...
A company is forecasted to generate free cash flows of $45 million for the next three years. After that, cash flows are projected to grow at a 2.5% annual rate in perpetuity. The company's cost of capital is 12.3%. The company has $66 million in debt, $7 million of cash, and 13 million shares outstanding. What's the value of each share?
A company is forecasted to generate free cash flows of $21million next year and $24...
A company is forecasted to generate free cash flows of $21 million next year and $24 million the year after. After that, cash flows are projected to grow at a stable rate in perpetuity. The company's cost of capital is 8.1%. The company has $48 million in debt, $17 million of cash, and 28 million shares outstanding. Using an exit multiple for the company's free cash flows (EV/FCFF) of 14, what's your estimate of the company's stock price?a. 30.8b. 26.8c....
A company is forecasted to generate free cash flows of $53 million for the next three...
A company is forecasted to generate free cash flows of $53 million for the next three years. After that, cash flows are projected to grow at a 2.2% annual rate in perpetuity. The company's cost of capital is 12.8%. The company has $54 million in debt, $6 million of cash, and 13 million shares outstanding. What's the value of each share? a. 33.4 b. 71.4 c. 32.7 d. 39.1 e. 45.0
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT