Jia's Fashions recently paid a $2 annual dividend. The company is projecting that its dividends will grow by 20 percent next year, 12 percent annually for the two years after that, and then at 6 percent annually thereafter. Based on this information, how much should Jia's Fashions common stock sell for today if her required return is 10.5%?
How would you find this on excel.