80.2K

Verified Solution

Link Copied!

please answer on Microsoft Excel parts a,b,c,d,e

You are interested in purchasing the common stock of Azure Corporation. The firm recently paid a dividend of $3 per share. It expects its earnings-and hence its dividends-to grow at a rate of 7% for the foreseeable future. Currently, similar-risk stocks have required returns of 10%. TO DO a. Given the data above, calculate the present value of this security. Use the constant-growth model (Equation 7.5 ) to find the stock value. b. One year later, your broker offers to sell you additional shares of Azure at $73. The most recent dividend paid was $3.21, and the expected growth rate for earnings remains at 7%. To determine the required rate of return, you decide to use the capital asset pricing model (CAPM). The risk-free rate, RF, is currently 5.25%; the market return, km, is 11.55%; and the stock's beta, bAzure is 1.07. Substitute the appropriate values into the CAPM (Equation 5.8 ) to determine the firm's current required return, kAzure c. Applying Equation 7.5, determine the value of the stock using the new dividend and required return from part b. d. Given your calculation in part c, would you buy the additional shares from your broker at $73 per share? Explain. e. Given your calculation in part c, would you sell your old shares for $73 ? Explain

Answer & Explanation Solved by verified expert

See Answer