Document · PDF

gemSchagen PSWR 2023-2027 definitief

Gemeenteraad 21 maart 2023, gemeente SchagenBij agendapunt: Programma Stedelijk Water en Riolering 2023-202755.058 woorden

Open het PDF bij de gemeente ↗Naar de vergadering →

Tekst van het document

Uit het bestand gehaald, zonder opmaak, tabellen en afbeeldingen · deel 5 van 6

€ 698.101.248 TOTAAL

€

excl. BTW

€ € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.185.482 4.471.153 4.810.708 5.180.704 5.562.073 5.990.332 6.453.428 6.991.468 7.571.986 8.199.468 8.893.831 9.576.801 9.777.235 9.982.525 10.200.182 10.415.863 10.630.596 10.854.520 11.084.071 11.312.865 11.545.800 11.782.539 12.066.445 12.329.422 12.601.362 12.884.814 10.679.171 10.911.052 11.147.315 11.387.673 11.632.262 11.885.180 12.138.058 12.396.852 12.662.309 12.935.476 13.215.433 13.494.480 13.780.499 14.070.355 14.365.791 11.907.392 12.157.082 12.411.667 12.671.245 12.935.914 13.205.777 13.481.084 13.761.660 14.048.904 14.341.687 14.639.394 14.970.462 15.311.782 15.657.076 16.007.436 16.363.212 16.706.621 17.055.305 17.409.969

afschr + rente BTW compensatie 66.420.047 € 764.521.295 TOTAAL BTW

Egalisatievoorziening riolering (BBV 44.2) €

525.341 597.011 649.489 701.646 774.851 836.062 899.996 929.413 959.862 990.176 1.004.006 1.023.782 1.035.359 1.046.322 1.049.242 1.058.549 1.073.304 1.083.458 1.092.667 1.107.408 1.122.878 1.139.513 1.114.048 1.114.681 1.111.623 1.102.430 1.105.362 1.109.172 1.113.314 1.118.168 1.123.696 1.125.897 1.133.241 1.139.873 1.145.150 1.148.132 1.149.847 1.158.106 1.165.139 1.174.195 1.183.650 1.193.324 1.205.647 1.218.317 1.231.339 1.244.722 1.258.471 1.272.449 1.286.944 1.300.672 1.314.881 1.330.305 1.318.631 1.303.093 1.290.097 1.278.679 1.268.626 1.277.854 1.288.860 1.301.079

5.710.823 5.068.164 5.460.197 5.882.350 6.336.923 6.826.394 7.353.424 7.920.881 8.531.848 9.189.644 9.897.837 10.600.583 10.812.595 11.028.847 11.249.424 11.474.412 11.703.901 11.937.979 12.176.738 12.420.273 12.668.678 12.922.052 13.180.493 13.444.103 13.712.985 13.987.245 11.784.533 12.020.224 12.260.628 12.505.841 12.755.958 13.011.077 13.271.298 13.536.724 13.807.459 14.083.608 14.365.280 14.652.586 14.945.638 15.244.550 15.549.441 13.100.715 13.362.730 13.629.984 13.902.584 14.180.636 14.464.248 14.753.533 15.048.604 15.349.576 15.656.568 15.969.699 16.289.093 16.614.875 16.947.172 17.286.116 17.631.838 17.984.475 18.344.164 18.711.048

€ 763.726.295

Dotatie

incl. BTW

-795.000

-795.000 -

TOTAAL

Jaar

4.915.823 5.068.164 5.460.197 5.882.350 6.336.923 6.826.394 7.353.424 7.920.881 8.531.848 9.189.644 9.897.837 10.600.583 10.812.595 11.028.847 11.249.424 11.474.412 11.703.901 11.937.979 12.176.738 12.420.273 12.668.678 12.922.052 13.180.493 13.444.103 13.712.985 13.987.245 11.784.533 12.020.224 12.260.628 12.505.841 12.755.958 13.011.077 13.271.298 13.536.724 13.807.459 14.083.608 14.365.280 14.652.586 14.945.638 15.244.550 15.549.441 13.100.715 13.362.730 13.629.984 13.902.584 14.180.636 14.464.248 14.753.533 15.048.604 15.349.576 15.656.568 15.969.699 16.289.093 16.614.875 16.947.172 17.286.116 17.631.838 17.984.475 18.344.164 18.711.048

2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

1.591.520 Heffingseenheden 26.441 25.291 25.441 25.591 25.741 25.891 26.041 26.191 26.341 26.491 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641 26.641

Rioolheffing 29.391 Heffing Stijging per 1/1 per 31/12 € 190,00 7,9% € 205,00 7,1% € 219,56 7,1% € 235,14 7,1% € 251,84 7,1% € 269,72 7,1% € 288,87 7,1% € 309,38 7,1% € 331,34 7,1% € 354,87 7,1% € 380,07 7,1% € 407,05 2,0% € 415,19 2,0% € 423,50 2,0% € 431,97 2,0% € 440,60 2,0% € 449,42 2,0% € 458,41 2,0% € 467,57 2,0% € 476,92 2,0% € 486,46 2,0% € 496,19 2,0% € 506,12 2,0% € 516,24 2,0% € 526,56 2,0% € 537,09 -15,7% € 452,51 2,0% € 461,56 2,0% € 470,79 2,0% € 480,21 2,0% € 489,81 2,0% € 499,61 2,0% € 509,60 2,0% € 519,80 2,0% € 530,19 2,0% € 540,80 2,0% € 551,61 2,0% € 562,64 2,0% € 573,90 2,0% € 585,37 2,0% € 597,08 -15,7% € 503,05 2,0% € 513,11 2,0% € 523,38 2,0% € 533,84 2,0% € 544,52 2,0% € 555,41 2,0% € 566,52 2,0% € 577,85 2,0% € 589,41 2,0% € 601,20 2,0% € 613,22 2,0% € 625,48 2,0% € 637,99 2,0% € 650,75 2,0% € 663,77 2,0% € 677,04 2,0% € 690,58 2,0% € 704,40 2,0% € 718,48 2,0% €

€ 781.280.728 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.023.823 5.184.691 5.585.737 6.017.596 6.482.621 6.983.345 7.522.493 8.102.996 8.728.011 9.400.930 10.125.406 10.844.310 11.061.196 11.282.420 11.508.069 11.738.230 11.972.994 12.212.454 12.456.703 12.705.838 12.959.954 13.219.153 13.483.536 13.753.207 14.028.271 14.308.837 12.055.481 12.296.591 12.542.523 12.793.373 13.049.240 13.310.225 13.576.430 13.847.958 14.124.918 14.407.416 14.695.564 14.989.475 15.289.265 15.595.050 15.906.951 13.401.925 13.669.963 13.943.362 14.222.230 14.506.674 14.796.808 15.092.744 15.394.599 15.702.491 16.016.541 16.336.871 16.663.609 16.996.881 17.336.819 17.683.555 18.037.226 18.397.971 18.765.930 19.141.249

-2,25% € -17.554.433 Kwijtschelding € -108.000 € -116.526 € -125.540 € -135.246 € -145.697 € -156.951 € -169.069 € -182.115 € -196.163 € -211.287 € -227.569 € -243.727 € -248.601 € -253.573 € -258.645 € -263.818 € -269.094 € -274.476 € -279.965 € -285.565 € -291.276 € -297.101 € -303.044 € -309.104 € -315.286 € -321.592 € -270.948 € -276.367 € -281.894 € -287.532 € -293.283 € -299.148 € -305.131 € -311.234 € -317.459 € -323.808 € -330.284 € -336.890 € -343.627 € -350.500 € -357.510 € -301.209 € -307.233 € -313.378 € -319.646 € -326.039 € -332.559 € -339.211 € -345.995 € -352.915 € -359.973 € -367.172 € -374.516 € -382.006 € -389.646 € -397.439 € -405.388 € -413.496 € -421.766 € -430.201

€ 763.726.295 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 2 (vast prijspeil 2022)

Kostendekkingsplan Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer: 3010.5824

Wachtjaren 1 10

Periode 1 Periode 2

Financieringsmethode: IDEAAL COMPLEX

Stijgingsjaren 9 1

Dotatie begroting 2022 € 550.508,00 €

Stijgingspercentage 6,60% -26,50%

-1.345.508,00

LASTEN - vast prijspeil (2022) Spaarvoorzieni ng € 153.573.694 Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

Inflatie factor

1,0000 1,0900 1,1118 1,1340 1,1567 1,1799 1,2034 1,2275 1,2521 1,2771 1,3027 1,3287 1,3553 1,3824 1,4100 1,4382 1,4670 1,4963 1,5263 1,5568 1,5879 1,6197 1,6521 1,6851 1,7188 1,7532 1,7883 1,8240 1,8605 1,8977 1,9357 1,9744 2,0139 2,0541 2,0952 2,1371 2,1799 2,2235 2,2679 2,3133 2,3596 2,4068 2,4549 2,5040 2,5541 2,6052 2,6573 2,7104 2,7646 2,8199 2,8763 2,9338 2,9925 3,0524 3,1134 3,1757 3,2392 3,3040 3,3700 3,4375

Heffing eind € 334,30 (vanaf 2032) € 245,71 (vanaf 2043)

Heffing in startjaar: € 190,00

Heffing in eindjaar: € 200,26

v4.10

YAG€R

BATEN - vast prijspeil (2022)

€ 102.602.481

Dotatie

Kapitaallasten € 12.445.299 € 37.748.810 Oud, na BCF Nieuw

1.046.998 196.093 872.285 1.037.367 1.136.780 1.340.211 1.575.989 2.023.078 2.510.488 3.046.949 3.708.159 3.769.644 3.848.942 3.923.817 4.031.797 4.109.273 4.176.494 4.251.089 4.330.506 4.383.766 4.432.640 2.173.060 2.323.456 2.379.911 2.447.655 2.533.970 2.578.844 2.619.316 2.657.847 2.693.447 2.726.062 2.767.345 2.794.375 2.823.794 2.856.851 2.896.088 2.934.437 2.956.361 2.981.413 3.001.984 3.021.978 1.857.599 1.876.485 1.894.837 1.912.669 1.929.996 1.946.829 1.963.491 1.979.393 1.997.146 2.014.187 2.029.146 2.096.027 2.167.606 2.231.125 2.289.503 2.342.698 2.361.058 2.375.751 2.387.593

excl. BTW

908.750 840.393 811.872 770.011 733.370 684.030 646.954 608.451 583.390 558.749 491.641 470.611 444.106 420.216 367.955 339.916 319.389 291.829 259.367 247.631 238.648 229.922 144.462 135.926 116.706 80.864 77.864 75.079 71.805 69.199 66.668 54.154 52.161 47.632 39.551 25.831 12.325 11.888 8.373 8.081 7.798 7.523 7.255 6.995 6.743 6.498 6.260 6.028 5.804 5.354 4.597 4.422 4.252 -

Heffing start € 188,07 (in 2023) € 334,30 (in 2042)

242.913 489.552 731.152 959.074 1.167.935 1.229.854 1.273.146 1.305.624 1.309.757 1.279.972 1.240.943 1.202.952 1.165.973 1.129.983 1.094.955 1.060.867 1.027.694 995.414 964.006 933.446 894.612 856.490 819.724 784.231 750.145 719.482 690.913 664.097 639.673 618.069 597.724 577.939 558.700 539.994 521.806 504.124 486.935 470.226 453.985 438.200 422.860 407.953 393.467 379.393 365.720 352.180 339.263 325.041 311.715 299.526 244.423 189.519 137.024 88.777 44.815 29.641 17.498 7.712

Onze referentie: 1.9 - Datum: 11 januari 2023

BTW plichtig 1.592.872 1.767.783 1.727.014 1.683.666 1.715.776 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189 1.711.189

Exploitatie 1.536.662 € 2.752.621 Niet Overhead BTW plichtig € 986.662 € 46.199 € 550.000 € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872 € € 45.872

€

42.012.257

Loonkosten € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

604.000 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835 701.835

€ 352.671.825 SUBTOTAAL

€

excl. BTW

5.185.482 4.101.975 4.401.791 4.728.302 5.064.784 5.442.210 5.849.772 6.320.277 6.825.919 7.370.217 7.968.452 7.979.123 7.992.885 8.005.880 8.024.620 8.038.067 8.049.733 8.062.679 8.076.462 8.085.706 8.094.188 5.795.323 5.821.425 5.831.223 5.842.980 5.857.960 5.865.748 5.872.772 5.879.459 5.885.638 5.891.299 5.898.463 5.903.154 5.908.260 5.913.997 5.920.807 5.927.463 5.931.268 5.935.616 5.939.186 5.942.656 4.762.217 4.765.495 4.768.680 4.771.775 4.774.782 4.777.703 4.780.595 4.783.355 4.786.436 4.789.393 4.791.990 4.803.597 4.816.020 4.827.044 4.837.176 4.846.408 4.849.594 4.852.144 4.854.199

afschr + rente BTW compensatie 32.087.284 € 384.759.109 SUBTOTAAL BTW

Egalisatievoorziening Riolering (BBV 44.2) €

525.341 547.717 584.178 618.078 667.862 704.401 740.476 745.394 749.222 750.868 737.643 726.972 713.210 700.215 681.475 668.028 656.362 643.416 629.632 620.389 611.907 603.657 577.555 567.757 556.000 541.020 533.231 526.208 519.520 513.342 507.681 500.516 495.825 490.720 484.982 478.173 471.517 467.712 463.364 459.794 456.324 452.951 449.674 446.489 443.394 440.387 437.465 434.573 431.814 428.733 425.775 423.179 411.571 399.149 388.125 377.993 368.761 365.574 363.024 360.969

5.710.823 4.649.692 4.985.969 5.346.380 5.732.646 6.146.611 6.590.248 7.065.671 7.575.142 8.121.085 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169

€ 383.964.109

Dotatie

incl. BTW

-795.000

-795.000 -

TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

4.915.823 4.649.692 4.985.969 5.346.380 5.732.646 6.146.611 6.590.248 7.065.671 7.575.142 8.121.085 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 8.706.095 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 6.398.980 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169 5.215.169

Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

Rioolheffing 14.802 Heffing Stijging per 1/1 per 31/12 € 190,00 -1,0% € 188,07 6,6% € 200,49 6,6% € 213,72 6,6% € 227,82 6,6% € 242,86 6,6% € 258,89 6,6% € 275,98 6,6% € 294,19 6,6% € 313,61 6,6% € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 € 334,30 -26,5% € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 € 245,71 -18,5% € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 € 200,26 €

€ 392.787.118 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.023.823 4.756.597 5.100.605 5.469.303 5.864.450 6.287.933 6.741.770 7.228.123 7.749.308 8.307.803 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 8.906.264 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 6.546.104 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075 5.335.075

-2,25% -8.823.010 Kwijtschelding € -108.000 € -106.905 € -114.636 € -122.923 € -131.804 € -141.322 € -151.522 € -162.453 € -174.166 € -186.719 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -200.169 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -147.124 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 € -119.906 €

€ 383.964.109 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 2 (nominaal / inclusief inschatting inflatie)

Kostendekkingsplan - nominaal (inclusief inflatie) Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer: 3010.5824

Wachtjaren 1 10

Periode 1 Periode 2

Stijgingsjaren 9 1

Stijgingspercentage 6,60% -26,50%

Heffing start € 205,00 (in 2023) € 530,85 (in 2042)

Financieringsmethode: IDEAAL COMPLEX

Heffing in startjaar: € 190,00

LASTEN - nominaal Spaarvoorzieni ng € 306.157.292 Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

Inflatie € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

1.046.998 213.741 969.807 1.176.411 1.314.933 1.581.249 1.896.621 2.483.362 3.143.301 3.891.285 4.830.436 5.008.741 5.216.386 5.424.220 5.684.959 5.910.087 6.126.903 6.361.059 6.609.492 6.824.596 7.038.696 3.519.667 3.838.526 4.010.431 4.207.078 4.442.548 4.611.646 4.777.699 4.944.940 5.111.398 5.276.759 5.463.803 5.627.512 5.800.495 5.985.767 6.189.336 6.396.718 6.573.401 6.761.686 6.944.506 7.130.574 4.470.801 4.606.579 4.744.665 4.885.104 5.027.943 5.173.232 5.321.860 5.472.259 5.631.766 5.793.415 5.953.173 6.272.376 6.616.308 6.946.394 7.270.714 7.588.437 7.800.865 8.006.398 8.207.233

v4.10

YAG€R

Heffing in eindjaar: € 688,37

BATEN - nominaal

€

Dotatie

factor

Heffing eind € 435,48 (vanaf 2032) € 397,98 (vanaf 2043)

Kapitaallasten 16.347.767 € 64.965.893 na BCF Nieuw

excl. BTW

908.750 916.029 902.639 873.220 848.301 807.054 778.575 746.884 730.444 713.583 640.437 625.303 601.887 580.900 518.829 488.879 468.542 436.674 395.863 385.509 378.955 372.401 238.662 229.052 200.597 141.770 139.240 136.946 133.593 131.321 129.048 106.921 105.045 97.843 82.868 55.203 26.867 26.432 18.989 18.694 18.400 18.105 17.811 17.517 17.222 16.928 16.633 16.339 16.045 15.097 13.223 12.973 12.724 -

270.070 555.170 845.736 1.131.564 1.405.549 1.509.666 1.594.065 1.667.424 1.706.156 1.700.704 1.681.823 1.662.941 1.644.059 1.625.177 1.606.295 1.587.413 1.568.531 1.549.650 1.530.768 1.511.886 1.477.968 1.443.287 1.408.958 1.374.911 1.341.455 1.312.355 1.285.448 1.260.267 1.238.196 1.220.306 1.203.739 1.187.173 1.170.607 1.154.041 1.137.475 1.120.909 1.104.343 1.087.776 1.071.210 1.054.644 1.038.078 1.021.512 1.004.946 988.380 971.813 954.552 937.932 916.585 896.586 878.760 731.439 578.480 426.612 281.928 145.163 97.934 58.970 26.508

Onze referentie: 1.9 - Datum: 11 januari 2023

€ 208.374.901 BTW plichtig € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

1.592.872 1.926.883 1.920.094 1.909.337 1.984.666 2.018.948 2.059.327 2.100.513 2.142.523 2.185.374 2.229.081 2.273.663 2.319.136 2.365.519 2.412.829 2.461.086 2.510.308 2.560.514 2.611.724 2.663.959 2.717.238 2.771.582 2.827.014 2.883.554 2.941.225 3.000.050 3.060.051 3.121.252 3.183.677 3.247.351 3.312.298 3.378.544 3.446.114 3.515.037 3.585.337 3.657.044 3.730.185 3.804.789 3.880.885 3.958.502 4.037.672 4.118.426 4.200.794 4.284.810 4.370.506 4.457.916 4.547.075 4.638.016 4.730.777 4.825.392 4.921.900 5.020.338 5.120.745 5.223.160 5.327.623 5.434.175 5.542.859 5.653.716 5.766.790 5.882.126

Exploitatie 1.586.162 € 5.587.941 Niet Overhead BTW plichtig € 986.662 € 46.199 € 599.500 € 50.000 € € 51.000 € € 52.020 € € 53.060 € € 54.122 € € 55.204 € € 56.308 € € 57.434 € € 58.583 € € 59.755 € € 60.950 € € 62.169 € € 63.412 € € 64.680 € € 65.974 € € 67.293 € € 68.639 € € 70.012 € € 71.412 € € 72.841 € € 74.297 € € 75.783 € € 77.299 € € 78.845 € € 80.422 € € 82.030 € € 83.671 € € 85.344 € € 87.051 € € 88.792 € € 90.568 € € 92.379 € € 94.227 € € 96.112 € € 98.034 € € 99.994 € € 101.994 € € 104.034 € € 106.115 € € 108.237 € € 110.402 € € 112.610 € € 114.862 € € 117.159 € € 119.503 € € 121.893 € € 124.331 € € 126.817 € € 129.354 € € 131.941 € € 134.579 € € 137.271 € € 140.016 € € 142.817 € € 145.673 € € 148.587 € € 151.558 € € 154.589 € € 157.681

€

85.392.655

604.000 765.000 780.300 795.906 811.824 828.061 844.622 861.514 878.745 896.319 914.246 932.531 951.181 970.205 989.609 1.009.401 1.029.589 1.050.181 1.071.185 1.092.608 1.114.461 1.136.750 1.159.485 1.182.674 1.206.328 1.230.454 1.255.064 1.280.165 1.305.768 1.331.884 1.358.521 1.385.692 1.413.405 1.441.674 1.470.507 1.499.917 1.529.916 1.560.514 1.591.724 1.623.559 1.656.030 1.689.150 1.722.933 1.757.392 1.792.540 1.828.391 1.864.958 1.902.258 1.940.303 1.979.109 2.018.691 2.059.065 2.100.246 2.142.251 2.185.096 2.228.798 2.273.374 2.318.841 2.365.218 2.412.523

€ 688.412.611 TOTAAL

€

excl. BTW

5.185.482 4.471.153 4.893.911 5.362.065 5.858.520 6.420.997 7.039.897 7.758.248 8.546.511 9.412.568 10.380.111 10.601.892 10.832.581 11.067.197 11.314.965 11.560.603 11.808.930 12.064.481 12.326.807 12.587.733 12.852.957 9.386.584 9.617.438 9.826.297 10.043.032 10.270.156 10.489.486 10.712.088 10.938.771 11.169.272 11.403.614 11.645.832 11.888.196 12.136.448 12.391.198 12.653.575 12.921.155 13.188.039 13.461.660 13.739.152 14.022.123 11.461.529 11.698.806 11.940.757 12.187.477 12.439.061 12.695.605 12.957.355 13.224.132 13.497.303 13.775.756 14.058.888 14.374.801 14.700.216 15.028.542 15.361.288 15.698.419 16.022.915 16.351.967 16.686.071

afschr + rente BTW compensatie 60.834.598 € 749.247.209 TOTAAL BTW

Egalisatievoorziening Riolering (BBV 44.2) €

525.341 597.011 649.489 700.923 772.528 831.089 891.125 914.983 938.077 958.940 960.892 965.931 966.598 967.966 960.901 960.780 962.880 962.766 960.985 965.815 971.662 977.733 954.165 956.737 955.664 948.514 953.557 959.816 966.571 974.177 982.704 988.212 998.529 1.008.011 1.016.151 1.021.921 1.027.851 1.039.947 1.050.885 1.063.644 1.076.729 1.090.147 1.103.903 1.118.006 1.132.462 1.147.277 1.162.460 1.177.871 1.193.798 1.208.986 1.224.659 1.241.535 1.231.631 1.218.344 1.208.389 1.200.382 1.194.485 1.207.847 1.223.410 1.240.813

5.710.823 5.068.164 5.543.400 6.062.987 6.631.048 7.252.086 7.931.022 8.673.231 9.484.588 10.371.508 11.341.002 11.567.822 11.799.179 12.035.162 12.275.866 12.521.383 12.771.811 13.027.247 13.287.792 13.553.548 13.824.619 10.364.317 10.571.603 10.783.035 10.998.696 11.218.670 11.443.043 11.671.904 11.905.342 12.143.449 12.386.318 12.634.044 12.886.725 13.144.459 13.407.349 13.675.496 13.949.006 14.227.986 14.512.545 14.802.796 15.098.852 12.551.676 12.802.709 13.058.764 13.319.939 13.586.338 13.858.064 14.135.226 14.417.930 14.706.289 15.000.415 15.300.423 15.606.431 15.918.560 16.236.931 16.561.670 16.892.903 17.230.761 17.575.376 17.926.884

€ 748.452.209

Dotatie

incl. BTW

-795.000

-795.000 -

TOTAAL

Jaar

4.915.823 5.068.164 5.543.400 6.062.987 6.631.048 7.252.086 7.931.022 8.673.231 9.484.588 10.371.508 11.341.002 11.567.822 11.799.179 12.035.162 12.275.866 12.521.383 12.771.811 13.027.247 13.287.792 13.553.548 13.824.619 10.364.317 10.571.603 10.783.035 10.998.696 11.218.670 11.443.043 11.671.904 11.905.342 12.143.449 12.386.318 12.634.044 12.886.725 13.144.459 13.407.349 13.675.496 13.949.006 14.227.986 14.512.545 14.802.796 15.098.852 12.551.676 12.802.709 13.058.764 13.319.939 13.586.338 13.858.064 14.135.226 14.417.930 14.706.289 15.000.415 15.300.423 15.606.431 15.918.560 16.236.931 16.561.670 16.892.903 17.230.761 17.575.376 17.926.884

Rioolheffing 28.807 Heffing Stijging per 1/1 per 31/12 € 190,00 7,9% € 205,00 8,7% € 222,90 8,7% € 242,36 8,7% € 263,53 8,7% € 286,54 8,7% € 311,56 8,7% € 338,76 8,7% € 368,35 8,7% € 400,51 8,7% € 435,48 2,0% € 444,19 2,0% € 453,08 2,0% € 462,14 2,0% € 471,38 2,0% € 480,81 2,0% € 490,42 2,0% € 500,23 2,0% € 510,24 2,0% € 520,44 2,0% € 530,85 -25,0% € 397,98 2,0% € 405,94 2,0% € 414,06 2,0% € 422,34 2,0% € 430,78 2,0% € 439,40 2,0% € 448,19 2,0% € 457,15 2,0% € 466,30 2,0% € 475,62 2,0% € 485,13 2,0% € 494,84 2,0% € 504,73 2,0% € 514,83 2,0% € 525,12 2,0% € 535,63 2,0% € 546,34 2,0% € 557,27 2,0% € 568,41 2,0% € 579,78 -16,9% € 481,97 2,0% € 491,61 2,0% € 501,44 2,0% € 511,47 2,0% € 521,70 2,0% € 532,13 2,0% € 542,78 2,0% € 553,63 2,0% € 564,71 2,0% € 576,00 2,0% € 587,52 2,0% € 599,27 2,0% € 611,26 2,0% € 623,48 2,0% € 635,95 2,0% € 648,67 2,0% € 661,64 2,0% € 674,88 2,0% € 688,37 2,0% €

€ 765.655.463 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.023.823 5.184.691 5.670.853 6.202.386 6.783.508 7.418.825 8.113.370 8.872.644 9.702.656 10.609.968 11.601.753 11.833.788 12.070.463 12.311.873 12.558.110 12.809.272 13.065.458 13.326.767 13.593.302 13.865.168 14.142.472 10.602.611 10.814.663 11.030.957 11.251.576 11.476.607 11.706.139 11.940.262 12.179.067 12.422.649 12.671.102 12.924.524 13.183.014 13.446.675 13.715.608 13.989.920 14.269.719 14.555.113 14.846.215 15.143.140 15.446.002 12.840.262 13.097.067 13.359.008 13.626.188 13.898.712 14.176.686 14.460.220 14.749.425 15.044.413 15.345.301 15.652.207 15.965.252 16.284.557 16.610.248 16.942.453 17.281.302 17.626.928 17.979.466 18.339.056

-2,25% € -17.203.254 Kwijtschelding € -108.000 € -116.526 € -127.453 € -139.399 € -152.460 € -166.739 € -182.349 € -199.413 € -218.068 € -238.460 € -260.750 € -265.965 € -271.285 € -276.710 € -282.244 € -287.889 € -293.647 € -299.520 € -305.511 € -311.621 € -317.853 € -238.294 € -243.060 € -247.922 € -252.880 € -257.938 € -263.096 € -268.358 € -273.725 € -279.200 € -284.784 € -290.480 € -296.289 € -302.215 € -308.259 € -314.425 € -320.713 € -327.127 € -333.670 € -340.343 € -347.150 € -288.586 € -294.358 € -300.245 € -306.250 € -312.375 € -318.622 € -324.995 € -331.494 € -338.124 € -344.887 € -351.785 € -358.820 € -365.997 € -373.317 € -380.783 € -388.399 € -396.167 € -404.090 € -412.172

€ 748.452.209 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 3 (vast prijspeil 2022)

Kostendekkingsplan Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer: 3010.5824

Wachtjaren 1 14

Periode 1 Periode 2

Financieringsmethode: IDEAAL COMPLEX

Stijgingsjaren 5 1

Dotatie begroting 2022 € 550.508,00 €

Stijgingspercentage 10,25% -17,50%

-1.345.508,00

LASTEN - vast prijspeil (2022) Spaarvoorzieni ng € 153.131.471 Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

Inflatie factor

Heffing eind € 306,35 (vanaf 2028) € 252,74 (vanaf 2043)

Heffing in startjaar: € 190,00

Heffing in eindjaar: € 198,40

v4.10

YAG€R

BATEN - vast prijspeil (2022)

€ 102.602.481

Dotatie

Kapitaallasten € 12.445.299 € 37.191.633 Oud, na BCF Nieuw

1.046.998 196.093 1.043.006 1.418.139 1.772.873 2.283.574 2.886.105 2.966.175 3.031.955 3.087.576 3.203.857 3.232.965 3.279.888 3.329.749 3.412.711 3.469.020 3.505.178 3.559.960 3.618.386 3.656.315 3.692.362 2.328.888 2.465.138 2.516.445 2.584.837 2.671.326 2.715.807 2.753.204 2.790.084 2.825.639 2.859.734 2.904.272 2.934.594 2.966.783 3.002.545 3.044.172 3.087.091 3.112.235 3.140.567 3.163.686 3.185.881 1.792.581 1.814.560 1.834.312 1.852.416 1.870.007 1.887.100 1.904.016 1.920.165 1.938.037 1.955.165 1.970.272 2.035.762 2.104.914 2.164.702 2.218.348 2.265.134 2.275.964 2.285.856 2.296.349

excl. BTW

Heffing start € 188,07 (in 2023) € 306,35 (in 2042)

242.913 482.625 708.970 911.729 1.083.715 1.093.168 1.100.989 1.116.786 1.124.918 1.121.892 1.109.618 1.092.300 1.075.998 1.057.500 1.048.145 1.030.431 1.014.606 994.996 974.188 955.889 928.746 894.879 857.577 821.940 788.179 760.058 732.852 706.074 680.427 656.133 633.066 610.993 589.519 568.837 546.872 526.529 506.630 487.814 469.754 451.995 434.098 418.033 403.324 389.031 375.143 361.394 348.272 333.952 320.553 308.243 254.290 201.391 151.979 107.644 68.977 60.028 51.852 43.180

Onze referentie: 1.9 - Datum: 11 januari 2023

€

42.012.257

€ 351.672.424 SUBTOTAAL

€

excl. BTW

5.185.482 4.101.975 4.572.511 5.102.146 5.678.695 6.338.229 7.075.668 7.126.689 7.175.229 7.222.006 7.279.311 7.284.363 7.292.506 7.301.160 7.315.558 7.325.331 7.331.606 7.341.114 7.351.254 7.357.837 7.364.093 5.973.594 5.997.241 6.006.145 6.018.015 6.033.025 6.040.745 6.047.236 6.053.636 6.059.807 6.065.724 6.073.454 6.078.717 6.084.303 6.090.510 6.097.734 6.105.183 6.109.547 6.114.464 6.118.476 6.122.328 4.710.993 4.714.808 4.718.236 4.721.378 4.724.431 4.727.397 4.730.333 4.733.136 4.736.238 4.739.211 4.741.832 4.753.198 4.765.200 4.775.576 4.784.887 4.793.007 4.794.886 4.796.603 4.798.424

afschr + rente BTW compensatie 31.970.277 € 383.642.701 SUBTOTAAL BTW

Egalisatievoorziening Riolering (BBV 44.2) €

525.341 547.717 584.178 616.623 663.204 694.459 722.790 716.689 713.069 711.212 698.827 693.775 685.632 676.978 662.580 652.807 646.532 637.024 626.884 620.301 614.045 608.370 584.723 575.819 563.949 548.938 541.219 534.728 528.328 522.157 516.240 508.510 503.247 497.661 491.454 484.230 476.781 472.417 467.500 463.488 459.636 455.848 452.034 448.606 445.464 442.411 439.444 436.508 433.706 430.604 427.631 425.009 413.643 401.642 391.265 381.955 373.835 371.955 370.238 368.417

5.710.823 4.649.692 5.156.689 5.718.770 6.341.899 7.032.688 7.798.458 7.843.378 7.888.298 7.933.218 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842

€ 382.847.701

Dotatie

incl. BTW

-795.000

-795.000 -

4.915.823 4.649.692 5.156.689 5.718.770 6.341.899 7.032.688 7.798.458 7.843.378 7.888.298 7.933.218 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 7.978.138 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 6.581.964 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842 5.166.842

Rioolheffing 14.764 Heffing Stijging per 1/1 per 31/12 € 190,00 -1,0% € 188,07 10,3% € 207,35 10,3% € 228,60 10,3% € 252,04 10,3% € 277,87 10,3% € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 € 306,35 -17,5% € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 € 252,74 -21,5% € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 € 198,40 €

€ 391.645.043 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.023.823 4.756.597 5.275.251 5.850.255 6.487.711 7.194.382 7.977.759 8.023.712 8.069.664 8.115.617 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 8.161.570 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 6.733.295 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637 5.285.637

-2,25% -8.797.341 Kwijtschelding € -108.000 € -106.905 € -118.562 € -131.485 € -145.812 € -161.694 € -179.301 € -180.334 € -181.366 € -182.399 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -183.432 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -151.331 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 € -118.795 €

€ 382.847.701 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 3 (nominaal / inclusief inschatting inflatie)

Kostendekkingsplan - nominaal (inclusief inflatie) Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer: 3010.5824

Wachtjaren 1 14

Periode 1 Periode 2

Stijgingsjaren 5 1

Stijgingspercentage 10,25% -17,50%

Heffing start € 205,00 (in 2023) € 486,46 (in 2042)

Financieringsmethode: IDEAAL COMPLEX

Heffing in startjaar: € 190,00

LASTEN - nominaal Spaarvoorzieni ng € 303.887.449 Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

1.046.998 213.741 1.159.614 1.608.221 2.050.712 2.694.277 3.473.277 3.641.031 3.796.212 3.943.170 4.173.508 4.295.653 4.445.160 4.602.990 4.812.028 4.989.255 5.142.083 5.326.897 5.522.609 5.692.109 5.863.190 3.772.059 4.072.596 4.240.507 4.442.870 4.683.360 4.856.571 5.021.915 5.190.969 5.362.261 5.535.503 5.734.149 5.909.897 6.094.216 6.291.028 6.505.812 6.729.487 6.919.984 7.122.638 7.318.572 7.517.316 4.314.318 4.454.561 4.593.112 4.731.212 4.871.665 5.014.517 5.160.658 5.308.517 5.465.083 5.623.652 5.780.446 6.092.032 6.424.950 6.739.595 7.044.747 7.337.193 7.519.716 7.703.449 7.893.586

v4.10

YAG€R

Heffing in eindjaar: € 681,99

BATEN - nominaal

€

Dotatie

factor

Heffing eind € 368,68 (vanaf 2028) € 409,36 (vanaf 2043)

Kapitaallasten 16.347.767 € 65.129.722 na BCF Nieuw

excl. BTW

270.070 547.314 820.078 1.075.705 1.304.195 1.341.882 1.378.513 1.426.258 1.465.375 1.490.662 1.503.841 1.509.977 1.517.190 1.520.930 1.537.625 1.541.871 1.548.555 1.548.998 1.546.937 1.548.236 1.534.360 1.507.976 1.474.020 1.441.023 1.409.470 1.386.364 1.363.476 1.339.928 1.317.083 1.295.458 1.274.915 1.255.071 1.235.180 1.215.682 1.192.116 1.170.725 1.149.009 1.128.464 1.108.419 1.087.844 1.065.665 1.046.754 1.030.120 1.013.487 996.853 979.524 962.839 941.714 922.008 904.333 760.965 614.718 473.172 341.842 223.431 198.330 174.743 148.430

Onze referentie: 1.9 - Datum: 11 januari 2023

€

85.392.655

€ 686.306.597 TOTAAL

€

excl. BTW

5.185.482 4.471.153 5.083.718 5.786.018 6.568.641 7.478.166 8.515.199 8.748.132 8.983.870 9.223.287 9.482.401 9.678.761 9.883.374 10.093.004 10.315.166 10.535.525 10.755.441 10.984.776 11.219.948 11.454.595 11.693.621 9.675.327 9.907.899 10.121.063 10.343.885 10.577.080 10.802.426 11.030.313 11.262.828 11.499.795 11.741.245 11.991.331 12.241.756 12.498.067 12.761.032 13.031.693 13.308.564 13.584.438 13.867.278 14.153.906 14.446.073 11.338.246 11.574.375 11.814.446 12.058.760 12.307.889 12.561.929 12.821.126 13.085.296 13.355.749 13.631.414 13.911.735 14.223.982 14.545.095 14.868.303 15.195.236 15.525.443 15.842.161 16.164.790 16.494.346

afschr + rente BTW compensatie 60.869.002 € 747.175.598 TOTAAL BTW

Egalisatievoorziening Riolering (BBV 44.2) €

525.341 597.011 649.489 699.273 767.139 819.358 869.840 879.749 892.811 908.295 910.328 921.822 929.221 935.843 934.258 938.888 948.460 953.202 956.790 965.678 975.057 985.366 966.007 970.322 969.327 962.397 967.840 975.358 982.957 990.906 999.270 1.003.994 1.013.476 1.022.270 1.029.711 1.034.865 1.039.325 1.050.409 1.060.265 1.072.189 1.084.543 1.097.119 1.109.697 1.123.307 1.137.748 1.152.549 1.167.718 1.183.115 1.199.029 1.214.263 1.229.997 1.246.905 1.237.831 1.225.954 1.218.167 1.212.964 1.210.921 1.228.930 1.247.722 1.266.417

5.710.823 5.068.164 5.733.207 6.485.291 7.335.781 8.297.524 9.385.039 9.627.880 9.876.681 10.131.582 10.392.729 10.600.583 10.812.595 11.028.847 11.249.424 11.474.412 11.703.901 11.937.979 12.176.738 12.420.273 12.668.678 10.660.693 10.873.907 11.091.385 11.313.212 11.539.477 11.770.266 12.005.672 12.245.785 12.490.701 12.740.515 12.995.325 13.255.232 13.520.336 13.790.743 14.066.558 14.347.889 14.634.847 14.927.544 15.226.094 15.530.616 12.435.365 12.684.072 12.937.753 13.196.508 13.460.438 13.729.647 14.004.240 14.284.325 14.570.012 14.861.412 15.158.640 15.461.813 15.771.049 16.086.470 16.408.199 16.736.363 17.071.091 17.412.512 17.760.763

€ 746.380.598

Dotatie

incl. BTW

-795.000

-795.000 -

TOTAAL

Jaar

4.915.823 5.068.164 5.733.207 6.485.291 7.335.781 8.297.524 9.385.039 9.627.880 9.876.681 10.131.582 10.392.729 10.600.583 10.812.595 11.028.847 11.249.424 11.474.412 11.703.901 11.937.979 12.176.738 12.420.273 12.668.678 10.660.693 10.873.907 11.091.385 11.313.212 11.539.477 11.770.266 12.005.672 12.245.785 12.490.701 12.740.515 12.995.325 13.255.232 13.520.336 13.790.743 14.066.558 14.347.889 14.634.847 14.927.544 15.226.094 15.530.616 12.435.365 12.684.072 12.937.753 13.196.508 13.460.438 13.729.647 14.004.240 14.284.325 14.570.012 14.861.412 15.158.640 15.461.813 15.771.049 16.086.470 16.408.199 16.736.363 17.071.091 17.412.512 17.760.763

Rioolheffing 28.733 Heffing Stijging per 1/1 per 31/12 € 190,00 7,9% € 205,00 12,5% € 230,53 12,5% € 259,25 12,5% € 291,53 12,5% € 327,85 12,5% € 368,68 2,0% € 376,05 2,0% € 383,57 2,0% € 391,24 2,0% € 399,07 2,0% € 407,05 2,0% € 415,19 2,0% € 423,50 2,0% € 431,97 2,0% € 440,60 2,0% € 449,42 2,0% € 458,41 2,0% € 467,57 2,0% € 476,92 2,0% € 486,46 -15,9% € 409,36 2,0% € 417,55 2,0% € 425,90 2,0% € 434,41 2,0% € 443,10 2,0% € 451,97 2,0% € 461,00 2,0% € 470,22 2,0% € 479,63 2,0% € 489,22 2,0% € 499,01 2,0% € 508,99 2,0% € 519,17 2,0% € 529,55 2,0% € 540,14 2,0% € 550,94 2,0% € 561,96 2,0% € 573,20 2,0% € 584,67 2,0% € 596,36 -19,9% € 477,50 2,0% € 487,05 2,0% € 496,80 2,0% € 506,73 2,0% € 516,87 2,0% € 527,20 2,0% € 537,75 2,0% € 548,50 2,0% € 559,47 2,0% € 570,66 2,0% € 582,08 2,0% € 593,72 2,0% € 605,59 2,0% € 617,70 2,0% € 630,06 2,0% € 642,66 2,0% € 655,51 2,0% € 668,62 2,0% € 681,99 2,0% €

€ 763.536.222 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

5.023.823 5.184.691 5.865.024 6.634.399 7.504.444 8.488.299 9.600.819 9.849.243 10.103.764 10.364.526 10.631.676 10.844.310 11.061.196 11.282.420 11.508.069 11.738.230 11.972.994 12.212.454 12.456.703 12.705.838 12.959.954 10.905.802 11.123.918 11.346.396 11.573.324 11.804.790 12.040.886 12.281.704 12.527.338 12.777.885 13.033.442 13.294.111 13.559.993 13.831.193 14.107.817 14.389.973 14.677.773 14.971.328 15.270.755 15.576.170 15.887.693 12.721.276 12.975.702 13.235.216 13.499.920 13.769.918 14.045.317 14.326.223 14.612.748 14.905.003 15.203.103 15.507.165 15.817.308 16.133.654 16.456.327 16.785.454 17.121.163 17.463.586 17.812.858 18.169.115

-2,25% € -17.155.624 Kwijtschelding € -108.000 € -116.526 € -131.817 € -149.109 € -168.663 € -190.775 € -215.779 € -221.362 € -227.083 € -232.943 € -238.948 € -243.727 € -248.601 € -253.573 € -258.645 € -263.818 € -269.094 € -274.476 € -279.965 € -285.565 € -291.276 € -245.109 € -250.011 € -255.011 € -260.111 € -265.314 € -270.620 € -276.032 € -281.553 € -287.184 € -292.928 € -298.786 € -304.762 € -310.857 € -317.074 € -323.416 € -329.884 € -336.482 € -343.211 € -350.076 € -357.077 € -285.912 € -291.630 € -297.462 € -303.412 € -309.480 € -315.670 € -321.983 € -328.423 € -334.991 € -341.691 € -348.525 € -355.495 € -362.605 € -369.857 € -377.254 € -384.799 € -392.495 € -400.345 € -408.352

€ 746.380.598 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Verloop voorziening(en)

Onze referentie: 1.9 - Datum: 11 januari 2023

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 1

Overzicht Egalisatievoorziening riolering (BBV 44.2) Jaarrente (positief): Rentemoment: Rente vanuit vorig jaar: Rente in huidig jaar:

30105824

VAST PRIJSPEIL (2022) € Jaar 2022 2023 2024 2025 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 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

Inflatie factor 1,0000 1,0900 1,1118 1,1340 1,1567 1,1799 1,2034 1,2275 1,2521 1,2771 1,3027 1,3287 1,3553 1,3824 1,4100 1,4382 1,4670 1,4963 1,5263 1,5568 1,5879 1,6197 1,6521 1,6851 1,7188 1,7532 1,7883 1,8240 1,8605 1,8977 1,9357 1,9744 2,0139 2,0541 2,0952 2,1371 2,1799 2,2235 2,2679 2,3133 2,3596 2,4068 2,4549 2,5040 2,5541 2,6052 2,6573 2,7104 2,7646 2,8199 2,8763 2,9338 2,9925 3,0524 3,1134 3,1757 3,2392 3,3040 3,3700 3,4375

Afwaardering

795.000 -

YAG€R

begin volg.jaar (saldo 1/1) 100% -

maximum: € minimum: €

(in 2022)

maximum: € minimum: €

(in 2022)

eind: €

(in 2081)

eind: €

(in 2081)

NOMINAAL €

€

-795.000 Dotatie

Rente

Saldo 1/1

t.b.v. vast prijspeil

€ € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

v4.10

nominaal

Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer:

Onze referentie: 1.9 - Datum: 11 januari 2023

-795.000 -

Saldo 31/12 € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

Saldo 1/1 nominaal 795.000 € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

Rente nominaal € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

€

-795.000 Dotatie

-795.000 -

Saldo 31/12 nominaal € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

(in 2022)

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - VAST PRIJSPEIL (2022) Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer:

Jaarrente (restinv.): Jaarrente (positief): Rentemoment: Rente vanuit vorig jaar: Rente in huidig jaar:

30105824

nominaal 2,0% begin volg.jaar (saldo 1/1) 100% -

v4.10

YAG€R

Dotaties

Saldo

€ €

3.607.279 196.093

maximum minimum

(in 2047) (in 2023)

€ €

4.375.148 -

(in 2023)

(in 2023) (in 2081)

← Vorig deel Volgend deel →

De tekst is automatisch uit het bestand gehaald en kan afwijken van het origineel (kolommen, tabellen en koppen lopen door elkaar). Het officiële stuk bij de gemeente is leidend. Bron: https://api.notubiz.nl/document/14643108/1