Consider the stock of Davidson Company that will pay an annual
dividend of $2 in the
coming year. The dividend is expected to grow at a constant rate of 5
percent permanently.
The market requires a 12-percent return on the company.
a. What is the current price of a share of the stock?
b. What will the stock price be 10 years from today?

I need the answer in Excel spreadsheet, thanks.

These questions are starting to worry me.  What if my financial
advisor didn't do her own homework when she was in school?

Well, at least these Qs (and other similar ones) look like they come
from UNDERGRAD level finance courses. They'll have to learn the
material, for real, before they have the chance to do any damage.

When I see questions that are clearly lifted from advanced finance
texts, used this semester by some of the top MBA programs in the
country, THAT'S when I start to worry.