Assignment2 DCModel Formulas Data Review View Page Layout Calibri (Body) A- A Wrap Text Home Insert X Cut Copy Pasta Format General A, $9. B 1 U Merge & Center L13 X fx G H A C 1 Discount Model 2 w Growth Maden 2014 2.30 $ $ 5 Own Dividend Growth 2015 3.70 5 12.129 2016 425$ 16,86% 2017 5.00 17.69 2018 5.50 $ 10.00 2019 Gwth fate 5.90 7.27 12 32Geometri Average 12.58% Arithmet Avenge Required forte e Retum 15.OON 10 Value of Stock Perpetual Growth Model with Geometric Average 11 Value of stock wingerpal Growth Model with Arttimet Average 3 $ 247.53 25119 13 10 Riidud Income Model 2014 10375 5 16 Eng Per Share 17 ES Gwth 2015 14.95 3.97% 2016 15.95 . 2017 15 a 5 GOON 2018 15.00 1.41N 2019 Growth Rate 15.0 06 2018 Geometrie Average 2.00 Arithmeti Averse red Rate of turn 30 kva pershare 15.00% 2128 121.00 121.02 -2.22 Geometric Avenge 2.61% Ariete Avelge 22 Wake of Stock using Restasione Model with Geometr Average 23 Vale of Stocking Resilicone Model with Arithmet Average 34 35 26 Free Cash Flow Model 27 2014 2015 2016 2017 2018 2013 Growlane 20 Freth Flow $14.00 $135.00 5 12.685.00 $ 1104.00 5 12.914,00 $ 12.950.00 29 TO Gwth 3.30 - 1 SW IN 10 31 tube 00 33 Detay 220 34 Tax Rate 215 35 free 2.00% 36 Matok remium 10.ON 22 38 Aaset Beta 0.2572 39 Rate of Retum in CAM 487 40 $ 165,14332 16.536.40 A Value ofrming Free Cash Flow Model with Geometric Average Vala firm using Free Gshow Model with Arithmetic Average 43 Total Debt Outstanding 539037.00 45 Total of shares Outstanding 46 47 Value of Stocking Geometri Average 4 Value for using Arithmetic Average 16 15735 Sheets Assignment2 DCModel Formulas Data Review View Page Layout Calibri (Body) A- A Wrap Text Home Insert X Cut Copy Pasta Format General A, $9. B 1 U Merge & Center L13 X fx G H A C 1 Discount Model 2 w Growth Maden 2014 2.30 $ $ 5 Own Dividend Growth 2015 3.70 5 12.129 2016 425$ 16,86% 2017 5.00 17.69 2018 5.50 $ 10.00 2019 Gwth fate 5.90 7.27 12 32Geometri Average 12.58% Arithmet Avenge Required forte e Retum 15.OON 10 Value of Stock Perpetual Growth Model with Geometric Average 11 Value of stock wingerpal Growth Model with Arttimet Average 3 $ 247.53 25119 13 10 Riidud Income Model 2014 10375 5 16 Eng Per Share 17 ES Gwth 2015 14.95 3.97% 2016 15.95 . 2017 15 a 5 GOON 2018 15.00 1.41N 2019 Growth Rate 15.0 06 2018 Geometrie Average 2.00 Arithmeti Averse red Rate of turn 30 kva pershare 15.00% 2128 121.00 121.02 -2.22 Geometric Avenge 2.61% Ariete Avelge 22 Wake of Stock using Restasione Model with Geometr Average 23 Vale of Stocking Resilicone Model with Arithmet Average 34 35 26 Free Cash Flow Model 27 2014 2015 2016 2017 2018 2013 Growlane 20 Freth Flow $14.00 $135.00 5 12.685.00 $ 1104.00 5 12.914,00 $ 12.950.00 29 TO Gwth 3.30 - 1 SW IN 10 31 tube 00 33 Detay 220 34 Tax Rate 215 35 free 2.00% 36 Matok remium 10.ON 22 38 Aaset Beta 0.2572 39 Rate of Retum in CAM 487 40 $ 165,14332 16.536.40 A Value ofrming Free Cash Flow Model with Geometric Average Vala firm using Free Gshow Model with Arithmetic Average 43 Total Debt Outstanding 539037.00 45 Total of shares Outstanding 46 47 Value of Stocking Geometri Average 4 Value for using Arithmetic Average 16 15735 Sheets
