how did we get the the numbers: i zoomed in the part needs to be determined!
48.08
159.24
142.45
15.33
explain please.
c 1 BUILD NEW STADIUM Current Forca 2 2009 3 2010 3155 4 2011 4 5 6 2050 2007 1740 15.70 28.70 5:20 7.10 74.10 Attendance Sponsor Broadcast Merchandise Omer Total Revenge 18.99 17.11 3126 5.6 7.74 15 34.10 8.44 9.10 100.00 Operating Costs Payroll Stadun Opera 5092 14 2185 56.01 1704 187 74.92 2100 2.02 130 68.10 Tot Operating 3120 5.85 2:20 EBITDA Depreciation EBIT We 5.00 220 280 220 2.50 15.77 2:03 319 245 0.36 Net Income 0:35 1.10 34 * DISCOUNTED CASH FLOW MODEL OF NEW STADIUM 20 EBITDA 205 180 NOPAT 1185 12.25 Change in WC LeCAPEX Add Depreciation Free Cash Flow FCF) 3.90 - 12843 579 30.02 24.75 Discount Rate > Discount factor * PV Cash Flow 1.0000 0.22 14 - 10878 Current Scenario New Stadium Scenario 100.00 4508 -6440 Intrinsic Value Enterprise Value Less Debt Variance 511 14245 Number of share 47 Price per share 30 Perpetuy Growth Model FCF 2000 Terminal UFCF Growth Rae se WACC Terminal Value 10:25 ples Analysis DCF Model for New Stadium DCF for New 5 2012 7 2014 10 2017 52:01 2011 343 2050 40.51 7.34 1002 110.00 28 44.10 2013 40.85 3160 48.13 72 1191 541.21 3444 52.46 2015 48.54 3754 S.19 10.36 14.15 12.90 152 1092 129.55 90.21 7455 2185 211 21 22.72 2.19 2457 237 25.56 246 26.50 2.50 2.28 116.11 250 10 27.75 30.60 25.10 278 3054 257 1778 3.19 5.11 1.45 260 19.05 3.45 5.77 10.71 27.50 450 3.79 535 2485 413 7.25 12.47 12.04 16.66 22.54 25.10 1323 1471 16.31 18.04 18.30 5.73 625 745 251 9.65 24.75 9.69 20.54 28.67 35. 0.670 18.75 16.35 15.95 15.60 15.24 14 1456 ples Analysis DCF Model for New Stadium DCF for New 11 12 7 2014 10 2017 - GUBE 62.86 2015 48.54 3754 57.19 34.44 52.46 450 2016 5291 4092 5233 11.20 15.42 182.07 55 53 1521 12:58 153.92 14.15 167.77 12:31 16.81 193.33 18.32 217 27 30 108.15 25.56 246 245 237 126.17 145.20 28.75 132 27.50 2.66 26 58 256 141 21 28 9825 319 3 2002 501 2.90 24.85 4.13 30.60 3.01 27.50 4.50 3:39 3708 3054 491 235 561 33.60 5.35 9.92 16.43 C . 10.94 13.47 15.01 16.06 . 27.75 1071 18.80 - 11.78 21.88 610 2011 24.02 2.31 23 809 743 -4.34 2.76 30.09 104 -5.00 -4.70 554 -5.4 12 SD 88 SES SESE ET SOS 15.60 . 1456 15.24 14.90 16884 ples Analysis DCF Model for New Stadium DCF for New EBITDA Tax at 35% NOPAT 5.85 -2.05 3.80 6.76 -2.37 4.39 Change in WC Less:CAPEX Add:Depreciation Free Cash Flow (FCF) 3.90 - 128.43 0.80 - 119.93 4.25 - 128.57 0.83 - 119.09 Terminal Value Discount Rate Discount factor PV Cash Flows 10.25% 1.0000 0.9070 - 108.78 0.8227 - 97.98 Current Scenario 159.24 Variance - 51.15 Intrinsic Value Enterprise Value Plus: Cash Less: Debt Equity Value Number of share Price per share New Stadium Scenario 108.08 48.08 - 64.40 91.76 9.29 9.88 142.45 50.68 15.33 -5.46 30.03 Finding Terminal Value Perpetuity Growth Model FCF @t-2020 Terminal UFCF Growth Rate WACC Terminal Value 10.25% 499.65 ples Analysis DCF Model for New Stadium DCF for New c 1 BUILD NEW STADIUM Current Forca 2 2009 3 2010 3155 4 2011 4 5 6 2050 2007 1740 15.70 28.70 5:20 7.10 74.10 Attendance Sponsor Broadcast Merchandise Omer Total Revenge 18.99 17.11 3126 5.6 7.74 15 34.10 8.44 9.10 100.00 Operating Costs Payroll Stadun Opera 5092 14 2185 56.01 1704 187 74.92 2100 2.02 130 68.10 Tot Operating 3120 5.85 2:20 EBITDA Depreciation EBIT We 5.00 220 280 220 2.50 15.77 2:03 319 245 0.36 Net Income 0:35 1.10 34 * DISCOUNTED CASH FLOW MODEL OF NEW STADIUM 20 EBITDA 205 180 NOPAT 1185 12.25 Change in WC LeCAPEX Add Depreciation Free Cash Flow FCF) 3.90 - 12843 579 30.02 24.75 Discount Rate > Discount factor * PV Cash Flow 1.0000 0.22 14 - 10878 Current Scenario New Stadium Scenario 100.00 4508 -6440 Intrinsic Value Enterprise Value Less Debt Variance 511 14245 Number of share 47 Price per share 30 Perpetuy Growth Model FCF 2000 Terminal UFCF Growth Rae se WACC Terminal Value 10:25 ples Analysis DCF Model for New Stadium DCF for New 5 2012 7 2014 10 2017 52:01 2011 343 2050 40.51 7.34 1002 110.00 28 44.10 2013 40.85 3160 48.13 72 1191 541.21 3444 52.46 2015 48.54 3754 S.19 10.36 14.15 12.90 152 1092 129.55 90.21 7455 2185 211 21 22.72 2.19 2457 237 25.56 246 26.50 2.50 2.28 116.11 250 10 27.75 30.60 25.10 278 3054 257 1778 3.19 5.11 1.45 260 19.05 3.45 5.77 10.71 27.50 450 3.79 535 2485 413 7.25 12.47 12.04 16.66 22.54 25.10 1323 1471 16.31 18.04 18.30 5.73 625 745 251 9.65 24.75 9.69 20.54 28.67 35. 0.670 18.75 16.35 15.95 15.60 15.24 14 1456 ples Analysis DCF Model for New Stadium DCF for New 11 12 7 2014 10 2017 - GUBE 62.86 2015 48.54 3754 57.19 34.44 52.46 450 2016 5291 4092 5233 11.20 15.42 182.07 55 53 1521 12:58 153.92 14.15 167.77 12:31 16.81 193.33 18.32 217 27 30 108.15 25.56 246 245 237 126.17 145.20 28.75 132 27.50 2.66 26 58 256 141 21 28 9825 319 3 2002 501 2.90 24.85 4.13 30.60 3.01 27.50 4.50 3:39 3708 3054 491 235 561 33.60 5.35 9.92 16.43 C . 10.94 13.47 15.01 16.06 . 27.75 1071 18.80 - 11.78 21.88 610 2011 24.02 2.31 23 809 743 -4.34 2.76 30.09 104 -5.00 -4.70 554 -5.4 12 SD 88 SES SESE ET SOS 15.60 . 1456 15.24 14.90 16884 ples Analysis DCF Model for New Stadium DCF for New EBITDA Tax at 35% NOPAT 5.85 -2.05 3.80 6.76 -2.37 4.39 Change in WC Less:CAPEX Add:Depreciation Free Cash Flow (FCF) 3.90 - 128.43 0.80 - 119.93 4.25 - 128.57 0.83 - 119.09 Terminal Value Discount Rate Discount factor PV Cash Flows 10.25% 1.0000 0.9070 - 108.78 0.8227 - 97.98 Current Scenario 159.24 Variance - 51.15 Intrinsic Value Enterprise Value Plus: Cash Less: Debt Equity Value Number of share Price per share New Stadium Scenario 108.08 48.08 - 64.40 91.76 9.29 9.88 142.45 50.68 15.33 -5.46 30.03 Finding Terminal Value Perpetuity Growth Model FCF @t-2020 Terminal UFCF Growth Rate WACC Terminal Value 10.25% 499.65 ples Analysis DCF Model for New Stadium DCF for New
