ck 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 esc STDEV Home Paste A A Microsoft Excel File Edit AutoSave Insert Draw Page Layout 1 Calibri (Body) B I UV x fx =F13 F1 B Question 1 Question 2 Point Accessibility: Investigate Q A Year 1 5+ N @ 2 F2 View 11 W Dividend 1=F13 2 3 4 Question 3 S Insert Format Tools Data Window C Formulas Data Review View Automate 20 points Total You are currently thinking about investing in Troy Inc. Shares are currently selling for $254 each. The most recent dividend was $4.50. The best growth forecasts you can find estimate the dividend will grow by 10% in each of the next 2 years, 15% in the third year, and 20% in the fourth year. After that, analysts believe the growth rate will settle on a constant growth rate beta of 0.3. What do you estimate the value of the stock is today? Given your estimate, would you buy the stock today? (Hint: think about how to get the 4%. The risk free rate is 5%, the return on the m