SOLVE USING EXCEL PLEASE SHOW EQUATIONS.

Determine the price of a share of stock whose last annual dividend payment (D0) was $2.10, assuming a required rate of return of 10% and considering the following:

1) The dividend payment is expected to grow at a constant rate of 4% per year indefinitely.

2) Compare the calculated intrinsic value in part 1) with the current price of $27. Use an IF statement to assess whether the stock is undervalued, overvalued, or fairly valued.