I need the blank boxes filled in. I have found most of the answers myself already, but cannot find the value of stock using geometric/arithmetric average. I need the excel format for answers to be correct. Thanks!

Perpetual Growth Model 2014 2015 $ 3.30 $ Dividends Dividend Growth 3.70 S 12.12% 2016 4.25 $ 14.86% 2017 5.00 $ 17.65% 2018 5.50 $ 10.00% 2019 Growth Rate 5.90 7.27% 12.32% 12.38% 12.32% Geometric Average 12.38% Arithmetic Average Required Rate of Return 15.00% Value of Stock using Perpetual Growth Model with Geometric Average: Value of Stock using Perpetual Growth Model with Arithmetic Average: $ $ 247.53 $ 253.19 $ 247.53 253.19 Risidual income Model 2014 14.37 $ $ Earnings Per Share EPS Growth 2015 14.94 $ 3.97% 2016 15.59 $ 4.35% 2017 15.58 $ -0.06% 2018 15.80 $ 1.41% 2019 Growth Rate 15.90 0.63% 2.04% 2.06% % 2.04% Geometric Average 2.06% Arithmetic Average Required Rate of Return Book value per share 15.00% 21.28 $ Value of Stock using Residual Income Model with Geometric Average: Value of Stock using Residual Income Model with Arithmetic Average: $ $ 121.88 122.02 Free Cash Flow Model free cash flow FCF Growth 2014 2015 2016 2017 2018 2019 Growth Rate $ 14,869.00 $ 13,345.00 $ 12,685.00 $ 13,104.00 $ 12,934.00 $ 12,951.00 -10.25% -4.95% 3.30% -1.30% 0.13% -2.72% -2.61% -2.72% Geometric Average -2.61% Arithmetic Average Equity Beta Debt/Equity Tax Rate Risk-Free Rate Market Risk Premium 0.8 2.26 21% 2.00% 10.00% 0.2872 Asset Beta Required Rate of Return using CAPM 0.2872 4.87% 4.87% Value of Firm using Free Cash Flow Model with Geometric Average: : Value of Firm using Free Cash Flow Model with Arithmetic Average: $ $ 165,843.32 $ 168,536.40 $ 165,843.32 168,536.40 Total Debt Outstanding Total #of Shares Outstanding $ 39,837.00 937 Value of Stock using Geometric Average Value of stock using Arithmetic Average $ $ 134.48 137.35 Perpetual Growth Model 2014 2015 $ 3.30 $ Dividends Dividend Growth 3.70 S 12.12% 2016 4.25 $ 14.86% 2017 5.00 $ 17.65% 2018 5.50 $ 10.00% 2019 Growth Rate 5.90 7.27% 12.32% 12.38% 12.32% Geometric Average 12.38% Arithmetic Average Required Rate of Return 15.00% Value of Stock using Perpetual Growth Model with Geometric Average: Value of Stock using Perpetual Growth Model with Arithmetic Average: $ $ 247.53 $ 253.19 $ 247.53 253.19 Risidual income Model 2014 14.37 $ $ Earnings Per Share EPS Growth 2015 14.94 $ 3.97% 2016 15.59 $ 4.35% 2017 15.58 $ -0.06% 2018 15.80 $ 1.41% 2019 Growth Rate 15.90 0.63% 2.04% 2.06% % 2.04% Geometric Average 2.06% Arithmetic Average Required Rate of Return Book value per share 15.00% 21.28 $ Value of Stock using Residual Income Model with Geometric Average: Value of Stock using Residual Income Model with Arithmetic Average: $ $ 121.88 122.02 Free Cash Flow Model free cash flow FCF Growth 2014 2015 2016 2017 2018 2019 Growth Rate $ 14,869.00 $ 13,345.00 $ 12,685.00 $ 13,104.00 $ 12,934.00 $ 12,951.00 -10.25% -4.95% 3.30% -1.30% 0.13% -2.72% -2.61% -2.72% Geometric Average -2.61% Arithmetic Average Equity Beta Debt/Equity Tax Rate Risk-Free Rate Market Risk Premium 0.8 2.26 21% 2.00% 10.00% 0.2872 Asset Beta Required Rate of Return using CAPM 0.2872 4.87% 4.87% Value of Firm using Free Cash Flow Model with Geometric Average: : Value of Firm using Free Cash Flow Model with Arithmetic Average: $ $ 165,843.32 $ 168,536.40 $ 165,843.32 168,536.40 Total Debt Outstanding Total #of Shares Outstanding $ 39,837.00 937 Value of Stock using Geometric Average Value of stock using Arithmetic Average $ $ 134.48 137.35