Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if its possible can it be done on excel? please answer the questions using excel b) E1) The details of the common stock of Quant,
if its possible can it be done on excel? please answer the questions using excel b) E1) The details of the common stock of Quant, Inc. are as follows. The last dividend that Quant paid on its common stock two days ago was $1.80. Value Line estimates that Quant's dividend will grow at a constant rate of 6% per year indefinitely. Quant is very similar in risk profile to Hexta, Inc. whose B is estimated to be 1.28. The rate of return on 30-year T-bonds is estimated to be 5.19%, and the risk premium of the market portfolio over T-bonds is estimated to be 3.37%. Estimate the intrinsic value of Quant's common stock. If the stock is currently trading in the market at $52.29 per share, would you purchase the stock? What rate of return would you expect to earn at the $52.29 price? Suppose analysts estimate the dividends of Quant stock to grow at -3% for the first two years, 4% for three years after that, 5.8% for a year after, and then stabilize to a constant rate of 6% per year forever thereafter. What would be the intrinsic value of the stock today? If you expect to sell the stock in 4 years' time, what price can you expect to receive for the stock if the required rate of return on the stock is not expected to change? Assume that Quant stock is supernormal growth with the growth rates specified in part (c). If the stock is currently trading in the market at $48 per share, will you purchase the stock? Assume that Quant stock is supernormal growth with the growth rates specified in part (e). Suppose, in addition to the regular dividends that the stock pays, Quant expects to pay a special dividend of $2.67 per share for the next three years. What would be the intrinsic value of the stock now
if its possible can it be done on excel?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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