As a Wealth Manager at Crimson Wealth, you are responsible for making recommendations to clients regarding common stocks. Your research on Core Inc, shows that dividend has been growing at a rate of 10% per year to the current dividend (D0) of $1.75 per share. The stock is now selling for $45 per share, and you believe that an appropriate discount rate of return for this stock is 15%

A. If you expect that the dividend will grow at 10% rate into the foreseeable future, what is the highest price at which you would recommend purchasing this stock for your clients? You are free to use whichever method you are most comfortable with! If you need additional "scratch paper", you may use the "ScratchSheet"

B. Supposed now that you believe that Core's new computer chip will rival Pentel's, resulting in higher growth in the near future. Your new estimate is for a 5 year period of 30% annual growth followed by a return to the historical growth rate of 10%. Under these new assumptions, what is the value of the stock using the two stage dividend growth model? Calculate this price both manually and using the FAME_TwoStageValue function.

THE TABLE GOES TO 300

You can just skip the FAME formula

Dividend at time 0 (Do) |Market Capitalization Rate (RRR) Growth Rate of Div. (G) Stock Price $1.75 15.00% 10.0% $45.00 PO Using an IF statement to determine your answer will earn a bonus point: Overvalued/Undervalued? Use Vlookup when determining the Growth Rates for a bonus point: Bonus point Time Div Growth Rate PV at time 0 2 3 4 5 6 7 8 9 10 Growth rate of Dividend Growth Rate Beginning Period 1 30.00% 6 10.00% Po |Using Fame Add-in Using an IF statement to determine your answer will earn a bonus point: Over/Undervalued? Bonus point