Excel Online Structured Activity: Constant growth analysis to answer the question below. Constant growth

Calculate required return:

Required return on common stock

Calculate constant growth rate, $g$ :

Total return on common stock

Expected dividend yield

Expected capital gains yield

Calculate stock price in $3$ years, $P_3$ :

Number of years from today

Calculate $P_3$ using $P_0$

Alternative calculation:

Calculate $P_3$ using dividends

Open spreadsheet

$