Question

please describe any excel formulas used

Apple is 8% per year Use the dividend-UISCOUN T O Usuatu s Value pur Share ale 13. Proctor and Gamble Company has just paid an annual dividend of $2.50. Analysts are predicure to grow by $0.12 per year over the next five years. After then, Proctor's earnings are expected to go year, and its dividend payout rate will remain constant. If Proctors' equity cost of capital is 8.5% pery price does the dividend-discount model predict Proctors' stock should sell for today? Predicting dividends led to grow 6% per per year, what

Answer 1

Hence Proctor's stock should sell today for $ 91.9 or say $92 as per Dividend discount model.

Calewation of Price of stook today As we know that Price of stock a Di D2 D3 D4 D5 L (1tk)' (hky) (1+kz) litky) '(tkr) (145 where, Pasip of stock - Annual dividend payment ka Capitalization rate ms No. of you untill stack is sold → 2.56 +0.12 (1 +0:085) 2.50+0.12*2) 11+0:085)?' 2.50 +(0:12X3), 2.50 + (0-12X4) (1+0.085)3 11 +0.085)4 2.540.)2XS) (1+0.0esys + 13lofo 11+0.085) 2.62 2.74 2.86 (1.085)? 2.98 11.08) T (1.0852 3.10 131.60 (1.0855 (1.0856 11.085) 7 - 91.86 OR$91.9 W.N Calculation of Price as on brayears P = D5(lt) 3.10 (17 0.06) 0,085 - 0,06 9 3.29 37131.601$ 0.025