Estimating multiplier for benefits experienced by other household members

	A	B	C	D
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
4	Average number of dependents per household	2.5
5	Average years before dependents leave household	18
6	Discount rate	3%
7	Expected annual increase in ln(income)	0.143
8	Above effect in terms of a percent increase in income	15%
9	Years deworming-related consumption benefits last	32
10
11	Discounted weighted average of number of people benefiting	3.69
12
13	Proportion of household income/consumption brought in by the individual who is dewormed	54%	Why this adjustment?
14
15	Suggested value for "Multiplier for resource sharing within households" parameter	1.97
16
17
18	Year	Household Size	Importance Post-discount	Weight
19	1	4.5	1.00	4.8%
20	2	4.5	0.97	4.6%
21	3	4.5	0.94	4.5%
22	4	4.5	0.92	4.4%
23	5	4.5	0.89	4.2%
24	6	4.5	0.86	4.1%
25	7	4.5	0.84	4.0%
26	8	4.5	0.81	3.9%
27	9	4.5	0.79	3.8%
28	10	4.5	0.77	3.6%
29	11	4.5	0.74	3.5%
30	12	4.5	0.72	3.4%
31	13	4.5	0.70	3.3%
32	14	4.5	0.68	3.2%
33	15	4.5	0.66	3.1%
34	16	4.5	0.64	3.1%
35	17	4.5	0.62	3.0%
36	18	4.5	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