1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Drinking water supply (See section 07.07 of the Project)
(discounted by 7% per annum over 20 years) - Factor : 1.000 0.930 0.865 0.804 0.748 0.696 0.647 0.602 0.560 0.520 0.484 0.450 0.412 0.389 0.362 0.337 0.313 0.291 0.271 0.252
Revenues
Water points at 100 m. (Point 01) Euro 1.095.000   0 0 1.018.350 947.707 880.771 819.117 761.779 708.454 655.886 612.742 569.850 529.961 492.863 458.363 426.277 396.438 368.687 342.879 318.878 296.556 275.797
Washing area (Point 02) Euro 624.000  0 580.320 539.698 501.919 466.784 434.110 403.722 375.461 349.179 324.736 302.005 280.865 261.204 242.920 225.915 210.101 195.394 181.717 168.996 157.167
Reduction medical treatment (Point 03) Euro 500.000 0 465.000 432.450 402.178 374.026 347.844 323.495 300.850 279.791 260.206 241.991 225.051 209.298 194.647 181.022 168.350 156.566 145.606 135.414 125.935
Productivity increase (Point 04) Euro 450.000 0 418.500 389.205 361.961 336.623 313.060 291.146 270.765 251.812 234.185 217.792 202.547 188.368 175.183 162.920 151.515 140.909 131.046 121.872 113.334
Present value of revenues water sector discounted by 7% per annum 0 2.482.170 2.309.060 2.146.829 1.996.550 1.856.793 1.726.817 1.602.962 1.493.524 1.388.977 1.291.749 1.201.326 1.117.233 1.039.027 966.295 898.653 835.748 777.247 722.838 672.233
Costs  
Specific costs water budget items 60901-60923  -206.350
Bore-holes budget item 70101 -525.000
Purchase equipment budget 70203-70209 -1.029.300
Direct investments water services -1.760.650
Quota common costs 1760650/2087450 (84.34%) of 2912550 -2.456.445
Total investments water sector -4.217.095 -4.217.095 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Quota maintenance costs 84.34% Euro 100.000 discounted by 7% per annum -84.340 0 -78.436 -72.946 -67.839 -63.091 -58.674 -54.567 -50.747 -47.195 -43.891 -40.819 -37.962 -35.304 -32.833 -30.535 -28.397 -26.409 -24.561 -22.842 -21.243
Present value of revenue (11) net of investments (19) and maintenance  (20)  -4.217.095 2.403.734 2.236.114 2.078.990 1.933.459 1.798.119 1.672.250 1.552.215 1.446.329 1.345.086 1.250.930 1.163.364 1.081.929 1.006.194 935.760 870.256 809.339 752.686 699.996 650.990 21.470.645
Progressive total (22)  -4.217.095 -1.813.361 422.753 2.501.743 4.435.202 6.233.321 7.905.571 9.457.786 10.904.115 12.249.201 13.500.131 14.663.495 15.745.424 16.751.618 17.687.378 18.557.634 19.366.973 20.119.659 20.819.655 21.470.645
Factor benefits water sector:  value (22) divided total investments (19)  0.00 0.00 0.10 0.59 1.05 1.49 1.87 2.24 2.59 2.90 3.20 3.48 3.73 3.97 4.19 4.40 4.59 4.77 4.94 5.09
Hygiene education (See section 07.07 of Project)
(discounted by 7% over 20 years) - Factor 1.000 0.930 0.865 0.804 0.748 0.696 0.647 0.602 0.560 0.520 0.484 0.450 0.412 0.389 0.362 0.337 0.313 0.291 0.271 0.252
Revenues
Reduction medical costs (Point 05) Euro 250.000 0 232.500 216.225 201.089 187.013 173.922 161.748 150.425 139.895 130.103 120.996 112.526 104.649 97.324 90.511 84.175 78.283 72.803 67.707 62.967
Reduction malaria costs (Point 06) Euro 100.000 0 93.000 86.490 80.436 74.805 69.569 64.699 60.170 55.958 52.041 48.398 45.010 41.860 38.929 36.204 33.670 31.313 29.121 27.083 25.187
Increased productivity (Point 07) Euro 90.000  0 83.700 77.841 72.392 67.325 62.612 58.229 54.153 50.362 46.837 43.558 40.509 37.674 35.037 32.584 30.303 28.182 26.209 24.374 22.668
Reduction urgent transport (Point 08) Euro 190.000 0 176.700 164.331 152.828 142.130 132.181 122.928 114.323 106.321 98.878 91.957 85.197 79.533 73.659 68.788 63.973 59.495 55.440 51.457 47.855
Present value revenues hygiene sector discounted by 7% per annum 0 585.900 544.887 506.745 471.273 438.284 407.604 379.071 352.536 327.859 304.909 283.242 263.716 244.949 228.087 212.121 197.273 183.573 170.621 158.677
Costs
Health clubs budget items 60101-60105 -147.500
School courses budget items 60201-60203 -34.000
Total direct investments hygiene services -181.500
Quota common costs 181500/2087450 (8.70%) of 2912550 -253.392
Total investments hugiene sctor -434.892 -434.892 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Quota maintenance costs 8.70% Euro 100.000 discounted by 7% per annum 0 -8.091 -7.525 -6.998 -6.508 -6.052 -5.629 -5.235 -4.868 -4.528 -4.211 -3.916 -3.642 -3.387 -3.150 -2.929 -2.724 -2.534 -2.356 -2.191
Present value revenues(36) net of investments (43)and maintenanc (44) -434.892 577.809 537.362 499.747 464.765 432.232 401.975 373.836 347.668 323.331 300.698 279.326 260.074 241.562 224.937 209.192 194.549 181.039 168.265 156.486 5.739.961
Progressive total (46) -434.892 142.917 680.279 1.180.026 1.644.791 2.077.023 2.478.998 2.852.834 3.200.502 3.523.833 3.824.531 4.103.857 4.363.931 4.605.493 4.830.430 5.039.622 5.234.171 5.415.210 5.583.475 5.739.961
Factor benefits hygiene sector: value (46) divided total investments (43) 0 0 1.56 2.71 3.78 4.78 5.70 6.56 7.36 8.10 8.79 9.44 10.03 10.59 11.11 11.59 12.04 12.45 12.84 13.20
Improved stoves, elimination smoke (See section 07.07 of the project
(discounted by 7% per annum over 20 years) Factor 1.000 0.930 0.865 0.804 0.748 0.696 0.647 0.602 0.560 0.520 0.484 0.450 0.412 0.389 0.362 0.337 0.313 0.291 0.271 0.252
Revenues
Elimination search for wood (Point 09) Euro 374.000 0 0 100.277 181.851 260.187 241.974 225.036 209.283 194.633 181.009 168.338 156.555 145.596 135.404 125.926 117.111 108.913 101.289 94.199 87.605
Elimination costs purchase wood (Point 10) Euro 730.000 0 0 195.727 354.951 507.852 472.302 439.241 408.494 379.900 353.307 328.575 305.575 284.185 264.292 245.791 228.596 212.585 197.703 183.865 170.994
Automatic reforestation (Point 11)  Euro 178.000 0 0 47.725 86.550 123.832 115.164 107.102 99.605 92.633 86.149 80.118 74.510 69.294 64.444 59.932 55.737 51.836 48.207 44.833 41.694
CER certificates (Point 12) Euro 450.000 0 0 120.654 218.805 313.060 291.146 270.766 251.812 234.185 217.792 202.547 188.368 175.183 162.920 151.515 140.909 131.046 121.873 113.341 105.408
Present value revenue stoves sector, discounted by 7% per annum 0 0 464.383 842.157 1.204.931 1.120.586 1.042.145 969.194 901.351 838.257 779.578 725.008 674.258 627.060 583.164 542.353 504.380 469.072 436.238 405.701
Costs
Stoves budget items 60801-60806 -88.300
Direct investments stoves/elimination smoke -88.300
Quota commoon costs 88300/2087450 (4.23%) of 2912550 -123.200
Total investments stoves/smoke elimination sector -211.500 -211.500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Quota maintenance costs 4.23% Euro 100.000 discounted by 7% per annum  0 0 -3.934 -3.659 -3.402 -3.164 -2.943 -2.737 -2.545 -2.367 -2.201 -2.047 -1.903 -1.904 -1.771 -1.647 -1.531 -1.424 -1.325 -1.232
Present value revenues (59) net of investments (65) and maintenance (66) -211.500 0 460.449 838.498 1.201.529 1.117.422 1.039.202 966.457 898.806 835.890 777.377 722.961 672.355 625.156 581.393 540.706 502.849 467.648 434.913 404.469 12.876.580
Progressive total (68) -211.500 -211.500 248.949 1.087.447 2.288.976 3.406.398 4.445.600 5.412.057 6.310.863 7.146.753 7.924.130 8.647.091 9.319.446 9.944.602 10.525.995 11.066.701 11.569.550 12.037.198 12.472.111 12.876.580
Factor benefits sector stoves/smoke elimination: value (69) divided total investments (65)   0 0 1.78 5.14 10.83 16.11 21.02 25.59 29.84 33.79 37.47 40.88 44.06 47.02 49.77 52.33 54.70 56.91 58.97 60.88
Eco-sanitation structures and mill (See section 07.07 of the Project)
(discounted by 7% per annum over 20 years) Factor 1.000 0.930 0.865 0.804 0.748 0.696 0.647 0.602 0.560 0.520 0.484 0.450 0.412 0.389 0.362 0.337 0.313 0.291 0.271 0.252
Revenues
Reduction food importation (Point 14) Euro 6.387.500 0 0 1.841.516 3.339.590 4.778.182 4.443.709 4.132.650 3.843.364 3.574.329 3.324.126 3.091.437 2.875.036 2.673.784 2.486.619 2.312.555 2.150.676 2.000.129 1.860.120 1.729.911 1.608.818
Reduction hand milling etc (Point 15) Euro 1.642.500 0 763.763 1.420.598 1.321.156 1.228.675 1.142.668 1.062.681 988.294 919.113 854.776 794.941 739.295 687.544 639.416 594.657 553.031 514.319 478.317 444.834 413.696
Present value  revenues eco-sanitation sector discounted by 7% per annum 0 763.763 3.262.114 4.660.746 6.006.857 5.586.377 5.195.331 4.831.658 4.493.442 4.178.902 3.886.378 3.614.331 3.361.328 3.126.035 2.907.212 2.703.707 2.514.448 2.338.437 2.174.745 2.022.514
Costs
Eco-sanitation budget items 61001-61006 -57.000
Direct investments stoves -57.000
Quota common costs 57000/2087450 (2.73%) of 2912550 -79.513
Total investments eco-sanitation sector -136.513 -136.513 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Quota maintenance costs 2.73% Euro 100.000 discounted by 7% per annum  0 -2.539 -2.361 -2.196 -2.042 -1.899 -1.766 -1.643 -1.528 -1.421 -1.321 -1.229 -1.143 -1.063 -988 -919 -855 -795 -739 -688
Present value revenues (79) net of investments (85) and maintenance (86) -136.513 761.224 3.259.753 4.658.550 6.004.815 5.584.478 5.193.565 4.830.015 4.491.914 4.177.481 3.885.057 3.613.102 3.360.185 3.124.972 2.906.224 2.702.788 2.513.593 2.337.642 2.174.006 2.021.826 67.464.677
Progressive total (88) -136.513 624.711 3.884.464 8.543.014 ######## ######## ######## ######## 34.647.801 38.825.282 42.710.339 46.323.441 49.683.626 52.808.598 55.714.822 58.417.610 60.931.203 63.268.845 65.442.851 67.464.677
Factor benefits eco-sanitation sector : value (89) divided total investments (85) 0 4.58 28.45 62.58 106.57 147.48 185.52 220.90 253.81 284.41 312.87 339.33 363.95 386.84 408.13 427.93 446.21 463.46 479.39 494.20
Present value project revenues net of investments and maintenance costs discounted by 7% per annum
Water supply (22) -4.217.095 2.403.734 2.236.114 2.078.990 1.933.459 1.798.119 1.672.250 1.552.215 1.446.329 1.345.086 1.250.930 1.163.364 1.081.929 1.006.194 935.760 870.256 809.339 752.686 699.996 650.990 21.470.645
Hygiene education (46) -434.892 577.809 537.362 499.747 464.765 432.232 401.975 373.836 347.668 323.331 300.698 279.326 260.074 241.562 224.937 209.192 194.549 181.039 168.265 156.486 5.739.961
Improved stoves (68) -211.500 0 460.449 838.498 1.201.529 1.117.422 1.039.202 966.457 898.806 835.890 777.377 722.961 672.355 625.156 581.393 540.706 502.849 467.648 434.913 404.469 12.876.580
Eco-sanitation (88) -136.513 761.224 3.259.753 4.658.550 6.004.815 5.584.478 5.193.565 4.830.015 4.491.914 4.177.481 3.885.057 3.613.102 3.360.185 3.124.972 2.906.224 2.702.788 2.513.593 2.337.642 2.174.006 2.021.826 67.464.677
107.551.863
Present value project benefits, all sectors together -5.000.000 3.742.767 6.493.678 8.075.785 9.604.568 8.932.251 8.306.992 7.722.523 7.184.717 6.681.788 6.214.062 5.778.753 5.374.543 4.997.884 4.648.314 4.322.942 4.020.330 3.739.015 3.477.180 3.233.771 107.551.863
Factor total benefits (99) divided project investments Euro 5.000.000  -1 0.75 1.30 1.62 1.92 1.79 1.66 1.54 1.44 1.34 1.24 1.16 1.08 1.00 0.93 0.86 0.80 0.75 0.70 0.65 21.53
Total costs
Total amount specific costs (41.75% of project total) 2.087.450
Amount of common costs (58.25% of project total) 2.912.550
Total amount of project 5.000.000 5.000.000
Details of the common costs
Human resources budget items 101010-1030202 216.930
Travel budget items 20101-20201 40.000
Material organisation budget items 30101-3040304 169.200
Offices budget items  400101-40404 169.200
Other services budget items 50101-50902 30.950
Social structures budget items 60302-60304 299.500
Local money systems budget items 60401-60409 244.000
Micro-credits system budget items 60501-60506 113.000
Gypsum production units budget items 60601-60606 127.500
Recycling structures budget items 60701-60706 240.000
Other structures budget items 61101-62401 92.900
Moulds budget items 70201-70202 124.000
Purchase equipment other strructures budget items 70210-70223 509.500
Consultants/transport budget items 70301-70306 364.695
Unforeseen budget section 9 118.125
Administration costs budget section 11 53.050
Total common costs 2.912.550
Project total