{"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":1,"defined_names":7,"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":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[1,0,1,1]]}
[]
["Carniceria Santanita"]
["Tabla # 16"]
["Balanza de Inversión Inicial"]
["(Cifras en dolares)"]
[]
["CONCEPTOS","COSTO"]
["Inversión en Capital de Trabajo:"]
["CAJA",1000]
["BANCOS",5000]
["Saldo minimo de Banco",1000]
["INVENTARIOS",2324.8200000000002]
["EQUIPO DE REPARTO",1300]
["MATERIAL Y SUMINISTRO",224.7191]
["Sub total inversión en Capital de Trabajo",{"$f":"SUM(B9:B14)","v":10849.5391}]
["Inversión en Capital Fijo:"]
["EDIFICIOS",15000]
["Equipo de oficina ",1855.81]
[]
[]
["Sub total inversión en Capital Fijo",{"$f":"SUM(B17:B20)","v":16855.810000000001}]
["Inversión en Activos Intangibles:"]
["INVESTIGACIÓN",600]
["Organización ",579.42999999999995]
["Instalacion ",180.19]
[]
["Sub total inversión en Activos Intangibles",{"$f":"SUM(B23:B26)","v":1359.62}]
["MONTO DE LA INVERSIÓN INICIAL",{"$f":"B15+B21+B27","v":29064.969099999998}]
[]
["Notas: "]
["De esta manera se espera que se comporte la inversion inicial de este proyecto sabiendo","este proyecto, en caja "]
["se ha determinado esa cantidad para solventar cualquier pronostico que se requiera, asi tambien "]
["en banco se ha determinado es a cantidad para estar en la capacidad de poder Hacerle ","idad de poder hacerle"]
["frente a los pagos de cada colaborador, asi tambien se estima que  en inventario de tenga","en inventario se tenga "]
["ese monto de dinero para poder cubrir las ventas iniciales de este proyecto.  "]
["tambien se ha determinado el precio que tendra la instalacion del edificio por medio de "]
["un ingeniero, asi tambien se reflejan los gastos de contitucion para la legalizacion de este "]
["negocio."]

{"sheet":"Tabla # 2 y 3","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,1,5,5],[5,0,6,0],[0,0,0,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[29,0,29,5],[26,0,26,5],[28,0,28,5],[30,0,30,5],[31,0,32,0],[31,1,31,5]]}
["Carniceria Santanita"]
[]
["Tabla # 17"]
["Proyección de ingresos"]
["(Cifras en Dolares)"]
["CONCEPTOS","AÑOS"]
[null,1,2,3,4,5]
["Ingresos por venta de productos",{"$f":"[1]Hoja1!D9","v":326360.02676937002},{"$f":"[1]Hoja1!E9","v":390154.30789731658},{"$f":"[1]Hoja1!F9","v":466419.07158765232},{"$f":"[1]Hoja1!G9","v":557609.37650366174},{"$f":"[1]Hoja1!H9","v":666608.37602116249}]
["Ingresos por venta de servicios",0,{"$f":"B9*1.02","v":0},{"$f":"C9*1.02","v":0},0,0]
["Otros ingresos",0,{"$f":"B10","v":0},{"$f":"C10","v":0},0,0]
["Ingresos totales",{"$f":"SUM(B8:B10)","v":326360.02676937002},{"$f":"SUM(C8:C10)","v":390154.30789731658},{"$f":"SUM(D8:D10)","v":466419.07158765232},557609.37650366174,666608.37602116249]
[]
["Notas"]
["De esta manera se comportan los ingreos por venta de los productos la explicacion de la obtencion de estos datos ya fue  "]
["presentada en el estudio de mercado, ya que solo se presentan  ingresos por ventas. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Carniceria Santanita"]
[]
["Tabla # 18"]
["Proyección de costos variables"]
["(Cifras en Dolardes>>"]
["CONCEPTOS","AÑOS"]
[null,1,2,3,4,5]
["Costo variable de productos",286231.73821737,342193.47781972447,409096.40905521443,489079.66618241754,584700.60987707425,699016.59551536094]
["Costo variable de servicios",null,{"$f":"B35*1.02","v":0},{"$f":"C35*1.02","v":0},{"$f":"D35*1.02","v":0},{"$f":"E35*1.02","v":0}]
["Otros costos variables.",null,{"$f":"B36","v":0},{"$f":"C36","v":0},{"$f":"D36","v":0},{"$f":"E36","v":0}]
["Costos variables totales",{"$f":"SUM(B34:B36)","v":286231.73821737},{"$f":"SUM(C34:C36)","v":342193.47781972447},409096.40905521443,489079.66618241754,584700.60987707425]
[]
["Notas"]
["Se identificaron los costos variables habiendo obtenido un costo promedio el cual se ha registrado sacando el total de las "]
["cantidades demandadas para cada producto, asi obteniendo el total de cantidades demandadas y pasando a dividir las"]
["cantidades demandadas de cada producto por las cantidades totales de los productos obteniendo asi el peso para cada "]
["producto y asi reflejar el costo en  que el proveedor dara los productos, y asi multiplicar el costo por el peso y asi se obtiene "]
["el costo promedio para cada producto y asi se pasa ha sumar la sumas de todos los costos promedios por cada producto y asi"]
["se obtiene el costo promedio de todos los productos.",null,"y asi se procede a multiplicar la participacion de mercado, consumo"]
["de compras, costo promedio y asi se obtienen los costos variables de los productos."]

{"sheet":"Tabla # 4","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,0,1,5],[3,0,3,5],[4,0,4,5],[5,0,6,0],[5,1,5,5]]}
[null,"Carniceria Santanita"]
["Cifras Dolares"]
[]
["Tabla: 19"]
["Proyección de Costos Fijos"]
["CONCEPTOS","AÑOS"]
[null,1,2,3,4,5]
["Gastos Personales:"]
["Salarios",15280.898800000001,{"$f":"B9*1.1","v":16808.988680000002},{"$f":"C9*1.05","v":17649.438114000004},{"$f":"D9*1.05","v":18531.910019700004},19458.505520685005]
["Prestaciones de ley",{"$f":"B9*25%","v":3820.2247000000002},{"$f":"C9*25%","v":4202.2471700000006},{"$f":"D9*25%","v":4412.359528500001},{"$f":"E9*22.222222%","v":4118.2021854179784},{"$f":"F9*22.222222%","v":4324.1122946888772}]
["Obligaciones patronales",{"$f":"B9*20%","v":3056.1797600000004},{"$f":"C9*21%","v":3529.8876228000004},{"$f":"D9*21%","v":3706.3820039400007},3891.7011041370006,4086.2861593438511]
["Sub total Gastos Personales",{"$f":"SUM(B9:B11)","v":22157.303260000001},{"$f":"SUM(C9:C11)","v":24541.123472800005},25768.179646440007,26541.813309254983,27868.90397471773]
["Gastos No Personales:"]
["Cargos básicos",809.04,809.04,809.04,809.04,809.04]
[]
["Propaganda y publicidad",898.92,898.92,898.92,898.92,898.92]
["Otros"]
["Sub total Gastos No Personales",{"$f":"SUM(B14:B17)","v":1707.96},{"$f":"SUM(C14:C17)","v":1707.96},{"$f":"SUM(D14:D17)","v":1707.96},{"$f":"SUM(E14:E17)","v":1707.96},{"$f":"SUM(F14:F17)","v":1707.96}]
["COSTOS FIJOS TOTALES",{"$f":"B12+B18","v":23865.26326},{"$f":"C12+C18","v":26249.083472800005},{"$f":"D12+D18","v":27476.139646440006},{"$f":"E12+E18","v":28249.773309254982},{"$f":"F12+F18","v":29576.863974717729}]
[]
["Notas"]
["Ds esta manera los salarios estan conformados de acuerdo a la ley de los salarios minimos de nicaragua con sus reformas "]
["todo esto con sus respectivos prestaciones y obligaciones de patronales, ",null,null,"s, que lo componen el instituto nacional de "]
["seguridad social y el instituto nacional de tecnologia, asi tambien se muestran los cargos basicos como agua y luz los"]
["cuales son los servicios que requiere este proyecto, a la vez se reflejan gastos de propaganda y publicidad los cuales son "]
["los establecidos en el presupuesto de marketing."]

{"sheet":"Tabla # 5","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,8],[4,0,4,8],[0,0,0,8],[2,1,2,5],[1,1,1,5]]}
[]
[null,"Carniceria Santanita"]
[null,"Cifras en Dolares"]
["Tabla 20"]
["Programa de Depreciación de Activos"]
[]
["ACTIVO","CANTIDAD","COSTO INSTALADO","VALOR RESIDUAL","VIDA ÚTIL","DEPREC. ANUAL","VIDA DEL PROYECTO","DEPREC. ACUMULADA","VALOR EN LIBROS"]
["MESAS",3,31.8352,6.367,5,{"$f":"IFERROR(((C8-D8)/E8)*B8, 0)","v":15.280919999999998},5,{"$f":"F8*G8","v":76.404599999999988},{"$f":"(C8*B8)-H8","v":19.101000000000013}]
["EXIBIDOR",2,486.8913,97.378200000000007,5,{"$f":"IFERROR(((C9-D9)/E9)*B9, 0)","v":155.80524},5,{"$f":"F9*G9","v":779.02620000000002},{"$f":"(C9*B9)-H9","v":194.75639999999999}]
["EQUIPO DE REPARTO",1,1300,260,5,208,5,1040,260]
["COMPUTADORAS",3,262.17219999999998,157.30330000000001,5,{"$f":"IFERROR(((C11-D11)/E11)*B11, 0)","v":62.921339999999987},5,{"$f":"F11*G11","v":314.60669999999993},{"$f":"(C11*B11)-H11","v":471.90989999999999}]
["fricer",2,749.06359999999995,149.81270000000001,5,239.70035999999999,5,1198.5018,299.6253999999999]
["EDIFICIO",1,12000,2400,5,1920,5,9600,2400]
[]
[]
[]
["TOTALES",null,null,null,null,{"$f":"SUM(F8:F16)","v":2601.70786},null,null,{"$f":"SUM(I8:I9)","v":213.85739999999998}]

{"sheet":"Tabla # 6","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"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]]}
["Carniceria Santanita"]
[]
["Tabla # 21"]
["Costo de Capital Promedio Ponderado del Proyecto"]
[]
["FUENTE DE FINANCIAMIENTO",null,"MONTO","PESO","COSTO","COSTO PONDERADO"]
["Recursos propios",null,11625.987999999999,{"$f":"IFERROR(C7/$C$10, 0)","v":0.39999999999999997},0.17,{"$f":"D7*E7","v":6.8000000000000005E-2}]
["Préstamos bancarios",null,17438.982,{"$f":"IFERROR(C8/$C$10, 0)","v":0.6},9.4799999999999995E-2,{"$f":"D8*E8","v":5.6879999999999993E-2}]
[]
["Inversión Total",null,{"$f":"SUM(C7:C9)","v":29064.97},"CCPP",null,{"$f":"SUM(F7:F9)","v":0.12487999999999999}]
[]
[]
["De esta manera se espera que se comporte el costo del capital promedio ponderado del proyecto "]
["donde los socios han puesto una tasa determinada con el fin de obtener mejores beneficios"]
["y ala vez el banco ha estimado esa tasa para los prestamos en concepto de vivienda, y asi se ha determinado"]
["una tasa de credito moderada ya que es del",null,null,"40-60 y por lo tanto no es muy riesgosa. "]

{"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":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Carniceria Santanita"]
["Tabla de Amortización de Préstamos"]
[]
["Monto del Préstamo:",null,17438.982,"Suma Principal:",17438.981999999996]
[null,null,0]
["Tasa de Interés Mensual:",null,7.9000000000000008E-3,"Suma Intereses:",4525.8900000000003]
[]
["Plazo (Meses):",null,60]
[]
["N° CUOTA","PAGO","INTERESES","AMORTIZACIÓN","SALDO"]
[0,0,0,0,17438.982]
[1,366.08,137.77000000000001,228.30999999999997,17210.671999999999]
[2,366.08,135.96,230.11999999999998,16980.552]
[3,366.08,134.15,231.92999999999998,16748.621999999999]
[4,366.08,132.31,233.76999999999998,16514.851999999999]
[5,366.08,130.47,235.60999999999999,16279.241999999998]
[6,366.08,128.61000000000001,237.46999999999997,16041.771999999999]
[7,366.08,126.73,239.34999999999997,15802.421999999999]
[8,366.08,124.84,241.23999999999998,15561.181999999999]
[9,366.08,122.93,243.14999999999998,15318.031999999999]
[10,366.08,121.01,245.07,15072.962]
[11,366.08,119.08,247,14825.962]
[12,366.08,117.13,248.95,14577.011999999999,{"$f":"SUM(D12:D23)","v":2861.97}]
[13,366.08,115.16,250.92,14326.091999999999,{"$f":"SUM(C13:C24)","v":1508.3799999999999},{"$f":"F24*30%","v":452.51399999999995}]
[14,366.08,113.18,252.89999999999998,14073.191999999999]
[15,366.08,111.18,254.89999999999998,13818.291999999999]
[16,366.08,109.16,256.91999999999996,13561.371999999999]
[17,366.08,107.13,258.95,13302.421999999999]
[18,366.08,105.09,260.99,13041.431999999999]
[19,366.08,103.03,263.04999999999995,12778.382]
[20,366.08,100.95,265.13,12513.252]
[21,366.08,98.85,267.23,12246.022000000001]
[22,366.08,96.74,269.33999999999997,11976.682000000001]
[23,366.08,94.62,271.45999999999998,11705.222000000002]
[24,366.08,92.47,273.61,11431.612000000001,{"$f":"SUM(D24:D35)","v":3145.4}]
[25,366.08,90.31,275.77,11155.842000000001]
[26,366.08,88.13,277.95,10877.892]
[27,366.08,85.94,280.14,10597.752]
[28,366.08,83.72,282.36,10315.392]
[29,366.08,81.489999999999995,284.58999999999997,10030.802]
[30,366.08,79.239999999999995,286.83999999999997,9743.9619999999995]
[31,366.08,76.98,289.09999999999997,9454.8619999999992]
[32,366.08,74.69,291.39,9163.4719999999998]
[33,366.08,72.39,293.69,8869.7819999999992]
[34,366.08,70.069999999999993,296.01,8573.771999999999]
[35,366.08,67.73,298.34999999999997,8275.4219999999987]
[36,366.08,65.38,300.7,7974.7219999999988,{"$f":"SUM(D36:D47)","v":3456.89}]
[37,366.08,63,303.08,7671.6419999999989]
[38,366.08,60.61,305.46999999999997,7366.1719999999987]
[39,366.08,58.19,307.89,7058.2819999999983]
[40,366.08,55.76,310.32,6747.9619999999986]
[41,366.08,53.31,312.77,6435.1919999999991]
[42,366.08,50.84,315.24,6119.9519999999993]
[43,366.08,48.35,317.72999999999996,5802.2219999999998]
[44,366.08,45.84,320.24,5481.982]
[45,366.08,43.31,322.77,5159.2119999999995]
[46,366.08,40.76,325.32,4833.8919999999998]
[47,366.08,38.19,327.89,4506.0019999999995]
[48,366.08,35.6,330.47999999999996,4175.5219999999999,{"$f":"SUM(D48:D59)","v":3799.2}]
[49,366.08,32.99,333.09,3842.4319999999998]
[50,366.08,30.36,335.71999999999997,3506.712]
[51,366.08,27.7,338.38,3168.3319999999999]
[52,366.08,25.03,341.04999999999995,2827.2820000000002]
[53,366.08,22.34,343.74,2483.5420000000004]
[54,366.08,19.62,346.46,2137.0820000000003]
[55,366.08,16.88,349.2,1787.8820000000003]
[56,366.08,14.12,351.96,1435.9220000000003]
[57,366.08,11.34,354.74,1081.1820000000002]
[58,366.08,8.5399999999999991,357.53999999999996,723.64200000000028]
[59,366.08,5.72,360.35999999999996,363.28200000000032]
[60,366.15200000000033,2.87,363.28200000000032,0,{"$f":"SUM(D60:D71)","v":4175.5220000000008}]

{"sheet":"Flujo","index":7,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,44,8],[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]]}
["Carniceria Santanita"]
["Tabla # 23"]
["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'!B15","v":-10849.5391}]
["Inversión en Activos Fijos",null,null,null,{"$f":"-'Tabla # 1'!B21","v":-16855.810000000001}]
["Inversión en Activos Intangibles",null,null,null,{"$f":"-'Tabla # 1'!B27","v":-1359.62}]
["Flujos Operativos durante la vida del Proyecto"]
["Ingresos por ventas",null,null,null,null,{"$f":"'Tabla # 2 y 3'!B11","v":326360.02676937002},{"$f":"'Tabla # 2 y 3'!C11","v":390154.30789731658},{"$f":"'Tabla # 2 y 3'!D11","v":466419.07158765232},{"$f":"'Tabla # 2 y 3'!E11","v":557609.37650366174},{"$f":"'Tabla # 2 y 3'!F11","v":666608.37602116249}]
["Costos variables",null,null,null,null,{"$f":"-'Tabla # 2 y 3'!B37","v":-286231.73821737},{"$f":"-'Tabla # 2 y 3'!C37","v":-342193.47781972447},{"$f":"-'Tabla # 2 y 3'!D37","v":-409096.40905521443},{"$f":"-'Tabla # 2 y 3'!E37","v":-489079.66618241754},{"$f":"-'Tabla # 2 y 3'!F37","v":-584700.60987707425}]
["Costos Fijos",null,null,null,null,{"$f":"-'Tabla # 4'!B19","v":-23865.26326},{"$f":"-'Tabla # 4'!C19","v":-26249.083472800005},{"$f":"-'Tabla # 4'!D19","v":-27476.139646440006},{"$f":"-'Tabla # 4'!E19","v":-28249.773309254982},{"$f":"-'Tabla # 4'!F19","v":-29576.863974717729}]
["Depreciaciones",null,null,null,null,{"$f":"-'Tabla # 5'!F17","v":-2601.70786},{"$f":"F15","v":-2601.70786},{"$f":"G15","v":-2601.70786},-2601.70786,-2601.70786]
["Amortizaciones",null,null,null,null,{"$f":"E10/J6","v":-271.92399999999998},{"$f":"F16","v":-271.92399999999998},{"$f":"G16","v":-271.92399999999998},-271.92399999999998,-271.92399999999998]
["Utilidades antes de Impuestos",null,null,null,null,{"$f":"SUM(F12:F16)","v":13389.393432000012},{"$f":"SUM(G12:G16)","v":18838.114744792107},26972.89102599788,37406.305151989218,49457.270309370506]
["Impuesto sobre la renta 30%",null,null,null,null,{"$f":"IF(F17>0, -F17*30%, 0)","v":-4016.8180296000032},{"$f":"IF(G17>0, -G17*30%, 0)","v":-5651.4344234376322},-8091.8673077993635,-11221.891545596765,-14837.181092811152]
["Utilidades después de impuestos",null,null,null,null,{"$f":"SUM(F17:F18)","v":9372.5754024000089},{"$f":"SUM(G17:G18)","v":13186.680321354474},18881.023718198518,26184.413606392452,34620.089216559354]
["(+) Depreciaciones y Amortizaciones",null,null,null,null,{"$f":"ABS(SUM(F15:F16))","v":2873.63186},{"$f":"ABS(SUM(G15:G16))","v":2873.63186},2873.63186,2873.63186,2873.63186]
["Flujos de Caja Anuales",null,null,null,null,{"$f":"SUM(F19:F20)","v":12246.207262400008},{"$f":"SUM(G19:G20)","v":16060.312181354473},21754.655578198519,29058.045466392454,{"$f":"SUM(J19:J20)","v":37493.721076559355}]
["Flujo de Caja del ultimo año"]
["Retorno del Capital de Trabajo",null,null,null,null,null,null,null,null,{"$f":"ABS(E8)","v":10849.5391}]
["Valor de salvamento neto",null,null,null,null,null,null,null,null,{"$f":"'Tabla # 5'!I17","v":213.85739999999998}]
["Flujo Final Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J24)","v":11063.396500000001}]
["Flujo de Caja Neto sin Financiamiento",null,null,null,{"$f":"SUM(E8:E10)","v":-29064.969099999998},{"$f":"F21","v":12246.207262400008},{"$f":"G21","v":16060.312181354473},21754.655578198519,29058.045466392454,{"$f":"J21+J25","v":48557.117576559358}]
["Financiamiento"]
["Préstamos bancarios",null,null,null,{"$f":"monto","v":17438.982}]
["Amortización de la Deuda",null,null,null,null,{"$f":"-IF(term>0, SUM(Amortizaciones!D12:D23), 0)","v":-2861.97},{"$f":"-IF(term>12, SUM(Amortizaciones!D24:D35), 0)","v":-3145.4},{"$f":"-IF(term>12, SUM(Amortizaciones!D36:D47), 0)","v":-3456.89},{"$f":"-IF(term>12, SUM(Amortizaciones!D48:D59), 0)","v":-3799.2},{"$f":"-IF(term>12, SUM(Amortizaciones!D60:D71), 0)","v":-4175.5220000000008}]
["Escudo fiscal de los intereses",null,null,null,null,{"$f":"IF(term>0, SUM(Amortizaciones!C13:C24)*30%, 0)","v":452.51399999999995},{"$f":"IF(term>12, SUM(Amortizaciones!C25:C36)*30%, 0)","v":366.81299999999999},{"$f":"IF(term>12, SUM(Amortizaciones!C37:C48)*30%, 0)","v":272.62800000000004},{"$f":"IF(term>12, SUM(Amortizaciones!C49:C60)*30%, 0)","v":169.12500000000003},{"$f":"IF(term>12, SUM(Amortizaciones!C61:C72)*30%, 0)","v":55.356000000000002}]
["Flujo de Caja Neto con Financiamiento",null,null,null,{"$f":"SUM(E26:E28)","v":-11625.987099999998},{"$f":"SUM(F26:F30)","v":9836.7512624000083},{"$f":"SUM(G26:G30)","v":13281.725181354474},{"$f":"SUM(H26:H30)","v":18570.39357819852},{"$f":"SUM(I26:I30)","v":25427.970466392453},{"$f":"SUM(J26:J30)","v":44436.951576559353}]
[]
[]
[]
["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 12.49%"},null,null,null,{"$f":"NPV(CCPP, F31:J31)+E31","v":61215.760566902143}]
["Tasa Interna de Retorno",null,null,null,null,{"$f":"IRR(E31:J31)","v":1.1373780754326641}]
["Relación Beneficio Costo",null,null,null,null,{"$f":"(E37+ABS(E31))/ABS(E31)","v":6.2654247798797362}]
[]
["Consideramos que este proyecto que este proyecto es sumamente rentable ya que con los datos facilitados en las tablas anteriores , la inversion inicial se recuperara en el plazo de 4 menes presentando unos unos indicadores de evaliacion financiera beneficiosos para la ejecucion de este. "]