Please show me how to do this using excel you do not expect there to be a dividend paid on a share of common stock next year. after that you expect a $2 dividend that will grow at a constant rate of 6% there after. how much would you pay for the stock assuming a cost of equity of 10%.