E. Using the GEONIE AN Function , calculate the compound average quarterly growth rate . What is the annualized growth rate ?" C. Using the capital asset pricing model , calculate the Expected rate of return for The Coca-cola Company's common stock . Note that for stock ] , R; = RF + Bi (\RM - RF ) I'VE the field on a 10 - Year LT. S . Treasury note For the risk - Free rate . For the Expected return on the market portfolio , use the compound average rate of return on the SUP 500 Index Note that this information and the beta for The Coca - Cola Company's common Stock are provided D. C Calculate the Expected total dividend For 2018 by annualizing the most recent quarterly dividend and multiplying by one plus the annualized growth rate . DividendzoIs = Dividend2017 (. 1 + Annualized compound average growth rate ) E. I'VE the constant-growth dividend discount model to Estimate the intrinsic Value of the Common Stock OF The Coca - Cola Company . F . ` L'SE an IF Function to indicate whether the stock is overvalued or undervalued in the market . relative to the intrinsic value calculated in part E. Note that answering this question will require that You obtain the current stock price . } . Pinnacle Corporation has a retention ratio of 60%/} . West rear it will Earn $ 2. 00 per share and have a return on Equity Of 13%/} . Shareholders" required rate of return is 1 1 %/0 .` A. Calculate the growth rate For Pinnacle Corporation's Earnings per share [EPS )` E. Using the earnings model, what is the value of the company's stock ?" Calculate the stock's no- growth value and the present value of growth opportunities ( PVGO). C. Construct a data table that shows the growth rate and PVGO For different values OF ROE. ranging from 10^/{ to 25%' , in One percentage - point increments . D. Create a data chart that shows the relation between a stock's value , retention ratio , and ROE L'sE values of 30%/} and 70%/ For the retention ratio and 5%/ 6 and 15% For ROE E. I'VE the data to create a scatter chart ( with smooth lines ) to show the relationship between the value of the stock and ROE . Is the relationship linear ?" At what point does the model break down ?"