Bijlage Rekenvoorbeeld bestemmingsreserve vervanging maatschappelijk vastgoed

Bijlage - Rekenvoorbeeld bestemmingsreserve vervanging maatschappelijk vastgoed Afschrijving in jaren: 40

Investering jaar 1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Investering jaar 41 41

Boekwaarde 10.000.000 9.750.000 9.500.000 9.250.000 9.000.000 8.750.000 8.500.000 8.250.000 8.000.000 7.750.000 7.500.000 7.250.000 7.000.000 6.750.000 6.500.000 6.250.000 6.000.000 5.750.000 5.500.000 5.250.000 5.000.000 4.750.000 4.500.000 4.250.000 4.000.000 3.750.000 3.500.000 3.250.000 3.000.000 2.750.000 2.500.000 2.250.000 2.000.000 1.750.000 1.500.000 1.250.000 1.000.000 750.000 500.000 250.000 21.647.448

Afschrijving (a) 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 250.000 541.186

2,00% Herbouwwaarde (stijging 2% per Storting Onttrekking jaar) reserve (b) reserve (c) 10.000.000 10.200.000 4.000 10.404.000 8.080 10.612.080 12.242 10.824.322 16.486 11.040.808 20.816 11.261.624 25.232 11.486.857 29.737 11.716.594 34.332 11.950.926 39.019 12.189.944 43.799 12.433.743 48.675 12.682.418 53.648 12.936.066 58.721 13.194.788 63.896 13.458.683 69.174 13.727.857 74.557 14.002.414 80.048 14.282.462 85.649 14.568.112 91.362 14.859.474 97.189 15.156.663 103.133 15.459.797 109.196 15.768.993 115.380 16.084.372 121.687 16.406.060 128.121 16.734.181 134.684 17.068.865 141.377 17.410.242 148.205 17.758.447 155.169 18.113.616 162.272 18.475.888 169.518 18.845.406 176.908 19.222.314 184.446 19.606.760 192.135 19.998.896 199.978 20.398.873 207.977 20.806.851 216.137 21.222.988 224.460 21.647.448 232.949 22.080.397 -102.010

Stand Storting Onttrekkin Stand reserve reserve 2 g reserve 2 reserve inv.jaar 1 (d) (e) inv.jaar 41 4.000 12.080 24.322 40.808 61.624 86.857 116.594 150.926 189.944 233.743 282.418 336.066 394.788 458.683 527.857 602.414 682.462 768.112 859.474 956.663 1.059.797 1.168.993 1.284.372 1.406.060 1.534.181 1.668.865 1.810.242 1.958.447 2.113.616 2.275.888 2.445.406 2.622.314 2.806.760 2.998.896 3.198.873 3.406.851 3.622.988 3.847.448 4.080.397 3.978.387 8.659 8.659

Structurele last begroting (a+b+c+d+e) 250.000 254.000 258.080 262.242 266.486 270.816 275.232 279.737 284.332 289.019 293.799 298.675 303.648 308.721 313.896 319.174 324.557 330.048 335.649 341.362 347.189 353.133 359.196 365.380 371.687 378.121 384.684 391.377 398.205 405.169 412.272 419.518 426.908 434.446 442.135 449.978 457.977 466.137 474.460 482.949 447.835

42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 Investering jaar 81 81

21.106.261 20.565.075 20.023.889 19.482.703 18.941.517 18.400.331 17.859.144 17.317.958 16.776.772 16.235.586 15.694.400 15.153.213 14.612.027 14.070.841 13.529.655 12.988.469 12.447.282 11.906.096 11.364.910 10.823.724 10.282.538 9.741.351 9.200.165 8.658.979 8.117.793 7.576.607 7.035.420 6.494.234 5.953.048 5.411.862 4.870.676 4.329.490 3.788.303 3.247.117 2.705.931 2.164.745 1.623.559 1.082.372 541.186 47.798.423

541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186 541.186

22.522.005 22.972.445 23.431.894 23.900.531 24.378.542 24.866.113 25.363.435 25.870.704 26.388.118 26.915.880 27.454.198 28.003.282 28.563.347 29.134.614 29.717.307 30.311.653 30.917.886 31.536.244 32.166.969 32.810.308 33.466.514 34.135.844 34.818.561 35.514.932 36.225.231 36.949.736 37.688.730 38.442.505 39.211.355 39.995.582 40.795.494 41.611.404 42.443.632 43.292.504 44.158.355 45.041.522 45.942.352 46.861.199 47.798.423 48.754.392

-102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010 -102.010

3.876.377 3.774.367 3.672.357 3.570.347 3.468.337 3.366.327 3.264.317 3.162.307 3.060.297 2.958.288 2.856.278 2.754.268 2.652.258 2.550.248 2.448.238 2.346.228 2.244.218 2.142.208 2.040.198 1.938.188 1.836.178 1.734.169 1.632.159 1.530.149 1.428.139 1.326.129 1.224.119 1.122.109 1.020.099 918.089 816.079 714.069 612.059 510.050 408.040 306.030 204.020 102.010 -0 -0

17.491 26.500 35.689 45.062 54.622 64.373 74.320 84.465 94.813 105.369 116.135 127.117 138.318 149.743 161.397 173.284 185.409 197.776 210.390 223.257 236.381 249.768 263.422 277.350 291.556 306.046 320.826 335.901 351.278 366.963 382.961 399.279 415.924 432.901 450.218 467.881 485.898 504.275 523.020 542.139

-233.901

26.150 52.650 88.339 133.401 188.023 252.396 326.716 411.181 505.994 611.363 727.498 854.614 992.932 1.142.676 1.304.073 1.477.357 1.662.766 1.860.542 2.070.932 2.294.189 2.530.571 2.780.339 3.043.761 3.321.111 3.612.666 3.918.712 4.239.538 4.575.439 4.926.717 5.293.680 5.676.641 6.075.920 6.491.843 6.924.745 7.374.963 7.842.844 8.328.742 8.833.017 9.356.037 9.898.176

456.667 465.676 474.865 484.238 493.798 503.550 513.496 523.641 533.990 544.545 555.311 566.293 577.494 588.920 600.573 612.460 624.585 636.952 649.567 662.433 675.558 688.944 702.599 716.526 730.732 745.222 760.002 775.077 790.454 806.139 822.137 838.455 855.100 872.077 889.394 907.058 925.074 943.451 962.196 849.424