Suppose the Price/Earnings Ratio for the S&P 500 is 15 and the dividend payout ratio of the S&P 500 is 38%. The future growth rate of dividends is expected to be 3.7%.

1. Use Goal Seek or Solver (identify which you choose) to determine the dividend growth rate that would yield an expected Market return of 7%.