Please show me the math in Excel

Kramerica Industries paid $ 2.53

$2.53 per share in dividends yesterday. Its dividends are expected to grow steadily at 6 %

6% per year. If the required return is 7.4 %

7.4%, what is the estimate of thestock's price 1 year from now (P1)?

If the required return is 7.4 %

7.4%, the estimate of thestock's price 1 year from now (P1) should be $

203.05