{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Model","Data Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Model","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions",null,null,null,null,null,null,"Base"]
[null,"Cash Flow",null,null,100,"cash",null,100,"base cash"]
[null,"Growth Rate",null,null,0.05,"st growth",null,0.05,"base st"]
[]
[null,"Terminal Period",null,null,8,"terminal",null,6,"base terminal"]
[null,"WACC",null,null,0.06,"wacc",null,0.06,"base wacc"]
[null,"Terminal Growth",null,null,0.02,"term growth",null,0.02,"base term growth"]
[]
["Corporate Valuation"]
[null,"Period",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,"Terminal Switch",null,null,null,{"$f":"E6","v":8},null,{"$f":"H11=$F12","v":false},{"$f":"I11=$F12","v":false},false,false,false,false,false,true,false,false]
[null,"Explicit Switch",null,null,null,{"$f":"F12","v":8},null,{"$f":"H11<=$F$13","v":true},{"$f":"I11<=$F$13","v":true},true,true,true,true,true,true,false,false]
[]
[null,"Base Cash Flow",null,null,null,{"$f":"E3","v":100},null,{"$f":"F15*H13","v":100},{"$f":"H15*I13","v":100},100,100,100,100,100,100,0,0]
[null,"Growth Index",null,null,{"$f":"E4","v":0.05},null,1,{"$f":"G16*(1+$E$16)","v":1.05},{"$f":"H16*(1+$E$16)","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505,1.477455443789063,1.5513282159785162,1.628894626777442]
[null,"Cash With Growth",null,null,null,null,null,{"$f":"H15*H16","v":105},{"$f":"I15*I16","v":110.25},115.76250000000002,121.55062500000003,127.62815625000003,134.00956406250003,140.71004226562505,147.74554437890629,0,0]
[]
[null,"Explicit Valuation",null,null,{"$f":"E7","v":0.06},{"$f":"NPV(E19,17:17)*(1+E19)^0.5","v":789.44302861920903}]
[]
[null,"Terminal Value",null,null,{"$f":"E7","v":0.06},{"$f":"E8","v":0.02},null,{"$f":"H17*(1+$F$21)/($E$21-$F$21)*H12","v":0},{"$f":"I17*(1+$F$21)/($E$21-$F$21)*I12","v":0},0,0,0,0,0,3767.511381662111,0,0]
[null,"PV of Terminal Value",null,null,{"$f":"E21","v":0.06},{"$f":"NPV(E22,H21:Q21)*(1+E22)^0.5","v":2433.6638075727337},"term value"]
[]
[null,"Total Value",null,null,null,{"$f":"F22+F19","v":3223.1068361919429},"value"]

{"sheet":"Data Tables","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Table Code",4]
[]
[null,null,null,null,"Terminal Growth",null,null,null,null,null,null,null,null,"Table 1","Table 2","Table 3","Table 4"]
[null,null,null,0,0.01,0.02,0.03,0.04,null,null,null,"Start Row",{"$f":"INDEX(N4:Q4,$M$1)","v":35},{"$f":"ROW(C5)","v":5},{"$f":"ROW(D15)","v":15},{"$f":"ROW(D25)","v":25},{"$f":"ROW(D35)","v":35}]
[null,null,0.05,2869.1462000000001,3407.1111000000001,4303.7192999999997,6096.9357,11476.5849,null,null,null,"End Row",{"$f":"INDEX(N5:Q5,$M$1)","v":40},{"$f":"ROW(D10)","v":10},{"$f":"ROW(D20)","v":20},{"$f":"ROW(E30)","v":30},{"$f":"ROW(D40)","v":40}]
[null,null,6.0000000000000005E-2,2380.0729999999999,2717.2865000000002,3223.1068,4066.1406999999999,5752.2084000000004,null,null,null,"Start Col",4,{"$f":"COLUMN(D6)","v":4},{"$f":"COLUMN(D15)","v":4},{"$f":"COLUMN(D25)","v":4},{"$f":"COLUMN(D40)","v":4}]
[null,"WACC",7.0000000000000007E-2,2031.5589,2258.1644999999999,2575.4123,3051.2838999999999,3844.4034000000001,null,null,null,"End Col",7,{"$f":"COLUMN(H7)","v":8},{"$f":"COLUMN(H16)","v":8},{"$f":"COLUMN(H30)","v":8},{"$f":"COLUMN(G35)","v":7}]
[null,null,0.08,1770.8463999999999,1930.8288,2144.1385,2442.7721000000001,2890.7226000000001,null,null,null,"output","term_value","value","value","value","term_value"]
[null,null,0.09,1568.6288999999999,1685.8241,1836.5035,2037.4095,2318.6779000000001,null,null,null,"row input","WACC","term_growth","terminal","terminal","WACC"]
[null,null,0.1,1407.325,1495.6776,1606.1184000000001,1748.1137000000001,1937.4407000000001,null,null,null,"col input","st_growth","wacc","st_growth","term_growth","st_growth"]
[]
[]
[null,null,null,null,"Terminal Period"]
[null,null,null,4,5,6,7,8,null,null,null,"cash",null,"=Model!$E$3"]
[null,null,0.04,2825.5435000000002,2873.2451000000001,2920.0466999999999,2965.9652000000001,3011.0173,null,null,null,"st_growth",null,"=Model!$E$4"]
[null,null,0.05,2929.9112,3004.2556,3077.8986,3150.8467999999998,3223.1068,null,null,null,"term_growth",null,"=Model!$E$8"]
[null,"Short-term ",0.06,3037.2109,3140.1671999999999,3243.1235000000001,3346.0798,3449.0360999999998,null,null,null,"terminal",null,"=Model!$E$6"]
[null,"Growth",7.0000000000000007E-2,3147.4978000000001,3281.1187,3416.0003000000002,3552.1543000000001,3689.5927000000001,null,null,null,"value",null,"=Model!$F$24"]
[null,null,0.08,3260.8276000000001,3427.2514999999999,3596.8155000000002,3769.5787999999998,3945.6017999999999,null,null,null,"wacc",null,"=Model!$E$7"]
[null,null,0.09,3377.2566999999999,3578.7096000000001,3785.8638999999998,3998.8811999999998,4217.9272000000001]
[]
[]
[null,null,null,null,"Terminal Period"]
[null,null,null,4,5,6,7,8]
[null,null,0,2054.3000999999999,2136.9049,2218.7303999999999,2299.7840000000001,2380.0729999999999]
[null,null,0.01,2404.5445,2483.8452000000002,2562.3977,2640.2091,2717.2865000000002]
[null,"Terminal",0.02,2929.9112,3004.2556,3077.8986,3150.8467999999998,3223.1068]
[null,"Growth",0.03,3805.5223999999998,3871.6062000000002,3937.0666999999999,4001.9096,4066.1406999999999]
[null,null,0.04,5556.7447000000002,5606.3076000000001,5655.4029,5704.0351000000001,5752.2084000000004]
[null,null,0.05,10810.411599999999,10810.411599999999,10810.411599999999,10810.411599999999,10810.411599999999]
[]
[]
[null,null,null,null,"WACC"]
[null,null,null,0.05,6.0000000000000005E-2,7.0000000000000007E-2,0.09]
[null,null,0.03,2987.1496000000002,2086.623,1555.7852,967.16639999999995]
[null,null,0.04,3227.2001,2254.3062,1680.8097,1044.8888999999999]
[null,"Short-term",0.05,3483.9632999999999,2433.6637999999998,1814.5387000000001,1128.0226]
[null,"Growth",0.06,3758.4268000000002,2625.3856999999998,1957.4864,1216.8871999999999]
[null,null,7.0000000000000007E-2,4051.6264000000001,2830.1952999999999,2110.1923999999999,1311.8181]
[null,null,0.08,4364.6478999999999,3048.8512000000001,2273.2221,1413.1668]