Median deworming country calculation [November 2020]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Organization	Geographic area	Country	Present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption)), after replicability and other adjustments	Worm intensity adjustment	Proportion of deworming going to children	Present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption))	Total downside adjustment factor	Adjustments for excluded effects that impact future income	Adjusted present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption))	Median per capita consumption per month, in 2011 PPP	Median per capita consumption per year, in 2011 PPP	Present value of additional consumption from a year of deworming, 2011 PPP	Cost per person dewormed per year	Total spending on deworming for this analysis	Number of person-years of deworming	Multiplier for resource sharing within households	Present value of cumulative additional consumption per capita from total spending on deworming for this analysis, 2011 PPP

2	Deworm the World	-	Kenya	0.11	17.8%	100%	0.020	92%	-13.5%	0.016	$73.24	$879	$14.42	$0.66	$100	153	2	$4,399
3	Deworm the World	-	Pakistan	0.11	2.9%	100%	0.003	92%	-13.5%	0.003	$116.96	$1,404	$3.73	$0.62	$100	161	2	$1,199
4	Deworm the World	Lagos	Nigeria	0.11	4.5%	100%	0.005	92%	-13.5%	0.004	$54.10	$649	$2.69	$0.97	$100	103	2	$556
5	Deworm the World	Oyo	Nigeria	0.11	11.0%	100%	0.013	92%	-13.5%	0.010	$54.10	$649	$6.57	$0.86	$100	117	2	$1,532
6	Deworm the World	Ogun	Nigeria	0.11	17.8%	100%	0.020	92%	-13.5%	0.016	$54.10	$649	$10.65	$1.52	$100	66	2	$1,403
7	Deworm the World	Rivers	Nigeria	0.11	8.3%	100%	0.010	92%	-13.5%	0.008	$54.10	$649	$4.95	$0.75	$100	134	2	$1,323
8	SCI Foundation	-	Ethiopia	0.11	4.0%	73%	0.003	85%	-13.5%	0.002	$77.48	$930	$2.27	$1.03	$100	97	2	$441
9	SCI Foundation	-	Malawi	0.11	7.3%	65%	0.005	85%	-13.5%	0.004	$40.70	$488	$1.96	$1.03	$100	97	2	$381
10	SCI Foundation	-	Congo, Dem. Rep.	0.11	17.8%	94%	0.019	85%	-13.5%	0.014	$33.48	$402	$5.68	$1.03	$100	97	2	$1,104
11	SCI Foundation	-	Madagascar	0.11	17.8%	100%	0.020	85%	-13.5%	0.015	$33.01	$396	$6.00	$1.03	$100	97	2	$1,166
12	SCI Foundation	-	Tanzania	0.11	4.9%	91%	0.005	85%	-13.5%	0.004	$58.82	$706	$2.63	$1.03	$100	97	2	$511
13	SCI Foundation	-	Cote d'Ivoire	0.11	6.4%	100%	0.007	85%	-13.5%	0.005	$84.72	$1,017	$5.54	$1.03	$100	97	2	$1,076
14	SCI Foundation	-	Liberia	0.11	11.5%	71%	0.009	85%	-13.5%	0.007	$66.20	$794	$5.45	$1.03	$100	97	2	$1,060
15	SCI Foundation	-	Uganda	0.11	0.9%	46%	0.000	85%	-13.5%	0.000	$97.23	$1,167	$0.41	$1.03	$100	97	2	$79
16	SCI Foundation	-	Burundi	0.11	8.8%	100%	0.010	85%	-13.5%	0.007	$53.37	$640	$4.77	$1.03	$100	97	2	$928
17	SCI Foundation	Zanzibar-Pemba	Tanzania	0.11	2.3%	25%	0.001	85%	-13.5%	0.000	$58.82	$706	$0.34	$1.03	$100	97	2	$66
18	SCI Foundation	Zanzibar-Unguja	Tanzania	0.11	0.4%	25%	0.000	85%	-13.5%	0.000	$58.82	$706	$0.06	$1.03	$100	97	2	$12
19	SCI Foundation	-	Sudan	0.11	5.1%	72%	0.004	85%	-13.5%	0.003	$132.70	$1,592	$4.96	$1.03	$100	97	2	$964
20	SCI Foundation	-	Niger	0.11	4.3%	38%	0.002	85%	-13.5%	0.001	$78.14	$938	$1.30	$1.03	$100	97	2	$252
21	SCI Foundation	-	Mauritania	0.11	17.8%	100%	0.020	85%	-13.5%	0.015	$174.56	$2,095	$31.73	$1.03	$100	97	2	$6,168
22	Sightsavers		Senegal	0.11	4.9%	100%	0.006	85%	-13.5%	0.004	$94.76	$1,137	$4.68	$1.52	$100	66	2	$617
23	Sightsavers		Chad	0.11	17.8%	100%	0.020	85%	-13.5%	0.015	$98.55	$1,183	$17.92	$1.71	$100	58	2	$2,091
24	Sightsavers	-	Congo, Dem. Rep.	0.11	1.7%	100%	0.002	78%	-13.5%	0.001	$33.48	$402	$0.51	$1.06	$100	94	2	$97
25	Sightsavers	West	Cameroon	0.11	6.0%	100%	0.007	78%	-13.5%	0.005	$109.29	$1,311	$6.12	$0.87	$100	115	2	$1,405
26	Sightsavers	North	Cameroon	0.11	11.5%	100%	0.013	78%	-13.5%	0.009	$109.29	$1,311	$11.72	$0.87	$100	115	2	$2,688
27	Sightsavers	Far-North	Cameroon	0.11	9.0%	100%	0.010	78%	-13.5%	0.007	$109.29	$1,311	$9.18	$0.87	$100	115	2	$2,106
28	Sightsavers	East	Cameroon	0.11	4.9%	100%	0.006	78%	-13.5%	0.004	$109.29	$1,311	$4.94	$0.87	$100	115	2	$1,134
29	Sightsavers	Adamoua	Cameroon	0.11	5.7%	100%	0.007	78%	-13.5%	0.004	$109.29	$1,311	$5.77	$0.87	$100	115	2	$1,324
30	Sightsavers	Benue	Nigeria	0.11	7.9%	100%	0.009	78%	-13.5%	0.006	$54.10	$649	$3.96	$1.00	$100	100	2	$794
31	Sightsavers	Kebbi	Nigeria	0.11	12.3%	100%	0.014	78%	-13.5%	0.010	$54.10	$649	$6.23	$0.64	$100	157	2	$1,951
32	Sightsavers	Kogi	Nigeria	0.11	2.7%	100%	0.003	78%	-13.5%	0.002	$54.10	$649	$1.36	$0.64	$100	157	2	$425
33	Sightsavers	Kwara	Nigeria	0.11	10.2%	100%	0.012	78%	-13.5%	0.008	$54.10	$649	$5.12	$0.64	$100	157	2	$1,603
34	Sightsavers	Sokoto	Nigeria	0.11	10.4%	100%	0.012	78%	-13.5%	0.008	$54.10	$649	$5.24	$0.64	$100	157	2	$1,641
35	Sightsavers	Taraba	Nigeria	0.11	1.5%	100%	0.002	78%	-13.5%	0.001	$54.10	$649	$0.76	$0.89	$100	112	2	$170
36	The END Fund	-	Ethiopia	0.11	2.1%	79%	0.002	83%	-13.5%	0.001	$77.48	$930	$1.28	$0.81	$100	124	2	$319
37	The END Fund	-	Angola	0.11	17.8%	79%	0.016	83%	-13.5%	0.012	$60.80	$730	$8.47	$0.81	$100	124	2	$2,104
38	The END Fund	-	Congo, Dem. Rep.	0.11	7.5%	79%	0.007	83%	-13.5%	0.005	$33.48	$402	$1.95	$0.81	$100	124	2	$486
39	The END Fund	-	Rwanda	0.11	5.7%	79%	0.005	83%	-13.5%	0.004	$52.76	$633	$2.33	$0.81	$100	124	2	$578
40	The END Fund	-	Zimbabwe	0.11	10.1%	79%	0.009	83%	-13.5%	0.007	$77.60	$931	$6.10	$0.81	$100	124	2	$1,514
41	Median											$706		$0.97				$1,076
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100