{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
[null,null,"Valuation Year",null,null,3]
[null,null,"Terminal Year",null,null,11]
[]
[null,null,"Discount Rate",null,null,"Period","Rate","Inflation"]
[null,null,null,null,null,1,{"$f":"H7+2%","v":0.04},0.02]
[null,null,null,null,null,5,{"$f":"H8+2%","v":0.04},0.02]
[null,null,null,null,null,7,0.06,0.04]
[null,null,null,null,null,9,0.05,0.03]
[]
[null,null,"Middle Period Cash Flow in Zero",null,null,100]
[null,null,"Terminal Growth",null,null,{"$f":"H10","v":0.03}]
[]
["Model"]
[null,null,null,null,null,1,{"$f":"F16+1","v":2},{"$f":"G16+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16]
[]
[null,null,null,"Valuation Year",null,{"$f":"F16=$F$3","v":false},{"$f":"G16=$F$3","v":false},true,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,"Valuation Period",null,{"$f":"AND(F16>=$F$3,F16<=$F$4)","v":false},{"$f":"AND(G16>=$F$3,G16<=$F$4)","v":false},true,true,true,true,true,true,true,true,true,false,false,false,false,false]
[null,null,null,"Terminal Period",null,{"$f":"F16=$F$4","v":false},{"$f":"G16=$F$4","v":false},false,false,false,false,false,false,false,false,true,false,false,false,false,false]
[]
[null,null,null,"Inflation Rate",null,{"$f":"LOOKUP(F16,$F$7:$F$10,$H$7:$H$10)","v":0.02},{"$f":"LOOKUP(G16,$F$7:$F$10,$H$7:$H$10)","v":0.02},0.02,0.02,0.02,0.02,0.04,0.04,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,"Index",1,{"$f":"E23*(1+F22)","v":1.02},{"$f":"F23*(1+G22)","v":1.0404},1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.17120891603456,1.2180572726759424,1.2545989908562207,1.2922369605819073,1.3310040693993646,1.3709341914813455,1.412062217225786,1.4544240837425595,1.4980568062548363,1.5429985104424815]
[null,null,null,"Middle Period Cash Flow",{"$f":"$F$12","v":100},{"$f":"$E$24*F23","v":102},{"$f":"$E$24*G23","v":104.03999999999999},106.12079999999999,108.243216,110.40808032,112.61624192640001,117.120891603456,121.80572726759425,125.45989908562207,129.22369605819074,133.10040693993645,137.09341914813456,141.20622172257859,145.44240837425596,149.80568062548363,154.29985104424816]
[]
[null,null,null,"Discount Factor",null,{"$f":"LOOKUP(F16,$F$7:$F$10,$G$7:$G$10)*F19","v":0},{"$f":"LOOKUP(G16,$F$7:$F$10,$G$7:$G$10)*G19","v":0},0.04,0.04,0.04,0.04,0.06,0.06,0.05,0.05,0.05,0,0,0,0,0]
[null,null,null,"Full Year Discount Factor",1,{"$f":"E27*(1+F26*F19)","v":1},{"$f":"F27*(1+G26*G19)","v":1},1.04,1.0816000000000001,{"$f":"I27*(1+J26*J19)","v":1.1248640000000001},1.1698585600000002,1.2400500736000002,1.3144530780160002,1.3801757319168002,1.4491845185126402,1.5216437444382722,1.5216437444382722,1.5216437444382722,1.5216437444382722,1.5216437444382722,1.5216437444382722]
[]
[null,null,null,"Prior Year Discount Factor",null,{"$f":"E26*E19","v":0},{"$f":"F26*F19","v":0},0,0.04,0.04,0.04,0.04,0.06,0.06,0.05,0.05,0.05,0,0,0,0]
[null,null,null,"Weighed Rate",null,{"$f":"F26*0.5+F29*0.5","v":0},{"$f":"G26*0.5+G29*0.5","v":0},0.02,0.04,0.04,0.04,0.05,0.06,5.5E-2,0.05,0.05,2.5000000000000001E-2,0,0,0,0]
[null,null,null,"1/2 Year Discount Factor",1,{"$f":"E31*(1+(F29*0.5+F26*5)*F19)","v":1},{"$f":"F31*(1+(G29*0.5+G26*5)*G19)","v":1},{"$f":"G31*(1+(H29*0.5+H26*5)*H19)","v":1.2},{"$f":"H31*(1+(I29*0.5+I26*0.5)*I19)","v":1.248},{"$f":"I31*(1+(J29*0.5+J26*0.5)*J19)","v":1.29792},1.3498368000000001,1.41732864,1.5023683584,1.5849986181119999,1.6642485490176,1.7474609764684801,1.7474609764684801,1.7474609764684801,1.7474609764684801,1.7474609764684801,1.7474609764684801]
[]
[null,null,null,"Final Period Cash Flow",null,{"$f":"F24*(1+F22*0.5)*(1+$F$13)*F20/(F26-$F$13)","v":0},{"$f":"G24*(1+G22*0.5)*(1+$F$13)*G20/(G26-$F$13)","v":0},0,0,0,0,0,0,0,0,6957.4910217678271,0,0,0,0,0]
[]
[null,null,null,"Cash Flow in Explicit Period",{"$f":"SUMPRODUCT(F24:U24*F19:U19/F31:U31)","v":740.34236972539657}]
[null,null,null,"Cash Flow in Terminal Period",{"$f":"SUMPRODUCT(F33:U33/F27:U27)","v":4572.3521338013616}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}