Suppose that a company paid $ 3 per share dividend last year, its dividend is expected to grow at 11 percent for the next 5 years and 2 percent thereafter. If its cost of equity is 10 percent, what is the intrinsic value of this stock using non-constant growth dividend discount model?
Possible Answers
60.97
52.65
49.88
55.43
47.11
Can you please do this by hand and also show me how to do it in excel (set by set)? Much appreciated