Question 4 Input area: Dividend next year Dividend growth rate Required return Output area: Price Input area: Stock price Required return \$ 78.00 10.9% Output area: Dividend yield Next year's dividend Current dividend Input area: Dividend one Dividend two Dividend three Dividend four Dividend growth rate Required return $$$$15.0011.009.002.954%10.30% Output area: Price after Year 4 dividend Year1234 Cash flow Share price