Problem:
A stock that currently trades for $50 per share is expected to pay a year-end dividend of $2 per share. The dividend is expected to grow at a constant rate over time. Beta is 1.2, risk-free rate is 5%, and market risk premium is 5%. What is the stock's expected price seven years from today? (Please include formula in Excel)