A simple and generic framework for impact estimation and attribution: Sheet

	A	B	C	D	E	F	G	H
1	Color coding	Input (Change this)	Constant	Calculation	Output
2
3	Life satisfaction vs Income
4	Income	$1,000.00	$2,000.00	$5,000.00	$10,000.00	$20,000.00	$50,000.00	$100,000.00
5	Life satisfaction	3.70	4.27	5.03	5.60	6.17	6.93	7.50
6	Log of income for forecasting	3.00	3.30	3.70	4.00	4.30	4.70	5.00
7	Life satisfaction effect of adding 1k	0.57	0.33	0.15	0.08	0.04	0.02	0.01
8
9
10	Life satisfaction impact from donations
11	Income pre tax per year	$50,000
12	Donation percentage	10%
13	Estimated life satisfaction before donation	6.93
14	Estimated life satisfaction after donation	6.84
15	Total WELLBY from donating this in 1k increments to people with 1k at 90% efficiency (GiveDirectly)	2.57
16	WELLBY loss from donating 10% of income	0.09
17	Net WELLBY impact from donations	2.49
18
19	Job input
20	Salary fudge factor (how much more/less value does this job generate than the salary suggests)	100%
21	Fudge-adjusted salary	$50,000
22
23	Company input
24	Company present yearly cost (incl depriciation, amortization, taxes, ...)	$5,000,000
25	Company value	$20,000,000
26	Value of shares for impact calculation	$50,000
27	%-impact from shares	0.25%
28
29	Revenue input
30	Revenue streams	Africa Consumer	Africa Mid-Market	Africa Corporate	EU Mid-Market
31	Revenue of company per year	$20,000	$300,000	$1,500,000	$1,000,000	$0	$0
32	Fudge factor to adjust for market failure	1.00	1.00	1.00	1.00	1.00	1.00
33	Target group income per year	$2,000	$5,000	$20,000	$70,000	$0	$0
34	Estimated life satisfaction per year	4.27	5.03	6.17	7.21	0.00	0.00
35	WELLBY/$ (fudge adjusted)	0.0021	0.0010	0.0003	0.0001	0.0000	0.0000
36
37	Job impact - present
38	Present revenue (fudge adjusted)	$20,000	$300,000	$1,500,000	$1,000,000	$0	$0
39	Present revenue split (fudge adjusted)	1%	11%	53%	35%	0%	0%
40	WELLBY per segment	43	302	463	103	0	0
41	Average WELLBY/$	0.000323
42	Total WELLBY generated	910
43	Company net WELLBY generated	-704
44	WELLBY from job	16
45	WELLBY from shares	-2
46	Net WELLBY	14
47
48	Job impact - future from shares
49	Future revenue split	5%	10%	15%	70%	0%	0%
50	Company value split (fudge-adjusted)	$1,000,000	$2,000,000	$3,000,000	$14,000,000	$0	$0
51	Future WELLBY from company value	2136	2011	926	1441	0	0
52	Total WELLBY from company value	6514
53	Future WELLBY from shares	16.29
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