~~ Fira de Barcelona RESUM PROJECT FINANCE ... APORTACIONS Anya 2011-2018 APOrtaclon. obJoc1o de _ni _Any 2021 Any2028 - Generalltat aporta 58.443.414,42 € - Aportacions d'Adminlstraclans de 162 MM€ - Aportacions d'Administracions de 75MME .. Ajuntament de Ben aporta 31.463.474,51 €. - Ajuntament de ¡'Hospitalet aporta 10.029.654,88 E - Mancomunltat de Munlclpis aporta 11.071.806,22 E (.) - Olputació de Barcelona aporta 10.031.457,91 E ... SUBVENCIONS ICobrament Import de subvencló FEDER pendent per Import de 11,1 mlllons d'euros abans del 2.013 ... ENDEUTAMENT ... DESGLOS DE LES APDRTACIONS PER ACCIONISTA l 162.000.000 __ 75.000.000 (') l 'aportacJó COITesponent el'eny 2.011 és la penden/del ConvenI2.006 VAN de les aportaclons 241.734.322 € Taxa de descomple 4,70% 05/08/2010 11 :4 6 PF2016 Partlclpacl6 de capital Any Partlclpacl6 de capital any Capital Desemborsat a 31/07/10 2011 20~8 Percentatge Besemborsat Percentatge Capital P.ercentatge lCapltal1 GENERALlTAT 32,19% 84.998.440 31.82% 84.998.440 37,25% 143.441 .855 ICF HOLDING 19.71 % 52.040.855 19.48% 52.040.855 13.51% 52.040.855 SUBTOTAL MON LOCAL 35.22% 92.994.277 35.95% 96.034.186 40,40% 155.590.671 AJ DE BARCELONA 17.81% 47.018.815 18,35% 49.018.376 20,38% 78.482.290 AJ O'HOSPITALET 5.94% 15.673.139 5,87% 15.673.139 6,67% 25.702.794 MANCOMUNITAT 5.54% 14.630.987 5,87% 15.671.336 6,67% 25.702.794 DIPUTACIÓ 5.93% 15.671.336 5,87% 15.671.336 6,67% 25.702.794 CAMBRA DE COMER/; 12,89% 34.040.605 12,74% 34.040.605 8,84% 34.040.605 TOTAL 100.00% 264.074.178 100,OD% 267.114.086 100.00% 385.113.986 PARTIDES FASE '" PENDENT EXECUCIÓ PRESSUPOST 2010 2011 2012 2013 2014 URBANITZACIÓ AMADEU TORNER TOTAL (€) 19.000.000,00 ( CONNEXIÓ L9 TOTAL (el 7.700.000,00 ( PAVELLONS 5-7 TOTAL (€l 102.750.000,00 ( 52.200,000,00 € 22-014,589,10 € EDIFICI AUDITORI TOTAL (€l 71 .000.000,00 ( 24.985.410.90 € 35.479.733,90 € MAMPARES PAVELLÓ 8 TOTAL (€) 5.500.000,00 ( SENYALITZACIO TOTAL (el 2.637.000,00 ( 1.000.000,00 € 1.637.000,00 € URBANITZACIÓ PAVELLÓ 1 TOTAL (C) 16.942.000,00 ( 10.000.000,00 € PONT I URBANITZACIÓ CARRER URANI TOTAL (el 10.227.000,00 ( URBANITZACIÓ FAt;ANES C.FOC DAVANT PAVELLONS 2-3 TOTAL (€) 19.178.000,00 ( (1 ) 3.300.000,00 € 10.000.000,00 € 11 .966.126,10 € TRASLLAT HABITATGES EXISTENTS TOTAL (€) 32.000.000,00 ( ADQUISICIO DE SOL PER AMPLlACIO PAVELLONS TOTAL (el 19.000.000,00 ( 10.000.000,00 € JUSTIPREU TOTAL (el 10.000.000,00 ( 5.000,000,00 € RECONVERSIÓ ACCESOS APARC.I PAVELLONS 2-3 EN RECINTE FIRAL TOTAL (el 7.095.000,00 ( 4.500.000,00 € 2-500,000,00 € PARKINGS TOTAL (€l 44.511 .381 ,30 ( TOTAL (El 367.540.381,30 E 70.000.000,00 € 58.000,000,00 € 61 _582,660,00 € 0,00 € 5.000,000,00 € (1) Donat que el detall de les partidas pressupostaries inicialment previstas no s'ajusten exactamenl a les inversions pendents de realitzar, s'ha utilitzat aquesta partida par imputar les inversions sansa cabuda en altres partidas. 31/07/201013:59 PF2016 Pressupos! anualilza! CALENDARI D'EXECUCIO DE LES OBRES [ ] F.ASE 2 20101; 20;1,1 20:12 2013 --,2014 2015 20,16 irOTAl!. Construcci6 Fase 2 257.163.420 Retenció de garantfa -27.366.342 Devoluci6 de garantla 27.366.342 Total desp de hon+gestió 35.262.368 SUBTOTAL , 308.925.788 O IVA construcci6 46.788.126 I.0TlIL OBRAFASE ~ _~ ___________ ~ __3 55.7_13.9:t4; - - - I 2010 2011 ,2013!. 201SL 20~6:JTOTA!. Terrenys Fase 2 121.7'99.821 filA terrenys 19.487.971 O TOTAL 141 .287.793 !9TALOBR~TERR.ENySF_ASE2 _ ____ ____ __ _ _ ______ ~ __~ ~~~~~_414.225.6101 I e, ;¡ Fase 3 61.582860 O ?6r Retenci6 de gamnUa O O O O , gamnUa 2.009.140 ñ 000 000 5 ROO oor 6.151 ?Rñ -2~~ O O O Terrenys Fase 3 10.000.000 5.000.000 66.012.121 TOTAL OBRA t TERRENYS 66.009.140 58.200.000 61.224.574 6.158.286 5.000.000 O Ol TotatrvA 11 .221.554 11 ~ooooo O O 59.198.21C .TQ]ALOBRAtTERRENYSFASE3 ._ 77.230.694 68.676.000 72.244.997 7.266.778 5.900.000 . _ O ___ O ____ 408.738.591 , Inversió anterior (P1 I P2) 144.000.000 TOTAL: INVERSI 924.265.991 0510812010 11:48 PF2016 C.RESULTATS TOTAL INGRESSOS 17.106.333 18.535.236 22.254.099 21.904.709 22.436.574 22.983.975 28.545.247 29.272.901 30.021 .917 30.792.928 31.586.583 l~ressc5 Ctmons FIBA 14.233.672 14.660.682 15.100.502 15.553.517 16.020.123 16.500.726 21.995.748 22.655.621 23.335.289 24.035.348 24.756.409 Altres I~ressos jsubvencló eartldeaHu) O 490.500 3.297.250 3.556.088 3.556.088 3.556.088 3.556.088 3.556.068 3.556.088 3.556.088 3.556.088 I~ressos Planle d'enl!!]la rotovollBlca 1.940.131 1.991.965 2.149.147 2.199.663 2.251.369 2.304.294 2.357.495 2.411.935 2.467.645 2.524.653 2.582.991 Ingressos Planle d'energla rotovoltalca O O 435.848 444.699 453.730 462.944 471.196 479.595 488.144 496.845 505.702 IngresS05 San Psu 375.000 750.000 1.125.000 O O O O O O O O Ingressos Heallng and Cooling 7.530 90.589 93.307 96.106 98.989 101.959 105.017 108.168 111.413 114.755 118.198 Ingresos INCASOL 500.000 500.000 O O O O O O O O O Altres Ingressos (1loguers I rerscturaclons) 50.000 51.500 53.045 54. .6 36 56.275 57.964 59.703 61.494 63.339 65.239 67.196 TOTAL OESPESES 34.496.203 41.045.944 47.344.107 48.000.738 46.460.147 45.314.515 44.736.353 47.430.038 48.319.225 48.083.700 49.034.472 Amortllzaclons 11.395.645 13.833.156 15.517.470 15.517.470 15.023.094 15.023.094 15.023.094 14.614.676 14.197.094 13.054.939 13.054.939 Amortllzació Planta d'energla solar 678.573 764.208 649.644 849.844 849.844 849.844 849.844 849.844 849.844 849.844 849.844 Amoftjlzatló aclfos 71.000 71.000 71.000 71.000 71.000 71.000 71.000 71.000 71.000 71.000 71.000 Manl PmvenHu PI8l11a Energla solar 84.261 82.203 85.690 89.262 90.921 92.610 94.328 96.077 97.856 99.667 101.510 AssegUf8f'olt8 PI8l11a Energla solar 11 .734 15.712 16.183 16.668 17.168 17.683 18.214 16.760 19.323 19.903 20.500 DesEeses Flnancares 19.326.688 23.255.378 27.680.978 28.232.156 27.026.069 25.771.586 25.079.510 28.064.556 29.251.040 30.034.070 30.857.839 Canon Al Hose. 478 .378 492.730 507.512 522.737 538.419 554.572 571.209 588.345 605.995 624.175 642.901 Deseeses estnM;tum 203.434 208.520 213.733 219.076 224.553 230.167 235.921 241.819 247.864 254.061 260.412 O O O O o O O O o o o 'B' 2.674.708 2.754.949 2.837.598 2.922.726 3.061.906 3.153.765 3.248.376 3.345.829 3.446.204 3.549.590 3.656.078 Cessio drets utililzacló cobertes (amort. Drel 956.246 938.762 920.578 901.666 881.998 861.543 840.270 818.147 795.138 771.209 746.323 Pagamenllloguer sos\ro H&C 50.000 51.000 52.020 53.060 54.122 55.204 56.308 57.434 58.563 59.755 60.950 Imputació subvencló Inmobllllzal (FEDER) -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1.860.849 A'"", 426.385 439.176 452.352 465.922 479.900 494.297 509.126 524.400 540.132 556.335 573.026 Plosv¡'¡lues eer la venda de lefreI1'r'S BAT -17.389.870 -22.510.709 -25.090.007 -26.096.029 -24.023.573 -22.330.540 -16.191.106 -18.157.138 -18.297.308 -17.290.772 -17.447.889 BATAc -49.099.887 -71.610.596 -96.700.603 -122.796.633 -146.820.206 -169.150.746 -185.341.852 -203.498.990 -221.796.297 -239.087.070 -256.534.959 Imposl de sodalals 558.255 558.255 230.289 -597,211 -1.777.650 -2.292.586 -3.657.272 -5.041.574 -6.236.822 -7.369.875 -.9.503.770 BOT -17.948.125 -23.068.963 -25.320.297 -25.498.818 -22.245.924 -20.037.954 -12.533.834 -13.115.564 -12.060.486 ·9.920.897 ·8.944.119 BDr Acumula! -47.077.321 -70.146.284 -95.466.581 -120.965.399 -143.211.323 -163.249.276 -175.783.110 -188.898.674 -200.959.160 -210.880.057 -219.824.176 11 2012 2013 201 2015 2011 2017 2011 2011 2020 Cae"al SocIal 120.750.001 131.959.163 143.999.072 200.504.283 216.854.099 242.829.150 278.833.856 314.843.971 314.843.971 305.297.600 290.416.454 Ame"aclons de caellal per Inverslons I Fons 11.209.162 3.039.909 5.005.211 15.004.816 25.975.051 36.004.706 36.010.115 O O O O Préslec PartldeaUu o 9.000.000 51.500.000 1.345.000 O O O O O O O Reducdó da capital per dlssoludó O O O O O O O O -9.546.171 -14.881.346 -13.416.179 Fans Propls 131.959.163 143.999.072 200.504.283 216.854.099 242.829.150 278.833.856 314.843.971 314.843.971 305.297.800 290.416.454 2n.000.275 Resultal ex anl8f\ors ·30.924.865 -48.872.990 -71.941.954 -97.262.250 -122.761.068 -145.006.992 -165.044.946 -177.578.779 -190.694.343 -193.208.658 -188.248.209 Reduccló de etmjucs per dl5S0lució O O O O O O O O 9.546.171 14.881.346 13.416.179 Resullal exen;!d -17.948.125 -23.068.963 -25.320.297 -25.498.818 -22.245.924 -20.037.954 -12.533.834 -13.115.564 -12.060.486 -9.920.897 -.9.944.119 Resullab 8CUITlulats -48.672.990 -71.941.954 -97.262.250 -122.761.068 -145.006.992 -165.044.946 -177.578.779 -190.694.343 -193.208.658 -188.248.209 -183.776.150 Aportaclons dlnerm1es Acumulal O 3.039.909 8.045.120 23.049.936 49.024.987 85.029.693 121.039.808 121.039.808 121.039.808 121.039.808 121.039.808 Total Fans propls 83.086.173 75.097.D27 111.287.152 117.142.966 146.847.145 198.818.603 258.304.999 245.189.436 233.126.950 223.208.053 214.263.933 Saldo Vlu Crédlts 456.230.884 514.330.884 530.638.409 521.858.648 513.428.886 489.024.124 471.887.655 461.623.647 466.484.638 471.345.630 476.706.621 05108/2010 11 :48 PF2016 C.RESULTATS TOTAL INGRESSOS 32.403.549 38.244.517 39.260.194 40.305.811 41 .382.255 42.490.439 43.631 .302 44.805.814 46.014.969 47.259.796 48.363.102 40.792.526 l!!Ira~ Plante lfeoc!SllIlolDYo!tnk;a 2.642.689 2.703.781 2.766.297 2.830.272 2.895.740 2.962.736 3.031.296 3.101.458 3.173.257 3.246.733 3.321.926 lrogra~ Plllnto Ifencrgtll Job:Wolta1c:a 514.716 523.890 533.229 542.734 552.408 562.255 572.277 582.478 592.860 603.428 614.164 lrogressos San Pau O O O O O O O O O O O tngressos HeaUng and Coot tng 121.744 125.396 129.158 133.033 137.024 141 .135 145.369 149.730 154.222 158.848 163.61 4 tng1tl501INCASOL O O O O O O O O O O O Atlnls Ingraso. (lIogue~ I rofllCtumeionsJ 69.212 71 .288 73.427 75.629 77.898 80.235 82.642 85.122 87.675 90.306 93.015 TOTAL DESPESES 39.396.335 37.151.299 35.408.641 32.519.463 31.879.451 28.438.683 24.965.206 22.155.558 20.351.230 18.913.896 17.320.232 Amortllz.Bcians 13.054.939 12.765.829 11.581.979 9.047.802 9.025,340 9.025.340 8.254.075 6.682.409 6.171.085 6.155.064 6.149.932 Amortllz.Bcló Planta d'cncrgta solar 849.844 849.844 849.844 799.377 799.377 799.377 417.044 417.044 417.044 417.044 417.044 AmortllzlM;lO IICtius 71.000 71.000 71.000 71.000 71.000 71 .000 71.000 71.000 71 .000 O O ManL Proventlu ptanta Ener¡¡tllsotar 103.385 105.293 107.235 109.210 111 .220 113.264 115.344 117.461 '19.613 121 .803 124.031 Aueguran.;a Ptonta Eoor¡¡ta sotar 21.115 21 .748 22.401 23.073 23.765 24.478 25.212 25.969 26.748 27.550 28.377 I Pogamen\ lIoguer soslm H&C Imputacl6.ubvendó Irunobll lz.Bl (FEDER) -1 .860.849 -1.860.849 -1 .860.849 -1.860.649 -1.860.849 -1.860.849 -1.860.849 -1.860.849 -1 .860.849 -1 .860.849 -1.860.849 A.." 590.216 607.923 626.160 644.945 664.294 684.222 704.749 725.892 747.668 170.098 193.201 Ptusv¡)fucs per ta venda de terrenys BAT -6.992.786 1.093.218 3.851.553 7.786.348 9.502.804 14.051 .756 18.666.096 22.650_256 25.663.739 28.345.900 '. 31 ,04.2~870 BATAc -263.527.745 ·262,434.527 -258.582.973 -250.796.625 -241.293.822 -227.242.066 -208.575.970 -185.925.714 -160.261.975 -131.916,075 -100.873.205 tmposl de socIctats -9.312.861 -9.580.139 -9.004.803 -7.950.327 -7.580.627 -6.364.501 -5.1 11 .791 -3.237.848 -2.507.641 -1 .833.788 -1.112.641 BDT 2.320.075 10.673.357 12.856.356 15.736.675 17.083.431 20.416.257 23.777.887 25.888.104 28.171.380 30.179.689 32.155.511 -217.504.101 ·206.B30.744 ·193.974.388 -178.237.712 -161.154,282 -140.738.024 -116.960.138 ·91.072.034 ·62.900.654 -32.720.965 -565.454 2021 2027 Saldo Vlu Crédlts 332.067.613 303.928.605 281 .989.596 266.350.588 248.911.579 191.372.571 163.233.563 135.094.554 106.955.546 78.816.537 50.677.529 05/08/2010 11 :49 PF2016 C.RESULTATS TOTAL INGRESSOS 48.940.664 48.672.629 48.406.643 48.142.755 47.881 .015 47.621.473 Ingressos Cénoll5 FIBA 42.016.301 42.016.302 42.016.303 42.016.304 42.016.305 42.016.306 AItre5I~rcsS09 {subvencló eertlcleatiul 3.021.338 2.664.838 2.308.338 1.951.838 1.595.338 1.238.838 Ingrcssos Planta