Old MathJax webview

I need help with finding the horizon value, present value of horizon value, and total firm value. if you cod show how you got each answer in excel it would be much appreciated.

the growth rate is cell three across (the percents)

Insert Draw File Home vab General V 12 B M N 21 fx A 1 2 Period 4 Revenues 5 Total costs and expenses Income from operations (EBIT) Taxes E Net operating profit after taxes (NOPAT) 9 Operating current assets 10 Operatine current liabilities 11 NOWC 12 Change in NOWC 13 Net fixed assets (plant property & equipment 14 Change in nel fixed assets 15 Depreciation and amortization 16 Capital expenditure 1 Free cash flow (FCF 15 WACC 10 Present value of FCF 20 Horizon value 21 Present value of horizon Value 22 Total firm value D E F G H 2011 2012 2013 2014 2015 2016 2017 2018 0 1 2 3 4 5 6 7 18.00 18.00% 18.00% 18.00% 18.00% 5.00 5.00 3,711 4378 99 51672 6097.29 71948 8489.87 8914360360,08 2432.9613 2870.89 338766 3097 43 4716.97 1952.82 520046 1946.0187 2296.3 2709.64 3197 37 3772.9 1061 54 4159.62 875.70842 1033 34 1219 34 1438.82 16978 1782.69 1871.83 10703103 1262.97 14903 1758.55 2075,09 2178 85 2287 79 460-44833.7396 5074 04 5328.18 5594.06 58732 6166 28 647397 899 1178.6789 1545.32 1622.48 1703.44 1788:44 1877.69 1971.38 3705 3655.0607 3529 58 3705 7 3890.62408476 4288.59 4502.59 -49 9393 -125 48 176.126 184.915 194 142 203.83 214.001 1.475 1282.6032 1513,47 17859 2107.36 2486.68 2611.02 2741.57 -192.40 230.87 272.42 321.46 37932 12433 130:55 376.15438 443.862 523.757 618.034729 28 765.744 804031 183.76 674.73 796.18 939.50 1,108,60 890 08934.58 1.312.65 1.157.58 1,041.75 1.252.18 1.501.63 1,850.68 1,943.24 15.00% 15.00 15.00% 15.00% 15.00% 15.00% 15.00% $1,141.43 $87530 $684.97 $71504 $746 57 5800 10 $730.54 ROSSR 20