Please solve in Excel

3. 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 remain constant (i.e., g = 0) indefinitely.

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

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