Question 3.II.a: Use EXCEL to graph the dividend path over the five year period for your firm.(Put dividends on the vertical axis and time on the horizontal axis).

Use the the data I have provided on Excel to make dividend path. Equity Multiplier for each year in addition is: 2014: 3.89 2015: -5.17 2016: 3.15 2017: 3.49 2018: 2.95

ONE OF FREE LETS 2014 27 6 81065 6565768 0 635 682 1.54 0. 0276519 14 976415 MEDIA 56 33 30536 3 2014 ED.5 2839 412074 ADIVIDE 5 2014 H DI VAC ! ! 6 2014 29196 $1 123 HDIVIDE 72014 525 2 8936 #DIVIDE 2014 59 8 293 36 HDIVAC 91 2014 6108 340 % $1 178 HDIVIDE HEY 2014 6207 3.3036 #DIVIDE TRY2014 8417 324 % #DIVID 1212014 736 28236 $1 234 HDIVIDE 12015 75.33 276 % $1273 HEARTS DESLOGE 17 5096 19 5 1564 4 2 2015 737 27296 HDIVID 312015 17.8 284% HDIVIDE 42015 #DIVID 5 12 015 70 CE 2 573 #DIVIDE BIZDIS 2716 1298 HDIVIDE THE2015 8217 247% #DIVIDE FAT CUTS 19.9 283% ADIVIDE 12015 76. 4 287% $1 307 HDIVID ! 1 2015 79.53 2849 6 HDIVIDE 182015 71:23 290% #DIVIDE 1212015 739 3 0326 $1322 #DIVIDE THECHE 713 309% $1 378 1.179474 0 678183 25 63% 13 478261 HEDIE HDIVID ! ZUZUTE 65.24 27696 #DIVIDE AT25 82 76 217% HDIVIDE 5/ 12016 BY 2.8436 HDIVID 5 2016 68 65 3.30% $1 412 #DIVIDE 72016 #DIVIDE ENDZONE 7275 36236 #DIVID! ! PUZOTE % $1 356 HDIVIDE TO 2016 ED7 35386 HDIVID THEZONE 68 65 3.609 HDIVIDE 121 2016 77.92 307% $1 344 HDIVIDE THEON 714 3.35 6 1359 19435 0707382 24 3796 15 454545 212017 HDIVID 3201 57:65 4.3386 #DIVID ! 4 12017 562 4.5036 #DIVIDE 5 2017 55 ,52 4.59 % HDIVID 62017 4. 21% $1433 HOWHE ! ! 72017 51 .9 4. 693 6 HDIVIDE EUROPE HDIVIDE 2017 57.2 4.32% $1 412 HDIVID ! TOP 2017 58 15 4 3496 HDIVIDE 12017 59.3 403 3 6 HDIVIDE 12 2017 4. 15% $1.370 HDIVID ! 12018 689 5:37 % 1356 9 9607 72 0.7 10915 1909 14 917204