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

{"sheet":"WACC 13","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Cálculo del WACC"]
[]
[null,"WACC 13","Rolling",null,null,2012,"2013"]
[null,"Estructura de Capital Contable"]
[null,"   Deuda",{"$f":"+Promedio_Deuda(F7,G7)","v":288062.68446999998},"Function","Activo",359364.12300000002,394192,"Input"]
[null,"   Patrimonio",{"$f":"+Promedio_Patrimonio(F8,G8)","v":88715.437000000005},"Function","Pasivo",271409.24699999997,304716.12193999992,"Input"]
[null,"   % Deuda",{"$f":"+C6/SUM($C$6:$C$7)","v":0.76454196264401786},null,"Patrimonio",87954.873999999996,89476,"Input"]
[null,"   % Patrimonio",{"$f":"+C7/SUM($C$6:$C$7)","v":0.23545803735598206}]
[null,"   Deuda Financiera",{"$f":"+Promedio_Deuda_Financiera(F10,G10)","v":196881.7415},"Function","D. Financiera",187507.14199999999,206256.34100000001,"Input"]
[null,"   D/P",{"$f":"+C6/C7","v":3.2470412614886852}]
[null,"   Tasa Impositiva",0.35599999999999998,"Input"]
[null,"Deuda con Escudo Fiscal",{"$f":"+C10/C6","v":0.6834683980753643}]
[null,"Beta"]
[null,"   Beta Desapalancado",0.51,"Input"]
[null,"   Beta Apalancado",{"$f":"+Beta_Apalancado(C15,C12,C13,C11)","v":1.763063997114279},"Function"]
[null,"COK"]
[null,"   Bono del Tesoro USA (30 años)",3.6600000000000001E-2,"Input"]
[null,"   Riesgo País (Promedio 5 años)",5.8000000000000003E-2,"Input"]
[null,"   Premio de Riesgo de Mercado PERU",0.02,"Input"]
[null,"COK",{"$f":"+COK(C18,C20,C19,C16)","v":0.17411899177491375},"Function"]
[null,"Activos Financiados con Deuda",{"$f":"+C6","v":288062.68446999998}]
[null,"Intereses de Deuda",10326,"Input"]
[null,"Tasa de Interés Implícita",{"$f":"+C23/C22","v":3.5846364547350427E-2}]
[null,"WACC",{"$f":"wacc(C8,C24,C13,C9,C21)","v":5.9728885095651593E-2},"Function"]