{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INVERSIÓN","FINANCIACIÓN","INGRESOS Y COSTES","ESTADOS FINANCIEROS","VALORACIÓN Y RENTABILIDAD"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"INVERSIÓN","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"VAN",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F2","v":548675.29532205523}]
[null,null,"TIR",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F3","v":0.17904917042371715}]
[null,null,"TIR Capital",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F4","v":0.27368271124511612}]
[null,null,null,null,null,"Cuadro de Amortización Técnica"]
[null,"Concepto","Cuantía","Coef.",1,{"$f":"E6+1","v":2},{"$f":"F6+1","v":3},4,5]
[null,"Inmovilizado Material"]
[null,"Terrenos",240000,0,{"$f":"D8*C8","v":0},{"$f":"IF($E8<($C8-SUM($E8:E8)),$E8,($C8-SUM($E8:E8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:F8)),$E8,($C8-SUM($E8:F8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:G8)),$E8,($C8-SUM($E8:G8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:H8)),$E8,($C8-SUM($E8:H8)))","v":0}]
[null,"Edificios",430000,0.03,{"$f":"D9*C9","v":12900},{"$f":"IF($E9<($C9-SUM($E9:E9)),$E9,($C9-SUM($E9:E9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:F9)),$E9,($C9-SUM($E9:F9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:G9)),$E9,($C9-SUM($E9:G9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:H9)),$E9,($C9-SUM($E9:H9)))","v":12900}]
[null,"Maquinaria",73000,0.12,8760,{"$f":"IF($E10<($C10-SUM($E10:E10)),$E10,($C10-SUM($E10:E10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:F10)),$E10,($C10-SUM($E10:F10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:G10)),$E10,($C10-SUM($E10:G10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:H10)),$E10,($C10-SUM($E10:H10)))","v":8760}]
[null,"Equipamiento",61350,0.15,9202.5,{"$f":"IF($E11<($C11-SUM($E11:E11)),$E11,($C11-SUM($E11:E11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:F11)),$E11,($C11-SUM($E11:F11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:G11)),$E11,($C11-SUM($E11:G11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:H11)),$E11,($C11-SUM($E11:H11)))","v":9202.5}]
[null,"Mobiliario",140000,0.12,16800,{"$f":"IF($E12<($C12-SUM($E12:E12)),$E12,($C12-SUM($E12:E12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:F12)),$E12,($C12-SUM($E12:F12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:G12)),$E12,($C12-SUM($E12:G12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:H12)),$E12,($C12-SUM($E12:H12)))","v":16800}]
[null,"Equipos Informáticos",40000,0.23,9200,{"$f":"IF($E13<($C13-SUM($E13:E13)),$E13,($C13-SUM($E13:E13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:F13)),$E13,($C13-SUM($E13:F13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:G13)),$E13,($C13-SUM($E13:G13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:H13)),$E13,($C13-SUM($E13:H13)))","v":3200}]
[null,"Varios",34000,0.15,5100,{"$f":"IF($E14<($C14-SUM($E14:E14)),$E14,($C14-SUM($E14:E14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:F14)),$E14,($C14-SUM($E14:F14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:G14)),$E14,($C14-SUM($E14:G14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:H14)),$E14,($C14-SUM($E14:H14)))","v":5100}]
[null,"Otros",0,0,0,{"$f":"IF($E15<($C15-SUM($E15:E15)),$E15,($C15-SUM($E15:E15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:F15)),$E15,($C15-SUM($E15:F15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:G15)),$E15,($C15-SUM($E15:G15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:H15)),$E15,($C15-SUM($E15:H15)))","v":0}]
[null,"Otros",0,0,0,{"$f":"IF($E16<($C16-SUM($E16:E16)),$E16,($C16-SUM($E16:E16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:F16)),$E16,($C16-SUM($E16:F16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:G16)),$E16,($C16-SUM($E16:G16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:H16)),$E16,($C16-SUM($E16:H16)))","v":0}]
[null,"Total Inmovilizado Material",{"$f":"SUM(C8:C16)","v":1018350},null,{"$f":"SUM(E8:E16)","v":61962.5},{"$f":"SUM(F8:F16)","v":61962.5},{"$f":"SUM(G8:G16)","v":61962.5},61962.5,{"$f":"SUM(I8:I16)","v":55962.5}]
[null,"Inmovilizado Intangible"]
[null,"Propiedad Intelectual",23000,0.2,{"$f":"D19*C19","v":4600},{"$f":"IF($E19<($C19-SUM($E19:E19)),$E19,($C19-SUM($E19:E19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:F19)),$E19,($C19-SUM($E19:F19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:G19)),$E19,($C19-SUM($E19:G19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:H19)),$E19,($C19-SUM($E19:H19)))","v":4600}]
[null,"Aplicaciones Informáticas",3500,0.2,{"$f":"D20*C20","v":700},{"$f":"IF($E20<($C20-SUM($E20:E20)),$E20,($C20-SUM($E20:E20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:F20)),$E20,($C20-SUM($E20:F20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:G20)),$E20,($C20-SUM($E20:G20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:H20)),$E20,($C20-SUM($E20:H20)))","v":700}]
[null,"Otros",2450,0.2,{"$f":"D21*C21","v":490},{"$f":"IF($E21<($C21-SUM($E21:E21)),$E21,($C21-SUM($E21:E21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:F21)),$E21,($C21-SUM($E21:F21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:G21)),$E21,($C21-SUM($E21:G21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:H21)),$E21,($C21-SUM($E21:H21)))","v":490}]
[null,"Total Inmovilizado Intangible",{"$f":"SUM(C19:C21)","v":28950},null,{"$f":"SUM(E19:E21)","v":5790},{"$f":"SUM(F19:F21)","v":5790},{"$f":"SUM(G19:G21)","v":5790},5790,5790]
[]
[null,"Total Inmovilizado",{"$f":"C17+C22","v":1047300},null,{"$f":"E17+E22","v":67752.5},67752.5,{"$f":"G17+G22","v":67752.5},67752.5,61752.5]
[]
[]
[null,"Total Inversión Inicial"]
[null,"Inmovilizado",{"$f":"C24","v":1047300}]
[null,"Fondo de Maniobra Inicial",{"$f":"'ESTADOS FINANCIEROS'!C34-'ESTADOS FINANCIEROS'!C43","v":61166.666666666664}]
[null,"Total",{"$f":"SUM(C28:C29)","v":1108466.6666666667}]

{"sheet":"FINANCIACIÓN","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Total a Financiar",{"$f":"INVERSIÓN!C30","v":1108466.6666666667},null,null,null,{"$f":"INVERSIÓN!C2","v":"VAN"},{"$f":"INVERSIÓN!D2","v":548675.29532205523}]
[null,null,null,null,null,null,{"$f":"INVERSIÓN!C3","v":"TIR"},{"$f":"INVERSIÓN!D3","v":0.17904917042371715}]
[null,"Composición de la financiación inicial",null,null,null,null,{"$f":"INVERSIÓN!C4","v":"TIR Capital"},{"$f":"INVERSIÓN!D4","v":0.27368271124511612}]
[null,null,"Porcentaje","Coste","Cuantía"]
[null,"Capital",0.4,0.15,{"$f":"C6*$C$2","v":443386.66666666674}]
[null,"Subvención",0.05,null,{"$f":"C7*$C$2","v":55423.333333333343}]
[null,"Deuda",{"$f":"1-C7-C6","v":0.54999999999999993},{"$f":"C13*(1-'ESTADOS FINANCIEROS'!E3)","v":4.1999999999999996E-2},{"$f":"C8*$C$2","v":609656.66666666663}]
[null,null,"CCMP =",{"$f":"D6*C6+D8*C8","v":8.3099999999999993E-2}]
[]
[null,"Datos del préstamo"]
[null,"Cuantía",{"$f":"E8","v":609656.66666666663}]
[null,"Tasa",0.06]
[null,"Duración",10]
[]
[null,"Cuadro de amortización del préstamo"]
[null,"Periodo",1,{"$f":"C17+1","v":2},{"$f":"D17+1","v":3},4,5,6]
[null,"Cap. Pend. Inicial",{"$f":"C12","v":609656.66666666663},{"$f":"C18-C19","v":563403.26015122153},{"$f":"D18-D19","v":514374.64924484969},462404.32168409554,407315.77446969616,{"$f":"G18-G19","v":348921.91442243278}]
[null,"Amortización",{"$f":"IF(C17<=$C$14,-PPMT($C$13,C17,$C$14,$C$12),0)","v":46253.406515445131},{"$f":"IF(D17<=$C$14,-PPMT($C$13,D17,$C$14,$C$12),0)","v":49028.61090637184},51970.327560754151,55088.547214399405,58393.860047263363,{"$f":"IF(H17<=$C$14,-PPMT($C$13,H17,$C$14,$C$12),0)","v":61897.491650099168}]
[null,"Intereses",{"$f":"$C$13*C18","v":36579.399999999994},{"$f":"$C$13*D18","v":33804.195609073293},30862.478954690981,27744.259301045731,24438.94646818177,{"$f":"$C$13*H18","v":20935.314865345965}]
[null,"Cuota",{"$f":"C19+C20","v":82832.806515445118},{"$f":"D19+D20","v":82832.806515445132},82832.806515445132,82832.806515445132,82832.806515445132,82832.806515445132]
[null,"Cap. Pend. Final",{"$f":"C18-C19","v":563403.26015122153},{"$f":"D18-D19","v":514374.64924484969},462404.32168409554,407315.77446969616,348921.91442243278,{"$f":"H18-H19","v":287024.42277233361}]

{"sheet":"INGRESOS Y COSTES","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"FINANCIACIÓN!G2","v":"VAN"},{"$f":"FINANCIACIÓN!H2","v":548675.29532205523}]
[null,{"$f":"FINANCIACIÓN!G3","v":"TIR"},{"$f":"FINANCIACIÓN!H3","v":0.17904917042371715}]
[null,{"$f":"FINANCIACIÓN!G4","v":"TIR Capital"},{"$f":"FINANCIACIÓN!H4","v":0.27368271124511612},{"$f":"INVERSIÓN!E6","v":1},{"$f":"D4+1","v":2},{"$f":"E4+1","v":3},4,5,6]
[null,"IPC",0.03,{"$f":"C5","v":0.03},{"$f":"D5","v":0.03},0.03,0.03,0.03]
[null,"Índice",null,1,{"$f":"D6*(1+D5)","v":1.03},{"$f":"E6*(1+E5)","v":1.0609},1.092727,1.1255088100000001,1.1592740743000001]
[]
[null,"Ingresos",null,{"$f":"D4","v":1},2,3,4,5,6]
[null,"Producto A"]
[null,"Precio",50,{"$f":"$C$10*D6","v":50},51.5,53.044999999999995,54.63635,56.275440500000009,57.963703715000001]
[null,"Unidades",5000,{"$f":"C11","v":5000},{"$f":"D11*(1+E12)","v":6250},{"$f":"E11*(1+F12)","v":7500},8625,{"$f":"G11*(1+H12)","v":9056.25},9327.9375]
[null,"Crecimiento",null,null,0.25,0.2,0.15,0.05,{"$f":"'VALORACIÓN Y RENTABILIDAD'!C2","v":0.03}]
[null,"Ingresos",null,{"$f":"D11*D10","v":250000},{"$f":"E11*E10","v":321875},397837.49999999994,{"$f":"G11*G10","v":471238.51874999999},509644.45802812511,{"$f":"I11*I10","v":540681.80552203779}]
[]
[null,"Producto B"]
[null,"Precio",60,{"$f":"$C$16*D6","v":60},61.800000000000004,63.653999999999996,65.56362,67.530528600000011,69.556444458000001]
[null,"Unidades",4000,{"$f":"C17","v":4000},{"$f":"D17*(1+E18)","v":5200},{"$f":"E17*(1+F18)","v":6240},{"$f":"F17*(1+G18)","v":7175.9999999999991},{"$f":"G17*(1+H18)","v":7534.7999999999993},7760.8439999999991]
[null,"Crecimiento",null,null,0.3,0.2,0.15,0.05,{"$f":"'VALORACIÓN Y RENTABILIDAD'!C2","v":0.03}]
[null,"Ingresos",null,{"$f":"D17*D16","v":240000},{"$f":"E17*E16","v":321360},397200.95999999996,{"$f":"G17*G16","v":470484.53711999994},508829.02689528005,{"$f":"I17*I16","v":539816.71463320253}]
[]
[null,"Total Ingresos",null,{"$f":"D13+D19","v":490000},643235,795038.46,941723.05586999992,1018473.4849234051,1080498.5201552403]
[]
[null,"Costes Fijos",null,{"$f":"D8","v":1},2,3,4,5,6]
[null,"Personal",160000,{"$f":"$C24*D$6","v":160000},164800,169744,174836.32,{"$f":"$C24*H$6","v":180081.40960000001},185483.851888]
[null,"Gastos Generales",35000,35000,36050,37131.5,38245.445,39392.808350000007,40574.5926005]
[null,"Gastos Varios",15000,15000,15450,15913.5,16390.904999999999,16882.632150000001,17389.1111145]
[null,"Gastos de Constitución",2000,{"$f":"C27","v":2000}]
[null,"Total Costes Fijos",null,{"$f":"SUM(D24:D27)","v":212000},{"$f":"SUM(E24:E27)","v":216300},222789,229472.67,{"$f":"SUM(H24:H27)","v":236356.85010000001},243447.55560300002]
[]
[null,"Costes Variables",null,{"$f":"D4","v":1},2,3,4,5,6]
[null,{"$f":"B9","v":"Producto A"}]
[null,"Materias Primas",0.4,{"$f":"$C32*D$13","v":100000},128750,159135,188495.4075,203857.78321125006,216272.72220881513]
[null,"Otros",0.1,25000,32187.5,39783.75,47123.851875,50964.445802812515,54068.180552203783]
[null,{"$f":"\"Variables  \"&B31","v":"Variables  Producto A"},null,{"$f":"SUM(D32:D33)","v":125000},160937.5,198918.75,235619.25937499999,{"$f":"SUM(H32:H33)","v":254822.22901406258},270340.90276101889]
[]
[null,{"$f":"B15","v":"Producto B"}]
[null,"Materias Primas",0.45,{"$f":"$C37*D$19","v":108000},144612,178740.432,211718.04170399997,228973.06210287602,242917.52158494113]
[null,"Otros",0.08,19200,25708.799999999999,31776.076799999999,37638.762969599993,40706.322151622408,43185.337170656203]
[null,{"$f":"\"Variables  \"&B36","v":"Variables  Producto B"},null,{"$f":"SUM(D37:D38)","v":127200},170320.8,210516.50880000001,249356.80467359995,{"$f":"SUM(H37:H38)","v":269679.38425449841},286102.85875559732]
[]
[null,"Total Materias Primas",null,{"$f":"D32+D37","v":208000},273362,337875.43200000003,400213.44920399995,432830.84531412611,459190.24379375624]
[]
[null,"Total Costes Variables",null,{"$f":"D34+D39","v":252200},331258.3,409435.25880000001,484976.06404859992,524501.61326856096,556443.76151661621]
[]
[null,"Costes Totales",null,{"$f":"D28+D43","v":464200},547558.30000000005,632224.25879999995,714448.73404859996,760858.463368561,799891.3171196162]

{"sheet":"ESTADOS FINANCIEROS","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Datos para Fondo de Maniobra",null,"Varios"]
[null,"Meses de Existencias",2,"Tasa impositiva",0.3,null,{"$f":"'INGRESOS Y COSTES'!B2","v":"VAN"},{"$f":"'INGRESOS Y COSTES'!C2","v":548675.29532205523}]
[null,"Meses de Cuentas a Cobrar",2,"Interés Activo",0.05,null,{"$f":"'INGRESOS Y COSTES'!B3","v":"TIR"},{"$f":"'INGRESOS Y COSTES'!C3","v":0.17904917042371715}]
[null,"Meses de Tesorería Operativa",1.5,"Dividendos",0.4,null,{"$f":"'INGRESOS Y COSTES'!B4","v":"TIR Capital"},{"$f":"'INGRESOS Y COSTES'!C4","v":0.27368271124511612}]
[null,"Meses de Cuentas a Pagar",1]
[null,null,null,{"$f":"'INGRESOS Y COSTES'!D8","v":1},{"$f":"'INGRESOS Y COSTES'!E8","v":2},{"$f":"'INGRESOS Y COSTES'!F8","v":3},{"$f":"'INGRESOS Y COSTES'!G8","v":4},{"$f":"'INGRESOS Y COSTES'!H8","v":5}]
[null,"Cuenta de Resultados",null,{"$f":"D7","v":1},{"$f":"E7","v":2},3,4,5]
[null,"Ingresos de Explotación",null,{"$f":"'INGRESOS Y COSTES'!D21","v":490000},{"$f":"'INGRESOS Y COSTES'!E21","v":643235},{"$f":"'INGRESOS Y COSTES'!F21","v":795038.46},{"$f":"'INGRESOS Y COSTES'!G21","v":941723.05586999992},{"$f":"'INGRESOS Y COSTES'!H21","v":1018473.4849234051}]
[null," Costes Variables",null,{"$f":"'INGRESOS Y COSTES'!D43","v":252200},{"$f":"'INGRESOS Y COSTES'!E43","v":331258.3},{"$f":"'INGRESOS Y COSTES'!F43","v":409435.25880000001},{"$f":"'INGRESOS Y COSTES'!G43","v":484976.06404859992},{"$f":"'INGRESOS Y COSTES'!H43","v":524501.61326856096}]
[null," Margen Bruto",null,{"$f":"D9-D10","v":237800},{"$f":"E9-E10","v":311976.7},385603.20119999995,{"$f":"G9-G10","v":456746.99182140001},493971.87165484414]
[null," Costes Fijos",null,{"$f":"'INGRESOS Y COSTES'!D28","v":212000},{"$f":"'INGRESOS Y COSTES'!E28","v":216300},{"$f":"'INGRESOS Y COSTES'!F28","v":222789},{"$f":"'INGRESOS Y COSTES'!G28","v":229472.67},{"$f":"'INGRESOS Y COSTES'!H28","v":236356.85010000001}]
[null," Amortización",null,{"$f":"INVERSIÓN!E24","v":67752.5},{"$f":"INVERSIÓN!F24","v":67752.5},{"$f":"INVERSIÓN!G24","v":67752.5},{"$f":"INVERSIÓN!H24","v":67752.5},{"$f":"INVERSIÓN!I24","v":61752.5}]
[null,"  BAIT",null,{"$f":"D11-D12-D13","v":-41952.5},{"$f":"E11-E12-E13","v":27924.200000000012},95061.701199999952,{"$f":"G11-G12-G13","v":159521.82182139999},195862.52155484413]
[null,"Imputación de la Subvención",null,{"$f":"C40/5","v":11084.666666666668},{"$f":"D15","v":11084.666666666668},11084.666666666668,{"$f":"F15","v":11084.666666666668},{"$f":"G15","v":11084.666666666668}]
[null,"  Gastos Financieros",null,{"$f":"FINANCIACIÓN!C20","v":36579.399999999994},{"$f":"FINANCIACIÓN!D20","v":33804.195609073293},{"$f":"FINANCIACIÓN!E20","v":30862.478954690981},{"$f":"FINANCIACIÓN!F20","v":27744.259301045731},{"$f":"FINANCIACIÓN!G20","v":24438.94646818177}]
[null,"Ingresos Financieros",null,{"$f":"$E$4*C35","v":4.0017766878008846E-12},{"$f":"$E$4*D35","v":-1.1641532182693482E-11},0,2421.4658938758776,6946.9578239782295]
[null,"  BAT",null,{"$f":"D14+D15-D16+D17","v":-67447.233333333323},{"$f":"E14+E15-E16+E17","v":5204.6710575933785},75283.888911975635,145283.69508089678,189455.19957730727]
[null,"Base Imponible",null,{"$f":"D18","v":-67447.233333333323},{"$f":"IF(D19<0,E18+D19,E18)","v":-62242.562275739947},13041.326636235688,{"$f":"IF(F19<0,G18+F19,G18)","v":145283.69508089678},{"$f":"IF(G19<0,H18+G19,H18)","v":189455.19957730727}]
[null,"  Impuestos",null,{"$f":"MAX(0,$E$3*D19)","v":0},{"$f":"MAX(0,$E$3*E19)","v":0},{"$f":"MAX(0,$E$3*F19)","v":3912.3979908707061},{"$f":"MAX(0,$E$3*G19)","v":43585.108524269031},{"$f":"MAX(0,$E$3*H19)","v":56836.559873192178}]
[null,"  BDT",null,{"$f":"D18-D20","v":-67447.233333333323},{"$f":"E18-E20","v":5204.6710575933785},71371.490921104923,{"$f":"G18-G20","v":101698.58655662775},132618.63970411511]
[null,"Dividendos",null,null,{"$f":"MAX(0,$E$5*D21)","v":0},{"$f":"MAX(0,$E$5*E21)","v":2081.8684230373515},{"$f":"MAX(0,$E$5*F21)","v":28548.596368441969},{"$f":"MAX(0,$E$5*G21)","v":40679.434622651104}]
[null,"Beneficio retenido",null,{"$f":"D21-D22","v":-67447.233333333323},{"$f":"E21-E22","v":5204.6710575933785},69289.622498067576,73149.99018818578,91939.205081463995]
[]
[null,"Balance","Inicio",{"$f":"D7","v":1},{"$f":"E7","v":2},{"$f":"F7","v":3},{"$f":"G7","v":4},{"$f":"H7","v":5}]
[null,"Inmovilizado Material",{"$f":"INVERSIÓN!C17","v":1018350},{"$f":"C26","v":1018350},{"$f":"D26","v":1018350},{"$f":"E26","v":1018350},{"$f":"F26","v":1018350},{"$f":"G26","v":1018350}]
[null,"(Amortización Acumulada)",null,{"$f":"C27+INVERSIÓN!E17","v":61962.5},{"$f":"D27+INVERSIÓN!F17","v":123925},{"$f":"E27+INVERSIÓN!G17","v":185887.5},{"$f":"F27+INVERSIÓN!H17","v":247850},{"$f":"G27+INVERSIÓN!I17","v":303812.5}]
[null,"Inmovilizado Intangible",{"$f":"INVERSIÓN!C22","v":28950},{"$f":"C28","v":28950},{"$f":"D28","v":28950},{"$f":"E28","v":28950},{"$f":"F28","v":28950},{"$f":"G28","v":28950}]
[null,"(Amortización Acumulada)",null,{"$f":"C29+INVERSIÓN!E22","v":5790},{"$f":"D29+INVERSIÓN!F22","v":11580},{"$f":"E29+INVERSIÓN!G22","v":17370},{"$f":"F29+INVERSIÓN!H22","v":23160},{"$f":"G29+INVERSIÓN!I22","v":28950}]
[null,"Inmovilizado Neto",{"$f":"C26+C28-C27-C29","v":1047300},{"$f":"D26+D28-D27-D29","v":979547.5},911795,{"$f":"F26+F28-F27-F29","v":844042.5},776290,714537.5]
[null,"Existencias",{"$f":"$C$3/12*'INGRESOS Y COSTES'!D41","v":34666.666666666664},{"$f":"$C$3/12*'INGRESOS Y COSTES'!E41","v":45560.333333333328},{"$f":"$C$3/12*'INGRESOS Y COSTES'!F41","v":56312.572},{"$f":"$C$3/12*'INGRESOS Y COSTES'!G41","v":66702.241533999986},{"$f":"$C$3/12*'INGRESOS Y COSTES'!H41","v":72138.474219021009},{"$f":"$C$3/12*'INGRESOS Y COSTES'!I41","v":76531.707298959373}]
[null,"Cuentas a Cobrar",null,{"$f":"$C$4/12*'INGRESOS Y COSTES'!D21","v":81666.666666666657},{"$f":"$C$4/12*'INGRESOS Y COSTES'!E21","v":107205.83333333333},{"$f":"$C$4/12*'INGRESOS Y COSTES'!F21","v":132506.40999999997},{"$f":"$C$4/12*'INGRESOS Y COSTES'!G21","v":156953.84264499997},{"$f":"$C$4/12*'INGRESOS Y COSTES'!H21","v":169745.5808205675}]
[null,"Tesorería Operativa",{"$f":"$C$5/12*'INGRESOS Y COSTES'!D28","v":26500},{"$f":"$C$5/12*'INGRESOS Y COSTES'!E28","v":27037.5},{"$f":"$C$5/12*'INGRESOS Y COSTES'!F28","v":27848.625},{"$f":"$C$5/12*'INGRESOS Y COSTES'!G28","v":28684.083750000002},{"$f":"$C$5/12*'INGRESOS Y COSTES'!H28","v":29544.606262500001},{"$f":"$C$5/12*'INGRESOS Y COSTES'!I28","v":30430.944450375002}]
[null,"Activo Corriente",{"$f":"SUM(C31:C33)","v":61166.666666666664},{"$f":"SUM(D31:D33)","v":154264.5},191367.03033333333,{"$f":"SUM(F31:F33)","v":227892.73528399994},258636.92312652097,276708.23256990185]
[null,"Excedente de Tesorería",{"$f":"C45-C30-C34","v":8.0035533756017685E-11},-2.3283064365386963E-10,0,48429.317877517547,138939.15647956458,222199.95419597079]
[null,"Total Activo",{"$f":"C30+C34+C35","v":1108466.6666666667},{"$f":"D30+D34+D35","v":1133811.9999999998},1103162.0303333334,{"$f":"F30+F34+F35","v":1120364.5531615175},1173866.0796060856,1213445.6867658726]
[]
[null,"Capital",{"$f":"FINANCIACIÓN!E6","v":443386.66666666674},{"$f":"MAX(C38,D30+D34-D39-D40-D42-D43-D44)","v":554833.97318211175},{"$f":"MAX(D38,E30+E34-E39-E40-E42-E43-E44)","v":572146.0850308903},{"$f":"MAX(E38,F30+F34-F39-F40-F42-F43-F44)","v":572146.0850308903},{"$f":"MAX(F38,G30+G34-G39-G40-G42-G43-G44)","v":572146.0850308903},{"$f":"MAX(G38,H30+H34-H39-H40-H42-H43-H44)","v":572146.0850308903}]
[null,"Reservas",null,{"$f":"C39+D23","v":-67447.233333333323},{"$f":"D39+E23","v":-62242.562275739947},7047.0602223276292,80197.050410513417,172136.25549197741]
[null,"Subvención",{"$f":"FINANCIACIÓN!E7","v":55423.333333333343},{"$f":"C40-D15","v":44338.666666666672},{"$f":"D40-E15","v":33254},{"$f":"E40-F15","v":22169.333333333332},{"$f":"F40-G15","v":11084.666666666664},{"$f":"G40-H15","v":0}]
[null,"Patrimonio Neto",{"$f":"C38+C39+C40","v":498810.00000000012},{"$f":"D38+D39+D40","v":531725.40651544509},543157.52275515033,{"$f":"F38+F39+F40","v":601362.47858655127},{"$f":"G38+G39+G40","v":663427.80210807035},{"$f":"H38+H39+H40","v":744282.34052286774}]
[null,"Deuda",{"$f":"FINANCIACIÓN!E8","v":609656.66666666663},{"$f":"FINANCIACIÓN!C22","v":563403.26015122153},{"$f":"FINANCIACIÓN!D22","v":514374.64924484969},{"$f":"FINANCIACIÓN!E22","v":462404.32168409554},{"$f":"FINANCIACIÓN!F22","v":407315.77446969616},{"$f":"FINANCIACIÓN!G22","v":348921.91442243278}]
[null,"Cuentas a Pagar",null,{"$f":"$C$6/12*'INGRESOS Y COSTES'!D45","v":38683.333333333328},{"$f":"$C$6/12*'INGRESOS Y COSTES'!E45","v":45629.858333333337},{"$f":"$C$6/12*'INGRESOS Y COSTES'!F45","v":52685.354899999991},{"$f":"$C$6/12*'INGRESOS Y COSTES'!G45","v":59537.394504049997},{"$f":"$C$6/12*'INGRESOS Y COSTES'!H45","v":63404.871947380081}]
[null,"Hacienda",null,{"$f":"D20","v":0},{"$f":"E20","v":0},{"$f":"F20","v":3912.3979908707061},{"$f":"G20","v":43585.108524269031},{"$f":"H20","v":56836.559873192178}]
[null,"Total Patrimonio Neto y Pasivo",{"$f":"SUM(C41:C44)","v":1108466.6666666667},{"$f":"SUM(D41:D44)","v":1133811.9999999998},1103162.0303333334,{"$f":"SUM(F41:F44)","v":1120364.5531615175},1173866.0796060856,1213445.6867658726]
[]
[null,"Fondo de Maniobra Operativo",{"$f":"C34-C43-C44","v":61166.666666666664},115581.16666666667,145737.17199999999,171294.98239312926,155514.42009820195,156466.80074932962]
[]
[null,"Deuda Neta",{"$f":"C42-C35","v":609656.66666666651},{"$f":"D42-D35","v":563403.26015122177},514374.64924484969,413975.003806578,268376.61799013161,126721.96022646199]

{"sheet":"VALORACIÓN Y RENTABILIDAD","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Crecimiento Residual",0.03,null,"VAN",{"$f":"NPV(C5,D15:H15)+C15","v":548675.29532205523}]
[null,"Reinversión Residual",0.3,null,"TIR",{"$f":"IRR(C15:H15)","v":0.17904917042371715}]
[null,"Rentabilidad Residual implícita",{"$f":"C2/C3","v":0.1},null,"TIR Capital",{"$f":"IRR(C26:H26)","v":0.27368271124511612}]
[null,"CCMP",{"$f":"FINANCIACIÓN!D9","v":8.3099999999999993E-2}]
[]
[null,"Flujos del Proyecto"]
[null,null,{"$f":"'ESTADOS FINANCIEROS'!C25","v":"Inicio"},{"$f":"'ESTADOS FINANCIEROS'!D25","v":1},{"$f":"'ESTADOS FINANCIEROS'!E25","v":2},{"$f":"'ESTADOS FINANCIEROS'!F25","v":3},{"$f":"'ESTADOS FINANCIEROS'!G25","v":4},{"$f":"'ESTADOS FINANCIEROS'!H25","v":5}]
[null,"BAIT",null,{"$f":"'ESTADOS FINANCIEROS'!D14","v":-41952.5},{"$f":"'ESTADOS FINANCIEROS'!E14","v":27924.200000000012},{"$f":"'ESTADOS FINANCIEROS'!F14","v":95061.701199999952},{"$f":"'ESTADOS FINANCIEROS'!G14","v":159521.82182139999},{"$f":"'ESTADOS FINANCIEROS'!H14","v":195862.52155484413}]
[null,"NOPAT",null,{"$f":"D9*(1-'ESTADOS FINANCIEROS'!D20/'ESTADOS FINANCIEROS'!D18)","v":-41952.5},{"$f":"E9*(1-'ESTADOS FINANCIEROS'!E20/'ESTADOS FINANCIEROS'!E18)","v":27924.200000000012},{"$f":"F9*(1-'ESTADOS FINANCIEROS'!F20/'ESTADOS FINANCIEROS'!F18)","v":90121.478077115171},{"$f":"G9*(1-'ESTADOS FINANCIEROS'!G20/'ESTADOS FINANCIEROS'!G18)","v":111665.27527497998},{"$f":"H9*(1-'ESTADOS FINANCIEROS'!H20/'ESTADOS FINANCIEROS'!H18)","v":137103.76508839088}]
[null,"  + Amortización",null,{"$f":"'ESTADOS FINANCIEROS'!D13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!E13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!F13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!G13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!H13","v":61752.5}]
[null,"  - Ajuste Fondo de Maniobra",{"$f":"'ESTADOS FINANCIEROS'!C47","v":61166.666666666664},{"$f":"'ESTADOS FINANCIEROS'!D47-'ESTADOS FINANCIEROS'!C47","v":54414.500000000007},{"$f":"'ESTADOS FINANCIEROS'!E47-'ESTADOS FINANCIEROS'!D47","v":30156.00533333332},{"$f":"'ESTADOS FINANCIEROS'!F47-'ESTADOS FINANCIEROS'!E47","v":25557.810393129272},{"$f":"'ESTADOS FINANCIEROS'!G47-'ESTADOS FINANCIEROS'!F47","v":-15780.562294927309},{"$f":"'ESTADOS FINANCIEROS'!H47-'ESTADOS FINANCIEROS'!G47","v":952.38065112766344}]
[null,"  -  Inversiones Inmovilizado",{"$f":"'ESTADOS FINANCIEROS'!C30","v":1047300}]
[null,"  + Valor en Continuidad",null,null,null,null,null,{"$f":"H10*(1+C2)*(1-C3)/(C5-C2)","v":1861616.0947030098}]
[null,"Flujo Neto de Caja del Proyecto",{"$f":"C10+C11-C12-C13+C14","v":-1108466.6666666667},{"$f":"D10+D11-D12-D13+D14","v":-28614.500000000007},65520.694666666692,132316.1676839859,195198.33756990731,2059519.9791402731]
[]
[null,"Flujos del Capital"]
[null,null,{"$f":"C8","v":"Inicio"},1,2,3,4,5]
[null,"BDT",null,{"$f":"'ESTADOS FINANCIEROS'!D21","v":-67447.233333333323},{"$f":"'ESTADOS FINANCIEROS'!E21","v":5204.6710575933785},{"$f":"'ESTADOS FINANCIEROS'!F21","v":71371.490921104923},{"$f":"'ESTADOS FINANCIEROS'!G21","v":101698.58655662775},{"$f":"'ESTADOS FINANCIEROS'!H21","v":132618.63970411511}]
[null,"  + Amortización",null,{"$f":"D11","v":67752.5},67752.5,67752.5,67752.5,61752.5]
[null,"  - Ajuste Fondo de Maniobra",{"$f":"C12","v":61166.666666666664},54414.500000000007,30156.00533333332,25557.810393129272,-15780.562294927309,952.38065112766344]
[null,"  +  Ajuste Deuda Neta",{"$f":"'ESTADOS FINANCIEROS'!C49","v":609656.66666666651},{"$f":"'ESTADOS FINANCIEROS'!D49-'ESTADOS FINANCIEROS'!C49","v":-46253.406515444745},{"$f":"'ESTADOS FINANCIEROS'!E49-'ESTADOS FINANCIEROS'!D49","v":-49028.61090637208},{"$f":"'ESTADOS FINANCIEROS'!F49-'ESTADOS FINANCIEROS'!E49","v":-100399.64543827169},{"$f":"'ESTADOS FINANCIEROS'!G49-'ESTADOS FINANCIEROS'!F49","v":-145598.38581644639},{"$f":"'ESTADOS FINANCIEROS'!H49-'ESTADOS FINANCIEROS'!G49","v":-141654.65776366962}]
[null,"  + Ajuste Subvención",{"$f":"'ESTADOS FINANCIEROS'!C40","v":55423.333333333343},{"$f":"-'ESTADOS FINANCIEROS'!D15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!E15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!F15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!G15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!H15","v":-11084.666666666668}]
[null,"  -  Inversiones Inmovilizado",{"$f":"C13","v":1047300}]
[null," + Valor en Continuidad",null,null,null,null,null,{"$f":"H14-'ESTADOS FINANCIEROS'!H49","v":1734894.1344765478}]
[null,"Flujo Neto de Caja del Capital",{"$f":"C19+C20-C21+C22+C23-C24+C25","v":-443386.66666666674},{"$f":"D19+D20-D21+D22+D23-D24+D25","v":-111447.30651544475},-17312.111848778684,2081.8684230372783,28548.596368442017,1775573.569099199]
[]
[null,null,"Tasa",{"$f":"F2","v":548675.29532205523},null,"Tasa","VAN"]
[null,null,0.06,1798708.4536742794,null,7.0000000000000007E-2,{"$f":"NPV(F29,$D$15:$H$15)+$C$15","v":647353.68758207629}]
[null,null,7.0000000000000007E-2,1082046.5817336163,null,0.08,571399.99800087488]
[null,null,0.08,649953.04527058755,null,0.09,499431.41379168583]
[null,null,0.09,360290.29993533739,null,0.1,431203.54246964795]
[null,null,0.1,152132.12143371301,null,0.11,366489.06939784647]
[null,null,0.11,-4992.7159336148761,null,0.12,305076.42233747733]
[null,null,0.12,-128019.27420323389,null,0.13,246768.55127881351]
[null,null,0.13,-227114.03532454802,null,0.14000000000000001,191381.81268438813]
[null,null,0.14000000000000001,-308751.11621527269,null,0.15,138744.94838531199]
[null,null,0.15,-377250.40999601909,null,0.16,88698.150359261548]
[null,null,0.16,-435605.84401762811,null,0.17,41092.203499029856]
[null,null,0.17,-485958.69380028138,null,0.18,-4212.300734321354]
[null,null,0.18,-529881.5913764768,null,0.19,-47345.686178339645]