Question

Question 5 Input area: R=Dividend Yield+g Dividend growth rate Dividend yield 4.3% 5.6% Find the Required Return:

Answer 1

Required rate = Dividend yield + dividend grwowth rate

Required rate = 4.3% + 5.6%

Required rate = 9.9%

Insert Page Layout Formulas Data Review View Help Share Com O 2 A 0 g 0 G Define Name » F Windward Windward Tools Search Define Name , Trace Precedents Plt Show Formula Use in Formula "a Trace Dependents Error Checking Create from Selection FRemove Arrows - Evaluate Formula Defined Names Formula Auditing Calculate Now um Recently Financial Logical Text Date & Lookup & Math & More Used - - - Time Reference Trigº Functions Function Library Name Manager Watch Window Calculation Calculate Sheet Options Calculation : f =SUM(D5:06) Function Arguments P . a . R . s SUM Number Number2 Number Ds.de 05:06 1 1 - 109430.056) = {0.043;0.056) = number Dividend growth rate Dividend yield 4.3% 5.6% Required rate of return 06) = 0.099 Adds all the numbers in a range of cells. Numbert: number number2.... are 1 to 255 numbers to sum. Logical values and text are ignored in cells, included if typed as arguments. Formula result = 9.9% Help on this function OK Cancel