Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the questions using excel a) E1) The details of the common stock of Quant, Inc. are as follows. The last dividend that Quant

please answer the questions using excel image text in transcribed
a) 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. b) 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 (c). 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? e) a) 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. b) 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 (c). 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? e)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Entrepreneur's Growth Startup Handbook 7 Secrets To Venture Funding And Successful Growth

Authors: David N. Feldman

1st Edition

1118445651, 978-1118445655

More Books

Students also viewed these Finance questions