Question 14 (1 point) B D E F G H 1 3 2012 2013 2016 2.3 2017 2.5 2 You have the following information on dividend payment. 2014 2015 4 Dividend (in $) 1.65 1.84 1.98 2.1 5 6 You can calculate dividend growth rate as 7 8 The appropriate formula to calculate growth rate in cell E6 is: No correct answer option is given =(H4/C4)^(1/5)-1 =(H4/C4)^(1/6)-1 =GROWTH(C4:H4) = (H4/C4)^(1/5) Question 15 (1 point) D E F G 6% Year1 1,759,895 Year2 1,881.136 Year 3 Year 4 2.008.739 2.142.733 Year5 2.283 085 B 1 You have collected the followig information to perform firm valuation: 2 3 Cash and marketable security (at time, t = 0) 800000 4 Value of firm's debt (at time, t=0) 32000000 5 Currently, number of outstanding shares 1000000 6 7 Weighted average cost of capital, WACC 1494 8 Long-term growth rate of FCFS, E 9 10 Yearo 11 Free cash flow 12 13 Terminal value calculation 14 Year 5 FCF 2,283,085 15 Terminal value 16 17 Total free cash flow calculation (including terminal value) 18 Yearo 19 FCF (Free cash flow) 20 Terminal value 21 Total FCF 22 23 Calculating enterprise value, firm value and per-share value 24 Enterprise Value 25 Add in initial (year O) cash and mkt. securities 26 Firm value 27 Subtract out value of firm's debt today 28 Equity value 29 Per-share equity valuation 30 31 The appropriate formula to calculate Terminal value in cell B15 is: Year 1 1,759,895 Year 2 1,881,136 Year 3 Year 4 Year 5 2,008,739 2,142,733 2,283,085 30,250,880 2,008,739 2.142.733 32.533,966 1.759 895 1,881, 136 G11*(1+B8) =SUM(C19:G19) =B14/(B7-08) No correct answer option is given =B14*(1+B8)/(B7-B8)