MM 29 /2021 allegati.pdf

text: \nAllegato 1 \n\nTabelle Piano finanziario ed economico AIM 2020-2027 \n\n\n\nParametri\n\nAnno 2020 2021 2022 2023 2024 2025 2026 2027\nInflazione e crescita massa salariale 0.50% 0.50% 0.75% 1.00% 1.25%\nInflazione 0.00% 0.00% 0.25% 0.50% 0.75%\nTasso interessi debiti a corto termine 2.50% 2.25% 2.30% 2.40% 2.50%\nTasso interessi nuovi debiti a medio‐lungo termine 1.00% 1.00% 1.20% 1.20% 1.25% 1.30% 1.40% 1.50%\nWACC 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83%\nPrezzo acqua al m3 fr. 1.20 fr. 1.20 fr. 1.30 fr. 1.40 fr. 1.50 fr. 1.60 fr. 1.60 fr. 1.60\nAttivazione prestazioni proprie in % degli investimenti (CQ) 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00%\n\nDati preventivo\n\nCittà di Mendrisio Allegato MM N. 29 /2021 1 di 19\n\n\n\nConto economico AIM\n\nAIM 2020 AIM 2021 AIM 2022 AIM 2023 AIM 2024 AIM 2025 AIM 2026 AIM 2027\n3 SPESE CORRENTI 43'726'000           45'078'300           47'182'200           47'701'600            48'710'400           49'423'400           50'053'700           50'834'500          \n30 Spese per il personale 5'640'600             5'446'400             5'670'700             5'851'200              5'842'300             5'886'100             5'924'900             5'972'700              \n31 Spese per beni e servizi e altre spese d'esercizio 24'798'300           26'163'700.00      28'077'700           27'856'700            27'856'700           27'922'600           27'928'200           27'964'100          \n33 Ammortamenti beni amministrativi 1'858'400             2'055'800             2'284'200             2'593'000              3'302'000             3'678'200             3'945'500             4'336'900              \n34 Spese finanziarie 147'700                178'000                224'600                432'300                 691'600                831'800                997'800                1'184'100              \n35 Versamenti a fondi e a finanziamenti speciali 521'800                108'600                86'500                    61'000                   43'000                  30'300                  21'400                  15'100                   \n36 Spese di trasferimento 458'500                503'400                518'700                572'600                 640'000                713'600                823'400                871'000                 \n37 Riversamento contributi 8'828'700             9'108'100             8'840'300            8'840'300             8'840'300            8'862'500            8'906'800            8'973'600             \n38 Spese straordinarie 60'200                  ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n39 Addebiti interni 1'411'800             1'514'300             1'479'500            1'494'500             1'494'500            1'498'300            1'505'700            1'517'000             \n\n4 RICAVI CORRENTI 45'562'400           47'147'500           48'392'200           48'682'700            49'171'500           49'536'200           49'735'500           49'888'900          \n42 Tasse e retribuzioni 30'229'600           30'804'900           33'826'100           34'013'200            34'408'900           34'886'200           35'248'600           35'688'800          \n43 Ricavi diversi 3'746'500             4'540'500             3'248'700            3'531'400             3'774'800            3'746'300            3'608'700            3'297'700             \n44 Ricavi finanziari 6'000                     6'400                     3'600                       ‐                          ‐                         ‐                         ‐                         ‐                          \n45 Prelievi da fondi e finanziamenti speciali 848'800                945'400                752'700                530'700                 374'100                263'700                185'900                131'100                 \n46 Ricavi da trasferimento 229'600                227'900                241'300                272'600                 278'900                279'200                279'800                280'700                 \n47 Contributi da riversare 8'828'700             9'108'100             8'840'300             8'840'300              8'840'300             8'862'500             8'906'800             8'973'600              \n48 Ricavi straordinari 261'400                ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n49 Accrediti interni 1'411'800             1'514'300             1'479'500            1'494'500             1'494'500            1'498'300            1'505'700            1'517'000             \n90 Chiusura del conto economico (‐ avanzo; + disavanzo) ‐1'836'400.00      ‐2'069'200.00      ‐1'210'000.00      ‐981'100.00           ‐461'100.00          ‐112'800.00          318'200.00           945'600.00          \n\nCittà di Mendrisio Allegato MM N. 29 /2021 2 di 19\n\n\n\nConto economico EL\n\nEL 2020 EL 2021 EL 2022 EL 2023 EL 2024 EL 2025 EL 2026 EL 2027\n3 SPESE CORRENTI 32'689'600           33'772'300           35'856'200           35'715'600            35'980'600           36'416'500           36'858'800           37'432'500          \n30 Spese per il personale 4'251'000             4'354'100             4'526'200             4'646'000              4'631'100             4'665'800             4'712'500             4'745'200              \n31 Spese per beni e servizi e altre spese d'esercizio 19'001'400           20'108'600           22'160'600           21'656'600            21'106'600           21'157'000           21'158'100           21'209'600          \n33 Ammortamenti beni amministrativi 1'101'700             1'242'900             1'361'900             1'537'900              2'184'500             2'461'400             2'723'800             3'034'100              \n34 Spese finanziarie 59'100                  56'000                  94'700                    172'800                 374'100                442'300                546'600                676'700                 \n35 Versamenti a fondi e a finanziamenti speciali 521'800                108'600                86'500                    61'000                   43'000                  30'300                  21'400                  15'100                   \n36 Spese di trasferimento 305'400                315'000                315'000                315'000                 315'000                315'000                315'000                315'000                 \n37 Riversamento contributi 7'172'000             7'408'100             7'140'300            7'140'300             7'140'300            7'158'200            7'194'000            7'248'000             \n38 Spese straordinarie 57'700                  ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n39 Addebiti interni 219'500                179'000                171'000                186'000                 186'000                186'500                187'400                188'800                 \n\n4 RICAVI CORRENTI 34'080'800           35'025'700           36'296'200           36'259'700            36'351'000           36'611'000           36'864'000           36'966'400          \n42 Tasse e retribuzioni 21'451'800           22'261'000           25'297'000           25'297'000            25'502'700           25'776'300           26'119'700           26'535'500          \n43 Ricavi diversi 3'174'300             3'172'500             1'860'200            2'049'200             2'091'400            2'167'600            2'113'800            1'793'000             \n44 Ricavi finanziari 5'200                     5'200                     3'500                       ‐                          ‐                         ‐                         ‐                         ‐                          \n45 Prelievi da fondi e finanziamenti speciali 848'800                945'400                752'700                530'700                 374'100                263'700                185'900                131'100                 \n46 Ricavi da trasferimento 162'500                162'500                162'500                162'500                 162'500                162'500                162'500                162'500                 \n47 Contributi da riversare 7'172'000             7'408'100             7'140'300             7'140'300             7'140'300            7'158'200            7'194'000            7'248'000             \n48 Ricavi straordinari 260'500                ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n49 Accrediti interni 1'005'700             1'071'000             1'080'000            1'080'000             1'080'000            1'082'700            1'088'100            1'096'300             \n90 Chiusura del conto economico (‐ avanzo; + disavanzo) ‐1'391'200.00      ‐1'253'400.00      ‐440'000.00          ‐544'100.00           ‐370'400.00          ‐194'500.00          ‐5'200.00              466'100.00          \n\nCittà di Mendrisio Allegato MM N. 29 /2021 3 di 19\n\n\n\nConto economico AP\n\nAP 2020 AP 2021 AP 2022 AP 2023 AP 2024 AP 2025 AP 2026 AP 2027\n3 SPESE CORRENTI 3'818'300             4'557'400             4'907'900             5'338'400              5'532'200             5'787'700             5'945'400             6'098'900              \n30 Spese per il personale 838'800                932'700.00           987'100                1'047'000              1'052'200             1'060'100             1'050'600             1'063'700              \n31 Spese per beni e servizi e altre spese d'esercizio 1'222'000             1'660'100.00        1'838'400             1'888'400              1'888'400             1'893'100             1'888'100             1'852'300              \n33 Ammortamenti beni amministrativi 606'000                649'900                762'300                899'400                 962'600                1'060'300             1'059'100             1'127'100              \n34 Spese finanziarie 88'600                  122'000                129'900                259'500                 317'500                386'600                445'300                498'400                 \n35 Versamenti a fondi e a finanziamenti speciali ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n36 Spese di trasferimento 153'100                188'400                203'700                257'600                 325'000                398'600                508'400                556'000                 \n37 Riversamento contributi ‐                         ‐                         ‐                          ‐                         ‐                        ‐                        ‐                        ‐                         \n38 Spese straordinarie ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n39 Addebiti interni 909'800                1'004'300             986'500                986'500                 986'500                989'000                993'900                1'001'400             \n\n4 RICAVI CORRENTI 3'874'800             4'651'900             4'847'900             5'177'300              5'558'200             5'644'500             5'562'800             5'575'800              \n42 Tasse e retribuzioni 3'027'500             3'080'900             3'189'600             3'379'600              3'569'600             3'759'800             3'760'300             3'761'100              \n43 Ricavi diversi 510'100                1'245'000             1'337'500            1'430'600             1'615'200            1'510'400            1'426'300            1'435'700             \n44 Ricavi finanziari 400                        600                        ‐                          ‐                         ‐                         ‐                         ‐                          \n45 Prelievi da fondi e finanziamenti speciali ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n46 Ricavi da trasferimento 67'100                  65'400                  78'800                    110'100                 116'400                116'700                117'300                118'200                 \n47 Contributi da riversare ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n48 Ricavi straordinari 900                        ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n49 Accrediti interni 268'800                260'000                242'000                257'000                 257'000                257'600                258'900                260'800                 \n90 Chiusura del conto economico (‐ avanzo; + disavanzo) ‐56'500.00            ‐94'500.00            60'000.00             161'100.00            ‐26'000.00            143'200.00           382'600.00           523'100.00          \n\nCittà di Mendrisio Allegato MM N. 29 /2021 4 di 19\n\n\n\nConto economico Gas\n\nGAS 2020 GAS 2021 GAS 2022 GAS 2023 GAS 2024 GAS 2025 GAS 2026 GAS 2027\n3 SPESE CORRENTI 7'218'100             6'748'600             6'418'100             6'647'600              7'197'600             7'219'200             7'249'500             7'303'100              \n30 Spese per il personale 550'800                159'600                157'400                158'200                 159'000                160'200                161'800                163'800                 \n31 Spese per beni e servizi e altre spese d'esercizio 4'574'900             4'395'000             4'078'700             4'311'700              4'861'700             4'872'500             4'882'000             4'902'200              \n33 Ammortamenti beni amministrativi 150'700                163'000                160'000                155'700                 154'900                156'500                162'600                175'700                 \n34 Spese finanziarie ‐                         ‐                         ‐                           ‐                          ‐                         2'900                     5'900                     9'000                      \n35 Versamenti a fondi e a finanziamenti speciali ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n36 Spese di trasferimento ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n37 Riversamento contributi 1'656'700             1'700'000             1'700'000            1'700'000             1'700'000            1'704'300            1'712'800            1'725'600             \n38 Spese straordinarie 2'500                     ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n39 Addebiti interni 282'500                331'000                322'000                322'000                 322'000                322'800                324'400                326'800                 \n\n4 RICAVI CORRENTI 7'606'800             7'469'900             7'248'100             7'245'700              7'262'300             7'280'700             7'308'700             7'346'700              \n42 Tasse e retribuzioni 5'750'300             5'463'000             5'339'500             5'336'600              5'336'600             5'350'100             5'368'600             5'392'200              \n43 Ricavi diversi 62'100                  123'000                51'000                    51'600                   68'200                  68'300                  68'600                  69'000                   \n44 Ricavi finanziari 400                        600                        100                          ‐                          ‐                         ‐                         ‐                         ‐                          \n45 Prelievi da fondi e finanziamenti speciali ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n46 Ricavi da trasferimento ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n47 Contributi da riversare 1'656'700             1'700'000             1'700'000             1'700'000              1'700'000             1'704'300             1'712'800             1'725'600              \n48 Ricavi straordinari ‐                         ‐                         ‐                           ‐                          ‐                         ‐                         ‐                         ‐                          \n49 Accrediti interni 137'300                183'300                157'500                157'500                 157'500                158'000                158'700                159'900                 \n90 Chiusura del conto economico (‐ avanzo; + disavanzo) ‐388'700.00          ‐721'300.00          ‐830'000.00          ‐598'100.00           ‐64'700.00            ‐61'500.00            ‐59'200.00            ‐43'600.00             \n\nCittà di Mendrisio Allegato MM N. 29 /2021 5 di 19\n\n\n\nConto patrimoniale AIM\n\n1 ATTIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n10 Beni patrimoniali (BP) 19'436'460         20'276'000         20'970'800            21'360'800            21'774'600             21'774'600            21'774'600           21'774'600           21'793'900          \n100 Liquidità e piazzamenti a breve termine 5'791'209           5'029'500           5'724'300              6'114'300              6'528'100               6'528'100              6'528'100             6'528'100             6'547'400             \n101 Crediti 12'927'872         14'545'200         14'545'200            14'545'200            14'545'200             14'545'200            14'545'200           14'545'200           14'545'200          \n104 Ratei e risconti attivi 26'185                 23'600                 23'600                   23'600                   23'600                    23'600                   23'600                  23'600                  23'600                  \n106 Scorte merci 691'194              677'700              677'700                 677'700                 677'700                  677'700                 677'700                677'700                677'700                \n108 Investimenti materiali dei BP ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n14 Beni amministrativi (BA) 38'312'414         45'347'400         54'133'700            65'518'500            85'422'200             95'884'300            106'633'600        115'422'700        119'573'500       \n140 Investimenti materiali dei BA 35'708'182         42'340'700         50'745'000            60'445'800            78'298'800             86'571'800            95'115'900           102'683'500        105'646'600       \n142 Investimenti immateriali ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n145 Partecipazioni, capitali sociali 9'300                   9'300                   9'300                      509'300                 509'300                  509'300                 509'300                509'300                509'300                \n146 Contributi per investimenti 2'594'933           2'997'400           3'379'400              4'563'400              6'614'100               8'803'200              11'008'400           12'229'900           13'417'600          \nTOTALE ATTIVI 57'748'874        65'623'400        75'104'500           86'879'300           107'196'800          117'658'900         128'408'200        137'197'300        141'367'400       \n2 PASSIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n20 Capitale di terzi 37'571'170         43'609'400         51'021'300            61'586'100            80'922'500             90'923'500            101'560'000        110'667'300        115'783'000       \n200 Impegni correnti 18'520'075         25'352'500         27'352'500            27'352'500            27'352'500             27'352'500            27'352'500           27'352'500           27'352'500          \n201 Impegni a breve termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n\n 204 Ratei e riscon  passivi (RRP)                                                               796'707              332'400              332'000                 332'000                 332'000                  332'000                 332'000                332'000                332'000                \n205 Accantonamenti a breve termine 252'640              249'000              260'000                 260'000                 260'000                  260'000                 260'000                260'000                260'000                \n206 Impegni a lungo termine 14'300'000         14'300'000         20'538'100            31'769'100            51'575'200             61'907'300            72'777'200           82'049'000           87'280'700          \nDebiti vecchi 14'300'000        14'300'000        14'300'000           9'800'000             9'800'000              7'000'000             6'000'000            6'000'000            3'000'000            \nDebiti nuovi ‐                      ‐                      6'238'100             21'969'100           41'775'200            54'907'300           66'777'200          76'049'000          84'280'700         \n208 Accantonamenti a lungo termine 125'476              126'200              126'200                 126'200                 126'200                  126'200                 126'200                126'200                126'200                \n209 Impegni verso finanziamenti speciali e fondi del capitale di terz 3'576'273           3'249'300           2'412'500              1'746'300              1'276'600               945'500                 712'100                547'600                431'600                \n29 Capitale proprio 20'177'704         22'014'000         24'083'200            25'293'200            26'274'300             26'735'400            26'848'200           26'530'000           25'584'400          \n291 Fondi ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n299 Eccedenze (+) / disavanzi (‐) di bilancio 20'177'704         22'014'000         24'083'200            25'293'200            26'274'300             26'735'400            26'848'200           26'530'000           25'584'400          \nTOTALE PASSIVI 57'748'874        65'623'400        75'104'500           86'879'300           107'196'800          117'658'900         128'408'200        137'197'300        141'367'400       \n\nCittà di Mendrisio Allegato MM N. 29 /2021 6 di 19\n\n\n\nConto patrimoniale EL\n\n1 ATTIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n10 Beni patrimoniali (BP) 10'155'729         10'858'900         10'858'900            10'858'900            10'858'900             10'858'900            10'858'900           10'858'900           10'858'900          \n100 Liquidità e piazzamenti a breve termine 2'988'266           1'801'500           1'801'500              1'801'500              1'801'500               1'801'500              1'801'500             1'801'500             1'801'500             \n101 Crediti 6'705'067           8'618'000           8'618'000              8'618'000              8'618'000               8'618'000              8'618'000             8'618'000             8'618'000             \n104 Ratei e risconti attivi 26'185                 22'900                 22'900                   22'900                   22'900                    22'900                   22'900                  22'900                  22'900                  \n106 Scorte merci 436'211              416'500              416'500                 416'500                 416'500                  416'500                 416'500                416'500                416'500                \n108 Investimenti materiali dei BP ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n14 Beni amministrativi (BA) 19'528'279         25'056'500         29'773'600            34'766'700            51'614'800             57'110'300            64'098'900           70'348'200           72'764'100          \n140 Investimenti materiali dei BA 19'518'979         25'047'200         29'764'300            34'757'400            51'605'500             57'101'000            64'089'600           70'338'900           72'754'800          \n142 Investimenti immateriali ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n145 Partecipazioni, capitali sociali 9'300                   9'300                   9'300                      9'300                       9'300                       9'300                      9'300                    9'300                    9'300                    \n146 Contributi per investimenti ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \nTOTALE ATTIVI 29'684'008        35'915'400        40'632'500           45'625'600           62'473'700            67'969'200           74'957'800          81'207'100          83'623'000         \n2 PASSIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n20 Capitale di terzi 18'075'020         22'915'300         26'379'000            30'932'100            47'236'100             52'361'200            59'155'300           65'399'400           68'281'400          \n200 Impegni correnti 7'433'371           12'983'500         12'983'500            12'983'500            12'983'500             12'983'500            12'983'500           12'983'500           12'983'500          \n201 Impegni a breve termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n\n 204 Ratei e riscon  passivi (RRP)                                                               764'900              296'300              296'300                 296'300                 296'300                  296'300                 296'300                296'300                296'300                \n205 Accantonamenti a breve termine 175'000              260'000              260'000                 260'000                 260'000                  260'000                 260'000                260'000                260'000                \n206 Impegni a lungo termine 6'000'000           6'000'000           10'300'500            15'519'800            32'293'500             37'749'700            44'777'200           51'185'800           54'183'800          \nDebiti vecchi 6'000'000          6'000'000          6'000'000             6'000'000             6'000'000              6'000'000             6'000'000            6'000'000            3'000'000            \nDebiti nuovi ‐                      ‐                      4'300'500             9'519'800             26'293'500            31'749'700           38'777'200          45'185'800          51'183'800         \n208 Accantonamenti a lungo termine 125'476              126'200              126'200                 126'200                 126'200                  126'200                 126'200                126'200                126'200                \n209 Impegni verso finanziamenti speciali e fondi del capitale di terz 3'576'273           3'249'300           2'412'500              1'746'300              1'276'600               945'500                 712'100                547'600                431'600                \n29 Capitale proprio 11'608'988         13'000'100         14'253'500            14'693'500            15'237'600             15'608'000            15'802'500           15'807'700           15'341'600          \n291 Fondi ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n299 Eccedenze (+) / disavanzi (‐) di bilancio 11'608'988         13'000'100         14'253'500            14'693'500            15'237'600             15'608'000            15'802'500           15'807'700           15'341'600          \nTOTALE PASSIVI 29'684'008        35'915'400        40'632'500           45'625'600           62'473'700            67'969'200           74'957'800          81'207'100          83'623'000         \n\nCittà di Mendrisio Allegato MM N. 29 /2021 7 di 19\n\n\n\nConto patrimoniale AP\n\n1 ATTIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n10 Beni patrimoniali (BP) 3'013'191           2'688'800           2'688'800              2'688'800              2'688'800               2'688'800              2'688'800             2'688'800             2'688'800             \n100 Liquidità e piazzamenti a breve termine 1'627'942           1'363'400           1'363'400              1'363'400              1'363'400               1'363'400              1'363'400             1'363'400             1'363'400             \n101 Crediti 1'155'564           1'093'800           1'093'800              1'093'800              1'093'800               1'093'800              1'093'800             1'093'800             1'093'800             \n104 Ratei e risconti attivi ‐                       700                      700                         700                          700                          700                         700                        700                        700                        \n106 Scorte merci 229'684              230'900              230'900                 230'900                 230'900                  230'900                 230'900                230'900                230'900                \n108 Investimenti materiali dei BP ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n14 Beni amministrativi (BA) 16'960'481         18'346'200         22'378'400            28'330'100            31'201'400             35'872'900            39'340'100           41'602'500           43'313'100          \n140 Investimenti materiali dei BA 14'365'549         15'348'800         18'999'000            23'766'700            24'587'300             27'069'700            28'331'700           29'372'600           29'895'500          \n142 Investimenti immateriali ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n145 Partecipazioni, capitali sociali ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n146 Contributi per investimenti 2'594'933           2'997'400           3'379'400              4'563'400              6'614'100               8'803'200              11'008'400           12'229'900           13'417'600          \nTOTALE ATTIVI 19'973'672        21'035'000        25'067'200           31'018'900           33'890'200            38'561'700           42'028'900          44'291'300          46'001'900         \n2 PASSIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n20 Capitale di terzi 17'462'492         18'467'300         22'404'900            28'416'600            31'449'000             36'094'500            39'704'900           42'349'900           44'583'600          \n200 Impegni correnti 9'133'724           10'131'600         12'131'600            12'131'600            12'131'600             12'131'600            12'131'600           12'131'600           12'131'600          \n201 Impegni a breve termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n\n 204 Ratei e riscon  passivi (RRP)                                                               28'769                 35'700                 35'700                   35'700                   35'700                    35'700                   35'700                  35'700                  35'700                  \n205 Accantonamenti a breve termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n206 Impegni a lungo termine 8'300'000           8'300'000           10'237'600            16'249'300            19'281'700             23'927'200            27'537'600           30'182'600           32'416'300          \nDebiti vecchi 8'300'000          8'300'000          8'300'000             3'800'000             3'800'000              1'000'000             ‐                        ‐                        ‐                        \nDebiti nuovi ‐                      ‐                      1'937'600             12'449'300           15'481'700            22'927'200           27'537'600          30'182'600          32'416'300         \n208 Accantonamenti a lungo termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n209 Impegni verso finanziamenti speciali e fondi del capitale di terz ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n29 Capitale proprio 2'511'179           2'567'700           2'662'200              2'602'200              2'441'100               2'467'100              2'323'900             1'941'300             1'418'200             \n291 Fondi ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n299 Eccedenze (+) / disavanzi (‐) di bilancio 2'511'179           2'567'700           2'662'200              2'602'200              2'441'100               2'467'100              2'323'900             1'941'300             1'418'200             \nTOTALE PASSIVI 19'973'672        21'035'000        25'067'100           31'018'800           33'890'100            38'561'600           42'028'800          44'291'200          46'001'800         \n\nCittà di Mendrisio Allegato MM N. 29 /2021 8 di 19\n\n\n\nConto patrimoniale GAS\n\n1 ATTIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n10 Beni patrimoniali (BP) 6'267'540           6'728'300           7'423'200              7'813'200              8'227'000               8'227'000              8'227'000             8'227'000             8'246'300             \n100 Liquidità e piazzamenti a breve termine 1'175'001           1'864'600           2'559'500              2'949'500              3'363'300               3'363'300              3'363'300             3'363'300             3'382'600             \n101 Crediti 5'067'240           4'833'400           4'833'400              4'833'400              4'833'400               4'833'400              4'833'400             4'833'400             4'833'400             \n104 Ratei e risconti attivi ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n106 Scorte merci 25'299                 30'300                 30'300                   30'300                   30'300                    30'300                   30'300                  30'300                  30'300                  \n108 Investimenti materiali dei BP ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n14 Beni amministrativi (BA) 1'823'655           1'944'700           1'981'700              2'421'700              2'606'000               2'901'100              3'194'600             3'472'000             3'496'300             \n140 Investimenti materiali dei BA 1'823'655           1'944'700           1'981'700              1'921'700              2'106'000               2'401'100              2'694'600             2'972'000             2'996'300             \n142 Investimenti immateriali ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n145 Partecipazioni, capitali sociali ‐                       ‐                       ‐                          500'000                 500'000                  500'000                 500'000                500'000                500'000                \n146 Contributi per investimenti ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \nTOTALE ATTIVI 8'091'195          8'673'000          9'404'900             10'234'900           10'833'000            11'128'100           11'421'600          11'699'000          11'742'600         \n2 PASSIVI 01.01.2020 2020 2021 2022 2023 2024 2025 2026 2027\n20 Capitale di terzi 2'033'658           2'226'800           2'237'400              2'237'400              2'237'400               2'467'800              2'699'800             2'918'000             2'918'000             \n200 Impegni correnti 1'952'980           2'237'400           2'237'400              2'237'400              2'237'400               2'237'400              2'237'400             2'237'400             2'237'400             \n201 Impegni a breve termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n\n 204 Ratei e riscon  passivi (RRP)                                                               3'038                   400                      ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n205 Accantonamenti a breve termine 77'640                 ‐11'000               ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n206 Impegni a lungo termine ‐                       ‐                       ‐                          ‐                           ‐                           230'400                 462'400                680'600                680'600                \nDebiti vecchi ‐                      ‐                      ‐                         ‐                          ‐                          ‐                         ‐                        ‐                        ‐                        \nDebiti nuovi ‐                      ‐                      ‐                         ‐                          ‐                          230'400                462'400               680'600               680'600               \n208 Accantonamenti a lungo termine ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n209 Impegni verso finanziamenti speciali e fondi del capitale di terz ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n29 Capitale proprio 6'057'537           6'446'200           7'167'500              7'997'500              8'595'600               8'660'300              8'721'800             8'781'000             8'824'600             \n291 Fondi ‐                       ‐                       ‐                          ‐                           ‐                           ‐                          ‐                        ‐                        ‐                        \n299 Eccedenze (+) / disavanzi (‐) di bilancio 6'057'537           6'446'200           7'167'500              7'997'500              8'595'600               8'660'300              8'721'800             8'781'000             8'824'600             \nTOTALE PASSIVI 8'091'195          8'673'000          9'404'900             10'234'900           10'833'000            11'128'100           11'421'600          11'699'000          11'742'600         \n\nCittà di Mendrisio Allegato MM N. 29 /2021 9 di 19\n\n\n\nAmmortamenti\n\n2020 2021 2022 2023 2024 2025 2026 2027\n\nAliquote ammortamento\n\n1080 Terreni beni patrimoniali 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%\n1084 Immobili beni patrimoniali 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%\n1090 Crediti verso finanziamenti speciali 0.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0%\n1400 Terreni beni amministrativi 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%\n1401 Strade, piazze e vie di comunicazione 0.0% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5%\n1402 Sistemazione corsi d'acqua e laghi 0.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%\n1403 Altre opere del genio civile 0.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%\n\n1403.2 Opere Piano generale smaltimento acque 0.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0%\n1404 Immobili beni amministrativi 0.0% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5%\n1405 Boschi 0.0% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5%\n1406 Beni mobili beni amministrativi 0.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%\n1409 Altri investimenti materiali 0.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%\n1420 Software 0.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%\n1429 Altri investimenti materiali 0.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%\n1441 Prestiti al Cantone o enti parastatali 0.0% 3.3% 3.3% 3.3% 3.3% 3.3% 3.3% 3.3%\n1454 Partecipazione in imprese pubbliche 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%\n1461 Contributi al Cantone 0.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%\n\n1462\nContributi a Comuni, Consorzi e altri enti \nlocali 0.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0%\n\n1464 Contributi a imprese pubbliche 0.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%\n1465 Contributi ad imprese private 0.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%\n\n1466\nContributi ad organizzazioni senza scopo di \nlucro 0.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%\n\nCalcolo ammortamenti\n\n1400 Terreni beni amministrativi 01.01 1'734'636 1'727'636 1'720'636 1'713'636 1'706'636 1'699'636 1'692'636 1'685'636\nInvestimento anno 0 0 0 0 0 0 0 0\nAmmortamenti riportati 7'000 7'000 7'000 7'000 7'000 7'000 7'000 7'000\nAmmortamento nuovo 0 0 0 0 0 0 0 0\nValore al 31.12 1'727'636 1'720'636 1'713'636 1'706'636 1'699'636 1'692'636 1'685'636 1'678'636\n\n1401 Strade, piazze e vie di comunicazione 01.01 258'341 654'203 1'083'803 1'538'003 3'992'603 4'142'403 4'285'103 4'420'703\nInvestimento anno 408'862 463'000 512'000 2'525'200 283'500 283'500 283'500 283'500\nAmmortamenti riportati 13'000 33'400 57'800 57'800 70'600 133'700 140'800 147'900\nAmmortamento nuovo 0 0 0 12'800 63'100 7'100 7'100 7'100\nValore al 31.12 654'203 1'083'803 1'538'003 3'992'603 4'142'403 4'285'103 4'420'703 4'549'203\n\n1403 Altre opere del genio civile 01.01 30'321'576 36'188'915 43'573'415 51'473'315 61'497'315 65'812'515 70'677'215 75'504'915\nInvestimento anno 7'221'040 8'930'000 9'694'000 12'010'200 6'529'500 7'176'800 7'179'500 6'079'500\nAmmortamenti riportati 1'353'700 1'545'500 1'794'100 1'792'300 1'974'100 2'181'500 2'208'300 2'349'100\nAmmortamento nuovo 0 0 0 193'900 240'200 130'600 143'500 143'600\nValore al 31.12 36'188'915 43'573'415 51'473'315 61'497'315 65'812'515 70'677'215 75'504'915 79'091'715\n\n1404 Immobili beni amministrativi 01.01 1'281'062 1'413'084 1'336'684 1'374'784 3'535'384 5'640'284 7'689'484 9'582'984\nInvestimento anno 201'222 0 100'000 2'225'000 2'225'000 2'225'000 2'125'000 0\nAmmortamenti riportati 69'200 76'400 61'900 61'900 64'400 120'100 175'800 229'300\nAmmortamento nuovo 0 0 0 2'500 55'700 55'700 55'700 53'200\nValore al 31.12 1'413'084 1'336'684 1'374'784 3'535'384 5'640'284 7'689'484 9'582'984 9'300'484\n\n1405 Boschi 01.01 11'214 10'614 10'014 9'414 8'814 8'214 7'614 7'014\nInvestimento anno 0 0 0 0 0 0 0 0\nAmmortamenti riportati 600 600 600 600 600 600 600 600\nAmmortamento nuovo 0 0 0 0 0 0 0 0\nValore al 31.12 10'614 10'014 9'414 8'814 8'214 7'614 7'014 6'414\n\n1406 Beni mobili beni amministrativi 01.01 2'101'352 2'346'379 3'020'479 4'336'679 7'558'079 9'268'779 10'763'879 11'482'279\nInvestimento anno 659'927 1'067'000 1'679'000 3'685'600 2'537'000 2'537'000 1'925'100 937'000\nAmmortamenti riportati 414'900 392'900 362'800 296'300 457'700 788'200 953'000 1'206'600\n\nDati consuntivo e preventivo\n\nCittà di Mendrisio Allegato MM N. 29 /2021 10 di 19\n\n\n\nAmmortamenti\n\n2020 2021 2022 2023 2024 2025 2026 2027\n\nAmmortamento nuovo 0 0 0 167'900 368'600 253'700 253'700 192'500\nValore al 31.12 2'346'379 3'020'479 4'336'679 7'558'079 9'268'779 10'763'879 11'482'279 11'020'179\n\n1454 Partecipazione in imprese pubbliche 0 0 0 500'000 500'000 500'000 500'000 500'000\nInvestimento anno 0 0 500'000 0 0 0 0 0\nAmmortamenti riportati 0 0 0 0 0 0 0 0\nAmmortamento nuovo 0 0 0 0 0 0 0 0\nValore al 31.12 0 0 500'000 500'000 500'000 500'000 500'000 500'000\n\n1462 Contributi a Comuni, Consorzi e altri enti locali 2'594'933 2'997'431 3'379'431 4'563'431 6'614'131 8'803'231 11'008'431 12'229'931\nInvestimento anno 485'798 480'000 1'296'600 2'202'200 2'406'700 2'495'000 1'586'200 1'600'000\nAmmortamenti riportati 83'300 98'000 112'600 112'600 151'500 217'600 289'800 364'700\nAmmortamento nuovo 0 0 0 38'900 66'100 72'200 74'900 47'600\nValore al 31.12 2'997'430.55 3'379'431 4'563'431 6'614'131 8'803'231 11'008'431 12'229'931 13'417'631\n\nTotali 01.01 38'303'114 45'338'262 54'124'462 65'509'262 85'412'962 95'875'062 106'624'362 115'413'462\nSaldi 31.12\n\n108 Investimenti materiali dei  BP 0 0 0 0 0 0 0 0\n109 Crediti verso finanziamenti speciali 0 0 0 0 0 0 0 0\n\n140-144 Investimenti in beni amministrativi 42'340'831 50'745'031 60'445'831 78'298'831 86'571'831 95'115'931 102'683'531 105'646'631\n145 Partecipazione in imprese pubbliche 0 0 500'000 500'000 500'000 500'000 500'000 500'000\n146 Contributi per investimenti 2'997'431 3'379'431 4'563'431 6'614'131 8'803'231 11'008'431 12'229'931 13'417'631\n\nTotali 31.12 45'338'262 54'124'462 65'509'262 85'412'962 95'875'062 106'624'362 115'413'462 119'564'262\n\nRiepilogo ammortamenti\n\n33 Ammortamenti beni amministrativi 1'858'400 2'055'800 2'284'200 2'593'000 3'302'000 3'678'200 3'945'500 4'336'900\n344 Rettifiche di valore su investimenti in BP 0 0 0 0 0 0 0 0\n366 Ammortamenti contributi per investimenti 83'300 98'000 112'600 151'500 217'600 289'800 364'700 412'300\n\n3052 Ammortamento fondi cassa pensione 0 0 0 0 0 0 0 0\n318 Perdite effettive su crediti 20'680 90'000 65'000 65'000 65'000 65'000 65'000 65'000\n\nCittà di Mendrisio Allegato MM N. 29 /2021 11 di 19\n\n\n\nInvestimenti\n\nC.to Investimenti 2020 2021 2022 2023 2024 2025 2026 2027 Oltre\n\nInvestimenti priorità 1‐2\n1080 Terreni beni patrimoniali 0 0 0 0 0 0 0 0 0\n1084 Immobili beni patrimoniali 0 0 0 0 0 0 0 0 0\n1090 Crediti verso finanziamenti speciali 0 0 0 0 0 0 0 0 0\n1400 Terreni beni amministrativi 0 0 0 0 0 0 0 0 0\n1401 Strade, piazze e vie di comunicazione\n\n‐ Elettricità (illuminazione pubblica) 408'862 463'000 512'000 2'525'200 283'500 283'500 283'500 283'500 283'500\n1402 Sistemazione corsi d'acqua e laghi 0 0 0 0 0 0 0 0 0\n1403 Altre opere del genio civile\n\n‐ Elettricità 5'499'303 4'790'000 4'469'000 11'045'200 3'729'500 5'499'500 5'699'500 4'599'500 2'599'500\n‐ Acqua potabile 1'499'889 3'980'000 5'175'000 915'000 2'640'000 1'517'300 1'320'000 1'320'000 1'320'000\n‐ Gas 221'848 160'000 50'000 50'000 160'000 160'000 160'000 160'000 160'000\n\n1403.2 Opere Piano generale smaltimento acque 0 0 0 0 0 0 0 0 0\n1404\n\n‐ Elettricità 126'418 0 65'000 1'500'000 1'500'000 1'500'000 1'435'000 0 0\n‐ Acqua potabile 49'090 0 25'000 475'000 475'000 475'000 450'000 0 0\n‐ Gas 25'714 0 10'000 250'000 250'000 250'000 240'000 0 0\n\n1405 Boschi 0 0 0 0 0 0 0 0 0\n1406 Beni mobili dei BA\n\n‐ Elettricità 595'353 707'000 1'309'000 3'315'600 2'167'000 2'167'000 1'555'100 567'000 567'000\n‐ Acqua potabile 40'406 320'000 330'000 330'000 330'000 330'000 330'000 330'000 330'000\n‐ Gas 24'168 40'000 40'000 40'000 40'000 40'000 40'000 40'000 40'000\n\n1409 Altri investimenti materiali 0 0 0 0 0 0 0 0 0\n1420 Software 0 0 0 0 0 0 0 0 0\n1429 Altri investimenti materiali 0 0 0 0 0 0 0 0 0\n1441 Prestiti al Cantone o enti parastatali 0 0 0 0 0 0 0 0 0\n1454 Partecipazione in imprese pubbliche 0 0 500'000 0 0 0 0 0 0\n1461 Contributi al Cantone 0 0 0 0 0 0 0 0 0\n\n1462 Contributi a Comuni, Consorzi e altri enti loc.\n\nImmobili beni amministrativi\n\nCittà di Mendrisio Allegato MM N. 29 /2021 12 di 19\n\n\n\nInvestimenti\n\nC.to Investimenti 2020 2021 2022 2023 2024 2025 2026 2027 Oltre\n\n‐ Acqua potabile (ARM) 485'798 480'000 1'296'600 2'202'200 2'406'700 2'495'000 1'586'200 1'600'000 1'600'000\n1464 Contributi a imprese pubbliche 0 0 0 0 0 0 0 0 0\n1465 Contributi ad imprese private 0 0 0 0 0 0 0 0 0\n\n1466\nContributi ad organizzazioni senza scopo di \nlucro 0 0 0 0 0 0 0 0 0\n\nRiepilogo\n108‐109 Beni patrimoniali 0 0 0 0 0 0 0 0 0\n140‐145 Investimenti in beni amministrativi 8'491'050 10'460'000 12'485'000 20'446'000 11'575'000 12'222'300 11'513'100 7'300'000 5'300'000\n\n144 Prestiti 0 0 0 0 0 0 0 0 0\n146 Contributi per investimenti 485'798 480'000 1'296'600 2'202'200 2'406'700 2'495'000 1'586'200 1'600'000 1'600'000\n\nTotale investimenti 31 dicembre 8'976'848 10'940'000 13'781'600 22'648'200 13'981'700 14'717'300 13'099'300 8'900'000 6'900'000\n\nCittà di Mendrisio Allegato MM N. 29 /2021 13 di 19\n\n\n\nPiano delle opere\n\nPiano delle Opere AIM MM\nImporto \ncredito\n\n(IVA esclusa)\nPreC2021 P2022 PF2023 PF2024 PF2025 PF2026 PF2027\n\nAcquedotto Regionale del Mendrisiotto (ARM) 128 /2012 ‐                  480'000              1'296'600                2'202'200                      2'406'700                    2'495'000                    1'586'200                    1'600'000                     \nCredito quadro AP 2016‐2020 04 /2016 8'040'000       1'600'000           500'000                  \nNuova sottostazione Tana 47 /2017 6'406'685       1'500'000           1'060'000               \nCredito quadro PV 2018‐2021 52 /2017 2'000'000       90'000                200'000                   250'000                         250'000                       300'000                       300'000                       300'000                        \nCredito quadro EL 2018‐2021 57 /2018 12'000'000     1'000'000          \nCredito quadro Gas 2018‐2021 58 /2018 2'120'706       200'000             \nProgetto Cassinelli ‐ rinnovo/ampliamento reti AP e EL 123 /2020 2'938'000       1'200'000           855'000                   855'000                        \nNuovo serbatoio AP Perfetta Arzo 124 /2020 2'368'617       1'000'000           1'150'000                ‐                                 ‐                               ‐                              \n‐ Entrata sussidio cantonale SPAAS per SE Perfetta 124 /2020 ‐402'665        ‐                     ‐                           ‐                                ‐                              ‐402'665                    \nNuovo Pozzo Prati Maggi 134 /2020 4'178'273       1'200'000           2'670'000                ‐                                \n‐ Partecipazione ai costi ARM (secondo decisione SPAAS) 134 /2020 ‐500'000        ‐                     ‐                           ‐500'000                      \nCQ Infrastrutture GC 2021‐2024 151 /2021 6'499'536      2'100'000          2'180'000                2'180'000                    \nCQ Fornitura‐posa componenti 2021‐2024  152 /2021 5'571'031      530'000             1'000'000                1'000'000                     1'000'000                   1'000'000                   1'000'000                  \nMigrazione a Smartmeter 03 /2021 6'388'115        40'000                600'000                   1'600'000                     1'600'000                   1'600'000                   988'115                     \nPartecipazione "Teleriscaldamento del Mendrisiotto” 11 /2021 500'000           ‐                      500'000                  \nAcquisto comprensori EL AIL XX /2021 12'906'000     ‐                      1'420'000                11'486'000                   \nSan Rocco ‐ Caviano XX /2022 1'500'000       ‐                      150'000                   1'050'000                      300'000                      \nNuova sede AIM (prato verde) XX /2022 8'900'000       ‐                      100'000                   2'225'000                      2'225'000                    2'225'000                    2'125'000                   \nRancate ‐ Besazio e Serbatoio Barozzo XX /2023 2'000'000        ‐                     ‐                           200'000                        1'200'000                   600'000                     \nRifacimento Penate XX /2023 6'600'000       ‐                     100'000                   100'000                         600'000                       1'900'000                    1'900'000                   2'000'000                    \nCQ Progettazione 2024‐2027 XX /2023 2'000'000       ‐                      ‐                            ‐                                 500'000                       500'000                       500'000                       500'000                        \nCQ Infrastrutture GC 2024‐2027 XX /2023 14'000'000      ‐                        ‐                              ‐                                 3'500'000                      3'500'000                      3'500'000                      3'500'000                     \nAnello AT Tana XX /2025 2'600'000        ‐                     ‐                           ‐                                400'000                      1'000'000                   1'200'000                  \nCQ Fornitura‐posa componenti 2027‐2030 XX /2026 4'000'000        ‐                        ‐                              ‐                                 ‐                                 ‐                                 ‐                                 1'000'000                     \nTotale 10'940'000        13'781'600              22'648'200                    13'981'700                  14'717'335                  13'099'315                  8'900'000                     \n\nCittà di Mendrisio Allegato MM N. 29 /2021 14 di 19\n\n\n\nInteressi\n\nInteressi C2020 2021 2022 2023 2024 2025 2026 2027\n\nInteressi vecchi debiti 139'100              158'200              144'200              144'200              130'800              126'300              126'300              106'300             \n\nDebiti a breve termine: ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                       ‐                      \n\nDebiti a medio lungo termine 139'100              158'200              144'200              144'200              130'800              126'300              126'300              106'300             \n2064.096 Banca Stato 2496312 (2015‐2020 0.70%) (Sezione AP) AP 272                    ‐                     ‐                      ‐                     ‐                     ‐                     ‐                     ‐                     \n2064.091 PostFinance PF.004471 (2016‐2024 0.55%) (Sezione AP) AP 4'400                 4'400                 4'400                  4'400                 ‐                     ‐                     ‐                     ‐                     \n2064.092 PostFinance PF.005219 (2017‐2022 0.41%) (Sezione AP) AP 18'450              18'500              ‐                      ‐                     ‐                     ‐                     ‐                     ‐                     \n2064.095 Banca Stato (2019‐2024 0.45%) (Sezione AP) AP 9'150                 9'000                 9'000                  9'000                 ‐                     ‐                     ‐                     \n2064.097 Banca Stato (2020‐2025 0.45%) (Sezione AP) AP 4'400                 4'500                  4'500                 4'500                 ‐                     ‐                     ‐                     \n2001.093 Città di Mendrisio (Sezione AP) AP ‐                      ‐                     ‐                     ‐                     ‐                     ‐                     \n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) AP 51'354              48'600              48'600               48'600              48'600              48'600              48'600              48'600             \n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) AP 569                    5'000                 5'000                  5'000                 5'000                 5'000                 5'000                 ‐                     \n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) AP ‐                     10'000              10'000               10'000              10'000              10'000              10'000              10'000             \n2064.093 Banca Stato 9301903 (2018‐2028 0.95%) (Sezione EL) EL 28'500              28'500              28'500               28'500              28'500              28'500              28'500              28'500             \n2064.094 Credit Suisse (2019‐2029 0.64%) (Sezione EL) EL 19'200              19'200              19'200               19'200              19'200              19'200              19'200              19'200             \n2001.093 Città di Mendrisio (Sezione EL) EL ‐                     ‐                     ‐                      ‐                     ‐                     ‐                     ‐                     ‐                     \n2001.091 Città di Mendrisio (tasso variabile) (Sezione EL) EL 2'792                 15'000              15'000               15'000              15'000              15'000              15'000              ‐                     \n\nInteressi nuovi debiti 281'200.00 553'800.00 698'500.00 864'500.00 1'070'800.00\nDati Preventivo o Consuntivo\n\nCittà di Mendrisio Allegato MM N. 29 /2021 15 di 19\n\n\n\nDebiti vecchi\n\nDebiti 31 dicembre (gruppo 201+206)\nTasso \n\ninteresse\nScadenza 01.01.2020 31.12.2020 2021 2022 2023 2024 2025 2026 2027\n\nDebiti a breve termine: 0 0 0 0 0 0 0 0.00 0.00\nCC 0 0 0 0 0 0.00 0.00\nPrevisione debito a breve 0 0 0 0 0 0 0 0.00 0.00\nDebiti a medio lungo termine 22'239'661      25'239'700      27'239'700      22'739'700      22'739'700      19'939'700      18'939'700      18'939'700      14'939'700     \n2064.096 Banca Stato 2496312 (2015‐2020 0.70%) (Sezione AP) 0.45% 14.01.2025 1'000'000        \n2064.091 PostFinance PF.004471 (2016‐2024 0.55%) (Sezione AP) 0.55% 04.03.2024 800'000            800'000            800'000             800'000            800'000            ‐                    ‐                    ‐                    ‐                   \n2064.092 PostFinance PF.005219 (2017‐2022 0.41%) (Sezione AP) 0.41% 25.07.2022 4'500'000         4'500'000         4'500'000         ‐                    ‐                    ‐                    ‐                    ‐                    ‐                   \n2064.095 Banca Stato (2019‐2024 0.45%) (Sezione AP) 0.45% 19.12.2024 2'000'000         2'000'000         2'000'000         2'000'000         2'000'000         ‐                    ‐                    ‐                    ‐                   \n2064.097 Banca Stato (2020‐2025 0.45%) (Sezione AP) 0.45% 14.01.2025 1'000'000         1'000'000         1'000'000         1'000'000         1'000'000         1'000'000         ‐                    ‐                    ‐                   \n2001.093 Città di Mendrisio (Sezione AP) 0.50%\n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) 0.70% nessuna 6'939'661         6'939'700         6'939'700         6'939'700         6'939'700         6'939'700         6'939'700         6'939'700         6'939'700       \n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) 0.50% 17.11.2027 1'000'000         1'000'000         1'000'000         1'000'000         1'000'000         1'000'000         1'000'000        \n2001.092 Città di Mendrisio (tasso variabile) (Sezione AP) 0.50% nessuna 2'000'000         2'000'000         2'000'000         2'000'000         2'000'000         2'000'000         2'000'000       \n\n‐                    ‐                     ‐                    ‐                    ‐                    ‐                    0.00 0.00\n2064.093 Banca Stato 9301903 (2018‐2028 0.95%) (Sezione EL) 0.95% 21.12.2028 3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000.00 3'000'000.00\n2064.094 Credit Suisse (2019‐2029 0.64%) (Sezione EL) 0.64% 19.12.2029 3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000.00 3'000'000.00\n2001.093 Città di Mendrisio (Sezione EL) 0.50% ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    0.00 0.00\n2001.091 Città di Mendrisio (tasso variabile) (Sezione EL) 0.50% 17.11.2027 3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000         3'000'000.00 0.00\n\nTotale debiti 31 dicembre (gruppo 201+206) 22'239'660.92 25'239'700.00 27'239'700.00 22'739'700.00 22'739'700.00 19'939'700.00 18'939'700.00 18'939'700.00 14'939'700.00\n\nCittà di Mendrisio Allegato MM N. 29 /2021 16 di 19\n\n\n\nNuovi debiti remunerati\n\nNuovi debiti remunerati 2020 2021 2022 2023 2024 2025 2026 2027\n\nInvestimento netto anno corrente 8'976'800         10'940'000         13'781'600       22'648'200       13'981'700       14'717'300         13'099'300         8'900'000          \nCash flow ‐4'976'000     ‐2'701'900        ‐2'550'600     ‐2'842'100     ‐3'649'600       ‐3'847'400        ‐3'827'500        ‐3'668'300       \n\nFabbisogno in capitali 4'000'800         8'238'100           11'231'000      19'806'100      10'332'100      10'869'900         9'271'800           5'231'700          \n\nDebiti per nuove opere 4'000'800         8'238'100           11'231'000       19'806'100       10'332'100       10'869'900         9'271'800           5'231'700          \nRifinanziamento debiti vecchi ‐800                4'500'000       ‐                   2'800'000        1'000'000         ‐                     3'000'000        \nRifinanziamento 2020 ‐800               \nRifinanziamento 2021\nRifinanziamento 2022 4'500'000      \nRifinanziamento 2023\nRifinanziamento 2024 2'800'000       \nRifinanziamento 2025 1'000'000        \nRifinanziamento 2026\nRifinanziamento 2027 3'000'000        \n\nTotale nuovi debiti 4'000'000 8'238'100 15'731'000 19'806'100 13'132'100 11'869'900 9'271'800 8'231'700\n\nRimborso vecchi debiti 0 0 4'500'000 0 2'800'000 1'000'000 0 3'000'000\n\nInteressi nuovi debiti 2020 2021 2022 2023 2024 2025 2026 2027\n\nDebiti contratti 2020 1'000'000 1'000'000 1'000'000 1'000'000 1'000'000 0 0 0\nDebiti contratti 2021 8'238'100 8'238'100 8'238'100 8'238'100 8'238'100 0 0\nDebiti contratti 2022 15'731'000 15'731'000 15'731'000 15'731'000 15'731'000 0\nDebiti contratti 2023 19'806'100 19'806'100 19'806'100 19'806'100 19'806'100\nDebiti contratti 2024 14'132'100 14'132'100 14'132'100 14'132'100\nDebiti contratti 2025 20'108'000 20'108'000 20'108'000\nDebiti contratti 2026 25'002'800 25'002'800\nDebiti contratti 2027 28'037'800\nInteressi annuali 10'000 146'400 281'200 553'800 698'500 864'500 1'070'800\n\nNuovi debiti:  mutui fissi per anni  4\nVerifica debiti al 31.12 1'000'000 9'238'100 24'969'100 44'775'200 57'907'300 69'777'200 79'049'000 87'280'700\n\n1'000'000 3'000'000 3'000'000 3'000'000 3'000'000 3'000'000 3'000'000 3'000'000\n\nGli interessi su debiti nuovi sono calcolati a decorre del 1. gennaio dell'anno successivo fino al 31.12 dell'anno di rifinanziamento.\nIl debito nuovo che deve essere rifinanziato alla sua scadenza è aggiunto al mutuo che dovrebbe essere accesso del corso dell'anno.\n\nCittà di Mendrisio Allegato MM N. 29 /2021 17 di 19\n\n\n\nAutofinanziamento\n\n2020 2021 2022 2023 2024 2025 2026\n\nRisultato di gestione corrente 1'836'400           2'069'200             1'210'000             981'100                461'100                112'800                ‐318'200              \n+ Ammortamenti amministrativi 1'858'400         2'055'800           2'284'200           2'593'000           3'302'000           3'678'200           3'945'500          \n+ Attribuzione a fondi e finanziamenti speciali 521'800            108'600              86'500                  61'000                 43'000                 30'300                 21'400                \n+ Rettifiche valore prestiti beni amministrativi ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \n+ Rettifiche valore partecipazioni beni amministrativi ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \n+ Ammortamenti contributi investimenti 83'300              98'000                 112'600              151'500              217'600              289'800              364'700             \n+ Versamenti a Capitale proprio ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \n‐ Prelievo da fondi e finanziamenti speciali ‐848'800           ‐945'400             ‐752'700             ‐530'700             ‐374'100             ‐263'700             ‐185'900            \n‐ Prelievo da budget globali ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \n\nAutofinanziamento LOC 3'451'100.00    3'386'200.00      2'940'600.00      3'255'900.00      3'649'600.00      3'847'400.00      3'827'500.00     \nRettifiche valore investimenti BP ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \nRettifiche valore investimenti BP ‐                     ‐                       ‐                        ‐                       ‐                       ‐                       ‐                      \nVariazione sostanza circolante 1'524'938.51   ‐684'300.00       ‐390'000.00       ‐413'800.00       ‐                       ‐                       ‐                      \n\nCash flow 4'976'038.51     2'701'900.00       2'550'600.00       2'842'100.00       3'649'600.00       3'847'400.00       3'827'500.00      \n\nCittà di Mendrisio Allegato MM N. 29 /2021 18 di 19\n\n\n\nIndici finanziari\n\nINDICI FINANZIARI 2020 2021 2022 2023 2024 2025 2026 2027\n\nQuota degli oneri finanziari 6% 6% 7% 8% 11% 12% 13% 15%\nElettricità 4% 5% 5% 6% 9% 10% 11% 13%\nAcqua 22% 20% 22% 27% 28% 32% 35% 38%\nGas 3% 3% 3% 3% 3% 3% 3% 3%\nQuota delle spese per interessi 0% 0% 1% 1% 2% 2% 3% 3%\nElettricità 0% 0% 0% 1% 1% 2% 2% 2%\nAcqua 2% 3% 3% 5% 6% 7% 8% 9%\nGas 0% 0% 0% 0% 0% 0% 0% 0%\nGrado di autofinanziamento 38.4% 31.0% 21.3% 14.4% 26.1% 26.1% 29.2% 41.4%\nElettricità 33% 28% 18% 9% 29% 26% 29% 45%\nAcqua 36% 18% 12% 23% 21% 25% 28% 31%\nGas 199% 442% 165% 222% 49% 48% 50% 110%\nQuota degli investimenti 22.4% 25.4% 28.6% 39.6% 28.7% 29.6% 27.1% 20.0%\nElettricità 22% 19% 19% 41% 23% 26% 25% 17%\nAcqua 48% 63% 69% 54% 63% 58% 51% 48%\nGas 5% 4% 12% 7% 8% 8% 8% 4%\nQuota di capitale proprio 33.5% 32.1% 29.1% 24.5% 22.7% 20.9% 19.3% 18.1%\nElettricità 36% 35% 32% 24% 23% 21% 19% 18%\nAcqua 12% 11% 8% 7% 6% 6% 4% 3%\nGas 74% 76% 78% 79% 78% 76% 75% 75%\nTasso di indebitamento lordo 112.3% 131.1% 155.3% 205.8% 229.8% 255.6% 278.2% 291.0%\nElettricità 73% 88% 102% 161% 180% 204% 225% 235%\nAcqua 511.14% 509% 616% 638% 680% 736% 798% 838%\nGas 38% 40% 42% 42% 46% 50% 54% 53%\n\nCittà di Mendrisio Allegato MM N. 29 /2021 19 di 19\n\n\n\t0\n\t01\n\t02\n\t03\n\t04\n\t04.1\n\t05\n\t06\n\t07\n\t07.1\n\t08\n\t09\n\t10\n\t11\n\t12\n\t13\n\t14\n\t15\n\n\n\n


parent_type: affair

name: MM 09 /2021 accordo incarico di gest. .pdf

category_it: ALLEGATO

format: application/pdf

text: \n\n\n\n