Using excel Suppose the Price$/$Earnings Ratio for the S&P $500$ is $18$ and the dividend payout ratio of the S&P $500$ is $25\%.$ The future growth rate of dividends is expected to be $2\mathrm{.}50\%.$

a$.$ Use Goal Seek or Solver to determine

the dividend growth rate that would yield

an expected Market return of $7\%.$

Use excel and show the formulas used in each cell please.