Document · PDF

gemSchagen PSWR 2023-2027 definitief

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

Open het PDF bij de gemeente ↗Naar de vergadering →

Tekst van het document

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

€

2.514.698

eind

(in 2081)

€

3.180.324

(in 2081)

(in 2047)

ICpos

Jaar

Inflatie factor

Afwaardering saldo

Spaarvoorzieni ng Saldo 1/1

2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

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

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

€

-1.072.305

-88.003 -11.500 -26.462 -44.765 -64.456 -85.787 -74.015 -62.485 -53.398 -41.181 -34.246 -28.893 -24.495 -21.066 -18.649 -9.821 -11.744 -13.257 -17.624 -17.481 -23.215 -22.498 -22.296 -20.459 -16.355 -17.872 -15.962 -15.903 -12.131 -6.671 -7.819 -8.405 -9.425 -3.700 -4.012 -9.207 -21.692 -36.034 -49.318

5.190.156 977.816 574.992 1.323.091 2.238.228 3.222.821 4.289.361 3.700.746 3.124.238 2.669.912 2.059.064 1.712.304 1.444.628 1.224.764 1.053.302 932.437 491.048 587.223 662.854 881.216 874.066 1.160.742 1.124.915 1.114.784 1.022.931 817.753 893.590 798.119 795.165 606.572 333.536 390.959 420.252 471.251 184.988 200.624 460.365 1.084.597 1.801.714 2.465.921

€ 192.884.246 73,2%

€ -141.247.181

€ 140.309.654

Totaal investeringen

% direct

Afboekingen

Dotatie

Totale mutatie

Spaarvoorzieni ng Saldo 31/12

100% 16% 11% 12% 12% 13% 27% 34% 39% 48% 61% 74% 77% 77% 78% 75% 79% 78% 80% 80% 79% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

1.046.998 € 196.093 € 797.449 € 874.405 € 870.934 € 955.124 € 1.053.564 € 1.342.441 € 1.649.299 € 1.980.602 € 2.409.586 € 2.790.817 € 2.828.646 € 2.869.264 € 2.942.843 € 2.989.627 € 3.014.827 € 3.058.386 € 3.105.428 € 3.131.752 € 3.155.983 € 3.176.695 € 3.344.996 € 3.419.015 € 3.504.001 € 3.607.279 € 2.280.680 € 2.338.479 € 2.394.352 € 2.447.219 € 2.497.333 € 2.556.496 € 2.599.912 € 2.644.884 € 2.693.064 € 2.746.773 € 2.802.936 € 2.841.127 € 2.882.105 € 2.917.590 € 2.951.848 € 1.838.712 € 1.865.805 € 1.892.137 € 1.917.728 € 1.942.598 € 1.966.764 € 1.990.555 € 2.013.387 € 2.037.927 € 2.061.575 € 2.082.930 € 2.156.636 € 2.235.751 € 2.308.034 € 2.375.564 € 2.438.937 € 2.467.093 € 2.491.972 € 2.514.698 €

-4.124.337 -977.816 586.491 774.561 959.902 1.049.049 1.152.328 -514.600 -514.024 -400.928 -569.666 -312.513 -238.784 -195.368 -150.396 -102.217 -431.568 107.919 88.888 235.986 10.332 309.891 -13.329 12.164 -71.394 -188.823 93.709 -79.508 12.949 -176.462 -266.365 65.242 37.698 60.424 -282.564 19.649 268.948 645.924 753.151 713.525 714.403

5.171.335 7.159.670 7.128.458 7.346.942 7.288.680 7.192.963 3.885.147 3.936.127 4.201.429 4.089.500 3.946.531 3.754.456 3.675.385 3.739.890 3.761.738 3.997.062 3.839.841 3.928.275 3.892.901 3.892.901 3.974.053 2.590.203 2.570.435 2.459.113 2.454.951 2.454.951 2.795.280 2.852.502 2.795.280 3.016.885 2.809.846 2.795.280 2.795.280 2.795.280 2.795.280 3.178.340 2.695.017 2.752.239 2.646.119 2.907.259 2.641.957 1.852.041 1.853.640 1.963.530 2.106.551 1.848.889 2.046.272 1.977.606 2.189.848 2.304.292 1.996.333 2.045.232 2.096.212 2.518.314 2.288.385 2.106.616 1.793.013 1.713.942 1.778.447 1.800.295

Onze referentie: 1.9 - Datum: 11 januari 2023

-5.171.335 -1.173.909 -797.449 -874.405 -870.934 -955.124 -1.053.564 -1.342.441 -1.649.299 -1.980.602 -2.409.586 -2.790.817 -2.828.646 -2.869.264 -2.942.843 -2.989.627 -3.014.827 -3.058.386 -3.105.428 -3.131.752 -3.155.983 -2.590.203 -2.570.435 -2.459.113 -2.454.951 -2.454.951 -2.795.280 -2.852.502 -2.795.280 -3.016.885 -2.809.846 -2.795.280 -2.795.280 -2.795.280 -2.795.280 -3.178.340 -2.695.017 -2.752.239 -2.646.119 -2.907.259 -2.641.957 -1.852.041 -1.853.640 -1.963.530 -2.106.551 -1.848.889 -2.046.272 -1.977.606 -2.189.848 -2.304.292 -1.996.333 -2.045.232 -2.096.212 -2.518.314 -2.288.385 -2.106.616 -1.793.013 -1.713.942 -1.778.447 -1.800.295

€

-937.527

1.065.819 586.491 1.349.552 2.282.992 3.287.277 4.375.148 3.774.761 3.186.722 2.723.310 2.100.245 1.746.550 1.473.520 1.249.259 1.074.368 951.085 500.869 598.967 676.111 898.840 891.547 1.183.957 1.147.414 1.137.079 1.043.390 834.108 911.462 814.082 811.069 618.703 340.207 398.778 428.657 480.676 188.687 204.637 469.572 1.106.289 1.837.748 2.515.239 3.180.324

(in 2022)

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

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

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

30105824

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

v4.10

YAG€R

Dotaties

Saldo

€ €

8.644.151 213.741

maximum minimum

(in 2081) (in 2023)

€ €

10.932.207 -

(in 2023)

(in 2023) (in 2081)

€

8.644.151

eind

(in 2081)

€

10.932.207

(in 2081)

(in 2047)

ICpos

Jaar

Inflatie factor

Spaarvoorzieni ng Saldo 1/1

5.190.156 1.065.819 949.930 2.229.564 3.847.111 5.650.239 7.670.495 6.750.256 5.812.664 5.066.735 3.985.670 3.380.747 2.909.295 2.515.848 2.206.912 1.992.745 1.070.425 1.305.676 1.503.317 2.038.522 2.062.422 2.793.632 2.761.553 2.791.414 2.612.645 2.130.377 2.374.502 2.163.228 2.198.325 1.710.476 959.352 1.147.008 1.257.607 1.438.427 575.941 637.116 1.491.207 3.583.477 6.071.866 8.476.481

€ 319.193.455 88,8%

€ -283.506.501

Totaal investeringen

% direct

Afboekingen

1.122.129 3.620.241 3.657.944 3.978.872 3.991.056 3.957.946 4.494.503 4.646.972 5.072.087 4.879.885 4.944.956 4.988.560 4.981.168 5.169.962 5.304.168 5.748.702 5.633.033 5.878.021 5.941.591 6.060.423 6.310.495 4.195.307 4.246.555 4.143.896 4.219.620 4.304.012 4.998.689 5.203.038 5.200.636 5.725.193 5.438.937 5.518.957 5.629.336 5.741.923 5.856.761 6.792.548 5.874.812 6.119.540 6.001.256 6.725.378 6.233.886 4.457.424 4.550.499 4.916.673 5.380.292 4.816.649 5.437.480 5.360.117 6.054.086 6.497.890 5.742.063 6.000.366 6.272.931 7.686.796 7.124.670 6.689.925 5.807.904 5.662.813 5.993.455 6.188.425

-5.171.335 -1.279.560 -886.604 -991.607 -1.007.423 -1.126.904 -1.267.909 -1.647.869 -2.065.033 -2.529.444 -3.138.849 -3.708.170 -3.833.602 -3.966.423 -4.149.501 -4.299.776 -4.422.741 -4.576.374 -4.739.700 -4.875.474 -5.011.462 -4.195.307 -4.246.555 -4.143.896 -4.219.620 -4.304.012 -4.998.689 -5.203.038 -5.200.636 -5.725.193 -5.438.937 -5.518.957 -5.629.336 -5.741.923 -5.856.761 -6.792.548 -5.874.812 -6.119.540 -6.001.256 -6.725.378 -6.233.886 -4.457.424 -4.550.499 -4.916.673 -5.380.292 -4.816.649 -5.437.480 -5.360.117 -6.054.086 -6.497.890 -5.742.063 -6.000.366 -6.272.931 -7.686.796 -7.124.670 -6.689.925 -5.807.904 -5.662.813 -5.993.455 -6.188.425

Onze referentie: 1.9 - Datum: 11 januari 2023

€ 289.248.552 € Dotatie € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € € €

1.046.998 213.741 886.604 991.607 1.007.423 1.126.904 1.267.909 1.647.869 2.065.033 2.529.444 3.138.849 3.708.170 3.833.602 3.966.423 4.149.501 4.299.776 4.422.741 4.576.374 4.739.700 4.875.474 5.011.462 5.145.237 5.526.189 5.761.443 6.022.747 6.324.269 4.078.450 4.265.446 4.454.708 4.644.127 4.834.014 5.047.505 5.235.890 5.432.987 5.642.594 5.870.229 6.110.062 6.317.180 6.536.461 6.749.278 6.965.096 4.425.345 4.580.361 4.737.904 4.898.024 5.060.774 5.226.206 5.395.214 5.566.237 5.746.765 5.929.719 6.110.966 6.453.751 6.824.311 7.185.845 7.544.016 7.900.173 8.151.202 8.398.070 8.644.151

Totale mutatie

Spaarvoorzieni ng Saldo 31/12

-4.124.337 -1.065.819 949.930 1.279.634 1.617.548 1.803.127 2.020.257 -920.239 -937.592 -745.929 -1.081.065 -604.923 -471.452 -393.447 -308.936 -214.167 -922.319 235.251 197.641 535.205 23.900 731.210 -32.079 29.861 -178.770 -482.268 244.125 -211.274 35.097 -487.849 -751.124 187.656 110.599 180.819 -862.485 61.175 854.091 2.092.270 2.488.389 2.404.615 2.455.726

5.742.051

1.065.819 949.930 2.229.564 3.847.111 5.650.239 7.670.495 6.750.256 5.812.664 5.066.735 3.985.670 3.380.747 2.909.295 2.515.848 2.206.912 1.992.745 1.070.425 1.305.676 1.503.317 2.038.522 2.062.422 2.793.632 2.761.553 2.791.414 2.612.645 2.130.377 2.374.502 2.163.228 2.198.325 1.710.476 959.352 1.147.008 1.257.607 1.438.427 575.941 637.116 1.491.207 3.583.477 6.071.866 8.476.481 10.932.207

(in 2022)

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

Scenario 2

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

VAST PRIJSPEIL (2022) € Jaar 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081

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

Afwaardering

795.000 -

YAG€R

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

maximum: € minimum: €

(in 2022)

maximum: € minimum: €

(in 2022)

eind: €

(in 2081)

eind: €

(in 2081)

NOMINAAL €

€

-795.000 Dotatie

Rente

Saldo 1/1

t.b.v. vast prijspeil

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

v4.10

nominaal

Opdrachtgever: Gemeente Schagen Project: GRP Noordkop Projectnummer: 3010.5824

Onze referentie: 1.9 - Datum: 11 januari 2023

-795.000 -

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

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

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

€

-795.000 Dotatie

-795.000 -

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

(in 2022)

PROGRAMMA STEDELIJK WATER EN RIOLERING SCHAGEN 2023-2027

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

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

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

v4.10

YAG€R

Dotaties

Saldo

€ €

4.432.640 196.093

maximum minimum

(in 2042) (in 2023)

€ €

2.638.043 -

(in 2023)

(in 2023) (in 2081)

€

2.387.593

eind

(in 2081)

€

2.554.883

(in 2081)

(in 2042)

ICpos

Jaar

Inflatie factor

Afwaardering saldo

Spaarvoorzieni ng Saldo 1/1

€

100

-1.074.954

-88.003 -298 -3.695 -7.229 -12.383 -14.340 -20.660 -26.584 -34.644 -43.589 -51.726 -42.533 -36.856 -34.580 -33.759 -34.647 -29.724 -24.568 -21.392 -14.631 -12.701 -11.904 -11.653 -11.984 -12.956 -7.167 -11.721 -15.494 -21.765 -23.195 -30.192 -29.709 -29.574 -27.647 -23.304 -24.437 -22.008 -21.300 -16.755 -10.404 -10.551 -10.028 -9.828 -2.759 -1.582 -5.137 -15.814 -28.193 -39.352

5.190.156 977.816 14.890 184.752 361.450 619.126 716.997 1.032.990 1.329.220 1.732.181 2.179.456 2.586.317 2.126.640 1.842.805 1.729.022 1.687.966 1.732.338 1.486.179 1.228.424 1.069.598 731.529 635.044 595.205 582.646 599.177 647.792 358.372 586.071 774.699 1.088.229 1.159.759 1.509.588 1.485.438 1.478.708 1.382.367 1.165.182 1.221.851 1.100.399 1.064.985 837.774 520.223 527.526 501.412 491.398 137.931 79.089 256.839 790.710 1.409.633 1.967.585

€ 192.884.246 80,4%

€ -155.134.013

€ 153.573.694

Totaal investeringen

% direct

Afboekingen

Dotatie

Totale mutatie

Spaarvoorzieni ng Saldo 31/12

100% 16% 12% 14% 16% 19% 41% 51% 60% 75% 94% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

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

-4.124.337 -977.816 15.188 173.557 183.927 270.059 112.211 336.653 322.814 437.605 490.865 458.586 -417.143 -246.980 -79.202 -7.297 79.019 -216.436 -233.187 -137.434 -323.439 -83.784 -27.935 -906 28.514 61.571 -282.253 239.420 204.122 335.295 94.725 380.021 5.558 22.844 -68.694 -193.882 81.106 -99.444 -14.115 -210.455 -307.146 17.853 -16.086 -185 -350.709 -57.261 182.887 549.685 647.116 597.304 587.298

Onze referentie: 1.9 - Datum: 11 januari 2023

-5.171.335 -1.173.909 -872.285 -1.037.367 -1.136.780 -1.340.211 -1.575.989 -2.023.078 -2.510.488 -3.046.949 -3.708.159 -3.754.456 -3.675.385 -3.739.890 -3.761.738 -3.997.062 -3.839.841 -3.928.275 -3.892.901 -3.892.901 -3.974.053 -2.590.203 -2.570.435 -2.459.113 -2.454.951 -2.454.951 -2.795.280 -2.852.502 -2.795.280 -3.016.885 -2.809.846 -2.795.280 -2.795.280 -2.795.280 -2.795.280 -3.178.340 -2.695.017 -2.752.239 -2.646.119 -2.907.259 -2.641.957 -1.852.041 -1.853.640 -1.963.530 -2.106.551 -1.848.889 -2.046.272 -1.977.606 -2.189.848 -2.304.292 -1.996.333 -2.045.232 -2.096.212 -2.518.314 -2.288.385 -2.106.616 -1.793.013 -1.713.942 -1.778.447 -1.800.295

€

-1.560.319

1.065.819 15.188 188.447 368.679 631.508 731.337 1.053.650 1.355.804 1.766.824 2.223.046 2.638.043 2.169.173 1.879.661 1.763.603 1.721.725 1.766.985 1.515.903 1.252.992 1.090.990 746.160 647.745 607.109 594.299 611.160 660.748 365.540 597.792 790.193 1.109.994 1.182.954 1.539.780 1.515.147 1.508.282 1.410.014 1.188.485 1.246.288 1.122.407 1.086.284 854.529 530.628 538.076 511.440 501.226 140.690 80.670 261.976 806.524 1.437.826 2.006.937 2.554.883

(in 2022)

← Vorig deel

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