Document · PDF

bij 2 Kostendekkingsplan PWR gemeente Bergen 2023.pdf

Algemene Raadscommissie 22 juni 2023, gemeente Bergen (NH)Bij agendapunt: 3: Voorstel betreft het programma water en riolering 2023-2026 BUCH en de bijbehorende begrotingswijziging vast te stellen40.867 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

Inflatie

Oud, na BCF

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

Kapitaallasten 40.583.683 € 72.805.145 excl. BTW

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

1.840.356 1.751.220 1.689.335 1.622.179 1.507.361 1.461.407 1.393.803 1.341.190 1.295.887 1.254.409 1.213.837 1.174.448 1.136.322 1.099.356 1.062.390 1.027.570 995.745 963.149 919.480 888.466 852.001 816.674 787.172 759.933 734.005 705.566 680.069 655.792 631.462 605.231 584.574 564.050 542.733 503.768 485.570 463.957 444.532 419.722 378.752 363.010 346.336 329.671 309.083 298.729 287.792 228.572 188.963 178.282 149.981 145.082 140.313 95.354 80.551 57.112 43.193 30.084 20.189 12.814 12.393 11.983 58 55 54 53 52 50 49 48 47 46 45 44 43 42 41

Heffing eind € 179,50 (vanaf 2033) € 174,18 (vanaf 2078)

Heffing in startjaar: € 184,98

Heffing in eindjaar: € 162,16

v4.10

YAG€R

BATEN - vast prijspeil (2023)

LASTEN - vast prijspeil (2023)

€

Heffing start € 184,98 (in 2028) € 174,18 (in 2073)

€

55.579.164

Nieuw

BTW plichtig

11.223 50.314 87.188 124.506 160.697 184.760 224.931 243.640 264.869 297.647 334.954 348.721 360.714 376.330 425.232 483.254 500.300 513.224 527.184 589.803 663.735 674.697 710.788 716.844 753.132 836.389 867.390 857.938 856.576 904.462 975.912 975.758 997.522 1.046.496 1.083.504 1.106.911 1.110.490 1.145.891 1.182.111 1.240.341 1.317.912 1.334.221 1.334.686 1.336.920 1.346.478 1.356.769 1.372.017 1.364.014 1.351.042 1.334.199 1.344.286 1.363.377 1.361.330 1.354.852 1.344.500 1.365.983 1.376.986 1.354.426 1.347.980 1.363.183 1.386.442 1.391.044 1.364.609 1.349.336 1.348.079 1.372.317 1.400.081 1.416.209 1.432.402 1.427.770 1.419.836 1.438.727 1.439.672 1.408.250 1.368.833

858.111 849.511 878.711 890.111 769.611 772.611 762.500 762.500 811.500 762.500 797.500 740.500 740.500 789.500 718.500 721.500 718.500 718.500 775.500 718.500 721.500 718.500 718.500 743.500 718.500 721.500 750.500 718.500 743.500 718.500 718.500 718.500 718.500 743.500 750.500 718.500 718.500 718.500 743.500 718.500 718.500 718.500 750.500 743.500 718.500 718.500 718.500 718.500 743.500 718.500 750.500 718.500 718.500 743.500 718.500 718.500 718.500 718.500 775.500 718.500 718.500 718.500 718.500 743.500 718.500 718.500 750.500 718.500 743.500 718.500 718.500 718.500 718.500 743.500 750.500

€

Exploitatie 25.496.993

€

Overhead € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960 339.960

30.449.132

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

405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988 405.988

€ 224.914.118

€

SUBTOTAAL

BTW

excl. BTW

3.455.638 3.396.993 3.401.182 3.382.744 3.183.616 3.164.726 3.127.182 3.093.278 3.118.205 3.060.504 3.092.239 3.009.617 2.983.485 3.011.135 2.952.071 2.978.272 2.960.494 2.940.822 2.968.112 2.942.717 2.983.185 2.955.819 2.962.408 2.966.225 2.951.585 3.009.404 3.043.907 2.978.178 2.977.487 2.974.141 3.024.934 3.004.256 3.004.703 3.039.713 3.065.522 3.035.316 3.019.470 3.030.061 3.050.311 3.067.799 3.128.696 3.128.339 3.140.217 3.125.097 3.098.718 3.049.789 3.025.428 3.006.745 2.990.471 2.943.729 2.981.047 2.923.179 2.906.329 2.901.413 2.852.142 2.860.515 2.861.624 2.831.688 2.881.821 2.839.614 2.850.948 2.855.548 2.829.111 2.838.837 2.812.579 2.836.815 2.896.579 2.880.705 2.921.897 2.892.264 2.884.329 2.903.219 2.904.163 2.897.740 2.865.322

alléén exploitatie BTW compensatie 11.671.625 € 236.585.742

180.203 178.397 184.529 186.923 161.618 162.248 160.125 160.125 170.415 160.125 167.475 155.505 155.505 165.795 150.885 151.515 150.885 150.885 162.855 150.885 151.515 150.885 150.885 156.135 150.885 151.515 157.605 150.885 156.135 150.885 150.885 150.885 150.885 156.135 157.605 150.885 150.885 150.885 156.135 150.885 150.885 150.885 157.605 156.135 150.885 150.885 150.885 150.885 156.135 150.885 157.605 150.885 150.885 156.135 150.885 150.885 150.885 150.885 162.855 150.885 150.885 150.885 150.885 156.135 150.885 150.885 157.605 150.885 156.135 150.885 150.885 150.885 150.885 156.135 157.605

Egalisatievoorziening Riolering (BBV 44.2) €

SUBTOTAAL 3.635.841 3.575.390 3.585.711 3.569.667 3.345.235 3.326.975 3.287.307 3.253.403 3.288.620 3.220.629 3.259.714 3.165.122 3.138.990 3.176.930 3.102.956 3.129.787 3.111.379 3.091.707 3.130.967 3.093.602 3.134.700 3.106.704 3.113.293 3.122.360 3.102.470 3.160.919 3.201.512 3.129.063 3.133.622 3.125.026 3.175.819 3.155.141 3.155.588 3.195.848 3.223.127 3.186.201 3.170.355 3.180.946 3.206.446 3.218.684 3.279.581 3.279.224 3.297.822 3.281.232 3.249.603 3.200.674 3.176.313 3.157.630 3.146.606 3.094.614 3.138.652 3.074.064 3.057.214 3.057.548 3.003.027 3.011.400 3.012.509 2.982.573 3.044.676 2.990.499 3.001.833 3.006.433 2.979.996 2.994.972 2.963.464 2.987.700 3.054.184 3.031.590 3.078.032 3.043.149 3.035.214 3.054.104 3.055.048 3.053.875 3.022.927

€ 238.834.667

1.436.051

TOTAAL

Jaar

Heffingseenheden

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

18.883 18.902 18.969 19.017 19.042 19.092 19.132 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162

Dotatie

incl. BTW

2.248.925

-278.305 -214.548 -212.973 -188.395 40.572 67.634 94.092 112.977 57.563 105.476 46.434 121.189 127.604 70.064 124.557 78.360 96.769 116.441 77.181 114.545 73.447 101.443 94.854 85.787 105.677 47.228 6.636 79.084 74.525 83.121 32.328 53.006 52.559 12.299 -14.980 21.946 37.792 27.201 1.701 -10.537 -71.434 -71.077 -89.675 -73.085 -41.456 7.474 31.834 50.517 61.542 113.533 69.495 134.083 150.933 150.599 205.121 196.748 157.632 150.012 50.798 68.304 20.734 -19.674 6.763 -8.213 23.295 -941 -67.425 -44.831 -91.273 -56.390 -48.455 -67.345 -68.289 -67.116 -36.168

3.357.536 3.360.843 3.372.738 3.381.273 3.385.807 3.394.608 3.381.399 3.366.381 3.346.182 3.326.105 3.306.149 3.286.312 3.266.594 3.246.994 3.227.512 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.208.147 3.170.141 3.132.585 3.095.475 3.058.803 3.022.566 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759 2.986.759

€

Rioolheffing 12.977 Heffing per 1/1

184,98 184,98 184,98 184,98 184,98 184,98 183,87 182,77 181,67 180,58 179,50 178,42 177,35 176,29 175,23 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 174,18 172,11 170,07 168,06 166,07 164,10 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16 162,16

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

€ 248.470.788 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

3.493.000 3.496.441 3.508.816 3.517.695 3.522.412 3.531.569 3.517.826 3.502.202 3.481.189 3.460.302 3.439.540 3.418.903 3.398.389 3.377.999 3.357.731 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.337.585 3.298.045 3.258.974 3.220.366 3.182.215 3.144.516 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264 3.107.264

-3,88% -9.636.121 Kwijtschelding en oninbaar € -135.464 € -135.598 € -136.078 € -136.422 € -136.605 € -136.960 € -136.427 € -135.821 € -135.006 € -134.196 € -133.391 € -132.591 € -131.795 € -131.005 € -130.219 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -129.437 € -127.904 € -126.389 € -124.891 € -123.412 € -121.950 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 € -120.505 €

€ 238.834.667 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

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

Kostendekkingsplan - nominaal (inclusief inflatie) Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

Wachtjaren 5 40

Periode 1 Periode 2

Stijgingsjaren 5 5

Stijgingspercentage -1,30% -

Heffing start € 208,27 (in 2028) € 570,15 (in 2073)

Financieringsmethode: ACTIVEREN

Heffing in startjaar: € 184,98

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

Kapitaallasten 63.717.527 € 238.929.547 na BCF Nieuw

excl. BTW

1.840.356 1.793.249 1.771.396 1.741.801 1.657.361 1.645.398 1.606.945 1.583.398 1.566.631 1.552.883 1.538.721 1.524.521 1.510.431 1.496.366 1.480.756 1.466.597 1.455.283 1.441.428 1.409.098 1.394.248 1.369.113 1.343.840 1.326.382 1.311.216 1.296.874 1.276.546 1.259.945 1.244.128 1.226.722 1.203.982 1.190.798 1.176.566 1.159.271 1.101.868 1.087.552 1.064.085 1.044.003 1.009.392 932.725 915.412 894.325 871.723 836.900 828.277 817.102 664.539 562.567 543.509 468.202 463.779 459.299 319.621 276.484 200.737 155.458 110.874 76.194 49.520 49.042 48.558 239 235 235 235 235 235 235 235 235 235 235 235 235 235 235

11.223 51.522 91.423 133.688 176.688 208.022 259.327 287.639 320.207 368.469 424.605 452.666 479.472 512.234 592.687 689.723 731.189 768.080 807.907 925.563 1.066.582 1.110.217 1.197.676 1.236.869 1.330.669 1.513.239 1.606.990 1.627.626 1.664.045 1.799.240 1.987.968 2.035.357 2.130.694 2.288.950 2.426.772 2.538.698 2.608.032 2.755.762 2.911.096 3.127.803 3.403.179 3.527.978 3.613.909 3.706.838 3.822.939 3.944.608 4.084.676 4.158.310 4.217.613 4.264.995 4.400.374 4.569.975 4.672.627 4.762.003 4.839.033 5.034.343 5.196.695 5.234.230 5.334.344 5.523.972 5.753.062 5.910.691 5.937.524 6.011.978 6.150.530 6.411.380 6.698.080 6.937.842 7.185.581 7.334.242 7.468.528 7.749.529 7.940.729 7.953.837 7.916.757

YAG€R

Heffing in eindjaar: € 937,85

BATEN - nominaal

LASTEN - vast prijspeil (2023)

€

v4.10

Heffing eind € 227,54 (vanaf 2033) € 641,93 (vanaf 2078)

€ 150.440.394

€

BTW plichtig € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

858.111 869.899 921.395 955.749 846.196 869.882 879.103 900.201 981.043 943.929 1.010.951 961.224 984.293 1.074.612 1.001.443 1.029.759 1.050.089 1.075.291 1.188.450 1.127.524 1.159.406 1.182.295 1.210.670 1.282.862 1.269.480 1.305.375 1.390.431 1.363.093 1.444.374 1.429.307 1.463.610 1.498.737 1.534.707 1.626.221 1.680.928 1.647.879 1.687.428 1.727.926 1.830.962 1.811.862 1.855.347 1.899.875 2.032.118 2.061.480 2.039.975 2.088.934 2.139.069 2.190.407 2.321.020 2.296.808 2.456.680 2.408.377 2.466.179 2.613.236 2.585.976 2.648.039 2.711.592 2.776.670 3.068.876 2.911.550 2.981.427 3.052.981 3.126.253 3.312.671 3.278.114 3.356.788 3.590.441 3.519.848 3.729.735 3.690.828 3.779.408 3.870.113 3.962.996 4.199.309 4.340.577

Exploitatie 69.725.587

€

Overhead

Loonkosten

339.960 348.119 356.474 365.029 373.790 382.761 391.947 401.354 410.986 420.850 430.950 441.293 451.884 462.729 473.835 485.207 496.852 508.776 520.987 533.491 546.295 559.406 572.831 586.579 600.657 615.073 629.835 644.951 660.430 676.280 692.511 709.131 726.150 743.578 761.423 779.698 798.410 817.572 837.194 857.287 877.861 898.930 920.504 942.597 965.219 988.384 1.012.105 1.036.396 1.061.269 1.086.740 1.112.822 1.139.529 1.166.878 1.194.883 1.223.560 1.252.926 1.282.996 1.313.788 1.345.319 1.377.606 1.410.669 1.444.525 1.479.194 1.514.694 1.551.047 1.588.272 1.626.391 1.665.424 1.705.394 1.746.324 1.788.235 1.831.153 1.875.101 1.920.103 1.966.186

83.267.999

405.988 415.732 425.710 435.927 446.389 457.102 468.073 479.307 490.810 502.589 514.651 527.003 539.651 552.603 565.865 579.446 593.353 607.593 622.175 637.108 652.398 668.056 684.089 700.507 717.319 734.535 752.164 770.216 788.701 807.630 827.013 846.861 867.186 887.998 909.310 931.134 953.481 976.365 999.797 1.023.793 1.048.364 1.073.524 1.099.289 1.125.672 1.152.688 1.180.352 1.208.681 1.237.689 1.267.394 1.297.811 1.328.959 1.360.854 1.393.514 1.426.959 1.461.206 1.496.274 1.532.185 1.568.958 1.606.613 1.645.171 1.684.655 1.725.087 1.766.489 1.808.885 1.852.298 1.896.753 1.942.275 1.988.890 2.036.623 2.085.502 2.135.554 2.186.808 2.239.291 2.293.034 2.348.067

€ 606.081.053 TOTAAL

€

excl. BTW

3.455.638 3.478.521 3.566.398 3.632.194 3.500.423 3.563.165 3.605.395 3.651.898 3.769.678 3.788.720 3.919.879 3.906.707 3.965.731 4.098.545 4.114.586 4.250.732 4.326.766 4.401.168 4.548.618 4.617.934 4.793.794 4.863.813 4.991.648 5.118.033 5.215.000 5.444.768 5.639.365 5.650.014 5.784.271 5.916.438 6.161.900 6.266.653 6.418.007 6.648.614 6.865.987 6.961.494 7.091.354 7.287.017 7.511.774 7.736.157 8.079.075 8.272.030 8.502.720 8.664.863 8.797.923 8.866.818 9.007.098 9.166.311 9.335.498 9.410.133 9.758.133 9.798.357 9.975.681 10.197.818 10.265.232 10.542.456 10.799.662 10.943.166 11.404.192 11.506.858 11.830.053 12.133.519 12.309.695 12.648.463 12.832.224 13.253.429 13.857.423 14.112.238 14.657.569 14.857.130 15.171.960 15.637.838 16.018.352 16.366.518 16.571.821

alléén exploitatie BTW compensatie 31.592.483 € 637.673.536 TOTAAL BTW

Egalisatievoorziening Riolering (BBV 44.2) €

180.203 182.679 193.493 200.707 177.701 182.675 184.612 189.042 206.019 198.225 212.300 201.857 206.702 225.668 210.303 216.249 220.519 225.811 249.575 236.780 243.475 248.282 254.241 269.401 266.591 274.129 291.991 286.250 303.319 300.154 307.358 314.735 322.288 341.506 352.995 346.055 354.360 362.864 384.502 380.491 389.623 398.974 426.745 432.911 428.395 438.676 449.204 459.985 487.414 482.330 515.903 505.759 517.897 548.780 543.055 556.088 569.434 583.101 644.464 611.425 626.100 641.126 656.513 695.661 688.404 704.926 753.993 739.168 783.244 775.074 793.676 812.724 832.229 881.855 911.521

3.635.841 3.661.200 3.759.891 3.832.901 3.678.124 3.745.840 3.790.007 3.840.941 3.975.697 3.986.945 4.132.179 4.108.564 4.172.433 4.324.213 4.324.889 4.466.982 4.547.285 4.626.979 4.798.193 4.854.714 5.037.269 5.112.095 5.245.889 5.387.434 5.481.590 5.718.897 5.931.356 5.936.263 6.087.590 6.216.593 6.469.258 6.581.388 6.740.296 6.990.121 7.218.981 7.307.548 7.445.714 7.649.882 7.896.276 8.116.648 8.468.698 8.671.003 8.929.465 9.097.774 9.226.318 9.305.494 9.456.303 9.626.296 9.822.912 9.892.463 10.274.035 10.304.116 10.493.579 10.746.598 10.808.287 11.098.544 11.369.096 11.526.267 12.048.656 12.118.283 12.456.153 12.774.645 12.966.208 13.344.124 13.520.628 13.958.354 14.611.415 14.851.406 15.440.813 15.632.204 15.965.636 16.450.562 16.850.581 17.248.373 17.483.342

€ 642.449.618

Dotatie

incl. BTW

4.776.082

-278.305 -219.697 -223.319 -202.287 44.610 76.149 108.481 133.380 69.589 130.574 58.862 157.313 169.615 95.367 173.607 111.839 141.428 174.263 118.279 179.753 118.025 166.926 159.828 148.021 186.715 85.448 12.294 150.034 144.778 165.352 65.854 110.567 112.265 26.902 -33.550 50.333 88.756 65.416 4.189 -26.571 -184.460 -187.944 -242.812 -202.641 -117.702 21.728 94.774 154.006 192.117 362.927 227.484 449.440 518.062 529.323 738.256 725.115 594.898 579.727 201.023 276.787 86.034 -83.596 29.426 -36.594 106.283 -4.398 -322.564 -219.623 -457.867 -289.667 -254.878 -362.746 -376.658 -379.075 -209.182

TOTAAL

Jaar

3.357.536 3.441.503 3.536.572 3.630.614 3.722.734 3.821.989 3.898.487 3.974.321 4.045.286 4.117.519 4.191.041 4.265.877 4.342.048 4.419.580 4.498.496 4.578.821 4.688.713 4.801.242 4.916.471 5.034.467 5.155.294 5.279.021 5.405.718 5.535.455 5.668.306 5.804.345 5.943.649 6.086.297 6.232.368 6.381.945 6.535.111 6.691.954 6.852.561 7.017.023 7.185.431 7.357.881 7.534.471 7.715.298 7.900.465 8.090.076 8.284.238 8.483.060 8.686.653 8.895.133 9.108.616 9.327.223 9.551.076 9.780.302 10.015.029 10.255.390 10.501.519 10.753.556 11.011.641 11.275.920 11.546.543 11.823.660 11.963.994 12.105.994 12.249.679 12.395.070 12.542.187 12.691.049 12.995.634 13.307.529 13.626.910 13.953.956 14.288.851 14.631.783 14.982.946 15.342.537 15.710.758 16.087.816 16.473.924 16.869.298 17.274.161

1.436.051 Heffingseenheden 18.883 18.902 18.969 19.017 19.042 19.092 19.132 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162 19.162

Rioolheffing 34.891 Heffing Stijging per 1/1 per 31/12 € 184,98 2,4% € 189,42 2,4% € 193,97 2,4% € 198,62 2,4% € 203,39 2,4% € 208,27 1,8% € 211,99 1,8% € 215,77 1,8% € 219,63 1,8% € 223,55 1,8% € 227,54 1,8% € 231,60 1,8% € 235,74 1,8% € 239,95 1,8% € 244,23 1,8% € 248,59 2,4% € 254,56 2,4% € 260,67 2,4% € 266,93 2,4% € 273,33 2,4% € 279,89 2,4% € 286,61 2,4% € 293,49 2,4% € 300,53 2,4% € 307,74 2,4% € 315,13 2,4% € 322,69 2,4% € 330,44 2,4% € 338,37 2,4% € 346,49 2,4% € 354,81 2,4% € 363,32 2,4% € 372,04 2,4% € 380,97 2,4% € 390,11 2,4% € 399,48 2,4% € 409,06 2,4% € 418,88 2,4% € 428,93 2,4% € 439,23 2,4% € 449,77 2,4% € 460,56 2,4% € 471,62 2,4% € 482,94 2,4% € 494,53 2,4% € 506,40 2,4% € 518,55 2,4% € 530,99 2,4% € 543,74 2,4% € 556,79 2,4% € 570,15 2,4% € 583,83 2,4% € 597,85 2,4% € 612,19 2,4% € 626,89 2,4% € 641,93 1,2% € 649,55 1,2% € 657,26 1,2% € 665,06 1,2% € 672,96 1,2% € 680,94 1,2% € 689,02 2,4% € 705,56 2,4% € 722,49 2,4% € 739,83 2,4% € 757,59 2,4% € 775,77 2,4% € 794,39 2,4% € 813,46 2,4% € 832,98 2,4% € 852,97 2,4% € 873,44 2,4% € 894,40 2,4% € 915,87 2,4% € 937,85 2,4% €

€ 668.370.151 SUBTOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

3.493.000 3.580.355 3.679.260 3.777.096 3.872.933 3.976.193 4.055.777 4.134.670 4.208.499 4.283.646 4.360.135 4.437.989 4.517.234 4.597.894 4.679.994 4.763.560 4.877.885 4.994.954 5.114.833 5.237.589 5.363.292 5.492.011 5.623.819 5.758.790 5.897.001 6.038.529 6.183.454 6.331.857 6.483.822 6.639.433 6.798.780 6.961.950 7.129.037 7.300.134 7.475.337 7.654.745 7.838.459 8.026.582 8.219.220 8.416.482 8.618.477 8.825.321 9.037.128 9.254.019 9.476.116 9.703.543 9.936.428 10.174.902 10.419.100 10.669.158 10.925.218 11.187.423 11.455.921 11.730.863 12.012.404 12.300.702 12.446.698 12.594.427 12.743.910 12.895.167 13.048.219 13.203.087 13.519.961 13.844.440 14.176.707 14.516.948 14.865.355 15.222.123 15.587.454 15.961.553 16.344.630 16.736.902 17.138.587 17.549.913 17.971.111

-3,88% € -25.920.534 Kwijtschelding en oninbaar € -135.464 € -138.852 € -142.688 € -146.482 € -150.199 € -154.204 € -157.290 € -160.350 € -163.213 € -166.127 € -169.093 € -172.113 € -175.186 € -178.314 € -181.498 € -184.739 € -189.173 € -193.713 € -198.362 € -203.123 € -207.998 € -212.990 € -218.101 € -223.336 € -228.696 € -234.184 € -239.805 € -245.560 € -251.454 € -257.489 € -263.668 € -269.996 € -276.476 € -283.112 € -289.906 € -296.864 € -303.989 € -311.285 € -318.755 € -326.406 € -334.239 € -342.261 € -350.475 € -358.887 € -367.500 € -376.320 € -385.352 € -394.600 € -404.070 € -413.768 € -423.699 € -433.867 € -444.280 € -454.943 € -465.862 € -477.042 € -482.704 € -488.433 € -494.231 € -500.097 € -506.032 € -512.038 € -524.327 € -536.911 € -549.797 € -562.992 € -576.504 € -590.340 € -604.508 € -619.016 € -633.873 € -649.086 € -664.664 € -680.616 € -696.950

€ 642.449.618 TOTAAL € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

Verloop voorziening(en)

Variant A (activeren)

Overzicht Egalisatievoorziening Riolering (BBV 44.2) Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

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

VAST PRIJSPEIL (2023) € -2.817.348 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

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

-10.569 -3.914 -2.823 -2.455 -7.798 -13.698 -19.609 -25.397 -29.275 -33.698 -36.069 -39.688 -42.928 -44.320 -46.490 -46.895 -47.752 -49.095 -49.609 -51.006 -51.138 -52.076 -52.770 -53.277 -54.320 -53.749 -52.140 -52.370 -52.575 -53.038 -52.004 -51.535 -51.119 -49.721 -47.657 -46.431 -45.698 -44.725 -43.212 -41.410 -37.936 -34.526 -30.816 -27.618 -25.212 -24.271 -24.000 -24.228 -24.844 -26.738 -27.574 -30.000 -32.838 -35.683 -39.872 -43.769 -46.412 -48.737 -48.555 -48.569 -47.292 -45.850 -45.154 -44.171 -43.987 -43.176 -40.701 -38.773 -35.722 -33.545 -31.671 -29.335 -26.964 -24.756

1.007.499 440.374 163.095 117.642 102.287 324.902 570.764 817.048 1.058.207 1.219.778 1.404.063 1.502.872 1.653.660 1.788.678 1.846.661 1.937.092 1.953.940 1.989.687 2.045.636 2.067.046 2.125.261 2.130.738 2.169.846 2.198.751 2.219.867 2.263.316 2.239.558 2.172.497 2.182.084 2.190.619 2.209.915 2.166.816 2.147.298 2.129.969 2.071.718 1.985.697 1.934.630 1.904.095 1.863.559 1.800.486 1.725.412 1.580.649 1.438.602 1.284.008 1.150.767 1.050.492 1.011.304 1.000.000 1.009.517 1.035.148 1.114.100 1.148.932 1.249.987 1.368.249 1.486.803 1.661.324 1.823.694 1.933.814 2.030.701 2.023.109 2.023.699 1.970.490 1.910.408 1.881.415 1.840.454 1.832.779 1.798.979 1.695.871 1.615.562 1.488.414 1.397.721 1.319.624 1.222.299 1.123.497 1.031.520

YAG€R

einde jaar (saldo 31/12) 100%

maximum: € minimum: €

2.317.636 (in 2047) 104.742 (in 2026)

maximum: € minimum: €

8.606.436 (in 2088) 112.465 (in 2026)

eind: €

1.000.000 (in 2097)

eind: €

5.783.581 (in 2097)

NOMINAAL €

Saldo 1/1

t.b.v. vast prijspeil

v4.10

nominaal

€

Rente € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

Dotatie -

€

2.809.849

-556.556 -273.364 -42.630 -12.900 230.413 259.560 265.893 266.556 190.845 217.982 134.878 190.476 177.946 102.303 136.921 63.743 83.500 105.045 71.019 109.221 56.615 91.184 81.675 74.393 97.769 29.991 -14.921 61.957 61.110 72.333 8.905 32.018 33.790 -8.529 -38.365 -4.636 15.164 4.190 -19.862 -33.663 -106.828 -107.521 -123.777 -105.623 -75.063 -14.916 12.696 33.745 50.474 105.690 62.407 131.054 151.100 154.238 214.393 206.139 156.531 145.624 40.963 49.159 -5.917 -14.232 16.160 3.210 36.312 9.375 -62.408 -41.536 -91.426 -57.148 -46.425 -67.990 -71.838 -67.220 -31.520

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

450.943 167.009 120.465 104.742 332.700 584.462 836.658 1.083.604 1.249.052 1.437.760 1.538.941 1.693.348 1.831.606 1.890.981 1.983.582 2.000.834 2.037.439 2.094.732 2.116.655 2.176.267 2.181.875 2.221.922 2.251.521 2.273.144 2.317.636 2.293.307 2.224.637 2.234.454 2.243.194 2.262.953 2.218.819 2.198.833 2.181.088 2.121.440 2.033.353 1.981.061 1.949.793 1.908.285 1.843.697 1.766.822 1.618.585 1.473.128 1.314.824 1.178.385 1.075.703 1.035.576 1.024.000 1.033.745 1.059.991 1.140.838 1.176.507 1.279.987 1.401.087 1.522.486 1.701.196 1.867.463 1.980.225 2.079.438 2.071.664 2.072.268 2.017.782 1.956.258 1.926.569 1.884.625 1.876.766 1.842.155 1.736.572 1.654.335 1.524.136 1.431.266 1.351.295 1.251.634 1.150.460 1.056.277 1.000.000

Saldo 1/1 nominaal € 1.007.499 € 450.943 € 171.018 € 126.317 € 112.465 € 365.807 € 658.046 € 964.600 € 1.279.294 € 1.510.012 € 1.779.861 € 1.950.839 € 2.198.091 € 2.434.622 € 2.573.869 € 2.764.710 € 2.855.686 € 2.977.721 € 3.134.928 € 3.243.764 € 3.415.162 € 3.506.139 € 3.656.182 € 3.793.805 € 3.922.165 € 4.094.908 € 4.149.170 € 4.121.526 € 4.239.068 € 4.357.783 € 4.501.676 € 4.519.815 € 4.586.601 € 4.658.775 € 4.640.120 € 4.554.193 € 4.543.560 € 4.579.173 € 4.589.248 € 4.540.336 € 4.455.446 € 4.179.590 € 3.895.280 € 3.560.131 € 3.267.272 € 3.054.152 € 3.010.786 € 3.048.583 € 3.151.458 € 3.309.027 € 3.646.883 € 3.851.166 € 4.290.453 € 4.809.089 € 5.351.199 € 6.122.826 € 6.882.554 € 7.473.296 € 8.036.065 € 8.198.167 € 8.397.371 € 8.372.817 € 8.312.344 € 8.382.659 € 8.396.964 € 8.562.634 € 8.606.436 € 8.307.873 € 8.104.396 € 7.645.763 € 7.352.202 € 7.107.998 € 6.741.776 € 6.345.540 € 5.965.880

Rente nominaal € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € -

€

4.776.082 Dotatie

-556.556 -279.925 -44.701 -13.851 253.342 292.239 306.554 314.694 230.718 269.849 170.978 247.252 236.531 139.247 190.840 90.977 122.035 157.207 108.836 171.398 90.976 150.044 137.623 128.360 172.743 54.262 -27.643 117.541 118.716 143.892 18.139 66.787 72.174 -18.655 -85.928 -10.632 35.613 10.075 -48.912 -84.890 -275.856 -284.310 -335.150 -292.858 -213.120 -43.366 37.797 102.876 157.568 337.857 204.283 439.287 518.635 542.110 771.627 759.728 590.742 562.769 162.102 199.204 -24.554 -60.473 70.315 14.304 165.671 43.801 -298.562 -203.478 -458.633 -293.561 -244.204 -366.222 -396.236 -379.660 -182.299

Saldo 31/12 nominaal € 450.943 € 171.018 € 126.317 € 112.465 € 365.807 € 658.046 € 964.600 € 1.279.294 ###### € 1.510.012 € 1.779.861 € 1.950.839 € 2.198.091 € 2.434.622 € 2.573.869 € 2.764.710 € 2.855.686 € 2.977.721 € 3.134.928 € 3.243.764 € 3.415.162 € 3.506.139 € 3.656.182 € 3.793.805 € 3.922.165 € 4.094.908 € 4.149.170 € 4.121.526 € 4.239.068 € 4.357.783 € 4.501.676 € 4.519.815 € 4.586.601 € 4.658.775 € 4.640.120 € 4.554.193 € 4.543.560 € 4.579.173 € 4.589.248 € 4.540.336 € 4.455.446 € 4.179.590 € 3.895.280 € 3.560.131 € 3.267.272 € 3.054.152 € 3.010.786 € 3.048.583 € 3.151.458 € 3.309.027 € 3.646.883 € 3.851.166 € 4.290.453 € 4.809.089 € 5.351.199 € 6.122.826 € 6.882.554 € 7.473.296 € 8.036.065 € 8.198.167 € 8.397.371 € 8.372.817 € 8.312.344 € 8.382.659 € 8.396.964 € 8.562.634 € 8.606.436 € 8.307.873 € 8.104.396 € 7.645.763 € 7.352.202 € 7.107.998 € 6.741.776 € 6.345.540 € 5.965.880 € 5.783.581

Variant B (duurzaam financieren) Overzicht Egalisatievoorziening Riolering (BBV 44.2) Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

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

VAST PRIJSPEIL (2023) € -1.842.053 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

-10.832 -4.450 -3.621 -3.553 -4.431 -5.083 -6.532 -8.335 -8.663 -10.208 -9.796 -11.052 -12.343 -12.429 -14.235 -14.046 -13.948 -13.823 -12.624 -12.827 -10.950 -10.585 -10.436 -10.387 -12.173 -12.347 -10.973 -11.676 -12.744 -15.615 -16.211 -17.665 -19.907 -21.061 -21.956 -23.460 -26.486 -29.571 -32.022 -34.980 -34.661 -33.457 -31.050 -28.598 -26.066 -24.660 -23.491 -23.233 -23.632 -25.631 -27.555 -30.925 -35.136 -39.350 -45.278 -51.657 -55.387 -57.816 -57.166 -56.451 -53.821 -50.731 -48.440 -46.210 -45.418 -44.361 -41.600 -39.624 -36.443 -34.034 -32.377 -30.393 -27.942 -25.426

1.007.499 451.333 185.426 150.875 148.023 184.639 211.803 272.177 347.297 360.942 425.324 408.168 460.507 514.295 517.890 593.133 585.236 581.177 575.966 526.005 534.438 456.258 441.044 434.834 432.785 507.196 514.456 457.197 486.510 530.982 650.634 675.445 736.059 829.442 877.539 914.829 977.483 1.103.570 1.232.116 1.334.268 1.457.507 1.444.202 1.394.023 1.293.768 1.191.599 1.086.073 1.027.517 978.807 968.046 984.662 1.067.965 1.148.123 1.288.525 1.463.979 1.639.564 1.886.566 2.152.376 2.307.788 2.408.987 2.381.901 2.352.110 2.242.546 2.113.806 2.018.330 1.925.413 1.892.430 1.848.368 1.733.332 1.650.991 1.518.440 1.418.075 1.349.045 1.266.357 1.164.269 1.059.423

maximum: € minimum: €

2.466.803 (in 2080) 151.575 (in 2026)

eind: €

1.000.000 (in 2097)

YAG€R

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

maximum: € minimum: €

9.760.117 (in 2082) 162.001 (in 2025)

eind: €

5.783.581 (in 2097)

NOMINAAL €

Saldo 1/1

t.b.v. vast prijspeil

v4.10

nominaal

€

1.834.554 Dotatie -545.334 -261.457 -30.930 700 41.048 32.247 66.906 83.455 22.307 74.590 -7.359 63.391 66.132 16.024 89.478 6.149 9.890 8.613 -37.337 21.260 -67.231 -4.629 4.226 8.338 86.583 19.607 -46.287 40.990 57.216 135.266 41.022 78.279 113.290 69.157 59.246 86.114 152.573 158.117 134.174 158.219 21.356 -16.723 -69.205 -73.570 -79.460 -33.896 -25.219 12.473 40.248 108.935 107.713 171.327 210.590 214.934 292.280 317.467 210.799 159.015 30.079 26.660 -55.743 -78.008 -47.036 -46.707 12.436 298 -73.436 -42.717 -96.108 -66.332 -36.652 -52.296 -74.146 -79.419 -59.423

462.165 189.877 154.496 151.575 189.071 216.887 278.710 355.632 369.604 435.532 417.964 471.559 526.639 530.319 607.368 599.281 595.125 589.790 538.629 547.265 467.208 451.629 445.270 443.172 519.368 526.803 468.169 498.186 543.726 666.249 691.656 753.724 849.349 898.600 936.785 1.000.943 1.130.056 1.261.687 1.366.291 1.492.487 1.478.863 1.427.480 1.324.818 1.220.198 1.112.139 1.052.177 1.002.298 991.279 1.008.294 1.093.597 1.175.678 1.319.450 1.499.115 1.678.914 1.931.844 2.204.033 2.363.175 2.466.803 2.439.067 2.408.561 2.296.367 2.164.537 2.066.770 1.971.623 1.937.848 1.892.729 1.774.932 1.690.615 1.554.883 1.452.109 1.381.422 1.296.750 1.192.211 1.084.850 1.000.000

Saldo 1/1 nominaal € 1.007.499 € 462.165 € 194.434 € 162.001 € 162.753 € 207.885 € 244.193 € 321.330 € 419.857 € 446.824 € 539.162 € 529.833 € 612.119 € 700.023 € 721.833 € 846.547 € 855.323 € 869.777 € 882.666 € 825.447 € 858.809 € 750.774 € 743.158 € 750.279 € 764.665 € 917.644 € 953.119 € 867.365 € 945.128 € 1.056.280 € 1.325.364 € 1.408.928 € 1.572.212 € 1.814.198 € 1.965.463 € 2.098.159 € 2.295.661 € 2.653.985 € 3.034.241 € 3.364.662 € 3.763.647 € 3.818.794 € 3.774.576 € 3.587.191 € 3.383.206 € 3.157.600 € 3.059.053 € 2.983.973 € 3.021.996 € 3.147.639 € 3.495.868 € 3.848.453 € 4.422.732 € 5.145.560 € 5.901.006 € 6.952.959 € 8.122.988 € 8.918.535 € 9.533.053 € 9.652.085 € 9.760.117 € 9.528.809 € 9.197.343 € 8.992.686 € 8.784.581 € 8.841.318 € 8.842.713 € 8.491.390 € 8.282.125 € 7.800.003 € 7.459.266 € 7.266.469 € 6.984.786 € 6.575.823 € 6.127.261

€

4.776.082 Dotatie

-545.334 -267.732 -32.433 752 45.133 36.307 77.138 98.526 26.968 92.338 -9.329 82.286 87.904 21.810 124.714 8.776 14.454 12.889 -57.219 33.362 -108.035 -7.616 7.121 14.387 152.979 35.475 -85.755 77.763 111.152 269.084 83.564 163.284 241.987 151.265 132.696 197.502 358.324 380.256 330.421 398.985 55.147 -44.218 -187.385 -203.985 -225.605 -98.548 -75.080 38.024 125.643 348.229 352.585 574.279 722.827 755.447 1.051.953 1.170.028 795.547 614.518 119.032 108.032 -231.308 -331.466 -204.657 -208.105 56.737 1.394 -351.322 -209.265 -482.123 -340.737 -192.797 -281.684 -408.962 -448.563 -343.680

Saldo 31/12 nominaal 462.165 194.434 162.001 162.753 207.885 244.193 321.330 419.857 446.824 539.162 529.833 612.119 700.023 721.833 846.547 855.323 869.777 882.666 825.447 858.809 750.774 743.158 750.279 764.665 917.644 953.119 867.365 945.128 1.056.280 1.325.364 1.408.928 1.572.212 1.814.198 1.965.463 2.098.159 2.295.661 2.653.985 3.034.241 3.364.662 3.763.647 3.818.794 3.774.576 3.587.191 3.383.206 3.157.600 3.059.053 2.983.973 3.021.996 3.147.639 3.495.868 3.848.453 4.422.732 5.145.560 5.901.006 6.952.959 8.122.988 8.918.535 9.533.053 9.652.085 9.760.117 9.528.809 9.197.343 8.992.686 8.784.581 8.841.318 8.842.713 8.491.390 8.282.125 7.800.003 7.459.266 7.266.469 6.984.786 6.575.823 6.127.261 5.783.581

Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - VAST PRIJSPEIL (2023) Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

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

v4.10

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

YAG€R

Dotaties

Saldo

Boekwaarde

€ (in 2023) €

1.886.155 -

€ €

(in 2023)

€

1.886.155

€

(in 2097)

€ (in 2023) €

1.040.000 -

maximum minimum

(in 2097)

€

1.040.000

eind

(in 2097)

€

59.800.000 €

2.021.102

(in 2068)

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

-134.947

Inflatie factor

Afwaardering saldo

-13.125 -0 -0 -2.354 -0 -0 -6.124 -6.769 -1.734 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -9.421 -1.918 -10.657 -9.295 -12.840 -11.480 -10.145 -5.052 -0 -0 -0 -0 -0 -0 -0 -0 -9.627 -24.406

€ -0 Afwaardering boekwaarde

Spaarvoorziening Rioolvervanging (BBV 44.1d) Saldo 1/1

restinvesteringen

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

546.875 0 0 98.068 0 0 255.174 282.038 72.254 0 0 0 0 0 0 0 0 0 0 0 0 392.547 79.917 444.042 387.282 534.993 478.343 422.693 210.519 0 0 0 0 0 0 0 0 401.129 1.016.905

Boekwaarde 1/1 restinvesteringen

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

€ 117.825.334

49,0%

€ -57.778.898

€

Totaal investeringen

% direct

Afboekingen

Rente opbrengsten

19% 44% 42% 38% 39% 20% 54% 67% 94% 46% 17% 57% 59% 81% 52% 15% 100% 50% 64% 100% 19% 27% 100% 100% 92% 15% 75% 70% 26% 39% 30% 100% 37% 27% 35% 14% 35% 52% 70% 46% 66% 40% 85% 78% 100% 100% 39% 79% 58% 100% 70% 38% 100% 100% 77% 45% 38% 100% 100% 100% 52% 35% 50% 39% 56% 90% 43% 41% 100% 100% 100%

975.000 1.070.764 1.050.000 1.240.000 906.991 120.000 545.326 664.393 661.474 1.805.890 680.705 481.699 410.273 1.039.209 2.701.102 588.587 1.026.553 745.721 1.195.882 4.878.897 120.000 2.494.650 1.074.392 578.193 4.365.883 2.508.601 359.656 581.932 1.001.212 4.545.835 1.071.996 1.035.341 2.825.871 1.973.086 2.384.157 395.447 2.320.529 2.769.518 2.258.445 5.097.587 2.267.868 1.617.680 1.177.274 2.018.287 1.501.736 2.287.059 1.179.111 1.224.429 638.032 1.279.276 2.401.938 1.293.321 1.591.585 512.040 2.115.897 2.174.403 642.495 879.449 2.041.240 2.150.760 2.754.881 543.322 1.085.505 1.247.121 2.419.617 2.521.113 2.054.704 2.657.070 1.826.315 1.097.170 2.367.601 2.506.424 629.244 399.819 170.749

-200.000 -240.000 -280.000 -320.000 -360.000 -400.000 -440.000 -480.000 -520.000 -560.000 -600.000 -640.000 -680.000 -720.000 -760.000 -800.000 -240.000 -1.346.875 -800.000 -699.578 -898.068 -800.000 -538.702 -766.367 -1.082.038 -800.000 -800.000 -800.000 -800.000 -800.000 -800.000 -726.012 -872.254 -800.000 -800.000 -800.000 -840.000 -880.000 -920.000 -960.000 -1.000.000 -1.040.000 -1.040.000 -1.040.000 -638.032 -1.350.712 -1.119.917 -1.040.000 -1.040.000 -585.301 -1.484.042 -1.040.000 -643.423 -879.449 -1.574.993 -1.040.000 -1.040.000 -550.177 -1.085.505 -1.247.121 -1.250.519 -1.040.000 -1.040.000 -1.040.000 -1.040.000 -1.040.000 -1.040.000 -1.040.000 -629.244 -399.819 -170.749

Totale mutatie

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

200.000 240.000 280.000 320.000 360.000 400.000 440.000 480.000 520.000 560.000 600.000 640.000 680.000 720.000 760.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 800.000 840.000 880.000 920.000 960.000 1.000.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000 1.040.000

Spaarvoorziening Rioolvervanging (BBV 44.1d)

560.000 -546.875 100.422 -98.068 261.298 33.633 -282.038 73.988 -72.254 401.968 -310.712 -79.917 454.699 -444.042 396.577 160.551 -534.993 489.823 -45.505 -207.121 -210.519 410.756 640.181 869.251

560.000 0 0 100.422 0 0 261.298 288.807 73.988 0 0 0 0 0 0 0 0 0 0 0 0 401.968 81.835 454.699 396.577 547.833 489.823 432.838 215.572 0 0 0 0 0 0 0 0 410.756 1.041.310 1.886.155

Boekwaarde 31/12 restinvesteringen

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

(in 2073)

Overzicht Spaarvoorziening Rioolvervanging (BBV 44.1d) - NOMINAAL Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

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

v4.10

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

YAG€R

Dotaties

Saldo

Boekwaarde

€ (in 2023) €

10.908.730 -

€ €

(in 2023)

€

10.908.730

€

(in 2097)

€ (in 2023) €

6.014.924 -

maximum minimum

(in 2097)

€

6.014.924

eind

(in 2097)

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 € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

899.885 0 0 173.272 0 0 484.100 547.906 169.691 0 0 0 0 0 0 0 0 0 0 0 0 1.254.842 261.599 1.598.167 1.496.667 2.117.122 2.081.308 1.883.312 960.482 0 0 0 0 0 0 0 0 2.265.587 5.881.349

Boekwaarde 1/1 restinvesteringen

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

€ 331.841.604

53,0%

€ -175.737.667

€

Totaal investeringen

% direct

Afboekingen

Rente opbrengsten

975.000 1.096.463 1.101.005 1.331.440 997.247 135.108 628.718 784.377 799.673 2.235.584 862.896 625.281 545.346 1.414.498 3.764.787 840.059 1.500.309 1.116.029 1.832.684 7.656.333 192.833 4.104.959 1.810.347 997.636 7.713.847 4.538.689 666.325 1.104.005 1.945.024 9.042.997 2.183.695 2.159.643 6.036.025 4.315.634 5.339.903 906.957 5.449.861 6.660.435 5.561.704 12.854.730 5.856.203 4.277.508 3.187.689 5.596.044 4.263.748 6.649.292 3.510.370 3.732.773 1.991.776 4.089.423 7.862.481 4.335.149 5.462.954 1.799.705 7.615.391 8.013.784 2.424.752 3.398.664 8.077.771 8.715.443 11.431.422 2.308.633 4.723.122 5.556.558 11.039.359 11.778.487 9.829.837 13.016.676 9.161.630 5.636.000 12.453.903 13.500.550 3.470.691 2.258.187 987.543

-219.902 -270.216 -322.818 -377.789 -435.213 -495.176 -557.766 -623.076 -691.199 -762.233 -836.278 -913.439 -993.821 -1.077.536 -1.164.697 -1.255.420 -385.665 -2.216.289 -1.347.997 -1.207.078 -1.586.749 -1.447.401 -998.039 -1.453.904 -2.102.041 -1.591.434 -1.629.629 -1.668.740 -1.708.790 -1.749.801 -1.791.796 -1.665.108 -2.048.525 -1.923.926 -1.970.100 -2.017.383 -2.169.090 -2.326.917 -2.491.070 -2.661.763 -2.839.214 -3.023.649 -3.096.217 -3.170.526 -1.991.776 -4.317.781 -3.665.925 -3.486.030 -3.569.695 -2.057.201 -5.341.263 -3.832.931 -2.428.254 -3.398.664 -6.232.700 -4.214.352 -4.315.496 -2.337.760 -4.723.122 -5.556.558 -5.705.421 -4.858.817 -4.975.428 -5.094.839 -5.217.115 -5.342.326 -5.470.541 -5.601.834 -3.470.691 -2.258.187 -987.543

€ 186.646.397

€

219.902 270.216 322.818 377.789 435.213 495.176 557.766 623.076 691.199 762.233 836.278 913.439 993.821 1.077.536 1.164.697 1.255.420 1.285.550 1.316.404 1.347.997 1.380.349 1.413.478 1.447.401 1.482.139 1.517.710 1.554.135 1.591.434 1.629.629 1.668.740 1.708.790 1.749.801 1.791.796 1.834.799 1.878.834 1.923.926 1.970.100 2.017.383 2.169.090 2.326.917 2.491.070 2.661.763 2.839.214 3.023.649 3.096.217 3.170.526 3.246.618 3.324.537 3.404.326 3.486.030 3.569.695 3.655.367 3.743.096 3.832.931 3.924.921 4.019.119 4.115.578 4.214.352 4.315.496 4.419.068 4.525.126 4.633.729 4.744.938 4.858.817 4.975.428 5.094.839 5.217.115 5.342.326 5.470.541 5.601.834 5.736.278 5.873.949 6.014.924

Spaarvoorziening Rioolvervanging (BBV 44.1d)

Totale mutatie

10.908.730

899.885 -899.885 173.272 -173.272 484.100 63.806 -547.906 169.691 -169.691 1.254.842 -993.244 -261.599 1.598.167 -1.598.167 1.496.667 620.455 -2.117.122 2.081.308 -197.996 -922.829 -960.482 2.265.587 3.615.762 5.027.381

899.885 0 0 173.272 0 0 484.100 547.906 169.691 0 0 0 0 0 0 0 0 0 0 0 0 1.254.842 261.599 1.598.167 1.496.667 2.117.122 2.081.308 1.883.312 960.482 0 0 0 0 0 0 0 0 2.265.587 5.881.349 10.908.730

Boekwaarde 31/12 restinvesteringen

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

(in 2073)

Variant C (activeren, BTW huidig) Overzicht Egalisatievoorziening Riolering (BBV 44.2) Opdrachtgever: Gemeente Bergen Project: KDP'en BUCH werkorganisatie Projectnummer: -

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

VAST PRIJSPEIL (2023) € -2.256.424 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

-17.090 -11.661 -6.397 -1.831 -2.739 -4.260 -6.366 -8.864 -10.006 -12.243 -13.045 -15.579 -18.205 -19.420 -21.884 -23.208 -24.932 -27.077 -28.251 -30.274 -31.286 -32.930 -34.381 -35.586 -37.229 -37.463 -36.741 -37.733 -38.595 -39.639 -39.468 -39.785 -40.084 -39.433 -38.158 -37.778 -37.778 -37.530 -36.691 -35.584 -33.075 -30.634 -27.815 -25.450 -23.882 -23.497 -23.692 -24.321 -25.194 -27.264 -28.254 -30.734 -33.551 -36.295 -40.251 -43.919 -46.585 -49.009 -49.051 -49.502 -48.828 -47.222 -46.274 -44.997 -44.488 -43.423 -40.825 -38.818 -35.769 -33.609 -31.685 -29.364 -27.076 -24.868

1.007.499 712.103 485.894 266.524 76.298 114.131 177.505 265.231 369.344 416.902 510.135 543.524 649.135 758.534 809.178 911.850 967.002 1.038.839 1.128.203 1.177.132 1.261.404 1.303.565 1.372.079 1.432.552 1.482.753 1.551.201 1.560.966 1.530.861 1.572.212 1.608.142 1.651.625 1.644.485 1.657.706 1.670.181 1.643.047 1.589.910 1.574.078 1.574.092 1.563.762 1.528.773 1.482.652 1.378.143 1.276.431 1.158.942 1.060.407 995.069 979.046 987.187 1.013.383 1.049.731 1.136.000 1.177.241 1.280.590 1.397.971 1.512.276 1.677.145 1.829.973 1.941.021 2.042.025 2.043.772 2.062.575 2.034.481 1.967.585 1.928.074 1.874.864 1.853.671 1.809.306 1.701.056 1.617.407 1.490.365 1.400.367 1.320.227 1.223.517 1.128.153 1.036.168

maximum: € minimum: €

2.112.077 (in 2082) 78.129 (in 2026)

eind: €

1.000.000 (in 2097)

YAG€R

einde jaar (saldo 31/12) 100%

maximum: € minimum: €

8.660.239 (in 2087) 83.891 (in 2026)

eind: €

5.783.581 (in 2097)

NOMINAAL €

Saldo 1/1

t.b.v. vast prijspeil

v4.10

nominaal

€

2.248.925 Dotatie -278.305 -214.548 -212.973 -188.395 40.572 67.634 94.092 112.977 57.563 105.476 46.434 121.189 127.604 70.064 124.557 78.360 96.769 116.441 77.181 114.545 73.447 101.443 94.854 85.787 105.677 47.228 6.636 79.084 74.525 83.121 32.328 53.006 52.559 12.299 -14.980 21.946 37.792 27.201 1.701 -10.537 -71.434 -71.077 -89.675 -73.085 -41.456 7.474 31.834 50.517 61.542 113.533 69.495 134.083 150.933 150.599 205.121 196.748 157.632 150.012 50.798 68.304 20.734 -19.674 6.763 -8.213 23.295 -941 -67.425 -44.831 -91.273 -56.390 -48.455 -67.345 -68.289 -67.116 -36.168

← 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://www.raadbergen-nh.nl/api/v1/meetings/4975/documents/37250