{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["I.I","I&E","CF","Depr","Fin","amort","Flujo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"I.I","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["Nombre del negocio"]
["Tabla # XX"]
["Balanza de Inversión Consolidada"]
["(Cifras en indicar la moneda)"]
[]
["CONCEPTOS","VALOR"]
["Inversión en Capital de Trabajo:"]
["Cuenta 1"]
["Cuenta 2"]
["Cuenta 3"]
["Cuenta 4"]
["Sub Total Inversión en Capital de Trabajo",{"$f":"SUM(B8:B11)","v":0}]
["Inversión en Capital Fijo:"]
["Cuenta 1"]
["Cuenta 2"]
["Cuenta 3"]
["Cuenta 4"]
["Sub Total Inversión en Capital Fijo",{"$f":"SUM(B14:B17)","v":0}]
["Inversión en Gastos Preoperativos:"]
["Cuenta 1"]
["Cuenta 2"]
["Cuenta 3"]
["Cuenta 4"]
["Sub Total Inversión en Gastos Preoperativos",{"$f":"SUM(B20:B23)","v":0}]
["TOTAL INVERSIÓN INICIAL",{"$f":"B12+B18+B24","v":0}]
[]
["Notas:"]

{"sheet":"I&E","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,6,1,7],[2,6,2,7],[3,6,3,7],[0,6,0,7],[30,0,30,5],[5,1,5,5],[5,0,6,0],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[31,0,31,5],[32,0,32,5],[33,0,33,5],[35,0,36,0],[35,1,35,5]]}
["Nombre del negocio",null,null,null,null,null,"Incremento Demanda"]
["Tabla # XX",null,null,null,null,null,0]
["Proyección de ingresos por ventas",null,null,null,null,null,"Inflación Anual"]
["(Cifras en indicar la moneda)",null,null,null,null,null,0]
[]
["CONCEPTOS","AÑOS DE OPERACIÓN DEL PROYECTO"]
[null,1,2,3,4,5]
["Ingresos por venta de productos",0,{"$f":"B8*(1+aumento_demanda)*(1+aumento_inflacion)","v":0},0,0,0]
["Ingresos por venta de servicios",0,0,0,0,0]
["Otros ingresos",0,0,0,0,0]
["Ingresos Totales",{"$f":"SUM(B8:B10)","v":0},{"$f":"SUM(C8:C10)","v":0},0,0,0]
[]
["Notas:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nombre del negocio"]
["Tabla # XX"]
["Proyección de costos variables"]
["(Cifras en indicar la moneda)"]
[]
["CONCEPTOS","AÑOS DE OPERACIÓN DEL PROYECTO"]
[null,1,2,3,4,5]
["Costos variables de productos",0,{"$f":"B38*(1+aumento_demanda)*(1+aumento_inflacion)","v":0},0,0,0]
["Costos variables de servicios",0,0,0,0,0]
["Otros costos variables",0,0,0,0,0]
["Costos variables totales",{"$f":"SUM(B38:B40)","v":0},{"$f":"SUM(C38:C40)","v":0},{"$f":"SUM(D38:D40)","v":0},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0}]
[]
["Notas:"]

{"sheet":"CF","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,7,5,8],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[5,1,5,5],[5,0,6,0],[0,7,0,8],[1,7,1,8],[2,7,2,8],[3,7,3,8],[4,7,4,8]]}
["Nombre del negocio",null,null,null,null,null,null,"Ajuste salarial"]
["Tabla # XX",null,null,null,null,null,null,0.1]
["Proyección de Costos Fijos",null,null,null,null,null,null,"Prestaciones año 1-3"]
["(Cifras en indicar la moneda)",null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,"Prestaciones año 1-5"]
["CONCEPTOS","AÑOS DE OPERACIÓN DEL PROYECTO",null,null,null,null,null,0.22222222]
[null,1,2,3,4,5]
["Gastos personales:"]
["Salarios",0,{"$f":"B9*(1+ajuste_salarial)","v":0},{"$f":"C9*(1+ajuste_salarial)","v":0},{"$f":"D9*(1+ajuste_salarial)","v":0},{"$f":"E9*(1+ajuste_salarial)","v":0}]
["Prestaciones de ley",{"$f":"B9*prestaciones_1_3","v":0},{"$f":"C9*prestaciones_1_3","v":0},{"$f":"D9*prestaciones_1_3","v":0},{"$f":"E9*prestaciones_4_5","v":0},{"$f":"F9*prestaciones_4_5","v":0}]
["Gastos patronales",{"$f":"B9*20%","v":0},{"$f":"C9*21%","v":0},{"$f":"D9*21%","v":0},0,0]
["Sub total gastos personales",{"$f":"SUM(B9:B11)","v":0},{"$f":"SUM(C9:C11)","v":0},0,0,0]
["Gastos no personales:"]
["Cargos básicos",0,{"$f":"B14*(1+aumento_inflacion)","v":0},0,0,0]
["Gasto en papelería y útiles",0,0,0,0,0]
["Gastos en materiales y suministros",0,0,0,0,0]
["Gastos en mantenimiento",0,0,0,0,0]
["Gastos en publicidad",0,{"$f":"B18","v":0},{"$f":"C18","v":0},0,0]
["Otros gastos",0,{"$f":"B19","v":0},0,0,0]
["Sub total gastos no personales",{"$f":"SUM(B14:B19)","v":0},{"$f":"SUM(C14:C19)","v":0},0,0,0]
["Gastos fijos totales",{"$f":"B12+B20","v":0},{"$f":"C12+C20","v":0},0,0,0]
[]
["Notas:"]

{"sheet":"Depr","index":3,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8]]}
["Nombre del negocio"]
["Tabla # XX"]
["Programa de depreciación de activos"]
["(Cifras en indicar la moneda)"]
[]
["ACTIVO","CANTIDAD","COSTO INSTALADO","VALOR RESIDUAL","VIDA ÚTIL","DEPRECIACIÓN ANUAL","VIDA ECONÓMICA DEL PROYECTO","DEPRECIACIÓN ACUMULADA","VALOR EN LIBROS"]
[null,null,null,null,null,{"$f":"IF(AND(B7<>\"\", C7<>\"\", D7<>\"\", E7<>\"\"), B7*(C7-D7)/E7, 0)","v":0},null,{"$f":"IF(G7<>\"\", F7*G7, \"\")","v":""},{"$f":"IF(AND(C7<>\"\", H7<>\"\"), C7*B7-H7, 0)","v":0}]
[null,null,null,null,null,0,{"$f":"IF(AND(G7<>\"\", F8<>0), G7,\"\")","v":""},{"$f":"IF(G8<>\"\", F8*G8, \"\")","v":""},0]
[null,null,null,null,null,0,{"$f":"IF(AND(G8<>\"\", F9<>0), G8,\"\")","v":""},{"$f":"IF(G9<>\"\", F9*G9, \"\")","v":""},0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,{"$f":"IF(AND(B18<>\"\", C18<>\"\", D18<>\"\", E18<>\"\"), B18*(C18-D18)/E18, 0)","v":0},"","",{"$f":"IF(AND(C18<>\"\", H18<>\"\"), C18*B18-H18, 0)","v":0}]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
[null,null,null,null,null,0,"","",0]
["TOTALES",null,null,null,null,{"$f":"SUM(F7:F41)","v":0},null,null,{"$f":"SUM(I7:I41)","v":0}]

{"sheet":"Fin","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
["Nombre del negocio"]
["Tabla # XX"]
["Tasa de Rentabilidad Mínima Requerida del Proyecto"]
["(Cifras en indicar la moneda)"]
[]
["FUENTES","APORTE MONETARIO","PESO\n(%)","COSTO","COSTO PONDERADO"]
["Fuente 1",null,{"$f":"IF(B7<>\"\", B7/$B$10, 0)","v":0},null,{"$f":"C7*D7","v":0}]
["Fuente 2",null,{"$f":"IF(B8<>\"\", B8/$B$10, 0)","v":0},null,{"$f":"C8*D8","v":0}]
["Fuente 3",null,0,null,0]
["TOTAL",{"$f":"SUM(B7:B9)","v":0},{"$f":"SUM(C7:C9)","v":0},"CCPP:",{"$f":"SUM(E7:E9)","v":0}]

{"sheet":"amort","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7]]}
[null,"Nombre del negocio"]
[null,"Plan de Amortización de la Deuda"]
[null,null,null,null,null,null,null,"Moneda"]
[null,"Valor Préstamo:",null,"Frec. Pagos:",null,"Tipo Amortiz:"]
[]
[null,"Plazo en años:",null,"Tasa anual:",null,"Fecha entrega:"]
[]
["CUOTA N°","FECHA","DIAS","PAGO","MANTEN. VALOR","INTERESES","AMORTIZACIÓN","SALDO"]

{"sheet":"Flujo","index":6,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,1,5,6],[34,0,34,1],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6]]}
["Nombre del negocio"]
["Tabla # XX"]
["Tasa de Rentabilidad Mínima Requerida del Proyecto"]
["(Cifras en indicar la moneda)"]
[]
["Conceptos","Años de operación del proyecto"]
[null,0,1,2,3,4,5]
["Inversiones realizadas en el año cero"]
["Inversión en Capital de Trabajo",{"$f":"-inversion_capital_de_trabajo","v":0}]
["Inversión en Capital Fijo",{"$f":"-inversion_capital_fijo","v":0}]
["Inversión en Gastos Preoperativos",{"$f":"-inversion_gastos_preoperativos","v":0}]
["Flujos operativos del proyecto"]
["Ingresos por venta de bienes y servicios",null,{"$f":"'I&E'!B11","v":0},{"$f":"'I&E'!C11","v":0},{"$f":"'I&E'!D11","v":0},{"$f":"'I&E'!E11","v":0},{"$f":"'I&E'!F11","v":0}]
["Costos variables de bienes y servicios",null,{"$f":"-'I&E'!B41","v":0},{"$f":"-'I&E'!C41","v":0},{"$f":"-'I&E'!D41","v":0},{"$f":"-'I&E'!E41","v":0},{"$f":"-'I&E'!F41","v":0}]
["Costos fijos",null,{"$f":"-CF!B21","v":0},{"$f":"-CF!C21","v":0},{"$f":"-CF!D21","v":0},{"$f":"-CF!E21","v":0},{"$f":"-CF!F21","v":0}]
["Depreciaciones",null,{"$f":"-Depr!F42","v":0},{"$f":"C16","v":0},{"$f":"D16","v":0},0,0]
["Amortización de intangibles",null,{"$f":"B11/G7","v":0},{"$f":"C17","v":0},{"$f":"D17","v":0},0,0]
["Utilidades antes de impuestos",null,{"$f":"SUM(C13:C17)","v":0},{"$f":"SUM(D13:D17)","v":0},0,0,0]
["Impuestos sobre la renta (30%)",null,{"$f":"IF(C18>0, -C18*30%, 0)","v":0},{"$f":"IF(D18>0, -D18*30%, 0)","v":0},0,0,{"$f":"IF(G18>0, -G18*30%, 0)","v":0}]
["Utilidades después de impuestos",null,{"$f":"C18+C19","v":0},{"$f":"D18+D19","v":0},0,0,0]
["(+) Depreciaciones y amortizaciones",null,{"$f":"ABS(C16+C17)","v":0},{"$f":"ABS(D16+D17)","v":0},0,0,0]
["(=) Flujos de caja anuales del proyecto",null,{"$f":"SUM(C20:C21)","v":0},{"$f":"SUM(D20:D21)","v":0},0,0,0]
["Flujo de caja del último año"]
["Retorno del Capital de trabajo",null,null,null,null,null,{"$f":"inversion_capital_de_trabajo","v":0}]
["Valores de salvamento neto",null,null,null,null,null,{"$f":"valores_salvamento_neto","v":0}]
["Sub total flujo de caja del último año",null,null,null,null,null,{"$f":"SUM(G24:G25)","v":0}]
["Flujos de caja neto sin financiamiento",{"$f":"SUM(B9:B11)","v":0},{"$f":"C22","v":0},{"$f":"D22","v":0},0,0,{"$f":"G22+G26","v":0}]
["Financiamiento"]
["Préstamos",{"$f":"principal","v":0}]
["Amortización del principal",null,{"$f":"-IF(capitalizaciones = \"Mensual\", SUM(amort!G10:G21), IF(capitalizaciones = \"Trimestral\", SUM(amort!G10:G13), IF(capitalizaciones = \"Semestral\", SUM(amort!G10:G11), amort!G10)))","v":0},{"$f":"IF(plazo>=D7, -IF(capitalizaciones = \"Mensual\", SUM(amort!G22:G33), IF(capitalizaciones = \"Trimestral\", SUM(amort!G14:G17), IF(capitalizaciones = \"Semestral\", SUM(amort!G12:G13), amort!G11))), 0)","v":0},{"$f":"IF(plazo>=E7, -IF(capitalizaciones = \"Mensual\", SUM(amort!G34:G45), IF(capitalizaciones = \"Trimestral\", SUM(amort!G18:G21), IF(capitalizaciones = \"Semestral\", SUM(amort!G14:G15), amort!G12))),0)","v":0},{"$f":"IF(plazo>=F7, -IF(capitalizaciones = \"Mensual\", SUM(amort!G46:G57), IF(capitalizaciones = \"Trimestral\", SUM(amort!G22:G25), IF(capitalizaciones = \"Semestral\", SUM(amort!G16:G17), amort!G13))), 0)","v":0},{"$f":"IF(plazo>=G7, -IF(capitalizaciones = \"Mensual\", SUM(amort!G58:G69), IF(capitalizaciones = \"Trimestral\", SUM(amort!G26:G29), IF(capitalizaciones = \"Semestral\", SUM(amort!G18:G19), amort!G14))), 0)","v":0}]
["Escudo fiscal de los intereses",null,{"$f":"IF(capitalizaciones=\"Mensual\",SUM(amort!E10:F21),IF(capitalizaciones=\"Trimestral\",SUM(amort!E10:F13),IF(capitalizaciones=\"Semestral\",SUM(amort!E10:F11),SUM(amort!E10:F10))))*30%","v":0},{"$f":"IF(plazo>=D7, IF(capitalizaciones = \"Mensual\", SUM(amort!E22:F33), IF(capitalizaciones = \"Trimestral\", SUM(amort!E14:F17), IF(capitalizaciones = \"Semestral\", SUM(amort!E12:F13), SUM(amort!E11:F11))))*30%, 0)","v":0},{"$f":"IF(plazo>=E7, IF(capitalizaciones = \"Mensual\", SUM(amort!E34:F45), IF(capitalizaciones = \"Trimestral\", SUM(amort!E18:F21), IF(capitalizaciones = \"Semestral\", SUM(amort!E14:F15), SUM(amort!E12:F12))))*30%, 0)","v":0},{"$f":"IF(plazo>=F7, IF(capitalizaciones = \"Mensual\", SUM(amort!E46:F57), IF(capitalizaciones = \"Trimestral\", SUM(amort!E22:F25), IF(capitalizaciones = \"Semestral\", SUM(amort!E16:F17), SUM(amort!E13:F13))))*30%, 0)","v":0},{"$f":"IF(plazo>=G7, IF(capitalizaciones = \"Mensual\", SUM(amort!E58:F69), IF(capitalizaciones = \"Trimestral\", SUM(amort!E26:F29), IF(capitalizaciones = \"Semestral\", SUM(amort!E18:F19), SUM(amort!E14:F14))))*30%, 0)","v":0}]
["Flujos de caja neto con financiamiento",{"$f":"SUM(B27:B31)","v":0},{"$f":"SUM(C27:C31)","v":0},0,0,0,0]
[]
[]
["INDICADORES DE EVALUACIÓN FINANCIERA"]
["PERÍODO DE RECUPERACIÓN (PRI)",{"$f":"IF(SUM(B32:C32)>0, B7 + ABS(B32/C32), IF(SUM(B32:D32)>0, C7 + ABS(SUM(B32:C32)/D32), IF(SUM(B32:E32)>0, D7 + ABS(SUM(B32:D32)/E32), IF(SUM(B32:F32)>0, E7 + ABS(SUM(B32:E32)/F32), IF(SUM(B32:G32)>0, F7 + ABS(SUM(B32:F32)/G32), \"Más de 5 Años\")))))","v":"Más de 5 Años"}]
[{"$f":"\"VALOR PRESENTE NETO AL \" & TEXT(ccpp * 100, \"##0.00\") &\"%\"","v":"VALOR PRESENTE NETO AL 0.00%"},{"$f":"NPV(ccpp, C32:G32)+B32","v":0}]
["TASA INTERNA DE RETORNO",{"$f":"IFERROR(IRR(B32:G32), 0)","v":0}]
["RELACIÓN BENEFICIO/COSTO",{"$f":"IFERROR((B37+ ABS(B32))/ABS(B32), 0)","v":0}]