Document · PDF

Kostendekkingsplan PWR gemeente Heiloo 2023.pdf

Raadsvergadering 26 juni 2023, gemeente HeilooBij agendapunt: Programma Water en Riolering Bergen Uitgeest Castricum Heiloo 2023-202642.765 woorden

Open het PDF bij de gemeente ↗Naar de vergadering →

Tekst van het document

Uit het bestand gehaald, zonder opmaak, tabellen en afbeeldingen · deel 3 van 4

€ 520.056.630 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

2.299.512 2.413.655 2.530.619 2.670.014 2.748.593 2.829.693 2.908.750 2.987.930 3.066.296 3.139.887 3.215.244 3.292.410 3.371.428 3.452.342 3.627.530 3.811.608 4.005.027 4.208.261 4.309.259 4.412.681 4.518.586 4.627.032 4.738.080 4.851.794 4.968.237 5.087.475 5.209.574 5.334.604 5.462.635 5.593.738 5.727.988 5.865.459 6.006.230 6.150.380 6.297.989 6.449.141 6.603.920 6.762.414 6.924.712 7.090.905 7.261.087 7.435.353 7.613.802 7.796.533 7.983.650 8.175.257 8.371.463 8.572.378 8.778.116 8.988.790 9.204.521 9.425.430 9.651.640 9.883.280 10.120.478 10.363.370 10.612.091 10.866.781 11.127.583 11.394.645 11.189.253 10.987.562 10.789.507 10.595.022 10.404.043 10.216.506 10.032.350 9.851.513 9.673.936 9.906.110 10.143.857 10.387.310 10.636.605 10.891.884 11.153.289

KOSTENDEKKINGSPLAN

Variant C (duurzaam financieren, huidig) vast prijspeil 2023

Kostendekkingsplan Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: -

Stijgingsjaren 15 15

Periode 1 Periode 2

Stijgingspercentage 1,97% -2,04%

Financieringsmethode: IDEAAL COMPLEX LASTEN - vast prijspeil (2023) Spaarvoorzieni ng € 89.724.852

Jaar

Inflatie

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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

1,0000 1,0240 1,0486 1,0737 1,0995 1,1259 1,1529 1,1806 1,2089 1,2379 1,2677 1,2981 1,3292 1,3611 1,3938 1,4272 1,4615 1,4966 1,5325 1,5693 1,6069 1,6455 1,6850 1,7254 1,7668 1,8093 1,8527 1,8971 1,9427 1,9893 2,0370 2,0859 2,1360 2,1873 2,2397 2,2935 2,3485 2,4049 2,4626 2,5217 2,5822 2,6442 2,7077 2,7727 2,8392 2,9074 2,9771 3,0486 3,1217 3,1967 3,2734 3,3520 3,4324 3,5148 3,5991 3,6855 3,7740 3,8645 3,9573 4,0523 4,1495 4,2491 4,3511 4,4555 4,5624 4,6719 4,7841 4,8989 5,0165 5,1369 5,2601 5,3864 5,5157 5,6480 5,7836

factor

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

Heffing eind € 276,11 (vanaf 2038) € 202,71 (vanaf 2063)

Heffing in startjaar: € 206,00

Heffing in eindjaar: € 135,65

v4.10

YAG€R

BATEN - vast prijspeil (2023)

Kapitaallasten € 17.305.785 € 1.477.455

€ 31.034.007

Exploitatie € 22.088.075

€ 19.891.118

€ 181.521.293

Dotatie

Oud, na BCF

BTW plichtig

Overhead

Loonkosten

SUBTOTAAL

248.044 334.608 375.946 439.950 634.640 709.429 810.571 894.333 929.828 1.060.095 1.111.836 1.242.538 1.328.840 1.369.740 1.520.748 1.600.475 1.623.008 1.644.762 1.620.195 1.688.336 1.706.116 1.725.994 1.742.486 1.741.103 1.775.758 1.787.634 1.714.025 1.690.855 1.622.637 1.593.566 1.547.348 1.501.102 1.454.775 1.395.631 1.345.097 1.330.675 1.286.943 1.243.981 1.185.832 1.164.752 1.124.373 1.133.436 1.113.884 1.138.002 1.175.377 1.185.891 1.197.783 1.221.307 1.205.071 1.230.191 1.207.340 1.236.589 1.253.324 1.243.635 1.264.246 1.275.879 1.280.734 1.281.496 1.236.571 1.282.873 1.283.188 1.283.495 1.286.232 1.269.620 1.291.385 1.164.139 1.014.712 926.240 797.652 713.415 615.595 523.230 523.230 503.870 496.610

Nieuw

excl. BTW

827.132 796.550 766.947 736.362 703.870 677.421 651.826 626.523 602.588 578.371 556.031 534.419 509.503 483.151 463.871 445.550 427.676 410.554 393.787 376.174 360.110 344.663 330.384 314.687 301.059 288.305 274.595 262.346 250.442 239.278 227.354 216.505 206.749 192.587 182.317 171.169 163.198 155.507 145.265 137.285 130.119 122.323 116.206 102.018 86.941 78.138 68.234 48.763 46.255 41.571 38.550 36.479 22.753 14.936 14.116 4.712 958 602 -

Heffing start € 206,00 (in 2023) € 276,11 (in 2048)

11.276 22.640 32.444 44.397 44.237 47.479 48.289 47.157 46.052 44.972 43.918 42.889 41.884 40.902 39.943 36.960 33.983 31.310 28.793 27.999 26.908 26.074 25.463 24.866 24.283 23.714 23.159 22.616 22.086 21.568 21.063 20.569 20.087 19.616 19.156 18.707 18.269 17.841 17.423 17.014 16.615 16.226 15.846 15.474 15.112 14.757 14.412 14.074 13.744 13.422 13.107 12.800 12.500 12.207 11.921 11.642 11.369 11.102 10.842 10.588 8.326 6.055 4.068 1.522 1.315 403 -

Onze referentie: 01 - Datum: 3 februari 2023

492.418 490.418 512.418 530.418 439.918 441.918 431.500 431.500 471.500 431.500 455.500 414.500 414.500 454.500 397.500 399.500 397.500 397.500 435.500 397.500 399.500 397.500 397.500 413.500 397.500 399.500 419.500 397.500 413.500 397.500 397.500 397.500 397.500 413.500 419.500 397.500 397.500 397.500 413.500 397.500 397.500 397.500 419.500 413.500 397.500 397.500 397.500 397.500 413.500 397.500 419.500 397.500 397.500 413.500 397.500 397.500 397.500 397.500 435.500 397.500 397.500 397.500 397.500 413.500 397.500 397.500 419.500 397.500 413.500 397.500 397.500 397.500 397.500 413.500 419.500

294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508 294.508

265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215 265.215

€

BTW

excl. BTW

2.127.316 2.181.298 2.226.310 2.289.093 2.370.594 2.432.888 2.497.856 2.559.557 2.611.927 2.676.846 2.729.141 2.796.152 2.856.484 2.910.003 2.983.725 3.046.149 3.047.851 3.049.499 3.043.188 3.053.043 3.054.242 3.055.879 3.057.001 3.055.087 3.059.502 3.060.028 2.992.126 2.934.138 2.869.460 2.812.683 2.754.010 2.696.398 2.639.810 2.582.010 2.526.724 2.478.683 2.426.519 2.375.418 2.322.589 2.277.099 2.229.137 2.229.996 2.225.928 2.229.468 2.235.386 2.236.726 2.238.352 2.242.050 2.238.960 2.243.059 2.238.857 2.243.713 2.246.407 2.244.594 2.248.084 2.250.021 2.250.836 2.250.962 2.243.162 2.251.198 2.251.253 2.251.306 2.251.781 2.248.898 2.252.675 2.122.884 1.995.250 1.883.866 1.770.875 1.670.638 1.572.818 1.480.453 1.480.453 1.477.093 1.475.833

afschrijvingen BTW compensatie 8.664.286 € 190.185.579

172.196 170.164 175.578 179.801 160.340 161.837 158.216 157.417 164.655 154.494 158.037 147.965 145.695 151.383 138.035 137.177 135.475 133.826 140.138 130.282 129.084 127.446 126.324 128.239 123.823 123.297 126.282 120.677 123.058 118.809 117.700 116.750 115.969 117.571 117.804 111.915 111.249 110.598 112.729 108.556 107.868 107.008 111.076 107.536 101.618 100.279 98.653 94.954 98.045 93.946 98.148 93.292 90.598 92.411 88.920 86.984 86.169 86.042 93.842 85.806 85.752 85.698 85.224 88.107 84.329 83.795 88.371 83.560 86.835 83.475 83.475 83.475 83.475 86.835 88.095

Egalisatievoorz iening riolering € 190.185.579

SUBTOTAAL

TOTAAL

incl. BTW

2.299.512 2.351.463 2.401.888 2.468.894 2.530.934 2.594.725 2.656.072 2.716.974 2.776.583 2.831.340 2.887.178 2.944.117 3.002.179 3.061.386 3.121.760 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.183.326 3.118.408 3.054.815 2.992.518 2.931.492 2.871.710 2.813.147 2.755.779 2.699.580 2.644.528 2.590.598 2.537.768 2.486.016 2.435.318 2.385.655 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.337.004 2.206.679 2.083.621 1.967.426 1.857.710 1.754.113 1.656.293 1.563.928 1.563.928 1.563.928 1.563.928

889.905 Jaar

Heffingseenheden

11.510 11.542 11.562 11.654 11.716 11.779 11.824 11.862 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887

€

Rioolheffing 16.526 Heffing per 1/1

206,00 210,06 214,21 218,43 222,74 227,13 231,61 236,18 240,83 245,58 250,43 255,37 260,40 265,54 270,77 276,11 276,11 276,11 276,11 276,11 276,11 276,11 276,11 276,11 276,11 276,11 270,48 264,97 259,56 254,27 249,09 244,01 239,03 234,16 229,38 224,70 220,12 215,63 211,23 206,93 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 202,71 191,40 180,73 170,65 161,13 152,15 143,66 135,65 135,65 135,65 135,65

Stijging per 31/12 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% 2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -2,0% -5,6% -5,6% -5,6% -5,6% -5,6% -5,6% -5,6% -

€ 196.098.096

€

2.371.000 2.424.565 2.476.558 2.545.647 2.609.616 2.675.390 2.738.644 2.801.440 2.862.901 2.919.361 2.976.935 3.035.644 3.095.511 3.156.559 3.218.810 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.282.289 3.215.354 3.149.783 3.085.550 3.022.626 2.960.986 2.900.603 2.841.451 2.783.505 2.726.741 2.671.135 2.616.663 2.563.301 2.511.028 2.459.821 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.409.658 2.275.280 2.148.397 2.028.589 1.915.463 1.808.645 1.707.784 1.612.547 1.612.547 1.612.547 1.612.547

€ 190.185.579

Kwijtschelding

SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

-3,02% -5.912.518

-71.488 -73.103 -74.670 -76.753 -78.682 -80.665 -82.572 -84.466 -86.319 -88.021 -89.757 -91.527 -93.332 -95.173 -97.050 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -98.964 -96.946 -94.969 -93.032 -91.135 -89.276 -87.456 -85.672 -83.925 -82.213 -80.537 -78.895 -77.286 -75.710 -74.166 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -72.653 -68.602 -64.776 -61.164 -57.753 -54.532 -51.491 -48.620 -48.620 -48.620 -48.620

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

KOSTENDEKKINGSPLAN

Variant C (duurzaam financieren, huidig) inclusief 2,4% indexatie

Kostendekkingsplan - nominaal (inclusief inflatie) Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: -

Stijgingsjaren 15 15

Periode 1 Periode 2

Stijgingspercentage 1,97% -2,04%

Heffing start € 206,00 (in 2023) € 499,56 (in 2048)

Financieringsmethode: IDEAAL COMPLEX

Heffing in startjaar: € 206,00

LASTEN - nominaal Spaarvoorzieni ng € 234.203.806 Jaar 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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

Inflatie factor

v4.10

YAG€R

Heffing eind € 394,08 (vanaf 2038) € 523,44 (vanaf 2063)

Heffing in eindjaar: € 784,55

BATEN - nominaal

€ 83.681.582

Exploitatie € 60.403.358

€ 54.395.429

Dotatie

Kapitaallasten € 26.280.023 € 2.900.180 na BCF Nieuw

BTW plichtig

Overhead

Loonkosten

248.044 342.639 394.208 472.393 697.794 798.747 934.525 1.055.842 1.124.093 1.312.335 1.409.420 1.612.907 1.766.332 1.864.393 2.119.614 2.284.274 2.372.029 2.461.515 2.482.942 2.649.465 2.741.623 2.840.131 2.936.083 3.004.163 3.137.493 3.234.280 3.175.528 3.207.785 3.152.247 3.170.070 3.152.003 3.131.186 3.107.381 3.052.595 3.012.674 3.051.902 3.022.440 2.991.659 2.920.260 2.937.187 2.903.411 2.997.059 3.016.047 3.155.303 3.337.148 3.447.807 3.565.957 3.723.256 3.761.928 3.932.516 3.952.096 4.144.988 4.301.909 4.371.100 4.550.188 4.702.265 4.833.442 4.952.389 4.893.465 5.198.537 5.324.609 5.453.706 5.596.501 5.656.804 5.891.866 5.438.788 4.854.448 4.537.544 4.001.388 3.664.707 3.238.113 2.818.315 2.885.955 2.845.872 2.872.184

excl. BTW

827.132 815.667 804.202 790.663 773.913 762.709 751.504 739.667 728.485 715.989 704.852 693.716 677.246 657.632 646.541 635.910 625.050 614.426 603.476 590.320 578.674 567.145 556.697 542.973 531.925 521.616 508.735 497.706 486.525 475.994 463.128 451.612 441.613 421.236 408.344 392.576 383.277 373.980 357.734 346.195 336.000 323.451 314.650 282.862 246.843 227.174 203.143 148.658 144.396 132.888 126.189 122.275 78.096 52.495 50.804 17.367 3.617 2.328 -

11.824 24.309 35.673 49.987 51.002 56.053 58.377 58.377 58.377 58.377 58.377 58.377 58.377 58.377 58.377 55.314 52.079 49.135 46.268 46.073 45.340 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 44.989 36.229 26.978 18.559 7.112 6.292 1.974 -

Onze referentie: 01 - Datum: 3 februari 2023

492.418 502.188 537.309 569.532 483.695 497.555 497.486 509.425 570.009 534.171 577.415 538.052 550.965 618.633 554.034 570.185 580.947 594.890 667.402 623.787 641.972 654.088 669.786 713.468 702.322 722.796 777.197 754.112 803.294 790.744 809.722 829.155 849.055 904.428 939.573 911.666 933.546 955.951 1.018.296 1.002.387 1.026.444 1.051.079 1.135.874 1.146.499 1.128.587 1.155.674 1.183.410 1.211.812 1.290.843 1.270.677 1.373.187 1.332.401 1.364.379 1.453.360 1.430.655 1.464.990 1.500.150 1.536.154 1.723.398 1.610.774 1.649.432 1.689.019 1.729.555 1.842.353 1.813.570 1.857.096 2.006.916 1.947.306 2.074.305 2.041.898 2.090.904 2.141.086 2.192.472 2.335.460 2.426.212

294.508 301.576 308.814 316.225 323.815 331.586 339.544 347.693 356.038 364.583 373.333 382.293 391.468 400.863 410.484 420.335 430.423 440.754 451.332 462.164 473.256 484.614 496.244 508.154 520.350 532.838 545.627 558.722 572.131 585.862 599.923 614.321 629.065 644.162 659.622 675.453 691.664 708.264 725.262 742.668 760.492 778.744 797.434 816.572 836.170 856.238 876.788 897.831 919.379 941.444 964.039 987.176 1.010.868 1.035.129 1.059.972 1.085.411 1.111.461 1.138.136 1.165.451 1.193.422 1.222.064 1.251.394 1.281.427 1.312.181 1.343.674 1.375.922 1.408.944 1.442.759 1.477.385 1.512.842 1.549.150 1.586.330 1.624.402 1.663.388 1.703.309

265.215 271.580 278.098 284.772 291.607 298.605 305.772 313.111 320.625 328.320 336.200 344.269 352.531 360.992 369.656 378.527 387.612 396.915 406.441 416.195 426.184 436.412 446.886 457.612 468.594 479.840 491.357 503.149 515.225 527.590 540.252 553.218 566.496 580.092 594.014 608.270 622.869 637.817 653.125 668.800 684.851 701.288 718.118 735.353 753.002 771.074 789.580 808.530 827.934 847.805 868.152 888.988 910.323 932.171 954.543 977.452 1.000.911 1.024.933 1.049.531 1.074.720 1.100.513 1.126.926 1.153.972 1.181.667 1.210.027 1.239.068 1.268.806 1.299.257 1.330.439 1.362.370 1.395.066 1.428.548 1.462.833 1.497.941 1.533.892

€ 461.864.378 TOTAAL excl. BTW

€ 2.127.316 € 2.233.650 € 2.334.455 € 2.457.895 € 2.606.496 € 2.739.189 € 2.879.832 € 3.021.791 € 3.157.626 € 3.313.775 € 3.459.597 € 3.629.613 € 3.796.919 € 3.960.890 € 4.158.706 € 4.347.609 € 4.454.439 € 4.563.813 € 4.663.671 € 4.791.065 € 4.907.977 € 5.028.463 € 5.151.037 € 5.271.359 € 5.405.673 € 5.536.361 € 5.543.433 € 5.566.463 € 5.574.411 € 5.595.250 € 5.610.017 € 5.624.483 € 5.638.599 € 5.647.503 € 5.659.216 € 5.684.855 € 5.698.784 € 5.712.660 € 5.719.666 € 5.742.226 € 5.756.188 € 5.896.609 € 6.027.113 € 6.181.579 € 6.346.740 € 6.502.956 € 6.663.867 € 6.835.075 € 6.989.469 € 7.170.319 € 7.328.653 € 7.520.817 € 7.710.563 € 7.889.245 € 8.091.150 € 8.292.475 € 8.494.570 € 8.698.929 € 8.876.835 € 9.122.443 € 9.341.608 € 9.566.033 € 9.797.684 € 10.019.984 € 10.277.697 € 9.917.986 € 9.545.406 € 9.228.839 € 8.883.517 € 8.581.817 € 8.273.234 € 7.974.279 € 8.165.662 € 8.342.660 € 8.535.597

afschrijvingen BTW compensatie € 21.179.570 € 483.043.948 TOTAAL BTW

Egalisatievoorz iening riolering € 483.043.948

incl. BTW

172.196 174.248 184.107 193.060 176.295 182.212 182.410 185.846 199.056 191.255 200.336 192.070 193.661 206.052 192.393 195.785 197.997 200.281 214.761 204.449 207.430 209.714 212.856 221.267 218.776 223.076 233.959 228.941 239.060 236.346 239.759 243.531 247.709 257.156 263.852 256.678 261.272 265.977 277.611 273.748 278.542 282.954 300.760 298.163 288.516 291.545 293.703 289.476 306.072 300.314 321.276 312.710 310.968 324.803 320.035 320.579 325.197 332.512 371.361 347.710 355.829 364.142 370.815 392.560 384.747 391.484 422.774 409.349 435.604 428.799 439.090 449.628 460.419 490.447 509.505

2.299.512 2.407.898 2.518.562 2.650.955 2.782.791 2.921.401 3.062.242 3.207.637 3.356.682 3.505.030 3.659.933 3.821.682 3.990.580 4.166.942 4.351.099 4.543.394 4.652.435 4.764.094 4.878.432 4.995.515 5.115.407 5.238.177 5.363.893 5.492.626 5.624.449 5.759.436 5.777.392 5.795.403 5.813.471 5.831.595 5.849.776 5.868.013 5.886.308 5.904.659 5.923.067 5.941.533 5.960.057 5.978.638 5.997.277 6.015.974 6.034.730 6.179.563 6.327.873 6.479.741 6.635.255 6.794.501 6.957.569 7.124.551 7.295.540 7.470.633 7.649.928 7.833.527 8.021.531 8.214.048 8.411.185 8.613.054 8.819.767 9.031.441 9.248.196 9.470.153 9.697.436 9.930.175 10.168.499 10.412.543 10.662.444 10.309.469 9.968.180 9.638.188 9.319.121 9.010.616 8.712.324 8.423.907 8.626.081 8.833.107 9.045.101

TOTAAL

Jaar

889.905 Heffingseenheden 11.510 11.542 11.562 11.654 11.716 11.779 11.824 11.862 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887 11.887

Rioolheffing 41.930 Heffing Stijging per 1/1 per 31/12 € 206,00 4,4% € 215,10 4,4% € 224,61 4,4% € 234,54 4,4% € 244,90 4,4% € 255,73 4,4% € 267,03 4,4% € 278,83 4,4% € 291,15 4,4% € 304,02 4,4% € 317,45 4,4% € 331,48 4,4% € 346,13 4,4% 4,4% € 361,43 € 377,40 4,4% 2,4% € 394,08 € 403,54 2,4% € 413,23 2,4% 2,4% € 423,14 € 433,30 2,4% € 443,70 2,4% € 454,35 2,4% € 465,25 2,4% 2,4% € 476,42 € 487,85 2,4% € 499,56 0,3% 0,3% € 501,12 € 502,68 0,3% € 504,25 0,3% € 505,82 0,3% € 507,40 0,3% € 508,98 0,3% € 510,57 0,3% € 512,16 0,3% € 513,75 0,3% € 515,36 0,3% € 516,96 0,3% € 518,57 0,3% € 520,19 0,3% € 521,81 0,3% € 523,44 2,4% € 536,00 2,4% € 548,87 2,4% € 562,04 2,4% € 575,53 2,4% € 589,34 2,4% 2,4% € 603,48 € 617,97 2,4% € 632,80 2,4% € 647,99 2,4% € 663,54 2,4% € 679,46 2,4% € 695,77 2,4% € 712,47 2,4% € 729,57 2,4% € 747,08 2,4% € 765,01 2,4% 2,4% € 783,37 € 802,17 2,4% € 821,42 2,4% € 841,13 2,4% € 861,32 2,4% € 881,99 2,4% € 903,16 2,4% € 924,84 -3,3% € 894,22 -3,3% € 864,62 -3,3% € 836,00 -3,3% € 808,32 -3,3% € 781,56 -3,3% € 755,69 -3,3% € 730,67 2,4% € 748,21 2,4% € 766,16 2,4% € 784,55 2,4% €

€ 498.060.890 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

2.371.000 2.482.755 2.596.859 2.733.368 2.869.303 3.012.222 3.157.442 3.307.356 3.461.035 3.613.994 3.773.714 3.940.491 4.114.640 4.296.485 4.486.366 4.684.640 4.797.071 4.912.201 5.030.094 5.150.816 5.274.435 5.401.022 5.530.646 5.663.382 5.799.303 5.938.486 5.957.000 5.975.572 5.994.201 6.012.889 6.031.635 6.050.439 6.069.302 6.088.224 6.107.205 6.126.244 6.145.344 6.164.503 6.183.721 6.203.000 6.222.338 6.371.674 6.524.594 6.681.185 6.841.533 7.005.730 7.173.867 7.346.040 7.522.345 7.702.881 7.887.751 8.077.057 8.270.906 8.469.408 8.672.674 8.880.818 9.093.957 9.312.212 9.535.705 9.764.562 9.998.912 10.238.886 10.484.619 10.736.250 10.993.920 10.629.972 10.278.072 9.937.821 9.608.835 9.290.739 8.983.174 8.685.791 8.894.250 9.107.712 9.326.297

-3,02% € -15.016.942 Kwijtschelding € -71.488 € -74.857 € -78.297 € -82.413 € -86.512 € -90.821 € -95.199 € -99.719 € -104.353 € -108.965 € -113.781 € -118.809 € -124.060 € -129.543 € -135.268 € -141.246 € -144.636 € -148.107 € -151.661 € -155.301 € -159.029 € -162.845 € -166.753 € -170.756 € -174.854 € -179.050 € -179.608 € -180.168 € -180.730 € -181.294 € -181.859 € -182.426 € -182.994 € -183.565 € -184.137 € -184.711 € -185.287 € -185.865 € -186.444 € -187.025 € -187.609 € -192.111 € -196.722 € -201.443 € -206.278 € -211.228 € -216.298 € -221.489 € -226.805 € -232.248 € -237.822 € -243.530 € -249.375 € -255.360 € -261.488 € -267.764 € -274.190 € -280.771 € -287.509 € -294.410 € -301.475 € -308.711 € -316.120 € -323.707 € -331.476 € -320.502 € -309.892 € -299.633 € -289.714 € -280.123 € -270.850 € -261.884 € -268.169 € -274.605 € -281.195

€ 483.043.948 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

KOSTENDEKKINGSPLAN

Verloop voorziening(en)

Onze referentie: 01 - Datum: 3 februari 2023

KOSTENDEKKINGSPLAN

Variant A (activeren) Overzicht Egalisatievoorziening riolering (BBV 44.2) Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: 30139672

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

VAST PRIJSPEIL (2023) € -1.308.993 Jaar 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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

Inflatie factor 1,0000 1,0240 1,0486 1,0737 1,0995 1,1259 1,1529 1,1806 1,2089 1,2379 1,2677 1,2981 1,3292 1,3611 1,3938 1,4272 1,4615 1,4966 1,5325 1,5693 1,6069 1,6455 1,6850 1,7254 1,7668 1,8093 1,8527 1,8971 1,9427 1,9893 2,0370 2,0859 2,1360 2,1873 2,2397 2,2935 2,3485 2,4049 2,4626 2,5217 2,5822 2,6442 2,7077 2,7727 2,8392 2,9074 2,9771 3,0486 3,1217 3,1967 3,2734 3,3520 3,4324 3,5148 3,5991 3,6855 3,7740 3,8645 3,9573 4,0523 4,1495 4,2491 4,3511 4,4555 4,5624 4,6719 4,7841 4,8989 5,0165 5,1369 5,2601 5,3864 5,5157 5,6480 5,7836

Afwaardering

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

-23.345 -26.070 -26.349 -24.774 -25.437 -25.833 -26.327 -26.520 -25.388 -25.169 -23.993 -23.878 -23.832 -22.657 -22.982 -23.068 -22.965 -22.542 -20.517 -20.617 -20.338 -19.121 -17.361 -14.921 -12.765 -10.940 -9.314 -9.102 -9.271 -9.050 -8.420 -7.610 -6.565 -5.041 -3.141 -2.344 -2.356 -3.048 -4.045 -6.033 -8.000 -9.802 -10.797 -12.137 -13.910 -15.381 -16.513 -17.607 -17.735 -17.913 -17.470 -17.811 -18.672 -19.446 -20.752 -22.152 -23.467 -24.575 -24.252 -24.685 -24.919 -25.108 -25.087 -24.532 -24.287 -24.465 -24.566 -24.369 -22.933 -21.187 -18.664 -15.365 -11.312 -6.074

YAG€R

maximum: € minimum: €

1.131.518 (in 2030) 0 (in 2097)

eind: €

0 (in 2097)

einde jaar (saldo 31/12) 100%

maximum: € minimum: €

5.093.526 (in 2090) 0 (in 2097)

eind: €

0 (in 2097)

NOMINAAL €

Saldo 1/1

t.b.v. vast prijspeil

v4.10

nominaal

781.950 € 972.704 € 1.086.238 € 1.097.854 € 1.032.270 € 1.059.885 € 1.076.366 € 1.096.964 € 1.104.998 € 1.057.825 € 1.048.699 € 999.702 € 994.935 € 993.009 € 944.026 € 957.564 € 961.186 € 956.866 € 939.260 € 854.858 € 859.027 € 847.422 € 796.719 € 723.388 € 621.691 € 531.859 € 455.830 € 388.099 € 379.254 € 386.277 € 377.080 € 350.838 € 317.081 € 273.562 € 210.053 € 130.870 € 97.656 € 98.160 € 126.997 € 168.558 € 251.374 € 333.326 € 408.424 € 449.895 € 505.717 € 579.575 € 640.883 € 688.038 € 733.617 € 738.964 € 746.361 € 727.902 € 742.130 € 778.014 € 810.262 € 864.672 € 923.004 € 977.803 € 1.023.956 € 1.010.486 € 1.028.539 € 1.038.281 € 1.046.152 € 1.045.286 € 1.022.162 € 1.011.951 € 1.019.386 € 1.023.565 € 1.015.363 € 955.529 € 882.809 € 777.664 € 640.228 € 471.339 € 253.085 €

527.043 Dotatie 214.099 139.604 37.965 -40.810 53.052 42.314 46.925 34.554 -21.785 16.043 -25.004 19.111 21.906 -26.326 36.520 26.690 18.645 4.936 -63.886 24.785 8.733 -31.582 -55.970 -86.776 -77.068 -65.089 -58.417 257 16.294 -147 -17.821 -26.147 -36.953 -58.468 -76.042 -30.870 2.859 31.885 45.606 88.850 89.951 84.900 52.269 67.959 87.768 76.688 63.668 63.186 23.082 25.309 -989 32.039 54.557 51.694 75.162 80.484 78.266 70.728 10.782 42.737 34.661 32.979 24.220 1.408 14.076 31.900 28.744 16.167 -36.901 -51.533 -86.481 -122.071 -157.577 -212.180 -253.085

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

996.049 1.112.308 1.124.203 1.057.045 1.085.322 1.102.199 1.123.291 1.131.518 1.083.213 1.073.868 1.023.695 1.018.814 1.016.841 966.683 980.546 984.255 979.831 961.802 875.375 879.643 867.760 815.840 740.749 636.612 544.624 466.770 397.413 388.356 395.548 386.130 359.259 324.691 280.128 215.094 134.011 100.000 100.516 130.045 172.603 257.407 341.325 418.226 460.693 517.854 593.485 656.264 704.551 751.224 756.700 764.273 745.372 759.941 796.687 829.708 885.424 945.156 1.001.270 1.048.531 1.034.738 1.053.224 1.063.200 1.071.260 1.070.373 1.046.694 1.036.238 1.043.851 1.048.131 1.039.732 978.462 903.996 796.328 655.593 482.651 259.159 0

Onze referentie: 01 - Datum: 3 februari 2023

€ -781.950 Saldo 1/1 Dotatie nominaal € 781.950 € 214.099 € 996.049 € 142.954 € 1.139.003 € 39.809 € 1.178.812 € -43.819 € 1.134.993 € 58.331 € 1.193.324 € 47.641 € 1.240.965 € 54.101 € 1.295.066 € 40.794 1.335.861 € € -26.337 1.309.524 € € 19.860 1.329.384 € € -31.696 € 1.297.688 € 24.808 1.322.496 € € 29.118 1.351.613 € € -35.833 € 1.315.780 € 50.901 1.366.681 € € 38.094 1.404.775 € € 27.250 1.432.025 € € 7.387 € 1.439.412 € -97.904 € 1.341.508 € 38.895 € 1.380.403 € 14.034 € 1.394.437 € -51.968 € 1.342.469 € -94.309 1.248.160 € € -149.727 € 1.098.434 € -136.167 € 962.267 € -117.763 € 844.504 € -108.227 € 736.277 € 488 € 736.764 € 31.654 € 768.418 € -293 € 768.125 € -36.302 € 731.823 € -54.541 € 677.281 € -78.932 € 598.349 € -127.884 € 470.465 € -170.315 € 300.150 € -70.800 229.350 € € 6.715 236.065 € € 76.681 312.746 € € 112.310 € 425.056 € 224.055 € 649.111 € 232.276 € 881.387 € 224.496 € 1.105.883 € 141.528 € 1.247.411 € 188.428 € 1.435.839 € 249.193 € 1.685.032 € 222.960 € 1.907.992 € 189.548 € 2.097.540 € 192.629 € 2.290.169 € 72.057 € 2.362.226 € 80.904 € 2.443.130 € -3.237 € 2.439.893 € 107.392 € 2.547.285 € 187.261 € 2.734.546 € 181.693 € 2.916.240 € 270.518 € 3.186.758 € 296.626 € 3.483.383 € 295.373 € 3.778.756 € 273.331 € 4.052.087 € 42.668 € 4.094.755 € 173.183 € 4.267.938 € 143.826 € 4.411.764 € 140.130 € 4.551.894 € 105.385 € 4.657.279 € 6.274 € 4.663.554 €

64.220 € 4.727.774 € 149.036 € 4.876.810 € 137.516 € 5.014.325 € 79.201 € 5.093.526 € -185.114 € 4.908.412 € -264.717 € 4.643.694 € -454.901 € 4.188.793 € -657.520 € 3.531.273 € -869.140 € 2.662.133 € -1.198.396 € 1.463.737 € -1.463.737

Saldo 31/12 nominaal 996.049 1.139.003 1.178.812 1.134.993 1.193.324 1.240.965 1.295.066 1.335.861 1.309.524 1.329.384 1.297.688 1.322.496 1.351.613 1.315.780 1.366.681 1.404.775 1.432.025 1.439.412 1.341.508 1.380.403 1.394.437 1.342.469 1.248.160 1.098.434 962.267 844.504 736.277 736.764 768.418 768.125 731.823 677.281 598.349 470.465 300.150 229.350 236.065 312.746 425.056 649.111 881.387 1.105.883 1.247.411 1.435.839 1.685.032 1.907.992 2.097.540 2.290.169 2.362.226 2.443.130 2.439.893 2.547.285 2.734.546 2.916.240 3.186.758 3.483.383 3.778.756 4.052.087 4.094.755 4.267.938 4.411.764 4.551.894 4.657.279 4.663.554 4.727.774 4.876.810 5.014.325 5.093.526 4.908.412 4.643.694 4.188.793 3.531.273 2.662.133 1.463.737 0

KOSTENDEKKINGSPLAN

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

VAST PRIJSPEIL (2023) € -1.081.344 Jaar 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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

Afwaardering

-19.453 -21.194 -20.983 -19.581 -18.910 -15.876 -14.019 -12.594 -10.441 -9.943 -9.097 -9.815 -11.105 -11.972 -12.751 -12.184 -10.541 -11.318 -11.675 -13.636 -16.135 -17.069 -18.814 -21.325 -22.966 -23.282 -22.613 -22.137 -20.767 -19.459 -17.796 -16.325 -15.045 -13.539 -12.146 -11.436 -11.599 -12.588 -13.981 -16.595 -17.564 -16.919 -16.353 -16.844 -18.562 -16.870 -15.679 -15.042 -14.132 -13.823 -13.040 -13.405 -14.584 -15.924 -15.773 -16.288 -17.282 -18.634 -19.254 -21.291 -20.927 -18.396 -16.191 -13.922 -12.446 -10.877 -9.255 -8.939 -6.542 -4.927 -3.621 -2.605 -1.850 -881

YAG€R

781.950 810.541 883.082 874.295 815.880 787.907 661.484 584.109 524.769 435.024 414.297 379.042 408.946 462.728 498.834 531.278 507.681 439.222 471.596 486.452 568.169 672.274 711.189 783.919 888.522 956.908 970.103 942.191 922.375 865.279 810.811 741.519 680.191 626.877 564.106 506.063 476.492 483.302 524.500 582.529 691.469 731.830 704.950 681.380 701.813 773.403 702.926 653.301 626.768 588.842 575.954 543.339 558.556 607.662 663.480 657.223 678.687 720.075 776.410 802.264 887.109 871.967 766.509 674.614 580.063 518.598 453.190 385.634 372.447 272.565 205.274 150.873 108.525 77.093 36.719

maximum: € minimum: €

993.385 (in 2048) -0 (in 2097)

eind: €

-0 (in 2097)

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

maximum: € minimum: €

3.705.078 (in 2083) -0 (in 2097)

eind: €

-0 (in 2097)

NOMINAAL €

Saldo 1/1

t.b.v. vast prijspeil

v4.10

nominaal

Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: 30139672

299.394 Dotatie

48.044 93.735 12.196 -38.834 -9.063 -110.547 -63.356 -46.746 -79.305 -10.784 -26.158 39.719 64.887 48.078 45.195 -11.413 -57.918 43.693 26.531 95.353 120.239 55.984 91.544 125.927 91.351 36.477 -5.299 2.320 -36.329 -35.009 -51.496 -45.003 -38.269 -49.232 -45.898 -18.135 18.409 53.786 72.010 125.535 57.925 -9.961 -7.217 37.276 90.152 -53.607 -33.946 -11.490 -23.794 935 -19.574 28.621 63.690 71.742 9.516 37.753 58.670 74.968 45.108 106.136 5.785 -87.061 -75.704 -80.630 -49.019 -54.531 -58.301 -4.249 -93.340 -62.364 -50.780 -39.744 -29.582 -39.493 -36.719

829.994 904.276 895.278 835.461 806.817 677.360 598.128 537.364 445.464 424.240 388.139 418.761 473.833 510.806 544.029 519.865 449.763 482.915 498.127 581.805 688.408 728.257 802.733 909.847 979.874 993.385 964.804 944.512 886.046 830.270 759.315 696.516 641.922 577.644 518.208 487.928 494.901 537.088 596.510 708.064 749.394 721.869 697.733 718.656 791.965 719.796 668.980 641.811 602.974 589.777 556.380 571.961 622.246 679.404 672.996 694.976 737.357 795.044 821.518 908.400 892.894 784.906 690.805 593.985 531.044 464.067 394.889 381.385 279.106 210.201 154.494 111.130 78.943 37.600 -0

Onze referentie: 01 - Datum: 3 februari 2023

€ -781.950 Saldo 1/1 Dotatie nominaal 48.044 € 781.950 € € 829.994 € 95.985 € 925.978 € 12.789 € 938.767 € -41.697 -9.965 € 897.070 € € 887.104 € -124.465 € 762.639 € -73.045 € 689.595 € -55.188 € 634.407 € -95.874 -13.350 € 538.533 € € 525.183 € -33.159 51.558 € 492.025 € € 543.583 € 86.250 65.441 € 629.833 € 62.992 € 695.274 € € -16.289 758.266 € € 741.977 € -84.647 65.390 € 657.329 € € 722.719 € 40.658 149.635 € 763.377 € 193.217 € 913.012 € € 92.122 1.106.229 € € 1.198.351 € 154.252 € 217.280 1.352.603 € € 1.569.883 € 161.404 65.997 € 1.731.287 € € 1.797.283 € -9.817 € 1.787.466 € 4.402 € 1.791.868 € -70.575 -69.643 € 1.721.294 € € 1.651.651 € -104.899 -93.874 € 1.546.753 € € 1.452.879 € -81.742 -107.683 € 1.371.137 € € 1.263.453 € -102.799 -41.592 € 1.160.654 € € 1.119.061 € 43.235 129.350 € 1.162.296 € € 1.291.646 € 177.334 € 1.468.980 € 316.566 149.577 € 1.785.546 € € 1.935.123 € -26.340 € 1.908.783 € -19.542 € 1.889.241 € 103.355 € 1.992.597 € 255.961 € 2.248.557 € -155.855 € 2.092.703 € -101.060 € 1.991.642 € -35.029 -74.280 € 1.956.614 € 2.989 € 1.882.333 € € 1.885.322 € -64.074 € 1.821.248 € 95.938 € 218.611 1.917.186 € 252.155 € 2.135.796 € 34.249 € 2.387.952 € 139.139 € 2.422.201 € 221.419 € 2.561.340 € 289.717 € 2.782.759 € € 3.072.476 € 178.506 € 3.250.982 € 430.092 € 3.681.074 € 24.003 € 3.705.078 € -369.933 € 3.335.145 € -329.397 € 3.005.749 € -359.245

-223.646 € 2.646.503 € -254.765 € 2.422.857 € € 2.168.092 € -278.916 € 1.889.176 € -20.814 € 1.868.362 € -468.237 € 1.400.125 € -320.354 € 1.079.771 € -267.109 € 812.662 € -214.074 € 598.588 € -163.166 € 435.422 € -223.056 € 212.366 € -212.366

Saldo 31/12 nominaal € 829.994 € 925.978 € 938.767 € 897.070 € 887.104 € 762.639 € 689.595 € 634.407 € 538.533 € 525.183 € 492.025 € 543.583 € 629.833 € 695.274 € 758.266 € 741.977 € 657.329 € 722.719 € 763.377 € 913.012 € 1.106.229 € 1.198.351 € 1.352.603 € 1.569.883 € 1.731.287 € 1.797.283 € 1.787.466 € 1.791.868 € 1.721.294 € 1.651.651 € 1.546.753 € 1.452.879 € 1.371.137 € 1.263.453 € 1.160.654 € 1.119.061 € 1.162.296 € 1.291.646 € 1.468.980 € 1.785.546 € 1.935.123 € 1.908.783 € 1.889.241 € 1.992.597 € 2.248.557 € 2.092.703 € 1.991.642 € 1.956.614 € 1.882.333 € 1.885.322 € 1.821.248 € 1.917.186 € 2.135.796 € 2.387.952 € 2.422.201 € 2.561.340 € 2.782.759 € 3.072.476 € 3.250.982 € 3.681.074 € 3.705.078 € 3.335.145 € 3.005.749 € 2.646.503 € 2.422.857 € 2.168.092 € 1.889.176 € 1.868.362 € 1.400.125 € 1.079.771 € 812.662 € 598.588 € 435.422 € 212.366 € -0

KOSTENDEKKINGSPLAN

Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - VAST PRIJSPEIL (2023) v4.10

Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: 30139672

YAG€R

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

Saldo

Boekwaarde

€ €

1.300.000 200.000

maximum minimum

(in 2061) (in 2023)

€ €

820.018 -

€ €

(in 2023)

€

700.000

eind

(in 2097)

€

112.102

€

(in 2097)

ICpos € Jaar 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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

-266.208

Inflatie factor

Afwaardering saldo

-416 -2.214 -2.852 -0 -1.797 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -5.111 -11.019 -13.792 -19.219 -19.000 -9.927 -4.944 -0 -0 -0 -0 -0 -0 -0 -0 -4.252 -6.200 -10.717 -14.384 -18.158 -16.930 -17.822 -16.444 -11.629 -8.957 -8.780 -8.548 -1.213 -4.584 -1.861 -2.819 -3.711 -4.583 -4.176 -3.779 -3.375 -2.997

€ -0 Afwaardering boekwaarde

Spaarvoorziening Rioolvervanging (BBV 44.1d) Saldo 1/1

restinvesteringen

-0 -0 -

17.322 92.244 118.816 0 74.874 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 212.976 459.141 574.659 800.799 791.660 413.643 205.987 0 0 0 0 0 0 0 0 177.151 258.323 446.530 599.330 756.589 705.412 742.579 685.147 484.528 373.203 365.815 356.180 50.524 191.016 77.528 117.442 154.634 190.954 174.012 157.466 140.631 124.868

Boekwaarde 1/1 restinvesteringen

0 0 -

Onze referentie: 01 - Datum: 3 februari 2023

€

78.325.889

85,4%

Totaal investeringen

% direct

Afboekingen

861.531 861.531 861.531 861.531 861.531 665.708 665.708 665.708 665.708 665.708 596.511 596.511 596.511 596.511 596.511 789.311 789.311 789.311 789.311 789.311 2.113.736 2.113.736 2.113.736 2.113.736 2.113.736 1.682.606 1.682.606 1.682.606 1.682.606 1.682.606 1.308.929 1.308.929 1.308.929 1.308.929 1.308.929 555.497 555.497 555.497 555.497 555.497 1.091.743 1.091.743 1.091.743 1.091.743 1.091.743 1.232.832 1.232.832 1.232.832 1.232.832 1.232.832 999.348 999.348 999.348 999.348 999.348 1.226.173 1.226.173 1.226.173 1.226.173 1.226.173 1.171.219 1.171.219 1.171.219 1.171.219 1.171.219 657.267 657.267 657.267 657.267 657.267 712.766 712.766 712.766 712.766 712.766

21% 21% 32% 42% 39% 79% 57% 60% 71% 65% 67% 76% 85% 66% 98% 100% 100% 100% 92% 100% 40% 39% 40% 36% 36% 47% 47% 46% 47% 47% 62% 63% 59% 64% 56% 100% 100% 100% 100% 100% 100% 100% 98% 92% 70% 84% 76% 80% 77% 79% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 92% 67% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

€ -66.921.691 €

-200.000 -200.000 -300.000 -400.000 -500.000 -600.000 -600.000 -600.000 -600.000 -600.000 -600.000 -600.000 -600.000 -600.000 -750.000 -882.263 -972.864 -1.020.577 -1.168.816 -973.330 -1.124.874 -1.050.000 -950.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -850.000 -631.912 -592.816 -720.690 -604.640 -840.139 -1.318.089 -1.252.712 -1.255.987 -1.050.000 -1.050.000 -1.200.000 -1.200.000 -1.200.000 -1.200.000 -1.200.000 -1.018.597 -1.112.628 -1.001.076 -1.032.816 -1.124.582 -1.334.248 -1.245.011 -1.340.989 -1.488.991 -1.402.368 -1.298.609 -1.301.086 -1.504.444 -1.150.524 -1.000.000 -704.400 -911.627 -657.267 -659.097 -659.097 -712.766 -712.766 -713.459 -712.766 -712.766

67.300.000

€

Dotatie € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

200.000 € 200.000 € 300.000 € 400.000 € 500.000 € 600.000 € 600.000 € 600.000 € 600.000 € 600.000 € 600.000 € 600.000 € 600.000 € 600.000 € 750.000 € 900.000 € 1.050.000 € 1.050.000 € 1.050.000 € 1.050.000 € 1.050.000 € 1.050.000 € 950.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 850.000 € 950.000 € 1.050.000 € 1.050.000 € 1.050.000 € 1.050.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.200.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.300.000 € 1.200.000 € 1.100.000 € 1.000.000 € 900.000 € 800.000 € 700.000 € 700.000 € 700.000 € 700.000 € 700.000 € 700.000 € 700.000 € 700.000 €

378.309

Spaarvoorziening Rioolvervanging (BBV 44.1d)

Totale mutatie 17.737 77.136 29.423 -118.816 76.670 -74.874 218.088 257.184 129.310 245.360 9.861 -368.089 -202.712 -205.987 181.403 87.372 198.924 167.184 175.418 -34.248 54.989 -40.989 -188.991 -102.368 1.391 -1.086 -304.444 -50.524 195.600 -111.627 42.733 40.903 40.903 -12.766 -12.766 -13.459 -12.766 -12.766

17.737 94.458 121.668 0 76.670 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 218.088 470.160 588.450 820.018 810.660 423.571 210.931 0 0 0 0 0 0 0 0 181.403 264.523 457.247 613.714 774.747 722.342 760.401 701.591 496.156 382.160 374.594 364.729 51.736 195.600 79.389 120.261 158.345 195.537 178.188 161.245 144.007 127.865 112.102

Boekwaarde 31/12 restinvesteringen

0 0 -

(in 2086)

KOSTENDEKKINGSPLAN

Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - NOMINAAL v4.10

Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: 30139672

YAG€R

Jaarrente (restinvest.): Jaarrente (positief): Rentemoment: Rente vanuit vorig jaar: Rente in huidig jaar: Dotaties € €

5.523.835 200.000

maximum minimum

€

4.048.506

eind

Saldo

Boekwaarde

(in 2023)

€ €

2.869.725 -

€ €

(in 2023)

(in 2097)

€

648.350

€

(in 2097)

(in 2079)

ICpos Spaarvoorziening Rioolvervanging (BBV 44.1d) Jaar 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 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097

Saldo 1/1 € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

25.316 138.051 182.085 0 120.317 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500.184 1.104.191 1.415.169 2.019.398 2.044.264 1.093.765 557.749 0 0 0 0 0 0 0 0 593.802 886.668 1.569.453 2.157.066 2.788.417 2.662.197 2.869.725 2.711.323 1.963.433 1.548.612 1.554.384 1.549.770 225.109 913.831 379.801 589.145 794.333 1.004.446 937.293 868.528 794.290 722.185

Boekwaarde 1/1 restinvesteringen

0 0 -

€ 208.515.130

92,9% € -193.655.289

Totaal investeringen

% direct

Afboekingen

861.531 882.208 903.381 925.062 947.264 749.520 767.509 785.929 804.791 824.106 756.168 774.316 792.899 811.929 831.415 1.126.542 1.153.579 1.181.264 1.209.615 1.238.646 3.396.642 3.478.162 3.561.638 3.647.117 3.734.648 3.044.257 3.117.319 3.192.135 3.268.746 3.347.196 2.666.336 2.730.328 2.795.856 2.862.957 2.931.667 1.274.032 1.304.609 1.335.920 1.367.982 1.400.813 2.819.154 2.886.814 2.956.097 3.027.044 3.099.693 3.584.281 3.670.304 3.758.391 3.848.592 3.940.959 3.271.257 3.349.768 3.430.162 3.512.486 3.596.786 4.519.072 4.627.530 4.738.590 4.852.316 4.968.772 4.859.991 4.976.631 5.096.070 5.218.376 5.343.617 3.070.711 3.144.408 3.219.874 3.297.151 3.376.283 3.749.248 3.839.230 3.931.372 4.025.725 4.122.342

Onze referentie: 01 - Datum: 3 februari 2023

-200.000 -204.800 -314.573 -429.497 -549.756 -675.540 -691.753 -708.355 -725.355 -742.764 -760.590 -778.845 -797.537 -816.678 -1.045.347 -1.259.207 -1.421.842 -1.527.372 -1.791.206 -1.527.422 -1.807.602 -1.727.780 -1.600.747 -1.466.621 -1.501.820 -1.537.864 -1.574.772 -1.612.567 -1.651.269 -1.690.899 -1.731.481 -1.773.036 -1.815.589 -1.859.163 -1.903.783 -1.449.290 -1.392.254 -1.733.194 -1.489.002 -2.118.603 -3.403.636 -3.312.452 -3.400.818 -2.911.303 -2.981.174 -3.488.826 -3.572.558 -3.658.299 -3.746.098 -3.836.005 -3.334.267 -3.729.477 -3.436.093 -3.630.118 -4.047.519 -4.917.383 -4.698.623 -5.182.301 -5.892.362 -5.682.760 -5.388.598 -5.528.450 -6.545.960 -5.126.168 -4.562.441 -3.290.914 -4.361.283 -3.219.874 -3.306.331 -3.385.683 -3.749.248 -3.839.230 -3.935.194 -4.025.725 -4.122.342

€ 194.303.639

€

648.350

Dotatie

Totale mutatie

200.000 € 204.800 € 314.573 € 429.497 € 549.756 € 675.540 € 691.753 € 708.355 € 725.355 € 742.764 € 760.590 € 778.845 € 797.537 € 816.678 € 1.045.347 € 1.284.523 € 1.534.577 € 1.571.407 € 1.609.120 € 1.647.739 € 1.687.285 € 1.727.780 € 1.600.747 € 1.466.621 € 1.501.820 € 1.537.864 € 1.574.772 € 1.612.567 € 1.651.269 € 1.690.899 € 1.731.481 € 1.773.036 € 1.815.589 € 1.859.163 € 1.903.783 € 1.949.474 € 1.996.261 € 2.044.171 € 2.093.232 € 2.143.469 € 2.453.137 € 2.776.435 € 2.843.070 € 2.911.303 € 2.981.174 € 3.488.826 € 3.572.558 € 3.658.299 € 3.746.098 € 3.836.005 € 3.928.069 € 4.022.342 € 4.118.879 € 4.217.732 € 4.678.870 € 4.791.163 € 4.906.151 € 5.023.899 € 5.144.472 € 5.267.940 € 5.394.370 € 5.523.835 € 5.221.299 € 4.901.059 € 4.562.441 € 4.204.745 € 3.827.253 € 3.429.218 € 3.511.520 € 3.595.796 € 3.682.095 € 3.770.465 € 3.860.957 € 3.953.620 € 4.048.506 €

25.316 112.735 44.035 -182.085 120.317 -120.317 500.184 604.007 310.978 604.229 24.866 -950.499 -536.017 -557.749 593.802 292.866 682.785 587.613 631.351 -126.220 207.528 -158.402 -747.890 -414.820 5.772 -4.615 -1.324.661 -225.109 913.831 -534.031 209.344 205.188 210.113 -67.153 -68.765 -74.237 -72.105 -73.836

Spaarvoorziening Rioolvervanging (BBV 44.1d) Saldo 31/12 € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

Boekwaarde 31/12 restinvesteringen

0 0 -

(in 2086)

KOSTENDEKKINGSPLAN

Variant C (duurzaam financieren, huidig) Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - VAST PRIJSPEIL (2023) v4.10

Opdrachtgever: Gemeente Heiloo Project: KDPén BUCH werkorganisatie Projectnummer: -

YAG€R

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

Saldo

Boekwaarde

€ (in 2024) €

5.226.760 -

€ €

(in 2023)

€

(in 2097)

€ €

1.787.634 248.044

maximum minimum

(in 2042)

€

496.610

eind

(in 2097)

-2.051.566

Inflatie factor

Afwaardering saldo

-1.409 -2.070 -5.237 -10.187 -20.600 -34.634 -44.618 -61.293 -76.689 -90.130 -102.646 -108.282 -122.502 -94.385 -69.255 -53.398 -37.152 -22.077 -21.174 -18.274 -14.516 -9.455 -3.935 -7.720 -10.850 -11.166 -12.653 -8.586 -24.762 -40.450 -51.767 -64.175 -70.279 -64.092 -59.794 -54.562 -53.094 -44.391 -37.639 -27.773 -20.693 -11.725 -4.552 -8.869 -11.566 -17.207 -21.745 -24.509 -22.566 -22.875 -20.944 -14.537 -11.396 -10.767 -10.103 -4.752 -5.200 -403 -11.169 -13.323 -19.315 -22.110 -22.865 -20.051 -15.139 -10.326 -5.188

€ -0 Afwaardering boekwaarde

Spaarvoorziening Rioolvervanging (BBV 44.1d) Saldo 1/1

restinvesteringen

-0 -0 -0 -0 -0 -0 -0 -

781.950 58.727 86.235 218.217 424.476 858.323 1.443.095 1.859.102 2.553.859 3.195.382 3.755.397 4.276.937 4.511.753 5.104.258 3.932.722 2.885.614 2.224.898 1.547.991 919.857 882.230 761.428 604.814 393.955 163.973 321.684 452.075 465.247 527.198 357.745 1.031.746 1.685.422 2.156.946 2.673.962 2.928.296 2.670.487 2.491.417 2.273.411 2.212.254 1.849.618 1.568.279 1.157.211 862.220 488.561 189.660 369.534 481.929 716.969 906.043 1.021.198 940.263 953.112 872.675 605.718 474.827 448.639 420.946 197.982 216.670 16.805 465.375 555.137 804.795 921.241 952.694 835.471 630.796 430.241 216.156

← 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://api1.ibabs.eu/publicdownload.aspx?site=Heiloo&id=8aeb1968-0dad-4d56-8cea-503fc9bd5ca5