{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tabla # 1","Tabla # 2 y 3","Tabla # 4","Tabla # 5","Tabla # 6","Datos","Amortizaciones","Flujo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Tabla # 1","index":0,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Nombre del negocio"]
[]
["Tabla # XXX"]
["Balanza de Inversión Inicial"]
["(Cifras en  <<Indicar moneda>>)"]
[]
["CONCEPTOS","COSTO"]
["Inversión en Capital de Trabajo:"]
[]
[]
[]
[]
["Sub total inversión en Capital de Trabajo",{"$f":"SUM(B9:B12)","v":0}]
["Inversión en Capital Fijo:"]
[]
[]
[]
[]
["Sub total inversión en Capital Fijo",{"$f":"SUM(B15:B18)","v":0}]
["Inversión en Activos Intangibles:"]
[]
[]
[]
[]
["Sub total inversión en Activos Intangibles",{"$f":"SUM(B21:B24)","v":0}]
["MONTO DE LA INVERSIÓN INICIAL",{"$f":"B13+B19+B25","v":0}]
[]
["Notas:"]

{"sheet":"Tabla # 2 y 3","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,7,8,8],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[5,1,5,5],[5,0,6,0],[0,0,0,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[27,0,27,5],[24,0,24,5],[26,0,26,5],[28,0,28,5],[29,0,30,0],[29,1,29,5]]}
["Nombre del Negocio"]
[]
["Tabla # XXX"]
["Proyección de ingresos"]
["(Cifras en <<Indicar moneda>>",null,null,null,null,null,null,"SUPUESTOS"]
["CONCEPTOS","AÑOS",null,null,null,null,null,"Crecim. Ventas"]
[null,1,2,3,4,5]
["Ingresos por venta de productos",0,{"$f":"B8*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C8*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D8*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E8*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},null,"Inflación / Precios"]
["Ingresos por venta de servicios",0,{"$f":"B9*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C9*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D9*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E9*(1+crecim_ventas)*(1+crecim_inflacion)","v":0}]
["Otros ingresos",0,{"$f":"B10*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C10*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D10*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E10*(1+crecim_ventas)*(1+crecim_inflacion)","v":0}]
["Ingresos totales",{"$f":"SUM(B8:B10)","v":0},{"$f":"SUM(C8:C10)","v":0},{"$f":"SUM(D8:D10)","v":0},0,0]
[]
["Notas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nombre del Negocio"]
[]
["Tabla # XXX"]
["Proyección de costos variables"]
["(Cifras en <<Indicar moneda>>"]
["CONCEPTOS","AÑOS"]
[null,1,2,3,4,5]
["Costo variable de productos",0,{"$f":"B32*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C32*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D32*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E32*(1+crecim_ventas)*(1+crecim_inflacion)","v":0}]
["Costo variable de servicios",0,{"$f":"B33*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C33*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D33*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E33*(1+crecim_ventas)*(1+crecim_inflacion)","v":0}]
["Otros costos variables.",0,{"$f":"B34*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"C34*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"D34*(1+crecim_ventas)*(1+crecim_inflacion)","v":0},{"$f":"E34*(1+crecim_ventas)*(1+crecim_inflacion)","v":0}]
["Costos variables totales",{"$f":"SUM(B32:B34)","v":0},{"$f":"SUM(C32:C34)","v":0},0,0,0]
[]
["Notas"]

{"sheet":"Tabla # 4","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[3,0,3,5],[4,0,5,0],[4,1,4,5],[2,0,2,5]]}
["Nombre del Negocio"]
["Tabla: XXX"]
["Proyección de Costos Fijos"]
["(Cifras en <<indicar moneda>>)"]
["CONCEPTOS","AÑOS"]
[null,1,2,3,4,5]
["Gastos Personales:"]
["Salarios",null,{"$f":"B8*1.03","v":0},{"$f":"C8*1.05","v":0},{"$f":"D8*1.07","v":0},{"$f":"E8*1.09","v":0}]
["Prestaciones de ley",null,{"$f":"C8*25%","v":0},0,{"$f":"E8*22.222222%","v":0},{"$f":"F8*22.222222%","v":0}]
["Obligaciones patronales",null,{"$f":"C8*19%","v":0},0,0,0]
["Sub total Gastos Personales",{"$f":"SUM(B8:B10)","v":0},{"$f":"SUM(C8:C10)","v":0},0,0,0]
["Gastos No Personales:"]
["Cargos básicos"]
["Alquileres"]
["Propaganda y publicidad"]
["Otros"]
["Sub total Gastos No Personales",{"$f":"SUM(B13:B16)","v":0},{"$f":"SUM(C13:C16)","v":0},0,0,0]
["COSTOS FIJOS TOTALES",{"$f":"B11+B17","v":0},{"$f":"C11+C17","v":0},0,0,0]
[]
["Notas"]

{"sheet":"Tabla # 5","index":3,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,0,2,8],[0,0,0,8],[3,0,3,8]]}
["Nombre del Negocio"]
["Tabla XXX"]
["Programa de Depreciación de Activos"]
["(Cifras en <<indicar moneda>>)"]
["ACTIVO","CANTIDAD","COSTO INSTALADO","VALOR RESIDUAL","VIDA ÚTIL","DEPREC. ANUAL","VIDA DEL PROYECTO","DEPREC. ACUMULADA","VALOR EN LIBROS"]
[null,null,null,null,null,{"$f":"IFERROR(((C6-D6)/E6)*B6, 0)","v":0},null,{"$f":"F6*G6","v":0},{"$f":"(C6*B6)-H6","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(((C7-D7)/E7)*B7, 0)","v":0},null,{"$f":"F7*G7","v":0},{"$f":"(C7*B7)-H7","v":0}]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,{"$f":"IFERROR(((C9-D9)/E9)*B9, 0)","v":0},null,{"$f":"F9*G9","v":0},{"$f":"(C9*B9)-H9","v":0}]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,{"$f":"IFERROR(((C20-D20)/E20)*B20, 0)","v":0},null,{"$f":"F20*G20","v":0},{"$f":"(C20*B20)-H20","v":0}]
["TOTALES",null,null,null,null,{"$f":"SUM(F6:F20)","v":0},null,null,{"$f":"SUM(I6:I7)","v":0}]

{"sheet":"Tabla # 6","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,4],[0,0,0,5],[2,0,2,5],[3,0,3,5],[5,0,5,1]]}
["Nombre del Negocio"]
[]
["Tabla # XX"]
["Costo de Capital Promedio Ponderado del Proyecto"]
[]
["FUENTE DE FINANCIAMIENTO",null,"MONTO","PESO","COSTO","COSTO PONDERADO"]
["Fuente 1",null,null,{"$f":"IFERROR(C7/$C$10, 0)","v":0},null,{"$f":"D7*E7","v":0}]
["Fuente 2",null,null,{"$f":"IFERROR(C8/$C$10, 0)","v":0},null,{"$f":"D8*E8","v":0}]
["Fuente 3",null,null,0,null,0]
["Inversión Total",null,{"$f":"SUM(C7:C9)","v":0},"CCPP",null,{"$f":"SUM(F7:F9)","v":0}]

{"sheet":"Datos","index":5,"n_rows":163,"n_cols":1,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
[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]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]

{"sheet":"Amortizaciones","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Tabla de Amortización de Préstamos"]
[]
["Monto del Préstamo:",null,0,"Suma Principal:",0]
[null,null,0]
["Tasa de Interés Mensual:",null,0.01,"Suma Intereses:",0]
[]
["Plazo (Meses):",null,1]
[]
["N° CUOTA","PAGO","INTERESES","AMORTIZACIÓN","SALDO"]
[]
[0,0,0,0,0]
[1,0,0,0,0]

{"sheet":"Flujo","index":7,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[4,4,4,9],[35,4,35,5],[36,4,36,5],[2,0,2,9],[34,0,34,5]]}
["Nombre del Negocio"]
["Tabla # XXX"]
["Flujo de Caja del Proyecto"]
[]
[null,null,null,null,"Años"]
[null,null,null,null,0,1,2,3,4,5]
["Inversiones realizadas en el año Cero"]
["Inversión en Capital de Trabajo",null,null,null,{"$f":"-'Tabla # 1'!B13","v":0}]
["Inversión en Activos Fijos",null,null,null,{"$f":"-'Tabla # 1'!B19","v":0}]
["Inversión en Activos Intangibles",null,null,null,{"$f":"-'Tabla # 1'!B25","v":0}]
["Flujos Operativos durante la vida del Proyecto"]
["Ingresos por ventas",null,null,null,null,{"$f":"'Tabla # 2 y 3'!B11","v":0},{"$f":"'Tabla # 2 y 3'!C11","v":0},{"$f":"'Tabla # 2 y 3'!D11","v":0},{"$f":"'Tabla # 2 y 3'!E11","v":0},{"$f":"'Tabla # 2 y 3'!F11","v":0}]
["Costos variables",null,null,null,null,{"$f":"-'Tabla # 2 y 3'!B35","v":0},{"$f":"-'Tabla # 2 y 3'!C35","v":0},{"$f":"-'Tabla # 2 y 3'!D35","v":0},{"$f":"-'Tabla # 2 y 3'!E35","v":0},{"$f":"-'Tabla # 2 y 3'!F35","v":0}]
["Costos Fijos",null,null,null,null,{"$f":"-'Tabla # 4'!B18","v":0},{"$f":"-'Tabla # 4'!C18","v":0},{"$f":"-'Tabla # 4'!D18","v":0},{"$f":"-'Tabla # 4'!E18","v":0},{"$f":"-'Tabla # 4'!F18","v":0}]
["Depreciaciones",null,null,null,null,{"$f":"-'Tabla # 5'!F21","v":0},{"$f":"F15","v":0},{"$f":"G15","v":0},0,0]
["Amortizaciones",null,null,null,null,{"$f":"-E10/J6","v":0},{"$f":"F16","v":0},{"$f":"G16","v":0},0,0]
["Utilidades antes de Impuestos",null,null,null,null,{"$f":"SUM(F12:F16)","v":0},{"$f":"SUM(G12:G16)","v":0},0,0,0]
["Impuesto sobre la renta 30%",null,null,null,null,{"$f":"IF(F17>0, -F17*30%, 0)","v":0},{"$f":"IF(G17>0, -G17*30%, 0)","v":0},0,0,{"$f":"IF(J17>0, -J17*30%, 0)","v":0}]
["Utilidades después de impuestos",null,null,null,null,{"$f":"SUM(F17:F18)","v":0},{"$f":"SUM(G17:G18)","v":0},0,0,0]
["(+) Depreciaciones y Amortizaciones",null,null,null,null,{"$f":"ABS(SUM(F15:F16))","v":0},{"$f":"ABS(SUM(G15:G16))","v":0},0,0,0]
["Flujos de Caja Anuales",null,null,null,null,{"$f":"SUM(F19:F20)","v":0},{"$f":"SUM(G19:G20)","v":0},0,0,{"$f":"SUM(J19:J20)","v":0}]
["Flujo de Caja del ultimo año"]
["Retorno del Capital de Trabajo",null,null,null,null,null,null,null,null,{"$f":"ABS(E8)","v":0}]
["Valor de salvamento neto",null,null,null,null,null,null,null,null,{"$f":"'Tabla # 5'!I21","v":0}]
["Flujo Final Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J24)","v":0}]
["Flujo de Caja Neto sin Financiamiento",null,null,null,{"$f":"SUM(E8:E10)","v":0},{"$f":"F21","v":0},{"$f":"G21","v":0},0,0,{"$f":"J21+J25","v":0}]
["Financiamiento"]
["Préstamos bancarios",null,null,null,{"$f":"monto","v":0}]
["Amortización de la Deuda",null,null,null,null,{"$f":"-IF(term>0, SUM(Amortizaciones!D12:D23), 0)","v":0},{"$f":"-IF(term>12, SUM(Amortizaciones!D24:D35), 0)","v":0},{"$f":"-IF(term>12, SUM(Amortizaciones!D36:D47), 0)","v":0},{"$f":"-IF(term>12, SUM(Amortizaciones!D48:D59), 0)","v":0},{"$f":"-IF(term>12, SUM(Amortizaciones!D60:D71), 0)","v":0}]
["Escudo fiscal de los intereses",null,null,null,null,0,0,0,0,0]
["Flujo de Caja Neto con Financiamiento",null,null,null,{"$f":"SUM(E26:E28)","v":0},{"$f":"SUM(F26:F30)","v":0},{"$f":"SUM(G26:G30)","v":0},{"$f":"SUM(H26:H30)","v":0},{"$f":"SUM(I26:I30)","v":0},{"$f":"SUM(J26:J30)","v":0}]
[]
[]
[]
["INDICADORES DE EVALUACIÓN FINANCIERA"]
["Período de Recuperación de la Inversión"]
[{"$f":"\"Valor presente neto al \" & TEXT(CCPP*100, \"#,##0.00\")& \"%\"","v":"Valor presente neto al 0.00%"}]
["Tasa Interna de Retorno"]
["Relación Beneficio Costo"]