Question
Curran Inc. forecasts the free cash flows (FCFs) (in millions) shown below. The weighted average cost of capital (WACC) is 12%, and the FCFs are
Curran Inc. forecasts the free cash flows (FCFs) (in millions) shown below. The weighted average cost of capital (WACC) is 12%, and the FCFs are expected to continue growing at a 5% rate after Year 4. The firm has $421.25 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 50 million shares outstanding.
Year | 1 | 2 | 3 | 4 |
FCF | $90 | $150 | $240 | $300 |
a. What is the estimated stock price today (Year 0)? b. Set up a simple Excel data table where you show how the estimated intrinsic value varies as the long-run growth rate varies over the following range (4.00%, 4.25%, 4.50%, 4.75%, 5.00%, 5.25%, 5.50%, 5.75%, 6.00%, 6.25%, 6.50%, and 6.75%) assuming everything else stays constant. When correctly set up, an Excel Data Table will automatically recalculate when input variables are changed. Refer to Useful Excel Tools in the Start Here module on the Canvas website for the Excel Tools file and Data Table video explaining how to create data tables.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started