Bear's Outdoor Wilderness Outfitters currently pays a $4.50 common stock dividend. Jennifer is considering an investment in Bear's Outdoor Wilderness Outfitters and plans to hold the stock for four years at which time she expects to sell the stock for $70.00. She expects the dividend to increase to $5 one year from now and then grow at an 8% rate for the next five years what is the current value of Bear's Outdoor Wilderness Outfitters common stock to Jennifer if she requires a 15% return rate of return?

Can you please fill out the spread sheet and show the formula used to get the answer!

\f