I need to do this one with my current excel sheet... plz help!

PROBLEM SET 3 Chapter 7-Equity Financing Assigned Problem 4 the risk-free rate is 6 percent and the market risk premium is 6 percent. The stock of Physicians Care Network (PON) has a beta of 1.5. The last dividend paid by PCN (DO was S2 share. 0 a. What would PCN's stock value be if the dividend was expected to grow at a constant -5 percent? 0%? 5% 1 Hint: First, use the SMI of the CAPM to show that the stock's required rate of return is 15%. 3 b. What would be the stock value if the growth rate is 10 percent, but PCN's beta falls to 1.0? 0.5 5