Question: Please show all work (preferably complete in excel) Horan Industries last year produced free cash flow of 200 million. You forecast that they can grow

Please show all work (preferably complete in excel)

Horan Industries last year produced free cash flow of 200 million. You forecast that they can grow that free cash flow at 25% per year
for the next 2 years, then 10% for years 3 and 4, then at 3% for all periods starting in year 5. The company has cash of $200 million and has no debt.
The Beta of their stock is 1.1, the risk free rate is 2.5% and the market risk premium is 6%.
using a FCF model, what is the value of the shares today? Their shares outstanding is 50 million.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Ocean water is processed in a desalinization plant on the coast and transported by a pipeline to a city water plant 60 km inland as shown in Figure P6.23. Fresh water flows in the horizontal pipeline...

Q:

Horan Industries last year produced free cash flow of 200 million. You forecast that they can grow that free cash flow at 25% per year for the next 2 years, then 10% for years 3 and 4, then at 3% for...

Q:

Horan Industries last year produced free cash flow of 200 million. You forecast that they can grow that free cash flow at 25% per year for the next 2 years, then 10% for years 3 and 4, then at 3% for...

Q:

Horan Industries last year produced free cash flow of 200 million. You forecast that they can grow that free cash flow at 25% per year for the next 2 years, then 10% for years 3 and 4, then at 3% for...

Q:

Flippy Tech Inc. last year produced free cash flow of 700 million. You forecast that they can grow that free cash flow at 12% per year for the next 4 years, then at 4.0% for all periods starting in...

Q:

Flippy Tech Inc. last year produced free cash flow of 700 million. You forecast that they can grow that free cash flow at 12% per year for the next 4 years, then at 4.0% for all periods starting in...

Q:

Flippy Tech Inc. last year produced free cash flow of 700 million. You forecast that they can grow that free cash flow at 12% per year for the next 4 years, then at 4.0% for all periods starting in...

Q:

PLEASE SHOW ALL WORK You have been assigned the task of using the free cash flow model to estimate ABC Corporation's intrinsic value. ABCs WACC is 10.00%, its end-of-year free cash flow (FCF) is...

Q:

PLEASE SHOW WORK AND FORMULAS IF ANSWERED CORRECTLY WILL UPVOTE Basic Stock Valuation: Free Cash Flow Valuation Model The recognition that dividends are dependent on earnings, so a reliable dividend...

Q:

Please show all work and functions using excel General This case study is from the Corporate Finance book, chapter 8 in the eBook (pg. 653 in the hard copy, page 261 in eBook). The case study will...

Q:

if you could please show the work and formulas used. That would be great. Year 1 Tons Tax Rate Cast of Capital 4 5 6 7 8 In the table below, please forecast the Incremental free cash flows that would...

Q:

Use the following graph to answer the questions below. Let Y1 = cost function and Y2 = revenue function. a. Explain the significance of point (D, B). b. Explain the significance of point (E, A). c....

Q:

On June 24, 2009, the 2008 American Time Use Survey was released by the Bureau of Labor Statistics. Among the many statistics provided was information on leisure-type activities and the average...

Q:

Which of the following is not a true statement? Multiple Choice A minority interest can still elect members to the Board of Directors under Bondholders may force a corporation into bankruptcy for...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...