finance help

Dividend Growth Model Inputs Latest Dividend DO 0.97 Dividend at t-N 0.50 Numberofyears between Dividends N 24 Inputs Risk Free Rate Expected Market Retum 10% Beta Output 13 15 16 17 19 25 31 Output Calculated Growth Rate Ex ected Next Period Dividend Inputs Dividend Growth Rate Next Period Dividend Required Rate of Retum Outputs Price at Time 0 PO Inputs Dividend Growth Rate Next Period Dividend Required Rate of Retum 3% 1.00 3% 1.00 Calculated Required Rate of Retum Input Next Period Dividend Required Rate of Retum Price at Time O- PO Outputs Dividend Growth Rate s 1.00 s 15.00 $ 15.00 Price at Time O PO Outputs Re uired Rate of Retum