{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INICIO","DESCRIPCIÓN PROYECTO","CRITERIOS VIABILIDAD LEGAL","CRITERIOS MCA","RESULTADO","Parámetros","CPP","Guía","Inputs","VpD"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":8407,"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":"INICIO","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,18,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PLANTILLA PARA EL ANÁLISIS MULTICRITERIO DE VALOR POR DINERO EN ESPAÑA"]

{"sheet":"DESCRIPCIÓN PROYECTO","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,3,10,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DESCRIPCIÓN PROYECTO"]
[null,null,"DP1","NOMBRE"]
[null,null,"DP2","SECTOR"]
[null,null,"DP3","ENTIDAD CONTRATANTE"]
[null,null,"DP4","TIPO DE CONTRATO"]
[null,null,"DP5","ALCANCE"]
[null,null,"DP6","INVERSIÓN (EUR millones)"]
[null,null,"DP7","MECANISMO DE PAGO"]
[null,null,"DP8","PLAZO (años)"]

{"sheet":"CRITERIOS VIABILIDAD LEGAL","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,2,9,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+IF(SUM(E16:E17)<2,\"El Proyecto no cumple con los requisitos mínimos legales para ser desarrollado bajo la vía concesional.\",\"El Proyecto cumple con los requisitos mínimos legales para ser desarrollado bajo la vía concesional.\")","v":"El Proyecto cumple con los requisitos mínimos legales para ser desarrollado bajo la vía concesional."}]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+Parámetros!B18","v":"CRITERIOS VIABILIDAD LEGAL"},"VALORACIÓN\n(SI=1 - NO=0)"]
[null,null,null,{"$f":"+Parámetros!D19","v":"Compatibilidad con el marco regulatorio vigente y las restricciones regulatorias sectoriales"},1]
[null,null,null,{"$f":"+Parámetros!D21","v":"Facultades legales de la entidad contratante para estructurar y adjudicar el contrato"},1]

{"sheet":"CRITERIOS MCA","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,2,38,7],[8,2,11,7],[14,2,17,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+IF($C$26=Parámetros!B$53,Parámetros!$B$51,\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,{"$f":"+IF(OR(F25=1,F26=1,F27=1,F28=1,F29=1),\"El Proyecto no cumple con los requisitos mínimos para ser desarrollado bajo la vía concesional\",\"El Proyecto cumple con los requisitos mínimos para ser desarrollado bajo la vía concesional\")","v":"El Proyecto cumple con los requisitos mínimos para ser desarrollado bajo la vía concesional"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"CRITERIO",null,"Puntuación (1:Bajo;3:Medio; 5: Alto)","PONDERACIÓN","VALORACIÓN NORMALIZADA"]
[null,null,{"$f":"+Parámetros!B24","v":"CR1"},{"$f":"+Parámetros!D24","v":"Riesgos legales y otros riesgos de carácter regulatorio"},{"$f":"+IF($F25=0,\"\",IF(AND(C25=Parámetros!B24,'CRITERIOS MCA'!F25=Parámetros!G24),Parámetros!E24,IF(AND(C25=Parámetros!B24,'CRITERIOS MCA'!F25=Parámetros!G25),Parámetros!E25,Parámetros!E26)))","v":"Se identifican algunos riesgos regulatorios o normativos que podrían generar incertidumbre en la implementación del proyecto, pero que pueden ser gestionados o mitigados. Es posible que se requiera la interpretación de determinadas normativas sectoriales, sin que éstas impliquen modificaciones legislativas complejas. Existen precedentes de proyectos similares, aunque con ciertas restricciones o ajustes en su aplicación. "},2,{"$f":"+Parámetros!$H24","v":7.0000000000000007E-2},{"$f":"+IF(F25>0,(F25-1)/2*100*Parámetros!H24,0)","v":3.5000000000000004}]
[null,null,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$17>=100,Parámetros!$B$53,Parámetros!B27)","v":"CR2"},{"$f":"+Parámetros!D27","v":"Potencial de transferencia eficiente del riesgo y nivel global de rentabilidad previsto."},{"$f":"+IF($F26=0,\"\",IF('DESCRIPCIÓN PROYECTO'!$E$17>=100,IF(AND(C26=Parámetros!B53,'CRITERIOS MCA'!F26=Parámetros!G53),Parámetros!E53,IF(AND(C26=Parámetros!B53,'CRITERIOS MCA'!F26=Parámetros!G54),Parámetros!E54,Parámetros!E55)),IF(AND(C26=Parámetros!B27,'CRITERIOS MCA'!F26=Parámetros!G27),Parámetros!E27,IF(AND(C26=Parámetros!B27,'CRITERIOS MCA'!F26=Parámetros!G28),Parámetros!E28,Parámetros!E29))))","v":"Las características del proyecto permiten que la mayoría de los riesgos del proyecto sean asignados de manera eficiente al concesionario, logrando un esquema de incentivos que optimiza la gestión de costes y plazos. Los riesgos retenidos por la entidad contratante son los riesgos que puede gestionar de manera más eficiente. La asignación de riesgos también se ajusta a las buenas prácticas internacionales. "},3,{"$f":"+Parámetros!$H27","v":0.21},{"$f":"+IF(F26>0,(F26-1)/2*100*Parámetros!H27,0)","v":21}]
[null,null,{"$f":"+Parámetros!B30","v":"CR3"},{"$f":"+Parámetros!D30","v":" Capacidad o preparación de la entidad contratante para la implementación y gestión del proyecto "},{"$f":"+IF($F27=0,\"\",IF(AND(C27=Parámetros!B30,'CRITERIOS MCA'!F27=Parámetros!G30),Parámetros!E30,IF(AND(C27=Parámetros!B30,'CRITERIOS MCA'!F27=Parámetros!G31),Parámetros!E31,Parámetros!E32)))","v":"La entidad contratante no cuenta con un equipo especializado en la ejecución y el seguimiento de los proyectos desarrollados bajo la vía concesional, pero cuenta con acceso asistencia técnica experimentada (proporcional a la complejidad del proyecto) para administrar el contrato durante su vigencia, una comprensión realista de los costes involucrados y los presupuestos disponibles para financiarlo."},2,{"$f":"+Parámetros!$H30","v":0.13},{"$f":"+IF(F27>0,(F27-1)/2*100*Parámetros!H30,0)","v":6.5}]
[null,null,{"$f":"+Parámetros!B33","v":"CR4"},{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\",Parámetros!D33, \"Criterio no aplica para Concesión de Servicios\")","v":"Criterio no aplica para Concesión de Servicios"},{"$f":"++IF('DESCRIPCIÓN PROYECTO'!$E$15=\"Concesión de Obras\",IF($F28=0,\"\",IF(AND(C28=Parámetros!B33,'CRITERIOS MCA'!F28=Parámetros!G33),Parámetros!E33,IF(AND(C28=Parámetros!B33,'CRITERIOS MCA'!F28=Parámetros!G34),Parámetros!E34,Parámetros!E35))),\"Criterio no aplica para Concesión de Servicios\")","v":"Criterio no aplica para Concesión de Servicios"},2,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\",Parámetros!$H33, \"Criterio no aplica para Concesión de Servicios\")","v":"Criterio no aplica para Concesión de Servicios"},{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\",+IF(F28>0,((F28-1)/2)*100*Parámetros!H33,0), \"Criterio no aplica para Concesión de Servicios\")","v":"Criterio no aplica para Concesión de Servicios"}]
[null,null,{"$f":"+Parámetros!B36","v":"CR5"},{"$f":"+Parámetros!D36","v":"Competencia e interés de los inversores"},{"$f":"+IF($F29=0,\"\",IF(AND(C29=Parámetros!B36,'CRITERIOS MCA'!F29=Parámetros!G36),Parámetros!E36,IF(AND(C29=Parámetros!B36,'CRITERIOS MCA'!F29=Parámetros!G37),Parámetros!E37,Parámetros!E38)))","v":"Existen evidencias de interés moderado por parte del mercado, con al menos 3 potenciales oferentes identificados con capacidad para entregar el proyecto bajo un esquema concesional. Existe un historial de licitaciones anteriores con una participación aceptable. "},2,{"$f":"+Parámetros!$H36","v":0.19},{"$f":"+IF(F29>0,((F29-1)/2)*100*Parámetros!H36,0)","v":9.5}]
[null,null,{"$f":"+Parámetros!B39","v":"CR6"},{"$f":"+Parámetros!D39","v":"Tamaño del Proyecto"},{"$f":"+IF($F30=0,\"\",IF(AND(C30=Parámetros!B39,'CRITERIOS MCA'!F30=Parámetros!G39),Parámetros!E39,IF(AND(C30=Parámetros!B39,'CRITERIOS MCA'!F30=Parámetros!G40),Parámetros!E40,Parámetros!E41)))","v":"El valor del contrato permite capturar completamente las eficiencias asociadas con la vía concesional. El proyecto es considerado atractivo para el mercado, con precedentes exitosos a nivel regional o internacional que respaldan su viabilidad y bancabilidad."},3,{"$f":"+Parámetros!$H39","v":7.0000000000000007E-2},{"$f":"+IF(F30>0,((F30-1)/2)*100*Parámetros!H39,0)","v":7.0000000000000009}]
[null,null,{"$f":"+Parámetros!B42","v":"CR7"},{"$f":"+Parámetros!D42","v":"Estabilidad a largo plazo de las necesidades de servicio"},{"$f":"+IF($F$31=0,\"\",IF(AND(C31=Parámetros!B42,'CRITERIOS MCA'!F31=Parámetros!G42),Parámetros!E42,IF(AND(C31=Parámetros!B42,'CRITERIOS MCA'!F31=Parámetros!G43),Parámetros!E43,Parámetros!E44)))","v":"La necesidad de servicio durante el plazo de la concesión es razonablemente predecible y se espera que permanezca relativamente estable. El contrato permite cierto margen de maniobra para gestionar ajustes a los términos de servicio, a través de mecanismos que pueden ser adecuados para cambios menores. Sin embargo, cambios sustanciales en las necesidades del servicio podrían generar costes significativos o requerir procesos de renegociación con cierto grado de complejidad."},2,{"$f":"+Parámetros!$H42","v":7.0000000000000007E-2},{"$f":"+IF(F31>0,((F31-1)/2)*100*Parámetros!H42,0)","v":3.5000000000000004}]
[null,null,{"$f":"+Parámetros!B45","v":"CR8"},{"$f":"+Parámetros!D45","v":"Eficiencias relacionadas con el tiempo"},{"$f":"+IF($F32=0,\"\",IF(AND(C32=Parámetros!B45,'CRITERIOS MCA'!F32=Parámetros!G45),Parámetros!E45,IF(AND(C32=Parámetros!B45,'CRITERIOS MCA'!F32=Parámetros!G46),Parámetros!E46,Parámetros!E47)))","v":"La vía concesional permite una reducción significativa del tiempo de prestación de servicios y/o un menor riesgo de retrasos debidos a los incentivos al pago por desempeño en el contrato de concesión y/o a la movilización de financiación privada, mientras que la financiación pública del proyecto bajo contratación tradicional puede no estar disponible o sufrir demoras. El diseño contractual incluye mecanismos efectivos para gestionar el riesgo de retrasos en la construcción, así como incentivos claros para cumplir con los plazos. La disponibilidad temprana del servicio genera valor económico y social."},3,{"$f":"+Parámetros!$H45","v":0.13},{"$f":"+IF(F32>0,((F32-1)/2)*100*Parámetros!H45,0)","v":13}]
[null,null,{"$f":"+Parámetros!B48","v":"CR9"},{"$f":"+Parámetros!D48","v":"Capacidad de definición de resultados objetivos y medibles (outputs de servicio)"},{"$f":"+IF($F33=0,\"\",IF(AND(C33=Parámetros!B48,'CRITERIOS MCA'!F33=Parámetros!G48),Parámetros!E48,IF(AND(C33=Parámetros!B48,'CRITERIOS MCA'!F33=Parámetros!G49),Parámetros!E49,Parámetros!E50)))","v":"Los estándares de desempeño están claramente definidos y se pueden medir con indicadores objetivos. Existen mecanismos de pago bien estructurados y basados en el desempeño, que incluyen incentivos y penalizaciones que alinean los intereses del concesionario con la calidad del servicio. Se han identificado múltiples precedentes exitosos de proyectos dentro del país o en la región."},3,{"$f":"+Parámetros!$H48","v":0.13},{"$f":"+IF(F33>0,((F33-1)/2)*100*Parámetros!H48,0)","v":13}]
[]
[]
[null,null,{"$f":"+IFERROR(IF($C$15=\"El Proyecto cumple con los requisitos mínimos para ser desarrollado bajo la vía concesional\",CONCATENATE(\"PUNTUACIÓN TOTAL \",Parámetros!B23,\" \",,ROUND(SUMPRODUCT(H25:H33),2)),\"El Proyecto no cumple con los requisitos mínimos para ser desarrollado bajo la vía concesional\"),\"\")","v":"PUNTUACIÓN TOTAL PREPARACIÓN DEL PROYECTO 77"}]

{"sheet":"RESULTADO","index":4,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[26,2,26,3],[6,2,7,4],[22,2,22,3],[9,2,9,3],[19,2,19,3],[24,2,24,3]]}
[]
[]
[]
[]
[]
[]
[null,null,"1 - DESCRIPCIÓN Y ELEGIBILIDAD"]
[]
[]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!D11","v":"DESCRIPCIÓN PROYECTO"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C12","v":"DP1"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D12","v":"NOMBRE"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C13","v":"DP2"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D13","v":"SECTOR"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C14","v":"DP3"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D14","v":"ENTIDAD CONTRATANTE"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C15","v":"DP4"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D15","v":"TIPO DE CONTRATO"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C16","v":"DP5"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D16","v":"ALCANCE"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C17","v":"DP6"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D17","v":"INVERSIÓN (EUR millones)"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C18","v":"DP7"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D18","v":"MECANISMO DE PAGO"}]
[null,null,{"$f":"+'DESCRIPCIÓN PROYECTO'!C19","v":"DP8"},{"$f":"+'DESCRIPCIÓN PROYECTO'!D19","v":"PLAZO (años)"}]
[]
[null,null,{"$f":"+'CRITERIOS VIABILIDAD LEGAL'!D15","v":"CRITERIOS VIABILIDAD LEGAL"}]
[null,null,{"$f":"+'CRITERIOS VIABILIDAD LEGAL'!C16","v":0},{"$f":"+'CRITERIOS VIABILIDAD LEGAL'!D16","v":"Compatibilidad con el marco regulatorio vigente y las restricciones regulatorias sectoriales"}]
[null,null,{"$f":"+'CRITERIOS VIABILIDAD LEGAL'!C17","v":0},{"$f":"+'CRITERIOS VIABILIDAD LEGAL'!D17","v":"Facultades legales de la entidad contratante para estructurar y adjudicar el contrato"}]
[null,null,"ELEGIBILDIAD PROYECTO",null,{"$f":"+IF(SUM(E21:E22)=2,\"Si\",\"No\")","v":"No"}]
[]
[null,null,"2 - CRITERIOS MCA"]
[]
[null,null,{"$f":"+Parámetros!B23","v":"PREPARACIÓN DEL PROYECTO"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C25","v":"CR1"},{"$f":"+'CRITERIOS MCA'!D25","v":"Riesgos legales y otros riesgos de carácter regulatorio"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C26","v":"CR2"},{"$f":"+'CRITERIOS MCA'!D26","v":"Potencial de transferencia eficiente del riesgo y nivel global de rentabilidad previsto."}]
[null,null,{"$f":"+'CRITERIOS MCA'!C27","v":"CR3"},{"$f":"+'CRITERIOS MCA'!D27","v":" Capacidad o preparación de la entidad contratante para la implementación y gestión del proyecto "}]
[null,null,{"$f":"+'CRITERIOS MCA'!C28","v":"CR4"},{"$f":"+'CRITERIOS MCA'!D28","v":"Criterio no aplica para Concesión de Servicios"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C29","v":"CR5"},{"$f":"+'CRITERIOS MCA'!D29","v":"Competencia e interés de los inversores"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C30","v":"CR6"},{"$f":"+'CRITERIOS MCA'!D30","v":"Tamaño del Proyecto"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C31","v":"CR7"},{"$f":"+'CRITERIOS MCA'!D31","v":"Estabilidad a largo plazo de las necesidades de servicio"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C32","v":"CR8"},{"$f":"+'CRITERIOS MCA'!D32","v":"Eficiencias relacionadas con el tiempo"}]
[null,null,{"$f":"+'CRITERIOS MCA'!C33","v":"CR9"},{"$f":"+'CRITERIOS MCA'!D33","v":"Capacidad de definición de resultados objetivos y medibles (outputs de servicio)"}]
[null,null,null,"Total",{"$f":"+IF(SUM(E28:E36)>0,SUM(E28:E36),\"\")","v":""}]
[]
[null,null,"VALORACIÓN DEL PROYECTO",null,{"$f":"+IF(E23=\"Si\",E37,\"N/A\")","v":"N/A"}]
[]
[null,null,"UMBRAL MÍNIMO (+60 puntos)",null,{"$f":"+IF(AND(E39>=60,E39<>\"N/A\"),\"PASA\",\"NO PASA\")","v":"NO PASA"}]

{"sheet":"Parámetros","index":5,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,1,50,7],[52,1,54,1],[52,2,54,2],[52,3,54,3],[52,7,54,7],[51,1,51,7],[47,1,49,1],[47,2,49,2],[47,3,49,3],[47,7,49,7],[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,7,46,7],[26,2,28,2],[29,2,31,2],[32,2,34,2],[29,7,31,7],[26,7,28,7],[32,7,34,7],[41,1,43,1],[41,3,43,3],[41,7,43,7],[35,2,37,2],[35,7,37,7],[38,7,40,7],[20,3,21,3],[20,7,21,7],[23,2,25,2],[23,3,25,3],[23,7,25,7],[18,2,21,2],[22,1,22,7],[20,1,21,1],[18,7,19,7],[17,1,17,6],[18,1,19,1],[18,3,19,3],[38,2,40,2],[41,2,43,2],[35,1,37,1],[35,3,37,3],[38,1,40,1],[38,3,40,3],[26,1,28,1],[26,3,28,3],[29,1,31,1],[29,3,31,3],[32,1,34,1],[32,3,34,3],[23,1,25,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SUBCATEGORIA","CRITERIO","DESCRIPCIÓN","VALORACIÓN (DESCRIPCIÓN REDUCIDA)","PUNTAJE","PONDERACIÓN"]
[null,"CRITERIOS VIABILIDAD LEGAL",null,null,null,null,null,"P. Estándar"]
[null,"CE1.1","Viabilidad Legal","Compatibilidad con el marco regulatorio vigente y las restricciones regulatorias sectoriales","El proyecto cumple con el marco normativo vigente, incluyendo su compatibilidad con la normativa sectorial vigente. Además, cuenta con claros precedentes que respaldan la idoneidad propuesta bajo la vía concesional.  ","CUMPLE",1,"N/A"]
[null,null,null,null,"El proyecto requiere modificaciones legislativas considerables o se enfrenta a barreras regulatorias que lo hacen imposible en la actualidad para implementarlo bajo la vía concesional.","NO CUMPLE",0]
[null,"CE1.2",null,"Facultades legales de la entidad contratante para estructurar y adjudicar el contrato","La entidad contratante tiene plenos poderes legales para estructurar, adjudicar y ejecutar el contrato de concesión. No se requieren modificaciones reglamentarias ni trámites administrativos adicionales para la atribución de competencias.","CUMPLE",1,"N/A"]
[null,null,null,null,"La entidad contratante no tiene las facultades necesarias para estructurar y adjudicar el contrato de concesión. Para la atribución de competencias se requiere la tramitación de procedimientos administrativos previos o existe incertidumbre sobre la viabilidad de dicho proceso.","NO CUMPLE",0]
[null,"PREPARACIÓN DEL PROYECTO"]
[null,"CR1","Viabilidad Legal","Riesgos legales y otros riesgos de carácter regulatorio","Existen barreras o riesgos regulatorios significativos que pueden comprometer la viabilidad del proyecto. Se requieren reformas legales o aprobaciones especiales y su obtención no está garantizada a corto plazo. No hay precedentes claros en el país o en el sector, o bien existen antecedentes de conflictos legales en proyectos similares.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 6%,7%)","v":7.0000000000000007E-2}]
[null,null,null,null,"Se identifican algunos riesgos regulatorios o normativos que podrían generar incertidumbre en la implementación del proyecto, pero que pueden ser gestionados o mitigados. Es posible que se requiera la interpretación de determinadas normativas sectoriales, sin que éstas impliquen modificaciones legislativas complejas. Existen precedentes de proyectos similares, aunque con ciertas restricciones o ajustes en su aplicación. ","N/A",2]
[null,null,null,null,"No se identifican riesgos legales significativos que puedan afectar la ejecución del contrato en el marco del esquema concesional. No se requieren aprobaciones especiales ni modificaciones regulatorias para su desarrollo.","N/A",3]
[null,"CR2","Transferencia de riesgos","Potencial de transferencia eficiente del riesgo y nivel global de rentabilidad previsto.","La asignación de riesgos al concesionario es bastante limitada. La mayoría de los riesgos clave (construcción y explotación) son retenidos por la entidad contratante. ","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 17%,21%)","v":0.21}]
[null,null,null,null,"Es factible transferir un número importante de riesgos, aunque todavía existen algunas dudas sobre la capacidad del concesionario para gestionarlos de manera más eficiente que la entidad contratante. Si bien los beneficios en términos de optimización de costes y tiempo no están claramente identificados, la transferencia de los riesgos asociados es razonablemente justificable y puede generar valor si se introducen medidas de mitigación adecuadas. ","N/A",2]
[null,null,null,null,"Las características del proyecto permiten que la mayoría de los riesgos del proyecto sean asignados de manera eficiente al concesionario, logrando un esquema de incentivos que optimiza la gestión de costes y plazos. Los riesgos retenidos por la entidad contratante son los riesgos que puede gestionar de manera más eficiente. La asignación de riesgos también se ajusta a las buenas prácticas internacionales. ","N/A",3]
[null,"CR3","Definición de resultados de servicio"," Capacidad o preparación de la entidad contratante para la implementación y gestión del proyecto ","La entidad contratante no cuenta con un equipo especializado en la ejecución y el seguimiento de los proyectos desarrollados bajo la vía concesional, ni tiene acceso (ni presupuesto) de asistencia técnica para la gestión de la licitación y el contrato durante su vigencia.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 11%,13%)","v":0.13}]
[null,null,null,null,"La entidad contratante no cuenta con un equipo especializado en la ejecución y el seguimiento de los proyectos desarrollados bajo la vía concesional, pero cuenta con acceso asistencia técnica experimentada (proporcional a la complejidad del proyecto) para administrar el contrato durante su vigencia, una comprensión realista de los costes involucrados y los presupuestos disponibles para financiarlo.","N/A",2]
[null,null,null,null,"La entidad contratante cuenta con un equipo especializado en la implementación y supervisión de proyectos desarrollados bajo el esquema de concesión, con experiencia en el desarrollo de proyectos concesionales, tiene una buena comprensión de sus necesidades en cuanto al apoyo externo especializado y los presupuestos para financiarlo.","N/A",3]
[null,"CR4","Eficiencia en la gestión","Eficiencias mediante la gestión de costes a lo largo de todo el ciclo de vida, fomentando la innovación y maximizando la calidad y la resiliencia operativa de la infraestructura","Hay oportunidades limitadas para generar incentivos de eficiencia a lo largo del ciclo de vida del proyecto. La capacidad para maximizar la calidad y la resiliencia es reducida, y los beneficios en términos de eficiencia son mínimos. No se espera que el plazo propuesto de la concesión cubra un período de mantenimiento mayor.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 16%,0%)","v":0}]
[null,null,null,null,"La estructura contractual basada en el ciclo de vida a largo plazo permite cierto margen para generar incentivos de eficiencia en costes. Existe potencial para introducir mejoras en diseño, materiales o procesos operativos que contribuyan a una mayor resiliencia de la infraestructura y al cumplimiento de los estándares de calidad. El plazo propuesto de la concesión cubre al menos un período de mantenimiento mayor.","N/A",2]
[null,null,null,null,"La estructura contractual proporciona incentivos significativos para maximizar la eficiencia de costes durante el ciclo de vida del proyecto. La capacidad de maximizar la calidad y la resiliencia es alta, y los beneficios en términos de eficiencia son sustanciales.","N/A",3]
[null,"CR5","Competencia e interés de los inversores","Competencia e interés de los inversores","El interés del mercado es limitado, ya que no se han identificado posibles oferentes que puedan tener la capacidad de ejecutar el proyecto bajo la vía concesional.  Existen precedentes de proyectos similares con baja participación en licitaciones.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 16%,19%)","v":0.19}]
[null,null,null,null,"Existen evidencias de interés moderado por parte del mercado, con al menos 3 potenciales oferentes identificados con capacidad para entregar el proyecto bajo un esquema concesional. Existe un historial de licitaciones anteriores con una participación aceptable. ","N/A",2]
[null,null,null,null,"Existen evidencias de un gran interés en el mercado, con al menos 5 oferentes que tienen experiencia en esquemas de concesiones comparables anteriores similares. ","N/A",3]
[null,"CR6","Tamaño del Proyecto","Tamaño del Proyecto","El valor del contrato es muy bajo [inferior a 20 millones de euros] o [superior a 1 billón de euros], lo que puede dificultar su estructuración bajo la vía concesional. La capacidad de capturar eficiencias a través de este modelo es limitada.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 6%,7%)","v":7.0000000000000007E-2}]
[null,null,null,null,"El valor del contrato se encuentra dentro de un rango aceptable, pero la complejidad del proyecto es tal que sus costes de preparación, adquisición o gestión del contrato pueden ser más altos de lo habitual. Sin embargo, se espera que el proyecto pueda captar las eficiencias del esquema concesional, siempre que cuente con una estructura financiera adecuada y se den condiciones de mercado favorables.","N/A",2]
[null,null,null,null,"El valor del contrato permite capturar completamente las eficiencias asociadas con la vía concesional. El proyecto es considerado atractivo para el mercado, con precedentes exitosos a nivel regional o internacional que respaldan su viabilidad y bancabilidad.","N/A",3]
[null,"CR7","Estabilidad a largo plazo ","Estabilidad a largo plazo de las necesidades de servicio","La naturaleza y/o las necesidades del servicio a lo largo de la duración del contrato son inciertos. Si bien el proyecto podría seguir siendo viable bajo la vía concesional, considerando los requisitos actuales de servicio, esta debilidad implica que el contrato podría requerir cambios significativos durante su vigencia, lo que podría afectar su eficiencia y atractivo tanto para el mercado como para la entidad contratante.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 6%,7%)","v":7.0000000000000007E-2}]
[null,null,null,null,"La necesidad de servicio durante el plazo de la concesión es razonablemente predecible y se espera que permanezca relativamente estable. El contrato permite cierto margen de maniobra para gestionar ajustes a los términos de servicio, a través de mecanismos que pueden ser adecuados para cambios menores. Sin embargo, cambios sustanciales en las necesidades del servicio podrían generar costes significativos o requerir procesos de renegociación con cierto grado de complejidad.","N/A",2]
[null,null,null,null,"No se espera que las necesidades de servicio cambien significativamente durante el plazo de la concesión. El contrato permite cambios en los requisitos de servicio hasta cierto punto sin incurrir en costes desproporcionados ni comprometer su estabilidad. Existen mecanismos contractuales claros y eficientes, que cumplen con la contratación pública, para incorporar cambios de pequeño a mediano nivel en los requisitos de servicio o en el alcance del proyecto. Existen evidencias sustantivas de estudios o precedentes de proyectos similares a nivel nacional o regional.","N/A",3]
[null,"CR8","Eficiencias relacionadas con el tiempo","Eficiencias relacionadas con el tiempo","Es probable que el diseño contractual bajo la vía concesional retrase los tiempos de entrega del servicio debido a la complejidad del proyecto. Aunque puede lograrse cierta eficiencia después de la adjudicación, se prevé que el plazo general será más largo que en la contratación tradicional, lo que limitará las ventajas relacionadas con el tiempo de la vía concesional. Los retrasos en el tiempo también pueden tener un coste económico y social significativo. ","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 11%,13%)","v":0.13}]
[null,null,null,null,"Si bien la preparación de un proyecto bajo la vía concesional puede llevar más tiempo, se esperan ciertos ahorros de tiempo después de la adjudicación del contrato ya sea por una gestión más eficiente de los riesgos de construcción o a un acceso más ágil a la financiación. Los beneficios en términos de reducción de plazos son relevantes, aunque no llegan a ser significativos.","N/A",2]
[null,null,null,null,"La vía concesional permite una reducción significativa del tiempo de prestación de servicios y/o un menor riesgo de retrasos debidos a los incentivos al pago por desempeño en el contrato de concesión y/o a la movilización de financiación privada, mientras que la financiación pública del proyecto bajo contratación tradicional puede no estar disponible o sufrir demoras. El diseño contractual incluye mecanismos efectivos para gestionar el riesgo de retrasos en la construcción, así como incentivos claros para cumplir con los plazos. La disponibilidad temprana del servicio genera valor económico y social.","N/A",3]
[null,"CR9","Capacidad de la entidad contratante de gestionar el proyecto","Capacidad de definición de resultados objetivos y medibles (outputs de servicio)","La naturaleza de los servicios y los estándares de desempeño requeridos dificultan su expresión en términos de resultados medibles. Existen serias dudas sobre la posibilidad de incorporar indicadores objetivos en el contrato de concesión. Las expectativas de la entidad contratante se definen en gran medida en términos de insumos.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 11%,13%)","v":0.13}]
[null,null,null,null,"Se prevé que los estándares desempeño puedan estar definidos y medirse objetivamente en el contrato. Se han identificado algunos precedentes en proyectos similares en la región o a nivel internacional.","N/A",2]
[null,null,null,null,"Los estándares de desempeño están claramente definidos y se pueden medir con indicadores objetivos. Existen mecanismos de pago bien estructurados y basados en el desempeño, que incluyen incentivos y penalizaciones que alinean los intereses del concesionario con la calidad del servicio. Se han identificado múltiples precedentes exitosos de proyectos dentro del país o en la región.","N/A",3]
[null,"Atención: Para el análisis del CR2. Potencial de tranferencia eficiente del riesgo y nivel global de rentabilidad previsto, use la herramienta del CPP para cálcular el Valor por Dinero."]
[null,"Análisis de VpD en proyectos de mayor tamaño"]
[null,"CR2.1","Transferencia de riesgos","Potencial de transferencia eficiente del riesgo y nivel global de rentabilidad previsto.","El VpD es negativo en más de un -10% CSP y las principales sensibilidades no llegan a poder compensar esa brecha. Algunas sensibilidades permiten reducir sustancialmente la brecha, pero no llegan a valores positivos en la mayoría de los escenarios.","N/A",1,{"$f":"+IF('DESCRIPCIÓN PROYECTO'!$E$15= \"Concesión de Obras\", 16%,0%)","v":0}]
[null,null,null,null,"El VpD está entre 0% y -10% CSP, y las principales sensibilidades ofrecen escenarios de valor positivo. Aunque el VpD es negativo, las sensibilidades refuerzan estos resultados y muestran una posibilidad de mejora.","N/A",2]
[null,null,null,null,"El VpD es positivo, mayor a 0% CSP, y las sensibilidades refuerzan estos resultados. Las sensibilidades no muestran una alta probabilidad de que los resultados puedan ser materialmente menores, indicando una alta viabilidad.","N/A",3]

{"sheet":"CPP","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,18,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HERRAMIENTA DE TRABAJO PARA EL ANÁLISIS DEL COMPARADOR PÚBLICO - PRIVADO (CPP)"]

{"sheet":"Guía","index":7,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,1,11,7],[17,1,17,7],[23,1,23,7],[31,1,31,7],[35,1,35,7]]}
["Proyecto Ejemplo Residuos"]
["Valor por Dinero - Comparador Público Privado"]
[]
[]
[]
[null,"El Comparador Público Privado (CPP), es la metodología que se emplea para obtener el VpD cuantitativo, por la cual se compara el coste en el que incurriría la entidad contratante para desarrollar un proyecto bajo modalidad de contratación de obra pública a través del Comparador del Sector Público (CSP) frente al coste en el que incurriría para desarrollar el mismo proyecto bajo la vía concesional. \n\nEn este contexto, a continuación se detalla el funcionamiento de la herramienta, con el fin de facilitar su correcta utilización:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Pestañas"]
[]
[null,"Inputs"]
[]
[null,"En esta pestaña se recopilan todas las hipótesis temporales, macroeconómicas, de Capex, Opex, Mantenimiento Mayor, Ingresos e Impuestos, con el fin de que sean incorporadas por el usuario de la guía en las celdas correspondientes, identificadas según la siguiente tipología.\n\n\n\n\n\n\n"]
[]
[null,"Inputs","Xxx"]
[]
[null,"VpD"]
[]
[null,"En esta pestaña se presentan todos los cálculos efectuados para la obtención del Valor por Dinero (VpD) cuantitativo, así como los resultados obtenidos, los gráficos asociados y los posibles análisis de sensibilidad.\n\n\n"]
[]
[null,"Todas aquellas celdas que presenten este formato indican que su contenido proviene de la pestaña de Inputs."]
[]
[null,"Celda","Xxx"]
[]
[null,"Otras"]
[]
[null,"Del mismo modo, en ambas pestañas se incluyen notas aclaratorias con el siguiente formato, con el objetivo de facilitar la comprensión por parte del usuario de la herramienta."]
[]
[null,"Nota: XXX"]
[]
[null,"Todas aquellas celdas que presenten este formato indican que su contenido es un sumatorio total."]
[]
[null,"Celda","Xxx"]

{"sheet":"Inputs","index":8,"n_rows":152,"n_cols":37,"rows_kept":152,"cut":false,"hidden":false,"merged":[[85,1,85,3],[107,1,108,3],[130,1,130,3]]}
["Proyecto Ejemplo Residuos"]
["Valor por Dinero - Comparador Público Privado"]
["Cifras en millones de Euros"]
[]
[null,"Año",null,null,null,null,null,{"$f":"+YEAR(H6)","v":2025},{"$f":"+YEAR(I6)","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Fecha Inicio",null,null,null,null,null,"2025-01-01",{"$f":"+H7+1","v":"2026-01-01"},{"$f":"+I7+1","v":"2027-01-01"},{"$f":"+J7+1","v":"2028-01-01"},"2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01","2047-01-01","2048-01-01","2049-01-01","2050-01-01","2051-01-01","2052-01-01","2053-01-01","2054-01-01"]
[null,"Fecha Fin",null,null,null,null,null,{"$f":"+DATE(YEAR(H6),MONTH(H6)+12,DAY(H6)-1)","v":"2025-12-31"},{"$f":"+DATE(YEAR(I6),MONTH(I6)+12,DAY(I6)-1)","v":"2026-12-31"},"2027-12-31","2028-12-31","2029-12-31","2030-12-31","2031-12-31","2032-12-31","2033-12-31","2034-12-31","2035-12-31","2036-12-31","2037-12-31","2038-12-31","2039-12-31","2040-12-31","2041-12-31","2042-12-31","2043-12-31","2044-12-31","2045-12-31","2046-12-31","2047-12-31","2048-12-31","2049-12-31","2050-12-31","2051-12-31","2052-12-31","2053-12-31","2054-12-31"]
[]
[null,"Flags"]
[]
[null,"Hipótesis temporales"]
[null,"Inicio Modelo","fecha","2025-01-01"]
[null,"Plazo Proyecto","años",{"$f":"+YEAR(D14)-YEAR(D12)+1","v":25}]
[null,"Fin Proyecto","fecha",{"$f":"+D24","v":"2049-12-31"}]
[null,"Inicio Preconstrucción","fecha",{"$f":"D12","v":"2025-01-01"}]
[null,"Plazo Preconstrucción","meses",12]
[null,"Fin Preconstrucción","fecha",{"$f":"+DATE(YEAR(D15),MONTH(D15)+D16,DAY(D15)-1)","v":"2025-12-31"}]
[null,"Inicio Construcción","fecha",{"$f":"+D17+1","v":"2026-01-01"}]
[null,"Plazo Construcción","años",2]
[null,"Fin Construcción","fecha",{"$f":"+DATE(YEAR(D18)+D19,MONTH(D18),DAY(D18)-1)","v":"2027-12-31"}]
[null,"Mantenimiento Mayor","años",5]
[null,"Inicio Operación","fecha",{"$f":"+D20+1","v":"2028-01-01"}]
[null,"Plazo Operación","años",22]
[null,"Fin Operación ","fecha",{"$f":"+DATE(YEAR(D22)+D23,MONTH(D22),DAY(D22)-1)","v":"2049-12-31"}]
[]
[null,{"$f":"+\"Flag\"&\" \"&B16","v":"Flag Plazo Preconstrucción"},null,{"$f":"+SUM(H26:AK26)","v":1},null,null,null,{"$f":"+($D15<=H$7)*(H$6<=$D17)","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+\"Flag\"&\" \"&B19","v":"Flag Plazo Construcción"},null,{"$f":"+SUM(H27:AK27)","v":2},null,null,null,{"$f":"+($D18<=H$7)*(H$6<=$D20)","v":0},1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Flag Mantenimiento Mayor",null,{"$f":"+SUM(H28:AK28)","v":4},null,null,null,{"$f":"+IF(MOD(H30,$D$21)=0,1,0)*H29","v":0},{"$f":"+IF(MOD(I30,$D$21)=0,1,0)*I29","v":0},0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0]
[null,{"$f":"+\"Flag\"&\" \"&B23","v":"Flag Plazo Operación"},null,{"$f":"+SUM(H29:AK29)","v":22},null,null,null,{"$f":"+($D22<=H$7)*(H$6<=$D24)","v":0},0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
[null,"Conteo Operación",null,null,null,null,null,{"$f":"+SUM($H$29:H29)","v":0},{"$f":"+SUM($H$29:I29)","v":0},{"$f":"+SUM($H$29:J29)","v":0},{"$f":"+SUM($H$29:K29)","v":1},{"$f":"+SUM($H$29:L29)","v":2},{"$f":"+SUM($H$29:M29)","v":3},{"$f":"+SUM($H$29:N29)","v":4},{"$f":"+SUM($H$29:O29)","v":5},{"$f":"+SUM($H$29:P29)","v":6},{"$f":"+SUM($H$29:Q29)","v":7},{"$f":"+SUM($H$29:R29)","v":8},{"$f":"+SUM($H$29:S29)","v":9},{"$f":"+SUM($H$29:T29)","v":10},{"$f":"+SUM($H$29:U29)","v":11},{"$f":"+SUM($H$29:V29)","v":12},{"$f":"+SUM($H$29:W29)","v":13},{"$f":"+SUM($H$29:X29)","v":14},{"$f":"+SUM($H$29:Y29)","v":15},{"$f":"+SUM($H$29:Z29)","v":16},{"$f":"+SUM($H$29:AA29)","v":17},{"$f":"+SUM($H$29:AB29)","v":18},{"$f":"+SUM($H$29:AC29)","v":19},{"$f":"+SUM($H$29:AD29)","v":20},{"$f":"+SUM($H$29:AE29)","v":21},{"$f":"+SUM($H$29:AF29)","v":22},{"$f":"+SUM($H$29:AG29)","v":22},{"$f":"+SUM($H$29:AH29)","v":22},{"$f":"+SUM($H$29:AI29)","v":22},{"$f":"+SUM($H$29:AJ29)","v":22},{"$f":"+SUM($H$29:AK29)","v":22}]
[]
[null,"Macroeconómicas"]
[]
[null,"IPC",null,null,null,null,null,0.02,0.02,0.02,0.02,{"$f":"+K34","v":0.02},{"$f":"+L34","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Factor Indexación",null,null,null,null,1,{"$f":"+G35*(1+H34)","v":1.02},{"$f":"+H35*(1+I34)","v":1.0404},1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548]
[null,"Factor IPC",null,null,null,null,1,{"$f":"+G36*(1+H34)","v":1.02},{"$f":"+H36*(1+I34)","v":1.0404},1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548]
[null,"Factor Demanda",null,null,null,null,null,0,0,0,0.3,0.5,{"$f":"+L37+15%","v":0.65},{"$f":"+M37+15%","v":0.8},1,{"$f":"+O37","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,"Tasa de descuento","%",3.7999999999999999E-2]
[]
[]
[null,"CAPEX"]
[]
[null,"Valor del dinero ","Switch","Constantes"]
[]
[null,null,null,null,null,null,"Total"]
[null,"Costes de equipos electromecánicos","EUR miles",null,null,{"$f":"+$D$44","v":"Constantes"},{"$f":"+SUM(H47:AK47)","v":120},60,48,12]
[null,"Obra civil y edificación","EUR miles",null,null,"Constantes",80,0,40,40]
[null,"Urbanización","EUR miles",null,null,"Constantes",15,0,7.5,7.5]
[null,"Seguridad y salud","EUR miles",null,null,"Constantes",0.1,0,0.05,0.05]
[null,"Adquisición predial","EUR miles",null,null,"Constantes",0,0,0,0]
[null,"Gestión de residuos de construcción","EUR miles",null,null,"Constantes",12,0,6,6]
[null,"Interferencia en Redes","EUR miles",null,null,{"$f":"+$D$44","v":"Constantes"},{"$f":"+SUM(H53:AK53)","v":0},0,0,0]
[null,"CAPEX","EUR miles",null,null,{"$f":"+$D$44","v":"Constantes"},{"$f":"+SUM(H54:AK54)","v":227.10000000000002},{"$f":"+SUM(H47:H53)","v":60},{"$f":"+SUM(I47:I53)","v":101.55},65.55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,{"$f":"+B47","v":"Costes de equipos electromecánicos"},"EUR miles",null,null,{"$f":"+IF($F$47=\"Constantes\",\"Constantes\",\"Constantes\")","v":"Constantes"},{"$f":"+SUM(H57:AK57)","v":120},{"$f":"+IF($F47=\"Corrientes\",H47/H$36,H47)","v":60},{"$f":"+IF($F47=\"Corrientes\",I47/I$36,I47)","v":48},12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Obra civil y edificación","EUR miles",null,null,{"$f":"+IF($F$47=\"Constantes\",\"Constantes\",\"Constantes\")","v":"Constantes"},80,{"$f":"+IF($F48=\"Corrientes\",H48/H$36,H48)","v":0},40,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Urbanización","EUR miles",null,null,"Constantes",15,0,7.5,7.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Seguridad y salud","EUR miles",null,null,"Constantes",0.1,0,0.05,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Adquisición predial","EUR miles",null,null,"Constantes",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gestión de residuos de construcción","EUR miles",null,null,"Constantes",12,0,6,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+B53","v":"Interferencia en Redes"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H63:AK63)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CAPEX","EUR miles",null,null,"Constantes",{"$f":"+SUM(H64:AK64)","v":227.10000000000002},{"$f":"+SUM(H57:H63)","v":60},{"$f":"+SUM(I57:I63)","v":101.55},65.55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"OPEX"]
[]
[null,null,null,null,null,null,"Total"]
[null,"Xxxx","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H69:AK69)","v":502.338061200921},0,0,0,18.401346719999999,18.769373654399995,19.144761127488003,19.527656350037766,19.91820947703852,20.316573666579284,20.722905139910871,21.1373632427091,21.56011050756328,21.991312717714536,22.431138972068823,22.879761751510202,23.337356986540421,23.80410412627122,24.280186208796657,24.765789932972584,25.261105731632028,25.766327846264669,26.281654403189975,26.807287491253774,27.343433241078838,27.890301905900419,0,0,0,0,0]
[null,"OPEX","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H70:AK70)","v":502.338061200921},{"$f":"+SUM(H69:H69)","v":0},0,0,18.401346719999999,18.769373654399995,19.144761127488003,19.527656350037766,19.91820947703852,20.316573666579284,20.722905139910871,21.1373632427091,21.56011050756328,21.991312717714536,22.431138972068823,22.879761751510202,23.337356986540421,23.80410412627122,24.280186208796657,24.765789932972584,25.261105731632028,25.766327846264669,26.281654403189975,26.807287491253774,27.343433241078838,27.890301905900419,0,0,0,0,0]
[]
[null,{"$f":"+B69","v":"Xxxx"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H72:AK72)","v":374},{"$f":"+H69/H$36","v":0},{"$f":"+I69/I$36","v":0},0,17,16.999999999999996,17,17.000000000000004,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000007,17.000000000000007,17,16.999999999999993,16.999999999999996,17.000000000000007,17,17.000000000000007,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000004,17.000000000000004,16.999999999999996,17,0,0,0,0,0]
[null,{"$f":"+B70","v":"OPEX"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H73:AK73)","v":374},{"$f":"+SUM(H72:H72)","v":0},0,0,17,16.999999999999996,17,17.000000000000004,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000007,17.000000000000007,17,16.999999999999993,16.999999999999996,17.000000000000007,17,17.000000000000007,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000004,17.000000000000004,16.999999999999996,17,0,0,0,0,0]
[]
[null,"Mantenimiento Mayor"]
[]
[null,null,null,null,null,null,"Total"]
[null,"Xxxx","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H78:AK78)","v":109.40823046447468},0,0,0,0,0,0,0,23.433187620045317,0,0,0,0,25.872132609075926,0,0,0,0,28.56492495152547,0,0,0,0,31.537985283827965,0,0,0,0,0,0,0]
[null,{"$f":"+B75","v":"Mantenimiento Mayor"},"EUR miles",null,null,"Corrientes",{"$f":"+SUM(H79:AK79)","v":109.40823046447468},{"$f":"+SUM(H78:H78)","v":0},0,0,0,0,0,0,23.433187620045317,0,0,0,0,25.872132609075926,0,0,0,0,28.56492495152547,0,0,0,0,31.537985283827965,0,0,0,0,0,0,0]
[]
[null,{"$f":"+B78","v":"Xxxx"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H81:AK81)","v":80},{"$f":"+H78/H$36","v":0},{"$f":"+I78/I$36","v":0},0,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,0,0,0]
[null,{"$f":"+B79","v":"Mantenimiento Mayor"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H82:AK82)","v":80},{"$f":"+SUM(H81:H81)","v":0},0,0,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,0,0,0]
[]
[null,"Ingresos por terceras fuentes"]
[]
[null,"Nota: A continuación, será posible ajustar la tipología de los ingresos en función de la naturaleza de las fuentes de ingresos de terceros asociadas al Proyecto objeto de análisis. "]
[]
[]
[null,null,null,null,null,null,"Total"]
[]
[null,"Ingresos Demanda","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H91:AK91)","v":0}]
[null,{"$f":"+$B$84","v":"Ingresos por terceras fuentes"},"EUR miles",null,null,"Corrientes",{"$f":"+SUM(H92:AK92)","v":0},{"$f":"+H90*H91/1000000","v":0},{"$f":"+I90*I91/1000000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"+B91","v":"Ingresos Demanda"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H94:AK94)","v":0},{"$f":"+H91/H$35","v":0},{"$f":"+I91/I$35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+B92","v":"Ingresos por terceras fuentes"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H95:AK95)","v":0},{"$f":"+SUM(H94:H94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,"Total"]
[]
[null,"Ingresos por Venta de Energía","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H100:AK100)","v":1.1154959570534184},0,0,0,1.3116999509452798E-2,2.2298899166069763E-2,2.956834029420851E-2,3.7119639507806369E-2,4.7327540372453118E-2,4.8274091179902189E-2,4.9239573003500237E-2,5.0224364463570238E-2,5.1228851752841635E-2,5.2253428787898466E-2,5.3298497363656439E-2,5.4364467310929573E-2,5.5451756657148167E-2,5.656079179029113E-2,5.7692007626096949E-2,5.8845847778618898E-2,6.0022764734191283E-2,6.1223220028875112E-2,6.2447684429452616E-2,6.369663811804166E-2,6.4970570880402506E-2,6.6269982298010552E-2,0,0,0,0,0]
[null,{"$f":"+$B$84","v":"Ingresos por terceras fuentes"},"EUR miles",null,null,"Corrientes",{"$f":"+SUM(H101:AK101)","v":1.1154959570534181E-6},{"$f":"+H100/1000000","v":0},{"$f":"+I100/1000000","v":0},0,1.3116999509452799E-8,2.2298899166069764E-8,2.956834029420851E-8,3.7119639507806368E-8,4.7327540372453117E-8,4.8274091179902187E-8,4.9239573003500234E-8,5.0224364463570237E-8,5.1228851752841637E-8,5.2253428787898469E-8,5.3298497363656438E-8,5.4364467310929572E-8,5.5451756657148166E-8,5.6560791790291132E-8,5.7692007626096947E-8,5.8845847778618901E-8,6.0022764734191283E-8,6.1223220028875111E-8,6.2447684429452609E-8,6.3696638118041666E-8,6.4970570880402507E-8,6.6269982298010554E-8,0,0,0,0,0]
[]
[null,{"$f":"+B100","v":"Ingresos por Venta de Energía"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H103:AK103)","v":0.81797040000000021},{"$f":"+H100/H$35","v":0},{"$f":"+I100/I$35","v":0},0,1.2118079999999998E-2,2.0196800000000001E-2,2.6255840000000006E-2,3.2314880000000004E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000009E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000009E-2,4.0393600000000002E-2,0,0,0,0,0]
[null,{"$f":"+B101","v":"Ingresos por terceras fuentes"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H104:AK104)","v":0.81797040000000021},{"$f":"+SUM(H103:H103)","v":0},0,0,1.2118079999999998E-2,2.0196800000000001E-2,2.6255840000000006E-2,3.2314880000000004E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000009E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393599999999995E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000002E-2,4.0393600000000009E-2,4.0393600000000002E-2,0,0,0,0,0]
[]
[null,"PPT"]
[]
[null,"Nota: En caso de no aplicar este tipo de ingreso poner a cero."]
[]
[null,null,null,null,null,null,"Total"]
[]
[null,"PPT","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H112:AK112)","v":11.15495957053418},0,0,0,0.13116999509452798,0.22298899166069758,0.29568340294208506,0.37119639507806373,0.47327540372453125,0.48274091179902184,0.49239573003500231,0.50224364463570226,0.51228851752841631,0.52253428787898459,0.5329849736365645,0.54364467310929576,0.55451756657148166,0.56560791790291132,0.57692007626096964,0.58845847778618898,0.6002276473419127,0.61223220028875103,0.6244768442945261,0.6369663811804166,0.64970570880402501,0.66269982298010544,0,0,0,0,0]
[null,{"$f":"+B106","v":"PPT"},"EUR miles",null,null,"Corrientes",{"$f":"+SUM(H113:AK113)","v":1.1154959570534183E-5},{"$f":"+H112/1000000","v":0},{"$f":"+I112/1000000","v":0},{"$f":"+J112/1000000","v":0},{"$f":"+K112/1000000","v":1.3116999509452799E-7},{"$f":"+L112/1000000","v":2.2298899166069759E-7},2.9568340294208504E-7,3.7119639507806371E-7,4.7327540372453124E-7,4.8274091179902187E-7,4.9239573003500227E-7,5.0224364463570221E-7,5.1228851752841633E-7,5.2253428787898456E-7,5.3298497363656446E-7,5.4364467310929576E-7,5.5451756657148162E-7,5.6560791790291135E-7,5.769200762609696E-7,5.8845847778618898E-7,6.0022764734191269E-7,6.1223220028875105E-7,6.2447684429452614E-7,6.3696638118041656E-7,6.4970570880402502E-7,6.6269982298010544E-7,0,0,0,0,0]
[]
[null,{"$f":"+B112","v":"PPT"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H115:AK115)","v":8.1797039999999992},{"$f":"+H112/H$35","v":0},{"$f":"+I112/I$35","v":0},0,0.12118079999999998,0.20196799999999998,0.26255840000000003,0.32314880000000007,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393599999999996,0.40393599999999996,0.40393599999999996,0.40393600000000007,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393600000000007,0.40393600000000002,0.40393599999999996,0.40393599999999996,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393600000000002,0,0,0,0,0]
[null,{"$f":"+B112","v":"PPT"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H116:AK116)","v":8.1797039999999992},{"$f":"+H115","v":0},{"$f":"+I115","v":0},0,0.12118079999999998,0.20196799999999998,0.26255840000000003,0.32314880000000007,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393599999999996,0.40393599999999996,0.40393599999999996,0.40393600000000007,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393600000000007,0.40393600000000002,0.40393599999999996,0.40393599999999996,0.40393600000000002,0.40393600000000002,0.40393600000000002,0.40393600000000002,0,0,0,0,0]
[]
[null,"PPD"]
[]
[null,"Valor del dinero ","Switch","Corrientes",null,null,"Total"]
[]
[null,"PPD","EUR miles",null,null,{"$f":"+IF($D$120=\"Corrientes\",$D$120,\"Constantes\")","v":"Corrientes"},{"$f":"+SUM(H122:AK122)","v":1211.5212064257505},0,0,0,44.379718560000001,45.267312931200003,46.172659189824003,47.096112373620478,48.038034621092898,48.998795313514755,49.978771219785052,50.978346644180753,51.997913577064367,53.037871848605647,54.098629285577765,55.180601871289326,56.28421390871511,57.409898186889421,58.558096150627208,59.729258073639748,60.92384323511255,62.142320099814803,63.385166501811106,64.652869831847326,65.945927228484265,67.264845773053963,0,0,0,0,0]
[null,{"$f":"+B118","v":"PPD"},"EUR miles",null,null,{"$f":"+IF($D$120=\"Corrientes\",$D$120,\"Constantes\")","v":"Corrientes"},{"$f":"+SUM(H123:AK123)","v":1211.5212064257505},{"$f":"+H122","v":0},{"$f":"+I122","v":0},0,44.379718560000001,45.267312931200003,46.172659189824003,47.096112373620478,48.038034621092898,48.998795313514755,49.978771219785052,50.978346644180753,51.997913577064367,53.037871848605647,54.098629285577765,55.180601871289326,56.28421390871511,57.409898186889421,58.558096150627208,59.729258073639748,60.92384323511255,62.142320099814803,63.385166501811106,64.652869831847326,65.945927228484265,67.264845773053963,0,0,0,0,0]
[]
[null,{"$f":"+B122","v":"PPD"},"EUR miles",null,null,{"$f":"+IF($F$122=\"Corrientes\",\"Constantes\", \"Constantes\")","v":"Constantes"},{"$f":"+SUM(H125:AK125)","v":902},{"$f":"+IF($F$122=\"Corrientes\",H122/H$35,H122)","v":0},{"$f":"+IF($F$122=\"Corrientes\",I122/I$35,I122)","v":0},0,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,40.999999999999993,41.000000000000007,0,0,0,0,0]
[null,{"$f":"+B122","v":"PPD"},"EUR miles",null,null,{"$f":"+IF($F$122=\"Corrientes\",\"Constantes\", \"Constantes\")","v":"Constantes"},{"$f":"+SUM(H126:AK126)","v":902},{"$f":"+H125","v":0},0,0,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,40.999999999999993,41.000000000000007,0,0,0,0,0]
[]
[]
[null,"Impuestos"]
[]
[null,"Nota: A continuación, será posible incluir los Impuestos a los que está sujeto el Proyecto.",null,null,null,null,"Total"]
[]
[null,"Impuesto de Sociedades","EUR miles",null,null,"Corrientes",{"$f":"+SUM(H133:AK133)","v":93.90764147203268},0.6630800388333532,2.5283421769418606,4.6458811497636789,5.5192244622540194,5.4248320900770954,5.3089261299380341,5.1696087576695042,5.258158736292728,5.3409873227035742,5.1645686002261568,4.9600712059164209,4.7248056170381219,4.7361593486599913,4.7349273065778812,4.4394319216100699,4.1042057391408235,3.7255226455830743,3.6088186228164676,3.4670167835391594,2.9881513645903812,2.4521917362087962,1.8538773856311057,1.5291883523152925,1.1598145945601224,0.39984938312897744,2.6923397452612875E-12,2.9257040253711487E-12,3.179295651352586E-12,3.4548678714782832E-12,3.7543259005480769E-12]
[null,{"$f":"+B129","v":"Impuestos"},"EUR miles",null,null,"Corrientes",{"$f":"+SUM(H134:AK134)","v":93.90764147203268},{"$f":"+SUM(H133:H133)","v":0.6630800388333532},2.5283421769418606,4.6458811497636789,5.5192244622540194,5.4248320900770954,5.3089261299380341,5.1696087576695042,5.258158736292728,5.3409873227035742,5.1645686002261568,4.9600712059164209,4.7248056170381219,4.7361593486599913,4.7349273065778812,4.4394319216100699,4.1042057391408235,3.7255226455830743,3.6088186228164676,3.4670167835391594,2.9881513645903812,2.4521917362087962,1.8538773856311057,1.5291883523152925,1.1598145945601224,0.39984938312897744,2.6923397452612875E-12,2.9257040253711487E-12,3.179295651352586E-12,3.4548678714782832E-12,3.7543259005480769E-12]
[]
[null,{"$f":"+B133","v":"Impuesto de Sociedades"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H136:AK136)","v":75.461178999355297},{"$f":"+H133/H$36","v":0.6500784694444639},{"$f":"+I133/I$36","v":2.430163568763803},4.3779175710734179,5.0989102746670234,4.9134375621368429,4.7141744735254676,4.5004555234408166,4.4877878516150078,4.4690992672313268,4.2367450707841376,3.9892019421894576,3.7254769849844354,3.6612052204761425,3.5884831488964744,3.2985633105375176,2.9896914892990676,2.660628799090754,2.5267481913154781,2.3798669648608848,2.0109402073570499,1.6178968056401914,1.1991602610794361,0.96974384289501792,0.72108165546310687,0.24372054257880094,1.6088864594970561E-12,1.7140589403042734E-12,1.8261065182657059E-12,1.9454786166574541E-12,2.0726540374358842E-12]
[null,{"$f":"+B133","v":"Impuesto de Sociedades"},"EUR miles",null,null,"Constantes",{"$f":"+SUM(H137:AK137)","v":75.461178999355297},{"$f":"+SUM(H136:H136)","v":0.6500784694444639},{"$f":"+SUM(I136:I136)","v":2.430163568763803},4.3779175710734179,5.0989102746670234,4.9134375621368429,4.7141744735254676,4.5004555234408166,4.4877878516150078,4.4690992672313268,4.2367450707841376,3.9892019421894576,3.7254769849844354,3.6612052204761425,3.5884831488964744,3.2985633105375176,2.9896914892990676,2.660628799090754,2.5267481913154781,2.3798669648608848,2.0109402073570499,1.6178968056401914,1.1991602610794361,0.96974384289501792,0.72108165546310687,0.24372054257880094,1.6088864594970561E-12,1.7140589403042734E-12,1.8261065182657059E-12,1.9454786166574541E-12,2.0726540374358842E-12]
[]
[null,"Transferencia de Riesgos"]
[]
[null,"Supuestos"]
[]
[null,"Riesgos Compartidos",null,"Transferido","Retenido"]
[null,{"$f":"+$B$148","v":"Adquisición Equipos"},null,0.8,{"$f":"100%-D144","v":0.19999999999999996}]
[]
[null,"Riesgos Transferidos (Sobre coste)"]
[]
[null,"Adquisición Equipos","%",0.1]
[]
[null,"Costrucción","%",0.1]
[]
[null,"Operación y Mantenimiento","%",0.1]

{"sheet":"VpD","index":9,"n_rows":226,"n_cols":35,"rows_kept":226,"cut":false,"hidden":false,"merged":[[142,1,142,2],[162,1,176,2],[178,1,178,2],[186,1,200,2],[91,1,91,2],[92,1,92,2],[125,1,125,2],[126,1,126,2],[134,1,134,2],[135,1,135,2]]}
[{"$f":"+Inputs!A1","v":"Proyecto Ejemplo Residuos"}]
[{"$f":"+Inputs!A2","v":"Valor por Dinero - Comparador Público Privado"}]
[{"$f":"+Inputs!A3","v":"Cifras en millones de Euros"}]
[]
[null,"Año",null,null,null,{"$f":"+YEAR(F6)","v":2025},{"$f":"+YEAR(G6)","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054]
[null,"Fecha Inicio",null,null,null,{"$f":"+Inputs!H6","v":"2025-01-01"},{"$f":"+F7+1","v":"2026-01-01"},{"$f":"+G7+1","v":"2027-01-01"},"2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01","2047-01-01","2048-01-01","2049-01-01","2050-01-01","2051-01-01","2052-01-01","2053-01-01","2054-01-01"]
[null,"Fecha Fin",null,null,null,{"$f":"+DATE(YEAR(F6),MONTH(F6)+12,DAY(F6)-1)","v":"2025-12-31"},{"$f":"+DATE(YEAR(G6),MONTH(G6)+12,DAY(G6)-1)","v":"2026-12-31"},"2027-12-31","2028-12-31","2029-12-31","2030-12-31","2031-12-31","2032-12-31","2033-12-31","2034-12-31","2035-12-31","2036-12-31","2037-12-31","2038-12-31","2039-12-31","2040-12-31","2041-12-31","2042-12-31","2043-12-31","2044-12-31","2045-12-31","2046-12-31","2047-12-31","2048-12-31","2049-12-31","2050-12-31","2051-12-31","2052-12-31","2053-12-31","2054-12-31"]
[null,null,null,null,null,{"$f":"+EOMONTH(F6,12)","v":"2026-01-31"}]
[null,{"$f":"+Inputs!B26","v":"Flag Plazo Preconstrucción"},null,null,null,{"$f":"+Inputs!H26","v":1},{"$f":"+Inputs!I26","v":0},{"$f":"+Inputs!J26","v":0},{"$f":"+Inputs!K26","v":0},{"$f":"+Inputs!L26","v":0},{"$f":"+Inputs!M26","v":0},{"$f":"+Inputs!N26","v":0},{"$f":"+Inputs!O26","v":0},{"$f":"+Inputs!P26","v":0},{"$f":"+Inputs!Q26","v":0},{"$f":"+Inputs!R26","v":0},{"$f":"+Inputs!S26","v":0},{"$f":"+Inputs!T26","v":0},{"$f":"+Inputs!U26","v":0},{"$f":"+Inputs!V26","v":0},{"$f":"+Inputs!W26","v":0},{"$f":"+Inputs!X26","v":0},{"$f":"+Inputs!Y26","v":0},{"$f":"+Inputs!Z26","v":0},{"$f":"+Inputs!AA26","v":0},{"$f":"+Inputs!AB26","v":0},{"$f":"+Inputs!AC26","v":0},{"$f":"+Inputs!AD26","v":0},{"$f":"+Inputs!AE26","v":0},{"$f":"+Inputs!AF26","v":0},{"$f":"+Inputs!AG26","v":0},{"$f":"+Inputs!AH26","v":0},{"$f":"+Inputs!AI26","v":0},{"$f":"+Inputs!AJ26","v":0},{"$f":"+Inputs!AK26","v":0}]
[null,{"$f":"+Inputs!B27","v":"Flag Plazo Construcción"},null,null,null,{"$f":"+Inputs!H27","v":0},{"$f":"+Inputs!I27","v":1},{"$f":"+Inputs!J27","v":1},{"$f":"+Inputs!K27","v":0},{"$f":"+Inputs!L27","v":0},{"$f":"+Inputs!M27","v":0},{"$f":"+Inputs!N27","v":0},{"$f":"+Inputs!O27","v":0},{"$f":"+Inputs!P27","v":0},{"$f":"+Inputs!Q27","v":0},{"$f":"+Inputs!R27","v":0},{"$f":"+Inputs!S27","v":0},{"$f":"+Inputs!T27","v":0},{"$f":"+Inputs!U27","v":0},{"$f":"+Inputs!V27","v":0},{"$f":"+Inputs!W27","v":0},{"$f":"+Inputs!X27","v":0},{"$f":"+Inputs!Y27","v":0},{"$f":"+Inputs!Z27","v":0},{"$f":"+Inputs!AA27","v":0},{"$f":"+Inputs!AB27","v":0},{"$f":"+Inputs!AC27","v":0},{"$f":"+Inputs!AD27","v":0},{"$f":"+Inputs!AE27","v":0},{"$f":"+Inputs!AF27","v":0},{"$f":"+Inputs!AG27","v":0},{"$f":"+Inputs!AH27","v":0},{"$f":"+Inputs!AI27","v":0},{"$f":"+Inputs!AJ27","v":0},{"$f":"+Inputs!AK27","v":0}]
[null,{"$f":"+Inputs!B29","v":"Flag Plazo Operación"},"flag",null,null,{"$f":"+Inputs!H29","v":0},{"$f":"+Inputs!I29","v":0},{"$f":"+Inputs!J29","v":0},{"$f":"+Inputs!K29","v":1},{"$f":"+Inputs!L29","v":1},{"$f":"+Inputs!M29","v":1},{"$f":"+Inputs!N29","v":1},{"$f":"+Inputs!O29","v":1},{"$f":"+Inputs!P29","v":1},{"$f":"+Inputs!Q29","v":1},{"$f":"+Inputs!R29","v":1},{"$f":"+Inputs!S29","v":1},{"$f":"+Inputs!T29","v":1},{"$f":"+Inputs!U29","v":1},{"$f":"+Inputs!V29","v":1},{"$f":"+Inputs!W29","v":1},{"$f":"+Inputs!X29","v":1},{"$f":"+Inputs!Y29","v":1},{"$f":"+Inputs!Z29","v":1},{"$f":"+Inputs!AA29","v":1},{"$f":"+Inputs!AB29","v":1},{"$f":"+Inputs!AC29","v":1},{"$f":"+Inputs!AD29","v":1},{"$f":"+Inputs!AE29","v":1},{"$f":"+Inputs!AF29","v":1},{"$f":"+Inputs!AG29","v":0},{"$f":"+Inputs!AH29","v":0},{"$f":"+Inputs!AI29","v":0},{"$f":"+Inputs!AJ29","v":0},{"$f":"+Inputs!AK29","v":0}]
[null,{"$f":"+Inputs!B36","v":"Factor IPC"},"índice",null,null,{"$f":"+Inputs!H36","v":1.02},{"$f":"+Inputs!I36","v":1.0404},{"$f":"+Inputs!J36","v":1.0612079999999999},{"$f":"+Inputs!K36","v":1.08243216},{"$f":"+Inputs!L36","v":1.1040808032},{"$f":"+Inputs!M36","v":1.1261624192640001},{"$f":"+Inputs!N36","v":1.14868566764928},{"$f":"+Inputs!O36","v":1.1716593810022657},{"$f":"+Inputs!P36","v":1.1950925686223111},{"$f":"+Inputs!Q36","v":1.2189944199947573},{"$f":"+Inputs!R36","v":1.2433743083946525},{"$f":"+Inputs!S36","v":1.2682417945625455},{"$f":"+Inputs!T36","v":1.2936066304537963},{"$f":"+Inputs!U36","v":1.3194787630628724},{"$f":"+Inputs!V36","v":1.3458683383241299},{"$f":"+Inputs!W36","v":1.3727857050906125},{"$f":"+Inputs!X36","v":1.4002414191924248},{"$f":"+Inputs!Y36","v":1.4282462475762734},{"$f":"+Inputs!Z36","v":1.4568111725277988},{"$f":"+Inputs!AA36","v":1.4859473959783549},{"$f":"+Inputs!AB36","v":1.5156663438979221},{"$f":"+Inputs!AC36","v":1.5459796707758806},{"$f":"+Inputs!AD36","v":1.5768992641913981},{"$f":"+Inputs!AE36","v":1.6084372494752261},{"$f":"+Inputs!AF36","v":1.6406059944647307},{"$f":"+Inputs!AG36","v":1.6734181143540252},{"$f":"+Inputs!AH36","v":1.7068864766411058},{"$f":"+Inputs!AI36","v":1.7410242061739281},{"$f":"+Inputs!AJ36","v":1.7758446902974065},{"$f":"+Inputs!AK36","v":1.8113615841033548}]
[]
[]
[null,"Valor por Dinero"]
[]
[null,"Tasa de descuento","%",5.2069999999999998E-2]
[]
[null,"CSP "]
[]
[null,"Coste Base del Proyecto"]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+Inputs!B47","v":"Costes de equipos electromecánicos"},"EUR miles","Constantes",{"$f":"+SUM(F24:AI24)","v":120},{"$f":"+Inputs!H57","v":60},{"$f":"+Inputs!I57","v":48},{"$f":"+Inputs!J57","v":12},{"$f":"+Inputs!K57","v":0},{"$f":"+Inputs!L57","v":0},{"$f":"+Inputs!M57","v":0},{"$f":"+Inputs!N57","v":0},{"$f":"+Inputs!O57","v":0},{"$f":"+Inputs!P57","v":0},{"$f":"+Inputs!Q57","v":0},{"$f":"+Inputs!R57","v":0},{"$f":"+Inputs!S57","v":0},{"$f":"+Inputs!T57","v":0},{"$f":"+Inputs!U57","v":0},{"$f":"+Inputs!V57","v":0},{"$f":"+Inputs!W57","v":0},{"$f":"+Inputs!X57","v":0},{"$f":"+Inputs!Y57","v":0},{"$f":"+Inputs!Z57","v":0},{"$f":"+Inputs!AA57","v":0},{"$f":"+Inputs!AB57","v":0},{"$f":"+Inputs!AC57","v":0},{"$f":"+Inputs!AD57","v":0},{"$f":"+Inputs!AE57","v":0},{"$f":"+Inputs!AF57","v":0},{"$f":"+Inputs!AG57","v":0},{"$f":"+Inputs!AH57","v":0},{"$f":"+Inputs!AI57","v":0},{"$f":"+Inputs!AJ57","v":0},{"$f":"+Inputs!AK57","v":0}]
[null,{"$f":"+Inputs!B48","v":"Obra civil y edificación"},"EUR miles","Constantes",80,{"$f":"+Inputs!H58","v":0},{"$f":"+Inputs!I58","v":40},{"$f":"+Inputs!J58","v":40},{"$f":"+Inputs!K58","v":0},{"$f":"+Inputs!L58","v":0},{"$f":"+Inputs!M58","v":0},{"$f":"+Inputs!N58","v":0},{"$f":"+Inputs!O58","v":0},{"$f":"+Inputs!P58","v":0},{"$f":"+Inputs!Q58","v":0},{"$f":"+Inputs!R58","v":0},{"$f":"+Inputs!S58","v":0},{"$f":"+Inputs!T58","v":0},{"$f":"+Inputs!U58","v":0},{"$f":"+Inputs!V58","v":0},{"$f":"+Inputs!W58","v":0},{"$f":"+Inputs!X58","v":0},{"$f":"+Inputs!Y58","v":0},{"$f":"+Inputs!Z58","v":0},{"$f":"+Inputs!AA58","v":0},{"$f":"+Inputs!AB58","v":0},{"$f":"+Inputs!AC58","v":0},{"$f":"+Inputs!AD58","v":0},{"$f":"+Inputs!AE58","v":0},{"$f":"+Inputs!AF58","v":0},{"$f":"+Inputs!AG58","v":0},{"$f":"+Inputs!AH58","v":0},{"$f":"+Inputs!AI58","v":0},{"$f":"+Inputs!AJ58","v":0},{"$f":"+Inputs!AK58","v":0}]
[null,{"$f":"+Inputs!B49","v":"Urbanización"},"EUR miles","Constantes",15,{"$f":"+Inputs!H59","v":0},{"$f":"+Inputs!I59","v":7.5},{"$f":"+Inputs!J59","v":7.5},{"$f":"+Inputs!K59","v":0},{"$f":"+Inputs!L59","v":0},{"$f":"+Inputs!M59","v":0},{"$f":"+Inputs!N59","v":0},{"$f":"+Inputs!O59","v":0},{"$f":"+Inputs!P59","v":0},{"$f":"+Inputs!Q59","v":0},{"$f":"+Inputs!R59","v":0},{"$f":"+Inputs!S59","v":0},{"$f":"+Inputs!T59","v":0},{"$f":"+Inputs!U59","v":0},{"$f":"+Inputs!V59","v":0},{"$f":"+Inputs!W59","v":0},{"$f":"+Inputs!X59","v":0},{"$f":"+Inputs!Y59","v":0},{"$f":"+Inputs!Z59","v":0},{"$f":"+Inputs!AA59","v":0},{"$f":"+Inputs!AB59","v":0},{"$f":"+Inputs!AC59","v":0},{"$f":"+Inputs!AD59","v":0},{"$f":"+Inputs!AE59","v":0},{"$f":"+Inputs!AF59","v":0},{"$f":"+Inputs!AG59","v":0},{"$f":"+Inputs!AH59","v":0},{"$f":"+Inputs!AI59","v":0},{"$f":"+Inputs!AJ59","v":0},{"$f":"+Inputs!AK59","v":0}]
[null,{"$f":"+Inputs!B50","v":"Seguridad y salud"},"EUR miles","Constantes",0.1,{"$f":"+Inputs!H60","v":0},{"$f":"+Inputs!I60","v":0.05},{"$f":"+Inputs!J60","v":0.05},{"$f":"+Inputs!K60","v":0},{"$f":"+Inputs!L60","v":0},{"$f":"+Inputs!M60","v":0},{"$f":"+Inputs!N60","v":0},{"$f":"+Inputs!O60","v":0},{"$f":"+Inputs!P60","v":0},{"$f":"+Inputs!Q60","v":0},{"$f":"+Inputs!R60","v":0},{"$f":"+Inputs!S60","v":0},{"$f":"+Inputs!T60","v":0},{"$f":"+Inputs!U60","v":0},{"$f":"+Inputs!V60","v":0},{"$f":"+Inputs!W60","v":0},{"$f":"+Inputs!X60","v":0},{"$f":"+Inputs!Y60","v":0},{"$f":"+Inputs!Z60","v":0},{"$f":"+Inputs!AA60","v":0},{"$f":"+Inputs!AB60","v":0},{"$f":"+Inputs!AC60","v":0},{"$f":"+Inputs!AD60","v":0},{"$f":"+Inputs!AE60","v":0},{"$f":"+Inputs!AF60","v":0},{"$f":"+Inputs!AG60","v":0},{"$f":"+Inputs!AH60","v":0},{"$f":"+Inputs!AI60","v":0},{"$f":"+Inputs!AJ60","v":0},{"$f":"+Inputs!AK60","v":0}]
[null,{"$f":"+Inputs!B51","v":"Adquisición predial"},"EUR miles","Constantes",0,{"$f":"+Inputs!H61","v":0},{"$f":"+Inputs!I61","v":0},{"$f":"+Inputs!J61","v":0},{"$f":"+Inputs!K61","v":0},{"$f":"+Inputs!L61","v":0},{"$f":"+Inputs!M61","v":0},{"$f":"+Inputs!N61","v":0},{"$f":"+Inputs!O61","v":0},{"$f":"+Inputs!P61","v":0},{"$f":"+Inputs!Q61","v":0},{"$f":"+Inputs!R61","v":0},{"$f":"+Inputs!S61","v":0},{"$f":"+Inputs!T61","v":0},{"$f":"+Inputs!U61","v":0},{"$f":"+Inputs!V61","v":0},{"$f":"+Inputs!W61","v":0},{"$f":"+Inputs!X61","v":0},{"$f":"+Inputs!Y61","v":0},{"$f":"+Inputs!Z61","v":0},{"$f":"+Inputs!AA61","v":0},{"$f":"+Inputs!AB61","v":0},{"$f":"+Inputs!AC61","v":0},{"$f":"+Inputs!AD61","v":0},{"$f":"+Inputs!AE61","v":0},{"$f":"+Inputs!AF61","v":0},{"$f":"+Inputs!AG61","v":0},{"$f":"+Inputs!AH61","v":0},{"$f":"+Inputs!AI61","v":0},{"$f":"+Inputs!AJ61","v":0},{"$f":"+Inputs!AK61","v":0}]
[null,{"$f":"+Inputs!B52","v":"Gestión de residuos de construcción"},"EUR miles","Constantes",12,{"$f":"+Inputs!H62","v":0},{"$f":"+Inputs!I62","v":6},{"$f":"+Inputs!J62","v":6},{"$f":"+Inputs!K62","v":0},{"$f":"+Inputs!L62","v":0},{"$f":"+Inputs!M62","v":0},{"$f":"+Inputs!N62","v":0},{"$f":"+Inputs!O62","v":0},{"$f":"+Inputs!P62","v":0},{"$f":"+Inputs!Q62","v":0},{"$f":"+Inputs!R62","v":0},{"$f":"+Inputs!S62","v":0},{"$f":"+Inputs!T62","v":0},{"$f":"+Inputs!U62","v":0},{"$f":"+Inputs!V62","v":0},{"$f":"+Inputs!W62","v":0},{"$f":"+Inputs!X62","v":0},{"$f":"+Inputs!Y62","v":0},{"$f":"+Inputs!Z62","v":0},{"$f":"+Inputs!AA62","v":0},{"$f":"+Inputs!AB62","v":0},{"$f":"+Inputs!AC62","v":0},{"$f":"+Inputs!AD62","v":0},{"$f":"+Inputs!AE62","v":0},{"$f":"+Inputs!AF62","v":0},{"$f":"+Inputs!AG62","v":0},{"$f":"+Inputs!AH62","v":0},{"$f":"+Inputs!AI62","v":0},{"$f":"+Inputs!AJ62","v":0},{"$f":"+Inputs!AK62","v":0}]
[null,{"$f":"+Inputs!B53","v":"Interferencia en Redes"},"EUR miles","Constantes",{"$f":"+SUM(F30:AI30)","v":0},{"$f":"+Inputs!H63","v":0},{"$f":"+Inputs!I63","v":0},{"$f":"+Inputs!J63","v":0},{"$f":"+Inputs!K63","v":0},{"$f":"+Inputs!L63","v":0},{"$f":"+Inputs!M63","v":0},{"$f":"+Inputs!N63","v":0},{"$f":"+Inputs!O63","v":0},{"$f":"+Inputs!P63","v":0},{"$f":"+Inputs!Q63","v":0},{"$f":"+Inputs!R63","v":0},{"$f":"+Inputs!S63","v":0},{"$f":"+Inputs!T63","v":0},{"$f":"+Inputs!U63","v":0},{"$f":"+Inputs!V63","v":0},{"$f":"+Inputs!W63","v":0},{"$f":"+Inputs!X63","v":0},{"$f":"+Inputs!Y63","v":0},{"$f":"+Inputs!Z63","v":0},{"$f":"+Inputs!AA63","v":0},{"$f":"+Inputs!AB63","v":0},{"$f":"+Inputs!AC63","v":0},{"$f":"+Inputs!AD63","v":0},{"$f":"+Inputs!AE63","v":0},{"$f":"+Inputs!AF63","v":0},{"$f":"+Inputs!AG63","v":0},{"$f":"+Inputs!AH63","v":0},{"$f":"+Inputs!AI63","v":0},{"$f":"+Inputs!AJ63","v":0},{"$f":"+Inputs!AK63","v":0}]
[null,"CAPEX","EUR miles","Constantes",{"$f":"+SUM(F31:AI31)","v":227.10000000000002},{"$f":"+SUM(F24:F30)","v":60},{"$f":"+SUM(G24:G30)","v":101.55},65.55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"VAN ",{"$f":"+NPV($D$17,F31:AI31)","v":205.06814529546915}]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+Inputs!B72","v":"Xxxx"},null,"Constantes",{"$f":"+SUM(F35:AI35)","v":374},{"$f":"+Inputs!H72","v":0},{"$f":"+Inputs!I72","v":0},{"$f":"+Inputs!J72","v":0},{"$f":"+Inputs!K72","v":17},{"$f":"+Inputs!L72","v":16.999999999999996},{"$f":"+Inputs!M72","v":17},{"$f":"+Inputs!N72","v":17.000000000000004},{"$f":"+Inputs!O72","v":17.000000000000004},{"$f":"+Inputs!P72","v":16.999999999999996},{"$f":"+Inputs!Q72","v":16.999999999999996},{"$f":"+Inputs!R72","v":17.000000000000007},{"$f":"+Inputs!S72","v":17.000000000000007},{"$f":"+Inputs!T72","v":17},{"$f":"+Inputs!U72","v":16.999999999999993},{"$f":"+Inputs!V72","v":16.999999999999996},{"$f":"+Inputs!W72","v":17.000000000000007},{"$f":"+Inputs!X72","v":17},{"$f":"+Inputs!Y72","v":17.000000000000007},{"$f":"+Inputs!Z72","v":17.000000000000004},{"$f":"+Inputs!AA72","v":16.999999999999996},{"$f":"+Inputs!AB72","v":16.999999999999996},{"$f":"+Inputs!AC72","v":17.000000000000004},{"$f":"+Inputs!AD72","v":17.000000000000004},{"$f":"+Inputs!AE72","v":16.999999999999996},{"$f":"+Inputs!AF72","v":17},{"$f":"+Inputs!AG72","v":0},{"$f":"+Inputs!AH72","v":0},{"$f":"+Inputs!AI72","v":0},{"$f":"+Inputs!AJ72","v":0},{"$f":"+Inputs!AK72","v":0}]
[null,"OPEX",null,"Constantes",{"$f":"+SUM(F36:AI36)","v":374},{"$f":"+SUM(F35:F35)","v":0},0,0,17,16.999999999999996,17,17.000000000000004,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000007,17.000000000000007,17,16.999999999999993,16.999999999999996,17.000000000000007,17,17.000000000000007,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000004,17.000000000000004,16.999999999999996,17,0,0,0,0,0]
[null,null,null,"VAN ",{"$f":"+NPV($D$17,F36:AI36)","v":188.58790342565533}]
[]
[null,{"$f":"+Inputs!B81","v":"Xxxx"},null,"Constantes",{"$f":"+SUM(F39:AI39)","v":80},{"$f":"+Inputs!H81","v":0},{"$f":"+Inputs!I81","v":0},{"$f":"+Inputs!J81","v":0},{"$f":"+Inputs!K81","v":0},{"$f":"+Inputs!L81","v":0},{"$f":"+Inputs!M81","v":0},{"$f":"+Inputs!N81","v":0},{"$f":"+Inputs!O81","v":20},{"$f":"+Inputs!P81","v":0},{"$f":"+Inputs!Q81","v":0},{"$f":"+Inputs!R81","v":0},{"$f":"+Inputs!S81","v":0},{"$f":"+Inputs!T81","v":20},{"$f":"+Inputs!U81","v":0},{"$f":"+Inputs!V81","v":0},{"$f":"+Inputs!W81","v":0},{"$f":"+Inputs!X81","v":0},{"$f":"+Inputs!Y81","v":20},{"$f":"+Inputs!Z81","v":0},{"$f":"+Inputs!AA81","v":0},{"$f":"+Inputs!AB81","v":0},{"$f":"+Inputs!AC81","v":0},{"$f":"+Inputs!AD81","v":20},{"$f":"+Inputs!AE81","v":0},{"$f":"+Inputs!AF81","v":0},{"$f":"+Inputs!AG81","v":0},{"$f":"+Inputs!AH81","v":0},{"$f":"+Inputs!AI81","v":0},{"$f":"+Inputs!AJ81","v":0},{"$f":"+Inputs!AK81","v":0}]
[null,"Mantenimiento Mayor",null,"Constantes",{"$f":"+SUM(F40:AI40)","v":80},{"$f":"+SUM(F39:F39)","v":0},{"$f":"+SUM(G39:G39)","v":0},0,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,20,0,0,0,0,0,0,0]
[null,null,null,"VAN ",{"$f":"+NPV($D$17,F40:AI40)","v":37.907502596302834}]
[]
[null,"Resumen Costo Base del Proyecto",null,null,"Total"]
[null,{"$f":"+B31","v":"CAPEX"},null,"VAN",{"$f":"+E32","v":205.06814529546915}]
[null,{"$f":"+B36","v":"OPEX"},null,"VAN",{"$f":"+E37","v":188.58790342565533}]
[null,{"$f":"+B40","v":"Mantenimiento Mayor"},null,"VAN",{"$f":"+E41","v":37.907502596302834}]
[null,"Total",null,"VAN",{"$f":"+SUM(E44:E46)","v":431.56355131742731}]
[]
[]
[null,"Valoración de riesgos transferidos"]
[]
[]
[null,{"$f":"+Inputs!$B$148","v":"Adquisición Equipos"}]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+B53","v":"Adquisición Equipos"},null,"Constantes",{"$f":"+SUM(F56:AI56)","v":120},{"$f":"+F24","v":60},{"$f":"+G24","v":48},12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Costo Riesgo Adquisición Equipos",{"$f":"+Inputs!$D$148","v":0.1},"Constantes",{"$f":"+SUM(F57:AI57)","v":9.6000000000000014},{"$f":"+$C57*F56*Inputs!$D$144","v":4.8000000000000007},{"$f":"+$C57*G56*Inputs!$D$144","v":3.8400000000000007},{"$f":"+$C57*H56*Inputs!$D$144","v":0.96000000000000019},{"$f":"+$C57*I56*Inputs!$D$144","v":0},{"$f":"+$C57*J56*Inputs!$D$144","v":0},{"$f":"+$C57*K56*Inputs!$D$144","v":0},{"$f":"+$C57*L56*Inputs!$D$144","v":0},{"$f":"+$C57*M56*Inputs!$D$144","v":0},{"$f":"+$C57*N56*Inputs!$D$144","v":0},{"$f":"+$C57*O56*Inputs!$D$144","v":0},{"$f":"+$C57*P56*Inputs!$D$144","v":0},{"$f":"+$C57*Q56*Inputs!$D$144","v":0},{"$f":"+$C57*R56*Inputs!$D$144","v":0},{"$f":"+$C57*S56*Inputs!$D$144","v":0},{"$f":"+$C57*T56*Inputs!$D$144","v":0},{"$f":"+$C57*U56*Inputs!$D$144","v":0},{"$f":"+$C57*V56*Inputs!$D$144","v":0},{"$f":"+$C57*W56*Inputs!$D$144","v":0},{"$f":"+$C57*X56*Inputs!$D$144","v":0},{"$f":"+$C57*Y56*Inputs!$D$144","v":0},{"$f":"+$C57*Z56*Inputs!$D$144","v":0},{"$f":"+$C57*AA56*Inputs!$D$144","v":0},{"$f":"+$C57*AB56*Inputs!$D$144","v":0},{"$f":"+$C57*AC56*Inputs!$D$144","v":0},{"$f":"+$C57*AD56*Inputs!$D$144","v":0},{"$f":"+$C57*AE56*Inputs!$D$144","v":0},{"$f":"+$C57*AF56*Inputs!$D$144","v":0},{"$f":"+$C57*AG56*Inputs!$D$144","v":0},{"$f":"+$C57*AH56*Inputs!$D$144","v":0},{"$f":"+$C57*AI56*Inputs!$D$144","v":0}]
[null,"VAN riesgo Adquisición Equipos",null,"VAN ",{"$f":"+NPV($D$17,F57:AI57)","v":8.8561335614293153}]
[]
[null,{"$f":"+Inputs!$B$150","v":"Costrucción"}]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+B60","v":"Costrucción"},null,"Constantes",{"$f":"+SUM(F63:AI63)","v":107.1},{"$f":"+SUM(F25:F27,F29)","v":0},{"$f":"+SUM(G25:G27,G29)","v":53.55},53.55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Costo Riesgo Gestión de residuos de construcción",{"$f":"+Inputs!$D$150","v":0.1},"Constantes",{"$f":"+SUM(F64:AI64)","v":10.71},{"$f":"+$C64*F63","v":0},{"$f":"+$C64*G63","v":5.3550000000000004},5.3550000000000004,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"VAN riesgo gestión de residuos de construcción",null,"VAN ",{"$f":"+NPV($D$17,F64:AI64)","v":9.4366475777602741}]
[]
[null,{"$f":"+Inputs!$B$152","v":"Operación y Mantenimiento"}]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+B67","v":"Operación y Mantenimiento"},null,"Constantes",{"$f":"+SUM(F70:AI70)","v":454},{"$f":"+F36+F40","v":0},0,0,17,16.999999999999996,17,17.000000000000004,37,16.999999999999996,16.999999999999996,17.000000000000007,17.000000000000007,37,16.999999999999993,16.999999999999996,17.000000000000007,17,37.000000000000007,17.000000000000004,16.999999999999996,16.999999999999996,17.000000000000004,37,16.999999999999996,17,0,0,0,0,0]
[null,"Costo Riesgo Operación y Mantenimiento",{"$f":"+Inputs!$D$152","v":0.1},"Constantes",{"$f":"+SUM(F71:AI71)","v":45.40000000000002},{"$f":"+$C71*F70","v":0},{"$f":"+$C71*G70","v":0},0,1.7000000000000002,1.6999999999999997,1.7000000000000002,1.7000000000000004,3.7,1.6999999999999997,1.6999999999999997,1.7000000000000008,1.7000000000000008,3.7,1.6999999999999993,1.6999999999999997,1.7000000000000008,1.7000000000000002,3.7000000000000011,1.7000000000000004,1.6999999999999997,1.6999999999999997,1.7000000000000004,3.7,1.6999999999999997,1.7000000000000002,0,0,0,0,0]
[null,"VAN riesgo Operación y Mantenimiento",null,"VAN ",{"$f":"+NPV($D$17,F71:AI71)","v":22.64954060219581}]
[]
[null,"Ingresos de Terceras fuentes"]
[]
[]
[null,"Ingresos de Demanda"]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+B77","v":"Ingresos de Demanda"},null,"Constantes",{"$f":"+SUM(F80:AI80)","v":0},{"$f":"+Inputs!H95","v":0},{"$f":"+Inputs!I95","v":0},{"$f":"+Inputs!J95","v":0},{"$f":"+Inputs!K95","v":0},{"$f":"+Inputs!L95","v":0},{"$f":"+Inputs!M95","v":0},{"$f":"+Inputs!N95","v":0},{"$f":"+Inputs!O95","v":0},{"$f":"+Inputs!P95","v":0},{"$f":"+Inputs!Q95","v":0},{"$f":"+Inputs!R95","v":0},{"$f":"+Inputs!S95","v":0},{"$f":"+Inputs!T95","v":0},{"$f":"+Inputs!U95","v":0},{"$f":"+Inputs!V95","v":0},{"$f":"+Inputs!W95","v":0},{"$f":"+Inputs!X95","v":0},{"$f":"+Inputs!Y95","v":0},{"$f":"+Inputs!Z95","v":0},{"$f":"+Inputs!AA95","v":0},{"$f":"+Inputs!AB95","v":0},{"$f":"+Inputs!AC95","v":0},{"$f":"+Inputs!AD95","v":0},{"$f":"+Inputs!AE95","v":0},{"$f":"+Inputs!AF95","v":0},{"$f":"+Inputs!AG95","v":0},{"$f":"+Inputs!AH95","v":0},{"$f":"+Inputs!AI95","v":0},{"$f":"+Inputs!AJ95","v":0},{"$f":"+Inputs!AK95","v":0}]
[null,"VAN Ingresos Venta de Energía",null,"VAN ",{"$f":"+NPV($D$17,F80:AI80)","v":0}]
[]
[]
[]
[]
[null,"Ingresos de Venta de Energía"]
[null,null,null,null,"Total"]
[]
[null,{"$f":"+B86","v":"Ingresos de Venta de Energía"},null,"Constantes",{"$f":"+SUM(F89:AI89)","v":0.81797040000000021},{"$f":"+Inputs!H104","v":0},{"$f":"+Inputs!I104","v":0},{"$f":"+Inputs!J104","v":0},{"$f":"+Inputs!K104","v":1.2118079999999998E-2},{"$f":"+Inputs!L104","v":2.0196800000000001E-2},{"$f":"+Inputs!M104","v":2.6255840000000006E-2},{"$f":"+Inputs!N104","v":3.2314880000000004E-2},{"$f":"+Inputs!O104","v":4.0393599999999995E-2},{"$f":"+Inputs!P104","v":4.0393600000000002E-2},{"$f":"+Inputs!Q104","v":4.0393600000000009E-2},{"$f":"+Inputs!R104","v":4.0393600000000002E-2},{"$f":"+Inputs!S104","v":4.0393599999999995E-2},{"$f":"+Inputs!T104","v":4.0393600000000002E-2},{"$f":"+Inputs!U104","v":4.0393599999999995E-2},{"$f":"+Inputs!V104","v":4.0393600000000002E-2},{"$f":"+Inputs!W104","v":4.0393600000000002E-2},{"$f":"+Inputs!X104","v":4.0393600000000002E-2},{"$f":"+Inputs!Y104","v":4.0393599999999995E-2},{"$f":"+Inputs!Z104","v":4.0393600000000002E-2},{"$f":"+Inputs!AA104","v":4.0393600000000002E-2},{"$f":"+Inputs!AB104","v":4.0393600000000002E-2},{"$f":"+Inputs!AC104","v":4.0393600000000002E-2},{"$f":"+Inputs!AD104","v":4.0393600000000002E-2},{"$f":"+Inputs!AE104","v":4.0393600000000009E-2},{"$f":"+Inputs!AF104","v":4.0393600000000002E-2},{"$f":"+Inputs!AG104","v":0},{"$f":"+Inputs!AH104","v":0},{"$f":"+Inputs!AI104","v":0},{"$f":"+Inputs!AJ104","v":0},{"$f":"+Inputs!AK104","v":0}]
[null,"VAN Ingresos Venta de Energía",null,"VAN ",{"$f":"+NPV($D$17,F89:AI89)","v":0.39326448743999654}]
[]
[null,"Resultado CSP"]
[null,"Concepto (millones de EUR)"]
[null,"Costes de inversión",{"$f":"+E44","v":205.06814529546915}]
[null,"Costes de operación y mantenimiento",{"$f":"+E45","v":188.58790342565533}]
[null,"Costes de reposiciones",{"$f":"+E46","v":37.907502596302834}]
[null,"Coste base",{"$f":"+SUM(C94:C96)","v":431.56355131742731}]
[null,"Coste riesgos transferidos",{"$f":"+$E$58+$E$65+$E$72","v":40.942321741385399}]
[null,"Ingresos terceros",{"$f":"+-$E$90-$E$81","v":-0.39326448743999654}]
[null,"Neutralidad competitiva",{"$f":"+E119","v":45.685388849983063}]
[null,"Costes Administración de Contrato",{"$f":"+$E$124","v":12.212837590849601}]
[null,"Coste CSP",{"$f":"+C97+C98+C99+C100+C101","v":530.01083501220546}]
[]
[null,"Concesión"]
[]
[]
[null,"PPD + PPT",null,"Constantes",{"$f":"+SUM(F107:AI107)","v":910.17970400000036},{"$f":"+(Inputs!H126+Inputs!H116)","v":0},{"$f":"+(Inputs!I126+Inputs!I116)","v":0},{"$f":"+(Inputs!J126+Inputs!J116)","v":0},{"$f":"+(Inputs!K126+Inputs!K116)","v":41.121180799999998},{"$f":"+(Inputs!L126+Inputs!L116)","v":41.201968000000001},{"$f":"+(Inputs!M126+Inputs!M116)","v":41.262558400000003},{"$f":"+(Inputs!N126+Inputs!N116)","v":41.323148799999998},{"$f":"+(Inputs!O126+Inputs!O116)","v":41.403936000000002},{"$f":"+(Inputs!P126+Inputs!P116)","v":41.403936000000002},{"$f":"+(Inputs!Q126+Inputs!Q116)","v":41.403936000000002},{"$f":"+(Inputs!R126+Inputs!R116)","v":41.403936000000002},{"$f":"+(Inputs!S126+Inputs!S116)","v":41.403936000000002},{"$f":"+(Inputs!T126+Inputs!T116)","v":41.403936000000002},{"$f":"+(Inputs!U126+Inputs!U116)","v":41.403936000000002},{"$f":"+(Inputs!V126+Inputs!V116)","v":41.403936000000002},{"$f":"+(Inputs!W126+Inputs!W116)","v":41.403936000000002},{"$f":"+(Inputs!X126+Inputs!X116)","v":41.403936000000002},{"$f":"+(Inputs!Y126+Inputs!Y116)","v":41.403936000000002},{"$f":"+(Inputs!Z126+Inputs!Z116)","v":41.403936000000002},{"$f":"+(Inputs!AA126+Inputs!AA116)","v":41.403936000000002},{"$f":"+(Inputs!AB126+Inputs!AB116)","v":41.403936000000002},{"$f":"+(Inputs!AC126+Inputs!AC116)","v":41.403936000000002},{"$f":"+(Inputs!AD126+Inputs!AD116)","v":41.403936000000002},{"$f":"+(Inputs!AE126+Inputs!AE116)","v":41.403935999999995},{"$f":"+(Inputs!AF126+Inputs!AF116)","v":41.403936000000009},{"$f":"+(Inputs!AG126+Inputs!AG116)","v":0},{"$f":"+(Inputs!AH126+Inputs!AH116)","v":0},{"$f":"+(Inputs!AI126+Inputs!AI116)","v":0},{"$f":"+(Inputs!AJ126+Inputs!AJ116)","v":0},{"$f":"+(Inputs!AK126+Inputs!AK116)","v":0}]
[null,"Impuestos",null,"Constantes",{"$f":"+SUM(F108:AI108)","v":75.461178999346117},{"$f":"+Inputs!H137","v":0.6500784694444639},{"$f":"+Inputs!I137","v":2.430163568763803},{"$f":"+Inputs!J137","v":4.3779175710734179},{"$f":"+Inputs!K137","v":5.0989102746670234},{"$f":"+Inputs!L137","v":4.9134375621368429},{"$f":"+Inputs!M137","v":4.7141744735254676},{"$f":"+Inputs!N137","v":4.5004555234408166},{"$f":"+Inputs!O137","v":4.4877878516150078},{"$f":"+Inputs!P137","v":4.4690992672313268},{"$f":"+Inputs!Q137","v":4.2367450707841376},{"$f":"+Inputs!R137","v":3.9892019421894576},{"$f":"+Inputs!S137","v":3.7254769849844354},{"$f":"+Inputs!T137","v":3.6612052204761425},{"$f":"+Inputs!U137","v":3.5884831488964744},{"$f":"+Inputs!V137","v":3.2985633105375176},{"$f":"+Inputs!W137","v":2.9896914892990676},{"$f":"+Inputs!X137","v":2.660628799090754},{"$f":"+Inputs!Y137","v":2.5267481913154781},{"$f":"+Inputs!Z137","v":2.3798669648608848},{"$f":"+Inputs!AA137","v":2.0109402073570499},{"$f":"+Inputs!AB137","v":1.6178968056401914},{"$f":"+Inputs!AC137","v":1.1991602610794361},{"$f":"+Inputs!AD137","v":0.96974384289501792},{"$f":"+Inputs!AE137","v":0.72108165546310687},{"$f":"+Inputs!AF137","v":0.24372054257880094},{"$f":"+Inputs!AG114","v":0},{"$f":"+Inputs!AH114","v":0},{"$f":"+Inputs!AI114","v":0},{"$f":"+Inputs!AJ114","v":0},{"$f":"+Inputs!AK114","v":0}]
[null,"Costes Administración de Contrato",{"$f":"950000/1000000","v":0.95},"Constantes",{"$f":"+SUM(F109:AI109)","v":22.79999999999999},{"$f":"+$C109*SUM(F10:F11)","v":0},0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0,0,0,0,0]
[]
[null,"Aportes públicos"]
[]
[null,"PPD + PPT",null,"Constantes",{"$f":"+SUM(F113:AI113)","v":910.17970400000036},{"$f":"+F107","v":0},0,0,41.121180799999998,41.201968000000001,41.262558400000003,41.323148799999998,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403936000000002,41.403935999999995,41.403936000000009,0,0,0,0,0]
[null,"VAN PPD + PPT",null,"VAN",{"$f":"+NPV($D$17,F113:AI113)","v":458.76229431274515}]
[]
[null,"Ahorro fiscal"]
[]
[null,"Impuestos",null,"Constantes",{"$f":"+SUM(F118:AI118)","v":75.461178999346117},{"$f":"+F108","v":0.6500784694444639},2.430163568763803,4.3779175710734179,5.0989102746670234,4.9134375621368429,4.7141744735254676,4.5004555234408166,4.4877878516150078,4.4690992672313268,4.2367450707841376,3.9892019421894576,3.7254769849844354,3.6612052204761425,3.5884831488964744,3.2985633105375176,2.9896914892990676,2.660628799090754,2.5267481913154781,2.3798669648608848,2.0109402073570499,1.6178968056401914,1.1991602610794361,0.96974384289501792,0.72108165546310687,0.24372054257880094,0,0,0,0,0]
[null,"VAN ahorro fiscal",null,"VAN",{"$f":"+NPV($D$17,F118:AI118)","v":45.685388849983063}]
[]
[null,"Administración del contrato"]
[]
[null,"Costes de administración",null,"Constantes",{"$f":"+SUM(F123:AI123)","v":22.79999999999999},{"$f":"+F109","v":0},0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0,0,0,0,0]
[null,"VAN costes de administración",null,"VAN",{"$f":"+NPV($D$17,F123:AI123)","v":12.212837590849601}]
[]
[null,"Resultado Concesión"]
[null,"Concepto (millones de EUR)"]
[null,"Aportes públicos",{"$f":"+E114","v":458.76229431274515}]
[null,"Coste aportes públicos",{"$f":"+SUM(C128:C128)","v":458.76229431274515}]
[null,"Coste de administración",{"$f":"+E124","v":12.212837590849601}]
[null,"Coste de administración",{"$f":"+SUM(C130)","v":12.212837590849601}]
[null,"Coste ajustado concesión",{"$f":"+C131+C129","v":470.97513190359473}]
[]
[]
[null,"Resultado Análisis para el Criterio 2. Potencial de transferencia del riesgo y nivel de coste - efectividad general esperado para proyectos de mayor tamaño."]
[null,"Concepto (millones de EUR)"]
[null,"CSP",{"$f":"+C102","v":530.01083501220546}]
[null,"Concesión",{"$f":"+C132","v":470.97513190359473}]
[null,"VpD cuantitativo",{"$f":"+C137-C138","v":59.035703108610733}]
[null,"VPD/CSP",{"$f":"+C139/C137","v":0.11138584196538401}]
[]
[]
[null,"Resumen General"]
[]
[null,"Cálculo CSP "]
[null,{"$f":"+B97","v":"Coste base"},{"$f":"+C97","v":431.56355131742731}]
[null,"Costes de administración",{"$f":"+C130","v":12.212837590849601}]
[null,"Coste riesgos transferidos",{"$f":"+C98","v":40.942321741385399}]
[null,{"$f":"+B99","v":"Ingresos terceros"},{"$f":"+C99","v":-0.39326448743999654}]
[null,"Neutralidad competitiva ",{"$f":"+C100","v":45.685388849983063}]
[null,"Coste ajustado CSP",{"$f":"+SUM(C146:C150)","v":530.01083501220535}]
[]
[null,"Cálculo Concesión"]
[null,{"$f":"+B129","v":"Coste aportes públicos"},{"$f":"+C129","v":458.76229431274515}]
[null,{"$f":"+B131","v":"Coste de administración"},{"$f":"+C131","v":12.212837590849601}]
[null,{"$f":"+B132","v":"Coste ajustado concesión"},{"$f":"+SUM(C154:C155)","v":470.97513190359473}]
[]
[null,"Valor por Dinero"]
[null,"VpD",{"$f":"+C151-C156","v":59.035703108610619}]
[null,"VPD/CSP",{"$f":"+C140","v":0.11138584196538401}]
[]
[]
[null,"Nota: En el caso de proyectos con un importe  de inversión igual o superior a 100 milloned de euros, el análisis del potencial de transferencia del riesgo se basará en el resultado del ejercicio del Comparador Público - Privado (CPP):\n\nLa evaluación del Criterio 2. Potencial de transferencia eficiente del riesgo y nivel de coste-efectividad general esperado se dará la siguiente puntuación:\n\n1 - (No cumple) -  VpD negativo en más de un -10%\n2 - (Medio) - VpD entre 0% y - 10%\n3 - (Alto) - VpD mayor a 0%\n\nEl resultado se añadirá al análisis Multicriterio (MCA)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sensibilidades"]
[]
[null,"Sensibilidades"]
[null,"Sensibilidad CAPEX ",-0.1,0,0.1]
[null,"VpD",2.225767685528144E-2,5.5433340484724175E-2,8.6320554906114053E-2]
[null,"Sensiiblidad TIR ",-0.1,0,0.1]
[null,"VpD",8.7854201022216846E-2,5.5433340484724175E-2,8.1738782014668717E-3]
[]
[null,"Nota: De acuerdo con las recomendaciones de la guía, para el análisis de sensibilidad se deberá aplicar una variación del +10% y -10% sobre el Capex del proyecto. Estas sensibilidades deberán calcularse incorporando directamente los inputs correspondientes en el modelo financiero, y los resultados obtenidos delVpD deberán registrarse en la tabla facilitada."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Concepto","Total","VAN"]
[null,"Costes de inversión (CAPEX)",{"$f":"+$E$31","v":227.10000000000002},{"$f":"+$E44","v":205.06814529546915}]
[null,"Costes de operación y mantenimiento (OPEX)",{"$f":"+E36","v":374},{"$f":"+$E45","v":188.58790342565533}]
[null,"Costes Mantenimiento Mayor (Mantenimiento Periódico)",{"$f":"+E40","v":80},{"$f":"+$E46","v":37.907502596302834}]
[null,"Total",{"$f":"+SUM(C223:C225)","v":681.1},{"$f":"+SUM(D223:D225)","v":431.56355131742731}]