Question
Corinth Corp. is an early-stage firm that does not pay any dividends and has no plans to pay dividends in the near future. As an
Corinth Corp. is an early-stage firm that does not pay any dividends and has no plans to pay dividends in the near future. As an analyst, you have been charged with assessing the value of Corinth Corp. common stock using a corporate valuation technique based on free cash flows. You have projected that Corinth Corp.s free cash flows over the next five years will be as follows:
- Year 1 $1,500,000
- Year 2 $2,500,000
- Year 3 $4,000,000
- Year 4 $6,500,000
- Year 5 $8,250,000
After the fifth year, future free cash flows are expected to grow at a constant rate of 5.0%. Corinth Corp. has a WACC of 8.0%, debt outstanding of $10,000,000 and existing preferred stock outstanding with a market value of $45,000,000.
If Corinth Corp. has 8.5 million shares of common stock outstanding, what is the firms estimated value per share of common stock?
Please complete this problem using Excel and submit your solution as an Excel file via Sakai by November 12th at 8:30 a.m. You may complete this assignment individually or in teams of two or three students.
As we have previously discussed, be sure to isolate your input (g, WACC, # of shares, etc.) in your spreadsheet so that any assumptions of the problem can be readily changed (i.e., do not embed input into your formulas your formulas should use cell references). Also, remember to format your spreadsheet for printing prior to submission.
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