{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INTRODUCTION","MODELING"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":175,"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":"INTRODUCTION","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["PROJECT FINANCE MODELING"]
[]
["PHILIPPE DUCHEMIN",null,null,"2020-11-17"]
[]
[]
[]
[null,"MODELLING"]

{"sheet":"MODELING","index":1,"n_rows":288,"n_cols":41,"rows_kept":288,"cut":false,"hidden":false,"merged":[]}
["PROJECT MODELING"]
[]
["Calendar Year",null,"Year",2020,{"$f":"D3+1","v":2021},{"$f":"E3+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
["Durations",null,"Duration",1,{"$f":"D4+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]
["Construction",null,"DurationConst",5,{"$f":"D5","v":5},5,{"$f":"F5","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["Production",null,"DurationProd",25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25]
["Termination",null,"DurationTerm",5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
["Project",null,"DurationProject",{"$f":"D5+D6+D7","v":35},{"$f":"D8","v":35},35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35,35]
[null,null,"YearConst",{"$f":"--(Duration<=DurationConst)","v":1},{"$f":"--(Duration<=DurationConst)","v":1},1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"YearProd",{"$f":"--(Duration>DurationConst)*(Duration<=DurationProd+DurationConst)","v":0},0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
[null,null,"YearTerm",{"$f":"--(Duration>DurationConst+DurationProd)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
["Inflation",null,"RateInflation",0.01,{"$f":"D12","v":0.01},{"$f":"E12","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
["Prices"]
["Initial Price",null,"PriceMWh",98,{"$f":"D14","v":98},{"$f":"E14","v":98},98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98]
["Index",null,"Priceindex",100,{"$f":"D15","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Production"]
["Capacity",null,"ProductionYear",500,{"$f":"D17","v":500},{"$f":"E17","v":500},500,500,500,500,{"$f":"J17","v":500},{"$f":"K17","v":500},{"$f":"L17","v":500},{"$f":"M17","v":500},{"$f":"N17","v":500},{"$f":"O17","v":500},{"$f":"P17","v":500},{"$f":"Q17","v":500},{"$f":"R17","v":500},{"$f":"S17","v":500},{"$f":"T17","v":500},{"$f":"U17","v":500},{"$f":"V17","v":500},{"$f":"W17","v":500},{"$f":"X17","v":500},{"$f":"Y17","v":500},{"$f":"Z17","v":500},{"$f":"AA17","v":500},{"$f":"AB17","v":500},{"$f":"AC17","v":500},{"$f":"AD17","v":500},{"$f":"AE17","v":500},{"$f":"AF17","v":500},{"$f":"AG17","v":500},{"$f":"AH17","v":500},{"$f":"AI17","v":500},{"$f":"AJ17","v":500},{"$f":"AK17","v":500}]
["Availability",null,"Availibility",0.5,1,1,1,1,1,1,1,1,{"$f":"$D18","v":0.5},1,1,1,1,{"$f":"$D18","v":0.5},1,1,1,1,{"$f":"$D18","v":0.5},1,1,1,1,{"$f":"$D18","v":0.5},1,1,1,1,{"$f":"$D18","v":0.5},1,1,1,1,1]
["Costs"]
["O&M",null,"CostOM",10,{"$f":"D20","v":10},{"$f":"E20","v":10},{"$f":"F20","v":10},{"$f":"G20","v":10},{"$f":"H20","v":10},{"$f":"I20","v":10},{"$f":"J20","v":10},{"$f":"K20","v":10},{"$f":"L20","v":10},{"$f":"M20","v":10},{"$f":"N20","v":10},{"$f":"O20","v":10},{"$f":"P20","v":10},{"$f":"Q20","v":10},{"$f":"R20","v":10},{"$f":"S20","v":10},{"$f":"T20","v":10},{"$f":"U20","v":10},{"$f":"V20","v":10},{"$f":"W20","v":10},{"$f":"X20","v":10},{"$f":"Y20","v":10},{"$f":"Z20","v":10},{"$f":"AA20","v":10},{"$f":"AB20","v":10},{"$f":"AC20","v":10},{"$f":"AD20","v":10},{"$f":"AE20","v":10},{"$f":"AF20","v":10},{"$f":"AG20","v":10},{"$f":"AH20","v":10},{"$f":"AI20","v":10},{"$f":"AJ20","v":10},{"$f":"AK20","v":10}]
["Fees",null,"CostFEE",0.02,{"$f":"D21","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Environment",null,"CostENV",0.01,{"$f":"D22","v":0.01},{"$f":"E22","v":0.01},{"$f":"F22","v":0.01},{"$f":"G22","v":0.01},{"$f":"H22","v":0.01},{"$f":"I22","v":0.01},{"$f":"J22","v":0.01},{"$f":"K22","v":0.01},{"$f":"L22","v":0.01},{"$f":"M22","v":0.01},{"$f":"N22","v":0.01},{"$f":"O22","v":0.01},{"$f":"P22","v":0.01},{"$f":"Q22","v":0.01},{"$f":"R22","v":0.01},{"$f":"S22","v":0.01},{"$f":"T22","v":0.01},{"$f":"U22","v":0.01},{"$f":"V22","v":0.01},{"$f":"W22","v":0.01},{"$f":"X22","v":0.01},{"$f":"Y22","v":0.01},{"$f":"Z22","v":0.01},{"$f":"AA22","v":0.01},{"$f":"AB22","v":0.01},{"$f":"AC22","v":0.01},{"$f":"AD22","v":0.01},{"$f":"AE22","v":0.01},{"$f":"AF22","v":0.01},{"$f":"AG22","v":0.01},{"$f":"AH22","v":0.01},{"$f":"AI22","v":0.01},{"$f":"AJ22","v":0.01},{"$f":"AK22","v":0.01}]
["Taxes"]
["on CA",null,"TaxCA",5.0000000000000001E-3,{"$f":"D24","v":5.0000000000000001E-3},{"$f":"E24","v":5.0000000000000001E-3},{"$f":"F24","v":5.0000000000000001E-3},{"$f":"G24","v":5.0000000000000001E-3},{"$f":"H24","v":5.0000000000000001E-3},{"$f":"I24","v":5.0000000000000001E-3},{"$f":"J24","v":5.0000000000000001E-3},{"$f":"K24","v":5.0000000000000001E-3},{"$f":"L24","v":5.0000000000000001E-3},{"$f":"M24","v":5.0000000000000001E-3},{"$f":"N24","v":5.0000000000000001E-3},{"$f":"O24","v":5.0000000000000001E-3},{"$f":"P24","v":5.0000000000000001E-3},{"$f":"Q24","v":5.0000000000000001E-3},{"$f":"R24","v":5.0000000000000001E-3},{"$f":"S24","v":5.0000000000000001E-3},{"$f":"T24","v":5.0000000000000001E-3},{"$f":"U24","v":5.0000000000000001E-3},{"$f":"V24","v":5.0000000000000001E-3},{"$f":"W24","v":5.0000000000000001E-3},{"$f":"X24","v":5.0000000000000001E-3},{"$f":"Y24","v":5.0000000000000001E-3},{"$f":"Z24","v":5.0000000000000001E-3},{"$f":"AA24","v":5.0000000000000001E-3},{"$f":"AB24","v":5.0000000000000001E-3},{"$f":"AC24","v":5.0000000000000001E-3},{"$f":"AD24","v":5.0000000000000001E-3},{"$f":"AE24","v":5.0000000000000001E-3},{"$f":"AF24","v":5.0000000000000001E-3},{"$f":"AG24","v":5.0000000000000001E-3},{"$f":"AH24","v":5.0000000000000001E-3},{"$f":"AI24","v":5.0000000000000001E-3},{"$f":"AJ24","v":5.0000000000000001E-3},{"$f":"AK24","v":5.0000000000000001E-3}]
["on Capex",null,"TaxCAP",1.2500000000000001E-2,{"$f":"D25","v":1.2500000000000001E-2},1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2]
["CompTax",null,"TaxCorp",0.3,{"$f":"D26","v":0.3},{"$f":"E26","v":0.3},{"$f":"F26","v":0.3},{"$f":"G26","v":0.3},{"$f":"H26","v":0.3},{"$f":"I26","v":0.3},{"$f":"J26","v":0.3},{"$f":"K26","v":0.3},{"$f":"L26","v":0.3},{"$f":"M26","v":0.3},{"$f":"N26","v":0.3},{"$f":"O26","v":0.3},{"$f":"P26","v":0.3},{"$f":"Q26","v":0.3},{"$f":"R26","v":0.3},{"$f":"S26","v":0.3},{"$f":"T26","v":0.3},{"$f":"U26","v":0.3},{"$f":"V26","v":0.3},{"$f":"W26","v":0.3},{"$f":"X26","v":0.3},{"$f":"Y26","v":0.3},{"$f":"Z26","v":0.3},{"$f":"AA26","v":0.3},{"$f":"AB26","v":0.3},{"$f":"AC26","v":0.3},{"$f":"AD26","v":0.3},{"$f":"AE26","v":0.3},{"$f":"AF26","v":0.3},{"$f":"AG26","v":0.3},{"$f":"AH26","v":0.3},{"$f":"AI26","v":0.3},{"$f":"AJ26","v":0.3},{"$f":"AK26","v":0.3}]
["Working Capital"]
["Collect",null,"DelaysCashIn",60,{"$f":"D28","v":60},{"$f":"E28","v":60},60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60]
["Payments",null,"DelaysCashOut",90,{"$f":"D29","v":90},{"$f":"E29","v":90},90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Construction"]
["Construction",null,"Construction",314000,{"$f":"D31","v":314000},{"$f":"E31","v":314000},314000,314000,314000,{"$f":"I31","v":314000},{"$f":"J31","v":314000},{"$f":"K31","v":314000},{"$f":"L31","v":314000},{"$f":"M31","v":314000},{"$f":"N31","v":314000},{"$f":"O31","v":314000},{"$f":"P31","v":314000},{"$f":"Q31","v":314000},{"$f":"R31","v":314000},{"$f":"S31","v":314000},{"$f":"T31","v":314000},{"$f":"U31","v":314000},{"$f":"V31","v":314000},{"$f":"W31","v":314000},{"$f":"X31","v":314000},{"$f":"Y31","v":314000},{"$f":"Z31","v":314000},{"$f":"AA31","v":314000},{"$f":"AB31","v":314000},{"$f":"AC31","v":314000},{"$f":"AD31","v":314000},{"$f":"AE31","v":314000},{"$f":"AF31","v":314000},{"$f":"AG31","v":314000},{"$f":"AH31","v":314000},{"$f":"AI31","v":314000},{"$f":"AJ31","v":314000},{"$f":"AK31","v":314000}]
["Land",null,"Land",27000,{"$f":"D32","v":27000},27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000,27000]
["Subventions",null,"Subvention",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
["Profile",null,"RateCapex",0.1,0.15,0.2,0.32,0.17,0.06,0,{"$f":"J34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Funding"]
[null,null,"FinancingRate",0.11,{"$f":"D36","v":0.11},0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,null,"Tx d'augmentation du Capex, pour financement"]
["Equity",null,"RpEquity",0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,"part d'Equity dans le capex"]
["Debt",null,"RpDebt",0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
[null,null,"RpBqDev",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,null,"RpBqExp",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"RpBqCom",0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
["Loan Duration"]
[" ",null,"DurGrace",7,{"$f":"D43","v":7},7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7]
[null,null,"DurDev",15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15]
[null,null,"DurExp",12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12]
[null,null,"DurCom",7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7]
["Amortization Method"]
["1- linear",null,"AmoDev",1,{"$f":"D48","v":1},{"$f":"E48","v":1},{"$f":"F48","v":1},{"$f":"G48","v":1},{"$f":"H48","v":1},{"$f":"I48","v":1},{"$f":"J48","v":1},{"$f":"K48","v":1},{"$f":"L48","v":1},{"$f":"M48","v":1},{"$f":"N48","v":1},{"$f":"O48","v":1},{"$f":"P48","v":1},{"$f":"Q48","v":1},{"$f":"R48","v":1},{"$f":"S48","v":1},{"$f":"T48","v":1},{"$f":"U48","v":1},{"$f":"V48","v":1},{"$f":"W48","v":1},{"$f":"X48","v":1},{"$f":"Y48","v":1},{"$f":"Z48","v":1},{"$f":"AA48","v":1},{"$f":"AB48","v":1},{"$f":"AC48","v":1},{"$f":"AD48","v":1},{"$f":"AE48","v":1},{"$f":"AF48","v":1},{"$f":"AG48","v":1},{"$f":"AH48","v":1},{"$f":"AI48","v":1},{"$f":"AJ48","v":1},{"$f":"AK48","v":1}]
["2- constant annuity",null,"AmoExp",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["3- constant DSCR",null,"AmoCom",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["Loan Interest Rate"]
["LT BqDev",2,"RateBqDev",0.02,{"$f":"D52","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["LT CredEp",6,"RateBqExp",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06]
["LT BaCom",7,"RateBqCom",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
["Bank Interest Rate"]
["Short Term",1,"RateDeposit",0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
["Short Term",5,"RateFunding",0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
["Fees",0.2,"FeeBkRate",2E-3,2E-3,{"$f":"E58","v":2E-3},2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3]
["Dividend"]
["Dividend",100,"RateDividend",1,{"$f":"D60","v":1},{"$f":"E60","v":1},{"$f":"F60","v":1},{"$f":"G60","v":1},{"$f":"H60","v":1},{"$f":"I60","v":1},{"$f":"J60","v":1},{"$f":"K60","v":1},{"$f":"L60","v":1},{"$f":"M60","v":1},{"$f":"N60","v":1},{"$f":"O60","v":1},{"$f":"P60","v":1},{"$f":"Q60","v":1},{"$f":"R60","v":1},{"$f":"S60","v":1},{"$f":"T60","v":1},{"$f":"U60","v":1},{"$f":"V60","v":1},{"$f":"W60","v":1},{"$f":"X60","v":1},{"$f":"Y60","v":1},{"$f":"Z60","v":1},{"$f":"AA60","v":1},{"$f":"AB60","v":1},{"$f":"AC60","v":1},{"$f":"AD60","v":1},{"$f":"AE60","v":1},{"$f":"AF60","v":1},{"$f":"AG60","v":1},{"$f":"AH60","v":1},{"$f":"AI60","v":1},{"$f":"AJ60","v":1},{"$f":"AK60","v":1}]
["Reserve"]
["Reserve",null,"RateReserve",0.9,{"$f":"D62","v":0.9},{"$f":"E62","v":0.9},{"$f":"F62","v":0.9},{"$f":"G62","v":0.9},{"$f":"H62","v":0.9},{"$f":"I62","v":0.9},{"$f":"J62","v":0.9},{"$f":"K62","v":0.9},{"$f":"L62","v":0.9},{"$f":"M62","v":0.9},{"$f":"N62","v":0.9},{"$f":"O62","v":0.9},{"$f":"P62","v":0.9},{"$f":"Q62","v":0.9},{"$f":"R62","v":0.9},{"$f":"S62","v":0.9},{"$f":"T62","v":0.9},{"$f":"U62","v":0.9},{"$f":"V62","v":0.9},{"$f":"W62","v":0.9},{"$f":"X62","v":0.9},{"$f":"Y62","v":0.9},{"$f":"Z62","v":0.9},{"$f":"AA62","v":0.9},{"$f":"AB62","v":0.9},{"$f":"AC62","v":0.9},{"$f":"AD62","v":0.9},{"$f":"AE62","v":0.9},{"$f":"AF62","v":0.9},{"$f":"AG62","v":0.9},{"$f":"AH62","v":0.9},{"$f":"AI62","v":0.9},{"$f":"AJ62","v":0.9},{"$f":"AK62","v":0.9}]
[null,null,"YearReserve",3,{"$f":"D63","v":3},{"$f":"E63","v":3},{"$f":"F63","v":3},{"$f":"G63","v":3},{"$f":"H63","v":3},{"$f":"I63","v":3},{"$f":"J63","v":3},{"$f":"K63","v":3},{"$f":"L63","v":3},{"$f":"M63","v":3},{"$f":"N63","v":3},{"$f":"O63","v":3},{"$f":"P63","v":3},{"$f":"Q63","v":3},{"$f":"R63","v":3},{"$f":"S63","v":3},{"$f":"T63","v":3},{"$f":"U63","v":3},{"$f":"V63","v":3},{"$f":"W63","v":3},{"$f":"X63","v":3},{"$f":"Y63","v":3},{"$f":"Z63","v":3},{"$f":"AA63","v":3},{"$f":"AB63","v":3},{"$f":"AC63","v":3},{"$f":"AD63","v":3},{"$f":"AE63","v":3},{"$f":"AF63","v":3},{"$f":"AG63","v":3},{"$f":"AH63","v":3},{"$f":"AI63","v":3},{"$f":"AJ63","v":3},{"$f":"AK63","v":3}]
["DF"]
["Discount Factor",null,"DF",0.08,{"$f":"D65","v":0.08},{"$f":"E65","v":0.08},{"$f":"F65","v":0.08},{"$f":"G65","v":0.08},{"$f":"H65","v":0.08},{"$f":"I65","v":0.08},{"$f":"J65","v":0.08},{"$f":"K65","v":0.08},{"$f":"L65","v":0.08},{"$f":"M65","v":0.08},{"$f":"N65","v":0.08},{"$f":"O65","v":0.08},{"$f":"P65","v":0.08},{"$f":"Q65","v":0.08},{"$f":"R65","v":0.08},{"$f":"S65","v":0.08},{"$f":"T65","v":0.08},{"$f":"U65","v":0.08},{"$f":"V65","v":0.08},{"$f":"W65","v":0.08},{"$f":"X65","v":0.08},{"$f":"Y65","v":0.08},{"$f":"Z65","v":0.08},{"$f":"AA65","v":0.08},{"$f":"AB65","v":0.08},{"$f":"AC65","v":0.08},{"$f":"AD65","v":0.08},{"$f":"AE65","v":0.08},{"$f":"AF65","v":0.08},{"$f":"AG65","v":0.08},{"$f":"AH65","v":0.08},{"$f":"AI65","v":0.08},{"$f":"AJ65","v":0.08},{"$f":"AK65","v":0.08}]
["DSCRTarget",null,"DSCRTarget",1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[]
["PROJECT"]
[]
["YEARS",null,"Year",{"$f":"INDIRECT($C70)","v":2020},{"$f":"INDIRECT($C70)","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[]
[null,null,"RateInflation",{"$f":"INDIRECT($C72)","v":0.01},{"$f":"INDIRECT($C72)","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,null,1,{"$f":"D73*(1+E72)","v":1.01},{"$f":"E73*(1+F72)","v":1.0201},1.0303009999999999,1.04060401,1.0510100500999999,1.0615201506009999,1.0721353521070098,1.08285670562808,1.0936852726843609,1.1046221254112045,1.1156683466653166,1.1268250301319698,1.1380932804332895,1.1494742132376223,1.1609689553699987,1.1725786449236986,1.1843044313729356,1.196147475686665,1.2081089504435316,1.220190039947967,1.2323919403474468,1.2447158597509214,1.2571630183484306,1.269734648531915,1.282431995017234,1.2952563149674063,1.3082088781170804,1.3212909668982513,1.3345038765672339,1.3478489153329063,1.3613274044862353,1.3749406785310978,1.3886900853164088,1.4025769861695729,"Infla",{"$f":"_xlfn.FORMULATEXT(K73)","v":"=J73*(1+K72)"}]
[null,null,"PriceMWh",{"$f":"INDIRECT($C74)","v":98},{"$f":"INDIRECT($C74)","v":98},98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98,98]
[null,null,null,{"$f":"PriceMWh*Infla*Priceindex/100","v":98},{"$f":"PriceMWh*Infla*Priceindex/100","v":98.98},99.969800000000021,100.96949799999999,101.97919298000001,102.99898490979999,104.02897475889799,105.06926450648696,106.11995715155184,107.18115672306736,108.25296829029804,109.33549797320103,110.42885295293304,111.53314148246236,112.64847289728699,113.77495762625986,114.91270720252245,116.06183427454769,117.22245261729317,118.39467714346611,119.57862391490079,120.77441015404979,121.98215425559029,123.20197579814619,124.43399555612767,125.67833551168894,126.93511886680582,128.20447005547388,129.48651475602864,130.78137990358891,132.08919370262481,133.41008563965107,134.74418649604758,136.09162836100808,137.45254464461814,"Price",{"$f":"_xlfn.FORMULATEXT(K75)","v":"=PriceMWh*Infla*Priceindex/100"}]
[]
["REVENUE",null,null,{"$f":"YearProd*ProductionYear*Availibility","v":0},0,0,0,0,500,500,500,500,250,500,500,500,500,250,500,500,500,500,250,500,500,500,500,250,500,500,500,500,250,0,0,0,0,0,"ProductionNet",{"$f":"_xlfn.FORMULATEXT(K77)","v":"=YearProd*ProductionYear*Availibility"}]
[null,null,null,{"$f":"ProductionNet*Price","v":0},{"$f":"ProductionNet*Price","v":0},0,0,0,51499.492454899992,52014.48737944899,52534.632253243479,53059.978575775924,26795.289180766838,54126.484145149021,54667.748986600513,55214.42647646652,55766.570741231175,28162.118224321748,56887.478813129928,57456.353601261224,58030.917137273849,58611.226308646583,29598.669285866526,59789.311957450394,60387.205077024897,60991.077127795143,61600.987899073094,31108.498889031918,62839.167755844472,63467.559433402908,64102.235027736941,64743.257378014321,32695.344975897227,0,0,0,0,0,"Revenues",{"$f":"_xlfn.FORMULATEXT(K78)","v":"=ProductionNet*Price"}]
[]
["INVESTMENT",null,null,{"$f":"(Construction+Land-Subvention)","v":331000},331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,331000,"Cap",{"$f":"_xlfn.FORMULATEXT(K80)","v":"=(Construction+Land-Subvention)"}]
[null,null,null,{"$f":"-Cap*RateCapex","v":-33100},-49650,-66200,-105920,-56270.000000000007,-19860,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Capex",{"$f":"_xlfn.FORMULATEXT(K81)","v":"=-Cap*RateCapex"}]
[null,null,null,{"$f":"-YearProd*Cap/DurationProd","v":0},0,0,0,0,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,0,0,0,0,0,"Amort",{"$f":"_xlfn.FORMULATEXT(K82)","v":"=-YearProd*Cap/DurationProd"}]
[null,null,null,{"$f":"-Capex+Amort","v":33100},{"$f":"-Capex+Amort","v":49650},{"$f":"-Capex+Amort","v":66200},{"$f":"-Capex+Amort","v":105920},{"$f":"-Capex+Amort","v":56270.000000000007},{"$f":"-Capex+Amort","v":6620},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":-13240},{"$f":"-Capex+Amort","v":0},{"$f":"-Capex+Amort","v":0},{"$f":"-Capex+Amort","v":0},{"$f":"-Capex+Amort","v":0},{"$f":"-Capex+Amort","v":0},"CFCap",{"$f":"_xlfn.FORMULATEXT(K83)","v":"=-Capex+Amort"}]
[null,null,0,{"$f":"C84-D81+D82","v":33100},{"$f":"D84-E81+E82","v":82750},{"$f":"E84-F81+F82","v":148950},254870,311140,317760,304520,291280,278040,264800,251560,238320,225080,211840,198600,185360,172120,158880,145640,132400,119160,105920,92680,79440,66200,52960,39720,26480,13240,0,0,0,0,0,0,"CapNet",{"$f":"_xlfn.FORMULATEXT(K84)","v":"=J84-K81+K82"}]
[]
["COSTS",null,"O&M",{"$f":"-ProductionNet*CostOM*Infla*YearProd","v":0},0,0,0,0,-5255.0502504999995,-5307.6007530049992,-5360.6767605350487,-5414.2835281404004,-2734.2131817109021,-5523.1106270560231,-5578.3417333265825,-5634.1251506598492,-5690.4664021664476,-2873.6855330940557,-5804.8447768499937,-5862.8932246184932,-5921.5221568646784,-5980.7373784333249,-3020.2723761088291,-6100.9501997398356,-6161.9597017372344,-6223.5792987546065,-6285.8150917421526,-3174.3366213297872,-6412.1599750861706,-6476.2815748370313,-6541.0443905854017,-6606.4548344912564,-3336.2596914180849,0,0,0,0,0,"CoOM",{"$f":"_xlfn.FORMULATEXT(K86)","v":"=-ProductionNet*CostOM*Infla*YearProd"}]
[null,null,"FEE",{"$f":"-Cap*CostFEE*Infla*YearProd","v":0},0,0,0,0,-6957.6865316619997,-7027.2633969786193,-7097.5360309484049,-7168.51139125789,-7240.1965051704692,-7312.598470222174,-7385.724454924396,-7459.5816994736397,-7534.1775164683768,-7609.5192916330598,-7685.6144845493909,-7762.4706293948848,-7840.095335688834,-7918.4962890457227,-7997.6812519361793,-8077.6580644555415,-8158.4346451000984,-8240.0189915511,-8322.4191814666101,-8405.6433732812766,-8489.6998070140889,-8574.5968050842293,-8660.342773135073,-8746.9462008664232,-8834.4156628750879,0,0,0,0,0,"CoFE","=-Cap*CostFEE*Infla*YearProd"]
[null,null,"ENV",{"$f":"-Revenues*CostENV*Infla*YearProd","v":0},0,0,0,0,-541.26484145149016,-552.14426476466508,-563.24236448643467,-574.56353601261219,-293.05613154323282,-597.89311957450377,-609.9107712779512,-622.16997778063819,-634.67559433402892,-323.7162868900715,-660.44596851312383,-673.72093248023759,-687.26272322309057,-701.07670395987464,-357.58417285473405,-729.54322945822867,-744.20704837033907,-759.1656100425829,-774.42483880443876,-394.99538903220412,-805.86959270350269,-822.06757151684303,-838.59112970433171,-855.44681141138892,-436.32064616037889,0,0,0,0,0,"CoEN","=-Revenues*CostENV*Infla*YearProd"]
[null,null,null,{"$f":"CoOM+CoFE+CoEN","v":0},0,0,0,0,-12754.001623613489,-12887.008414748285,-13021.455155969887,-13157.358455410902,-10267.465818424605,-13433.602216852702,-13573.976959528929,-13715.876827914128,-13859.319512968854,-10806.921111617188,-14150.905229912509,-14299.084786493615,-14448.880215776602,-14600.310371438922,-11375.537800899743,-14908.151493653604,-15064.601395207672,-15222.763900348289,-15382.659112013202,-11974.975383643268,-15707.729374803761,-15872.945951438105,-16039.978293424807,-16208.847846769069,-12606.996000453551,0,0,0,0,0,"Cost","=CoOM+CoFE+CoEN"]
["TAXES",null,"on CA",{"$f":"-Revenues*TaxCA*Infla","v":0},0,0,0,0,{"$f":"-Revenues*TaxCA*Infla","v":-270.63242072574508},-276.07213238233254,-281.62118224321733,-287.28176800630609,-146.52806577161641,-298.94655978725189,-304.9553856389756,-311.0849888903191,-317.33779716701446,-161.85814344503575,-330.22298425656192,-336.8604662401188,-343.63136161154529,-350.53835197993732,-178.79208642736702,-364.77161472911433,-372.10352418516953,-379.58280502129145,-387.21241940221938,-197.49769451610206,-402.93479635175134,-411.03378575842152,-419.29556485216585,-427.72340570569446,-218.16032308018944,0,0,0,0,0,"TxCA","=-Revenues*TaxCA*Infla"]
[null,null,"on CAPEX",{"$f":"-Cap*TaxCAP*Infla*YearProd","v":0},0,0,0,0,{"$f":"-Cap*TaxCAP*Infla*YearProd","v":-4348.5540822887497},-4392.0396231116374,-4435.9600193427532,-4480.3196195361807,-4525.1228157315436,-4570.374043888859,-4616.0777843277474,-4662.2385621710246,-4708.8609477927357,-4755.9495572706628,-4803.5090528433693,-4851.5441433718024,-4900.0595848055209,-4949.0601806535769,-4998.5507824601118,-5048.5362902847137,-5099.0216531875612,-5150.0118697194375,-5201.5119884166315,-5253.5271083007983,-5306.0623793838058,-5359.123003177644,-5412.7142332094199,-5466.8413755415149,-5521.5097892969306,0,0,0,0,0,"TxCAP","=-Cap*TaxCAP*Infla*YearProd"]
[null,null,null,{"$f":"TxCA+TxCAP","v":0},0,0,0,0,{"$f":"TxCA+TxCAP","v":-4619.1865030144945},-4668.1117554939701,-4717.5812015859701,-4767.6013875424869,-4671.6508815031602,-4869.3206036761112,-4921.0331699667231,-4973.323551061344,-5026.19874495975,-4917.807700715699,-5133.7320370999314,-5188.4046096119209,-5243.6909464170658,-5299.598532633514,-5177.3428688874792,-5413.3079050138276,-5471.1251773727308,-5529.5946747407288,-5588.7244078188505,-5451.0248028169008,-5708.997175735557,-5770.1567889360658,-5832.0097980615856,-5894.5647812472098,-5739.6701123771199,0,0,0,0,0,"TAX","=TxCA+TxCAP"]
[]
["FINANCING"]
["CapitalNeed",null,null,{"$f":"-Capex*(1+FinancingRate)","v":33166.199999999997},49749.3,66332.399999999994,106131.84,56382.540000000008,19899.72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"CapFi",{"$f":"_xlfn.FORMULATEXT(K95)","v":"=-Capex*(1+FinancingRate)"}]
["Equity",null,null,{"$f":"CapFi*RpEquity","v":8291.5499999999993},12437.325000000001,16583.099999999999,26532.959999999999,14095.635000000002,4974.93,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Eq","=CapFi*RpEquity"]
[null,null,"CumEq",{"$f":"D96","v":8291.5499999999993},{"$f":"D97+E96","v":20728.875},{"$f":"E97+F96","v":37311.974999999999},63844.934999999998,77940.570000000007,82915.5,{"$f":"I97+J96","v":82915.5},82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,"CumEq","=J97+K96"]
["Debt",null,null,{"$f":"CapFi*RpDebt","v":24874.649999999998},37311.975000000006,49749.299999999996,79598.880000000005,42286.905000000006,14924.79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dt","=CapFi*RpDebt"]
["BqDev",null,null,{"$f":"RpBqDev*Dt","v":12437.324999999999},18655.987500000003,24874.649999999998,39799.440000000002,21143.452500000003,7462.3950000000004,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"UsBqDev","=RpBqDev*Dt"]
["BqExp",null,null,{"$f":"RpBqExp*Dt","v":7462.3949999999986},11193.592500000001,14924.789999999997,23879.664000000001,12686.071500000002,4477.4369999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"UsBqExp","=RpBqExp*Dt"]
["BqCom",null,null,{"$f":"RpBqCom*Dt","v":4974.93},7462.3950000000013,9949.86,15919.776000000002,8457.3810000000012,2984.9580000000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"UsBqCom","=RpBqCom*Dt"]
["DEBT"]
[null,null,"UsBqDev",{"$f":"INDIRECT($C103)","v":12437.324999999999},{"$f":"INDIRECT($C103)","v":18655.987500000003},24874.649999999998,39799.440000000002,21143.452500000003,7462.3950000000004,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDIRECT($C103)","v":0},{"$f":"INDIRECT($C103)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"(Duration>DurGrace)+(Duration>DurGrace+DurDev)","v":0},0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,"PeriodDev",{"$f":"_xlfn.FORMULATEXT(K104)","v":"=(Duration>DurGrace)+(Duration>DurGrace+DurDev)"}]
["DEBTDEV",null,null,{"$f":"D103","v":12437.324999999999},{"$f":"D105+E103*(PeriodDev=0)","v":31093.3125},{"$f":"E105+F103*(PeriodDev=0)","v":55967.962499999994},95767.402499999997,116910.855,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,124373.25,"EncBqDev",{"$f":"_xlfn.FORMULATEXT(K105)","v":"=J105+K103*(PeriodDev=0)"}]
["Linear",null,"Repayment",{"$f":"D105/DurDev*(PeriodDev=1)","v":0},0,0,0,0,0,0,{"$f":"K105/DurDev*(PeriodDev=1)","v":8291.5499999999993},8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,8291.5499999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoLinDev",{"$f":"_xlfn.FORMULATEXT(K106)","v":"=K105/DurDev*(PeriodDev=1)"}]
[null,null,"OutstandingC",{"$f":"D105-D106","v":12437.324999999999},{"$f":"D107+E103-E106","v":31093.3125},{"$f":"E107+F103-F106","v":55967.962499999994},{"$f":"F107+G103-G106","v":95767.402499999997},{"$f":"G107+H103-H106","v":116910.855},{"$f":"H107+I103-I106","v":124373.25},{"$f":"I107+J103-J106","v":124373.25},{"$f":"J107+K103-K106","v":116081.7},{"$f":"K107+L103-L106","v":107790.15},{"$f":"L107+M103-M106","v":99498.599999999991},{"$f":"M107+N103-N106","v":91207.049999999988},{"$f":"N107+O103-O106","v":82915.499999999985},{"$f":"O107+P103-P106","v":74623.949999999983},{"$f":"P107+Q103-Q106","v":66332.39999999998},{"$f":"Q107+R103-R106","v":58040.849999999977},{"$f":"R107+S103-S106","v":49749.299999999974},{"$f":"S107+T103-T106","v":41457.749999999971},{"$f":"T107+U103-U106","v":33166.199999999968},{"$f":"U107+V103-V106","v":24874.649999999969},16583.099999999969,{"$f":"W107+X103-X106","v":8291.5499999999702},{"$f":"X107+Y103-Y106","v":-2.9103830456733704E-11},{"$f":"Y107+Z103-Z106","v":-2.9103830456733704E-11},{"$f":"Z107+AA103-AA106","v":-2.9103830456733704E-11},{"$f":"AA107+AB103-AB106","v":-2.9103830456733704E-11},-2.9103830456733704E-11,{"$f":"AC107+AD103-AD106","v":-2.9103830456733704E-11},{"$f":"AD107+AE103-AE106","v":-2.9103830456733704E-11},{"$f":"AE107+AF103-AF106","v":-2.9103830456733704E-11},{"$f":"AF107+AG103-AG106","v":-2.9103830456733704E-11},{"$f":"AG107+AH103-AH106","v":-2.9103830456733704E-11},-2.9103830456733704E-11,{"$f":"AI107+AJ103-AJ106","v":-2.9103830456733704E-11},{"$f":"AJ107+AK103-AK106","v":-2.9103830456733704E-11},{"$f":"AK107+AL103-AL106","v":-2.9103830456733704E-11},"CrdLinDev","=J107+K103-K106"]
[null,null,"Interest",0,{"$f":"D107*RateBqDev","v":248.7465},621.86625000000004,1119.35925,1915.3480500000001,2338.2170999999998,2487.4650000000001,2487.4650000000001,2321.634,2155.8029999999999,1989.972,1824.1409999999998,1658.3099999999997,1492.4789999999996,1326.6479999999997,1160.8169999999996,994.98599999999954,829.1549999999994,663.32399999999939,497.49299999999937,331.66199999999941,165.83099999999942,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,"IntLinDev","=J107*RateBqDev"]
[null,null,"Installment",{"$f":"D108+D106","v":0},248.7465,621.86625000000004,1119.35925,1915.3480500000001,2338.2170999999998,2487.4650000000001,10779.014999999999,10613.183999999999,10447.352999999999,10281.521999999999,10115.690999999999,9949.8599999999988,9784.0289999999986,9618.1979999999985,9452.3669999999984,9286.5359999999982,9120.7049999999981,8954.873999999998,8789.0429999999978,8623.2119999999995,8457.3809999999994,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,"EchLinDev","=K108+K106"]
[null,null,{"$f":"IRR(FluxLinDev)","v":2.0000000000010454E-2},{"$f":"D103-D109","v":12437.324999999999},{"$f":"E103-E109","v":18407.241000000002},24252.783749999999,38680.080750000001,19228.104450000003,5124.1779000000006,-2487.4650000000001,-10779.014999999999,{"$f":"L103-L109","v":-10613.183999999999},-10447.352999999999,-10281.521999999999,-10115.690999999999,-9949.8599999999988,-9784.0289999999986,-9618.1979999999985,-9452.3669999999984,-9286.5359999999982,-9120.7049999999981,-8954.873999999998,-8789.0429999999978,-8623.2119999999995,-8457.3809999999994,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,"FluxLinDev","=K103-K109"]
[null,null,null,{"$f":"D104","v":0},{"$f":"D111+E104*(PeriodDev=1)","v":0},0,0,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,"PeriodDevCum"]
["Constant",null,"Repayment",{"$f":"(PeriodDev=1)*IntVarDev/((1+RateBqDev)^(DurDev-PeriodDevCum+1)-1)","v":0},0,0,0,0,0,0,7191.941916547682,7335.7807548786268,7482.4963699762029,7632.1462973757252,7784.789223323246,7940.4850077897036,8099.2947079454998,8261.2806021044107,8426.5062141465041,8595.0363384294178,8766.9370651980098,8942.2758065019734,9121.1213226320197,9303.5437490846471,9489.6146240663275,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoVarDev","=(PeriodDev=1)*IntVarDev/((1+RateBqDev)^(DurDev-PeriodDevCum+1)-1)"]
[null,null,"OutstandingC",{"$f":"D103","v":12437.324999999999},{"$f":"D113+E103-E112","v":31093.3125},55967.962499999994,95767.402499999997,116910.855,124373.25,124373.25,117181.30808345231,109845.52732857369,102363.03095859749,94730.88466122176,86946.095437898519,79005.61043010882,70906.315722163316,62645.035120058907,54218.528905912404,45623.492567482986,36856.555502284973,27914.279695783,18793.158373150982,9489.6146240663347,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"CrdVarDev","=J113+K103-K112"]
[null,null,"Interest",0,{"$f":"D113*RateBqDev","v":248.7465},621.86625000000004,1119.35925,1915.3480500000001,2338.2170999999998,2487.4650000000001,2487.4650000000001,2343.6261616690463,2196.9105465714738,2047.2606191719499,1894.6176932244352,1738.9219087579704,1580.1122086021765,1418.1263144432664,1252.9007024011783,1084.3705781182482,912.46985134965973,737.13111004569953,558.28559391566,375.86316746301964,189.79229248132671,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntVarDev","=J113*RateBqDev"]
[null,null,"Installment",{"$f":"D112+D114","v":0},{"$f":"E112+E114","v":248.7465},{"$f":"F112+F114","v":621.86625000000004},{"$f":"G112+G114","v":1119.35925},{"$f":"H112+H114","v":1915.3480500000001},{"$f":"I112+I114","v":2338.2170999999998},{"$f":"J112+J114","v":2487.4650000000001},{"$f":"K112+K114","v":9679.4069165476831},{"$f":"L112+L114","v":9679.4069165476722},{"$f":"M112+M114","v":9679.4069165476758},{"$f":"N112+N114","v":9679.4069165476758},{"$f":"O112+O114","v":9679.4069165476812},{"$f":"P112+P114","v":9679.406916547674},{"$f":"Q112+Q114","v":9679.4069165476758},{"$f":"R112+R114","v":9679.4069165476776},{"$f":"S112+S114","v":9679.4069165476831},{"$f":"T112+T114","v":9679.4069165476667},{"$f":"U112+U114","v":9679.4069165476703},{"$f":"V112+V114","v":9679.4069165476722},{"$f":"W112+W114","v":9679.4069165476794},{"$f":"X112+X114","v":9679.4069165476667},{"$f":"Y112+Y114","v":9679.406916547654},{"$f":"Z112+Z114","v":0},{"$f":"AA112+AA114","v":0},{"$f":"AB112+AB114","v":0},{"$f":"AC112+AC114","v":0},{"$f":"AD112+AD114","v":0},{"$f":"AE112+AE114","v":0},{"$f":"AF112+AF114","v":0},{"$f":"AG112+AG114","v":0},{"$f":"AH112+AH114","v":0},{"$f":"AI112+AI114","v":0},{"$f":"AJ112+AJ114","v":0},{"$f":"AK112+AK114","v":0},{"$f":"AL112+AL114","v":0},"EchVarDev","=K112+K114"]
[null,null,{"$f":"IRR(FluxVarDev)","v":2.0000000000060414E-2},{"$f":"D103-D115","v":12437.324999999999},{"$f":"E103-E115","v":18407.241000000002},{"$f":"F103-F115","v":24252.783749999999},{"$f":"G103-G115","v":38680.080750000001},{"$f":"H103-H115","v":19228.104450000003},{"$f":"I103-I115","v":5124.1779000000006},{"$f":"J103-J115","v":-2487.4650000000001},{"$f":"K103-K115","v":-9679.4069165476831},{"$f":"L103-L115","v":-9679.4069165476722},{"$f":"M103-M115","v":-9679.4069165476758},{"$f":"N103-N115","v":-9679.4069165476758},{"$f":"O103-O115","v":-9679.4069165476812},{"$f":"P103-P115","v":-9679.406916547674},{"$f":"Q103-Q115","v":-9679.4069165476758},{"$f":"R103-R115","v":-9679.4069165476776},{"$f":"S103-S115","v":-9679.4069165476831},{"$f":"T103-T115","v":-9679.4069165476667},{"$f":"U103-U115","v":-9679.4069165476703},{"$f":"V103-V115","v":-9679.4069165476722},{"$f":"W103-W115","v":-9679.4069165476794},{"$f":"X103-X115","v":-9679.4069165476667},{"$f":"Y103-Y115","v":-9679.406916547654},{"$f":"Z103-Z115","v":0},{"$f":"AA103-AA115","v":0},{"$f":"AB103-AB115","v":0},{"$f":"AC103-AC115","v":0},{"$f":"AD103-AD115","v":0},{"$f":"AE103-AE115","v":0},{"$f":"AF103-AF115","v":0},{"$f":"AG103-AG115","v":0},{"$f":"AH103-AH115","v":0},{"$f":"AI103-AI115","v":0},{"$f":"AJ103-AJ115","v":0},{"$f":"AK103-AK115","v":0},{"$f":"AL103-AL115","v":0},"FluxVarDev","=K103-K115"]
["DSCR",null,"DSCRnum",{"$f":"DSCRNUM*RpBqDev","v":0},0,0,0,0,{"$f":"DSCRNUM*RpBqDev","v":14365.777995846021},17203.3932097828,17371.258384346969,17540.718418630357,7755.5737770470078,16029.948131748435,18058.810867932669,18234.794074804839,18412.444555219405,8137.5159489012585,16825.638738778311,18955.548314806209,19140.017121532743,19326.228374130471,8537.5108219539252,17659.616101687061,19895.471063285302,20088.806918598119,20283.963193472136,8956.3296360763979,18533.592445979924,20880.514445463792,21083.112878012442,21287.612539977272,9394.7673175869295,1148.7375812680752,0,0,0,0,"DscrDev","=DSCRNUM*RpBqDev"]
[null,null,"Repayment",{"$f":"PeriodDev*DscrDev/DSCRTarget","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-E120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-F120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-G120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-H120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-I120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-J120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-K120)","v":9093.3739228979794},{"$f":"PeriodDev*(DscrDev/DSCRTarget-L120)","v":9388.2147575448635},{"$f":"PeriodDev*(DscrDev/DSCRTarget-M120)","v":3052.5492916401959},{"$f":"PeriodDev*(DscrDev/DSCRTarget-N120)","v":8629.8498472739502},{"$f":"PeriodDev*(DscrDev/DSCRTarget-O120)","v":10155.022001675585},{"$f":"PeriodDev*(DscrDev/DSCRTarget-P120)","v":10475.444579623878},{"$f":"PeriodDev*(DscrDev/DSCRTarget-Q120)","v":10803.387124826066},{"$f":"PeriodDev*(DscrDev/DSCRTarget-R120)","v":4169.5024631104898},{"$f":"PeriodDev*(DscrDev/DSCRTarget-S120)","v":10044.974372290733},{"$f":"PeriodDev*(DscrDev/DSCRTarget-T120)","v":11665.81357708848},{"$f":"PeriodDev*(DscrDev/DSCRTarget-U120)","v":12022.109053114606},{"$f":"PeriodDev*(DscrDev/DSCRTarget-V120)","v":12386.692069242052},{"$f":"PeriodDev*(DscrDev/DSCRTarget-W120)","v":5441.9475425091941},{"$f":"PeriodDev*(DscrDev/DSCRTarget-X120)","v":11632.190013181469},{"$f":"PeriodDev*(DscrDev/DSCRTarget-Y120)","v":13263.647375523535},{"$f":"PeriodDev*(DscrDev/DSCRTarget-Z120)","v":26785.075891464159},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AA120)","v":27045.284257962849},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AB120)","v":11941.772848101864},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AC120)","v":24711.456594639898},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AD120)","v":27840.685927285056},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AE120)","v":28110.817170683255},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AF120)","v":28383.483386636362},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AG120)","v":12526.356423449239},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AH120)","v":1531.6501083574337},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AI120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AJ120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AK120)","v":0},{"$f":"PeriodDev*(DscrDev/DSCRTarget-AL120)","v":0},"AmoDSDev","=PeriodDev*(DscrDev/DSCRTarget-K120)"]
[null,null,"OutstandingC",{"$f":"D103","v":12437.324999999999},{"$f":"MAX(D119+E103-E118,0)","v":31093.3125},{"$f":"MAX(E119+F103-F118,0)","v":55967.962499999994},95767.402499999997,116910.855,124373.25,124373.25,115279.87607710202,105891.66131955716,102839.11202791696,94209.262180643011,84054.240178967419,73578.795599343546,62775.408474517477,58605.906011406987,48560.931639116257,36895.118062027774,24873.00900891317,12486.316939671118,7044.3693971619241,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"CrdDSDev","=MAX(J119+K103-K118;0)"]
[null,null,"Interest",0,{"$f":"D119*RateBqDev","v":248.7465},{"$f":"E119*RateBqDev","v":621.86625000000004},{"$f":"F119*RateBqDev","v":1119.35925},{"$f":"G119*RateBqDev","v":1915.3480500000001},{"$f":"H119*RateBqDev","v":2338.2170999999998},{"$f":"I119*RateBqDev","v":2487.4650000000001},{"$f":"J119*RateBqDev","v":2487.4650000000001},{"$f":"K119*RateBqDev","v":2305.5975215420403},{"$f":"L119*RateBqDev","v":2117.8332263911429},{"$f":"M119*RateBqDev","v":2056.7822405583393},{"$f":"N119*RateBqDev","v":1884.1852436128602},{"$f":"O119*RateBqDev","v":1681.0848035793483},{"$f":"P119*RateBqDev","v":1471.575911986871},{"$f":"Q119*RateBqDev","v":1255.5081694903495},{"$f":"R119*RateBqDev","v":1172.1181202281398},{"$f":"S119*RateBqDev","v":971.21863278232513},{"$f":"T119*RateBqDev","v":737.90236124055548},{"$f":"U119*RateBqDev","v":497.46018017826339},{"$f":"V119*RateBqDev","v":249.72633879342237},{"$f":"W119*RateBqDev","v":140.88738794323848},{"$f":"X119*RateBqDev","v":0},{"$f":"Y119*RateBqDev","v":0},{"$f":"Z119*RateBqDev","v":0},{"$f":"AA119*RateBqDev","v":0},{"$f":"AB119*RateBqDev","v":0},{"$f":"AC119*RateBqDev","v":0},{"$f":"AD119*RateBqDev","v":0},{"$f":"AE119*RateBqDev","v":0},{"$f":"AF119*RateBqDev","v":0},{"$f":"AG119*RateBqDev","v":0},{"$f":"AH119*RateBqDev","v":0},{"$f":"AI119*RateBqDev","v":0},{"$f":"AJ119*RateBqDev","v":0},{"$f":"AK119*RateBqDev","v":0},"IntDSDev","=J119*RateBqDev"]
[null,null,"Installment",{"$f":"D118+D120","v":0},{"$f":"E118+E120","v":248.7465},621.86625000000004,1119.35925,1915.3480500000001,2338.2170999999998,2487.4650000000001,{"$f":"(J119-K119)+K120","v":11580.838922897983},{"$f":"(K119-L119)+L120","v":11693.812279086902},5170.3825180313434,10686.632087832284,12039.207245288453,12156.52938320322,12274.96303681294,5425.010632600839,11217.09249251887,12637.032209870809,12760.01141435516,12884.152249420315,5691.6738813026168,7185.2567851051626,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"EchDSDev","=(J119-K119)+K120"]
[null,null,{"$f":"IRR(FluxDSDev)","v":2.0000000000000684E-2},{"$f":"D103-D121","v":12437.324999999999},{"$f":"E103-E121","v":18407.241000000002},24252.783749999999,38680.080750000001,19228.104450000003,5124.1779000000006,-2487.4650000000001,-11580.838922897983,-11693.812279086902,-5170.3825180313434,-10686.632087832284,-12039.207245288453,-12156.52938320322,-12274.96303681294,-5425.010632600839,-11217.09249251887,-12637.032209870809,-12760.01141435516,-12884.152249420315,-5691.6738813026168,-7185.2567851051626,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FluxDSDev","=K103-K121"]
[]
[null,null,"UsBqExp",{"$f":"INDIRECT($C124)","v":7462.3949999999986},{"$f":"INDIRECT($C124)","v":11193.592500000001},14924.789999999997,23879.664000000001,12686.071500000002,4477.4369999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDIRECT($C124)","v":0},{"$f":"INDIRECT($C124)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"(Duration>DurGrace)+(Duration>DurGrace+DurExp)","v":0},0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,"PeriodExp",{"$f":"_xlfn.FORMULATEXT(K125)","v":"=(Duration>DurGrace)+(Duration>DurGrace+DurExp)"}]
["DEBTEXP",null,null,{"$f":"D124","v":7462.3949999999986},{"$f":"D126+E124*(PeriodExp=0)","v":18655.987499999999},33580.777499999997,57460.441500000001,70146.513000000006,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,74623.950000000012,"EncBqExp",{"$f":"_xlfn.FORMULATEXT(K126)","v":"=J126+K124*(PeriodExp=0)"}]
["Linear",null,"Repayment",{"$f":"D126/DurExp*(PeriodExp=1)","v":0},0,0,0,0,0,0,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,6218.6625000000013,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoLinExp",{"$f":"_xlfn.FORMULATEXT(K127)","v":"=K126/DurExp*(PeriodExp=1)"}]
[null,null,"OutstandingC",{"$f":"D126-D127","v":7462.3949999999986},{"$f":"D128+E124-E127","v":18655.987499999999},{"$f":"E128+F124-F127","v":33580.777499999997},{"$f":"F128+G124-G127","v":57460.441500000001},{"$f":"G128+H124-H127","v":70146.513000000006},{"$f":"H128+I124-I127","v":74623.950000000012},{"$f":"I128+J124-J127","v":74623.950000000012},{"$f":"J128+K124-K127","v":68405.287500000006},{"$f":"K128+L124-L127","v":62186.625000000007},{"$f":"L128+M124-M127","v":55967.962500000009},{"$f":"M128+N124-N127","v":49749.30000000001},{"$f":"N128+O124-O127","v":43530.637500000012},{"$f":"O128+P124-P127","v":37311.975000000013},{"$f":"P128+Q124-Q127","v":31093.312500000011},{"$f":"Q128+R124-R127","v":24874.650000000009},{"$f":"R128+S124-S127","v":18655.987500000007},{"$f":"S128+T124-T127","v":12437.325000000004},{"$f":"T128+U124-U127","v":6218.6625000000031},{"$f":"U128+V124-V127","v":0},{"$f":"V128+W124-W127","v":0},{"$f":"W128+X124-X127","v":0},{"$f":"X128+Y124-Y127","v":0},{"$f":"Y128+Z124-Z127","v":0},{"$f":"Z128+AA124-AA127","v":0},{"$f":"AA128+AB124-AB127","v":0},{"$f":"AB128+AC124-AC127","v":0},{"$f":"AC128+AD124-AD127","v":0},{"$f":"AD128+AE124-AE127","v":0},{"$f":"AE128+AF124-AF127","v":0},{"$f":"AF128+AG124-AG127","v":0},{"$f":"AG128+AH124-AH127","v":0},{"$f":"AH128+AI124-AI127","v":0},{"$f":"AI128+AJ124-AJ127","v":0},{"$f":"AJ128+AK124-AK127","v":0},{"$f":"AK128+AL124-AL127","v":0},"CrdLinExp","=J128+K124-K127"]
[null,null,"Interest",0,{"$f":"D128*RateBqExp","v":447.74369999999988},1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,4477.4370000000008,4104.3172500000001,3731.1975000000002,3358.0777500000004,2984.9580000000005,2611.8382500000007,2238.7185000000009,1865.5987500000006,1492.4790000000005,1119.3592500000004,746.23950000000025,373.11975000000018,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntLinExp","=J128*RateBqExp"]
[null,null,"Installment",{"$f":"D129+D127","v":0},447.74369999999988,1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,10696.099500000002,10322.979750000002,9949.86,9576.7402500000026,9203.6205000000009,8830.5007500000029,8457.3810000000012,8084.2612500000014,7711.1415000000015,7338.0217500000017,6964.9020000000019,6591.7822500000011,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"EchLinExp","=K129+K127"]
[null,null,{"$f":"IRR(FluxLinExp)","v":6.0000000000101528E-2},{"$f":"D124-D130","v":7462.3949999999986},{"$f":"E124-E130","v":10745.848800000002},13805.430749999998,21864.817350000001,9238.4450100000013,268.64621999999963,-4477.4370000000008,-10696.099500000002,{"$f":"L124-L130","v":-10322.979750000002},{"$f":"M124-M130","v":-9949.86},-9576.7402500000026,-9203.6205000000009,-8830.5007500000029,-8457.3810000000012,-8084.2612500000014,-7711.1415000000015,-7338.0217500000017,-6964.9020000000019,-6591.7822500000011,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FluxLinExp","=K124-K130"]
[null,null,null,{"$f":"D125","v":0},{"$f":"D132+E125*(PeriodExp=1)","v":0},0,0,0,0,0,1,2,3,4,5,6,7,8,9,10,11,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,"PeriodExpCum"]
["Constant",null,"Repayment",{"$f":"(PeriodDev=1)*IntVarExp/((1+RateBqExp)^(DurExp-PeriodExpCum+1)-1)","v":0},0,0,0,0,0,0,4423.4860766511692,4688.8952412502395,4970.2289557252552,5268.4426930687723,5584.5492546528994,5919.6222099320712,6274.7995425279978,6651.287515079679,7050.3647659844646,7473.3866519435333,7921.7898510601535,8397.0972421237766,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoVarExp",{"$f":"_xlfn.FORMULATEXT(K133)","v":"=(PeriodDev=1)*IntVarExp/((1+RateBqExp)^(DurExp-PeriodExpCum+1)-1)"}]
[null,null,"OutstandingC",{"$f":"D124","v":7462.3949999999986},{"$f":"D134+E124-E133","v":18655.987499999999},{"$f":"E134+F124-F133","v":33580.777499999997},{"$f":"F134+G124-G133","v":57460.441500000001},{"$f":"G134+H124-H133","v":70146.513000000006},{"$f":"H134+I124-I133","v":74623.950000000012},{"$f":"I134+J124-J133","v":74623.950000000012},{"$f":"J134+K124-K133","v":70200.463923348841},{"$f":"K134+L124-L133","v":65511.568682098601},{"$f":"L134+M124-M133","v":60541.33972637335},{"$f":"M134+N124-N133","v":55272.89703330458},{"$f":"N134+O124-O133","v":49688.347778651681},{"$f":"O134+P124-P133","v":43768.725568719608},{"$f":"P134+Q124-Q133","v":37493.926026191613},{"$f":"Q134+R124-R133","v":30842.638511111934},{"$f":"R134+S124-S133","v":23792.27374512747},{"$f":"S134+T124-T133","v":16318.887093183937},{"$f":"T134+U124-U133","v":8397.0972421237839},{"$f":"U134+V124-V133","v":0},{"$f":"V134+W124-W133","v":0},{"$f":"W134+X124-X133","v":0},{"$f":"X134+Y124-Y133","v":0},{"$f":"Y134+Z124-Z133","v":0},{"$f":"Z134+AA124-AA133","v":0},{"$f":"AA134+AB124-AB133","v":0},{"$f":"AB134+AC124-AC133","v":0},{"$f":"AC134+AD124-AD133","v":0},{"$f":"AD134+AE124-AE133","v":0},{"$f":"AE134+AF124-AF133","v":0},{"$f":"AF134+AG124-AG133","v":0},{"$f":"AG134+AH124-AH133","v":0},{"$f":"AH134+AI124-AI133","v":0},{"$f":"AI134+AJ124-AJ133","v":0},{"$f":"AJ134+AK124-AK133","v":0},{"$f":"AK134+AL124-AL133","v":0},"CrdVarExp","=J134+K124-K133"]
[null,null,"Interest",0,{"$f":"D134*RateBqExp","v":447.74369999999988},1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,4477.4370000000008,4212.0278354009306,3930.6941209259157,3632.4803835824009,3316.3738219982747,2981.3008667191007,2626.1235341231763,2249.6355615714965,1850.5583106667159,1427.5364247076482,979.13322559103619,503.82583452742699,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntVarExp","=J134*RateBqExp"]
[null,null,"Installment",{"$f":"D133+D135","v":0},{"$f":"E133+E135","v":447.74369999999988},1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,{"$f":"K133+K135","v":8900.92307665117},{"$f":"L133+L135","v":8900.92307665117},8900.9230766511719,8900.9230766511737,8900.9230766511737,8900.9230766511719,8900.9230766511737,8900.9230766511755,8900.923076651181,8900.923076651181,8900.9230766511901,8900.9230766512028,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"EchVarExp","=K133+K135"]
[null,null,{"$f":"IRR(FluxVarExp)","v":5.9999999999999831E-2},{"$f":"D124-D136","v":7462.3949999999986},{"$f":"E124-E136","v":10745.848800000002},13805.430749999998,21864.817350000001,9238.4450100000013,268.64621999999963,-4477.4370000000008,-8900.92307665117,-8900.92307665117,-8900.9230766511719,-8900.9230766511737,-8900.9230766511737,-8900.9230766511719,-8900.9230766511737,-8900.9230766511755,-8900.923076651181,-8900.923076651181,-8900.9230766511901,-8900.9230766512028,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FluxVarExp","=K124-K136"]
["DSCR",null,"DSCRnum",{"$f":"DSCRNUM*RpBqExp","v":0},0,0,0,0,8619.4667975076118,10322.035925869679,10422.755030608181,10524.431051178213,4653.3442662282041,9617.96887904906,10835.286520759601,10940.876444882902,11047.466733131643,4882.5095693407548,10095.383243266986,11373.328988883724,11484.010272919646,11595.737024478281,5122.5064931723546,10595.769661012237,11937.282637971181,12053.28415115887,12170.377916083282,5373.7977816458388,11120.155467587954,12528.308667278276,12649.867726807464,12772.567523986363,5636.8603905521577,689.24254876084512,0,0,0,0,"DscrExp","=DSCRNUM*RpBqExp"]
[null,null,"Repayment",{"$f":"PeriodDev*DscrDev/DSCRTarget","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-E141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-F141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-G141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-H141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-I141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-J141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-K141)","v":2471.0663537387863},{"$f":"PeriodExp*(DscrExp/DSCRTarget-L141)","v":2687.1143486764695},{"$f":"PeriodExp*(DscrExp/DSCRTarget-M141)","v":-1065.7166470362827},{"$f":"PeriodExp*(DscrExp/DSCRTarget-N141)","v":2180.0900960221106},{"$f":"PeriodExp*(DscrExp/DSCRTarget-O141)","v":3122.4405962571309},{"$f":"PeriodExp*(DscrExp/DSCRTarget-P141)","v":3380.1803147814267},{"$f":"PeriodExp*(DscrExp/DSCRTarget-Q141)","v":3654.0513258341398},{"$f":"PeriodExp*(DscrExp/DSCRTarget-R141)","v":-236.67703714307117},{"$f":"PeriodExp*(DscrExp/DSCRTarget-S141)","v":3224.3714565791652},{"$f":"PeriodExp*(DscrExp/DSCRTarget-T141)","v":4269.7975743850748},{"$f":"PeriodExp*(DscrExp/DSCRTarget-U141)","v":4599.7729515387937},{"$f":"PeriodExp*(DscrExp/DSCRTarget-V141)","v":4950.2438296702112},{"$f":"PeriodExp*(DscrExp/DSCRTarget-W141)","v":1863.5428771596116},{"$f":"PeriodExp*(DscrExp/DSCRTarget-X141)","v":9384.8522462052752},{"$f":"PeriodExp*(DscrExp/DSCRTarget-Y141)","v":12299.718485028499},{"$f":"PeriodExp*(DscrExp/DSCRTarget-Z141)","v":13930.353387482173},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AA141)","v":15758.120813879248},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AB141)","v":7165.0637088611184},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AC141)","v":14826.873956783938},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AD141)","v":16704.411556371033},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AE141)","v":16866.490302409951},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AF141)","v":17030.090031981817},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AG141)","v":7515.8138540695436},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AH141)","v":918.99006501446013},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AI141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AJ141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AK141)","v":0},{"$f":"PeriodExp*(DscrExp/DSCRTarget-AL141)","v":0},"AmoDSExp","=PeriodExp*(DscrExp/DSCRTarget-K141)"]
[null,null,"OutstandingC",{"$f":"D124","v":7462.3949999999986},{"$f":"MAX(D140+E124-E139,0)","v":18655.987499999999},{"$f":"MAX(E140+F124-F139,0)","v":33580.777499999997},{"$f":"MAX(F140+G124-G139,0)","v":57460.441500000001},{"$f":"MAX(G140+H124-H139,0)","v":70146.513000000006},{"$f":"MAX(H140+I124-I139,0)","v":74623.950000000012},{"$f":"MAX(I140+J124-J139,0)","v":74623.950000000012},{"$f":"MAX(J140+K124-K139,0)","v":72152.883646261223},{"$f":"MAX(K140+L124-L139,0)","v":69465.76929758476},{"$f":"MAX(L140+M124-M139,0)","v":70531.485944621047},{"$f":"MAX(M140+N124-N139,0)","v":68351.395848598942},{"$f":"MAX(N140+O124-O139,0)","v":65228.95525234181},{"$f":"MAX(O140+P124-P139,0)","v":61848.774937560382},{"$f":"MAX(P140+Q124-Q139,0)","v":58194.723611726244},{"$f":"MAX(Q140+R124-R139,0)","v":58431.400648869312},{"$f":"MAX(R140+S124-S139,0)","v":55207.029192290145},{"$f":"MAX(S140+T124-T139,0)","v":50937.231617905069},{"$f":"MAX(T140+U124-U139,0)","v":46337.458666366278},{"$f":"MAX(U140+V124-V139,0)","v":41387.214836696068},{"$f":"MAX(V140+W124-W139,0)","v":39523.671959536456},{"$f":"MAX(W140+X124-X139,0)","v":30138.819713331181},{"$f":"MAX(X140+Y124-Y139,0)","v":17839.101228302679},{"$f":"MAX(Y140+Z124-Z139,0)","v":3908.7478408205061},{"$f":"MAX(Z140+AA124-AA139,0)","v":0},{"$f":"MAX(AA140+AB124-AB139,0)","v":0},{"$f":"MAX(AB140+AC124-AC139,0)","v":0},{"$f":"MAX(AC140+AD124-AD139,0)","v":0},{"$f":"MAX(AD140+AE124-AE139,0)","v":0},{"$f":"MAX(AE140+AF124-AF139,0)","v":0},{"$f":"MAX(AF140+AG124-AG139,0)","v":0},{"$f":"MAX(AG140+AH124-AH139,0)","v":0},{"$f":"MAX(AH140+AI124-AI139,0)","v":0},{"$f":"MAX(AI140+AJ124-AJ139,0)","v":0},{"$f":"MAX(AJ140+AK124-AK139,0)","v":0},{"$f":"MAX(AK140+AL124-AL139,0)","v":0},"CrdDSExp","=MAX(J140+K124-K139;0)"]
[null,null,"Interest",0,{"$f":"D140*RateBqExp","v":447.74369999999988},1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,4477.4370000000008,4329.173018775673,4167.9461578550854,4231.8891566772627,4101.0837509159364,3913.7373151405086,3710.9264962536226,3491.6834167035745,3505.8840389321585,3312.4217515374085,3056.233897074304,2780.2475199819764,2483.2328902017639,2371.4203175721873,1808.3291827998708,1070.3460736981608,234.52487044923035,0,0,0,0,0,0,0,0,0,0,0,"IntDSExp","=J140*RateBqExp"]
[null,null,"Installment",{"$f":"D139+D141","v":0},{"$f":"E139+E141","v":447.74369999999988},1119.35925,2014.8466499999997,3447.6264900000001,4208.7907800000003,4477.4370000000008,{"$f":"(J140-K140)+K141","v":6948.503353738789},{"$f":"(K140-L140)+L141","v":7016.2873674521361},{"$f":"(L140-M140)+M141","v":3102.2295108187991},{"$f":"(M140-N140)+N141","v":6411.979252699367},{"$f":"(N140-O140)+O141","v":7223.5243471730691},{"$f":"(O140-P140)+P141","v":7293.9176299219362},{"$f":"(P140-Q140)+Q141","v":7364.9778220877606},{"$f":"(Q140-R140)+R141","v":3255.006379560506},{"$f":"(R140-S140)+S141","v":6730.2554955113255},{"$f":"(S140-T140)+T141","v":7582.219325922485},{"$f":"(T140-U140)+U141","v":7656.0068486130949},{"$f":"(U140-V140)+V141","v":7730.4913496521858},{"$f":"(V140-W140)+W141","v":4346.775767361376},{"$f":"(W140-X140)+X141","v":11756.272563777462},{"$f":"(X140-Y140)+Y141","v":14108.047667828372},{"$f":"(Y140-Z140)+Z141","v":15000.699461180335},{"$f":"(Z140-AA140)+AA141","v":4143.2727112697366},{"$f":"(AA140-AB140)+AB141","v":0},{"$f":"(AB140-AC140)+AC141","v":0},{"$f":"(AC140-AD140)+AD141","v":0},{"$f":"(AD140-AE140)+AE141","v":0},{"$f":"(AE140-AF140)+AF141","v":0},{"$f":"(AF140-AG140)+AG141","v":0},{"$f":"(AG140-AH140)+AH141","v":0},{"$f":"(AH140-AI140)+AI141","v":0},{"$f":"(AI140-AJ140)+AJ141","v":0},{"$f":"(AJ140-AK140)+AK141","v":0},{"$f":"(AK140-AL140)+AL141","v":0},"EchDSExp","=(J140-K140)+K141"]
[null,null,{"$f":"IRR(FluxDSExp)","v":6.0000000000000053E-2},{"$f":"D124-D142","v":7462.3949999999986},{"$f":"E124-E142","v":10745.848800000002},{"$f":"F124-F142","v":13805.430749999998},{"$f":"G124-G142","v":21864.817350000001},{"$f":"H124-H142","v":9238.4450100000013},{"$f":"I124-I142","v":268.64621999999963},{"$f":"J124-J142","v":-4477.4370000000008},{"$f":"K124-K142","v":-6948.503353738789},{"$f":"L124-L142","v":-7016.2873674521361},{"$f":"M124-M142","v":-3102.2295108187991},{"$f":"N124-N142","v":-6411.979252699367},{"$f":"O124-O142","v":-7223.5243471730691},{"$f":"P124-P142","v":-7293.9176299219362},{"$f":"Q124-Q142","v":-7364.9778220877606},{"$f":"R124-R142","v":-3255.006379560506},{"$f":"S124-S142","v":-6730.2554955113255},{"$f":"T124-T142","v":-7582.219325922485},{"$f":"U124-U142","v":-7656.0068486130949},{"$f":"V124-V142","v":-7730.4913496521858},{"$f":"W124-W142","v":-4346.775767361376},{"$f":"X124-X142","v":-11756.272563777462},{"$f":"Y124-Y142","v":-14108.047667828372},{"$f":"Z124-Z142","v":-15000.699461180335},{"$f":"AA124-AA142","v":-4143.2727112697366},{"$f":"AB124-AB142","v":0},{"$f":"AC124-AC142","v":0},{"$f":"AD124-AD142","v":0},{"$f":"AE124-AE142","v":0},{"$f":"AF124-AF142","v":0},{"$f":"AG124-AG142","v":0},{"$f":"AH124-AH142","v":0},{"$f":"AI124-AI142","v":0},{"$f":"AJ124-AJ142","v":0},{"$f":"AK124-AK142","v":0},{"$f":"AL124-AL142","v":0},"FluxDSExp","=K124-K142"]
[]
[null,null,"UsBqCom",{"$f":"INDIRECT($C145)","v":4974.93},{"$f":"INDIRECT($C145)","v":7462.3950000000013},9949.86,15919.776000000002,8457.3810000000012,2984.9580000000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"INDIRECT($C145)","v":0},{"$f":"INDIRECT($C145)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"(Duration>DurGrace)+(Duration>DurGrace+DurDev)","v":0},{"$f":"(Duration>DurGrace)+(Duration>DurGrace+DurCom)","v":0},0,0,0,0,0,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,"PeriodCom",{"$f":"_xlfn.FORMULATEXT(K146)","v":"=(Duration>DurGrace)+(Duration>DurGrace+DurCom)"}]
["DEBTCOM",null,null,{"$f":"D145","v":4974.93},{"$f":"D147+E145*(PeriodCom=0)","v":12437.325000000001},22387.185000000001,38306.961000000003,46764.342000000004,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,49749.3,"EncBqCom",{"$f":"_xlfn.FORMULATEXT(K147)","v":"=J147+K145*(PeriodCom=0)"}]
["Linear",null,"Repayment",{"$f":"D147/DurDev*(PeriodDev=1)","v":0},{"$f":"E147/DurCom*(PeriodCom=1)","v":0},0,0,0,0,0,7107.0428571428574,7107.0428571428574,7107.0428571428574,7107.0428571428574,7107.0428571428574,7107.0428571428574,7107.0428571428574,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoLinCom",{"$f":"_xlfn.FORMULATEXT(K148)","v":"=K147/DurCom*(PeriodCom=1)"}]
[null,null,"OutstandingC",{"$f":"D147-D148","v":4974.93},{"$f":"D149+E145-E148","v":12437.325000000001},{"$f":"E149+F145-F148","v":22387.185000000001},38306.961000000003,46764.342000000004,49749.3,49749.3,42642.257142857146,35535.21428571429,28428.171428571433,21321.128571428577,14214.08571428572,7107.0428571428629,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"CrdLinCom","=J149+K145-K148"]
[null,null,"Interest",0,{"$f":"D149*RateBqCom","v":348.24510000000004},870.61275000000012,1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,3482.4510000000005,2984.9580000000005,2487.4650000000006,1989.9720000000004,1492.4790000000005,994.98600000000056,497.49300000000045,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntLinCom","=J149*RateBqCom"]
[null,null,"Installment",{"$f":"D150+D148","v":0},348.24510000000004,{"$f":"F150+F148","v":870.61275000000012},1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,10589.493857142857,10092.000857142859,9594.5078571428585,9097.0148571428581,8599.5218571428577,8102.0288571428582,7604.5358571428578,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"EchLinCom","=K150+K148"]
[null,null,{"$f":"IRR(FluxLinCom)","v":7.0000000000000062E-2},{"$f":"D145-D151","v":4974.93},{"$f":"E145-E151","v":7114.1499000000013},{"$f":"F145-F151","v":9079.2472500000003},14352.673050000001,5775.8937300000007,-288.54593999999997,-3482.4510000000005,-10589.493857142857,-10092.000857142859,-9594.5078571428585,-9097.0148571428581,-8599.5218571428577,-8102.0288571428582,-7604.5358571428578,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FluxLinCom","=K145-K151"]
[null,null,null,{"$f":"D146","v":0},{"$f":"D153+E146*(PeriodCom=1)","v":0},0,0,0,0,0,1,2,3,4,5,6,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,"PeriodComCum"]
["Constant",null,"Repayment",{"$f":"(PeriodCom=1)*IntVarCom/((1+RateBqCom)^(DurCom-PeriodComCum+1)-1)","v":0},0,0,0,0,0,0,5748.6917893964337,6151.100214654185,6581.6772296799763,7042.3946357575778,7535.3622602606056,8062.8376184788522,8627.236251772365,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoVarCom",{"$f":"_xlfn.FORMULATEXT(K154)","v":"=(PeriodCom=1)*IntVarCom/((1+RateBqCom)^(DurCom-PeriodComCum+1)-1)"}]
[null,null,"OutstandingC",{"$f":"D145","v":4974.93},{"$f":"D155+E145-E154","v":12437.325000000001},{"$f":"E155+F145-F154","v":22387.185000000001},{"$f":"F155+G145-G154","v":38306.961000000003},{"$f":"G155+H145-H154","v":46764.342000000004},{"$f":"H155+I145-I154","v":49749.3},{"$f":"I155+J145-J154","v":49749.3},{"$f":"J155+K145-K154","v":44000.608210603568},{"$f":"K155+L145-L154","v":37849.507995949381},{"$f":"L155+M145-M154","v":31267.830766269406},{"$f":"M155+N145-N154","v":24225.436130511829},{"$f":"N155+O145-O154","v":16690.073870251224},{"$f":"O155+P145-P154","v":8627.2362517723723},{"$f":"P155+Q145-Q154","v":0},{"$f":"Q155+R145-R154","v":0},{"$f":"R155+S145-S154","v":0},{"$f":"S155+T145-T154","v":0},{"$f":"T155+U145-U154","v":0},{"$f":"U155+V145-V154","v":0},{"$f":"V155+W145-W154","v":0},{"$f":"W155+X145-X154","v":0},{"$f":"X155+Y145-Y154","v":0},{"$f":"Y155+Z145-Z154","v":0},{"$f":"Z155+AA145-AA154","v":0},{"$f":"AA155+AB145-AB154","v":0},{"$f":"AB155+AC145-AC154","v":0},{"$f":"AC155+AD145-AD154","v":0},{"$f":"AD155+AE145-AE154","v":0},{"$f":"AE155+AF145-AF154","v":0},{"$f":"AF155+AG145-AG154","v":0},{"$f":"AG155+AH145-AH154","v":0},{"$f":"AH155+AI145-AI154","v":0},{"$f":"AI155+AJ145-AJ154","v":0},{"$f":"AJ155+AK145-AK154","v":0},{"$f":"AK155+AL145-AL154","v":0},"CrdVarCom","=J155+K145-K154"]
[null,null,"Interest",0,{"$f":"D155*RateBqCom","v":348.24510000000004},870.61275000000012,1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,3482.4510000000005,3080.0425747422501,2649.4655597164569,2188.7481536388586,1695.7805291358281,1168.3051709175859,603.90653762406612,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntVarCom","=J155*RateBqCom"]
[null,null,"Installment",{"$f":"D154+D156","v":0},{"$f":"E154+E156","v":348.24510000000004},{"$f":"F154+F156","v":870.61275000000012},1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,9231.1427893964337,9231.1427893964355,9231.1427893964337,9231.1427893964355,9231.1427893964337,9231.1427893964374,9231.1427893964319,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"EchVarCom","=K154+K156"]
[null,null,{"$f":"IRR(FluxVarCom)","v":6.999999999999984E-2},{"$f":"D145-D157","v":4974.93},{"$f":"E145-E157","v":7114.1499000000013},{"$f":"F145-F157","v":9079.2472500000003},14352.673050000001,5775.8937300000007,-288.54593999999997,-3482.4510000000005,-9231.1427893964337,-9231.1427893964355,-9231.1427893964337,-9231.1427893964355,-9231.1427893964337,-9231.1427893964374,-9231.1427893964319,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"FluxVarCom","=K145-K157"]
["DSCR",null,"DSCRnum",{"$f":"DSCRNUM*RpBqCom","v":0},{"$f":"DSCRNUM*RpBqDev","v":0},0,0,0,14365.777995846021,17203.3932097828,17371.258384346969,17540.718418630357,7755.5737770470078,16029.948131748435,18058.810867932669,18234.794074804839,18412.444555219405,8137.5159489012585,16825.638738778311,18955.548314806209,19140.017121532743,19326.228374130471,8537.5108219539252,17659.616101687061,19895.471063285302,20088.806918598119,20283.963193472136,8956.3296360763979,18533.592445979924,20880.514445463792,21083.112878012442,21287.612539977272,9394.7673175869295,1148.7375812680752,0,0,0,0,"DscrCom","=DSCRNUM*RpBqDev"]
[null,null,"Repayment",{"$f":"PeriodDev*DscrDev/DSCRTarget","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-E162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-F162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-G162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-H162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-I162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-J162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-K162)","v":8098.3879228979786},{"$f":"PeriodCom*(DscrCom/DSCRTarget-L162)","v":8778.2484336897614},{"$f":"PeriodCom*(DscrCom/DSCRTarget-M162)","v":2869.2960629924801},{"$f":"PeriodCom*(DscrCom/DSCRTarget-N162)","v":8586.3963572029043},{"$f":"PeriodCom*(DscrCom/DSCRTarget-O162)","v":10540.019259663264},{"$f":"PeriodCom*(DscrCom/DSCRTarget-P162)","v":11395.142745754472},{"$f":"PeriodCom*(DscrCom/DSCRTarget-Q162)","v":12274.963036812936},{"$f":"PeriodCom*(DscrCom/DSCRTarget-R162)","v":10850.021265201678},{"$f":"PeriodCom*(DscrCom/DSCRTarget-S162)","v":22434.184985037748},{"$f":"PeriodCom*(DscrCom/DSCRTarget-T162)","v":25274.064419741611},{"$f":"PeriodCom*(DscrCom/DSCRTarget-U162)","v":25520.022828710324},{"$f":"PeriodCom*(DscrCom/DSCRTarget-V162)","v":25768.304498840629},{"$f":"PeriodCom*(DscrCom/DSCRTarget-W162)","v":11383.347762605234},{"$f":"PeriodCom*(DscrCom/DSCRTarget-X162)","v":23546.154802249413},{"$f":"PeriodCom*(DscrCom/DSCRTarget-Y162)","v":26527.294751047069},{"$f":"PeriodCom*(DscrCom/DSCRTarget-Z162)","v":26785.075891464159},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AA162)","v":27045.284257962849},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AB162)","v":11941.772848101864},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AC162)","v":24711.456594639898},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AD162)","v":27840.685927285056},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AE162)","v":28110.817170683255},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AF162)","v":28383.483386636362},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AG162)","v":12526.356423449239},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AH162)","v":1531.6501083574337},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AI162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AJ162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AK162)","v":0},{"$f":"PeriodCom*(DscrCom/DSCRTarget-AL162)","v":0},"AmoDSCom","=PeriodCom*(DscrCom/DSCRTarget-K162)"]
[null,null,"OutstandingC",{"$f":"D145","v":4974.93},{"$f":"MAX(D161+E145-E160,0)","v":12437.325000000001},{"$f":"MAX(E161+F145-F160,0)","v":22387.185000000001},{"$f":"MAX(F161+G145-G160,0)","v":38306.961000000003},{"$f":"MAX(G161+H145-H160,0)","v":46764.342000000004},{"$f":"MAX(H161+I145-I160,0)","v":49749.3},{"$f":"MAX(I161+J145-J160,0)","v":49749.3},{"$f":"MAX(J161+K145-K160,0)","v":41650.912077102024},{"$f":"MAX(K161+L145-L160,0)","v":32872.663643412263},{"$f":"MAX(L161+M145-M160,0)","v":30003.367580419785},{"$f":"MAX(M161+N145-N160,0)","v":21416.971223216882},{"$f":"MAX(N161+O145-O160,0)","v":10876.951963553618},{"$f":"MAX(O161+P145-P160,0)","v":0},{"$f":"MAX(P161+Q145-Q160,0)","v":0},{"$f":"MAX(Q161+R145-R160,0)","v":0},{"$f":"MAX(R161+S145-S160,0)","v":0},{"$f":"MAX(S161+T145-T160,0)","v":0},{"$f":"MAX(T161+U145-U160,0)","v":0},{"$f":"MAX(U161+V145-V160,0)","v":0},{"$f":"MAX(V161+W145-W160,0)","v":0},{"$f":"MAX(W161+X145-X160,0)","v":0},{"$f":"MAX(X161+Y145-Y160,0)","v":0},{"$f":"MAX(Y161+Z145-Z160,0)","v":0},{"$f":"MAX(Z161+AA145-AA160,0)","v":0},{"$f":"MAX(AA161+AB145-AB160,0)","v":0},{"$f":"MAX(AB161+AC145-AC160,0)","v":0},{"$f":"MAX(AC161+AD145-AD160,0)","v":0},{"$f":"MAX(AD161+AE145-AE160,0)","v":0},{"$f":"MAX(AE161+AF145-AF160,0)","v":0},{"$f":"MAX(AF161+AG145-AG160,0)","v":0},{"$f":"MAX(AG161+AH145-AH160,0)","v":0},{"$f":"MAX(AH161+AI145-AI160,0)","v":0},{"$f":"MAX(AI161+AJ145-AJ160,0)","v":0},{"$f":"MAX(AJ161+AK145-AK160,0)","v":0},{"$f":"MAX(AK161+AL145-AL160,0)","v":0},"CrdDSCom","=MAX(J161+K145-K160;0)"]
[null,null,"Interest",0,{"$f":"D161*RateBqCom","v":348.24510000000004},870.61275000000012,1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,3482.4510000000005,2915.5638453971419,2301.0864550388587,2100.2357306293852,1499.1879856251819,761.38663744875339,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"IntDSCom","=J161*RateBqCom"]
[null,null,"Installment",{"$f":"D160+D162","v":0},{"$f":"E160+E162","v":348.24510000000004},870.61275000000012,1567.1029500000002,2681.4872700000005,3273.5039400000005,3482.4510000000005,{"$f":"(J161-K161)+K162","v":11580.83892289798},{"$f":"(K161-L161)+L162","v":11693.812279086904},{"$f":"(L161-M161)+M162","v":5170.382518031337},{"$f":"(M161-N161)+N162","v":10686.632087832288},{"$f":"(N161-O161)+O162","v":12039.207245288446},{"$f":"(O161-P161)+P162","v":11638.338601002371},{"$f":"(P161-Q161)+Q162","v":0},{"$f":"(Q161-R161)+R162","v":0},{"$f":"(R161-S161)+S162","v":0},{"$f":"(S161-T161)+T162","v":0},{"$f":"(T161-U161)+U162","v":0},{"$f":"(U161-V161)+V162","v":0},{"$f":"(V161-W161)+W162","v":0},{"$f":"(W161-X161)+X162","v":0},{"$f":"(X161-Y161)+Y162","v":0},{"$f":"(Y161-Z161)+Z162","v":0},{"$f":"(Z161-AA161)+AA162","v":0},{"$f":"(AA161-AB161)+AB162","v":0},{"$f":"(AB161-AC161)+AC162","v":0},{"$f":"(AC161-AD161)+AD162","v":0},{"$f":"(AD161-AE161)+AE162","v":0},{"$f":"(AE161-AF161)+AF162","v":0},{"$f":"(AF161-AG161)+AG162","v":0},{"$f":"(AG161-AH161)+AH162","v":0},{"$f":"(AH161-AI161)+AI162","v":0},{"$f":"(AI161-AJ161)+AJ162","v":0},{"$f":"(AJ161-AK161)+AK162","v":0},{"$f":"(AK161-AL161)+AL162","v":0},"EchDSCom","=(J161-K161)+K162"]
[null,null,{"$f":"IRR(FluxDSCom)","v":6.999999999999984E-2},{"$f":"D145-D163","v":4974.93},{"$f":"E145-E163","v":7114.1499000000013},{"$f":"F145-F163","v":9079.2472500000003},{"$f":"G145-G163","v":14352.673050000001},{"$f":"H145-H163","v":5775.8937300000007},{"$f":"I145-I163","v":-288.54593999999997},{"$f":"J145-J163","v":-3482.4510000000005},{"$f":"K145-K163","v":-11580.83892289798},{"$f":"L145-L163","v":-11693.812279086904},{"$f":"M145-M163","v":-5170.382518031337},{"$f":"N145-N163","v":-10686.632087832288},{"$f":"O145-O163","v":-12039.207245288446},{"$f":"P145-P163","v":-11638.338601002371},{"$f":"Q145-Q163","v":0},{"$f":"R145-R163","v":0},{"$f":"S145-S163","v":0},{"$f":"T145-T163","v":0},{"$f":"U145-U163","v":0},{"$f":"V145-V163","v":0},{"$f":"W145-W163","v":0},{"$f":"X145-X163","v":0},{"$f":"Y145-Y163","v":0},{"$f":"Z145-Z163","v":0},{"$f":"AA145-AA163","v":0},{"$f":"AB145-AB163","v":0},{"$f":"AC145-AC163","v":0},{"$f":"AD145-AD163","v":0},{"$f":"AE145-AE163","v":0},{"$f":"AF145-AF163","v":0},{"$f":"AG145-AG163","v":0},{"$f":"AH145-AH163","v":0},{"$f":"AI145-AI163","v":0},{"$f":"AJ145-AJ163","v":0},{"$f":"AK145-AK163","v":0},{"$f":"AL145-AL163","v":0},"FluxDSCom","=K145-K163"]
["Interest",null,{"$f":"SUM(IntLT)","v":-103625.75547558919},{"$f":"-IF(AmoDev=1,IntLinDev,0)-IF(AmoDev=2,IntVarDev,0)-IF(AmoDev=3,IntDSDev,0)-IF(AmoExp=1,IntLinExp,0)-IF(AmoExp=2,IntVarExp,0)-IF(AmoExp=3,IntDSExp,0)-IF(AmoCom=1,IntLinCom,0)-IF(AmoCom=2,IntVarCom,0)-IF(AmoCom=3,IntDSCom,0)","v":0},-1044.7352999999998,{"$f":"-IF(AmoDev=1,IntLinDev,0)-IF(AmoDev=2,IntVarDev,0)-IF(AmoDev=3,IntDSDev,0)-IF(AmoExp=1,IntLinExp,0)-IF(AmoExp=2,IntVarExp,0)-IF(AmoExp=3,IntDSExp,0)-IF(AmoCom=1,IntLinCom,0)-IF(AmoCom=2,IntVarCom,0)-IF(AmoCom=3,IntDSCom,0)","v":-2611.8382500000002},-4701.3088500000003,-8044.4618100000007,{"$f":"-IF(AmoDev=1,IntLinDev,0)-IF(AmoDev=2,IntVarDev,0)-IF(AmoDev=3,IntDSDev,0)-IF(AmoExp=1,IntLinExp,0)-IF(AmoExp=2,IntVarExp,0)-IF(AmoExp=3,IntDSExp,0)-IF(AmoCom=1,IntLinCom,0)-IF(AmoCom=2,IntVarCom,0)-IF(AmoCom=3,IntDSCom,0)","v":-9820.5118199999997},-10447.353000000001,-10447.353000000001,-9613.7044101431802,-8735.962680642373,-7811.2005372212598,-6836.2953511341029,-5807.9160376366863,-4722.5090717472422,-3576.2835615714962,-3011.3753106667154,-2422.5224247076476,-1808.2882255910356,-1167.1498345274263,-497.49299999999937,-331.66199999999941,-165.83099999999942,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,"IntLT",{"$f":"FORM(K165)","v":{"$error":"#NAME?"}},{"$f":"SUM(IntLT)","v":-103625.75547558919}]
["Amortization",null,null,{"$f":"-IF(AmoDev=1,AmoLinDev,0)-IF(AmoDev=2,AmoVarDev,0)-IF(AmoDev=3,AmoDSDev,0)-IF(AmoExp=1,AmoLinExp,0)-IF(AmoExp=2,AmoVarExp,0)-IF(AmoExp=3,AmoDSExp,0)-IF(AmoCom=1,AmoLinCom,0)-IF(AmoCom=2,AmoVarCom,0)-IF(AmoCom=3,AmoDSCom,0)","v":0},0,0,0,0,0,0,-18463.727866047604,-19131.545455904423,-19843.45618540523,-20602.387328826349,-21411.461514913502,-22274.009828410923,-23193.585794300365,-14942.837515079678,-15341.914765984464,-15764.936651943532,-16213.339851060153,-16688.647242123778,-8291.5499999999993,-8291.5499999999993,-8291.5499999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,"AmoLT",{"$f":"FORM(K166)","v":{"$error":"#NAME?"}},{"$f":"SUM(AmoLT)","v":-248746.5}]
["Outstanding",null,null,{"$f":"IF(AmoDev=1,CrdLinDev)+IF(AmoDev=2,CrdVarDev,0)+IF(AmoDev=3,CrdDSDev,0)+IF(AmoExp=1,CrdLinExp,0)+IF(AmoExp=2,CrdVarExp,0)+IF(AmoExp=3,CrdDSExp,0)+IF(AmoCom=1,CrdLinCom,0)+IF(AmoCom=2,CrdVarCom,0)+IF(AmoCom=3,CrdDSCom,0)","v":24874.649999999998},62186.625,111935.92499999999,191534.80499999999,233821.71000000002,248746.5,248746.5,230282.77213395239,211151.226678048,191307.77049264277,170705.38316381641,149293.92164890288,127019.91182049197,103826.32602619159,88883.488511111907,73541.573745127447,57776.637093183905,41563.29724212375,24874.649999999969,16583.099999999969,8291.5499999999702,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,"OutLT",{"$f":"FORM(K167)","v":{"$error":"#NAME?"}},{"$f":"SUM(CrdLT)","v":381861.19602622947}]
[null,null,{"$f":"NPV(C169,CFDBT)","v":-1.8992377210310394E-10},{"$f":"D167","v":24874.649999999998},{"$f":"E167-D167","v":37311.975000000006},{"$f":"F167-E167","v":49749.299999999988},79598.880000000005,42286.905000000028,14924.789999999979,0,-18463.727866047615,-19131.545455904386,-19843.45618540523,-20602.387328826357,-21411.461514913535,-22274.009828410912,-23193.585794300379,-14942.837515079678,-15341.91476598446,-15764.936651943543,-16213.339851060155,-16688.647242123781,-8291.5499999999993,-8291.5499999999993,-8291.5499999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,"CFDT"]
["cost of loans",null,{"$f":"IRR(CFDBT)","v":4.0142021911247605E-2},{"$f":"CFDT+IntLT","v":24874.649999999998},{"$f":"CFDT+IntLT","v":36267.239700000006},{"$f":"CFDT+IntLT","v":47137.461749999988},{"$f":"CFDT+IntLT","v":74897.571150000003},{"$f":"CFDT+IntLT","v":34242.443190000027},{"$f":"CFDT+IntLT","v":5104.2781799999793},{"$f":"CFDT+IntLT","v":-10447.353000000001},{"$f":"CFDT+IntLT","v":-28911.080866047618},{"$f":"CFDT+IntLT","v":-28745.249866047569},{"$f":"CFDT+IntLT","v":-28579.418866047603},{"$f":"CFDT+IntLT","v":-28413.587866047616},{"$f":"CFDT+IntLT","v":-28247.756866047639},{"$f":"CFDT+IntLT","v":-28081.925866047597},{"$f":"CFDT+IntLT","v":-27916.094866047621},{"$f":"CFDT+IntLT","v":-18519.121076651176},{"$f":"CFDT+IntLT","v":-18353.290076651174},{"$f":"CFDT+IntLT","v":-18187.45907665119},{"$f":"CFDT+IntLT","v":-18021.628076651192},{"$f":"CFDT+IntLT","v":-17855.797076651208},{"$f":"CFDT+IntLT","v":-8789.0429999999978},{"$f":"CFDT+IntLT","v":-8623.2119999999995},{"$f":"CFDT+IntLT","v":-8457.3809999999994},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},{"$f":"CFDT+IntLT","v":5.8207660913467408E-13},"CFDBT"]
[{"$f":"NPV(C169,IntLT)*(1+C169)","v":-75001.041529341514},null,{"$f":"SUM(CFDBT)","v":-103625.75547558922}]
["WORKING CAPITAL",null,"on CA",{"$f":"DelaysCashIn*Revenues/360","v":0},0,0,0,0,8583.2487424833325,8669.0812299081663,8755.7720422072471,8843.3297626293206,4465.8815301278064,9021.0806908581708,9111.2914977667515,9202.4044127444213,9294.4284568718613,4693.6863707202911,9481.2464688549881,9576.0589335435361,9671.8195228789755,9768.5377181077638,4933.1115476444211,9964.8853262417324,10064.53417950415,10165.179521299189,10266.831316512184,5184.749814838653,10473.19462597408,10577.926572233817,10683.705837956157,10790.542896335721,5449.2241626495379,0,0,0,0,0,"WcPay",{"$f":"_xlfn.FORMULATEXT(K171)","v":"=DelaysCashIn*Revenues/360"}]
[null,null,"on CAPEX",{"$f":"-DelaysCashOut*Cost/360","v":0},0,0,0,0,3188.5004059033722,3221.7521036870712,3255.3637889924717,3289.3396138527255,2566.8664546061514,3358.4005542131754,3393.4942398822323,3428.9692069785319,3464.8298782422135,2701.7302779042971,3537.7263074781272,3574.7711966234037,3612.2200539441505,3650.0775928597304,2843.8844502249358,3727.037873413401,3766.150348801918,3805.6909750870718,3845.6647780033004,2993.7438459108171,3926.9323437009402,3968.2364878595263,4009.9945733562013,4052.2119616922669,3151.7490001133874,0,0,0,0,0,"WcRec","=-DelaysCashOut*Cost/360"]
[null,null,null,{"$f":"WcPay-WcRec","v":0},0,0,0,0,5394.7483365799599,5447.3291262210951,5500.408253214775,5553.9901487765947,1899.015075521655,5662.6801366449954,5717.7972578845192,5773.4352057658889,5829.5985786296478,1991.956092815994,5943.5201613768604,6001.2877369201324,6059.5994689348245,6118.4601252480334,2089.2270974194853,6237.8474528283314,6298.3838307022315,6359.4885462121174,6421.1665385088836,2191.005968927836,6546.2622822731391,6609.6900843742906,6673.711264599955,6738.3309346434544,2297.4751625361505,0,0,0,0,0,"WcNeed","=WcPay-WcRec"]
[null,null,null,{"$f":"-D173","v":0},{"$f":"-E173+D173","v":0},{"$f":"-F173+E173","v":0},0,0,-5394.7483365799599,-52.580789641135198,-53.079126993679893,-53.581895561819692,3654.9750732549396,-3763.6650611233404,-55.11712123952384,-55.637947881369655,-56.163372863758923,3837.6424858136538,-3951.5640685608664,-57.76757554327196,-58.311732014692097,-58.860656313208892,4029.2330278285481,-4148.6203554088461,-60.536377873900165,-61.104715509885864,-61.677992296766206,4230.1605695810476,-4355.2563133453032,-63.427802101151428,-64.021180225664466,-64.619670043499355,4440.8557721073039,2297.4751625361505,0,0,0,0,"WcVar"]
[]
["RESERVE DSRA",null," ",{"$f":"-IntLT-AmoLT","v":0},1044.7352999999998,2611.8382500000002,4701.3088500000003,8044.4618100000007,9820.5118199999997,10447.353000000001,28911.080866047603,28745.249866047605,28579.418866047603,28413.587866047608,28247.756866047606,28081.925866047608,27916.094866047606,18519.121076651176,18353.290076651181,18187.459076651179,18021.628076651188,17855.797076651204,8789.0429999999978,8623.2119999999995,8457.3809999999994,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,-5.8207660913467408E-13,"CFLT",{"$f":"_xlfn.FORMULATEXT(K176)","v":"=-IntLT-AmoLT"}]
[null,null,null,{"$f":"SUM(OFFSET(CFLT,0,D4,1,YearReserve))","v":8357.8824000000004},{"$f":"SUM(OFFSET(CFLT,0,E4,1,YearReserve))","v":15357.608910000001},{"$f":"SUM(OFFSET(CFLT,0,F4,1,YearReserve))","v":22566.282480000002},{"$f":"SUM(OFFSET(CFLT,0,G4,1,YearReserve))","v":28312.326630000003},{"$f":"SUM(OFFSET(CFLT,0,H4,1,YearReserve))","v":49178.945686047606},{"$f":"SUM(OFFSET(CFLT,0,I4,1,YearReserve))","v":68103.683732095204},{"$f":"SUM(OFFSET(CFLT,0,J4,1,YearReserve))","v":86235.749598142807},{"$f":"SUM(OFFSET(CFLT,0,K4,1,YearReserve))","v":85738.25659814282},{"$f":"SUM(OFFSET(CFLT,0,L4,1,YearReserve))","v":85240.763598142818},{"$f":"SUM(OFFSET(CFLT,0,M4,1,YearReserve))","v":84743.270598142815},{"$f":"SUM(OFFSET(CFLT,0,N4,1,YearReserve))","v":84245.777598142828},{"$f":"SUM(OFFSET(CFLT,0,O4,1,YearReserve))","v":74517.141808746397},{"$f":"SUM(OFFSET(CFLT,0,P4,1,YearReserve))","v":64788.506019349959},{"$f":"SUM(OFFSET(CFLT,0,Q4,1,YearReserve))","v":55059.870229953536},{"$f":"SUM(OFFSET(CFLT,0,R4,1,YearReserve))","v":54562.377229953549},{"$f":"SUM(OFFSET(CFLT,0,S4,1,YearReserve))","v":54064.884229953575},{"$f":"SUM(OFFSET(CFLT,0,T4,1,YearReserve))","v":44666.46815330239},{"$f":"SUM(OFFSET(CFLT,0,U4,1,YearReserve))","v":35268.052076651205},{"$f":"SUM(OFFSET(CFLT,0,V4,1,YearReserve))","v":25869.635999999999},{"$f":"SUM(OFFSET(CFLT,0,W4,1,YearReserve))","v":17080.593000000001},{"$f":"SUM(OFFSET(CFLT,0,X4,1,YearReserve))","v":8457.3809999999994},{"$f":"SUM(OFFSET(CFLT,0,Y4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,Z4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AA4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AB4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AC4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AD4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AE4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AF4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AG4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AH4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AI4,1,YearReserve))","v":-1.7462298274040222E-12},{"$f":"SUM(OFFSET(CFLT,0,AJ4,1,YearReserve))","v":-1.1641532182693482E-12},{"$f":"SUM(OFFSET(CFLT,0,AK4,1,YearReserve))","v":-5.8207660913467408E-13},{"$f":"SUM(OFFSET(CFLT,0,AL4,1,YearReserve))","v":0},"BKRes","{=SOMME(DECALER(CFLT;0;K4;1;YearReserve))}"]
["DSRA",null,null,{"$f":"YearProd*BKRes*RateReserve","v":0},0,0,0,0,61293.315358885688,77612.174638328535,77164.430938328544,76716.687238328537,76268.943538328531,75821.199838328554,67065.427627871759,58309.655417414964,49553.883206958184,49106.139506958192,48658.395806958222,40199.821337972149,31741.246868986087,23282.672399999999,15372.533700000002,7611.6428999999998,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,-1.57160684466362E-12,0,0,0,0,0,"BKRes2","=YearProd*BKRes*RateReserve"]
[null,null,null,{"$f":"MAX(MIN(D167,D178,C218),0)","v":0},{"$f":"MAX(MIN(E167,E178,D218),0)","v":0},{"$f":"MAX(MIN(F167,F178,E218),0)","v":0},{"$f":"MAX(MIN(G167,G178,F218),0)","v":0},{"$f":"MAX(MIN(H167,H178,G218),0)","v":0},{"$f":"MAX(MIN(I167,I178,H218),0)","v":0},{"$f":"MAX(MIN(J167,J178,I218),0)","v":1672.2495384805261},{"$f":"MAX(MIN(K167,K178,J218),0)","v":21694.670873778898},{"$f":"MAX(MIN(L167,L178,K218),0)","v":4200.6168906551611},{"$f":"MAX(MIN(M167,M178,L218),0)","v":10472.736529271373},{"$f":"MAX(MIN(N167,N178,M218),0)","v":0},{"$f":"MAX(MIN(O167,O178,N218),0)","v":0},{"$f":"MAX(MIN(P167,P178,O218),0)","v":0},{"$f":"MAX(MIN(Q167,Q178,P218),0)","v":0},{"$f":"MAX(MIN(R167,R178,Q218),0)","v":0},{"$f":"MAX(MIN(S167,S178,R218),0)","v":0},{"$f":"MAX(MIN(T167,T178,S218),0)","v":0},{"$f":"MAX(MIN(U167,U178,T218),0)","v":0},{"$f":"MAX(MIN(V167,V178,U218),0)","v":0},{"$f":"MAX(MIN(W167,W178,V218),0)","v":0},{"$f":"MAX(MIN(X167,X178,W218),0)","v":0},{"$f":"MAX(MIN(Y167,Y178,X218),0)","v":0},{"$f":"MAX(MIN(Z167,Z178,Y218),0)","v":0},{"$f":"MAX(MIN(AA167,AA178,Z218),0)","v":0},{"$f":"MAX(MIN(AB167,AB178,AA218),0)","v":0},{"$f":"MAX(MIN(AC167,AC178,AB218),0)","v":0},{"$f":"MAX(MIN(AD167,AD178,AC218),0)","v":0},{"$f":"MAX(MIN(AE167,AE178,AD218),0)","v":0},{"$f":"MAX(MIN(AF167,AF178,AE218),0)","v":0},{"$f":"MAX(MIN(AG167,AG178,AF218),0)","v":0},{"$f":"MAX(MIN(AH167,AH178,AG218),0)","v":0},{"$f":"MAX(MIN(AI167,AI178,AH218),0)","v":0},{"$f":"MAX(MIN(AJ167,AJ178,AI218),0)","v":0},{"$f":"MAX(MIN(AK167,AK178,AJ218),0)","v":0},{"$f":"MAX(MIN(AL167,AL178,AK218),0)","v":0},"DSRA","=MAX(MIN(K167;K178;J218);0)"]
[null,null,null,{"$f":"-D179+C179","v":0},0,0,0,0,{"$f":"-I179+H179","v":0},{"$f":"-J179+I179","v":-1672.2495384805261},-20022.421335298372,17494.053983123737,-6272.1196386162119,10472.736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"CFDSRA"]
[]
["TAX",null,"PLBEFTAX",{"$f":"INDIRECT($C182)","v":0},-1091.010842105263,-2791.046096952909,-5126.2365231083259,-8909.2236664298161,11082.515003656808,10988.960917944523,11150.249064594171,12386.041687972063,-10586.508853555846,14592.270938757523,15505.024725521671,16431.408890590665,17372.154783933427,-6124.7816091240384,19609.143914638305,20434.884248261231,21267.017638148587,22105.752063784319,-2569.7218303070213,24186.650686141547,24980.50331290939,26192.519125395516,27242.321052315598,587.74364288247136,28416.533582482418,28950.314792184989,29487.864823604552,30029.216440651613,1914.8591114411931,829.15500000000134,829.1550000000035,829.15500000000748,829.15500000001236,829.15500000001691]
[null,null,null,{"$f":"C183+D182+C184/TaxCorp","v":0},-1091.010842105263,-3882.0569390581722,-9008.2934621664972,-17917.517128596315,{"$f":"H183+I182+H184/TaxCorp","v":-6835.0021249395068},4153.9587930050166,11150.249064594171,12386.041687972063,-10586.508853555846,4005.7620852016771,15505.024725521671,16431.408890590665,17372.154783933427,-6124.7816091240384,13484.362305514267,20434.884248261231,21267.017638148587,22105.752063784319,-2569.7218303070222,21616.928855834525,24980.50331290939,26192.519125395516,27242.321052315598,587.74364288247307,28416.533582482421,28950.314792184989,29487.864823604556,30029.216440651606,1914.8591114411684,829.15499999996882,829.15499999999543,829.15500000007137,829.15500000018483,829.15500000029147,"PLBEFTAXCUM"]
[null,null,null,{"$f":"-(PLBEFTAXCUM>0)*TaxCorp*PLBEFTAXCUM","v":0},0,0,0,0,0,-1246.187637901505,-3345.0747193782513,-3715.8125063916186,0,-1201.7286255605031,-4651.5074176565013,-4929.4226671771994,-5211.6464351800278,0,-4045.3086916542798,-6130.4652744783689,-6380.1052914445763,-6631.7256191352953,0,-6485.0786567503574,-7494.1509938728168,-7857.7557376186542,-8172.6963156946786,-176.32309286474191,-8524.9600747447257,-8685.0944376554962,-8846.3594470813659,-9008.7649321954814,-574.45773343235044,-248.74649999999065,-248.7464999999986,-248.7465000000214,-248.74650000005545,-248.74650000008742,"TAXCO"]
[]
["DIVIDEND",null,"RATEDIVIDEND",{"$f":"INDIRECT($C186)","v":1},{"$f":"INDIRECT($C186)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"PLAFTERTAX",{"$f":"INDIRECT($C187)","v":0},-1091.010842105263,-2791.046096952909,-5126.2365231083259,-8909.2236664298161,11082.515003656808,9742.7732800430185,7805.1743452159189,8670.2291815804456,-10586.508853555846,13390.54231319702,10853.51730786517,11501.986223413465,12160.508348753399,-6124.7816091240384,15563.835222984026,14304.418973782862,14886.912346704012,15474.026444649024,-2569.7218303070213,17701.572029391191,17486.352319036574,18334.76338777686,19069.624736620921,411.42055001773053,19891.573507737692,20265.220354529491,20641.505376523186,21020.451508456124,1340.4013780088328,580.4085000000083,580.40850000002411,580.40850000003786,580.40850000003923,580.40850000002774]
[null,null,null,{"$f":"C188+D187+C192","v":0},{"$f":"D188+E187+D192","v":-1091.010842105263},-3882.0569390581722,-9008.2934621664972,-17917.517128596315,{"$f":"H188+I187+H192","v":-6835.0021249395068},2907.7711551035118,9477.423883696445,18147.653065276892,-6385.891962900685,7004.6503502963351,10853.517307865168,11501.986223413467,12160.508348753399,-6124.7816091240384,9439.0536138599873,14304.418973782862,14886.912346704014,15474.026444649024,-2569.7218303070204,15131.850199084171,17486.352319036574,18334.76338777686,19069.624736620921,411.42055001773042,19891.573507737692,20265.220354529483,20641.505376523168,21020.451508456095,1340.4013780087953,580.40849999998272,580.40850000001387,580.4084999999734,580.40849999970169,580.40849999901957]
[null,null,null,{"$f":"MAX(D188-D179,0)","v":0},{"$f":"MAX(E188-E179,0)","v":0},0,0,0,0,1235.5216166229857,0,13947.036174621731,0,7004.6503502963351,10853.517307865168,11501.986223413467,12160.508348753399,0,9439.0536138599873,14304.418973782862,14886.912346704014,15474.026444649024,0,15131.850199084171,17486.352319036574,18334.76338777686,19069.624736620921,411.42055001773042,19891.573507737692,20265.220354529483,20641.505376523168,21020.451508456095,1340.4013780087953,580.40849999998272,580.40850000001387,580.4084999999734,580.40849999970169,580.40849999901957]
[null,null,"CFBEFDIV",{"$f":"INDIRECT($C190)","v":66.19999999999709},{"$f":"INDIRECT($C190)","v":-991.7108421052601},-2658.6460969529148,-4914.3965231083293,-8796.6836664298153,18967.48666707685,22930.192490401885,2528.3673521746337,2725.1018301142058,-13534.989965706136,2264.4899232473281,2626.9386717121497,2412.338447121173,2150.7591815892729,-3989.9766383900628,9510.3563884386931,11721.714746296058,11855.260763629165,11966.518546212041,6407.9611975215257,18501.401673982349,22374.265941162677,31513.658672266982,32247.946744324145,17881.581119598777,28776.317194392388,33441.792552428342,33817.484196297512,34195.831838412618,19021.257150116136,2877.8836625361587,580.40850000002411,580.40850000003786,580.40850000003923,580.40850000002774]
[null,null,null,{"$f":"D190","v":66.19999999999709},{"$f":"D191+E190-D192","v":-925.51084210526301},{"$f":"E191+F190-E192","v":-3584.1569390581781},-8498.5534621665065,-17295.237128596324,1672.2495384805261,24602.442028882411,28366.33099768003,31091.432827794237,31503.479036709832,33767.968959957157,43399.557981965641,56665.413736951989,70318.159141954733,78488.690852318075,87999.047240756772,109159.81560091281,135319.49533832484,162172.92623124088,184054.91387341145,202556.31554739381,240062.43168764067,289062.44267894421,339645.15281104523,376596.35866726493,405784.09641167504,459117.46247184108,513200.16702266812,568037.50423760398,608079.21289617626,612297.49793672119,613458.31493672123,614619.13193672139,615779.94893672178,616940.76593672251]
[null,null,null,{"$f":"-MAX(0,MIN(D189*D186,D191))","v":0},{"$f":"-MAX(0,MIN(E189*E186,E191))","v":0},0,0,0,0,-1235.5216166229857,0,-13947.036174621731,0,-7004.6503502963351,-10853.517307865168,-11501.986223413467,-12160.508348753399,0,-9439.0536138599873,-14304.418973782862,-14886.912346704014,-15474.026444649024,0,-15131.850199084171,-17486.352319036574,-18334.76338777686,-19069.624736620921,-411.42055001773042,-19891.573507737692,-20265.220354529483,-20641.505376523168,-21020.451508456095,-1340.4013780087953,-580.40849999998272,-580.40850000001387,-580.4084999999734,-580.40849999970169,-580.40849999901957,"DIVIDEND"]
[]
["CASH ACCOUNTS",null,null,0,{"$f":"(POSBAL+DSRA)*RateDeposit","v":0},{"$f":"POSBAL*RateDeposit","v":0},0,0,{"$f":"POSBAL*RateDeposit","v":16.72249538480526},216.94670873778898,42.006168906551615,104.72736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,145.24494031072157,234.0923771772685,365.85809915625697,497.61788735400012,629.371690653565,806.18024837463815,829.15499999999986,829.15499999999929,829.15499999999656,829.15499999998985,829.15499999997837,"POSINT"]
[null,null,null,0,{"$f":"NEGBAL*RateFunding","v":46.275542105263156},{"$f":"NEGBAL*RateFunding","v":179.20784695290891},424.92767310832534,864.76185642981625,0,0,0,0,466.71865375254879,180.08984864143042,591.4187804490814,1045.9011692636961,1546.3886276219025,1745.8874595414054,1742.3223208124703,1871.4575321868106,2023.040111340553,2198.4155062624022,1878.0174463863259,1709.5398726414169,1465.1441915351118,806.19942731060564,147.28332692544447,0,0,0,0,0,0,0,0,0,0,0,"NEGINT"]
[null,null,null,{"$f":"POSINT-NEGINT","v":0},{"$f":"POSINT-NEGINT","v":-46.275542105263156},-179.20784695290891,-424.92767310832534,-864.76185642981625,16.72249538480526,216.94670873778898,42.006168906551615,104.72736529271373,-466.71865375254879,-180.08984864143042,-591.4187804490814,-1045.9011692636961,-1546.3886276219025,-1745.8874595414054,-1742.3223208124703,-1871.4575321868106,-2023.040111340553,-2198.4155062624022,-1878.0174463863259,-1709.5398726414169,-1465.1441915351118,-806.19942731060564,-147.28332692544447,145.24494031072157,234.0923771772685,365.85809915625697,497.61788735400012,629.371690653565,806.18024837463815,829.15499999999986,829.15499999999929,829.15499999999656,829.15499999998985,829.15499999997837,"INTST"]
[]
["CASH FLOW STATEMENT"]
[]
[null,"REVENUES",null,{"$f":"INDIRECT($B200)","v":0},{"$f":"INDIRECT($B200)","v":0},{"$f":"INDIRECT($B200)","v":0},0,0,51499.492454899992,52014.48737944899,52534.632253243479,53059.978575775924,26795.289180766838,54126.484145149021,54667.748986600513,55214.42647646652,55766.570741231175,28162.118224321748,56887.478813129928,57456.353601261224,58030.917137273849,58611.226308646583,29598.669285866526,59789.311957450394,60387.205077024897,60991.077127795143,61600.987899073094,31108.498889031918,62839.167755844472,63467.559433402908,64102.235027736941,64743.257378014321,32695.344975897227,0,0,0,0,0]
[null,"COST",null,{"$f":"INDIRECT($B201)","v":0},0,{"$f":"INDIRECT($B201)","v":0},0,0,-12754.001623613489,-12887.008414748285,-13021.455155969887,-13157.358455410902,-10267.465818424605,-13433.602216852702,-13573.976959528929,-13715.876827914128,-13859.319512968854,-10806.921111617188,-14150.905229912509,-14299.084786493615,-14448.880215776602,-14600.310371438922,-11375.537800899743,-14908.151493653604,-15064.601395207672,-15222.763900348289,-15382.659112013202,-11974.975383643268,-15707.729374803761,-15872.945951438105,-16039.978293424807,-16208.847846769069,-12606.996000453551,0,0,0,0,0]
[null,"TAX",null,{"$f":"INDIRECT($B202)","v":0},0,{"$f":"INDIRECT($B202)","v":0},0,0,-4619.1865030144945,-4668.1117554939701,-4717.5812015859701,-4767.6013875424869,-4671.6508815031602,-4869.3206036761112,-4921.0331699667231,-4973.323551061344,-5026.19874495975,-4917.807700715699,-5133.7320370999314,-5188.4046096119209,-5243.6909464170658,-5299.598532633514,-5177.3428688874792,-5413.3079050138276,-5471.1251773727308,-5529.5946747407288,-5588.7244078188505,-5451.0248028169008,-5708.997175735557,-5770.1567889360658,-5832.0097980615856,-5894.5647812472098,-5739.6701123771199,0,0,0,0,0]
[null,"WCVAR",null,{"$f":"INDIRECT($B203)","v":0},0,{"$f":"INDIRECT($B203)","v":0},0,0,-5394.7483365799599,-52.580789641135198,-53.079126993679893,-53.581895561819692,3654.9750732549396,-3763.6650611233404,-55.11712123952384,-55.637947881369655,-56.163372863758923,3837.6424858136538,-3951.5640685608664,-57.76757554327196,-58.311732014692097,-58.860656313208892,4029.2330278285481,-4148.6203554088461,-60.536377873900165,-61.104715509885864,-61.677992296766206,4230.1605695810476,-4355.2563133453032,-63.427802101151428,-64.021180225664466,-64.619670043499355,4440.8557721073039,2297.4751625361505,0,0,0,0]
[null,"CAPEX",null,{"$f":"INDIRECT($B204)","v":-33100},{"$f":"INDIRECT($B204)","v":-49650},{"$f":"INDIRECT($B204)","v":-66200},-105920,-56270.000000000007,-19860,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D200:D204)","v":-33100},-49650,-66200,-105920,-56270.000000000007,8871.5559916920429,34406.7864195656,34742.516768693939,35081.436837260713,15511.147554094016,32059.89626349687,36117.621735865338,36469.588149609677,36824.889110438809,16275.031897802517,33651.277477556621,37911.096629612417,38280.034243065485,38652.456748260942,17075.02164390785,35319.232203374122,39790.942126570604,40177.613837196237,40567.926386944273,17912.659272152796,37067.184891959849,41761.028890927584,42166.225756024884,42575.225079954544,18789.534635173859,2297.4751625361505,0,0,0,0,"CFOP"]
[null,"EQ",null,{"$f":"INDIRECT($B206)","v":8291.5499999999993},{"$f":"INDIRECT($B206)","v":12437.325000000001},{"$f":"INDIRECT($B206)","v":16583.099999999999},26532.959999999999,14095.635000000002,4974.93,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DT",null,{"$f":"INDIRECT($B207)","v":24874.649999999998},37311.975000000006,{"$f":"INDIRECT($B207)","v":49749.299999999996},79598.880000000005,42286.905000000006,14924.79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"AMOLT",null,{"$f":"INDIRECT($B208)","v":0},0,{"$f":"INDIRECT($B208)","v":0},0,0,0,0,-18463.727866047604,-19131.545455904423,-19843.45618540523,-20602.387328826349,-21411.461514913502,-22274.009828410923,-23193.585794300365,-14942.837515079678,-15341.914765984464,-15764.936651943532,-16213.339851060153,-16688.647242123778,-8291.5499999999993,-8291.5499999999993,-8291.5499999999993,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INTST",null,{"$f":"INDIRECT($B209)","v":0},{"$f":"INDIRECT($B209)","v":-46.275542105263156},{"$f":"INDIRECT($B209)","v":-179.20784695290891},-424.92767310832534,-864.76185642981625,16.72249538480526,216.94670873778898,42.006168906551615,104.72736529271373,-466.71865375254879,-180.08984864143042,-591.4187804490814,-1045.9011692636961,-1546.3886276219025,-1745.8874595414054,-1742.3223208124703,-1871.4575321868106,-2023.040111340553,-2198.4155062624022,-1878.0174463863259,-1709.5398726414169,-1465.1441915351118,-806.19942731060564,-147.28332692544447,145.24494031072157,234.0923771772685,365.85809915625697,497.61788735400012,629.371690653565,806.18024837463815,829.15499999999986,829.15499999999929,829.15499999999656,829.15499999998985,829.15499999997837]
[null,"INTLT",null,{"$f":"INDIRECT($B210)","v":0},-1044.7352999999998,{"$f":"INDIRECT($B210)","v":-2611.8382500000002},-4701.3088500000003,-8044.4618100000007,-9820.5118199999997,-10447.353000000001,-10447.353000000001,-9613.7044101431802,-8735.962680642373,-7811.2005372212598,-6836.2953511341029,-5807.9160376366863,-4722.5090717472422,-3576.2835615714962,-3011.3753106667154,-2422.5224247076476,-1808.2882255910356,-1167.1498345274263,-497.49299999999937,-331.66199999999941,-165.83099999999942,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13]
[null,null,null,{"$f":"SUM(D205:D210)","v":66.19999999999709},{"$f":"SUM(E205:E210)","v":-991.7108421052601},-2658.6460969529148,-4914.3965231083293,-8796.6836664298153,18967.48666707685,24176.38012830339,5873.442071552885,6440.9143365058244,-13534.989965706136,3466.2185488078312,7278.446089368651,7341.7611142983724,7362.4056167693007,-3989.9766383900628,13555.665080092973,17852.180020774427,18235.36605507374,18598.244165347336,6407.9611975215257,24986.480330732706,29868.416935035493,39371.414409885634,40420.643060018825,18057.904212463516,37301.277269137114,42126.88699008384,42663.843643378881,43204.596770608106,19595.714883548499,3126.6301625361507,829.15499999999986,829.15499999999713,829.15499999999042,829.15499999997894,"CFBEFTAX"]
[null,"TAXCO",null,{"$f":"INDIRECT($B212)","v":0},{"$f":"INDIRECT($B212)","v":0},0,0,0,0,-1246.187637901505,-3345.0747193782513,-3715.8125063916186,0,-1201.7286255605031,-4651.5074176565013,-4929.4226671771994,-5211.6464351800278,0,-4045.3086916542798,-6130.4652744783689,-6380.1052914445763,-6631.7256191352953,0,-6485.0786567503574,-7494.1509938728168,-7857.7557376186542,-8172.6963156946786,-176.32309286474191,-8524.9600747447257,-8685.0944376554962,-8846.3594470813659,-9008.7649321954814,-574.45773343235044,-248.74649999999065,-248.7464999999986,-248.7465000000214,-248.74650000005545,-248.74650000008742]
[null,null,null,{"$f":"SUM(D211:D212)","v":66.19999999999709},{"$f":"SUM(E211:E212)","v":-991.7108421052601},{"$f":"SUM(F211:F212)","v":-2658.6460969529148},{"$f":"SUM(G211:G212)","v":-4914.3965231083293},{"$f":"SUM(H211:H212)","v":-8796.6836664298153},{"$f":"SUM(I211:I212)","v":18967.48666707685},{"$f":"SUM(J211:J212)","v":22930.192490401885},{"$f":"SUM(K211:K212)","v":2528.3673521746337},{"$f":"SUM(L211:L212)","v":2725.1018301142058},{"$f":"SUM(M211:M212)","v":-13534.989965706136},{"$f":"SUM(N211:N212)","v":2264.4899232473281},{"$f":"SUM(O211:O212)","v":2626.9386717121497},{"$f":"SUM(P211:P212)","v":2412.338447121173},{"$f":"SUM(Q211:Q212)","v":2150.7591815892729},{"$f":"SUM(R211:R212)","v":-3989.9766383900628},{"$f":"SUM(S211:S212)","v":9510.3563884386931},{"$f":"SUM(T211:T212)","v":11721.714746296058},{"$f":"SUM(U211:U212)","v":11855.260763629165},{"$f":"SUM(V211:V212)","v":11966.518546212041},{"$f":"SUM(W211:W212)","v":6407.9611975215257},{"$f":"SUM(X211:X212)","v":18501.401673982349},{"$f":"SUM(Y211:Y212)","v":22374.265941162677},{"$f":"SUM(Z211:Z212)","v":31513.658672266982},{"$f":"SUM(AA211:AA212)","v":32247.946744324145},{"$f":"SUM(AB211:AB212)","v":17881.581119598774},{"$f":"SUM(AC211:AC212)","v":28776.317194392388},{"$f":"SUM(AD211:AD212)","v":33441.792552428342},{"$f":"SUM(AE211:AE212)","v":33817.484196297519},{"$f":"SUM(AF211:AF212)","v":34195.831838412625},{"$f":"SUM(AG211:AG212)","v":19021.257150116147},{"$f":"SUM(AH211:AH212)","v":2877.88366253616},{"$f":"SUM(AI211:AI212)","v":580.40850000000125},{"$f":"SUM(AJ211:AJ212)","v":580.40849999997567},{"$f":"SUM(AK211:AK212)","v":580.40849999993497},{"$f":"SUM(AL211:AL212)","v":580.40849999989155},"CFBEFDIV"]
[null,"CFDSRA",null,{"$f":"INDIRECT($B214)","v":0},{"$f":"INDIRECT($B214)","v":0},{"$f":"INDIRECT($B214)","v":0},0,0,0,-1672.2495384805261,-20022.421335298372,17494.053983123737,-6272.1196386162119,10472.736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DIVIDEND",null,{"$f":"INDIRECT($B215)","v":0},0,{"$f":"INDIRECT($B215)","v":0},0,0,0,-1235.5216166229857,0,-13947.036174621731,0,-7004.6503502963351,-10853.517307865168,-11501.986223413467,-12160.508348753399,0,-9439.0536138599873,-14304.418973782862,-14886.912346704014,-15474.026444649024,0,-15131.850199084171,-17486.352319036574,-18334.76338777686,-19069.624736620921,-411.42055001773042,-19891.573507737692,-20265.220354529483,-20641.505376523168,-21020.451508456095,-1340.4013780087953,-580.40849999998272,-580.40850000001387,-580.4084999999734,-580.40849999970169,-580.40849999901957]
[null,null,null,{"$f":"SUM(D213:D215)","v":66.19999999999709},{"$f":"SUM(E213:E215)","v":-991.7108421052601},-2658.6460969529148,{"$f":"SUM(G213:G215)","v":-4914.3965231083293},{"$f":"SUM(H213:H215)","v":-8796.6836664298153},{"$f":"SUM(I213:I215)","v":18967.48666707685},20022.421335298372,-17494.053983123737,6272.1196386162119,-19807.109604322348,5732.5761022223669,-8226.578636153019,-9089.647776292295,-10009.749167164126,-3989.9766383900628,71.302774578705794,-2582.7042274868036,-3031.6515830748485,-3507.5078984369829,6407.9611975215257,3369.5514748981786,4887.9136221261033,13178.895284490121,{"$f":"SUM(AA213:AA215)","v":13178.322007703224},17470.160569581043,8884.7436866546959,13176.572197898859,13175.978819774351,13175.38032995653,17680.855772107352,2297.4751625361773,-1.2619238987099379E-11,2.2737367544323206E-12,2.3328539100475609E-10,8.7197804532479495E-10]
[null,null,null,null,{"$f":"E205+E206+E207+E210","v":-945.43529999999691},{"$f":"-(E217+D218)*0.05/0.95","v":46.275542105263149},{"$f":"(E217+D218)/0.95","v":-925.51084210526301}]
[null,null,null,{"$f":"D216","v":66.19999999999709},{"$f":"D218+E216","v":-925.51084210526301},{"$f":"E218+F216","v":-3584.1569390581781},{"$f":"F218+G216","v":-8498.5534621665065},{"$f":"G218+H216","v":-17295.237128596324},{"$f":"H218+I216","v":1672.2495384805261},{"$f":"I218+J216","v":21694.670873778898},{"$f":"J218+K216","v":4200.6168906551611},{"$f":"K218+L216","v":10472.736529271373},{"$f":"L218+M216","v":-9334.3730750509749},{"$f":"M218+N216","v":-3601.796972828608},{"$f":"N218+O216","v":-11828.375608981627},{"$f":"O218+P216","v":-20918.023385273922},{"$f":"P218+Q216","v":-30927.772552438048},{"$f":"Q218+R216","v":-34917.749190828108},{"$f":"R218+S216","v":-34846.446416249404},{"$f":"S218+T216","v":-37429.150643736211},{"$f":"T218+U216","v":-40460.802226811058},{"$f":"U218+V216","v":-43968.310125248041},{"$f":"V218+W216","v":-37560.348927726518},{"$f":"W218+X216","v":-34190.797452828338},{"$f":"X218+Y216","v":-29302.883830702234},{"$f":"Y218+Z216","v":-16123.988546212113},{"$f":"Z218+AA216","v":-2945.6665385088891},{"$f":"AA218+AB216","v":14524.494031072154},{"$f":"AB218+AC216","v":23409.23771772685},{"$f":"AC218+AD216","v":36585.809915625709},{"$f":"AD218+AE216","v":49761.788735400056},{"$f":"AE218+AF216","v":62937.169065356589},{"$f":"AF218+AG216","v":80618.024837463949},{"$f":"AG218+AH216","v":82915.500000000131},{"$f":"AH218+AI216","v":82915.500000000116},{"$f":"AI218+AJ216","v":82915.500000000116},{"$f":"AJ218+AK216","v":82915.500000000349},{"$f":"AK218+AL216","v":82915.500000001222},"CASHBALANCE"]
[null,null,null,{"$f":"IF(D218>0,D218,0)","v":66.19999999999709},{"$f":"IF(E218>0,E218,0)","v":0},0,{"$f":"IF(G218>0,G218,0)","v":0},{"$f":"IF(H218>0,H218,0)","v":0},{"$f":"IF(I218>0,I218,0)","v":1672.2495384805261},21694.670873778898,4200.6168906551611,10472.736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AA218>0,AA218,0)","v":0},14524.494031072154,23409.23771772685,36585.809915625709,49761.788735400056,62937.169065356589,80618.024837463949,82915.500000000131,82915.500000000116,82915.500000000116,82915.500000000349,82915.500000001222,"POSBAL"]
[null,null,null,{"$f":"IF(D218<0,-D218,0)","v":0},925.51084210526301,3584.1569390581781,{"$f":"IF(G218<0,-G218,0)","v":8498.5534621665065},{"$f":"IF(H218<0,-H218,0)","v":17295.237128596324},0,0,0,0,9334.3730750509749,3601.796972828608,11828.375608981627,20918.023385273922,30927.772552438048,34917.749190828108,34846.446416249404,37429.150643736211,40460.802226811058,43968.310125248041,37560.348927726518,34190.797452828338,29302.883830702234,16123.988546212113,{"$f":"IF(AA218<0,-AA218,0)","v":2945.6665385088891},0,0,0,0,0,0,0,0,0,0,0,"NEGBAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASH BANK"]
[null,null,null,null,null,null,null,null,{"$f":"I211+H218/100","v":18794.534295790887},{"$f":"I222/0.99","v":18984.378076556452}]
["INCOME STATEMENT"]
[]
[null,"REVENUES",null,{"$f":"INDIRECT($B225)","v":0},{"$f":"INDIRECT($B225)","v":0},{"$f":"INDIRECT($B225)","v":0},0,0,51499.492454899992,52014.48737944899,52534.632253243479,53059.978575775924,26795.289180766838,54126.484145149021,54667.748986600513,55214.42647646652,55766.570741231175,28162.118224321748,56887.478813129928,57456.353601261224,58030.917137273849,58611.226308646583,29598.669285866526,59789.311957450394,60387.205077024897,60991.077127795143,61600.987899073094,31108.498889031918,62839.167755844472,63467.559433402908,64102.235027736941,64743.257378014321,32695.344975897227,0,0,0,0,0]
[null,"COST",null,{"$f":"INDIRECT($B226)","v":0},0,{"$f":"INDIRECT($B226)","v":0},0,0,-12754.001623613489,-12887.008414748285,-13021.455155969887,-13157.358455410902,-10267.465818424605,-13433.602216852702,-13573.976959528929,-13715.876827914128,-13859.319512968854,-10806.921111617188,-14150.905229912509,-14299.084786493615,-14448.880215776602,-14600.310371438922,-11375.537800899743,-14908.151493653604,-15064.601395207672,-15222.763900348289,-15382.659112013202,-11974.975383643268,-15707.729374803761,-15872.945951438105,-16039.978293424807,-16208.847846769069,-12606.996000453551,0,0,0,0,0]
[null,"TAX",null,{"$f":"INDIRECT($B227)","v":0},0,{"$f":"INDIRECT($B227)","v":0},0,0,-4619.1865030144945,-4668.1117554939701,-4717.5812015859701,-4767.6013875424869,-4671.6508815031602,-4869.3206036761112,-4921.0331699667231,-4973.323551061344,-5026.19874495975,-4917.807700715699,-5133.7320370999314,-5188.4046096119209,-5243.6909464170658,-5299.598532633514,-5177.3428688874792,-5413.3079050138276,-5471.1251773727308,-5529.5946747407288,-5588.7244078188505,-5451.0248028169008,-5708.997175735557,-5770.1567889360658,-5832.0097980615856,-5894.5647812472098,-5739.6701123771199,0,0,0,0,0]
[null,"AMORT",null,{"$f":"INDIRECT($B228)","v":0},0,{"$f":"INDIRECT($B228)","v":0},0,0,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,-13240,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D225:D228)","v":0},0,0,0,0,{"$f":"SUM(I225:I228)","v":20886.304328272003},21219.367209206735,21555.59589568762,21895.018732822529,-1383.8275191609246,22583.561324620212,22932.738857104858,23285.226097491046,23641.05248330257,-802.61058801113722,24362.841546117488,24728.864205155689,25098.345975080178,25471.317404574147,-194.21138392069588,26227.852558782964,26611.478504444502,26998.718552706123,{"$f":"SUM(AA225:AA228)","v":27389.604379241042},442.49870257174916,28182.441205305149,28584.456693028733,28990.246936250551,29399.844749998047,1108.6788630665542,0,0,0,0,0,"PLPROD"]
[null,"INTST",null,{"$f":"INDIRECT($B230)","v":0},{"$f":"INDIRECT($B230)","v":-46.275542105263156},-179.20784695290891,-424.92767310832534,-864.76185642981625,16.72249538480526,216.94670873778898,42.006168906551615,104.72736529271373,-466.71865375254879,-180.08984864143042,-591.4187804490814,-1045.9011692636961,-1546.3886276219025,-1745.8874595414054,-1742.3223208124703,-1871.4575321868106,-2023.040111340553,-2198.4155062624022,-1878.0174463863259,-1709.5398726414169,-1465.1441915351118,-806.19942731060564,-147.28332692544447,145.24494031072157,234.0923771772685,365.85809915625697,497.61788735400012,629.371690653565,806.18024837463815,829.15499999999986,829.15499999999929,829.15499999999656,829.15499999998985,829.15499999997837]
[null,"INTLT",null,{"$f":"INDIRECT($B231)","v":0},-1044.7352999999998,{"$f":"INDIRECT($B231)","v":-2611.8382500000002},-4701.3088500000003,-8044.4618100000007,-9820.5118199999997,-10447.353000000001,-10447.353000000001,-9613.7044101431802,-8735.962680642373,-7811.2005372212598,-6836.2953511341029,-5807.9160376366863,-4722.5090717472422,-3576.2835615714962,-3011.3753106667154,-2422.5224247076476,-1808.2882255910356,-1167.1498345274263,-497.49299999999937,-331.66199999999941,-165.83099999999942,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13]
[null,null,null,{"$f":"SUM(D229:D231)","v":0},-1091.010842105263,-2791.046096952909,-5126.2365231083259,-8909.2236664298161,11082.515003656808,10988.960917944523,11150.249064594171,12386.041687972063,-10586.508853555846,14592.270938757523,15505.024725521671,16431.408890590665,17372.154783933427,-6124.7816091240384,19609.143914638305,20434.884248261231,21267.017638148587,22105.752063784319,-2569.7218303070213,24186.650686141547,24980.50331290939,26192.519125395516,{"$f":"SUM(AA229:AA231)","v":27242.321052315598},587.74364288247136,28416.533582482418,28950.314792184989,29487.864823604552,30029.216440651613,1914.8591114411931,829.15500000000043,829.15499999999986,829.15499999999713,829.15499999999042,829.15499999997894,"PLBEFTAX"]
[null,"TAXCO",null,{"$f":"INDIRECT($B233)","v":0},0,{"$f":"INDIRECT($B233)","v":0},0,0,0,-1246.187637901505,-3345.0747193782513,-3715.8125063916186,0,-1201.7286255605031,-4651.5074176565013,-4929.4226671771994,-5211.6464351800278,0,-4045.3086916542798,-6130.4652744783689,-6380.1052914445763,-6631.7256191352953,0,-6485.0786567503574,-7494.1509938728168,-7857.7557376186542,-8172.6963156946786,-176.32309286474191,-8524.9600747447257,-8685.0944376554962,-8846.3594470813659,-9008.7649321954814,-574.45773343235044,-248.74649999999065,-248.7464999999986,-248.7465000000214,-248.74650000005545,-248.74650000008742]
[null,null,null,{"$f":"D232+D233","v":0},-1091.010842105263,-2791.046096952909,-5126.2365231083259,-8909.2236664298161,11082.515003656808,9742.7732800430185,7805.1743452159189,8670.2291815804456,-10586.508853555846,13390.54231319702,10853.51730786517,11501.986223413465,12160.508348753399,-6124.7816091240384,15563.835222984026,14304.418973782862,14886.912346704012,15474.026444649024,-2569.7218303070213,17701.572029391191,17486.352319036574,18334.76338777686,{"$f":"AA232+AA233","v":19069.624736620921},411.42055001772945,19891.573507737692,20265.220354529491,20641.505376523186,21020.451508456132,1340.4013780088426,580.40850000000978,580.40850000000125,580.40849999997567,580.40849999993497,580.40849999989155,"PLAFTERTAX"]
[null,"DIVIDEND",null,{"$f":"INDIRECT($B235)","v":0},0,{"$f":"INDIRECT($B235)","v":0},0,0,0,-1235.5216166229857,0,-13947.036174621731,0,-7004.6503502963351,-10853.517307865168,-11501.986223413467,-12160.508348753399,0,-9439.0536138599873,-14304.418973782862,-14886.912346704014,-15474.026444649024,0,-15131.850199084171,-17486.352319036574,-18334.76338777686,-19069.624736620921,-411.42055001773042,-19891.573507737692,-20265.220354529483,-20641.505376523168,-21020.451508456095,-1340.4013780087953,-580.40849999998272,-580.40850000001387,-580.4084999999734,-580.40849999970169,-580.40849999901957]
[null,null,null,{"$f":"D234+D235","v":0},{"$f":"E234+E235","v":-1091.010842105263},-2791.046096952909,-5126.2365231083259,-8909.2236664298161,{"$f":"I234+I235","v":11082.515003656808},8507.2516634200329,7805.1743452159189,-5276.8069930412858,-10586.508853555846,6385.891962900685,0,0,0,-6124.7816091240384,6124.7816091240384,0,0,0,-2569.7218303070213,2569.7218303070204,0,0,{"$f":"AA234+AA235","v":0},-9.6633812063373625E-13,0,0,0,3.637978807091713E-11,4.7293724492192268E-11,2.7057467377744615E-11,-1.2619238987099379E-11,2.2737367544323206E-12,2.3328539100475609E-10,8.7197804532479495E-10]
[null,"CUMPL",null,{"$f":"D236","v":0},{"$f":"D237+E236","v":-1091.010842105263},{"$f":"E237+F236","v":-3882.0569390581722},-9008.2934621664972,-17917.517128596315,-6835.0021249395068,1672.2495384805261,9477.423883696445,4200.6168906551593,-6385.8919629006868,0,0,0,0,-6124.7816091240384,0,0,0,0,-2569.7218303070213,0,0,0,0,-9.6633812063373625E-13,-9.6633812063373625E-13,-9.6633812063373625E-13,-9.6633812063373625E-13,3.5413449950283393E-11,8.2707174442475662E-11,1.0976464182022028E-10,9.7145402833120897E-11,9.9419139587553218E-11,3.3270453059230931E-10,1.2046825759171043E-9]
[]
["BALANCE SHEET"]
[]
["ASSETS"]
[null,"CAPNET",null,{"$f":"INDIRECT($B242)","v":33100},{"$f":"INDIRECT($B242)","v":82750},{"$f":"INDIRECT($B242)","v":148950},254870,311140,317760,304520,291280,278040,264800,251560,238320,225080,211840,198600,185360,172120,158880,145640,132400,119160,105920,92680,79440,66200,52960,39720,26480,13240,0,0,0,0,0,0]
[null,"POSBAL",null,{"$f":"INDIRECT($B243)","v":66.19999999999709},0,{"$f":"INDIRECT($B243)","v":0},0,0,1672.2495384805261,21694.670873778898,4200.6168906551611,10472.736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14524.494031072154,23409.23771772685,36585.809915625709,49761.788735400056,62937.169065356589,80618.024837463949,82915.500000000131,82915.500000000116,82915.500000000116,82915.500000000349,82915.500000001222]
[null,"DSRA",null,{"$f":"INDIRECT($B244)","v":0},{"$f":"INDIRECT($B244)","v":0},{"$f":"INDIRECT($B244)","v":0},{"$f":"INDIRECT($B244)","v":0},0,0,1672.2495384805261,21694.670873778898,4200.6168906551611,10472.736529271373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WCPAY",null,{"$f":"INDIRECT($B245)","v":0},{"$f":"INDIRECT($B245)","v":0},{"$f":"INDIRECT($B245)","v":0},0,0,8583.2487424833325,8669.0812299081663,8755.7720422072471,8843.3297626293206,4465.8815301278064,9021.0806908581708,9111.2914977667515,9202.4044127444213,9294.4284568718613,4693.6863707202911,9481.2464688549881,9576.0589335435361,9671.8195228789755,9768.5377181077638,4933.1115476444211,9964.8853262417324,10064.53417950415,10165.179521299189,10266.831316512184,5184.749814838653,10473.19462597408,10577.926572233817,10683.705837956157,10790.542896335721,5449.2241626495379,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D242:D245)","v":33166.199999999997},{"$f":"SUM(E242:E245)","v":82750},148950,254870,311140,328015.49828096386,336556.00164216757,325931.05980664125,301556.68318255583,279738.61805939913,260581.08069085816,247431.29149776674,234282.40441274442,221134.42845687186,203293.6863707203,194841.24646885498,181696.05893354354,168551.81952287897,155408.53771810775,137333.11154764442,129124.88532624173,115984.53417950415,102845.17952129919,{"$f":"SUM(AA242:AA245)","v":89706.83131651218},85909.243845910809,86842.43234370093,86883.736487859525,86925.494573356205,86967.711961692316,86067.249000113487,82915.500000000131,82915.500000000116,82915.500000000116,82915.500000000349,82915.500000001222]
[]
["LIABILITIES"]
[null,"NEGBAL",null,{"$f":"INDIRECT($B249)","v":0},{"$f":"INDIRECT($B249)","v":925.51084210526301},{"$f":"INDIRECT($B249)","v":3584.1569390581781},8498.5534621665065,17295.237128596324,0,0,0,0,9334.3730750509749,3601.796972828608,11828.375608981627,20918.023385273922,30927.772552438048,34917.749190828108,34846.446416249404,37429.150643736211,40460.802226811058,43968.310125248041,37560.348927726518,34190.797452828338,29302.883830702234,16123.988546212113,2945.6665385088891,0,0,0,0,0,0,0,0,0,0,0]
[null,"OUTLT",null,{"$f":"INDIRECT($B250)","v":24874.649999999998},62186.625,{"$f":"INDIRECT($B250)","v":111935.92499999999},191534.80499999999,233821.71000000002,248746.5,248746.5,230282.77213395239,211151.226678048,191307.77049264277,170705.38316381641,149293.92164890288,127019.91182049197,103826.32602619159,88883.488511111907,73541.573745127447,57776.637093183905,41563.29724212375,24874.649999999969,16583.099999999969,8291.5499999999702,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11]
[null,"WCREC",null,{"$f":"INDIRECT($B251)","v":0},0,{"$f":"INDIRECT($B251)","v":0},0,0,3188.5004059033722,3221.7521036870712,3255.3637889924717,3289.3396138527255,2566.8664546061514,3358.4005542131754,3393.4942398822323,3428.9692069785319,3464.8298782422135,2701.7302779042971,3537.7263074781272,3574.7711966234037,3612.2200539441505,3650.0775928597304,2843.8844502249358,3727.037873413401,3766.150348801918,3805.6909750870718,3845.6647780033004,2993.7438459108171,3926.9323437009402,3968.2364878595263,4009.9945733562013,4052.2119616922669,3151.7490001133874,0,0,0,0,0]
[null,"CUMEQ",null,{"$f":"INDIRECT($B252)","v":8291.5499999999993},20728.875,{"$f":"INDIRECT($B252)","v":37311.974999999999},63844.934999999998,77940.570000000007,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5,82915.5]
[null,"CUMPL",null,{"$f":"INDIRECT($B253)","v":0},{"$f":"INDIRECT($B253)","v":-1091.010842105263},{"$f":"INDIRECT($B253)","v":-3882.0569390581722},-9008.2934621664972,-17917.517128596315,-6835.0021249395068,{"$f":"INDIRECT($B253)","v":1672.2495384805261},9477.423883696445,4200.6168906551593,-6385.8919629006868,0,0,0,0,-6124.7816091240384,0,0,0,0,-2569.7218303070213,0,0,0,0,-9.6633812063373625E-13,-9.6633812063373625E-13,-9.6633812063373625E-13,-9.6633812063373625E-13,3.5413449950283393E-11,8.2707174442475662E-11,1.0976464182022028E-10,9.7145402833120897E-11,9.9419139587553218E-11,3.3270453059230931E-10,1.2046825759171043E-9]
[null,null,null,{"$f":"SUM(D249:D253)","v":33166.199999999997},82750,148949.99999999997,254870,311140,328015.49828096386,336556.00164216757,325931.05980664131,301556.68318255583,279738.61805939919,260581.08069085819,247431.29149776674,234282.40441274442,221134.42845687186,203293.68637072027,194841.24646885498,181696.05893354351,168551.81952287897,155408.53771810775,137333.1115476444,129124.88532624171,115984.53417950412,102845.17952129916,89706.831316512165,85909.243845910794,86842.432343700915,86883.736487859496,86925.494573356176,86967.711961692272,86067.249000113443,82915.500000000087,82915.500000000073,82915.500000000073,82915.500000000306,82915.500000001179]
[]
["BS Controls",null,{"$f":"SUM(ABS(D256:AL256))=0","v":true},{"$f":"D246-D254","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["RATIOS"]
["CASH FLOWS"]
[]
["OPERATIONS","CFOP",{"$f":"IRR(D262:AL262)","v":7.249008142975355E-2},{"$f":"INDIRECT($B262)","v":-33100},{"$f":"INDIRECT($B262)","v":-49650},{"$f":"INDIRECT($B262)","v":-66200},-105920,-56270.000000000007,8871.5559916920429,{"$f":"INDIRECT($B262)","v":34406.7864195656},34742.516768693939,35081.436837260713,15511.147554094016,32059.89626349687,36117.621735865338,36469.588149609677,36824.889110438809,16275.031897802517,33651.277477556621,37911.096629612417,38280.034243065485,38652.456748260942,17075.02164390785,35319.232203374122,39790.942126570604,40177.613837196237,40567.926386944273,17912.659272152796,37067.184891959849,41761.028890927584,42166.225756024884,42575.225079954544,18789.534635173859,2297.4751625361505,0,0,0,0]
[]
["SPV","CFBEFTAX",{"$f":"IRR(D264:AL264)","v":0.5230870584157985},{"$f":"INDIRECT($B264)","v":66.19999999999709},{"$f":"INDIRECT($B264)","v":-991.7108421052601},-2658.6460969529148,-4914.3965231083293,-8796.6836664298153,18967.48666707685,{"$f":"INDIRECT($B264)","v":24176.38012830339},5873.442071552885,6440.9143365058244,-13534.989965706136,3466.2185488078312,7278.446089368651,7341.7611142983724,7362.4056167693007,-3989.9766383900628,13555.665080092973,17852.180020774427,18235.36605507374,18598.244165347336,6407.9611975215257,24986.480330732706,29868.416935035493,39371.414409885634,40420.643060018825,18057.904212463516,37301.277269137114,42126.88699008384,42663.843643378881,43204.596770608106,19595.714883548499,3126.6301625361507,829.15499999999986,829.15499999999713,829.15499999999042,0]
[]
["EQUITY","EQ",null,{"$f":"INDIRECT($B266)","v":8291.5499999999993},{"$f":"INDIRECT($B266)","v":12437.325000000001},16583.099999999999,26532.959999999999,14095.635000000002,4974.93,{"$f":"INDIRECT($B266)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DIVIDEND",null,{"$f":"INDIRECT($B267)","v":0},{"$f":"INDIRECT($B267)","v":0},0,0,0,0,{"$f":"INDIRECT($B267)","v":-1235.5216166229857},0,-13947.036174621731,0,-7004.6503502963351,-10853.517307865168,-11501.986223413467,-12160.508348753399,0,-9439.0536138599873,-14304.418973782862,-14886.912346704014,-15474.026444649024,0,-15131.850199084171,-17486.352319036574,-18334.76338777686,-19069.624736620921,-411.42055001773042,-19891.573507737692,-20265.220354529483,-20641.505376523168,-21020.451508456095,-1340.4013780087953,-580.40849999998272,-580.40850000001387,-580.4084999999734,-580.40849999970169,0]
[null,null,{"$f":"IRR(D268:AL268)","v":7.5451492319513314E-2},{"$f":"-SUM(D266:D267)","v":-8291.5499999999993},{"$f":"-SUM(E266:E267)","v":-12437.325000000001},-16583.099999999999,-26532.959999999999,-14095.635000000002,-4974.93,1235.5216166229857,0,13947.036174621731,0,7004.6503502963351,10853.517307865168,11501.986223413467,12160.508348753399,0,9439.0536138599873,14304.418973782862,14886.912346704014,15474.026444649024,0,15131.850199084171,17486.352319036574,18334.76338777686,19069.624736620921,411.42055001773042,19891.573507737692,20265.220354529483,20641.505376523168,21020.451508456095,1340.4013780087953,580.40849999998272,580.40850000001387,580.4084999999734,580.40849999970169,0]
[]
["DSCR",null,"CFOP",{"$f":"INDIRECT($C270)","v":-33100},-49650,-66200,-105920,-56270.000000000007,8871.5559916920429,34406.7864195656,34742.516768693939,35081.436837260713,15511.147554094016,{"$f":"INDIRECT($C270)","v":32059.89626349687},36117.621735865338,36469.588149609677,36824.889110438809,16275.031897802517,33651.277477556621,37911.096629612417,38280.034243065485,38652.456748260942,17075.02164390785,{"$f":"INDIRECT($C270)","v":35319.232203374122},39790.942126570604,40177.613837196237,40567.926386944273,17912.659272152796,37067.184891959849,41761.028890927584,42166.225756024884,42575.225079954544,18789.534635173859,2297.4751625361505,0,0,0,0]
[null,null,"CAPEX",-33100,-49650,-66200,-105920,-56270.000000000007,-19860,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CFADS",{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":28731.555991692043},{"$f":"CFOP-Capex","v":34406.7864195656},{"$f":"CFOP-Capex","v":34742.516768693939},{"$f":"CFOP-Capex","v":35081.436837260713},{"$f":"CFOP-Capex","v":15511.147554094016},{"$f":"CFOP-Capex","v":32059.89626349687},{"$f":"CFOP-Capex","v":36117.621735865338},{"$f":"CFOP-Capex","v":36469.588149609677},{"$f":"CFOP-Capex","v":36824.889110438809},{"$f":"CFOP-Capex","v":16275.031897802517},{"$f":"CFOP-Capex","v":33651.277477556621},{"$f":"CFOP-Capex","v":37911.096629612417},{"$f":"CFOP-Capex","v":38280.034243065485},{"$f":"CFOP-Capex","v":38652.456748260942},{"$f":"CFOP-Capex","v":17075.02164390785},{"$f":"CFOP-Capex","v":35319.232203374122},{"$f":"CFOP-Capex","v":39790.942126570604},{"$f":"CFOP-Capex","v":40177.613837196237},{"$f":"CFOP-Capex","v":40567.926386944273},{"$f":"CFOP-Capex","v":17912.659272152796},{"$f":"CFOP-Capex","v":37067.184891959849},{"$f":"CFOP-Capex","v":41761.028890927584},{"$f":"CFOP-Capex","v":42166.225756024884},{"$f":"CFOP-Capex","v":42575.225079954544},{"$f":"CFOP-Capex","v":18789.534635173859},{"$f":"CFOP-Capex","v":2297.4751625361505},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},{"$f":"CFOP-Capex","v":0},"CFADS"]
[null,null,{"$f":"SUM(CFADS)","v":830215.40571373771},{"$f":"forme(C273)","v":"=SUM(CFADS)"},null,null,null,null,{"$f":"J273/(1+WACC)+I272","v":372725.02802184672},{"$f":"K273/(1+WACC)+J272","v":371512.94979256706},{"$f":"L273/(1+WACC)+K272","v":364074.65644284157},{"$f":"M273/(1+WACC)+L272","v":355678.71084807947},{"$f":"N273/(1+WACC)+M272","v":346245.05593168427},{"$f":"O273/(1+WACC)+N272","v":357192.6210477975},{"$f":"P273/(1+WACC)+O272","v":351143.34276704467},{"$f":"Q273/(1+WACC)+P272","v":340227.77871367376},{"$f":"R273/(1+WACC)+Q272","v":328058.8458091892},{"$f":"S273/(1+WACC)+R272","v":314532.6732346504},{"$f":"T273/(1+WACC)+S272","v":322118.25264379574},{"$f":"U273/(1+WACC)+T272","v":311544.33317953831},{"$f":"V273/(1+WACC)+U272","v":295523.89547391998},{"$f":"W273/(1+WACC)+V272","v":277823.37012932287},{"$f":"X273/(1+WACC)+W272","v":258304.58645154687},{"$f":"Y273/(1+WACC)+X272","v":260527.92999225017},{"$f":"Z273/(1+WACC)+Y272","v":243225.39361198613},{"$f":"AA273/(1+WACC)+Z272","v":219709.20760424878},{"$f":"AB273/(1+WACC)+AA272","v":193894.12126841675},{"$f":"AC273/(1+WACC)+AB272","v":165592.29047199027},{"$f":"AD273/(1+WACC)+AC272","v":159494.0016958245},{"$f":"AE273/(1+WACC)+AD272","v":132220.96214817383},{"$f":"AF273/(1+WACC)+AE272","v":97696.727917825949},{"$f":"AG273/(1+WACC)+AF272","v":59972.942334745152},{"$f":"AG272","v":18789.534635173859}]
[null,"NPV",{"$f":"NPV(WACC,CFADS)*(1+WACC)","v":253898.70813885573},{"$f":"forme(C274)","v":"=NPV(WACC,CFADS)*(1+WACC)"},null,null,null,null,{"$f":"J274/(1+WACC)+I272","v":313344.45085975132},{"$f":"K274/(1+WACC)+J272","v":307381.92645750404},{"$f":"L274/(1+WACC)+K272","v":294813.1512409735},{"$f":"M274/(1+WACC)+L272","v":280876.28523006197},{"$f":"N274/(1+WACC)+M272","v":265458.4362642254},{"$f":"O274/(1+WACC)+N272","v":269943.07180694188},{"$f":"P274/(1+WACC)+O272","v":256913.82958692062},{"$f":"Q274/(1+WACC)+P272","v":238459.90447913972},{"$f":"R274/(1+WACC)+Q272","v":218149.54163589244},{"$f":"S274/(1+WACC)+R272","v":195830.62472748992},{"$f":"T274/(1+WACC)+S272","v":193920.04025606241},{"$f":"U274/(1+WACC)+T272","v":173090.26380078626},{"$f":"V274/(1+WACC)+U272","v":145993.50054486777},{"$f":"W274/(1+WACC)+V272","v":116330.54360594647},{"$f":"X274/(1+WACC)+W272","v":83892.333806300376},{"$f":"Y274/(1+WACC)+X272","v":72162.697135383933},{"$f":"Y272","v":39790.942126570604}]
[null,null,{"$f":"C274*(1+WACC)^5","v":373060.50053166947},"=C274*(1+WACC)^5"]
[]
[null,null,"INTLT",{"$f":"INDIRECT($C277)","v":0},-1044.7352999999998,-2611.8382500000002,-4701.3088500000003,-8044.4618100000007,-9820.5118199999997,-10447.353000000001,-10447.353000000001,-9613.7044101431802,-8735.962680642373,-7811.2005372212598,-6836.2953511341029,-5807.9160376366863,-4722.5090717472422,-3576.2835615714962,-3011.3753106667154,{"$f":"INDIRECT($C277)","v":-2422.5224247076476},-1808.2882255910356,-1167.1498345274263,-497.49299999999937,-331.66199999999941,-165.83099999999942,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,5.8207660913467408E-13,{"$f":"INDIRECT($C277)","v":5.8207660913467408E-13},5.8207660913467408E-13,5.8207660913467408E-13]
[null,null,"AMOLT",0,0,0,0,0,0,0,-18463.727866047604,-19131.545455904423,-19843.45618540523,-20602.387328826349,-21411.461514913502,-22274.009828410923,-23193.585794300365,-14942.837515079678,-15341.914765984464,-15764.936651943532,-16213.339851060153,-16688.647242123778,-8291.5499999999993,-8291.5499999999993,-8291.5499999999993,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CFDEBT",{"$f":"IntLT+AmoLT","v":0},{"$f":"IntLT+AmoLT","v":-1044.7352999999998},{"$f":"IntLT+AmoLT","v":-2611.8382500000002},{"$f":"IntLT+AmoLT","v":-4701.3088500000003},{"$f":"IntLT+AmoLT","v":-8044.4618100000007},{"$f":"IntLT+AmoLT","v":-9820.5118199999997},{"$f":"IntLT+AmoLT","v":-10447.353000000001},{"$f":"IntLT+AmoLT","v":-28911.080866047603},{"$f":"IntLT+AmoLT","v":-28745.249866047605},{"$f":"IntLT+AmoLT","v":-28579.418866047603},{"$f":"IntLT+AmoLT","v":-28413.587866047608},{"$f":"IntLT+AmoLT","v":-28247.756866047606},{"$f":"IntLT+AmoLT","v":-28081.925866047608},{"$f":"IntLT+AmoLT","v":-27916.094866047606},{"$f":"IntLT+AmoLT","v":-18519.121076651176},{"$f":"IntLT+AmoLT","v":-18353.290076651181},{"$f":"IntLT+AmoLT","v":-18187.459076651179},{"$f":"IntLT+AmoLT","v":-18021.628076651188},{"$f":"IntLT+AmoLT","v":-17855.797076651204},{"$f":"IntLT+AmoLT","v":-8789.0429999999978},{"$f":"IntLT+AmoLT","v":-8623.2119999999995},{"$f":"IntLT+AmoLT","v":-8457.3809999999994},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},{"$f":"IntLT+AmoLT","v":5.8207660913467408E-13},"CFDEBT"]
[null,null,{"$f":"SUM(CFDEBT)","v":-352372.25547558919},{"$f":"forme(C280)","v":"=SUM(CFDEBT)"}]
[null,null,{"$f":"NPV(WACC,CFDEBT)*(1+WACC)","v":-151812.85091123095},{"$f":"forme(C281)","v":"=NPV(WACC,CFDEBT)*(1+WACC)"}]
[null,null,{"$f":"C281*(1+WACC)^5","v":-223062.88426292417},"=C281*(1+WACC)^5"]
["average","min"]
[{"$f":"AVERAGE(DSCR)","v":2.0022195615994334},{"$f":"MIN(DSCR)","v":0.542738382008225},"DSCR",null,null,null,null,null,{"$f":"-I272/I279","v":2.925667879466189},{"$f":"-J272/J279","v":3.2933496570438079},1.2017024520689787,1.2204255312004466,0.542738382008225,1.1283297419051526,1.2786014092070055,1.2986854364466205,1.3191275243596605,0.87882312721212263,1.8335283394429287,2.084463611427843,2.1241163162534176,2.1647007177744024,1.9427623284933131,4.0958325277604359,4.7048775651198174]
[]
[null,null,"OUTLT",{"$f":"INDIRECT($C286)","v":24874.649999999998},62186.625,111935.92499999999,191534.80499999999,233821.71000000002,248746.5,248746.5,230282.77213395239,211151.226678048,191307.77049264277,170705.38316381641,149293.92164890288,127019.91182049197,103826.32602619159,88883.488511111907,73541.573745127447,57776.637093183905,41563.29724212375,24874.649999999969,16583.099999999969,8291.5499999999702,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11,-2.9103830456733704E-11]
[{"$f":"AVERAGE(PLCR)","v":6.0585898964648734},{"$f":"MIN(PLCR)","v":1.4935404107899692},"PLCR",null,null,null,null,null,{"$f":"I273/I286","v":1.498413155649815},{"$f":"J273/J286","v":1.4935404107899692},1.5809895506688805,1.68447380791398,1.809884956790085,2.092450832115937,2.3520270543420692,2.6785389301363476,3.1596884756033066,3.5387075654138913,4.3800837572521747,5.3922199154144295,7.1102129783488675,11.168935849522434,15.576375132004712,31.42089597147109]
[{"$f":"AVERAGE(LLCR)","v":2.722584146894572},{"$f":"MIN(LLCR)","v":1.2357236240811591},"LLCR",null,null,null,null,null,{"$f":"I274/I286","v":1.2596939086972132},{"$f":"J274/J286","v":1.2357236240811591},1.28022234798131,1.3302138455407932,1.3875988182844579,1.5813389525501524,1.7208592737694262,1.8773427021122311,2.1011004625249021,2.2032283836722706,2.6368764003899323,2.9958521732862549,3.5125581999520876,4.676670570478243,5.0589053799531172,8.7031613070395988]