| A | B | C | D | E | F | G | H | I | ||
|---|---|---|---|---|---|---|---|---|---|---|
1 | Main calculations | unit | type | Overall | ||||||
2 | Final cost-effectiveness estimate (pulled from below for visibility) | xcash | calc | 1.0 | ||||||
3 | Costs | |||||||||
4 | ||||||||||
5 | Total funding transferred to households | |||||||||
6 | Grant size | $ | input | $1,000,000 | ||||||
7 | Proportion of total costs transferred to households | % | input | 83% | ||||||
8 | Total funding transferred to households | $ | calc | $830,000 | ||||||
9 | ||||||||||
10 | Outputs | |||||||||
11 | ||||||||||
12 | Cash transfers | |||||||||
13 | Size of cash transfer per household | $ | input | $1,000 | ||||||
14 | Number of cash transfers made | # | calc | 830 | ||||||
15 | People per household | # | input | 4.7 | ||||||
16 | Size of cash transfer per person | $ | calc | $213 | ||||||
17 | ||||||||||
18 | Outcomes | |||||||||
19 | ||||||||||
20 | Baseline consumption | |||||||||
21 | Baseline annual consumption per capita | nom. $ | input | $286 | ||||||
22 | ||||||||||
23 | Investment returns | |||||||||
24 | Percentage of transfers invested | % | input | 39% | ||||||
25 | Amount invested per person | $ | calc | $83 | ||||||
26 | Return on investment | % | input | 10% | ||||||
27 | Annual increase in consumption per person from investment returns | nom. $ | calc | $8.30 | ||||||
28 | Annual increase in ln(consumption) per person from investment returns | ln($) | calc | 0.03 | ||||||
29 | Years of investment benefits | # | input | 10 | ||||||
30 | Discount rate for future benefits | % | input | 4% | ||||||
31 | Present value of future increases in ln(consumption) per person (excluding the last year of expected benefits) | ln($) | calc | 0.21 | ||||||
32 | Percent of investment returned when benefits end | % | input | 20% | ||||||
33 | Present value of ln(consumption) increase in the last year of expected benefits | ln($) | calc | 0.06 | ||||||
34 | Present value of all future increases in ln(consumption) per person | ln($) | calc | 0.27 | ||||||
35 | ||||||||||
36 | Short-term consumption | |||||||||
37 | Percentage of transfers not invested | % | calc | 61% | ||||||
38 | Increase in short-term consumption per person from funds transferred | $ | calc | $130 | ||||||
39 | Short-term increase in ln(consumption) per person from funds transferred | ln($) | calc | 0.37 | ||||||
40 | ||||||||||
41 | Total present value of cash transfers | |||||||||
42 | Total present value of cash transfer per person in terms of increases in ln(consumption) | ln($) | calc | 0.64 | ||||||
43 | Discount to the benefits of cash from potential negative spillover effects on consumption | % | input | -5% | ||||||
44 | Total present value of cash transfer per person, accounting for spillovers | ln($) | calc | 0.61 | ||||||
45 | Total units of increase in ln(consumption) per household | ln($) | calc | 2.87 | ||||||
46 | ||||||||||
47 | Value of outcomes | |||||||||
48 | ||||||||||
49 | Units of value generated from cash transfers | |||||||||
50 | Number of transfers made | # | calc | 830 | ||||||
51 | Total units of increase in ln(consumption) | ln($) | calc | 2384 | ||||||
52 | Value assigned to increasing ln(consumption) by one unit for one person for one year | # | input | 1.44 | ||||||
53 | Total units of value generated | # | calc | 3,440 | ||||||
54 | Units of value generated per dollar spent | # | calc | 0.003 | ||||||
55 | ||||||||||
56 | Contribution of each outcome to overall cost-effectiveness | |||||||||
57 | Percent of modeled benefits coming from investment returns in the future | % | calc | 42% | ||||||
58 | Percent of modeled benefits coming from short-term consumption increases | % | calc | 58% | ||||||
59 | ||||||||||
60 | Adjustments | |||||||||
61 | ||||||||||
62 | Supplemental charity-level adjustments | |||||||||
63 | Risk of wastage | |||||||||
64 | Double treatment | % | input | 0% | ||||||
65 | Ineffective goods | % | input | 0% | ||||||
66 | Goods purchased and left in storage until they expire / cash doesn't receive recipients or is taken back from them inappropriately | % | input | -3% | ||||||
67 | Total adjusment for risk of wastage | % | calc | -3% | ||||||
68 | Quality of monitoring and evaluation | |||||||||
69 | Misappropriation without monitoring results | % | input | 0% | ||||||
70 | Misappropriation without monitoring results | % | input | 0% | ||||||
71 | Total adjustment for quality of monitoring and evaluation | % | calc | 0% | ||||||
72 | Confidence in funds being used for intended purpose | |||||||||
73 | Change of priorities | % | input | 0% | ||||||
74 | Non-funding bottlenecks | % | input | 0% | ||||||
75 | Within-org fungibility | % | input | -5% | ||||||
76 | Total adjustment for confidence in funds being used for intended purpose | % | calc | -5% | ||||||
77 | ||||||||||
78 | Total supplemental charity-level adjustment | % | calc | -8% | ||||||
79 | ||||||||||
80 | Supplemental intervention-level adjustments | |||||||||
81 | Changes in purchasing power parity (PPP) and exchange rates | % | input | -7% | ||||||
82 | Developmental effects | % | input | 5% | ||||||
83 | Reduced morbidity | % | input | 4% | ||||||
84 | Child mortality effects | % | input | 4% | ||||||
85 | ||||||||||
86 | Total supplemental intervention-level adjustment | % | calc | 6% | ||||||
87 | ||||||||||
88 | Cost-effectiveness (after all adjustments) | |||||||||
89 | ||||||||||
90 | Cost-effectiveness after all adjustments | |||||||||
91 | Total units of value generated, after accounting for all adjustments | UoV | calc | 3,355 | ||||||
92 | Units of value generated per philanthropic dollar spent, after accounting for all adjustments | UoV / $ | calc | 0.003 | ||||||
93 | Cost-effectiveness in terms of multiples of GiveDirectly's unconditional cash transfer program, after all adjustments | xcash | calc | 1.0 | ||||||
94 | ||||||||||