{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["FLUXO DE CAIXA","RECEITA","VAGAS RECEITA","CAPEX","VAGAS CAPEX","ESTACIONAMENTOS","EDIFICAÇÕES","EQUIPAMENTOS","CCO","SISTEMAS","VEíCULOS","COMUNICAÇÃO","UNIFORMES","OPEX","ADMINISTRATIVO OPEX","CAMPO OPEX","CCO OPEX","CUSTO FIXO OPEX","COMUNICAÇÃO OPEX","WACC","RESSARCIMENTO","FLUXO DE CAIXA 15 ANOS","FLUXO DE CAIXA 10 ANOS"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":3,"defined_names":0,"comments":2,"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":"FLUXO DE CAIXA","index":0,"n_rows":148,"n_cols":40,"rows_kept":148,"cut":false,"hidden":false,"merged":[[73,2,74,2],[69,2,69,3],[2,2,2,3],[29,1,29,2],[39,5,40,8],[62,2,62,3],[66,2,67,2]]}
[]
[null,"DATA BASE: ABRIL / 2021"]
[]
[null,"DRE","Total","Pré-Oper"," 1º Ano","2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano","11º ano","12º ano","13º ano","14º ano","15º ano","16º ano","17º ano","18º ano","19º ano","20º ano"]
[null,"Receita Tarifária Bruta",{"$f":"SUM(D5:X5)","v":1409847568.6006765},null,{"$f":"(RECEITA!J36+RECEITA!J36/RECEITA!J34*'FLUXO DE CAIXA'!I43)*(1+K43)","v":16070251.802907979},{"$f":"(RECEITA!J37+RECEITA!J37/RECEITA!J34*'FLUXO DE CAIXA'!I43)*(1+K43)","v":44167579.147635177},{"$f":"(RECEITA!J38+RECEITA!J38/RECEITA!J34*'FLUXO DE CAIXA'!I43)*(1+K43)","v":57430201.602133334},{"$f":"(RECEITA!J34+$I$43)*(1+$K$43)","v":76010560.944000006},{"$f":"H5","v":76010560.944000006},{"$f":"I5","v":76010560.944000006},{"$f":"J5","v":76010560.944000006},{"$f":"K5","v":76010560.944000006},76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006,76010560.944000006]
[0.2,"Outorga Mensal",-281969513.72013539,null,{"$f":"-E5*$A$6","v":-3214050.3605815959},{"$f":"-F5*$A$6","v":-8833515.8295270354},-11486040.320426667,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002,-15202112.188800002]
[69654800,"Outorga Inicial",-69654800,{"$f":"-A7","v":-69654800}]
[0,"VF Regulatória",0,null,{"$f":"-$A$8*E5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,"VF de Trânsito",0,null,{"$f":"-E5*$A$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Receita Após Repasse",1127878054.8805416,null,{"$f":"E5+E6+(E8+E9)","v":12856201.442326384},35334063.318108141,45944161.281706668,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006]
[{"$f":"D2","v":0},"Receita Após Participação",1127878054.8805416,null,{"$f":"E10*(1-$A$11)","v":12856201.442326384},35334063.318108141,45944161.281706668,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006,60808448.755200006]
[null,"Tributos sobre Receita",-121951814.68395856,null,{"$f":"SUM(E13:E15)","v":-1390076.7809515402},{"$f":"SUM(F13:F15)","v":-3820495.5962704429},-4967712.4385845335,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001,-6574913.5216560001]
[0.03,"PIS",-42295427.058020286,null,{"$f":"(-E5*$A$13)","v":-482107.55408723938},{"$f":"(-F5*$A$13)","v":-1325027.3744290553},-1722906.048064,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999,-2280316.8283199999]
[6.4999999999999997E-3,"COFINS",-9164009.1959043965,null,{"$f":"(-E5*$A14)","v":-104456.63671890186},{"$f":"(-F5*$A14)","v":-287089.26445962861},-373296.31041386665,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136,-494068.646136]
[0.05,"ISS",-70492378.430033848,null,{"$f":"-E5*$A15","v":-803512.59014539898},-2208378.9573817588,-2871510.0801066668,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004,-3800528.0472000004]
[{"$f":"J2","v":0},"Receita Líquida",1005926240.1965826,null,{"$f":"E11+E12","v":11466124.661374843},{"$f":"F11+F12","v":31513567.721837699},40976448.843122132,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007,54233535.233544007]
[null,null,null,null,{"$f":"E16/E5","v":0.71350000000000002},0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002,0.71350000000000002]
[]
[null,"CUSTOS E DESPESAS OPERAÇÃO",{"$f":"SUM(D19:X19)","v":-493476571.88303953},null,{"$f":"-(OPEX!D7+OPEX!D10)*('VAGAS CAPEX'!O34+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!N29)/('VAGAS CAPEX'!N35+'VAGAS CAPEX'!O35)-OPEX!D8*'FLUXO DE CAIXA'!E5/'FLUXO DE CAIXA'!H5-OPEX!D9","v":-6824963.8413991109},{"$f":"-OPEX!D7-OPEX!D8*'FLUXO DE CAIXA'!F5/'FLUXO DE CAIXA'!H5-OPEX!D9-OPEX!D10","v":-17325247.509332523},{"$f":"-OPEX!D7-OPEX!D8-OPEX!D9-OPEX!D10","v":-28093818.506354254},{"$f":"-OPEX!D6","v":-28093818.506354254},{"$f":"0.99*H19","v":-27812880.321290713},-27534751.518077806,-27259404.002897028,-26986809.962868057,-26716941.863239378,-26449772.444606982,-26185274.720160913,-25923421.972959302,-25664187.753229707,-25407545.875697412,-25153470.416940436,-24901935.712771032,-24652916.355643321,-24406387.192086887,-24162323.320166018,-23920700.086964358]
[null,"DEPRECIAÇÃO",-176442731.7248638,null,{"$f":"-E59","v":-7108129.7916175211},-9105360.1453945432,-9105360.1453945432,-9105360.1453945432,-9105360.1453945432,-8860877.4234445412,{"$f":"J20","v":-8860877.4234445412},-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412,-8860877.4234445412]
[null,"Lucro Bruto",336006936.58867949,null,{"$f":"E16+E19+E20","v":-2466968.9716417892},{"$f":"F16+F19+F20","v":5082960.0671106335},{"$f":"G16+G19+G20","v":3777270.1913733352},{"$f":"H16+H19+H20","v":17034356.581795208},17315294.766858749,17837906.292021662,18113253.807202436,18385847.84723141,18655715.94686009,18922885.365492485,19187383.089938551,19449235.837140165,19708470.05686976,19965111.934402056,20219187.393159032,20470722.097328432,20719741.454456143,20966270.618012577,21210334.489933446,21451957.723135106]
[null,null,0]
[null,"Lucro antes de IR",451151221.95221663,null,{"$f":"0.32*E5","v":5142480.5769305537},{"$f":"0.32*F5","v":14133625.327243257},18377664.512682669,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001,24323379.502080001]
[0.15,"Imposto de Renda",67672683.292832449,null,{"$f":"IF(E23<0,0,E$23*$A24)","v":771372.08653958305},2120043.7990864883,2756649.6769024003,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999,3648506.9253119999]
[0.1,"Adicional de Imposto",44635122.195221663,null,{"$f":"IF(E23<240000,0,(E$23-240000)*$A25)","v":490248.05769305537},1389362.5327243258,1813766.4512682669,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004,2408337.9502080004]
[0.09,"Contribuição Social",40603609.975699477,null,{"$f":"IF(E23<0,0,E$23*$A26)","v":462823.25192374981},1272026.2794518932,1653989.8061414401,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998,2189104.1551871998]
[null,"Lucro Líquido",108088533.62355042,{"$f":"D31","v":-75006987.501375467},{"$f":"E21-SUM(E24:E26)","v":-4191412.3677981775},{"$f":"F21-SUM(F24:F26)","v":301527.45584792644},-2447135.7429387718,8788407.551088009,9069345.73615155,9591957.2613144629,9867304.7764952369,10139898.816524211,10409766.916152891,10676936.334785286,10941434.059231352,11203286.806432966,11462521.026162561,11719162.903694857,11973238.362451833,12224773.066621233,12473792.423748944,12720321.587305378,12964385.459226247,13206008.692427907]
[{"$f":"H2","v":0},"Lucro Líquido Ajustado",108088533.62355042,{"$f":"D7-RESSARCIMENTO!B4","v":-75006987.501375467},{"$f":"E27*(1-$H$2)","v":-4191412.3677981775},301527.45584792644,-2447135.7429387718,8788407.551088009,9069345.73615155,9591957.2613144629,9867304.7764952369,10139898.816524211,10409766.916152891,10676936.334785286,10941434.059231352,11203286.806432966,11462521.026162561,11719162.903694857,11973238.362451833,12224773.066621233,12473792.423748944,12720321.587305378,12964385.459226247,13206008.692427907]
[null,"Margem  Sobre o Faturamento",{"$f":"C27/C5","v":7.6666822733774051E-2},null,-0.26081808917516303,6.8268956928799855E-3,-4.261060687009445E-2,0.11562087480926206,0.11931691627474367,0.12619242829139543,0.12981491853171392,0.13340118386962935,0.13695158655416553,0.1404664852118564,0.14394623488297029,0.14739118705737314,0.15080168971003194,0.15417808733616409,0.15752072098603498,0.16082992829940707,0.16410604353964553,0.16734939762748158,0.17056031817443926,0.17373912951592738]
[null,"FLUXO DE CAIXA PROJETO",null,null,{"$f":"E4","v":" 1º Ano"},"2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano","11º ano","12º ano","13º ano","14º ano","15º ano","16º ano","17º ano","18º ano","19º ano","20º ano"]
[null,"(=) Lucro Líquido",{"$f":"SUM(D31:X31)","v":108088533.62355042},{"$f":"D7-RESSARCIMENTO!B4","v":-75006987.501375467},{"$f":"E28","v":-4191412.3677981775},{"$f":"F28","v":301527.45584792644},-2447135.7429387718,8788407.551088009,9069345.73615155,9591957.2613144629,9867304.7764952369,10139898.816524211,10409766.916152891,{"$f":"N28","v":10676936.334785286},{"$f":"O28","v":10941434.059231352},11203286.806432966,11462521.026162561,11719162.903694857,11973238.362451833,12224773.066621233,12473792.423748944,12720321.587305378,12964385.459226247,13206008.692427907]
[null,"(+) Depreciação",{"$f":"SUM(E32:X32)","v":176442731.7248638},null,{"$f":"E20*-1","v":7108129.7916175211},{"$f":"F20*-1","v":9105360.1453945432},{"$f":"G20*-1","v":9105360.1453945432},{"$f":"H20*-1","v":9105360.1453945432},9105360.1453945432,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412,8860877.4234445412]
[null,"IMOBILIZADO",{"$f":"SUM(D33:X33)","v":0},null,0,{"$f":"-'[1]TOTALRESUMO '!$I$24","v":0},{"$f":"-'[1]TOTALRESUMO '!$J$24","v":0}]
[null,"(-) Investimentos",{"$f":"SUM(D34:X34)","v":-102430798.24157341},null,{"$f":"-ESTACIONAMENTOS!O81-ESTACIONAMENTOS!Q81-ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K34+'VAGAS CAPEX'!K29)/ESTACIONAMENTOS!M77-('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*20*EDIFICAÇÕES!C4-('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5-0.33*CAPEX!D9-CAPEX!D10-CAPEX!D11-CAPEX!D12-COMUNICAÇÃO!F19-CAPEX!D14","v":-49428548.36797493},{"$f":"-ESTACIONAMENTOS!S81*'VAGAS CAPEX'!K26/ESTACIONAMENTOS!M77-'VAGAS CAPEX'!N26*20*EDIFICAÇÕES!C4-EDIFICAÇÕES!E3-0.67*CAPEX!D9-COMUNICAÇÃO!F36","v":-20597197.773598466},{"$f":"-COMUNICAÇÃO!F53","v":0},null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D12*0.5-CAPEX!D14","v":-10340206.699999999},null,null,null,null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D10-CAPEX!D12*0.5-CAPEX!D14","v":-11724638.699999999},null,null,null,null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D12*0.5-CAPEX!D14","v":-10340206.699999999},{"$f":"O34","v":0},0,0,0]
[null,"(-) Manutenção",{"$f":"SUM(E35:X35)","v":-31654694.610790681},null,null,null,null,null,{"$f":"-0.05*(CAPEX!D7+CAPEX!D8)","v":-1978418.413174418},{"$f":"I35","v":-1978418.413174418},{"$f":"J35","v":-1978418.413174418},-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418]
[null,"(-) Despesas Pré Operacionais",{"$f":"SUM(D36:X36)","v":0}]
[null,"(=) Saldo de Caixa",{"$f":"SUM(D37:X37)","v":150445772.49605021},{"$f":"SUM(D31:D36)","v":-75006987.501375467},{"$f":"SUM(E31:E36)","v":-46511830.944155589},{"$f":"SUM(F31:F36)","v":-11190310.172355996},{"$f":"SUM(G31:G36)","v":6658224.4024557713},17893767.696482554,5856080.768371678,16474416.271584587,16749763.786765361,17022357.826794337,17292225.926423017,5834756.6450554123,17823893.069501478,18085745.816703092,18344980.036432687,18601621.913964983,8515490.6727219578,19107232.076891359,19356251.43401907,19602780.597575504,19846844.469496373,20088467.702698033]
[null,"(=) Saldo de Caixa Acumulado",null,{"$f":"D37","v":-75006987.501375467},{"$f":"E37+D38","v":-121518818.44553106},{"$f":"F37+E38","v":-132709128.61788705},-126050904.21543127,-108157136.51894872,-102301055.75057705,-85826639.478992462,-69076875.692227095,-52054517.865432754,-34762291.939009741,-28927535.293954328,-11103642.224452849,6982103.5922502428,25327083.62868293,43928705.542647913,52444196.215369873,71551428.292261228,90907679.726280302,110510460.3238558,130357304.79335217,150445772.49605021]
[null,"FCL",{"$f":"NPV(C41,E37:X37)+D37","v":150445772.49605018}]
[null,"Exposição Máxima",{"$f":"MIN(D38:S38)","v":-132709128.61788705},null,null,"SIMULAÇÕES"]
[]
[null,"VPL",{"$f":"NPV(C43,D37:X37)","v":4.952918941750973E-8}]
[null,"TIR",{"$f":"IRR(D37:X37)","v":7.1800030999807696E-2},null,null,"TARIFA AUTO (R$)",3,"RECEITA ACESSÓRIA (R$)",{"$f":"RECEITA!D46","v":318926.40000000002},"FRUSTRAÇÃO DE RECEITA",0]
[null,"Taxa Interna de Retorno Acionistas",{"$f":"IRR(D27:X27)","v":7.5625679329952566E-2}]
[null,null,null,null,null,"TAXA DE OCUPAÇÃO (%)",0.3,"TAXA RESPEITO 1º ANO",0.5,"TAXA RESPEITO 4º ANO",0.6]
[null,"VALOR DO CONTRATO",{"$f":"-(C6+C7+C19+C33+C34+C35)","v":979186378.45553911}]
[]
[null,null,null,"DEPRECIAÇÃO","ANO 1","ANO 2","ANO 3","ANO 4","ANO 5","ANO 6-20"]
[null,null,null,"Outorga",{"$f":"-$D7/20","v":3482740},{"$f":"-$D7/20","v":3482740},3482740,3482740,3482740,{"$f":"-$D7/20","v":3482740}]
[null,null,null,"Ressarcimento",{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357}]
[null,null,null,"Estacionamentos",{"$f":"(ESTACIONAMENTOS!O81+ESTACIONAMENTOS!Q81+ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K29+'VAGAS CAPEX'!K34)/ESTACIONAMENTOS!M77)/20","v":1124420.1863487465},{"$f":"E51+(CAPEX!D7-'FLUXO DE CAIXA'!E51*20)/19","v":1799244.3198494534},{"$f":"F51","v":1799244.3198494534},1799244.3198494534,1799244.3198494534,1799244.3198494534]
[null,null,null,"Edificações",{"$f":"(('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*20*EDIFICAÇÕES!C4+('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5)/20","v":117922.31999999999},{"$f":"E52+(CAPEX!D8-'FLUXO DE CAIXA'!E52*20)/19","v":217914.93052631579},217914.93052631579,217914.93052631579,217914.93052631579,217914.93052631579]
[null,null,null,"Equipamentos",{"$f":"0.33*CAPEX!D9/5","v":481667.45220000006},{"$f":"E53+0.67*CAPEX!D9/4","v":1704081.06195},{"$f":"F53","v":1704081.06195},1704081.06195,1704081.06195,{"$f":"CAPEX!D9/5","v":1459598.34}]
[null,null,null,"CCO",{"$f":"CAPEX!D10/10","v":138443.20000000001},{"$f":"E54","v":138443.20000000001},138443.20000000001,138443.20000000001,138443.20000000001,{"$f":"I54","v":138443.20000000001}]
[null,null,null,"Sistemas",{"$f":"CAPEX!D11/20","v":626000},{"$f":"E55","v":626000},626000,626000,626000,626000]
[null,null,null,"Veículos",{"$f":"CAPEX!D12/10","v":465600},{"$f":"E56","v":465600},465600,465600,465600,465600]
[null,null,null,"Comunicação",{"$f":"CAPEX!D13/20","v":260884.258},{"$f":"E57","v":260884.258},260884.258,260884.258,260884.258,260884.258]
[null,null,null,"Uniformes",{"$f":"CAPEX!D14/5","v":142843},{"$f":"E58","v":142843},142843,142843,142843,142843]
[null,null,null,"TOTAL",{"$f":"SUM(E49:E58)","v":7108129.7916175211},9105360.1453945432,9105360.1453945432,9105360.1453945432,9105360.1453945432,8860877.4234445412]
[]
[]
[]
[null,null,"TIR para percentual de Outorga 15%"]
[null,null,{"$f":"IRR(D37:X37)","v":7.1800030999807696E-2},0.2,0.21,0.22,0.23,0.24,0.25,0.26,0.27,0.28000000000000003,0.28999999999999998,0.3,0.31,0.32,0.33,0.34,0.35,0.36,0.37,0.38,0.39,0.4,0.41,0.42,0.43,0.44,0.45,0.46,0.46999999999999897,0.47999999999999898,0.48999999999999899,0.499999999999999]
[null,null,0.2,-0.1085243184464868,-7.6397288980317724E-2,-5.1149872940414398E-2,-2.9979653364707537E-2,-1.1501141912929391E-2,5.0700038629585276E-3,2.0220445141082344E-2,3.4272779630510453E-2,4.7451787122037237E-2,5.9920304849919059E-2,7.1800030999807696E-2,8.3184265231823984E-2,9.4146067357019803E-2,0.10474367984707578,0.11502424701663094,0.12502643569859995,0.13478232558071679,0.14431880094354566,0.15365859399100912,0.16282107964960502,0.17182288978818416,0.18067839404420161,0.18940008063023739,0.19799886112143317,0.20648431674697543,0.21486489915760831,0.22314809539474689,0.23134056443859019,0.23944825099228617,0.24747648088376084,0.2554300415107944]
[]
[null,null,"TIR MITIGADA",1,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]
[null,null,null,{"$f":"INDEX($D$78:$AH$108,D67,D67)","v":1.8753721298982562E-2},{"$f":"INDEX($D$78:$AH$108,E67,E67)","v":2.4677557598912658E-2},3.0430792946455787E-2,3.6028611835194679E-2,4.1484283145395873E-2,4.6809468594972481E-2,5.2014471497382919E-2,{"$f":"INDEX($D$78:$AH$108,K67,K67)","v":5.7108439165319158E-2},{"$f":"INDEX($D$78:$AH$108,L67,L67)","v":6.2099528949842497E-2},{"$f":"INDEX($D$78:$AH$108,M67,M67)","v":6.699218482311009E-2},{"$f":"INDEX($D$78:$AH$108,N67,N67)","v":7.1800030999807696E-2},{"$f":"INDEX($D$78:$AH$108,O67,O67)","v":7.6524980613510873E-2},8.1168219458040758E-2,{"$f":"INDEX($D$78:$AH$108,Q67,Q67)","v":8.5743532280658341E-2},{"$f":"INDEX($D$78:$AH$108,R67,R67)","v":9.0245706937334802E-2},{"$f":"INDEX($D$78:$AH$108,S67,S67)","v":9.4685851326989035E-2},{"$f":"INDEX($D$78:$AH$108,T67,T67)","v":9.9067385733496272E-2},{"$f":"INDEX($D$78:$AH$108,U67,U67)","v":0.10338949072681602},0.10765553702536423,{"$f":"INDEX($D$78:$AH$108,W67,W67)","v":0.11187229882470517},{"$f":"INDEX($D$78:$AH$108,X67,X67)","v":0.11604044950813486},{"$f":"INDEX($D$78:$AH$108,Y67,Y67)","v":0.12016245075633503},{"$f":"INDEX($D$78:$AH$108,Z67,Z67)","v":0.12424058430020746},{"$f":"INDEX($D$78:$AH$108,AA67,AA67)","v":0.12827696871282002},0.13227357429114228,{"$f":"INDEX($D$78:$AH$108,AC67,AC67)","v":0.13623223628310432},{"$f":"INDEX($D$78:$AH$108,AD67,AD67)","v":0.14015466667644971},{"$f":"INDEX($D$78:$AH$108,AE67,AE67)","v":0.14404246473347482},{"$f":"INDEX($D$78:$AH$108,AF67,AF67)","v":0.14789575617626016},{"$f":"INDEX($D$78:$AH$108,AG67,AG67)","v":0.15171872142593723},0.15551255819976562]
[]
[null,null,"TIR para Frustração"]
[null,null,{"$f":"IRR(D37:X37)","v":7.1800030999807696E-2},-0.36,-0.3,-0.24,-0.21,-0.18,-0.15,-0.12,-0.09,-0.06,-0.03,0,0.03,0.06,0.09,0.12,0.15,0.18,0.21,0.24,0.27,0.3,0.33,0.36,0.39,0.42,0.45,0.48,0.51,0.54,0.56999999999999995,0.6,0.65,0.7,0.9,1,1.2,1.28]
[null,null,0.2,-0.14597655791028252,-7.7464811111044085E-2,-3.4579920963286881E-2,-1.729522649373072E-2,-1.7387534696389206E-3,1.2512548933973244E-2,2.5744236341128435E-2,3.8158079562008673E-2,4.9901890645877911E-2,6.1087160445279176E-2,7.1800030999807696E-2,8.2108412684492427E-2,9.2066765262341921E-2,0.1017194067838576,0.11110286317160933,0.12024757430690869,0.12917915740566599,0.13791935895292085,0.14648678316026964,0.15489745720004344,0.16316527530909974,0.17130235169412211,0.17931930386762329,0.18722548227466329,0.19502915799672871,0.20273767740033888,0.21035759047803859,0.21789475807050485,0.22535444199879118,0.23274138126376087,0.24005985680751762,0.25211554570521466,0.26400752916573311,0.31018433299384029,0.33256927748585952,0.37619973105773741,0.39328101423303741]
[]
[null,null,"TIR MITIGADA (Frustração)",1,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,36,37]
[null,null,null,{"$f":"INDEX($D$112:$AN$148,D74,D74)","v":1.3276110123010998E-2},{"$f":"INDEX($D$112:$AN$148,E74,E74)","v":2.4455805727485513E-2},3.4751584298110982E-2,3.9716798012928711E-2,4.4572481863979219E-2,4.9326592577048078E-2,5.3986263037453686E-2,5.8557911810706909E-2,6.304733503897908E-2,6.7459784010255985E-2,7.1800030999807696E-2,7.6072425449792869E-2,8.0280942140577016E-2,8.442922268646802E-2,8.8520611436867069E-2,9.2558186665009146E-2,9.654478776834452E-2,0.10048303907804734,0.10437537077324377,0.10822403731302921,0.11203113373215912,0.11579861009131709,0.1195282843276475,0.12322185371387517,0.12688090510333772,0.13050692411240861,0.13410130337016613,0.13766534994699686,0.14120029205850848,0.14470728512815278,0.14818741728097051,0.15393070649236917,0.1596066087417618,0.18171143837556403,0.19244872362297682,0.21339355872035037,0.22185948400078015]
[]
[null,null,{"$f":"IRR(D37:X37)","v":7.1800030999807696E-2},0.2,0.21,0.22,0.23,0.24,0.25,0.26,0.27,0.28000000000000003,0.28999999999999998,0.3,0.31,0.32,0.33,0.34,0.35,0.36,0.37,0.38,0.39,0.4,0.41,0.42,0.43,0.44,0.45,0.46,0.46999999999999897,0.47999999999999898,0.48999999999999899,0.499999999999999]
[null,null,2.2745123762406425E-2,1.8753721298982562E-2,3.6875285298838545E-2,5.3590447265737584E-2,6.9220301465499512E-2,8.3988413294296516E-2,9.8056562551854576E-2,0.11154547079407773,0.1245475021897795,0.13713480385536458,0.14936472188491035,0.16128352035743143,0.17292900494254737,0.1843324174500296,0.19551983203931189,0.20651320272132412,0.21733116174327094,0.2279896366837213,0.23850233341416249,0.24888111832600446,0.2591363238795521,0.26927699506964498,0.279311089857883,0.28924564337549041,0.29908690334967503,0.30884044248082776,0.31851125221615506,0.32810382140239769,0.3376222025692901,0.34707006803498452,0.35645075759109446,0.3657673191867199]
[null,null,4.8021267745811703E-2,5.9893666914203614E-3,2.4677557598912658E-2,4.1762314131878142E-2,5.7628559223518394E-2,7.2538757098079332E-2,8.6679773962576423E-2,0.10018926066773015,0.11317143901658344,0.12570702362014785,0.13785971592148338,0.14968060175235909,0.16121121671867633,0.1724857369198618,0.18353257887844188,0.19437559040313146,0.20503495194386367,0.21552786902724774,0.22586911128028264,0.23607143702482025,0.24614593130446227,0.25610227757739246,0.26594897798437067,0.27569353332534119,0.28534259116102789,0.29490206847412104,0.30437725386099856,0.31377289313136036,0.32309326136714733,0.33234222386196621,0.34152328787686925,0.35063964677127046]
[null,null,7.1012751847794944E-2,-6.4720542785043911E-3,1.2897057613188379E-2,3.0430792946455787E-2,4.6593111505927265E-2,6.1693202223552568E-2,7.5947348810029291E-2,8.9512669318895233E-2,0.10250680027765502,0.11502001587835387,0.12712302533836595,0.13887217708224275,0.15031304168678883,0.16148294517101869,0.17241280190473485,0.18312846775527092,0.19365175691993741,0.20400121812537919,0.21419273547902495,0.22423999943238337,0.23415488009605068,0.2439477261535512,0.2536276063921683,0.26320250648255916,0.27267949050301632,0.28206483443083052,0.2913641371537139,0.30058241331351798,0.30972417136207531,0.3187934795009979,0.32779402163442573,0.33672914504373619]
[null,null,9.2015940884248235E-2,-1.8736736495939765E-2,1.441394220124792E-3,1.9508946888016743E-2,3.6028611835194679E-2,5.1366052992077638E-2,6.5772209520979175E-2,7.9426664537741054E-2,9.2462273853748611E-2,0.10498000302166388,0.1170583034512902,0.12875927664549436,0.14013286395899871,0.15121977632853478,0.16205359371665429,0.17266230202146882,0.1830694394626462,0.19329496595885098,0.20335593221486392,0.21326700148204947,0.22304086126195721,0.23268855163638791,0.24221972963030791,0.25164288392551426,0.26096551062858864,0.27019425819216858,0.27933504768664408,0.2883931732133731,0.29737338619910414,0.30627996651668776,0.31511678277057364,0.32388734361827343]
[null,null,0.11127806519672427,-3.0907364273825788E-2,-9.7735028071658236E-3,8.9203946224156727E-3,2.5861531521975234E-2,4.1484283145395873E-2,5.6080609342616938E-2,6.9856110537296345E-2,8.2960957224236465E-2,9.5508098892639115E-2,0.10758455636406494,0.11925873017218502,0.13058530234295018,0.1416086251119224,0.15236512536590441,0.16288504966672468,0.17319375600132503,0.18331268682970747,0.19326011350433747,0.2030517137072565,0.21270102494537002,0.22221980469942526,0.23161831933332389,0.24090557797605761,0.25008952342880542,0.25917718917008536,0.26817482936809189,0.27708802721806203,0.28592178573836469,0.29468060426819931,0.30336854323269957,0.31198927922175468]
[null,null,0.12900699794392304,-4.3087496643710588E-2,-2.0826407670643032E-2,-1.4033427891569916E-3,1.6027582174896304E-2,3.1984933605969434E-2,4.6809468594972481E-2,6.073702885731791E-2,7.3937538114569046E-2,8.653740794650755E-2,9.8633160971737244E-2,0.11030010464156126,0.12159806918234084,0.13257532795115989,0.14327135095371957,0.15371878556827845,0.16394491139477885,0.17397272864460001,0.18382178573095698,0.19350881774139594,0.2030482454449305,0.21245256987721306,0.22173268765888388,0.23089814538450759,0.23995734663914403,0.24891772179575189,0.25778586828848526,0.26656766725839565,0.2752683811361758,0.28389273572911233,0.29244498962453691,0.30092899314520571]
[null,null,0.14537878704837828,-5.5386311860067816E-2,-3.1793536723972116E-2,-1.1525030101239953E-2,6.4696696611119542E-3,2.2813076736088345E-2,3.7904302213253471E-2,5.2014471497382919E-2,6.5336106599454435E-2,7.801077416972424E-2,9.0145550420694054E-2,0.10182332681155115,0.11310953080980024,0.12405666232388901,0.13470744681606162,0.14509708296495694,0.15525488048983438,0.16520547684671549,0.17496975663148562,0.18456555695806109,0.19400821603144736,0.20331100500941757,0.21248547174480259,0.22154171712625592,0.2304886192499318,0.23933401677187272,0.24808486000233465,0.2567473362734316,0.26532697461541743,0.27382873366153437,0.28225707586076743,0.29061603043803119]
[null,null,0.16054352120300697,-6.7924251528350466E-2,-4.2751215997600345E-2,-2.1503598125188761E-2,-2.8637672964130223E-3,1.392019950318657E-2,2.9317587513864041E-2,4.3640851062479724E-2,5.7108439165319158E-2,6.987901600364288E-2,8.2071399081905749E-2,9.377681839026053E-2,0.10506679347358561,0.1159983841531933,0.12661780115006693,0.13696295605495745,0.14706530439066134,0.15695120500151982,0.16664294078256225,0.17615949738177705,0.1855171657463659,0.19473001433415948,0.20381026345178066,0.21276858510017194,0.22161434542294778,0.23035580243077636,0.23900026851627687,0.24755424498626732,0.25602353416012447,0.26441333333740391,0.27272831400308095,0.28097268892998928]
[null,null,0.17462994454448733,-8.0840318849888182E-2,-5.3778696323931396E-2,-3.1395842352461178E-2,-1.2020142978705461E-2,5.2628982258269286E-3,2.1007462928631426E-2,3.5574615794360387E-2,4.9212639515151313E-2,6.2099528949842497E-2,7.4367185646781575E-2,8.6116019442747493E-2,9.7424187363390091E-2,0.1083536729643988,0.11895442088654473,0.12926722917870026,0.1393258225258458,0.14915837028608436,0.15878861900754093,0.16823675146227779,0.17752004794799925,0.18665340216668902,0.19564972849324547,0.20452028698935742,0.21327494532690872,0.22192239175573092,0.23047030967776361,0.2389255218152333,0.24729411008087521,0.25558151586914524,0.26379262444915708,0.2719318363559482]
[null,null,0.18775414196406215,-9.4307661022020817E-2,-6.4965844185457366E-2,-4.1261961033326466E-2,-2.1047474889406281E-2,-3.2015141637773414E-3,1.2933521586073971E-2,2.777614695284969E-2,4.1609093424782362E-2,5.4632268773979975E-2,6.699218482311009E-2,7.8799374253647692E-2,9.013923587948236E-2,0.10107907623788193,0.11167284454474125,0.12196441287972437,0.13198990759391971,0.14177940375114662,0.15135818097923148,0.16074767051414351,0.16996618046506873,0.17902945895427802,0.1879511368345741,0.19674307965988569,0.20541567036862718,0.21397803842741636,0.22243824714731764,0.23080344799164831,0.23908000859197709,0.24727361964195538,0.25538938468708583,0.26343189596209582]
[null,null,0.2,-0.1085243184464868,-7.6397288980317724E-2,-5.1149872940414398E-2,-2.9979653364707537E-2,-1.1501141912929391E-2,5.0700038629585276E-3,2.0220445141082344E-2,3.4272779630510453E-2,4.7451787122037237E-2,5.9920304849919059E-2,7.1800030999807696E-2,8.3184265231823984E-2,9.4146067357019803E-2,0.10474367984707578,0.11502424701663094,0.12502643569859995,0.13478232558071679,0.14431880094354566,0.15365859399100912,0.16282107964960502,0.17182288978818416,0.18067839404420161,0.18940008063023739,0.19799886112143317,0.20648431674697543,0.21486489915760831,0.22314809539474689,0.23134056443859019,0.23944825099228617,0.24747648088376084,0.2554300415107944]
[null,null,0.21145862420453823,-0.12377445962512823,-8.8189433221364411E-2,-6.1125108474122558E-2,-3.8863108961965875E-2,-1.9674326362547845E-2,-2.6178352761132562E-3,1.2874301272562727E-2,2.7170994182092567E-2,4.0525333829451338E-2,5.3118438747838947E-2,6.5084343776755871E-2,7.6524980613510873E-2,8.7519634896215504E-2,9.8131156714201584E-2,0.10841017692650046,0.11839805204106102,0.12812897213036423,0.13763150229903953,0.14692973135870968,0.15604414221832807,0.16499228131242316,0.17378928039823904,0.18244826821213045,0.19098069879695578,0.19939661597692382,0.20770486833081558,0.21591328537680576,0.22402882306312688,0.23205768474832844,0.24000542244413059,0.24787702204036433]
[null,null,0.22221050784824262,-0.14045010989457984,-0.10048352683514861,-7.1259934018395699E-2,-4.7745561416283389E-2,-2.7758630716993249E-2,-1.0163012197664023E-2,5.706753821937971E-3,2.027361100648406E-2,3.3822975718501569E-2,4.6556487414003422E-2,5.8621837795941545E-2,7.0130404468708996E-2,8.1168219458040758E-2,9.1803083822935783E-2,0.10208934738778819,0.11207121718418955,0.12178510712659452,0.13126134451085503,0.14052543396915684,0.14959901005145637,0.15850056633516174,0.16724602127889221,0.17584916289117114,0.18432200213436656,0.19267505668822116,0.20091758093248147,0.20905775393729664,0.21710283433289557,0.22505928881112847,0.23293289945304552,0.24072885391721055]
[null,null,0.23230525173374891,-0.15907298979581097,-0.11342742934198868,-8.1613159398404966E-2,-5.6657423090078929E-2,-3.5773824016245181E-2,-1.7581012799116946E-2,-1.2960079023781601E-3,1.356732114333048E-2,2.7331343134334274E-2,4.0220740274538036E-2,5.2398319902800639E-2,6.3985790662873354E-2,7.5076489447681416E-2,8.5743532280658341E-2,9.6045231736326508E-2,0.10602881245429208,0.11573302898671445,0.12519005386303705,0.1344268674598097,0.14346629977693093,0.15232782393851152,0.1610281693294584,0.16958180152289781,0.17800130234767564,0.18629767407616327,0.19448058523803291,0.20255857101673502,0.21053919794073961,0.21842920023487911,0.22623459347800279,0.2339607699388131]
[null,null,0.24181593712942639,{"$error":"#NUM!"},-0.12725463415710903,-9.2285446795144055E-2,-6.5658101427913618E-2,-4.3763365549102318E-2,-2.4908254783668093E-2,-8.1670597026443081E-3,7.0206565492341166E-3,2.1019684289931284E-2,3.4080668674896231E-2,4.6383195080751172E-2,5.8060299300335183E-2,6.9213245413559887E-2,7.9920866874432228E-2,9.0245706937334802E-2,0.10023819064229311,0.10993954052630284,0.11938386468737439,0.12859968433975166,0.13761107248929272,0.14643851697963806,0.15509958442697891,0.16360943784534965,0.17198124509607604,0.1802265047269449,0.18835530850392779,0.19637655486140582,0.20429812389238111,0.2121270219043534,0.21986950167244501,0.22753116312247235]
[null,null,0.25078146237734977,{"$error":"#NUM!"},-0.14223271258480508,-0.10336398825750315,-7.4785807562642415E-2,-5.1748645079984334E-2,-3.2159559788775494E-2,-1.4918539649060869E-2,6.2250740385771941E-4,1.4877152355404988E-2,2.8125315028216136E-2,4.0565206496031347E-2,5.2342278479019733E-2,6.3566392902220104E-2,7.4322529108495683E-2,8.4677743213758649E-2,9.4685851326989035E-2,0.10439067563913729,0.11382835245287182,0.12302901004961142,0.13201801245681266,0.14081689747726323,0.14944409510443446,0.15791548538408628,0.16624483702341464,0.17444415614420317,0.18252396644046875,0.19049353634257926,0.19836106479103499,0.20613383435559474,0.21381833835131503,0.22142038706945688]
[null,null,0.25924739308218508,{"$error":"#NUM!"},-0.15875080019720944,-0.1149695357624948,-8.4094394183859222E-2,-5.9761340508598715E-2,-3.9357908559192856E-2,-2.1569691619063414E-2,-5.6447295463262215E-3,8.8868055504065513E-3,2.2337906175751154E-2,3.4927487084020825E-2,4.6814621299331227E-2,5.8118501536555289E-2,6.8930716262170622E-2,7.932313678003422E-2,8.9353172972287842E-2,9.9067385733496272E-2,0.10850403683239263,0.11769493079718285,0.12666677259936621,0.13544218648313544,0.14404049277646402,0.15247830867331724,0.16077001887340825,0.16892814857254002,0.1769636621942452,0.18488620495494601,0.19270429992440774,0.20042551007974119,0.20805657256096888,0.21560351065700445]
[null,null,0.26726053564769242,{"$error":"#NUM!"},-0.17737986772529446,-0.12726298050603602,-9.3652442196252905E-2,-6.7840971295006547E-2,-4.6531597636176203E-2,-2.8143908261861861E-2,-1.1802162524442661E-2,3.0286023548296015E-3,1.6698849561101348E-2,2.9450557561121027E-2,4.1457768912680271E-2,5.2849816970204078E-2,6.3725406134122142E-2,7.4161551019906291E-2,8.4219473855057458E-2,9.3948623384374708E-2,0.10338949072681602,0.11257563030124751,0.12153514102980312,0.13029177225832456,0.13886576317457111,0.14727448938500243,0.1555329675802557,0.16365425416895407,0.17164976358813355,0.17952952499608643,0.18730239115063285,0.19497620978991237,0.20255796531905279,0.21005389676968456]
[null,null,0.27485626731799995,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14044026794834619,-0.10353125786572082,-7.6023067212697804E-2,-5.3703252789303546E-2,-3.4658485707283582E-2,-1.7864729897842158E-2,-2.71135269450129E-3,1.1194657081865511E-2,2.4121008768974939E-2,3.6258212527474409E-2,4.7746629880584424E-2,5.869263028340943E-2,6.9178723793293262E-2,7.9270177650181406E-2,8.901948611322541E-2,9.846947880962964E-2,0.10765553702536423,0.11660720878070863,0.12534940857605426,0.1339033238972327,0.14228711062710064,0.15051643383678748,0.15860489353668905,0.16656436361455484,0.17440526441194826,0.18213678397125954,0.18976705914878744,0.19730332503355963,0.2047520391055857]
[null,null,0.28206080841037101,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15474860424368453,-0.11380718477159057,-8.4339759218982291E-2,-6.0890265393833243E-2,-4.1125134735578217E-2,-2.3841804882310913E-2,-8.3414931399551362E-3,5.8171969653373345E-3,1.8930701472436917E-2,3.120764966104117E-2,4.2800394701405287E-2,5.3823559523561659E-2,6.4365522772505956E-2,7.4495840861044105E-2,8.4270217587241403E-2,9.3733933761808386E-2,0.1029242764235121,0.11187229882470517,0.12060412112556773,0.12914190869117337,0.13750461950968895,0.145708583287254,0.15376795583613356,0.16169507971680996,0.16950077347022696,0.17719456579390713,0.18478488679815652,0.19227922546096421,0.1996842602115898]
[null,null,0.28890626460282892,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.17054263799121283,-0.12458604140277985,-9.2837144261445514E-2,-6.8119361377285026E-2,-4.7563021330911615E-2,-2.9749259156341301E-2,-1.387617967672905E-2,5.5278973557593147E-4,1.386621860347903E-2,2.6292700363062416E-2,3.7997641090386614E-2,4.910455793711388E-2,5.9708100658160346E-2,6.9882376178529659E-2,7.9686472267513908E-2,8.916824009979285E-2,9.8366955533434552E-2,0.10731523594201997,0.11604044950813486,0.12456577033515148,0.13291098124063416,0.14109309345708798,0.14912683125746984,0.15702501543042824,0.16479886997586402,0.17245826979466683,0.18001194251566743,0.1874676343024233,0.19483224709731428]
[null,null,0.29541882911852863,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.13599409489566316,-0.10156375224093916,-7.5415682212006119E-2,-5.3988640774990659E-2,-3.5599976912138342E-2,-1.9326698356858074E-2,-4.6091531618347448E-3,8.9172311115859326E-3,2.1503068228648559E-2,3.3327982020586511E-2,4.4525078458995004E-2,5.5195710273901799E-2,6.5418812862686471E-2,7.525704212202311E-2,8.4760944616050216E-2,9.3971871682739128E-2,0.10292406595799219,0.11164618744183508,0.12016245075633503,0.12849348686904372,0.13665700581657036,0.14466831323961915,0.15254071786639378,0.16028585650872018,0.16791395586942692,0.17543404538067087,0.18285413168721165,0.19018134279221965]
[null,null,0.30162220812192458,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14819107392452235,-0.1105755211475602,-8.2806124043527718E-2,-6.0418626729778158E-2,-4.1406416964039017E-2,-2.4703678178549349E-2,-9.6784515808893135E-3,4.0742423417652329E-3,1.682933227421235E-2,2.8781939452042105E-2,4.0075512021892301E-2,5.0818569149402526E-2,6.109517035705414E-2,7.0971734071275216E-2,8.0501633374064685E-2,8.9728385465368099E-2,9.868792169846774E-2,0.10741023914751646,0.11592062566807648,0.12424058430020746,0.13238854155097624,0.14038039758540521,0.14822995894005864,0.155949282687178,0.16354895298343042,0.17103830537324471,0.1784256102818973,0.18571822431016471]
[null,null,0.30753790905849643,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.16138337532330649,-0.11993807922561006,-9.031992020438051E-2,-6.6869976381014551E-2,-4.7180746254206318E-2,-3.001719867103092E-2,-1.4664257384584323E-2,-6.715119864366681E-4,1.2262845426449065E-2,2.4350840524468786E-2,3.5747081151118909E-2,4.6567750411988795E-2,5.6902346451122687E-2,6.6821255428868298E-2,7.6380814448396839E-2,8.5626800808502823E-2,9.4596900413277618E-2,0.10332249415933847,0.11182997679795048,0.12014174797110577,0.12827696871282002,0.13625214711894218,0.14408159756109495,0.15177780491702086,0.15935171650431079,0.16681297831544062,0.17417012786265373,0.18143075287442012]
[null,null,0.3131854897887868,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.17584332670665093,-0.1297297644831954,-9.7989338407857063E-2,-7.3360290959445851E-2,-5.2934968258848247E-2,-3.5276887130366696E-2,-1.9575143085330371E-2,-5.3281509468241506E-3,7.7956463729498271E-3,2.0026727530904731E-2,3.1531747727191028E-2,4.2435088218388595E-2,5.2832020347038489E-2,6.2797114604217885E-2,7.2389816279342156E-2,8.1658261001356758E-2,9.0641957503950765E-2,9.9373718777096665E-2,0.10788108109053307,0.11618736582922118,0.12431248700178887,0.13227357429114228,0.14008546008829059,0.1477610647183969,0.15531170442322395,0.16274734000764668,0.17007677938694066,0.17730784394376209]
[null,null,0.31858277459822065,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14004568278268714,-0.10585053230641339,-7.9908039624810634E-2,-5.8681049346959835E-2,-4.0492007663186946E-2,-2.4419180422239228E-2,-9.9032247344648106E-3,3.420382717169046E-3,1.5802279562086907E-2,2.742213275130867E-2,3.8413095507435768E-2,4.887656835775922E-2,5.8891534741864371E-2,6.8520699264711382E-2,7.7814658257324698E-2,8.681481407686098E-2,9.5555461632049976E-2,0.1040653143078627,0.11236864098947397,0.12048612749967447,0.1284355390137073,0.13623223628310432,0.1438895828188167,0.15141926960646401,0.15883157665725411,0.16613558561687691,0.17333935404739731]
[null,null,0.32374604210944419,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15100323683077099,-0.11394460001246343,-8.6532856074250319E-2,-6.4431046093654576E-2,-4.5671543920767554E-2,-2.9204010558763427E-2,-1.4403781827069251E-2,-8.6975626868868172E-4,1.1670744071938799E-2,2.3411446318802209E-2,3.4494892233450258E-2,4.5028990351586584E-2,5.5097378368193839E-2,6.4766178616171066E-2,7.4088554794236261E-2,8.3107876264545855E-2,9.1859971267602258E-2,0.10037476688814539,0.10867750588962433,0.11678966514094591,0.12472965946302628,0.13251338846463301,0.14015466667644971,0.14766556570381661,0.15505668918820503,0.16233739584549256,0.16951598194277362]
[null,null,0.32869018927061783,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.16274974362049177,-0.12231892017593105,-9.3255879178872347E-2,-7.019723662204358E-2,-5.0824277201357959E-2,-3.3936907325923138E-2,-1.8836428378333103E-2,-5.0810987147157372E-3,7.6258769072004018E-3,1.9493426305876582E-2,3.0674142547692407E-2,4.1282845372927701E-2,5.1408081438428566E-2,6.1119556836595645E-2,7.0473113753325434E-2,7.9514164600529513E-2,8.8280123985417625E-2,9.680217027905802E-2,0.10510654712673251,0.11321554206823814,0.12114823397034913,0.12892107194983371,0.13654832948540041,0.14404246473347482,0.15141440941967699,0.15867380268281139,0.16582918202216379]
[null,null,0.33343071405345642,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.17547827198941768,-0.13103238824695274,-0.10010289167597775,-7.5994563557815864E-2,-5.5960894103291858E-2,-3.8626684785061816E-2,-2.3209102016797378E-2,-9.2211688131140779E-3,3.6603337534792946E-3,1.5660782535303897E-2,2.6943539020447105E-2,3.7630766371069546E-2,4.7816191174894662E-2,5.7573278813695117E-2,6.6960666832570181E-2,7.6025890336768986E-2,8.4808005654148921E-2,9.3339481564455706E-2,0.10164759064191542,0.10975545144846111,0.11768282181435907,0.12544671139170815,0.13306186081507199,0.14054112093461835,0.14789575617626016,0.15513568958076518,0.16226970250614503]
[null,null,0.33797641073873125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14014369445784758,-0.10709389765292243,-8.1831585661734652E-2,-6.1085927190260403E-2,-4.3276335966792367E-2,-2.7524214051935503E-2,-1.3292200955668743E-2,-2.2812414059891761E-4,1.1911188578006104E-2,2.330062973082514E-2,3.4070160108075287E-2,4.4318968056338282E-2,5.4124459147061321E-2,6.3548185739900509E-2,7.2639886419585409E-2,8.1440314982613948E-2,8.9983269749603467E-2,9.8297080091080291E-2,0.10640571567761103,0.11432962792676027,0.12208639775962626,0.12969124089549089,0.13715740676305632,0.14449649686992894,0.15171872142593723,0.1588331080837535]
[null,null,0.3423390471701418,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.1497309836719608,-0.11425707726851875,-8.7722067308056983E-2,-6.620800171750052E-2,-4.7892401537978246E-2,-3.1787401914273539E-2,-1.7299441876649668E-2,-4.0445947928905435E-3,8.2395734327220804E-3,1.9740306520454665E-2,3.0595846242056579E-2,4.0911139996980816E-2,5.0767722964183415E-2,6.0230186606948344E-2,6.935055658550926E-2,7.817134157751493E-2,8.6727709576716272E-2,9.504907522388728E-2,0.10316027975430697,0.11108248302146118,0.11883384808450925,0.12643007375597226,0.13388481397256147,0.14121001172758807,0.14841616767565879,0.15551255819976562]
[]
[]
[null,null,{"$f":"IRR(D37:X37)","v":7.1800030999807696E-2},-0.36,-0.3,-0.24,-0.21,-0.18,-0.15,-0.12,-0.09,-0.06,-0.03,0,0.03,0.06,0.09,0.12,0.15,0.18,0.21,0.24,0.27,0.3,0.33,0.36,0.39,0.42,0.45,0.48,0.51,0.54,0.56999999999999995,0.6,0.65,0.7,0.9,1,1.2,1.28]
[null,null,0,1.3276110123010998E-2,4.6643127487679736E-2,7.5749344359739013E-2,8.9207692062041044E-2,0.10210250028391221,0.11452229634951472,0.12653653024483713,0.13820062254498189,0.14955944744377891,0.16064980007041707,0.17150218461051381,0.18214213630376608,0.1925912161490928,0.20286777109038012,0.21298752308753821,0.22296403128776521,0.23280905869510327,0.24253286600507451,0.25214444921537615,0.26165173335405667,0.27106173161087566,0.2803806769401096,0.28961413157319926,0.29876707866737262,0.30784399940467977,0.31684893816313409,0.3257855578501776,0.33465718707723946,0.34346686053293474,0.35221735365965645,0.36091121253790237,0.37528140334993099,0.38951047634124802,0.44517400991327594,0.47234320971570365,0.52555175123337028,0.54645641922362231]
[null,null,4.7107142857142834E-2,-1.0988040964450274E-2,2.4455805727485513E-2,5.4497265769308578E-2,6.8186353083082407E-2,8.120570621580292E-2,9.3667981980004589E-2,0.10566000570438261,0.11725004680506834,0.1284927000594982,0.13943226099273276,0.15010512135878029,0.16054150796937083,0.17076677005825802,0.18080234916300864,0.19066652122267103,0.20037497229190948,0.20994125074693071,0.21937712646500596,0.22869287900409629,0.23789753093724575,0.246999038351986,0.25600444755606344,0.26492002487467081,0.27375136483856766,0.28250348088243094,0.29118088178500434,0.29978763640788952,0.3083274287721165,0.31680360511082495,0.32521921422347932,0.33357704221081375,0.34738519391434797,0.36105044174030576,0.41445229819571727,0.44049208088145519,0.49145273874689654,0.51146339449032086]
[null,null,8.7342105263157915E-2,-3.5048773932687349E-2,3.3388468888941869E-3,3.4751584298110982E-2,4.8823267199006093E-2,6.2094631906846942E-2,7.4710118794293789E-2,8.6778799386034722E-2,9.8384999086841951E-2,0.10959520684553414,0.12046272883715692,0.13103091692555258,0.14133546622220439,0.15140608682799628,0.16126774412554035,0.17094159494243066,0.1804457050606314,0.18979560672396412,0.19900473718707112,0.20808478753987347,0.21704598296705058,0.22589730998359103,0.23464670221492745,0.24330119343989831,0.25186704454195752,0.26034984948768969,0.26875462431466879,0.27708588225451014,0.28534769746577493,0.29354375935139476,0.30167741904801471,0.30975172937217255,0.32308449391002525,0.33627156973610739,0.38774608286869561,0.4128196154548851,0.4618528090623979,0.48109584930880289]
[null,null,0.10516772151898734,-4.7129617141466573E-2,-6.8752500189614985E-3,2.5397317527148244E-2,3.9716798012928711E-2,5.3160046511729231E-2,6.5890982752152993E-2,7.8032009762929899E-2,8.9676893351263942E-2,0.10089900216437298,0.11175678038334036,0.12229749922969102,0.13255989925095624,0.14257609557221484,0.15237298021140111,0.16197327308473231,0.17139632248158687,0.18065872354624646,0.18977480234250521,0.19875699914151124,0.20761617511998676,0.21636186012537628,0.22500245457739854,0.23354539530420615,0.24199729274569104,0.25036404522355071,0.25865093469309963,0.26686270742890295,0.27500364236707275,0.28307760926945136,0.29108811844462945,0.29903836342593193,0.31216265137555754,0.32513954262406797,0.37576331508805483,0.40040886260796249,0.44858657815460545,0.4674884924214282]
[null,null,0.12168902439024389,-5.938726043789011E-2,-1.6940246882739873E-2,1.6320545336568237E-2,3.0926783708637551E-2,4.4572481863979219E-2,5.7444000544165874E-2,6.9678853965297272E-2,8.1381364054487371E-2,9.2632503606111527E-2,0.10349633927972635,0.11402439388401908,0.12425868622316982,0.13423390272904179,0.14397898283775978,0.15351829864028277,0.16287254757810499,0.17205943822544079,0.1810942242673399,0.18999012535419024,0.19875866245741358,0.2074099277689565,0.21595280389671445,0.22439514335809929,0.23274391667735461,0.24100533542714619,0.24918495510529892,0.257287761655832,0.26531824462776443,0.27328045934388601,0.28117807997416722,0.28901444503818796,0.30194707251058883,0.31473040984892986,0.36456838286892368,0.38881762579312373,0.43620200289315614,0.45478727063835445]
[null,null,0.13704411764705879,-7.1945387819909667E-2,-2.6913364612417667E-2,7.4767244076894279E-3,2.2410359408704394E-2,3.6289548543227301E-2,4.9326592577048078E-2,6.1676178062239684E-2,7.3454454300384775E-2,8.4750812532092379E-2,9.5635480240895188E-2,0.10616459738221362,0.11638371500627875,0.12633027087139026,0.13603538167997331,0.14552516683659955,0.15482174364466772,0.16394398736393678,0.17290811992011479,0.18172817170725053,0.19041634800731733,0.19898332275798247,0.20743847630494527,0.21579008948175482,0.22404550328991157,0.23221125122644981,0.24029316967226766,0.24829649054077207,0.25622591947501872,0.26408570219016902,0.27187968102862792,0.27961134338616667,0.29236746069240693,0.30497222573060623,0.35408288153250345,0.37796433532071494,0.4246112739290111,0.44290190465745671]
[null,null,0.15135227272727267,-8.4949994233216364E-2,-3.6851281567098937E-2,-1.1747451204842108E-3,1.4129204706668341E-2,2.8273785342033841E-2,4.1501387338974904E-2,5.3986263037453686E-2,6.5857840151581692E-2,7.7214844680225658E-2,8.8134263513673483E-2,9.8677256098661736E-2,0.10889318283073424,0.11882242768114226,0.12849842421678415,0.13794914078382359,0.14719818961820286,0.1562656688623747,0.16516881127843175,0.17392249067682553,0.18253962200477791,0.19103148085146793,0.19940796111413439,0.20767778465923969,0.21584867332171953,0.22392749106774112,0.23192036230700763,0.23983277098047573,0.24766964403227165,0.25543542210608416,0.26313411971995815,0.27076937672197854,0.28336268094446315,0.2958024173314624,0.34423861273839229,0.3677780401894486,0.41373802003366134,0.43175387969491341]
[null,null,0.16471703296703302,-9.8580888288878787E-2,-4.6811806465299366E-2,-9.6714453445995163E-3,6.0486711948779526E-3,2.0491793567995797E-2,3.393534412560939E-2,4.6575928335269579E-2,5.8557911810706909E-2,6.9990387720038738E-2,8.0957768417800891E-2,9.152667583320695E-2,0.10175058204674192,0.11167302820996294,0.12132991481866706,0.13075116771818385,0.13996197379410646,0.1489837134080616,0.15783467487827796,0.16653060953166099,0.17508516827660214,0.18351024885671152,0.19181627488504271,0.20001242214986448,0.20810680371790569,0.21610662251652846,0.22401829800811379,0.23184757204748285,0.2395995978794756,0.24727901538053843,0.25489001499956254,0.2624363923555415,0.27487930645346559,0.28716629759950529,0.33497596463237933,0.35819672186804929,0.40351548921831504,0.42127457355473807]
[null,null,0.17722872340425525,-0.11306897807859773,-5.6855708853987497E-2,-1.8048748097771905E-2,-1.8629481119554203E-3,1.2913524751263727E-2,2.6599036497193973E-2,3.9415801869820744E-2,5.1525026316165512E-2,6.304733503897908E-2,7.4075307640553811E-2,8.4681516500484166E-2,9.4923875314623318E-2,0.10484931077858217,0.11449635160704874,0.12389699708550994,0.13307809339616838,0.14206236578296405,0.15086920509695934,0.15951527581095615,0.16801499211628768,0.17638089508575527,0.18462395463202097,0.19275381359163846,0.20077898676672024,0.20870702454625878,0.21654464840654031,0.22429786388797934,0.23197205538352916,0.23957206612756665,0.24710226605745911,0.25456660967202538,0.26687043438206892,0.27901585407391338,0.32624259269607614,0.3491659213881686,0.39388506843120585,0.41140373339200798]
[null,null,0.18896649484536085,-0.12872346865678153,-6.7048850902692858E-2,-2.6340543175766062E-2,-9.6350422706342753E-3,5.5116874391192283E-3,1.9466061643593768E-2,3.2479720877859553E-2,4.4732895255350513E-2,5.6359058370573978E-2,6.7459784010255985E-2,7.8114132816044179E-2,8.8384820222193961E-2,9.832240566212902E-2,0.10796821939763412,0.1173564579533819,0.12651571667233985,0.13547013185294632,0.14424024623597487,0.15284367468887483,0.16129562310480106,0.16960929779326683,0.17779623202507477,0.18586654910118439,0.19382917621808393,0.20169201978408569,0.20946211023571881,0.21714572250273223,0.2247484768666641,0.23227542390978018,0.23973111646018541,0.2471196708361767,0.25929471428150608,0.27130875510527952,0.31799233781230241,0.34063761353162714,0.38479507014581871,0.40208822729394766]
[null,null,0.2,-0.14597655791028252,-7.7464811111044085E-2,-3.4579920963286881E-2,-1.729522649373072E-2,-1.7387534696389206E-3,1.2512548933973244E-2,2.5744236341128435E-2,3.8158079562008673E-2,4.9901890645877911E-2,6.1087160445279176E-2,7.1800030999807696E-2,8.2108412684492427E-2,9.2066765262341921E-2,0.1017194067838576,0.11110286317160933,0.12024757430690869,0.12917915740566599,0.13791935895292085,0.14648678316026964,0.15489745720004344,0.16316527530909974,0.17130235169412211,0.17931930386762329,0.18722548227466329,0.19502915799672871,0.20273767740033888,0.21035759047803859,0.21789475807050485,0.22535444199879118,0.23274138126376087,0.24005985680751762,0.25211554570521466,0.26400752916573311,0.31018433299384029,0.33256927748585952,0.37619973105773741,0.39328101423303741]
[null,null,0.21039077669902914,-0.16546000656003823,-8.8188269055591961E-2,-4.2799840599146877E-2,-2.4869829502565999E-2,-8.8610057037116219E-3,5.7167469245711366E-3,1.9188199901091885E-2,3.1779569830454601E-2,4.3654696973103535E-2,5.4936020450306433E-2,6.5717418340622613E-2,7.6072425449792869E-2,8.6059691579336128E-2,9.5726722669981834E-2,0.10511251509465303,0.11424945447309787,0.12316471267692131,0.13188129440247498,0.14041883393159282,0.14879421050579889,0.15702202980541524,0.16511500510606569,0.17308426224295825,0.180939585990608,0.18868962088453478,0.1963420362449475,0.20390366280070471,0.2113806065823125,0.21877834447110756,0.22610180483157216,0.23335543592697228,0.24530041150019954,0.25707888293980008,0.30278226130450725,0.32492312490738184,0.36805838064339813,0.38494028886951193]
[null,null,0.22019339622641509,{"$error":"#NUM!"},-9.9319549255717066E-2,-5.103381476841462E-2,-3.2384343479784583E-2,-1.5876823591873479E-2,-9.4132742981523077E-4,1.279241683110155E-2,2.5578435355395612E-2,3.7598516547796557E-2,4.8987201545017012E-2,5.9846827591763185E-2,7.0257023272253694E-2,8.0280942140577016E-2,8.9969493015420454E-2,9.9364293237588663E-2,0.10849978151312789,0.11740476217264506,0.12610355531785089,0.13461686787596738,0.14296246320953032,0.15115568282034242,0.15920985777104768,0.16713663672104451,0.17494625010673448,0.18264772484985592,0.19024906032618083,0.19775737369870772,0.20517902080287942,0.21251969735658838,0.21978452421159256,0.22697811956627767,0.23882032066138392,0.25049313147376706,0.29575373580682274,0.31766545499923704,0.36033474672274846,0.37702876735828017]
[null,null,0.22945642201834865,{"$error":"#NUM!"},-0.11098093429572253,-5.9316644725565859E-2,-3.9863853937281646E-2,-2.2806840672193629E-2,-7.4801902618243377E-3,6.5393521364383034E-3,1.9537528720075414E-2,3.1716262004846785E-2,4.3223487808826233E-2,5.417080205230218E-2,6.4644440281279802E-2,7.4712399597504975E-2,8.442922268646802E-2,9.3839308452591919E-2,0.10297926252811163,0.11187960376838202,0.12056602771757374,0.12906035844332919,0.13738127678855649,0.14554488534850218,0.15356515230073575,0.16145426404190144,0.16922290827388498,0.17688050340724759,0.1844353860724548,0.19189496560805974,0.19926585227344784,0.20655396437373708,0.21376461832404692,0.22090260480795121,0.2326493402439529,0.24422371940493415,0.28906977865356986,0.31076611276262267,0.35299637226544456,0.36951308763036628]
[null,null,0.2382232142857143,{"$error":"#NUM!"},-0.12332570978159396,-6.7685244642017306E-2,-4.7333465957960397E-2,-2.9670872414377047E-2,-1.3917153354783718E-2,4.1287951808555157E-4,1.3641235511805627E-2,2.5992465555431554E-2,3.7629350627019331E-2,4.8673630158227787E-2,5.9218708112114493E-2,6.9337793298881678E-2,7.9089310473352548E-2,8.8520611436867069E-2,9.7670589445559841E-2,0.10657156441434967,0.11525067032907943,0.12373089488323141,0.1320318711106192,0.14017048889476813,0.1481613734870364,0.15601726436314611,0.16374931838071594,0.17136735472707132,0.17888005459869438,0.18629512530990056,0.19361943618245969,0.2008591318496058,0.20801972733434049,0.21510618830767281,0.22676420011374243,0.23824681667854986,0.28270438123559627,0.30419803158350134,0.34601412309304691,0.36236330319678678]
[null,null,0.24653260869565216,{"$error":"#NUM!"},-0.13655149684197987,-7.6179603645795346E-2,-5.4818743513459611E-2,-3.6488199055372816E-2,-2.0268556269006921E-2,-5.6019350253849742E-3,7.8752608614982567E-3,2.0413063430639422E-2,3.2190728957460779E-2,4.3341120693640045E-2,5.3965425699770364E-2,6.4142463537540051E-2,7.3934807767237043E-2,8.3392945867988733E-2,9.2558186665009146E-2,0.10146474235406711,0.11014125144722331,0.11861191381084457,0.12689735077385622,0.13501526665255659,0.14298096438030572,0.15080775229667887,0.15850726860417041,0.16608974275173849,0.17356420793699701,0.180938675320923,0.18822027795784546,0.19541539055289903,0.20252972976290162,0.20956843871389874,0.22114395761579653,0.23254097553770015,0.27663413098780532,0.29793684516173724,0.33936177029165648,0.35555245381101841]
[null,null,0.2544194915254237,{"$error":"#NUM!"},-0.15092043419976098,-8.4843948350757037E-2,-6.2346179959523962E-2,-4.3277837645903205E-2,-2.6549975104397827E-2,-1.1519021617569569E-2,2.2264461414236436E-3,1.4965211841641235E-2,2.6894842169245647E-2,3.8160411506128256E-2,4.8871563452395739E-2,5.9113161020475591E-2,6.8952213283579145E-2,7.8442538392280214E-2,8.7627996349253001E-2,9.654478776834452E-2,0.10522312498604602,0.11368847072305543,0.12196247214344158,0.13006367611581426,0.1380080845295184,0.14580959082753453,0.15348032705499093,0.16103094261323991,0.16847083026885112,0.17580831098027261,0.18305078624594429,0.19020486459966057,0.19727646734985882,0.2042709175213222,0.21576971180241289,0.22708683819223086,0.27083789331638242,0.29196055677240684,0.33301563437448878,0.349056199648621]
[null,null,0.26191528925619828,{"$error":"#NUM!"},-0.16679046945090603,-9.3728190447985194E-2,-6.9943720542432808E-2,-5.0058812010593146E-2,-3.2776413937810722E-2,-1.7351472399825929E-2,-3.3173895707407919E-3,9.6371289830288198E-3,2.1730029857076172E-2,3.3119805995940332E-2,4.3925295937561781E-2,5.4237875560696258E-2,6.4129297697169685E-2,7.3656919200652426E-2,8.286729496687939E-2,9.1798715323666569E-2,0.10048303907804734,0.10894704469585403,0.11721344419455137,0.12530165611422528,0.13322840325497398,0.14100818086760269,0.14865362765401824,0.15617582287151377,0.16358452656292766,0.17088837552195146,0.17809504445154767,0.18521137949184729,0.1922435096209445,0.19919694019087331,0.21062435886417163,0.2218668866211968,0.26529653934515873,0.28624925617769104,0.32695428075126109,0.34285250825552582]
[null,null,0.2690483870967742,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.10288977648679365,-7.764136213865358E-2,-5.6850429413449421E-2,-3.8962484243788453E-2,-2.3111689429286097E-2,-8.7675876576364109E-3,4.4179586393591208E-3,1.6685614097846635E-2,2.8208632737868777E-2,3.9115858329719089E-2,4.9505689128745978E-2,5.9454953217880968E-2,6.9024768113811863E-2,7.8264535902673682E-2,8.7214743337880041E-2,9.5908971831809131E-2,0.10437537077324377,0.11263775757261651,0.12071645258450525,0.12862892216938504,0.13639028056397651,0.14401368626377331,0.1515106585036039,0.15889133245446296,0.16616466687533116,0.17333861448868793,0.18042026284578805,0.18741595161928992,0.19433137090882502,0.20569238198338069,0.21686522757543747,0.25999271193676043,0.28078487633887694,0.32115825803977294,0.33692138555416262]
[null,null,0.27584448818897639,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.11239610565258651,-8.5471862017345468E-2,-6.3672573310559977E-2,-4.5122577133362651E-2,-2.8811518395746694E-2,-1.4134771372185218E-2,-7.0234822937875752E-4,1.1751780456055627E-2,2.3417124456480032E-2,3.4433422749226228E-2,4.490664930381616E-2,5.4919064057550315E-2,6.4535782039143452E-2,7.3809213911521621E-2,8.2782155253554146E-2,9.148998985441148E-2,9.9962295571416782E-2,0.10822403731302921,0.11629646843940722,0.12419782222936049,0.13194384956515859,0.13954824220049145,0.14702296969137474,0.15437855033715175,0.16162427108832578,0.16876836756077584,0.17581817255353238,0.18278023947080579,0.18966044557761519,0.20095967007782933,0.21206740712379757,0.25491062383571061,0.27555098352721807,0.31560987232031668,0.33124464380833829]
[null,null,0.28232692307692309,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.12232775442678334,-9.3471596958383696E-2,-7.0546022722927759E-2,-5.127103299725333E-2,-3.4462371436945527E-2,-1.9428953491284262E-2,-5.7331369005623189E-3,6.9194747126308798E-3,1.8736313260966586E-2,2.986899132554921E-2,4.0431659882542714E-2,5.0512394472217892E-2,6.0180560410668438E-2,6.949174795557278E-2,7.8491179888300122E-2,8.7216125938548217E-2,9.5697652429768576E-2,0.10396191548451039,0.11203113373215912,0.11992433144930947,0.12765791431218076,0.13524612112935963,0.1427013823467842,0.15003460754332054,0.15725541818621558,0.16437233772066806,0.1713929480655938,0.17832401940985565,0.1851716186035417,0.19641336089781691,0.20746025010414981,0.25003588288904544,0.27053259558648657,0.31029299167943614,0.32580570073055592]
[null,null,0.28851691729323314,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.13278285714200078,-0.10168162776848344,-7.7492810584062655E-2,-5.7422313102612366E-2,-4.0075341935698505E-2,-2.4659632728581626E-2,-1.0683139761468619E-2,2.1803128256772109E-3,1.415793959445999E-2,2.5414303379287961E-2,3.6072385978618282E-2,4.6226491651609525E-2,5.5950505823543883E-2,6.5303379576638232E-2,7.4332887555488503E-2,8.3078272950182219E-2,9.1572153087861263E-2,9.9841920679324847E-2,0.10791079298435147,0.11579861009131709,0.12352245111434645,0.1310971160493819,0.13853550702838135,0.14584893321373604,0.15304735701555905,0.1601395947085511,0.16713348124172156,0.17403600666087549,0.18085342982621544,0.19204170473715054,0.20303172065611941,0.2453553401880515,0.26571602402448025,0.30519287638715387,0.32058940494237564]
[null,null,0.29443382352941172,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14388315742174795,-0.11014904387717039,-8.4536636081762984E-2,-6.3591177866562654E-2,-4.5661313904401424E-2,-2.9835881041390011E-2,-1.556055669046863E-2,-2.4734979394216428E-3,9.6743727938655155E-3,2.1061754569959623E-2,3.1821171409199378E-2,4.2053601200900737E-2,5.1837737557774322E-2,6.123608444889439E-2,7.0299099651622843E-2,7.9068091464950641E-2,8.7577293389228705E-2,9.5855381804616835E-2,0.10392660708556778,0.11181165069388843,0.1195282843276475,0.12709188364157753,0.13451583347883123,0.14181185104335592,0.14899024621636436,0.15606013316799472,0.1630296038275254,0.16990587119146405,0.17669538856322542,0.18783394566182809,0.19877080066987185,0.24085695769018733,0.26108873635535068,0.30029603085495538,0.31558188382514296]
[null,null,0.30009532374100722,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15578249341492145,-0.11892869084681268,-9.1703349776574461E-2,-6.9792876929846814E-2,-5.1231068386955347E-2,-3.4966423669996916E-2,-2.0373126664814944E-2,-7.0492284269927374E-3,5.2785415128799862E-3,1.6804326222237487E-2,2.7670966538523301E-2,3.7986593342656194E-2,4.7835016076909431E-2,5.7282495156141033E-2,6.6382309713738596E-2,7.5177929116444497E-2,8.3705270935525267E-2,9.1994344059321831E-2,0.10007046761071603,0.10795519074753401,0.11566699740630715,0.12322185371387517,0.13063363848013099,0.13791448556334185,0.14507505894683037,0.15212477582874895,0.15907198911004183,0.16592413785479487,0.17268787225280757,0.18378021768115049,0.19466738351802793,0.23652969245969557,0.25663923571754177,0.29559007417195149,0.31077041046745912]
[null,null,0.30551760563380276,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.16867883993221322,-0.12808542403417578,-9.9021535507586855E-2,-7.6043356810455265E-2,-5.6795389225828274E-2,-4.0059713519013718E-2,-2.512819204693284E-2,-1.155368899106568E-2,9.6387255047125642E-4,1.2635523340583488E-2,2.3615265053542611E-2,3.4018898278139531E-2,4.3935676905564991E-2,5.3435833562559543E-2,6.2575614281407566E-2,7.1400749957115206E-2,7.9948912958454299E-2,8.8251495331264085E-2,9.6334921757301961E-2,0.10422163618750457,0.11193085496622968,0.11947914985032848,0.12688090510333772,0.13414868000566638,0.14129349937676228,0.14832508864244165,0.15525206570868022,0.1620820988482552,0.16882203759208725,0.17987145371027302,0.19071218087152109,0.2323633951370685,0.25235695528279667,0.29106362654549756,0.30614328695997806]
[null,null,0.3107155172413793,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.13769708955842108,-0.10652322030924932,-8.2359492879266472E-2,-6.2365170548719151E-2,-4.5124001318586737E-2,-2.9832756787298687E-2,-1.5993284086114334E-2,-3.2757631366941986E-3,8.5493200648503187E-3,1.9648048394949269E-2,3.0144449401478202E-2,4.0133572549468699E-2,4.9689851411248931E-2,5.8872652168634021E-2,6.7730072408539899E-2,7.6301612958081133E-2,8.4620101535338277E-2,9.2713106396237421E-2,0.10060399417032762,0.10831273430041555,0.11585651967844157,0.12325025174061444,0.13050692411240861,0.1376379292863199,0.14465330618260297,0.15156194178795435,0.15837173674989269,0.16508974240780683,0.17609930552031727,0.18689664075504697,0.22834872063325418,0.24823216537291071,0.28670620940486224,0.30168974173288543]
[null,null,0.31570270270270273,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14785851617732937,-0.11424475348816954,-8.8759353739449764E-2,-6.7951528425971963E-2,-5.0167402879939038E-2,-3.449353961043744E-2,-2.0374061070090765E-2,-7.4460982658952624E-3,4.5401115183874019E-3,1.5763736770854964E-2,2.6357633268793812E-2,3.6423021334980987E-2,4.6038778002601477E-2,5.5267550973157942E-2,6.4159914604382973E-2,7.2757274887056411E-2,8.109394964883343E-2,8.91986899690973E-2,9.7095813844238155E-2,0.1048060650339091,0.11234727341992334,0.11973486956293566,0.1269822905113438,0.13410130337016613,0.14110226588776653,0.14799433824960939,0.15478565666929889,0.16148347677534192,0.17245607315742539,0.18321287528937691,0.22447704936143231,0.24425589153048688,0.28250815728152845,0.29739983899663236]
[null,null,0.32049172185430469,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15868691689196068,-0.12222790965042674,-9.5262507909753324E-2,-7.3565919342521879E-2,-5.51979646790135E-2,-3.9117023113677818E-2,-2.4701754088956251E-2,-1.155251177300709E-2,6.0267116397705323E-4,1.1957145848333184E-2,2.2653245396292432E-2,3.2798762220771494E-2,4.2477273984069308E-2,5.1754879833872058E-2,6.068474611621455E-2,6.9310263850668408E-2,7.7667297393865686E-2,8.5785821162135401E-2,9.3691134024419753E-2,0.10140477581005669,0.10894522959774999,0.11632846725764767,0.12356837849354618,0.13067711206446853,0.13766534994699686,0.14454252968555559,0.15131702627655996,0.15799630213198457,0.16893464254757173,0.17965359680847204,0.22074041758066221,0.24041984206186418,0.27846053987250285,0.29326439864763754]
[null,null,0.3250941558441558,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.17032925360920625,-0.13052128918240802,-0.10189038514730608,-7.9220268427972473E-2,-6.0223728960187906E-2,-4.3709499600132817E-2,-2.8981823787088357E-2,-1.5600066807795132E-2,-3.267887081670473E-3,8.2234483569343375E-3,1.902645110352319E-2,2.9255914779745762E-2,3.9000390431428444E-2,4.8329607598698088E-2,5.7299445207019239E-2,6.595536245029443E-2,7.4334828677491194E-2,8.2469083450854352E-2,9.0384436850308836E-2,9.810324706900575E-2,0.10564466694434982,0.11302522207477983,0.12025926420616329,0.12735933089433327,0.13433643381001215,0.14120029205850848,0.14795952266102663,0.15462179732122028,0.16552843019907248,0.1762120612387934,0.2171314556424131,0.2367163437956612,0.27455509293550362,0.28927492525009102]
[null,null,0.32952070063694266,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.13918211522612023,-0.10866670798512557,-8.4927110812831663E-2,-6.5252799547266038E-2,-4.8277114383412534E-2,-3.3219493485566742E-2,-1.9593544808803598E-2,-7.0761426118011173E-3,4.5581399535825629E-3,1.5472750736076346E-2,2.5789943670073701E-2,3.5603532525048109E-2,4.4987065691249217E-2,5.3999260885757572E-2,6.2687732028862353E-2,7.1091614033545802E-2,7.9243454744835296E-2,8.7170606640519788E-2,9.4896269120036791E-2,0.10244028169871577,0.10981973635629139,0.11704945642108711,0.12414237548908647,0.13110984045613239,0.13796185623151458,0.14470728512815278,0.15135401066343102,0.16223133407704671,0.17288201779413437,0.21364333311120887,0.23313828498774902,0.27078415686653479,0.28542354491234168]
[null,null,0.33378124999999997,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14827856064769962,-0.11561801335141519,-9.0699750052543271E-2,-7.0293409580957422E-2,-5.2825907238370995E-2,-3.7419782386457046E-2,-2.3537476196532792E-2,-1.0826398315271102E-2,9.5700879437443653E-4,1.1987948700449724E-2,2.2396627014887649E-2,3.2282427227576349E-2,4.1722915069687172E-2,5.0779779143545589E-2,5.9502878186225461E-2,6.7933075421648281E-2,7.610427147595078E-2,8.4044893276371768E-2,9.1779004826729738E-2,9.9327149599617082E-2,0.10670699884374257,0.11393385716345739,0.12102106153791703,0.12798029968327485,0.13482186659639361,0.14155487317335003,0.14818741728097051,0.15903768985966504,0.16965766417789063,0.21026970988114924,0.22967906445991826,0.26714062197868493,0.28170294904944604]
[null,null,0.34053787878787872,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.1646384777640616,-0.12767571298631986,-0.10050625665005763,-7.8743097527361861E-2,-6.0381616260320237E-2,-4.4350290548712312E-2,-3.0012199764920866E-2,-1.695884281105875E-2,-4.9128696300555497E-3,6.3225226726519868E-3,1.6891979955945713E-2,2.6904902420323396E-2,3.6446021474740187E-2,4.5582287586957815E-2,5.4367511105740896E-2,6.2845581340498891E-2,7.1052756246115845E-2,7.9019327126651051E-2,8.6770852521997899E-2,9.4329088552378648E-2,0.10171270119302922,0.10893781913063472,0.11601846823533579,0.12296691686237349,0.12979395311453668,0.13650910957231521,0.14312084702266326,0.15393070649236917,0.16450412769457379,0.20488562619327144,0.2241613095411108,0.26133343643831375,0.27577435072192702]
[null,null,0.34689705882352945,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14047154799075268,-0.1106092192068413,-8.7289294400916595E-2,-6.7929209600220863E-2,-5.1211960486584718E-2,-3.6379942589267134E-2,-2.2958765373270462E-2,-1.0632169998035845E-2,8.2106186584507412E-4,1.1561656578094714E-2,2.1710031397428331E-2,3.1358717137104142E-2,4.0580340582883512E-2,4.9432942138063041E-2,5.7963628604430051E-2,6.6211149453590634E-2,7.4207756043351836E-2,8.1980570667349095E-2,8.9552612799178366E-2,9.6943580685235453E-2,0.10417045514831358,0.11124797207242043,0.11818899645656189,0.12500482169711513,0.13170541137528957,0.1382995963381517,0.14907441579084568,0.1596066087417618,0.19977855361950425,0.21893092960315919,0.25583412124824179,0.2701617336234825]
[null,null,0.36898684210526317,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15599403904434861,-0.12339996480007942,-9.8612630761221065E-2,-7.8381593980358599E-2,-6.1118065751179174E-2,-4.593500824916219E-2,-3.228905234308288E-2,-1.9823972057171346E-2,-8.2938507623250279E-3,2.4781007303940061E-3,1.2623189363520693E-2,2.2241587400732898E-2,3.1411442089328556E-2,4.0194882776257268E-2,4.8642111266408827E-2,5.6794264762665136E-2,6.468546813631737E-2,7.2344336166187073E-2,7.9795093653355798E-2,8.7058424441122328E-2,9.4152124481701849E-2,0.10109161086846208,0.10789032338198545,0.114560044715595,0.1211111584020359,0.13179061495747479,0.14220229876001067,0.18171143837556403,0.20045743658260107,0.23645711093938515,0.25039981643627818]
[null,null,0.37837500000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.14348366857538464,-0.11470053851402695,-9.2087340164704323E-2,-7.3263976198775782E-2,-5.6993039133225065E-2,-4.2553979309711942E-2,-2.9491854289375619E-2,-1.750156068024078E-2,-6.3687291945058178E-3,4.0629310335287272E-3,1.391083977618579E-2,2.3265431166792361E-2,3.2197823667279302E-2,4.0764947438773236E-2,4.9013076621318818E-2,5.6980326667213088E-2,6.4698460298569405E-2,7.2194219678024307E-2,7.9490326520474053E-2,8.6606244782869268E-2,9.3558770538424429E-2,0.10036249402380371,0.10703016575213553,0.11357298967028928,0.1242266199606894,0.13459971698598627,0.17386326367735405,0.19244872362297682,0.22808151203158622,0.24186551592829941]
[null,null,0.39459090909090905,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.15006761596265672,-0.12064522716005821,-9.7703272176423495E-2,-7.8707737235997333E-2,-6.2353604809177177E-2,-4.7886476408129708E-2,-3.4832734378009045E-2,-2.2876179864456669E-2,-1.1795457253462427E-2,-1.4296661376733688E-3,8.3417740030555798E-3,1.7611535888144569E-2,2.6452367938339272E-2,3.4922416007300061E-2,4.3068880374278029E-2,5.0930595517966193E-2,5.8539892002336558E-2,6.5923967463650479E-2,7.3105914210569667E-2,8.0105501732776752E-2,8.6939781095896729E-2,9.362355778273912E-2,0.10016976593596461,0.1108046568309824,0.12113322036382379,0.1600353662676004,0.17836465543846036,0.21339355872035037,0.22691203993186737]
[null,null,0.4,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.16526581098260285,-0.1321768620265884,-0.10719446763971552,-8.6921532659390732E-2,-6.97029974951896E-2,-5.4618524807074187E-2,-4.1106441414069606E-2,-2.879971429253092E-2,-1.7445670330348717E-2,-6.8630944701660868E-3,3.0823342794359387E-3,1.2492909716996126E-2,2.1448315814005081E-2,3.0011823583700803E-2,3.8234502518928348E-2,4.6158163101539307E-2,5.38174627202328E-2,6.1241444901282804E-2,6.8454685440223484E-2,7.5478160044210263E-2,8.2329910938516715E-2,8.9025565882115076E-2,9.5578747168201472E-2,0.1062158964461164,0.11653685167217231,0.15533890563200581,0.17358960121338929,0.20842676421334416,0.22185948400078015]

{"sheet":"RECEITA","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[37,4,37,5],[37,6,37,8],[36,6,36,8],[41,0,41,3],[18,0,19,0],[32,4,33,5],[35,4,35,5],[36,4,36,5],[20,0,21,0],[25,0,25,9],[32,7,32,8],[33,7,33,8],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[35,6,35,8],[1,0,1,9],[3,0,4,0],[5,0,6,0],[10,0,10,9],[16,0,16,9]]}
[]
["IPÊ AMARELO - RECEITA MENSAL INICIAL ESTIMADA (R$)"]
["VEÍCULO","PERÍODO","VAGAS","DIAS","HORAS","TARIFA (R$)","TX OCUPAÇÃO","RESPEITO*","ISENÇÃO","RECEITA (R$)"]
["CARROS","2ª a 6ª",{"$f":"'VAGAS RECEITA'!B26","v":72455},22,11,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0.8,{"$f":"C4*D4*E4*F4*G4*H4*(1-I4)","v":1893683.8799999997}]
[null,"SÁBADO",{"$f":"'VAGAS RECEITA'!B26","v":72455},4,4,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0.8,{"$f":"C5*D5*E5*F5*G5*H5*(1-I5)","v":125202.23999999996}]
["MOTOS","2ª a 6ª",{"$f":"'VAGAS RECEITA'!G26","v":4135},22,11,{"$f":"'FLUXO DE CAIXA'!$G$43/2","v":1.5},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C6*D6*E6*F6*G6*H6*(1-I6)","v":270180.89999999997}]
[null,"SÁBADO",{"$f":"'VAGAS RECEITA'!G26","v":4135},4,4,{"$f":"'FLUXO DE CAIXA'!$G$43/2","v":1.5},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C7*D7*E7*F7*G7*H7*(1-I7)","v":17863.2}]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J4:J7)","v":2306930.2199999997}]
[]
["IPÊ BRANCO - RECEITA MENSAL INICIAL ESTIMADA (R$)"]
["VEÍCULO","PERÍODO","VAGAS","DIAS","HORAS","TARIFA (R$)","TX OCUPAÇÃO","RESPEITO*","ISENÇÃO","RECEITA (R$)"]
["CARROS","2ª a 6ª",{"$f":"'VAGAS RECEITA'!B19","v":6266},22,18,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0.95,{"$f":"C13*D13*E13*F13*G13*H13*(1-I13)","v":66996.072000000058}]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J13:J13)","v":66996.072000000058}]
[]
["IPÊ ROXO - RECEITA MENSAL INICIAL ESTIMADA (R$)"]
["VEÍCULO","PERÍODO","VAGAS","DIAS","HORAS","TARIFA (R$)","TX OCUPAÇÃO","RESPEITO*","ISENÇÃO","RECEITA (R$)"]
["CARROS","2ª a 6ª",{"$f":"'VAGAS RECEITA'!B29","v":11851},22,10,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C19*D19*E19*F19*G19*H19*(1-I19)","v":1407898.8}]
[null,"SÁBADO",{"$f":"'VAGAS RECEITA'!B29","v":11851},4,5,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C20*D20*E20*F20*G20*H20*(1-I20)","v":127990.79999999999}]
["MOTOS ","2ª a 6ª",{"$f":"'VAGAS RECEITA'!G29","v":1645},22,10,{"$f":"'FLUXO DE CAIXA'!$G$43/2","v":1.5},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C21*D21*E21*F21*G21*H21*(1-I21)","v":97713}]
[null,"SÁBADO",{"$f":"'VAGAS RECEITA'!G29","v":1645},4,5,{"$f":"'FLUXO DE CAIXA'!$G$43/2","v":1.5},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C22*D22*E22*F22*G22*H22*(1-I22)","v":8883}]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J19:J22)","v":1642485.6}]
[]
["IPÊ ROSA - RECEITA MENSAL INICIAL ESTIMADA (R$)"]
["VEÍCULO","PERÍODO","VAGAS","DIAS","HORAS","TARIFA (R$)","TX OCUPAÇÃO","RESPEITO*","ISENÇÃO","RECEITA (R$)"]
["CARROS","2ª a 6ª",{"$f":"'VAGAS RECEITA'!B34","v":15252},22,12,{"$f":"'FLUXO DE CAIXA'!$G$43","v":3},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C28*D28*E28*F28*G28*H28*(1-I28)","v":2174325.1199999996}]
["MOTOS","SÁBADO",{"$f":"'VAGAS RECEITA'!G34","v":1640},22,12,{"$f":"'FLUXO DE CAIXA'!$G$43/2","v":1.5},{"$f":"'FLUXO DE CAIXA'!G45","v":0.3},{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},0,{"$f":"C29*D29*E29*F29*G29*H29*(1-I29)","v":116899.2}]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J28:J29)","v":2291224.3199999998}]
[]
["ANO","* TAXA DE RESPEITO",null,null,"VÁLIDO A PARTIR DO 4º ANO",null,null,"TOTAL GERAL MENSAL (R$)",null,{"$f":"J9+J15+J24+J31","v":6307636.2119999994}]
[1,{"$f":"'FLUXO DE CAIXA'!I45","v":0.5},null,null,null,null,null,"TOTAL GERAL ANUAL (R$)",null,{"$f":"12*J33","v":75691634.544}]
[2,{"$f":"B34+(B37-B34)/3","v":0.53333333333333333}]
[3,{"$f":"B34+2*(B37-B34)/3","v":0.56666666666666665},null,null,"RECEITA 1º ANO",null,"50% IPÊS BRANCO/ROXO/ROSA ; RESPEITO 60%",null,null,{"$f":"0.5*(J15+J24+J31)*12*B34/0.75","v":16002823.968}]
["4 - 20",{"$f":"'FLUXO DE CAIXA'!K45","v":0.6},null,null,"RECEITA 2º ANO",null,"100% B/R/R ; 50% IPÊ AMARELO ; RESPEITO 65%",null,null,{"$f":"(0.5*J9+J15+J24+J31)*12*B35/0.75","v":43982260.0704}]
[null,null,null,null,"RECEITA 3º ANO",null," RESPEITO 70%",null,null,{"$f":"J34*B36/0.75","v":57189234.988799997}]
[]
[]
[]
["RECEITA ACESSÓRIA PUBLICIDADE"]
["Preço público de ocupação (R$/m2/ano):",null,null,204.44]
["Número de espaços a serem explorados:",null,null,130]
["Área explorada em cada espaço (m2):",null,null,12]
["Valor total anual:",null,null,{"$f":"D43*D44*D45","v":318926.40000000002}]

{"sheet":"VAGAS RECEITA","index":2,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"VAGAS (AUTOS)","VAGAS","PNE","IDOSOS","GESTANTES","VAGAS (MOTOS)","CARGA/DESCARGA","VAGAS (TOTAL)","REVIT","EXPANSÃO/NOVAS"]
["IPÊ BRANCO"]
["METRÔ GUARÁ",{"$f":"SUM(C3:F3)","v":556},520,9,25,2,50,3,{"$f":"B3+G3+H3","v":609},278,{"$f":"I3-J3","v":331}]
["METRÔ SHOPPING",536,500,9,25,2,100,2,638,415,{"$f":"I4-J4","v":223}]
["METRÔ TAGUATINGA SUL",139,130,2,6,1,20,1,160,67,{"$f":"I5-J5","v":93}]
["METRÔ FURNAS",171,160,3,7,1,60,1,232,232]
["METRÔ SAMAMBAIS",1012,950,15,45,2,300,2,1314,600,{"$f":"I7-J7","v":714}]
["METRÔ SAMAMBAIA SUL",448,420,6,20,2,100,2,550,310,{"$f":"I8-J8","v":240}]
["METRO CENTRO ADM",172,150,5,15,2,40,1,213,150,{"$f":"I9-J9","v":63}]
["METRÔ FEIRA",311,290,5,14,2,50,2,363,363]
["METRÔ TERM. CEILÂNDIA",123,115,2,5,1,20,1,144,144]
["METRÔ CEILÂNDIA NORTE",536,500,8,26,2,80,1,617,617]
["METRÔ CEILÂNDIA CENTRO",337,315,5,15,2,40,1,378,0,378]
["METRÔ GUARIROBA",172,160,3,7,2,30,1,203,203]
["METRÔ CEILÂNDIA SUL",204,190,3,10,1,30,1,235,235]
["SANTA MARIA BRT",634,600,7,25,2,150,2,786,560,{"$f":"I16-J16","v":226}]
["BRT GAMA",483,450,7,23,3,60,2,545,196,{"$f":"I17-J17","v":349}]
["METRÔ ESTRADA PARQUE",432,400,8,20,4,100,2,534,0,{"$f":"I18-J18","v":534}]
["SOMA",{"$f":"SUM(B3:B18)","v":6266},5850,97,288,31,1230,25,7521,4370,3151]
[]
["IPÊ AMARELO"]
["SUDOESTE",{"$f":"SUM(C22:F22)","v":8795},8500,80,200,15,300,80,{"$f":"B22+G22+H22","v":9175},{"$f":"I22","v":9175}]
["SIG",{"$f":"SUM(C23:F23)","v":1722},1600,32,80,10,200,30,{"$f":"B23+G23+H23","v":1952},{"$f":"I23","v":1952}]
["W3NORTE",{"$f":"SUM(C24:F24)","v":4870},4600,60,200,10,500,20,{"$f":"B24+G24+H24","v":5390},{"$f":"I24","v":5390}]
["OUTROS",{"$f":"SUM(C25:F25)","v":57068},53680,910,2292,186,3135,843,{"$f":"B25+G25+H25","v":61046},{"$f":"I25","v":61046}]
["SOMA",{"$f":"SUM(B22:B25)","v":72455},68380,1082,2772,221,4135,973,77563,77563]
["IPÊ ROXO",null,68380]
[null,{"$f":"SUM(C28:F28)","v":11851},11025,179,564,83,1645,120,{"$f":"B28+G28+H28","v":13616},{"$f":"I28","v":13616}]
["SOMA",{"$f":"SUM(B28)","v":11851},11025,179,564,83,1645,120,13616,13616]
["IPÊ ROSA"]
["EIXO MONUM. E BURITI",{"$f":"SUM(C31:F31)","v":1050},970,20,50,10,150,4,{"$f":"B31+G31+H31","v":1204},{"$f":"I31","v":1204}]
["REGIÃO DOS MINISTÉRIOS (N1, N2, ESPLANADA E EIXO)",{"$f":"SUM(C32:F32)","v":6410},6000,90,300,20,600,20,{"$f":"B32+G32+H32","v":7030},{"$f":"I32","v":7030}]
["OUTROS",{"$f":"SUM(C33:F33)","v":7792},7229,{"$f":"13+9+45+13+15+20+6","v":121},{"$f":"45+30+150+45+47+70+7","v":394},{"$f":"5+5+10+5+7+10+6","v":48},{"$f":"100+70+300+100+90+150+80","v":890},{"$f":"6+2+10+15+7+10+4","v":54},{"$f":"B33+G33+H33","v":8736},{"$f":"I33","v":8736}]
["SOMA",{"$f":"SUM(B31:B33)","v":15252},14199,231,744,78,1640,78,16970,16970]
[null,{"$f":"B34+B29+B26+B19","v":105824},99454,1589,4368,413,8650,1196,115670,112519,3151]

{"sheet":"CAPEX","index":3,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,7,30,10],[22,7,22,10],[23,7,23,10],[24,7,24,10],[25,7,25,10],[26,7,26,10],[27,1,27,4],[28,1,28,4],[29,1,29,4],[27,7,27,10],[28,7,28,10],[29,7,29,10],[30,1,30,4],[19,0,20,10],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[23,1,23,4],[24,1,24,4],[22,1,22,4],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[25,1,25,4],[26,1,26,4],[3,0,5,0],[0,0,1,10],[3,7,3,8],[3,9,3,10],[3,6,5,6],[3,1,3,2],[3,3,3,4]]}
["COMPARATIVO CAPEX"]
[]
[]
["CAPEX TOTAL","RIZZO",null,"REVISÃO SEMOB",null,null,"ESTACIONAMENTOS","RIZZO",null,"REVISÃO SEMOB"]
[null,"R$","%","R$","%",null,null,"R$","%","R$","%"]
[null,{"$f":"SUM(B7:B14)","v":271080177.88999999},{"$f":"B6/B$6","v":1},{"$f":"SUM(D7:D14)","v":71358692.123488367},1,null,null,{"$f":"SUM(H7:H17)","v":143621764.80860001},{"$f":"H6/H$6","v":1},{"$f":"SUM(J7:J17)","v":35310062.26348836},{"$f":"J6/J$6","v":1}]
["Estacionamentos",143621765,0.52981286244499748,{"$f":"J6","v":35310062.26348836},0.4948249640335789,null,"Serviços Preliminares",14140345.049999999,{"$f":"H7/H$6","v":9.8455446978000655E-2},{"$f":"ESTACIONAMENTOS!U6","v":1350603.6397209873},{"$f":"J7/J$6","v":3.8249823227232062E-2}]
["Edificações",42759660,0.15773805496524054,{"$f":"EDIFICAÇÕES!E6","v":4258306},5.9674664337049134E-2,null,"Terraplenagem",7330777.8786000004,{"$f":"H8/H$6","v":5.1042248982036159E-2},{"$f":"ESTACIONAMENTOS!U9+ESTACIONAMENTOS!U13","v":904806.05992934317},{"$f":"J8/J$6","v":2.5624595424883722E-2}]
["Equipamentos",42791504.259999998,0.15785552670459035,{"$f":"EQUIPAMENTOS!F18","v":7297991.7000000002},0.10227193748689516,null,"Pavimentação",18112555,{"$f":"H9/H$6","v":0.12611288424242667},{"$f":"ESTACIONAMENTOS!U20++ESTACIONAMENTOS!U29","v":8807558.2205752246},{"$f":"J9/J$6","v":0.24943479722159817}]
["CCO",1384432,5.1070941843699849E-3,{"$f":"CCO!F10","v":1384432},1.9401028225183817E-2,null,"Calçadas / Meio Fio / Piso Podotátil / Mob. Urbano",3140205.6999999993,{"$f":"H10/H$6","v":2.1864413824637566E-2},{"$f":"ESTACIONAMENTOS!U33+ESTACIONAMENTOS!U38+ESTACIONAMENTOS!U41+ESTACIONAMENTOS!U45","v":14714610.301812343},{"$f":"J10/J$6","v":0.41672569682856897}]
["Sistemas",12919350,4.7658777932639791E-2,{"$f":"SISTEMAS!F7","v":12520000},0.17545164614751854,null,"Limpeza da Obra",0,{"$f":"H11/H$6","v":0},{"$f":"ESTACIONAMENTOS!U50","v":256244.26147297301},{"$f":"J11/J$6","v":7.2569756337681991E-3}]
["Veículos",4656000,1.7175730207353378E-2,{"$f":"VEíCULOS!F11","v":4656000},6.5247832624827987E-2,null,"Sinalização Horizontal e Vertical",12349571,{"$f":"H12/H$6","v":8.5986765421368169E-2},{"$f":"ESTACIONAMENTOS!U52","v":6064141.1062525194},{"$f":"J12/J$6","v":0.17173974548674242}]
["Comunicação",22233251.630000003,8.2017253356761119E-2,{"$f":"COMUNICAÇÃO!F54","v":5217685.16},7.3119125431428011E-2,null,"Drenagem",1299197.8299999998,{"$f":"H13/H$6","v":9.0459675922475811E-3},{"$f":"ESTACIONAMENTOS!U57","v":932001.65153124346},{"$f":"J13/J$6","v":2.6394789240996624E-2}]
["Uniformes",714215,2.6347002040474428E-3,{"$f":"UNIFORMES!F10","v":714215},1.0008801713518367E-2,null,"Iluminação",2080884.9799999997,{"$f":"H14/H$6","v":1.4488646499875047E-2},{"$f":"ESTACIONAMENTOS!U62","v":2031568.3822650812},{"$f":"J14/J$6","v":5.7535111864296613E-2}]
[null,null,null,null,null,null,"Paisagismo",356640.63,{"$f":"H15/H$6","v":2.4831934802868019E-3},{"$f":"ESTACIONAMENTOS!U67","v":248528.63992864866},{"$f":"J15/J$6","v":7.0384650719133553E-3}]
[null,null,null,null,null,null,"Instalações Hidrossanitárias / Esgoto / Irrigação",1787585.3899999997,{"$f":"H16/H$6","v":1.2446479768454703E-2},{"$f":"ESTACIONAMENTOS!U73","v":0},{"$f":"J16/J$6","v":0}]
[null,null,null,null,null,null,"Fechamentos",83024001.349999994,{"$f":"H17/H$6","v":0.57807395321066657},0,{"$f":"J17/J$6","v":0}]
[]
[]
["CRONOGRAMA CAPEX"]
[]
[]
["ITEM","ANO 1",null,null,null,"ANO 2",null,"ANO 3 - ANO 20"]
["Estacionamentos","Ipês Branco, Roxo e Rosa (33% das vagas) ",null,null,null,"Ipê Amarelo ",null,"Manutenção 5% ao ano (anos 5 - 20)"]
["Edificações","Edificações previstas nos Ipês Branco,Roxo e Rosa",null,null,null,"Edificações previstas no Ipê Amarelo / Boulevards",null,"Manutenção 5% ao ano (anos 5 - 20)"]
["Equipamentos *","33% do total",null,null,null,"67% do total",null,"Reinv. c/5 anos s/ valor res., exceto parquímetro"]
["CCO *",1,null,null,null,"-",null,"Reinvestimento no 10º ano sem valor residual"]
["Sistemas *",1,null,null,null,"-",null,"-"]
["Veículos *",1,null,null,null,"-",null,"Reinvestimento c/5 anos com valor residual 50%"]
["Comunicação","1ª Etapa de Comunicação",null,null,null,"2ª Etapa de Comunicação",null,"3ª Etapa de Comunicação no ano 3"]
["Uniformes *",1,null,null,null,"-",null,"Reinvestimento c/5 anos sem valor residual"]
["* Bens não reversíveis, não sendo necessário o reinvestimento no ano 20."]
[]
[]
["DEPRECIAÇÃO ANUAL"]
["Estacionamentos",{"$f":"D7/20","v":1765503.113174418}]
["Edificações",{"$f":"D8/20","v":212915.3}]
["Equipamentos",{"$f":"D9/5","v":1459598.34}]
["CCO",{"$f":"D10/10","v":138443.20000000001}]
["Sistemas",{"$f":"D11/20","v":626000}]
["Veículos",{"$f":"D12/5*0.5","v":465600}]
["Comunicação",{"$f":"D13/20","v":260884.258}]
["Uniformes",{"$f":"D14/5","v":142843}]

{"sheet":"VAGAS CAPEX","index":4,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"VAGAS","PNE","IDOSOS","GESTANTES","MOTOS","CARGA/DESCARGA","soma normal","soma motos (x50%)","vagas relativas- para calculo do CAPEX","REVIT","EXPAD","NOVA","BASE","BASE+LAV"]
["IPÊ BRANCO"]
["METRÔ GUARÁ",520,9,25,2,50,3,{"$f":"B3+C3+D3+E3+G3","v":559},{"$f":"F3*0.5","v":25},{"$f":"SUM(H3:I3)","v":584},248,{"$f":"J3-K3","v":336},null,null,1]
["METRÔ SHOPPING",500,9,25,2,100,2,{"$f":"B4+C4+D4+E4+G4","v":538},50,{"$f":"SUM(H4:I4)","v":588},353,{"$f":"J4-K4","v":235},null,null,1]
["METRÔ TAGUATINGA SUL",130,2,6,1,20,1,140,10,150,58,null,{"$f":"J5-K5","v":92},null,1]
["METRÔ FURNAS",160,3,7,1,60,1,172,30,202,202,null,null,null,1]
["METRÔ SAMAMBAIS",950,15,45,2,300,2,1014,150,1164,490,{"$f":"J7-K7","v":674},null,null,1]
["METRÔ SAMAMBAIA SUL",420,6,20,2,100,2,450,50,500,262,{"$f":"J8-K8","v":238},null,null,1]
["METRO CENTRO ADM",150,5,15,2,40,1,173,20,193,116,{"$f":"J9-K9","v":77},null,null,1]
["METRÔ FEIRA",290,5,14,2,50,2,313,25,338,338,null,null,null,1]
["METRÔ TERM. CEILÂNDIA",115,2,5,1,20,1,124,10,134,134,null,null,null,1]
["METRÔ CEILÂNDIA NORTE",500,8,26,2,80,1,537,40,577,577,null,null,null,1]
["METRÔ CEILÂNDIA CENTRO",315,5,15,2,40,1,338,20,358,null,null,358,null,1]
["METRÔ GUARIROBA",160,3,7,2,30,1,173,15,188,188,null,null,null,1]
["METRÔ CEILÂNDIA SUL",190,3,10,1,30,1,205,15,220,220,null,null,null,1]
["SANTA MARIA BRT",600,7,25,2,150,2,636,75,711,474,null,{"$f":"J16-K16","v":237},null,1]
["BRT GAMA",450,7,23,3,60,2,485,30,515,172,null,{"$f":"J17-K17","v":343},null,1]
["METRÔ ESTRADA PARQUE",400,8,20,4,100,2,434,50,484,null,null,484,null,1]
["SOMA",{"$f":"SUM(B3:B18)","v":5850},{"$f":"SUM(C3:C18)","v":97},288,31,1230,25,null,null,null,{"$f":"SUM(K3:K18)","v":3832},{"$f":"SUM(L3:L18)","v":1560},1514,0,16]
[]
["IPÊ AMARELO"]
["SUDOESTE",8500,80,200,15,300,80,{"$f":"B22+C22+D22+E22+G22","v":8875},{"$f":"F22*0.5","v":150},{"$f":"SUM(H22:I22)","v":9025},{"$f":"SUM(H22:I22)","v":9025},null,null,7]
["SIG",1600,32,80,10,200,30,{"$f":"B23+C23+D23+E23+G23","v":1752},{"$f":"F23*0.5","v":100},{"$f":"SUM(H23:I23)","v":1852},{"$f":"SUM(H23:I23)","v":1852},null,null,2]
["W3NORTE",4600,60,200,10,500,20,4890,{"$f":"F24*0.5","v":250},5140,{"$f":"SUM(H24:I24)","v":5140},null,null,10]
["OUTROS",53680,910,2292,186,3135,843,57911,{"$f":"F25*0.5","v":1567.5},59478.5,{"$f":"SUM(H25:I25)","v":59478.5},null,null,38]
["SOMA",{"$f":"SUM(B22:B25)","v":68380},1082,2772,221,4135,973,null,null,null,{"$f":"SUM(K22:K25)","v":75495.5},{"$f":"SUM(L22:L25)","v":0},0,{"$f":"SUM(N22:N25)","v":57},{"$f":"SUM(O22:O25)","v":0}]
["IPÊ ROXO",68380]
[null,11025,179,564,83,1645,120,{"$f":"B28+C28+D28+E28+G28","v":11971},{"$f":"F28*0.5","v":822.5},{"$f":"SUM(H28:I28)","v":12793.5},{"$f":"SUM(H28:I28)","v":12793.5},null,null,1,27]
["SOMA",{"$f":"SUM(B28)","v":11025},{"$f":"SUM(C28)","v":179},564,83,1645,120,null,null,null,{"$f":"SUM(K28)","v":12793.5},0,0,{"$f":"SUM(N28)","v":1},{"$f":"SUM(O28)","v":27}]
["IPÊ ROSA "]
["EIXO MONUM. E BURITI",970,20,50,10,150,4,{"$f":"B31+C31+D31+E31+G31","v":1054},{"$f":"F31*0.5","v":75},{"$f":"SUM(H31:I31)","v":1129},{"$f":"SUM(H31:I31)","v":1129},null,null,null,2]
["REGIÃO DOS MINISTÉRIOS (N1, N2, ESPLANADA E EIXO)",6000,90,300,20,600,20,{"$f":"B32+C32+D32+E32+G32","v":6430},{"$f":"F32*0.5","v":300},6730,{"$f":"SUM(H32:I32)","v":6730},null,null,null,7]
["OUTROS",7229,{"$f":"13+9+45+13+15+20+6","v":121},{"$f":"45+30+150+45+47+70+7","v":394},{"$f":"5+5+10+5+7+10+6","v":48},{"$f":"100+70+300+100+90+150+80","v":890},{"$f":"6+2+10+15+7+10+4","v":54},7846,{"$f":"F33*0.5","v":445},8291,{"$f":"SUM(H33:I33)","v":8291},null,null,null,20]
["SOMA",{"$f":"SUM(B31:B33)","v":14199},{"$f":"SUM(C31:C33)","v":231},744,78,1640,78,null,null,null,{"$f":"SUM(K31:K33)","v":16150},0,0,0,29]
[null,{"$f":"B34+B29+B26+B19","v":99454},{"$f":"C34+C29+C26+C19","v":1589},4368,413,8650,1196,null,null,null,{"$f":"K34+K29+K26+K19","v":108271},1560,1514,58,72]
[]
[null,"Total",{"$f":"C35/($B35-$F35-$G35)","v":1.7732791715025443E-2},{"$f":"D35/($B35-$F35-$G35)","v":4.8745647710025888E-2},4.608963485403089E-3]
[]
[]
[null,"Branco",{"$f":"C19/($B19-$F19-$G19)","v":2.1109902067464634E-2},{"$f":"D19/($B19-$F19-$G19)","v":6.2676822633297061E-2},6.7464635473340586E-3]
[]
[null,"Amarelo",{"$f":"C26/($B26-$F26-$G26)","v":1.7100771273233027E-2},{"$f":"D26/($B26-$F26-$G26)","v":4.3810848400556331E-2},3.4928562397268932E-3]
[]
[null,"Roxo",{"$f":"C29/($B29-$F29-$G29)","v":1.9330453563714902E-2},{"$f":"D29/($B29-$F29-$G29)","v":6.0907127429805613E-2},8.9632829373650115E-3]
[]
[null,"Rosa",{"$f":"C34/($B34-$F34-$G34)","v":1.8508132361189006E-2},{"$f":"D34/($B34-$F34-$G34)","v":5.9610608124349013E-2},6.2494992388430412E-3]

{"sheet":"ESTACIONAMENTOS","index":5,"n_rows":102,"n_cols":23,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,14,1,22],[0,0,2,6],[78,7,78,12],[0,7,0,8],[1,7,1,8],[2,7,2,8],[0,9,0,10],[1,9,1,10],[2,9,2,10],[0,11,0,12],[1,11,1,12],[2,11,2,12],[32,1,32,6],[37,1,37,6],[40,1,40,6],[44,1,44,6],[72,1,72,6],[74,0,74,6],[75,0,75,6],[76,0,76,6],[19,1,19,6],[51,1,51,6],[56,1,56,6],[61,1,61,6],[66,1,66,6],[28,1,28,6],[49,1,49,6],[5,1,5,6],[8,1,8,6],[12,1,12,6],[3,0,4,0],[3,7,3,8],[3,2,4,2],[3,1,4,1],[3,11,3,12],[3,6,4,6],[3,5,4,5],[3,4,4,4],[3,3,4,3],[3,9,3,10],[79,0,79,6],[80,0,80,6],[79,7,79,12],[80,7,80,12],[77,0,77,6],[78,0,78,6]]}
["ESTACIONAMENTOS",null,null,null,null,null,null,null,null,null,null,"IPÊ AMARELO"]
[null,null,null,null,null,null,null,"IPÊ BRANCO ",null,"IPÊ BRANCO ",null,"IPÊ ROXO",null,null,"CUSTO PARCIAL POR ITEM"]
[null,null,null,null,null,null,null,null,null,null,null,"IPÊ ROSA"]
["ITEM","FONTE","CÓDIGO","DESCRIÇÃO","PREMISSAS","UN.","CUSTO UNIT.","NOVOS (EXPANSÃO)",null,"NOVOS (REVITALIZAÇÃO)",null,"EXISTENTES",null,null,"NOVOS (EXP.)",null,"NOVOS (REV.)",null,"EXISTENTES",null,"TOTAL",null,"% PARCIAL"]
[null,null,null,null,null,null,null,"QUANT.","CUSTO REF. (R$)","QUANT.","CUSTO REF. (R$)","QUANT.","CUSTO REF. (R$)"]
[1,"SERVIÇOS PRELIMINARES",null,null,null,null,null,null,{"$f":"SUM(I7:I8)","v":24055.560127199999},null,{"$f":"SUM(K7:K8)","v":3828.6126732000007},null,{"$f":"SUM(M7:M8)","v":769.76023235999992},null,{"$f":"I6*I$77/148*(1+$H$80)","v":590924.8020171544},null,{"$f":"K6*K$77/148*(1+$H$80)","v":117241.08107655968},null,{"$f":"M6*M$77/148*(1+$H$80)","v":642437.75662727316},null,{"$f":"(I6*I$77+K6*K$77+M6*M$77)*(1+$H$80)/148","v":1350603.6397209873},null,{"$f":"U6/$H$79","v":4.6967507025010562E-2}]
["1.1","HÉLIO PRATES1","-","INSTALAÇÃO DA OBRA / MOBILIZAÇÃO E DESMOBILIZAÇÃO",2.1999999999999999E-2,"-","-","-",{"$f":"0.022*(I9+I29+I33+I38+I41+I45+I50+I52+I57+I62+I67+I73)","v":12600.531495199999},"-",{"$f":"0.022*(K9+K29+K33+K38+K41+K45+K50+K52+K57+K62+K67+K73)","v":2005.4637812000003},"-",{"$f":"0.022*(M9+M29+M33+M38+M41+M45+M50+M52+M57+M62+M67+M73)","v":403.20774075999998}]
["1.2","PMI VLT W32","-","PROJETOS LICENCIAMENTO TAXAS",0.02,"-","-","-",{"$f":"$E$8*(I9+I29+I33+I38+I41+I45+I50+I52+I57+I62+I67+I73)","v":11455.028632},"-",{"$f":"$E$8*(K9+K29+K33+K38+K41+K45+K50+K52+K57+K62+K67+K73)","v":1823.1488920000004},"-",{"$f":"$E$8*(M9+M29+M33+M38+M41+M45+M50+M52+M57+M62+M67+M73)","v":366.5524916}]
["2","TERRAPLENAGEM",null,null,null,null,null,null,{"$f":"SUM(I10:I12)","v":16395.96},null,null,null,null,null,{"$f":"I9*I$77/148*(1+$H$80)","v":402766.7352432973},null,null,null,null,null,{"$f":"(I9*I$77+K9*K$77+M9*M$77)*(1+$H$80)/148","v":402766.7352432973},null,{"$f":"U9/$H$79","v":1.4006292379671112E-2}]
["2.1","SINAPI",98524,"LIMPEZA MANUAL DE VEGETAÇÃO EM TERRENO COM ENXADA.AF_05/2018",0,"M2",2.84,0,{"$f":"$G10*H10","v":0}]
["2.2","SINAPI",100983,"CARGA, MANOBRA E DESCARGA DE ENTULHO EM CAMINHÃO BASCULANTE 14 M³ - CARGA COM ESCAVADEIRA HIDRÁULICA (CAÇAMBA DE 0,80 M³ / 111 HP) E DESCARGA LIVRE (UNIDADE:M3). AF_07/2020","h = 1 metro","M3",5.91,596,{"$f":"$G11*H11","v":3522.36}]
["2.3","SINAPI",95876,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 14 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: M3XKM). AF_07/2020","DMT = 15 km","M3xKM",1.44,{"$f":"15*H11","v":8940},12873.6]
["3","DEMOLIÇÃO DE PAVIMENTAÇÃO ASFÁLTICA",null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K19)","v":16394.544499999996},null,null,null,null,null,{"$f":"K13*K$77/148*(1+$H$80)","v":502039.32468604593},null,null,null,{"$f":"(I13*I$77+K13*K$77+M13*M$77)*(1+$H$80)/148","v":502039.32468604587},null,{"$f":"U13/$H$79","v":1.7458516189023866E-2}]
["3.1","SINAPI",97636,"DEMOLIÇÃO PARCIAL DE PAVIMENTO ASFÁLTICO, DE FORMA MECANIZADA, SEM REAPROVEITAMENTO. AF_12/2017",0.25,"M2",12.79,null,null,{"$f":"E14*2980","v":745},{"$f":"$G14*J14","v":9528.5499999999993}]
["3.2","SINAPI",100983,"CARGA, MANOBRA E DESCARGA DE ENTULHO EM CAMINHÃO BASCULANTE 14 M³ - CARGA COM ESCAVADEIRA HIDRÁULICA (CAÇAMBA DE 0,80 M³ / 111 HP) E DESCARGA LIVRE (UNIDADE: M3). AF_07/2020","5 cm","M3",5.91,null,null,{"$f":"J14*0.05","v":37.25},{"$f":"$G15*J15","v":220.14750000000001}]
["3.3","SINAPI",95876,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 14 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: M3XKM). AF_07/2020","DMT = 15 km","M3xKM",1.44,null,null,{"$f":"15*J15","v":558.75},804.6]
["3.4","SICRO-M","4915669 M","REMOÇÃO MECANIZADA DE CAMADA GRANULAR"," 20 cm","M3",3.44,null,null,{"$f":"J14*0.2","v":149},512.55999999999995]
["3.5","SINAPI",100983,"CARGA, MANOBRA E DESCARGA DE ENTULHO EM CAMINHÃO\nBASCULANTE 14 M³ - CARGA COM ESCAVADEIRA HIDRÁULICA (CAÇAMBA DE 0,80 M³ / 111 HP) E DESCARGA LIVRE (UNIDADE: M3). AF_07/2020","x 1,3","M3",5.91,null,null,{"$f":"J17*1.3","v":193.70000000000002},1144.7670000000001]
["3.6","SINAPI",95876,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 14 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: M3XKM). AF_07/2020","DMT = 15 km","M3xKM",1.44,null,null,{"$f":"15*J18","v":2905.5000000000005},4183.92]
["4","PAVIMENTO FLEXÍVEL (RESTAURAÇÃO)",null,null,null,null,null,null,null,null,{"$f":"SUM(K21:K28)","v":42458.863658499999},null,null,null,null,null,null,null,{"$f":"M20*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I20*I$77+K20*K$77+M20*M$77)*(1+$H$80)/148","v":1300189.781914968},null,{"$f":"U20/$H$79","v":4.5214355211239905E-2}]
["4.1","SICRO-M","4011480 M","FRESAGEM DESCONTÍNUA DE REVESTIMENTO BETUMINOSO","20% ; 5 cm","M3",23,null,null,{"$f":"0.25*0.05*2980","v":37.25},{"$f":"J21*G21","v":856.75}]
["4.2","SINAPI",95876,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 10 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: TXKM). AF_07/2020","DMT = 15 km","TxKM",1.07,null,null,{"$f":"2.4*15*J21","v":1341},{"$f":"J22*G22","v":1434.8700000000001}]
["4.3","SINAPI-M",96402,"EXECUÇÃO DE PINTURA DE LIGAÇÃO COM EMULSÃO ASFÁLTICA RR-2C. AF_11/2019 (EXCLUSIVE PRODUTO BETUMINOSO)",0.15,"M2",0.69,null,null,{"$f":"0.15*2980","v":447},308.42999999999995]
["4.4","ANP","RR2C","EMULSÃO ASFÁLTICA CATIÔNICA RR2C","0,45 kg/m2","T",4384.74,null,null,{"$f":"J23*0.45/1000","v":0.20115},881.99045099999989]
["4.5","SINAPI",102330,"TRANSPORTE COM CAMINHÃO TANQUE DE TRANSPORTE DE MATERIAL ASFÁLTICO DE 30000 L, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30KM (UNIDADE: TXKM). AF_07/2020","DMT = 15 km","TxKM",0.95,null,null,{"$f":"15*J24","v":3.0172499999999998},2.8663874999999996]
["4.6","SICRO-M","4011463 M","CONCRETO ASFÁLTICO - FAIXA C - AREIA E BRITA COMERCIAIS (EXCLUSIVE MATERIAL BETUMINOSO)","2,4 T / m3","T",144.96,null,null,{"$f":"2.4*J21","v":89.399999999999991},12959.423999999999]
["4.7","ANP","CAP 30/45","CIMENTO ASFÁLTICO DE PETRÓLEO - CAP 30/45"," ","T",5018.8,null,null,{"$f":"0.056*J26","v":5.0063999999999993},25126.120319999998]
["4.8","SINAPI",95875,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 10 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: M3XKM). AF_07/2020","DMT = 15 km","M3xKM",1.59,null,null,{"$f":"15*J21","v":558.75},888.41250000000002]
["5","PISO INTERTRAVADO",null,null,null,null,null,null,{"$f":"SUM(I30:I32)","v":305612.40999999997},0,{"$f":"$I29*J29","v":0},null,null,null,{"$f":"I29*I$77/148*(1+$H$80)","v":7507368.4386602566},null,{"$f":"K29*K$77/148*(1+$H$80)","v":0},null,null,null,{"$f":"(I29*I$77+K29*K$77+M29*M$77)*(1+$H$80)/148","v":7507368.4386602556},null,{"$f":"U29/$H$79","v":0.26107021298636512}]
["5.1","SINAPI-C",100576,"REGULARIZAÇÃO E COMPACTAÇÃO DE SUBLEITO DE SOLO  PREDOMINANTEMENTE ARGILOSO. AF_11/2019"," ","M2",1.58,2980,{"$f":"G30*H30","v":4708.4000000000005}]
["5.2","SINAPI-C",96396,"EXECUÇÃO E COMPACTAÇÃO DE BASE E OU SUB BASE PARA PAVIMENTAÇÃO DE BRITA GRADUADA SIMPLES - EXCLUSIVE CARGA E TRANSPORTE. AF_11/2019","15 cm","M3",203.23,447,{"$f":"G31*H31","v":90843.81}]
["5.3","SINAPI-C",92399,"EXECUÇÃO DE VIA EM PISO INTERTRAVADO, COM BLOCO RETANGULAR COR NATURAL DE 20 X 10 CM, ESPESSURA 8 CM. AF_12/2015"," ","M2",70.489999999999995,2980,{"$f":"G32*H32","v":210060.19999999998}]
["6","CALÇADA",null,null,null,null,null,null,{"$f":"SUM(I34:I37)","v":67533.766000000003},0.25,{"$f":"$I33*J33","v":16883.441500000001},0.05,{"$f":"$I33*L33","v":3376.6883000000003},null,{"$f":"I33*I$77/148*(1+$H$80)","v":1658966.8705281543},null,{"$f":"K33*K$77/148*(1+$H$80)","v":517010.49510929466},null,{"$f":"M33*M$77/148*(1+$H$80)","v":2818165.9237327571},null,{"$f":"(I33*I$77+K33*K$77+M33*M$77)*(1+$H$80)/148","v":4994143.2893702062},null,{"$f":"U33/$H$79","v":0.17367231445923045}]
["6.1","SINAPI-C",100576,"REGULARIZAÇÃO E COMPACTAÇÃO DE SUBLEITO DE SOLO  PREDOMINANTEMENTE ARGILOSO. AF_11/2019"," ","M2",1.58,892,{"$f":"G34*H34","v":1409.3600000000001}]
["6.2","SINAPI-C",96622,"LASTRO COM MATERIAL GRANULAR, APLICADO EM PISOS OU LAJES SOBRE SOLO, ESPESSURA DE *5 CM*. AF_08/2017","5 cm","M3",176.01,44.6,{"$f":"G35*H35","v":7850.0460000000003}]
["6.3","SINAPI-C",96620,"LASTRO DE CONCRETO MAGRO, APLICADO EM PISOS, LAJES SOBRE SOLO OU RADIERS. AF_08/2017","8 cm","M3",513.91,0,{"$f":"G36*H36","v":0}]
["6.4","SINAPI-C",94990,"EXECUÇÃO DE PASSEIO (CALÇADA) OU PISO DE CONCRETO COM CONCRETO MOLDADO IN LOCO, FEITO EM OBRA, ACABAMENTO CONVENCIONAL, NÃO ARMADO. AF_07/2016","10 cm","M3",653.29999999999995,89.2,{"$f":"G37*H37","v":58274.36}]
["7","PISO PODOTÁTIL",null,null,null,null,null,null,{"$f":"SUM(I39:I40)","v":20004.705600000001},1,{"$f":"$I38*J38","v":20004.705600000001},0.05,{"$f":"$I38*L38","v":1000.2352800000001},null,{"$f":"I38*I$77/148*(1+$H$80)","v":491415.56603061408},null,{"$f":"K38*K$77/148*(1+$H$80)","v":612590.90729645838},null,{"$f":"M38*M$77/148*(1+$H$80)","v":834790.99383004731},null,{"$f":"(I38*I$77+K38*K$77+M38*M$77)*(1+$H$80)/148","v":1938797.4671571199},null,{"$f":"U38/$H$79","v":6.7422062980362116E-2}]
["7.1","SCO-RJ-M RV","RV 14.95.0050","PISO PODOTATIL DE CONCRETO - DIRECIONAL E ALERTA 40 X 40 - ALERTA"," ","M2",101.94,{"$f":"0.4*(42+42+96+86+86+86+4+4)","v":178.4},{"$f":"G39*H39","v":18186.096000000001}]
["7.2","SCO-RJ-M","RV 14.95.0050","PISO PODOTATIL DE CONCRETO - DIRECIONAL E ALERTA 40 X 40 - DIRECIONAL"," ","M2",101.94,{"$f":"H39*0.1","v":17.84},{"$f":"G40*H40","v":1818.6096}]
["8","MEIO-FIO",null,null,null,null,null,null,{"$f":"SUM(I42:I44)","v":32429.22},0.25,{"$f":"$I41*J41","v":8107.3050000000003},0.05,{"$f":"$I41*L41","v":1621.4610000000002},null,{"$f":"I41*I$77/148*(1+$H$80)","v":796623.74547672982},null,{"$f":"K41*K$77/148*(1+$H$80)","v":248264.65457602707},null,{"$f":"M41*M$77/148*(1+$H$80)","v":1353262.6440117792},null,{"$f":"(I41*I$77+K41*K$77+M41*M$77)*(1+$H$80)/148","v":2398151.0440645362},null,{"$f":"U41/$H$79","v":8.339617390073531E-2}]
["8.1","SINAPI-C",94273,"ASSENTAMENTO DE GUIA (MEIO-FIO) EM TRECHO RETO, CONFECCIONADA EM CONCRETO PRÉ-FABRICADO, DIMENSÕES 100X15X13X30 CM (COMPRIMENTO X BASE INFERIOR X BASE SUPERIOR X ALTURA), PARA VIAS URBANAS (USO VIÁRIO). AF_06/2016"," ","M",44.08,{"$f":"40+96+40+2+86+2+86+8+86+8","v":454},{"$f":"G42*H42","v":20012.32}]
["8.2","SINAPI-C",83693,"CAIACAO EM MEIO FIO",null,"M2",4.2,{"$f":"0.45*H42","v":204.3},{"$f":"G43*H43","v":858.06000000000006}]
["8.3","SINAPI-C",94263,"GUIA (MEIO-FIO) CONCRETO, MOLDADA  IN LOCO  EM TRECHO RETO COM EXTRUSORA, 13 CM BASE X 22 CM ALTURA. AF_06/2016"," ","M",25.46,{"$f":"+H42","v":454},{"$f":"G44*H44","v":11558.84}]
["9","MOBILIÁRIO URBANO",null,null,null,null,null,null,{"$f":"SUM(I46:I49)","v":11394.060000000001},1,{"$f":"$I45*J45","v":11394.060000000001},0.5,{"$f":"$I45*L45","v":5697.0300000000007},null,{"$f":"I45*I$77/148*(1+$H$80)","v":279895.06850262167},null,{"$f":"K45*K$77/148*(1+$H$80)","v":348912.78545935138},null,{"$f":"M45*M$77/148*(1+$H$80)","v":4754710.6472585071},null,{"$f":"(I45*I$77+K45*K$77+M45*M$77)*(1+$H$80)/148","v":5383518.5012204805},null,{"$f":"U45/$H$79","v":0.18721291398087897}]
["9.1","NOVACAP-M","4808 M","ASSENTAMENTO DE SINALIZADOR DE VAGA, BATE-RODA (40X16X8) CM EM CONCRETO CONF. DET E PROJETO","2 por vaga","UN.",70.069999999999993,0,{"$f":"$G46*H46","v":0}]
["9.2","RODOVIÁRIA3","-","PARACICLO TUBULAR EM AÇO GALVANIZADO CLASSE MÉDIA DN 50 MM"," ","UN.",302.45999999999998,6,{"$f":"$G47*H47","v":1814.7599999999998}]
["9.3","SINAPI - I",42440,"LIXEIRA DUPLA, COM CAPACIDADE VOLUMETRICA DE 60L*, FABRICADA EM TUBO DE ACO CARBONO, CESTOS EM CHAPA DE ACO E PINTURA NO PROCESSO ELETROSTATICO - PARA ACADEMIA AO AR LIVRE / ACADEMIA DA TERCEIRA IDADE - ATI"," ","UN.",1057.95,6,6347.7000000000007]
["9.4","RODOVIÁRIA3","-","BANCO EM CONCRETO FCK 25 MPA - PADRÃO SEDUH - NOVACAP -"," ","UN.",538.6,6,3231.6000000000004]
["10","LIMPEZA DE OBRA",null,null,null,null,null,null,{"$f":"I51","v":6426},0.5,{"$f":"$I50*J50","v":3213},0,{"$f":"$I50*L50","v":0},null,{"$f":"I50*I$77/148*(1+$H$80)","v":157854.68131621621},null,{"$f":"K50*K$77/148*(1+$H$80)","v":98389.580156756769},null,{"$f":"M50*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I50*I$77+K50*K$77+M50*M$77)*(1+$H$80)/148","v":256244.26147297301},null,{"$f":"U50/$H$79","v":8.9109445561221558E-3}]
["10.1","SINAPI-C",99814,"LIMPEZA DE SUPERFÍCIE COM JATO DE ALTA PRESSÃO. AF_04/2019"," ","M2",1.53,4200,{"$f":"$G51*H51","v":6426}]
["11","SINALIZAÇÃO HORIZONTAL E VERTICAL",null,null,null,null,null,null,{"$f":"SUM(I53:I56)","v":13264.419999999998},0.5,{"$f":"$I52*J52","v":6632.2099999999991},0.5,{"$f":"$I52*L52","v":6632.2099999999991},null,{"$f":"I52*I$77/148*(1+$H$80)","v":325840.45937510813},null,{"$f":"K52*K$77/148*(1+$H$80)","v":203093.79315637838},null,{"$f":"M52*M$77/148*(1+$H$80)","v":5535206.8537210338},null,{"$f":"(I52*I$77+K52*K$77+M52*M$77)*(1+$H$80)/148","v":6064141.1062525194},null,{"$f":"U52/$H$79","v":0.21088169884349578}]
["11.1","SINAPI-C",79467,"PINTURA COM TINTA A BASE DE BORRACHA CLORADA , DE FAIXAS DE DEMARCACAO, EM QUADRA POLIESPORTIVA, 5 CM DE LARGURA."," ","M",13.09,{"$f":"(148-1)*5","v":735},{"$f":"$G53*H53","v":9621.15}]
["11.2","SICRO-M",5213409,"PINTURA DE SETAS E ZEBRADOS - TERMOPLÁSTICO POR EXTRUSÃO"," ","M2",61.2,{"$f":"1.5*8","v":12},{"$f":"$G54*H54","v":734.40000000000009}]
["11.3","PMSP-M ","17.03.59","PICTOGRAMA VAGA EXCLUSIVA PNE/IDOSO E MOTO"," ","UN.",206.65,11,2273.15]
["11.4","SICRO-M",5213570,"FORNECIMENTO E IMPLANTAÇÃO DE PLACA EM AÇO - PELÍCULA I + I"," ","M2",317.86,2,635.72]
["12","DRENAGEM",null,null,null,null,null,null,{"$f":"SUM(I58:I61)","v":28925.660000000003},0.25,{"$f":"$I57*J57","v":7231.4150000000009},0,{"$f":"$I57*L57","v":0},null,{"$f":"I57*I$77/148*(1+$H$80)","v":710558.79881127039},null,{"$f":"K57*K$77/148*(1+$H$80)","v":221442.85271997302},null,{"$f":"M57*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I57*I$77+K57*K$77+M57*M$77)*(1+$H$80)/148","v":932001.65153124346},null,{"$f":"U57/$H$79","v":3.2410540611794943E-2}]
["12.1","SINAPI-C",94281,"EXECUÇÃO DE SARJETA DE CONCRETO USINADO, MOLDADA  IN LOCO  EM TRECHO RETO, 30 CM BASE X 15 CM ALTURA. AF_06/2016"," ","M",41,454,{"$f":"$G58*H58","v":18614}]
["12.2","SINAPI-C",90082,"ESCAVAÇÃO MECANIZADA DE VALA COM PROF. ATÉ 1,5 M (MÉDIA ENTRE MONTANTE E JUSANTE/UMA COMPOSIÇÃO POR TRECHO), COM ESCAVADEIRA HIDRÁULICA (0,8 M3), LARG. DE 1,5 M A 2,5 M, EM SOLO DE 1A CATEGORIA, EM LOCAIS COM ALTO NÍVEL DE INTERFERÊNCIA. AF_02/2021"," ","M3",7.39,10,{"$f":"$G59*H59","v":73.899999999999991}]
["12.3","SINAPI-C",100576,"REGULARIZAÇÃO E COMPACTAÇÃO DE SUBLEITO DE SOLO  PREDOMINANTEMENTE ARGILOSO. AF_11/2019"," ","M2",1.58,{"$f":"H58","v":454},717.32]
["12.4","SINAPI-C",97951,"CAIXA PARA BOCA DE LOBO COMBINADA COM GRELHA RETANGULAR, EM ALVENARIA COM TIJOLOS CERÂMICOS MACIÇOS, DIMENSÕES INTERNAS: 1,3X1X1,2 M. AF_12/2020"," ","UN.",2380.11,4,9520.44]
["13","ILUMINAÇÃO",null,null,null,null,null,null,{"$f":"SUM(I63:I66)","v":63051.880000000005},0.25,{"$f":"$I62*J62","v":15762.970000000001},0,{"$f":"$I62*L62","v":0},null,{"$f":"I62*I$77/148*(1+$H$80)","v":1548869.346994757},null,{"$f":"K62*K$77/148*(1+$H$80)","v":482699.03527032444},null,{"$f":"M62*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I62*I$77+K62*K$77+M62*M$77)*(1+$H$80)/148","v":2031568.3822650812},null,{"$f":"U62/$H$79","v":7.0648189786854332E-2}]
["13.1","SINAPI-C",100622,"POSTE DE AÇO CONICO CONTÍNUO CURVO SIMPLES, ENGASTADO, H=9M, INCLUSIVE LUMINÁRIA, SEM LÂMPADA - FORNECIMENTO E INSTALACAO. AF_11/2019"," ","UN.",2334.0500000000002,24,{"$f":"$G63*H63","v":56017.200000000004}]
["13.2","SINAPI-I",1020,"CABO DE COBRE, FLEXIVEL, CLASSE 4 OU 5, ISOLACAO EM PVC/A, ANTICHAMA BWF-B, COBERTURA PVC-ST1, ANTICHAMA BWF-B, 1 CONDUTOR, 0,6/1 KV, SECAO NOMINAL 10 MM2"," ","M",10.09,{"$f":"400*1.3","v":520},{"$f":"$G64*H64","v":5246.8}]
["13.3","SINAPI-C",101641,"LÂMPADA VAPOR METÁLICO 150 W - FORNECIMENTO E INSTALAÇÃO. AF_08/2020"," ","UN.",47.16,24,1131.8399999999999]
["13.4","SINAPI-C",101517,"ENTRADA DE ENERGIA ELÉTRICA, SUBTERRÂNEA, MONOFÁSICA, COM CAIXA DE EMBUTIR, CABO DE 10 MM2 E DISJUNTOR DIN 50A (NÃO INCLUSA MURETA DE ALVENARIA). AF_07/2020_P"," ","UN.",656.04,1,656.04]
["14","PAISAGISMO",null,null,null,null,null,null,{"$f":"SUM(I68:I72)","v":7713.3499999999985},0.25,{"$f":"$I67*J67","v":1928.3374999999996},0,{"$f":"$I67*L67","v":0},null,{"$f":"I67*I$77/148*(1+$H$80)","v":189478.43232655403},null,{"$f":"K67*K$77/148*(1+$H$80)","v":59050.20760209459},null,{"$f":"M67*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I67*I$77+K67*K$77+M67*M$77)*(1+$H$80)/148","v":248528.63992864866},null,{"$f":"U67/$H$79","v":8.6426323004553211E-3}]
["14.1","SICRO-M",4413946,"PLANTIO DE ARVORES ORNAMENTAIS COM PORTE DE 200 A 300 CM EM COVAS DE 60 X 60 X 60 CMlantio de árvores ornamentais com porte de 200 a 300 cm em covas de 60 x 60 x 60 cm"," ","UN.",69.11,9,{"$f":"$G68*H68","v":621.99}]
["14.2","SINAPI-C",101616,"PREPARO DE FUNDO DE VALA COM LARGURA MENOR QUE 1,5 M (ACERTO DO SOLO NATURAL). AF_08/2020"," ","M2",5.14,{"$f":"4*82","v":328},{"$f":"$G69*H69","v":1685.9199999999998}]
["14.3","SINAPI-C",100973,"CARGA, MANOBRA E DESCARGA DE SOLOS E MATERIAIS GRANULARES EM CAMINHÃO BASCULANTE 6 M³ - CARGA COM PÁ CARREGADEIRA (CAÇAMBA DE 1,7 A 2,8 M³ / 128 HP) E DESCARGA LIVRE (UNIDADE: M3). AF_07/2020"," ","M3",5.85,{"$f":"0.15*H69","v":49.199999999999996},287.81999999999994]
["14.4","SINAPI-C",97914,"TRANSPORTE COM CAMINHÃO BASCULANTE DE 6 M³, EM VIA URBANA PAVIMENTADA, DMT ATÉ 30 KM (UNIDADE: M3XKM). AF_07/2020","DMT = 15 km","M3XKM",1.93,{"$f":"15*H70","v":737.99999999999989},1424.3399999999997]
["14.5","SINAPI-C",98504,"PLANTIO DE GRAMA EM PLACAS. AF_05/2018"," ","M2",11.26,{"$f":"H69","v":328},3693.2799999999997]
["15","INTALAÇÕES HIDROSSANITÁRIAS / ESGOTO SANITÁRIO / IRRIGAÇÃO",null,null,null,null,null,null,{"$f":"I74","v":0},0.25,{"$f":"$I73*J73","v":0},0,{"$f":"$I73*L73","v":0},null,{"$f":"I73*I$77/148*(1+$H$80)","v":0},null,{"$f":"K73*K$77/148*(1+$H$80)","v":0},null,{"$f":"M73*M$77/148*(1+$H$80)","v":0},null,{"$f":"(I73*I$77+K73*K$77+M73*M$77)*(1+$H$80)/148","v":0},null,{"$f":"U73/$H$79","v":0}]
["15.1","RIZZO4","-","INTALAÇÕES HIDROSSANITÁRIAS / ESGOTO SANITÁRIO / IRRIGAÇÃO"," ","-","-","-",0]
["TOTAL PROJETO REFERENCIAL (R$)",null,null,null,null,null,null,null,{"$f":"I6+I9+I29+I33+I38+I41+I45+I50+I52+I57+I62+I67+I73","v":596806.99172719999},null,{"$f":"K6+K13+K29+K33+K38+K41+K45+K50+K52+K57+K62+K67+K73","v":111380.6017732},null,{"$f":"M6+M20+M33+M38+M41+M45+M50+M52+M57+M62+M67+M73","v":19097.38481236}]
["CUSTO REFERENCIAL POR VAGA (R$ / VAGA)",null,null,null,null,null,null,null,{"$f":"I75/148","v":4032.4796738324321},null,{"$f":"K75/148","v":752.57163360270272},null,{"$f":"M75/148","v":129.0363838672973}]
["NÚMERO DE VAGAS5",null,null,null,null,null,null,null,{"$f":"'[2]VAGAS CAPEX'!L19+'[2]VAGAS CAPEX'!M19","v":3074},null,{"$f":"'[2]VAGAS CAPEX'!K19","v":3832},null,{"$f":"'[2]VAGAS CAPEX'!K26+'[2]VAGAS CAPEX'!K29+'[2]VAGAS CAPEX'!K34","v":104439}]
["CUSTO PARCIAL SEM BDI (R$)",null,null,null,null,null,null,null,{"$f":"I76*I77","v":12395842.517360896},null,{"$f":"K76*K77","v":2883854.4999655569},null,{"$f":"M76*M77","v":13476430.894716663}]
["CUSTO TOTAL SEM BDI(R$)",null,null,null,null,null,null,{"$f":"I78+K78+M78","v":28756127.912043117}]
["BDI (%)6",null,null,null,null,null,null,0.1827]
["CUSTO TOTAL (R$)",null,null,null,null,null,null,{"$f":"H79*(1+H80)","v":34009872.481573395},null,null,null,null,null,null,{"$f":"O6+O9+O13+O20+O29+O33+O38+O41+O45+O50+O52+O57+O62+O67+O73","v":14660562.945282733},null,{"$f":"Q6+Q9+Q13+Q20+Q29+Q33+Q38+Q41+Q45+Q50+Q52+Q57+Q62+Q67+Q73","v":3410734.7171092639},null,{"$f":"S6+S9+S13+S20+S29+S33+S38+S41+S45+S50+S52+S57+S62+S67+S73","v":15938574.819181398},null,{"$f":"U6+U9+U13+U20+U29+U33+U38+U41+U45+U50+U52+U57+U62+U67+U73","v":35310062.26348836}]
[]
["REFERÊNCIAS DE FONTES E PREMISSAS:"]
["(1) - PROJETO SISTEMA VIÁRIO DE REQUALIFICAÇÃO-SIV-011/2020 - AV. HÉLIO PRATES - ETAPA 01 (EDITAL PUBLICADO PELA SECRETARIA DE ESTADO DE OBRAS E INFRAESTRUTURA DO DISTRITO FEDERAL)"]
["(2) - PROJETO VLT NA AVENIDA W3 - EM ANÁLISE PELO TRIBUNAL DE CONTAS DO DISTRITO FEDERAL (PROCESSO 00600.00008644/2020-20-e)"]
["(3) - PROJETO DE CONCESSÃO DA RODOVIÁRIA DO PLANO PILOTO - EM ANÁLISE PELO TRIBUNAL DE CONTAS DO DISTRITO FEDERAL (PROCESSO 00600.00002307/2021-18-e)"]
["(4) - PLANILHA APRESENTADA PELO GRUPO RIZZO, QUE TEVE OS ESTUDOS SELECIONADOS NO ÂMBITO DA PMI DO PROJETO ZONA VERDE"]
["(5) - PARA EFEITO DO CAPEX AS VAGAS DE MOTO FORAM CONSIDERADAS COM METADA DO CUSTO DAS VAGAS DE AUTOMÓVEL"]
["(6) - BDI UTILIZADO EM OBRAS SIMILARES PELA SECRETARIA DE OBRAS E INFRAESTRUTURA DO DISTRITO FEDERAL:"]
["(11,1% PARA FORNECIMENTO DE MATERIAS BETUMINSOS E OUTROS INSUMOS E 20,34% PARA OBRAS E SERVIÇOS DE ENGENHARIA) - MÉDIA PONDERADA"]
[]
["PROJETO REFERENCIAL:",null,null,null,null,null,null,null,null,"DETALHE VAGAS:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"148 VAGAS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ÁREA TOTAL PAV. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"2.980 m2"]

{"sheet":"EDIFICAÇÕES","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["EDIFICAÇÕES"]
["PES","UNIDADE","C. UNIT (R$)","QUANT.","CUSTO (R$)"]
["BOULEVARD ALTO PADRÃO (500 M2)","M2",0,{"$f":"5*500","v":2500},{"$f":"C3*D3","v":0}]
["ESPAÇO PARA ADMINISTRAÇÃO (20 M2)","M2",1637.81,2600,{"$f":"C4*D4","v":4258306}]
["ESPAÇO LAVADOR (70 M2)","M2",0,0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E3:E5)","v":4258306}]
[]
["REFERÊNCIAS"]
["CUSTO UNITÁRIO  (1637,81 R$/m2) - Custo unitário básico da construção civil (centro-oeste, abril/2021)"]
["5 BOULEVARD DE ALTO PADRÃO"]
["O CÁLCULO DA QUANTIDADE DE ESPAÇOS PARA ADMINISTRAÇÃO E ESPAÇOS LAVADOR CONSIDERA OS QUANTITATIVOS DETALHADOS NA ABA \"VAGAS CAPEX\""]

{"sheet":"EQUIPAMENTOS","index":7,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[20,2,20,4]]}
["EQUIPAMENTOS"]
["FONTE (S)","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["DIGICON / RIZZO","Parquimetro","UN.",30010,{"$f":"1141*(1-F21)","v":0},{"$f":"D3*E3","v":0}]
["RIZZO","Bobinas","UN.",1.37,560000,{"$f":"D4*E4","v":767200.00000000012}]
["RIZZO","Totens de Auto Atendimento","UN.",18306.09,130,2379791.7000000002]
["RIZZO","Identificação Ponto de Venda","UN.",6,2500,15000]
["RIZZO","Celular","UN.",700,1100,770000]
["RIZZO","Impressora","UN.",650,2500,1625000]
["RIZZO","Máquina de Cartão ","UN.",300,2500,750000]
["RIZZO","PABX Completo ","UN.",25000,1,25000]
["RIZZO","Telefone","UN.",100,160,16000]
["RIZZO","Computador","UN.",2500,50,125000]
["RIZZO","Computador Ponto de Atendimento ","UN.",1900,130,247000]
["RIZZO","Impressora","UN.",1000,130,130000]
["RIZZO","Cadeira de Escritorio ","UN.",100,280,28000]
["RIZZO","Mesa de Escritorio","UN.",500,140,70000]
["RIZZO","Infraestrura e adequação dos escritórios","UN.",350000,1,350000]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F17)","v":7297991.7000000002}]
[]
["FONTES (PARQUÍMETRO):"]
["RIZZO  - R$ 30.010,00",null,"REDUÇÃO QUANT. DE PARQUÍMETROS",null,null,1]
["DIGICON - R$ 30.421,86"]
["UTILIZADA COTAÇÃO DA RIZZO POR SER MAIS VANTAJOSA"]

{"sheet":"CCO","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["CCO"]
["FONTE","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Monitor de Video Wall","UN.",12000,10,{"$f":"D3*E3","v":120000}]
["RIZZO","Servidor","UN.",28000,3,{"$f":"D4*E4","v":84000}]
["RIZZO","Camera fixa OCR ","UN.",4691,72,337752]
["RIZZO","Sistema OCR","UN.",5490,72,395280]
["RIZZO","Piso elevado","UN.",40,360,14400]
["RIZZO","Estação de Monitoramento","UN.",13000,16,208000]
["RIZZO","Drone Matrice M210 ","UN.",225000,1,225000]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F9)","v":1384432}]

{"sheet":"SISTEMAS","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5],[10,4,10,5]]}
["SISTEMAS"]
["FONTE (S)","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Sistema de Gerenciamento De Chamados","UN.",10000,2,{"$f":"D3*E3","v":20000}]
["RIZZO / SERBET","Sistema de Aplicativo","UN.",5000000,1,{"$f":"D4*E4","v":5000000}]
["RIZZO / SERBET","Sistema de Gestao de Zona Verde","UN.",7500000,1,7500000]
["RIZZO","Instalação Parquimetros ","UN.",0,1141,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F6)","v":12520000}]
["COTAÇÕES:"]
["RIZZO (SISTEMA DE APLICATIVO) - R$ 5.000.000,00"]
["RIZZO (SISTEMA DE GESTÃO) - R$ 7.500.000,00"]
["SERBET (SISTEMA DE APLICATIVO + SISTEMA DE GESTÃO) - R$",null,null,{"$f":"0.04*RECEITA!J34","v":3027665.3817600003},"(por ano)"]
["UTILIZADAS COTA;ÓES DA RIZZO POR SEREM MAIS VANTAJOSAS",null,null,{"$f":"(D11+F4+F5)/2","v":7763832.6908800006},"(ano 1)"]

{"sheet":"VEíCULOS","index":10,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["SISTEMAS"]
["FONTE ","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Moto Elétrica com OCR","UN.",39000,37,{"$f":"D3*E3","v":1443000}]
["RIZZO","Carro Elétrico ","UN.",150000,10,{"$f":"D4*E4","v":1500000}]
["RIZZO","Carregador de Carro Elétrico","UN.",8000,10,80000]
["RIZZO","Ônibus Elétrico  ","UN.",350000,1,350000]
["RIZZO","Van FIAT Ducato 15 pessoas","UN.",160000,2,320000]
["RIZZO","Van FIAT Ducato Cargo","UN.",130000,2,260000]
["RIZZO","Pickup FIAT Strada","UN.",43000,1,43000]
["RIZZO","Fiorino","UN.",60000,11,{"$f":"D10*E10","v":660000}]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F10)","v":4656000}]

{"sheet":"COMUNICAÇÃO","index":11,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,5],[18,0,18,4],[35,0,35,4],[52,0,52,4],[56,0,56,1]]}
["COMUNICAÇÃO"]
["FONTE ","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","TV ABERTA (Globo, SBT, Record)","UN.",2608510.29,0,{"$f":"D3*E3","v":0}]
["RIZZO","TV FECHADA (Globosat (Gnt, Sportv,Multishow, Globo News,Megapix,etc)","UN.",632055,0,{"$f":"D4*E4","v":0}]
["RIZZO","RÁDIO (CBN, Band News, Antena1, JovemPan, Transamérica,etc)","UN.",1066744.2,0,0]
["RIZZO","INTERNET (Facebook, Instagram,Globo.com, Metrópoles,etc)","UN.",420000,{"$f":"(1-$C$57)","v":1},420000]
["RIZZO","WIFI (DS Wifi, Mob R2, Mob TV )","UN.",350000,1,350000]
["RIZZO","OOH (JC Decor, Alumi, Neon Vegas, WS Painéis,etc)","UN.",1105000,1,1105000]
["RIZZO","DOOH (Idéia, Select, Ws, Vip Channel, Tv Minuto)","UN.",448000,1,448000]
["RIZZO","JORNAL (Jornal de Brasília, Correio Braziliense)","UN.",329113.98,1,329113.98]
["RIZZO","REVISTA (Encontro)","UN.",96600,1,96600]
["RIZZO","Assessoria de Imprensa","UN.",100000,0,0]
["RIZZO","Redes Sociais (Gestão, monitoramento, produção de conteúdo - video e posts, cachê de influenciadores)","UN.",1000000,0,0]
["RIZZO","Produção de Campanha (Produção de foto, filme, spot, lona, adesivo, vinheta, banner de internet e criação / finalização)","UN.",900000,0,0]
["RIZZO","Material de Apoio (sites, impressos etc)","UN.",150000,1,150000]
["RIZZO","Endomarketing / Público Interno","UN.",150000,0,0]
["RIZZO","Ações Mobile (envio de whatsapp e SMS)","UN.",350000,0,0]
["RIZZO","Eventos / Patrocinios","UN.",400000,0,0]
["TOTAL 1ª ETAPA",null,null,null,null,{"$f":"SUM(F3:F18)","v":2898713.98}]
["RIZZO","TV ABERTA (Globo, SBT, Record)","UN.",2086808.23,0,{"$f":"D20*E20","v":0}]
["RIZZO","TV FECHADA (Globosat (Gnt, Sportv,Multishow, Globo News,Megapix,etc)","UN.",505644,0,{"$f":"D21*E21","v":0}]
["RIZZO","RÁDIO (CBN, Band News, Antena1, JovemPan, Transamérica,etc)","UN.",853395.36,0,0]
["RIZZO","INTERNET (Facebook, Instagram,Globo.com, Metrópoles,etc)","UN.",336000,{"$f":"(1-$C$57)","v":1},336000]
["RIZZO","WIFI (DS Wifi, Mob R2, Mob TV )","UN.",280000,1,280000]
["RIZZO","OOH (JC Decor, Alumi, Neon Vegas, WS Painéis,etc)","UN.",884000,1,884000]
["RIZZO","DOOH (Idéia, Select, Ws, Vip Channel, Tv Minuto)","UN.",358400,1,358400]
["RIZZO","JORNAL (Jornal de Brasília, Correio Braziliense)","UN.",263291.18,1,263291.18]
["RIZZO","REVISTA (Encontro)","UN.",77280,1,77280]
["RIZZO","Assessoria de Imprensa","UN.",80000,0,0]
["RIZZO","Redes Sociais (Gestão, monitoramento, produção de conteúdo - video e posts, cachê de influenciadores)","UN.",800000,0,0]
["RIZZO","Produção de Campanha (Produção de foto, filme, spot, lona, adesivo, vinheta, banner de internet e criação / finalização)","UN.",720000,0,0]
["RIZZO","Material de Apoio (sites, impressos etc)","UN.",120000,1,120000]
["RIZZO","Endomarketing / Público Interno","UN.",120000,0,0]
["RIZZO","Ações Mobile (envio de whatsapp e SMS)","UN.",280000,0,0]
["RIZZO","Eventos / Patrocinios","UN.",320000,0,0]
["TOTAL 2ª ETAPA",null,null,null,null,{"$f":"SUM(F20:F35)","v":2318971.1800000002}]
["RIZZO","TV ABERTA (Globo, SBT, Record)","UN.",1043404.12,0,{"$f":"D37*E37","v":0}]
["RIZZO","TV FECHADA (Globosat (Gnt, Sportv,Multishow, Globo News,Megapix,etc)","UN.",252822,0,{"$f":"D38*E38","v":0}]
["RIZZO","RÁDIO (CBN, Band News, Antena1, JovemPan, Transamérica,etc)","UN.",426697.68,0,0]
["RIZZO","INTERNET (Facebook, Instagram,Globo.com, Metrópoles,etc)","UN.",168000,0,0]
["RIZZO","WIFI (DS Wifi, Mob R2, Mob TV )","UN.",140000,0,0]
["RIZZO","OOH (JC Decor, Alumi, Neon Vegas, WS Painéis,etc)","UN.",442000,0,0]
["RIZZO","DOOH (Idéia, Select, Ws, Vip Channel, Tv Minuto)","UN.",179200,0,0]
["RIZZO","JORNAL (Jornal de Brasília, Correio Braziliense)","UN.",131645.59,0,0]
["RIZZO","REVISTA (Encontro)","UN.",38640,0,0]
["RIZZO","Assessoria de Imprensa","UN.",40000,0,0]
["RIZZO","Redes Sociais (Gestão, monitoramento, produção de conteúdo - video e posts, cachê de influenciadores)","UN.",400000,0,0]
["RIZZO","Produção de Campanha (Produção de foto, filme, spot, lona, adesivo, vinheta, banner de internet e criação / finalização)","UN.",360000,0,0]
["RIZZO","Material de Apoio (sites, impressos etc)","UN.",60000,0,0]
["RIZZO","Endomarketing / Público Interno","UN.",60000,0,0]
["RIZZO","Ações Mobile (envio de whatsapp e SMS)","UN.",140000,0,0]
["RIZZO","Eventos / Patrocinios","UN.",160000,0,0]
["TOTAL 3ª ETAPA",null,null,null,null,{"$f":"SUM(F37:F52)","v":0}]
[null,null,null,null,"TOTAL",{"$f":"F19+F36+F53","v":5217685.16}]
[]
[]
["PERCENTUAL DE COMPARTILHAMENTO DO PLANO DE COMUNICAÇÃO COM A PROPAGANDA INSTITUCIONAL",null,0]

{"sheet":"UNIFORMES","index":12,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["UNIFORMES"]
["FONTE ","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Uniforme completo (2 calças / 3 camisas/ 1 Jaqueta)","UN.",360,1340,{"$f":"D3*E3","v":482400}]
["RIZZO","Uniforme (3 camisas sociais)","UN.",60,183,{"$f":"D4*E4","v":10980}]
["RIZZO","Botinas","UN.",40,1523,60920]
["RIZZO","Bonés","UN.",20,1523,30460]
["RIZZO","Pochetes","UN.",20,1523,30460]
["RIZZO","Squeeze","UN.",15,1523,22845]
["RIZZO","Capa de Chuva","UN.",50,1523,76150]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F9)","v":714215}]

{"sheet":"OPEX","index":13,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,7,6,8],[6,9,6,10],[12,7,12,8],[12,9,12,10],[7,9,7,10],[8,7,8,8],[8,9,8,10],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[7,7,7,8],[21,1,21,4],[21,5,21,6],[21,7,21,10],[22,1,22,4],[22,5,22,6],[22,7,22,10],[19,1,19,4],[19,5,19,6],[19,7,19,10],[20,1,20,4],[20,5,20,6],[20,7,20,10],[14,0,15,10],[17,1,17,4],[17,5,17,6],[17,7,17,10],[18,1,18,4],[18,5,18,6],[18,7,18,10],[0,0,1,10],[3,0,5,0],[3,1,3,2],[3,3,3,4],[3,7,3,8],[3,9,3,10],[4,7,4,8],[4,9,4,10],[5,7,5,8],[5,9,5,10]]}
["COMPARATIVO OPEX"]
[]
[]
["OPEX TOTAL","RIZZO",null,"REVISÃO SEMOB",null,null,"PESSOAL DE CAMPO","PROPOSTA RIZZO",null,"PROPOSTA SEMOB"]
[null,"R$","%","R$","%",null,"Gerente Operacional",1,null,{"$f":"'CAMPO OPEX'!E3","v":1}]
[null,{"$f":"SUM(B7:B11)","v":59147950},{"$f":"B6/B$6","v":1},{"$f":"SUM(D7:D11)","v":28093818.506354254},1,null,"Coordenador Rotativo",10,null,{"$f":"'CAMPO OPEX'!E4","v":6}]
["Administrativo",1149012,1.9426066330278564E-2,{"$f":"'ADMINISTRATIVO OPEX'!F9","v":541986.26697097206},1.9292011402735648E-2,null,"Supervisor Rotativo",80,null,{"$f":"'CAMPO OPEX'!E5","v":0}]
["Pessoal de Campo",45044918,0.76156346923266149,{"$f":"'CAMPO OPEX'!F12","v":25705040.039383281},0.9149713853803576,null,"Operador de Drone",1,null,{"$f":"'CAMPO OPEX'!E6","v":1}]
["CCO",610792,1.0326511738783847E-2,{"$f":"'CCO OPEX'!F8","v":610792.19999999995},2.174115988760485E-2,null,"Auxiliar Administrativo",85,null,58]
["Custos Fixos",1236000,2.089675128216616E-2,{"$f":"'CUSTO FIXO OPEX'!F11","v":1236000},4.3995443329301845E-2,null,"Menor Aprendiz",85,null,58]
["Comunicação",11107228,0.18778720141610994,{"$f":"'COMUNICAÇÃO OPEX'!F8","v":0},0,null,"Lider Rotativo",100,null,{"$f":"'CAMPO OPEX'!E9","v":64}]
[null,null,null,null,null,null,"Monitor Rotativo",1005,null,{"$f":"'CAMPO OPEX'!E10","v":638}]
[null,null,null,null,null,null,"Motorista Fiscalização - Moto",40,null,{"$f":"'CAMPO OPEX'!E11","v":39}]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:I13)","v":1407},null,{"$f":"SUM(J5:K13)","v":865}]
["CRONOGRAMA OPEX"]
[]
[]
["ITEM","ANO 1",null,null,null,"ANO 2",null,"ANO 3 - ANO 20"]
["Administrativo","Proporcional ao espaço para administração",null,null,null,1,null,1]
["Pessoal de Campo","Proporcional à receita",null,null,null,"Proporcional à receita",null,1]
["CCO",1,null,null,null,1,null,1]
["Custos Fixos","Proporcional ao espaço para administração",null,null,null,1,null,1]
["Comunicação","-",null,null,null,"-",null,"100% a partir do ano 4"]
[]
["OBS.: A partir do 5º prevê-se uma redução de 1% ao ano nos custos operacionais (ganho de eficiência)"]

{"sheet":"ADMINISTRATIVO OPEX","index":14,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["ADMINISTRATIVO OPEX"]
["FONTE","PROFISSIONAL","SALÁRIO","ENCARGOS","QUANT.","CUSTO ANUAL (R$)"]
["RIZZO","Coordenador de Serviços",5147.2700000000004,1.8066105425946177,1,{"$f":"C3*D3*E3*12","v":111589.34697097199}]
["RIZZO","Técnico Parquimetro",1435.51,1.8066105425946177,0,{"$f":"C4*D4*E4*12","v":0}]
["RIZZO","Motorista",1558.46,1.8066103717772675,2,67572.72]
["RIZZO","Coletor Parquimetro",1115.73,1.8066109184121606,0,0]
["RIZZO","Serviço Geral",1115.73,1.8066109184121606,4,96753.12]
["RIZZO","Aux Limpeza",1115.73,1.8066109184121606,11,266071.08]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F8)","v":541986.26697097206}]

{"sheet":"CAMPO OPEX","index":15,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[13,2,13,3],[13,4,13,5],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[18,2,18,3],[0,0,0,5],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3]]}
["PESSOAL DE CAMPO OPEX"]
["FONTE","PROFISSIONAL","SALÁRIO","ENCARGOS","QUANT.","CUSTO ANUAL (R$)"]
["RIZZO","Gerente Operacional",17733.59,1.8066105425946177,1,{"$f":"C3*D3*E3*12","v":384452.28782460588}]
["RIZZO","Coordenador Rotativo",5500,1.8066105425946177,{"$f":"ROUND(E9/10,0)","v":6},{"$f":"C4*D4*E4*12","v":715417.77486746851}]
["RIZZO","Supervisor Rotativo",3100,1.8066105425946177,0,0]
["RIZZO","Operador de Drone",6250,1.8066105425946177,1,135495.79069459633]
["RIZZO","Auxiliar Administrativo",1400,1.8066105425946177,58,1760361.3127041957]
["RIZZO","Menor Aprendiz",676,1.8066105425946177,58,850003.0338485972]
["RIZZO","Lider Rotativo",2021.5,1.8066105425946177,{"$f":"ROUND(E10/10,0)","v":64},2804784.546704655]
["RIZZO","Monitor Rotativo",1300,1.81,{"$f":"ROUND(('VAGAS RECEITA'!I26*0.2+'VAGAS RECEITA'!I26*0.8*0.25+'VAGAS RECEITA'!I29+'VAGAS RECEITA'!I34+'VAGAS RECEITA'!I19*0.05+'VAGAS RECEITA'!I19*0.95*0.25)/100,0)","v":638},18014568]
["RIZZO","Motorista Fiscalização - Moto",1230,1.8066105425946177,{"$f":"ROUND(('VAGAS RECEITA'!I35/3000),0)","v":39},1039957.2927391657]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F11)","v":25705040.039383281}]
[]
[null,"PROFISSIONAL","PROPOSTA RIZZO",null,"PROPOSTA SEMOB"]
[null,"Gerente Operacional",1,null,1]
[null,"Coordenador Rotativo","1 cada 8 supervisores",null,"1 cada 10 líders"]
[null,"Supervisor Rotativo","1 a cada 12 monitores",null,"-"]
[null,"Operador de Drone",1,null,1]
[null,"Auxiliar Administrativo","1 a cada 1142 vagas",null,"1 a cada 2000 vagas"]
[null,"Menor Aprendiz","-",null,"5% da quant. de profissionais"]
[null,"Lider Rotativo","1 a cada 10 monitores",null,"1 a cada 10 monitores"]
[null,"Monitor Rotativo","1 a cada 97 vagas",null,"1 a cada 100 vagas*"]
[null,"Motorista Fiscalização - Moto","-",null,"1 a cada 3000 vagas"]
[null,"* Para fins deste cálculo as vagas isentas contam como 0,25"]

{"sheet":"CCO OPEX","index":16,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["OPEX CCO"]
["FONTE","PROFISSIONAL","SALÁRIO","ENCARGOS","QUANT.","CUSTO ANUAL (R$)"]
["RIZZO","Coordenador Suporte Operacional",3900,1.8066102564102564,1,{"$f":"C3*D3*E3*12","v":84549.36}]
["RIZZO","Supervisor de Atendimento",2400,1.8066125,1,{"$f":"C4*D4*E4*12","v":52030.44}]
["RIZZO","Analista de Suporte/ Operacional",1946.49,1.8066108739320519,3,126595.79999999999]
["RIZZO","Analista de atendimento ",1250,1.806611,8,216793.32]
["RIZZO","Técnicos câmeras",2011.49,1.8066110196918703,3,130823.28000000003]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F7)","v":610792.19999999995}]

{"sheet":"CUSTO FIXO OPEX","index":17,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["CUSTO FIXO OPEX"]
["FONTE ","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Escritorio Apoio ","UN.",0,3,{"$f":"D3*E3*12","v":0}]
["RIZZO","Escritorio Central ","UN.",0,1,{"$f":"D4*E4*12","v":0}]
["RIZZO","Conta de Água","UN.",5000,1,60000]
["RIZZO","Conta de Energia","UN.",10000,1,120000]
["RIZZO","Conta de Telefone","UN.",2000,1,24000]
["RIZZO","Chip de Dados ","UN.",30,2200,792000]
["RIZZO","Material de Escritório","UN.",5000,1,60000]
["RIZZO","Despesas básicas (protetor, produto de higiene,agua e etc) ","UN.",15000,1,180000]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F10)","v":1236000}]

{"sheet":"COMUNICAÇÃO OPEX","index":18,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5],[9,1,9,2]]}
["COMUNICAÇÃO OPEX"]
["FONTE ","ITEM","UNIDADE","C. UNIT. (R$)","QUANT.","CUSTO (R$)"]
["RIZZO","Redes Sociais (Gestão, monitoramento, produção de conteúdo - video e posts, cachê de influenciadores)","UN.",100000,1,{"$f":"D3*E3*12*(1-$D$10)","v":0}]
["RIZZO","Produção de Campanha (Produção de foto, filme, spot, lona, adesivo, vinheta, banner de internet e criação / finalização)","UN.",90000,1,{"$f":"D4*E4*12*(1-$D$10)","v":0}]
["RIZZO","Material de Apoio (sites, impressos etc)","UN.",15000,1,0]
["RIZZO","Campanha Publicitária mídia","UN.",705602.35,1,0]
["RIZZO","Endomarketing / Público Interno","UN.",15000,1,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F3:F7)","v":0}]
[]
[null,"PERCENTUAL DE COMPARTILHAMENTO DO PLANO DE COMUNICAÇÃO COM A PROPAGANDA INSTITUCIONAL",null,1]

{"sheet":"WACC","index":19,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[22,0,22,2],[23,0,23,2],[24,0,24,2]]}
["WACC"]
["Recálculo DIGEM3"]
["Data-Base","2021-01-01","Atualização"]
["Percentual de capital próprio (E)",0.35,0.35]
["Percentual de capital de terceiros (D)",0.65,0.65]
["Custo de capital de terceiros (Kd)",9.8900000000000002E-2,9.8900000000000002E-2]
["Tributos (IR + CSLL)",0.34,0.34]
["Taxa Livre de Risco - Tbond (RF)",4.9500000000000002E-2,"Média Geométrica do Retorno Histórico (US T. Bond 1928-2020)1"]
["Taxa de Retorno do Mercado - S&P500 (RM)",9.7900000000000001E-2,"Média Geométrica do Retorno Histórico (S&P 500 1928-2020)1"]
["Beta Desalavancado (β)",0.98,0.98]
["Beta Realavancado (βL)",{"$f":"B10*(1+(1-B7)*(B5/B4))","v":2.1812},"βL=(β)*(1+(1-T)*(D/E))"]
["Prêmio de Risco de Mercado (PRM)",4.8399999999999999E-2,"PRM = Rm - Rf (S&P 500 - US T. Bond 1928-2020)"]
["Risco País (RP)",2.5999999999999999E-2,2.5999999999999999E-2]
["Prêmio de Liquidez (PTL)",0,"Removido. Tal prêmio de risco não costuma fazer parte do cálculo do WACC das licitações de concessões, conforme apontado pelo Corpo Técnico quanto da análise da PPP do Veículo Leve sobre Trilhos (EDOC nº EECOB618 - Processo nº 8.644/2020). "]
["Custo do Capital Próprio obtido pelo método CAPM em UR$ (KeU$)",{"$f":"B8+B11*B12+B13","v":0.18107007999999999},"KeU$ = RF+βL*(RM - RF)+RP. No projeto, somou-se ao final o Prêmio de Liquidez. Nesse cálculo, foi desconsiderado."]
["Inflação Projetada BR",3.7199999999999997E-2,"Expectativa média para o IPCA de 2021 a 2024 + Boletim Focus/ Bacen de 9/4/20211 (4,85%; 3,53%; 3,25% e 3,25%)"]
["Inflação Projetada US",2.2800000000000001E-2,"Expectativa média para a inflação americana (US CPI) de 2021 a 2024 (2,2%; 2,3%; 2,3% e 2,3%)2."]
["Diferencial de Inflação (Δi)",{"$f":"(1+B16)/(1+B17)-1","v":1.4078998826750011E-2}]
["Conversão de Ke para Termos Brasileiros",{"$f":"(1+B15)*(1+B16)/(1+B17)-1","v":0.19769836427062959},"KeR$ = (1 + KeU$) x "]
["WACC Nominal",{"$f":"(1-B7)*B6*B5+B4*B19","v":0.11162252749472035},"KD = (1 - T) x (%D) + KE x (%E)"]
["Inflação Projetada BR",3.7199999999999997E-2,"Expectativa média para o IPCA de 2021 a 2024 - Boletim Focus/ Bacen de 9/4/2021."]
["WACC Real",{"$f":"(1+B20)/(1+B21)-1","v":7.175330456490614E-2},"Relação de Fisher: "]
["1. http://pages.stern.nyu.edu/~adamodar/"]
["2. https://www.bcb.gov.br/publicacoes/focus"]
["3. https://pt.knoema.com/kyaewad/us-inflation-forecast-2020-2021-and-long-term-to-2060-data-and-charts"]
["TIR =",{"$f":"'[3]FLUXO DE CAIXA'!C43","v":0.11425337710987038}]

{"sheet":"RESSARCIMENTO","index":20,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,4]]}
["DEMONSTRATIVO","VALOR (R$)","DATA-BASE","ÍNDICE CONSULTORIA DNIT"]
[null,null,null,"MÊS","Ic"]
["VALOR DEFINIDO PELA COMISSÃO TÉCNICA*",4922921.32,"JUNHO/2019","ABRIL/2019",226.119]
["VALOR REAJUSTADO",{"$f":"B3*E4/E3","v":5352187.5013754712},"ABRIL/2021","FEVEREIRO/2021",245.83600000000001]
["* Nota Técnica SEI-GDF nº 1/2019 - SEMOB/GAB/CTZV, de 20 de agosto de 2019 (SEI nº 26935022)"]

{"sheet":"FLUXO DE CAIXA 15 ANOS","index":21,"n_rows":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,2,2,3],[29,1,29,2],[40,5,40,6]]}
[]
[]
[]
[null,"DRE","Total","Pré-Oper"," 1º Ano","2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano","11º ano","12º ano","13º ano","14º ano","15º ano"]
[null,"Receita Tarifária Bruta",{"$f":"SUM(D5:S5)","v":1025473933.5552003},null,{"$f":"RECEITA!J36","v":16002823.968},{"$f":"RECEITA!J37","v":43982260.0704},{"$f":"RECEITA!J38","v":57189234.988799997},{"$f":"RECEITA!J34","v":75691634.544},{"$f":"H5","v":75691634.544},{"$f":"I5","v":75691634.544},{"$f":"J5","v":75691634.544},{"$f":"K5","v":75691634.544},75691634.544,75691634.544,75691634.544,75691634.544,75691634.544,75691634.544,75691634.544]
[0.18,"Outorga Mensal",-184585308.03993604,null,{"$f":"-E5*$A$6","v":-2880508.3142399997},{"$f":"-F5*$A$6","v":-7916806.8126719994},-10294062.297983998,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792,-13624494.21792]
[17850000,"Outorga Inicial",-17850000,{"$f":"-A7","v":-17850000}]
[0,"VF Regulatória",0,null,{"$f":"-$A$8*E5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,"VF de Trânsito",0,null,{"$f":"-E5*$A$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Receita Após Repasse",840888625.51526392,null,{"$f":"E5+E6+(E8+E9)","v":13122315.653760001},36065453.257728003,46895172.690816,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002]
[{"$f":"D2","v":0},"Receita Após Participação",840888625.51526392,null,{"$f":"E10*(1-$A$11)","v":13122315.653760001},36065453.257728003,46895172.690816,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002,62067140.326080002]
[null,"Tributos sobre Receita",-128951291.23040339,null,{"$f":"SUM(E13:E15)","v":-1964747.8377752912},{"$f":"SUM(F13:F15)","v":-5466179.3627253706},-6850126.8799851155,-9486718.8166011162,-9499712.2076603044,-9512575.664808901,-9525310.4873860124,-9537917.9617373515,-9550399.3613451775,-9562755.946956927,-9574988.9667125568,-9587099.6562706325,-9599089.2389331255,-9610958.9257689938,-9622709.9157365039]
[1.6500000000000001E-2,"PIS",-13856003.352633685,null,{"$f":"(-E5*$A$13)-0.5*$A$13*E19","v":-207740.64378045735},{"$f":"(-F5*$A$13)-0.5*$A$13*F19","v":-582773.99920960667},{"$f":"(-G5*$A$13)-0.5*$A$13*G19","v":-711848.37463777734},-1017137.9672985774,-1019455.7073253517,-1021750.2699518581,-1024021.8869520995,-1026270.7877823386,-1028497.1996042752,-1030701.3473079924,-1032883.4535346725,-1035043.7386990858,-1037182.4210118549,-1039299.7165014964,-1041395.8390362414]
[7.5999999999999998E-2,"COFINS",-63821591.200009696,null,{"$f":"(-E5*$A14)-0.5*$A$14*E19","v":-956865.99559483374},{"$f":"(-F5*$A14)-0.5*$A$14*F19","v":-2684292.3599957637},-3278816.7559073381,-4684999.1221025381,-4695674.7731349524,-4706243.6676570429,-4716706.8732339125,-4727065.4467550134,-4737320.4345409032,-4747472.8724489342,-4757523.7859778851,-4767474.190371546,-4777325.0907212701,-4787077.4820674974,-4796732.3495002631]
[0.05,"ISS",-51273696.677760012,null,{"$f":"-E5*$A15","v":-800141.19840000011},-2199113.0035200003,-2859461.7494399999,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001]
[{"$f":"J2","v":0},"Receita Líquida",711937334.28486061,null,{"$f":"E11+E12","v":11157567.815984709},{"$f":"F11+F12","v":30599273.895002633},40045045.810830884,52580421.509478882,52567428.118419699,52554564.661271103,52541829.838693991,52529222.364342652,52516740.964734823,52504384.379123077,52492151.359367445,52480040.669809371,52468051.087146878,52456181.400311008,52444430.410343498]
[null,null,null,null,{"$f":"E16/E5","v":0.69722492969340333},0.69571854302221048,0.70021999452647599,0.69466621808667073,0.69449455590580411,0.69432461034674609,0.69415636424327853,0.69398980060084581,0.69382490259483731,0.69366165356888898,0.69350003703320007,0.69334003666286803,0.69318163629623941,0.69302481993327703,0.69286957173394426]
[]
[null,"CUSTOS E DESPESAS OPERAÇÃO",{"$f":"SUM(D19:S19)","v":-371432309.21540791},null,{"$f":"-(OPEX!D7+OPEX!D10)*('VAGAS CAPEX'!O34+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!N29)/('VAGAS CAPEX'!N35+'VAGAS CAPEX'!O35)-OPEX!D8*'FLUXO DE CAIXA 15 ANOS'!E5/'FLUXO DE CAIXA 15 ANOS'!H5-OPEX!D9","v":-6824963.8413991118},{"$f":"-OPEX!D7-OPEX!D8*'FLUXO DE CAIXA 15 ANOS'!F5/'FLUXO DE CAIXA 15 ANOS'!H5-OPEX!D9-OPEX!D10","v":-17325247.509332526},{"$f":"-OPEX!D7-OPEX!D8-OPEX!D9-OPEX!D10","v":-28093818.506354254},{"$f":"-OPEX!D6","v":-28093818.506354254},{"$f":"0.99*H19","v":-27812880.321290713},-27534751.518077806,-27259404.002897028,-26986809.962868057,-26716941.863239378,-26449772.444606982,-26185274.720160913,-25923421.972959302,-25664187.753229707,-25407545.875697412,-25153470.416940436]
[null,"DEPRECIAÇÃO",-100411514.20888461,null,{"$f":"-E59","v":-5999063.0320900278},-6918377.0283067543,-6918377.0283067543,-6918377.0283067543,-6918377.0283067543,-6673894.3063567542,{"$f":"J20","v":-6673894.3063567542},-6673894.3063567542,-6673894.3063567542,-6673894.3063567542,-6673894.3063567542,-6673894.3063567542,-6673894.3063567542,-6673894.3063567542,-6673894.3063567542]
[null,"Lucro Bruto",240093510.86056817,null,{"$f":"E16+E19+E20","v":-1666459.0575044304},{"$f":"F16+F19+F20","v":6355649.3573633526},{"$f":"G16+G19+G20","v":5032850.2761698756},{"$f":"H16+H19+H20","v":17568225.974817872},17836170.76882223,18345918.836836543,18608531.529440209,18868518.095117841,19125904.795138691,19380717.62815934,19632982.332849778,19882724.390493315,20129969.027560417,20374741.218256842,20617065.687046308]
[null,null,0]
[null,"Lucro antes de IR",240093510.86056817,null,{"$f":"E21","v":-1666459.0575044304},6355649.3573633526,5032850.2761698756,17568225.974817872,17836170.76882223,18345918.836836543,18608531.529440209,18868518.095117841,19125904.795138691,19380717.62815934,19632982.332849778,19882724.390493315,20129969.027560417,20374741.218256842,20617065.687046308]
[0.15,"Imposto de Renda",36263995.487710893,null,{"$f":"IF(E23<0,0,E$23*$A24)","v":0},953347.40360450279,754927.54142548132,2635233.8962226808,2675425.6153233345,2751887.8255254813,2791279.7294160314,2830277.7142676762,2868885.7192708035,2907107.644223901,2944947.3499274668,2982408.6585739972,3019495.3541340623,3056211.1827385263,3092559.8530569463]
[0.1,"Adicional de Imposto",23839996.99180726,null,{"$f":"IF(E23<240000,0,(E$23-240000)*$A25)","v":0},611564.93573633523,479285.02761698759,1732822.5974817872,1759617.0768822231,1810591.8836836545,1836853.1529440209,1862851.8095117842,1888590.4795138692,1914071.7628159341,1939298.233284978,1964272.4390493315,1988996.9027560418,2013474.1218256843,2037706.5687046309]
[0.09,"Contribuição Social",21758397.292626534,null,{"$f":"IF(E23<0,0,E$23*$A26)","v":0},572008.44216270174,452956.52485528879,1581140.3377336084,1605255.3691940007,1651132.6953152888,1674767.8376496187,1698166.6285606057,1721331.4315624821,1744264.5865343406,1766968.4099564799,1789445.1951443984,1811697.2124804375,1833726.7096431158,1855535.9118341675]
[null,"Lucro Líquido",135028933.58704802,{"$f":"D31","v":-23202187.50137547},{"$f":"E23-SUM(E24:E26)","v":-1666459.0575044304},{"$f":"F23-SUM(F24:F26)","v":4218728.575859813},3345681.1822721181,11619029.143379796,11795872.707422672,12132306.432312118,12305630.809430538,12477221.942777775,12647097.164791536,12815273.634585164,12981768.339680854,13146598.097725589,13309779.558189875,13471329.204049516,13631263.353450563]
[{"$f":"H2","v":0},"Lucro Líquido Ajustado",135028933.58704802,{"$f":"D7-RESSARCIMENTO!B4","v":-23202187.50137547},{"$f":"E27*(1-$H$2)","v":-1666459.0575044304},4218728.575859813,3345681.1822721181,11619029.143379796,11795872.707422672,12132306.432312118,12305630.809430538,12477221.942777775,12647097.164791536,12815273.634585164,12981768.339680854,13146598.097725589,13309779.558189875,13471329.204049516,13631263.353450563]
[null,"Margem  Sobre o Faturamento",{"$f":"C27/C5","v":0.13167466199644706},null,-0.10413531141983193,9.5918867495829563E-2,5.8501939795616083E-2,0.15350479895668767,0.15584116763346761,0.16028596165748721,0.16257583659759919,0.16484281278831006,0.16708711921711378,0.16930898258162955,0.17150862731250011,0.17368627559606198,0.17584214739678822,0.17797646047950719,0.18008943043139897]
[null,"FLUXO DE CAIXA PROJETO",null,null,{"$f":"E4","v":" 1º Ano"},"2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano","11º ano","12º ano","13º ano","14º ano","15º ano"]
[null,"(=) Lucro Líquido",{"$f":"SUM(D31:S31)","v":135028933.58704802},{"$f":"D7-RESSARCIMENTO!B4","v":-23202187.50137547},{"$f":"E28","v":-1666459.0575044304},{"$f":"F28","v":4218728.575859813},3345681.1822721181,11619029.143379796,11795872.707422672,12132306.432312118,12305630.809430538,12477221.942777775,12647097.164791536,{"$f":"N28","v":12815273.634585164},{"$f":"O28","v":12981768.339680854},13146598.097725589,13309779.558189875,13471329.204049516,13631263.353450563]
[null,"(+) Depreciação",{"$f":"SUM(E32:S32)","v":100411514.20888461},null,{"$f":"E20*-1","v":5999063.0320900278},{"$f":"F20*-1","v":6918377.0283067543},{"$f":"G20*-1","v":6918377.0283067543},{"$f":"H20*-1","v":6918377.0283067543},6918377.0283067543,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542,6673894.3063567542]
[null,"IMOBILIZADO",{"$f":"SUM(D33:S33)","v":0},null,0,{"$f":"-'[1]TOTALRESUMO '!$I$24","v":0},{"$f":"-'[1]TOTALRESUMO '!$J$24","v":0}]
[null,"(-) Investimentos",{"$f":"SUM(D34:S34)","v":-115107447.6415734},null,{"$f":"-ESTACIONAMENTOS!O81-ESTACIONAMENTOS!Q81-ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K34+'VAGAS CAPEX'!K29)/ESTACIONAMENTOS!M77-('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*80*EDIFICAÇÕES!C4-('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5-0.33*CAPEX!D9-CAPEX!D10-CAPEX!D11-CAPEX!D12-COMUNICAÇÃO!F19-CAPEX!D14","v":-56503887.567974925},{"$f":"-ESTACIONAMENTOS!S81*'VAGAS CAPEX'!K26/ESTACIONAMENTOS!M77-'VAGAS CAPEX'!N26*80*EDIFICAÇÕES!C4-EDIFICAÇÕES!E3-0.67*CAPEX!D9-COMUNICAÇÃO!F36","v":-26198507.973598465},{"$f":"-COMUNICAÇÃO!F53","v":0},null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D12*0.5-CAPEX!D14","v":-10340206.699999999},null,null,null,null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D10-CAPEX!D12*0.5-CAPEX!D14","v":-11724638.699999999},null,null,null,null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D12*0.5-CAPEX!D14","v":-10340206.699999999}]
[null,"(-) Manutenção",{"$f":"SUM(E35:S35)","v":-21762602.544918597},null,null,null,null,null,{"$f":"-0.05*(CAPEX!D7+CAPEX!D8)","v":-1978418.413174418},{"$f":"I35","v":-1978418.413174418},{"$f":"J35","v":-1978418.413174418},-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418,-1978418.413174418]
[null,"(-) Despesas Pré Operacionais",{"$f":"SUM(D36:S36)","v":0}]
[null,"(=) Saldo de Caixa",{"$f":"SUM(D37:S37)","v":98570397.609440625},{"$f":"SUM(D31:D36)","v":-23202187.50137547},{"$f":"SUM(E31:E36)","v":-52171283.593389325},{"$f":"SUM(F31:F36)","v":-15061402.369431898},{"$f":"SUM(G31:G36)","v":10264058.210578872},18537406.171686552,6395624.6225550091,16827782.325494457,17001106.702612873,17172697.835960113,17342573.057973873,5786110.8277675016,17677244.232863192,17842073.990907926,18005255.45137221,18166805.097231854,7986532.5466328999]
[null,"(=) Saldo de Caixa Acumulado",null,{"$f":"D37","v":-23202187.50137547},{"$f":"E37+D38","v":-75373471.094764799},{"$f":"F37+E38","v":-90434873.464196697},-80170815.253617823,-61633409.081931271,-55237784.459376261,-38410002.133881807,-21408895.431268934,-4236197.5953088216,13106375.462665051,18892486.290432554,36569730.523295745,54411804.514203668,72417059.965575874,90583865.062807724,98570397.609440625]
[null,"FCL",{"$f":"NPV(C41,E37:S37)+D37","v":98570397.60944064}]
[null,"Exposição Máxima",{"$f":"MIN(D38:S38)","v":-90434873.464196697}]
[null,null,null,null,null,"SIMULAÇÃO "]
[null,"VPL",{"$f":"NPV(C43,D37:S37)","v":8.4539177358289099E-10}]
[null,"TIR",{"$f":"IRR(D37:S37)","v":0.1016461287154482},null,null,"TARIFA AUTO (R$)",2]
[null,"Taxa Interna de Retorno Acionistas",{"$f":"IRR(D27:S27)","v":0.27487045239459595}]
[null,null,null,null,null,"TAXA DE OCUPAÇÃO (%)",0.5]
[null,"VALOR DO CONTRATO",{"$f":"-(C6+C7+C19+C33+C34+C35)","v":710737667.44183588}]
[]
[null,null,null,"DEPRECIA;ÁO","ANO 1","ANO 2","ANO 3","ANO 4","ANO 5","ANO 6-20"]
[null,null,null,"Outorga",{"$f":"-$D7/15","v":1190000},{"$f":"-$D7/15","v":1190000},1190000,1190000,1190000,1190000]
[null,null,null,"Ressarcimento",{"$f":"RESSARCIMENTO!$B4/15","v":356812.50009169808},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357},{"$f":"RESSARCIMENTO!$B4/20","v":267609.37506877357}]
[null,null,null,"Estacionamentos",{"$f":"(ESTACIONAMENTOS!O81+ESTACIONAMENTOS!Q81+ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K29+'VAGAS CAPEX'!K34)/ESTACIONAMENTOS!M77)/15","v":1499226.915131662},{"$f":"E51+(CAPEX!D7-'FLUXO DE CAIXA 15 ANOS'!E51*20)/14","v":1879621.4837641707},{"$f":"F51","v":1879621.4837641707},1879621.4837641707,1879621.4837641707,1879621.4837641707]
[null,null,null,"Edificações",{"$f":"(('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*80*EDIFICAÇÕES!C4+('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5)/15","v":628919.03999999992},{"$f":"E52+(CAPEX!D8-'FLUXO DE CAIXA 15 ANOS'!E52*20)/14","v":34627.982857142808},34627.982857142808,34627.982857142808,34627.982857142808,34627.982857142808]
[null,null,null,"Equipamentos",{"$f":"0.33*CAPEX!D9/5","v":481667.45220000006},{"$f":"E53+0.67*CAPEX!D9/4","v":1704081.06195},{"$f":"F53","v":1704081.06195},1704081.06195,1704081.06195,{"$f":"CAPEX!D9/5","v":1459598.34}]
[null,null,null,"CCO",{"$f":"CAPEX!D10/10","v":138443.20000000001},{"$f":"E54","v":138443.20000000001},138443.20000000001,138443.20000000001,138443.20000000001,{"$f":"I54","v":138443.20000000001}]
[null,null,null,"Sistemas",{"$f":"CAPEX!D11/15","v":834666.66666666663},{"$f":"E55","v":834666.66666666663},834666.66666666663,834666.66666666663,834666.66666666663,834666.66666666663]
[null,null,null,"Veículos",{"$f":"CAPEX!D12/10","v":465600},465600,465600,465600,465600,465600]
[null,null,null,"Comunicação",{"$f":"CAPEX!D13/20","v":260884.258},260884.258,260884.258,260884.258,260884.258,260884.258]
[null,null,null,"Uniformes",{"$f":"CAPEX!D14/5","v":142843},142843,142843,142843,142843,142843]
[null,null,null,"TOTAL",{"$f":"SUM(E49:E58)","v":5999063.0320900278},6918377.0283067543,6918377.0283067543,6918377.0283067543,6918377.0283067543,6673894.3063567542]

{"sheet":"FLUXO DE CAIXA 10 ANOS","index":22,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,2,2,3],[29,1,29,2],[40,5,40,6]]}
[]
[]
[]
[null,"DRE","Total","Pré-Oper"," 1º Ano","2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano"]
[null,"Receita Tarifária Bruta",{"$f":"SUM(D5:N5)","v":647015760.83520019},null,{"$f":"RECEITA!J36","v":16002823.968},{"$f":"RECEITA!J37","v":43982260.0704},{"$f":"RECEITA!J38","v":57189234.988799997},{"$f":"RECEITA!J34","v":75691634.544},{"$f":"H5","v":75691634.544},{"$f":"I5","v":75691634.544},{"$f":"J5","v":75691634.544},{"$f":"K5","v":75691634.544},75691634.544,75691634.544]
[0.1,"Outorga Mensal",-64701576.08352001,null,{"$f":"-E5*$A$6","v":-1600282.3968000002},{"$f":"-F5*$A$6","v":-4398226.0070400005},-5718923.4988799999,-7569163.4544000002,-7569163.4544000002,-7569163.4544000002,-7569163.4544000002,-7569163.4544000002,-7569163.4544000002,-7569163.4544000002]
[2890000,"Outorga Inicial",-2890000,{"$f":"-A7","v":-2890000}]
[0,"VF Regulatória",0,null,{"$f":"-$A$8*E5","v":0},0,0,0,0,0,0,0,0,0]
[0,"VF de Trânsito",0,null,{"$f":"-E5*$A$9","v":0},0,0,0,0,0,0,0,0,0]
[null,"Receita Após Repasse",582314184.7516799,null,{"$f":"E5+E6+(E8+E9)","v":14402541.5712},39584034.063359998,51470311.489919998,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997]
[{"$f":"D2","v":0},"Receita Após Participação",582314184.7516799,null,{"$f":"E10*(1-$A$11)","v":14402541.5712},39584034.063359998,51470311.489919998,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997,68122471.089599997]
[null,"Tributos sobre Receita",-80956444.526981562,null,{"$f":"SUM(E13:E15)","v":-1964747.8377752912},{"$f":"SUM(F13:F15)","v":-5466179.3627253706},-6850126.8799851155,-9486718.8166011162,-9499712.2076603044,-9512575.664808901,-9525310.4873860124,-9537917.9617373515,-9550399.3613451775,-9562755.946956927]
[1.6500000000000001E-2,"PIS",-8670198.183850335,null,{"$f":"(-E5*$A$13)-0.5*$A$13*E19","v":-207740.64378045735},{"$f":"(-F5*$A$13)-0.5*$A$13*F19","v":-582773.99920960667},{"$f":"(-G5*$A$13)-0.5*$A$13*G19","v":-711848.37463777734},-1017137.9672985774,-1019455.7073253517,-1021750.2699518581,-1024021.8869520995,-1026270.7877823386,-1028497.1996042752,-1030701.3473079924]
[7.5999999999999998E-2,"COFINS",-39935458.301371239,null,{"$f":"(-E5*$A14)-0.5*$A$14*E19","v":-956865.99559483374},{"$f":"(-F5*$A14)-0.5*$A$14*F19","v":-2684292.3599957637},-3278816.7559073381,-4684999.1221025381,-4695674.7731349524,-4706243.6676570429,-4716706.8732339125,-4727065.4467550134,-4737320.4345409032,-4747472.8724489342]
[0.05,"ISS",-32350788.041760005,null,{"$f":"-E5*$A15","v":-800141.19840000011},-2199113.0035200003,-2859461.7494399999,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001,-3784581.7272000001]
[{"$f":"J2","v":0},"Receita Líquida",501357740.22469842,null,{"$f":"E11+E12","v":12437793.733424708},{"$f":"F11+F12","v":34117854.700634629},44620184.609934881,58635752.272998884,58622758.881939694,58609895.424791098,58597160.602213986,58584553.127862647,58572071.728254817,58559715.142643072]
[null,null,null,null,{"$f":"E16/E5","v":0.77722492969340318},0.77571854302221044,0.78021999452647595,0.77466621808667069,0.77449455590580396,0.77432461034674593,0.77415636424327849,0.77398980060084577,0.77382490259483727,0.77366165356888894]
[]
[null,"CUSTOS E DESPESAS OPERAÇÃO",{"$f":"SUM(D19:N19)","v":-243098408.47642013},null,{"$f":"-(OPEX!D7+OPEX!D10)*('VAGAS CAPEX'!O34+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!N29)/('VAGAS CAPEX'!N35+'VAGAS CAPEX'!O35)-OPEX!D8*'FLUXO DE CAIXA 10 ANOS'!E5/'FLUXO DE CAIXA 10 ANOS'!H5-OPEX!D9","v":-6824963.8413991118},{"$f":"-OPEX!D7-OPEX!D8*'FLUXO DE CAIXA 10 ANOS'!F5/'FLUXO DE CAIXA 10 ANOS'!H5-OPEX!D9-OPEX!D10","v":-17325247.509332526},{"$f":"-OPEX!D7-OPEX!D8-OPEX!D9-OPEX!D10","v":-28093818.506354254},{"$f":"-OPEX!D6","v":-28093818.506354254},{"$f":"0.99*H19","v":-27812880.321290713},-27534751.518077806,-27259404.002897028,-26986809.962868057,-26716941.863239378,-26449772.444606982]
[null,"DEPRECIAÇÃO",-48908721.084555581,null,{"$f":"-E59","v":-6340542.2597017074},-4865621.3816226516,-4865621.3816226516,-4865621.3816226516,-4865621.3816226516,-4621138.6596726524,{"$f":"J20","v":-4621138.6596726524},-4621138.6596726524,-4621138.6596726524,-4621138.6596726524]
[null,"Lucro Bruto",209350610.66372272,null,{"$f":"E16+E19+E20","v":-727712.36767611094},{"$f":"F16+F19+F20","v":11926985.80967945},{"$f":"G16+G19+G20","v":11660744.721957976},{"$f":"H16+H19+H20","v":25676312.385021977},25944257.179026328,26454005.247040641,26716617.939644307,26976604.505321939,27233991.205342788,27488804.038363438]
[null,null,0]
[null,"Lucro antes de IR",209350610.66372272,null,{"$f":"E21","v":-727712.36767611094},11926985.80967945,11660744.721957976,25676312.385021977,25944257.179026328,26454005.247040641,26716617.939644307,26976604.505321939,27233991.205342788,27488804.038363438]
[0.15,"Imposto de Renda",31511748.454709824,null,{"$f":"IF(E23<0,0,E$23*$A24)","v":0},1789047.8714519176,1749111.7082936964,3851446.8577532964,3891638.5768539491,3968100.7870560959,4007492.690946646,4046490.6757982904,4085098.6808014181,4123320.6057545156]
[0.1,"Adicional de Imposto",20791832.303139884,null,{"$f":"IF(E23<240000,0,(E$23-240000)*$A25)","v":0},1168698.580967945,1142074.4721957976,2543631.2385021979,2570425.7179026329,2621400.5247040642,2647661.7939644307,2673660.4505321942,2699399.1205342789,2724880.4038363439]
[0.09,"Contribuição Social",18907049.072825897,null,{"$f":"IF(E23<0,0,E$23*$A26)","v":0},1073428.7228711506,1049467.0249762179,2310868.114651978,2334983.1461123694,2380860.4722336577,2404495.6145679876,2427894.4054789743,2451059.2084808508,2473992.3634527093]
[null,"Lucro Líquido",129897793.33167166,{"$f":"D31","v":-8242187.5013754712},{"$f":"E23-SUM(E24:E26)","v":-727712.36767611094},{"$f":"F23-SUM(F24:F26)","v":7895810.6343884375},7720091.5164922643,16970366.174114503,17147209.738157377,17483643.463046823,17656967.840165243,17828558.973512478,17998434.195526242,18166610.665319867]
[{"$f":"H2","v":0},"Lucro Líquido Ajustado",129897793.33167166,{"$f":"D7-RESSARCIMENTO!B4","v":-8242187.5013754712},{"$f":"E27*(1-$H$2)","v":-727712.36767611094},7895810.6343884375,7720091.5164922643,16970366.174114503,17147209.738157377,17483643.463046823,17656967.840165243,17828558.973512478,17998434.195526242,18166610.665319867]
[null,"Margem  Sobre o Faturamento",{"$f":"C27/C5","v":0.2007644963145768},null,-4.5473996910250267E-2,0.17952262166041594,0.13499204033773446,0.22420398603295491,0.22654035470973483,0.23098514873375439,0.23327502367386638,0.23554199986457725,0.23778630629338102,0.2400081696578967]
[null,"FLUXO DE CAIXA PROJETO",null,null,{"$f":"E4","v":" 1º Ano"},"2 º Ano ","3º ano","4º ano","5º ano","6º ano","7º ano","8º ano","9º ano","10º ano"]
[null,"(=) Lucro Líquido",{"$f":"SUM(D31:N31)","v":129897793.33167166},{"$f":"D7-RESSARCIMENTO!B4","v":-8242187.5013754712},{"$f":"E28","v":-727712.36767611094},{"$f":"F28","v":7895810.6343884375},7720091.5164922643,16970366.174114503,17147209.738157377,17483643.463046823,17656967.840165243,17828558.973512478,17998434.195526242,{"$f":"N28","v":18166610.665319867}]
[null,"(+) Depreciação",{"$f":"SUM(E32:N32)","v":48908721.084555581},null,{"$f":"E20*-1","v":6340542.2597017074},{"$f":"F20*-1","v":4865621.3816226516},{"$f":"G20*-1","v":4865621.3816226516},{"$f":"H20*-1","v":4865621.3816226516},4865621.3816226516,4621138.6596726524,4621138.6596726524,4621138.6596726524,4621138.6596726524,4621138.6596726524]
[null,"IMOBILIZADO",{"$f":"SUM(D33:N33)","v":0},null,0,{"$f":"-'[1]TOTALRESUMO '!$I$24","v":0},{"$f":"-'[1]TOTALRESUMO '!$J$24","v":0}]
[null,"(-) Investimentos",{"$f":"SUM(D34:N34)","v":-104767240.9415734},null,{"$f":"-ESTACIONAMENTOS!O81-ESTACIONAMENTOS!Q81-ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K34+'VAGAS CAPEX'!K29)/ESTACIONAMENTOS!M77-('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*80*EDIFICAÇÕES!C4-('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5-0.33*CAPEX!D9-CAPEX!D10-CAPEX!D11-CAPEX!D12-COMUNICAÇÃO!F19-CAPEX!D14","v":-56503887.567974925},{"$f":"-ESTACIONAMENTOS!S81*'VAGAS CAPEX'!K26/ESTACIONAMENTOS!M77-'VAGAS CAPEX'!N26*80*EDIFICAÇÕES!C4-EDIFICAÇÕES!E3-0.67*CAPEX!D9-COMUNICAÇÃO!F36","v":-26198507.973598465},{"$f":"-COMUNICAÇÃO!F53","v":0},null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D12*0.5-CAPEX!D14","v":-10340206.699999999},null,null,null,null,{"$f":"-CAPEX!D9+EQUIPAMENTOS!F3-CAPEX!D10-CAPEX!D12*0.5-CAPEX!D14","v":-11724638.699999999}]
[null,"(-) Manutenção",{"$f":"SUM(E35:N35)","v":-11870510.479046509},null,null,null,null,null,{"$f":"-0.05*(CAPEX!D7+CAPEX!D8)","v":-1978418.413174418},{"$f":"I35","v":-1978418.413174418},{"$f":"J35","v":-1978418.413174418},-1978418.413174418,-1978418.413174418,-1978418.413174418]
[null,"(-) Despesas Pré Operacionais",{"$f":"SUM(D36:N36)","v":0}]
[null,"(=) Saldo de Caixa",{"$f":"SUM(D37:N37)","v":62168762.995607331},{"$f":"SUM(D31:D36)","v":-8242187.5013754712},{"$f":"SUM(E31:E36)","v":-50891057.675949328},{"$f":"SUM(F31:F36)","v":-13437075.957587376},{"$f":"SUM(G31:G36)","v":12585712.898114916},21835987.555737153,9694206.0066056084,20126363.709545057,20299688.086663477,20471279.220010713,20641154.442024477,9084692.2118181009]
[null,"(=) Saldo de Caixa Acumulado",null,{"$f":"D37","v":-8242187.5013754712},{"$f":"E37+D38","v":-59133245.177324802},{"$f":"F37+E38","v":-72570321.134912178},-59984608.236797258,-38148620.681060106,-28454414.674454495,-8328050.964909438,11971637.121754039,32442916.341764752,53084070.783789232,62168762.995607331]
[null,"FCL",{"$f":"NPV(C41,E37:N37)+D37","v":62168762.995607324}]
[null,"Exposição Máxima",{"$f":"MIN(D38:N38)","v":-72570321.134912178}]
[null,null,null,null,null,"SIMULAÇÃO "]
[null,"VPL",{"$f":"NPV(C43,D37:N37)","v":4.2978589151014866E-8}]
[null,"TIR",{"$f":"IRR(D37:N37)","v":0.12681162496608667},null,null,"TARIFA AUTO (R$)",2]
[null,"Taxa Interna de Retorno Acionistas",{"$f":"IRR(D27:N27)","v":0.7262087546821705}]
[null,null,null,null,null,"TAXA DE OCUPAÇÃO (%)",0.5]
[null,"VALOR DO CONTRATO",{"$f":"-(C6+C7+C19+C33+C34+C35)","v":427327735.98056006}]
[]
[null,null,null,"DEPRECIA;ÁO","ANO 1","ANO 2","ANO 3","ANO 4","ANO 5","ANO 6-20"]
[null,null,null,"Outorga",{"$f":"-$D7/10","v":289000},{"$f":"-$D7/10","v":289000},289000,289000,289000,289000]
[null,null,null,"Ressarcimento",{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715},{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715},{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715},{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715},{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715},{"$f":"RESSARCIMENTO!$B4/10","v":535218.75013754715}]
[null,null,null,"Estacionamentos",{"$f":"(ESTACIONAMENTOS!O81+ESTACIONAMENTOS!Q81+ESTACIONAMENTOS!S81*('VAGAS CAPEX'!K29+'VAGAS CAPEX'!K34)/ESTACIONAMENTOS!M77)/10","v":2248840.3726974931},{"$f":"E51+(CAPEX!D7-'FLUXO DE CAIXA 10 ANOS'!E51*20)/9","v":1174757.5737573262},{"$f":"F51","v":1174757.5737573262},1174757.5737573262,1174757.5737573262,1174757.5737573262]
[null,null,null,"Edificações",{"$f":"(('VAGAS CAPEX'!N290+'VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*80*EDIFICAÇÕES!C4+('VAGAS CAPEX'!O19+'VAGAS CAPEX'!O29+'VAGAS CAPEX'!O34)*70*EDIFICAÇÕES!C5)/10","v":943378.55999999994},{"$f":"E52+(CAPEX!D8-'FLUXO DE CAIXA 10 ANOS'!E52*20)/9","v":-679873.12888888887},-679873.12888888887,-679873.12888888887,-679873.12888888887,-679873.12888888887]
[null,null,null,"Equipamentos",{"$f":"0.33*CAPEX!D9/5","v":481667.45220000006},{"$f":"E53+0.67*CAPEX!D9/4","v":1704081.06195},{"$f":"F53","v":1704081.06195},1704081.06195,1704081.06195,{"$f":"CAPEX!D9/5","v":1459598.34}]
[null,null,null,"CCO",{"$f":"CAPEX!D10/10","v":138443.20000000001},{"$f":"E54","v":138443.20000000001},138443.20000000001,138443.20000000001,138443.20000000001,{"$f":"I54","v":138443.20000000001}]
[null,null,null,"Sistemas",{"$f":"CAPEX!D11/15","v":834666.66666666663},{"$f":"E55","v":834666.66666666663},834666.66666666663,834666.66666666663,834666.66666666663,834666.66666666663]
[null,null,null,"Veículos",{"$f":"CAPEX!D12/10","v":465600},465600,465600,465600,465600,465600]
[null,null,null,"Comunicação",{"$f":"CAPEX!D13/20","v":260884.258},260884.258,260884.258,260884.258,260884.258,260884.258]
[null,null,null,"Uniformes",{"$f":"CAPEX!D14/5","v":142843},142843,142843,142843,142843,142843]
[null,null,null,"TOTAL",{"$f":"SUM(E49:E58)","v":6340542.2597017074},4865621.3816226516,4865621.3816226516,4865621.3816226516,4865621.3816226516,4621138.6596726524]