A stock you are interested in paid a dividend of $1.05 per share last year. The anticipated growth rate in dividends and earnings is 25.50%, 22.50%, and 16.90% for the next three years before settling down to a constant 2.40% growth rate. The discount rate is 11.10%. What is the current value of the stock?

Perform in Excel