Question

Find the average annual growth rate of the dividends for each firm listed in the following table: TA Data Table . A (Click on the following icon S 2 Firm Loewen Morse Huddleston Meyer 006 $1.02 $1.00 $1.50 $2.00 in order to copy its contents into a spreadsheet.) e Dividend Payment per Year 2007 2008 2009 2010 $1.05 $1.20 $1.21 $1.25 $0.90 $0.90 $1.10 $1.25 $2.50 $3.50 $3.90 $3.90 $2.20 $2.00 $2.74 $2.85 . TIT $1.40 $1.45 $4.50 $2.99 CT Print Done

Answer 1

­SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

' v to - ENG W a 1x 2 05:35 | 23-03-2020 ... o X HB110 X fc HB HC HD HE HE HG HH HI HK HL HM - 110 111 USING EXCEL firm 2006 2011 --- - LOEWEN MORSE HUDDLESTON MEYER PV 1.02 1.00 1.50 2.00 FV 1.40 1.45 4.50 2.99 n = 5 YEARS AVERAGE ANNUAL GROWTH RATE 6.54% EXCEL =RATE(5,,-HE115,HG115) 7.71% EXCEL FRATE(5,,-HE116,HG116) 24.57% EXCEL ERATE(5,,-HE117,HG117) 8.37% EXCEL =RATE(5,,-HE118,HG118) WE CAN ALSO CALCULATE USING THE FORMULA 112 113 114 115 A 116 B 117 C 118 D 119 120 121 122 123 124 125 A 126 B 127 C 128 D 129 130 131 132 133 134 FORMULA = (FV/PV)^(1/5) - 1 LOEWEN MORSE HUDDLESTON MEYER (1.40/1.02)^(1/5) - 1 (1.45/1.00)^(1/5) - 1 (4.50/1.50)^(1/5) - 1 (2.99/2.00)^(1/5) - 1 AVERAGE ANNUAL GROWTH RATE 6.54% 7.71% 24.57% 8.37% KE CAPM UTILITY, SHARPE, beta coNvexity DGM beta port future INDEX INTL CAP BUD SANDRINE LEASING PORTFOLOQ DIR right clean YIELD bc ... + :