Copy of Estimating multiplier for benefits experienced by other household members

	A	B	C	D	E	F	G	H	I	J	K
1	Click here to make an editable copy of this sheet
2	Input	Value	Note (hover cursor over)
3	Average number of wage earners per household	2	Sheet explanation		Charity	Country	Household
4	Average number of dependents per household	4.8			END	Ethiopia	4.6			Pakistan
5	Average years before dependents leave household	18			END	Angola	4.8			6.8	4.8
6	Discount rate	3%			END	DRC	5.3
7	Expected annual increase in ln(income)	0.143			END	Rwanda	4.3		HH multiplier
8	Above effect in terms of a percent increase in income	15.3730%		0.15373	END	Zimbabwe	4.1	4.62	1.91
9	Years deworming-related consumption benefits last	32			Malaria Consortium	Burkina Faso	5.9	2.62
10					Malaria Consortium	Nigeria	4.9
11	Discounted weighted average of number of people benefiting	5.24			Malaria Consortium	Togo	4.6	Average	HH multiplier
12					Malaria Consortium	Chad	5.8	5.3	2.1200
13	Proportion of household income/consumption brought in by the individual who is dewormed	54%	Why this adjustment?					3.3
14
15	Suggested value for "Multiplier for resource sharing within households" parameter	2.81
16
17
18	Year	Household Size	Importance Post-discount	Weight
19	1	6.8	1.00	4.8%
20	2	6.8	0.97	4.6%
21	3	6.8	0.94	4.5%
22	4	6.8	0.92	4.4%
23	5	6.8	0.89	4.2%
24	6	6.8	0.86	4.1%
25	7	6.8	0.84	4.0%
26	8	6.8	0.81	3.9%
27	9	6.8	0.79	3.8%
28	10	6.8	0.77	3.6%
29	11	6.8	0.74	3.5%
30	12	6.8	0.72	3.4%
31	13	6.8	0.70	3.3%
32	14	6.8	0.68	3.2%
33	15	6.8	0.66	3.1%
34	16	6.8	0.64	3.1%
35	17	6.8	0.62	3.0%
36	18	6.8	0.61	2.9%
37	19	2	0.59	2.8%
38	20	2	0.57	2.7%
39	21	2	0.55	2.6%
40	22	2	0.54	2.6%
41	23	2	0.52	2.5%
42	24	2	0.51	2.4%
43	25	2	0.49	2.3%
44	26	2	0.48	2.3%
45	27	2	0.46	2.2%
46	28	2	0.45	2.1%
47	29	2	0.44	2.1%
48	30	2	0.42	2.0%
49	31	2	0.41	2.0%
50	32	2	0.40	1.9%
51	33	2	0.00	0.0%
52	34	2	0.00	0.0%
53	35	2	0.00	0.0%
54	36	2	0.00	0.0%
55	37	2	0.00	0.0%
56	38	2	0.00	0.0%
57	39	2	0.00	0.0%
58	40	2	0.00	0.0%
59	41	2	0.00	0.0%
60	42	2	0.00	0.0%
61	43	2	0.00	0.0%
62	44	2	0.00	0.0%
63	45	2	0.00	0.0%
64	46	2	0.00	0.0%
65	47	2	0.00	0.0%
66	48	2	0.00	0.0%
67	49	2	0.00	0.0%
68	50	2	0.00	0.0%
69	51	2	0.00	0.0%
70	52	2	0.00	0.0%
71	53	2	0.00	0.0%
72	54	2	0.00	0.0%
73	55	2	0.00	0.0%
74	56	2	0.00	0.0%
75	57	2	0.00	0.0%
76	58	2	0.00	0.0%
77	59	2	0.00	0.0%
78	60	2	0.00	0.0%
79	61	2	0.00	0.0%
80	62	2	0.00	0.0%
81	63	2	0.00	0.0%
82	64	2	0.00	0.0%
83	65	2	0.00	0.0%
84	66	2	0.00	0.0%
85	67	2	0.00	0.0%
86	68	2	0.00	0.0%
87	69	2	0.00	0.0%
88
89
90
91
92
93
94
95
96
97
98
99
100