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