Use the “Campspell” spreadsheet to complete this problem. Yo…
Use the “Campspell” spreadsheet to complete this problem. You are valuing Campspell’s, one of your favorite food companies. The company is expected to pay a dividend of $12 this year. The dividends are expected to grow at 7% for the next six years and then at 5% forever thereafter. If the company has a 12% required return on equity, what is your estimated stock price based upon this data? Format: round to the nearest cent and format as $XXX.XX or $X.XX with no leading 0’s with the $.