A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | What this is: Rough back-of-the-envelope calculation (BOTEC) to estimate value of monitoring and evaluation (M&E) grant. | ||||||||||||||||||||||||
2 | |||||||||||||||||||||||||
3 | Value | Notes | |||||||||||||||||||||||
4 | Cost of monitoring and evaluation study, including overhead | $596,500.00 | MiracleFeet budget as of 19 May 2023 | ||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | Basic parameters | ||||||||||||||||||||||||
7 | How many years would we fund MiracleFeet's program if it met our bar for cost-effectiveness? | 10 | Typical parameter we use in our calculations | ||||||||||||||||||||||
8 | Cost-effectiveness of counterfactual programs we could fund over this time period (x cash) | 10.0 | Guess | ||||||||||||||||||||||
9 | Discount rate | 4% | This assumes that cost effectiveness of opportunities decays over 10-year period. Using similar value to other value of information BOTECs. The value here is subjective. This could also incorporate probability of fundamental changes that render the program ineffective (i.e., temporal uncertainty). | ||||||||||||||||||||||
10 | Units of value per dollar generated by unconditional cash transfers | 0.00335 | Calculated in our Top Charities CEA. | ||||||||||||||||||||||
11 | |||||||||||||||||||||||||
12 | Scenario 0: No evaluation | ||||||||||||||||||||||||
13 | Annual funding to MiracleFeet in this scenario | $1,021,274 | Assumption based on internal data provided by MiracleFeet. If we didn't fund the evaluation, we would only fund a portion of the gaps we estimate to be above 10x. | ||||||||||||||||||||||
14 | Cost-effectiveness of funding to MiracleFeet in this scenario (x cash) | 13.1 | This is our current best guess of the cost-effectiveness of MiracleFeet funding gaps above our bar of 10x cash. | ||||||||||||||||||||||
15 | |||||||||||||||||||||||||
16 | Scenario 1: Evaluation results provide a negative update on cost-effectiveness | ||||||||||||||||||||||||
17 | Probability of this scenario | 33% | Guess. Assumes that it is equally likely that the evaluation will cause us to update positively, negatively, or with no change to our cost-effectiveness estimate but a reduction in variance. | ||||||||||||||||||||||
18 | Annual funding to MiracleFeet in this scenario | $514,597 | Assumes that only funding gaps which are above 12x cash in our current best guess would be above 10x cash in the event of a negative update. | ||||||||||||||||||||||
19 | Cost-effectiveness of funding we allocate away from MiracleFeet in this scenario (x cash) | 8.0 | Guess. Assumes that with a negative update our estimate of opportunities above the 10x bar would decrease by 20% | ||||||||||||||||||||||
20 | Increase in units of value per year from evaluation in this scenario | 3,395 | The increase in units of value for this scenario comes from reallocating funding away from MiracleFeet’s program and toward counterfactual funding opportunities. | ||||||||||||||||||||||
21 | |||||||||||||||||||||||||
22 | Scenario 2: Evaluation results provide a positive update on cost-effectiveness | ||||||||||||||||||||||||
23 | Probability of this scenario | 33% | Guess. Assumes that it is equally likely that the evaluation will cause us to update positively, negatively, or with no change to our cost-effectiveness estimate but a reduction in variance. | ||||||||||||||||||||||
24 | Annual funding to MiracleFeet in this scenario | $1,527,951 | Guess. Assumes funding gaps estimated to be 8x cash in our current best guess are actually at 10x cash in the event of a positive update. | ||||||||||||||||||||||
25 | Cost-effectiveness of funding to MiracleFeet in this scenario (x cash) | 14.0 | Guess. Assumes that with a positive update, all opportunities we currently estimate at above the 8x bar would increase in cost effectiveness by 20%. (Note: This calculation assumes that the positive update applies to the entire portfolio and so begins with our weighted average CE of all opportunities above the 8x threshold, which is approximately 11.6x) | ||||||||||||||||||||||
26 | Increase in units of value per year from evaluation in this scenario | 6,715 | The increase in units of value for this scenario comes from reallocating funding toward MiracleFeet’s program and away from counterfactual funding opportunities. | ||||||||||||||||||||||
27 | |||||||||||||||||||||||||
28 | Scenario 3: Evaluation results do not provide an update on cost-effectiveness | ||||||||||||||||||||||||
29 | Probability of this scenario | 33% | Guess. Assumes that it is equally likely that the evaluation will cause us to update positively, negatively, or with no change to our cost-effectiveness estimate but a reduction in variance. | ||||||||||||||||||||||
30 | Annual funding to MiracleFeet in this scenario | $1,021,274 | If the evaluation provides no update on cost-effectiveness, we would fund those gaps we currently estimate to be above 10x (as in scenario 0). | ||||||||||||||||||||||
31 | Cost-effectiveness of funding to MiracleFeet in this scenario (x cash) | 13.1 | This is our current best guess of the cost-effectiveness of MiracleFeet funding gaps above our bar of 10x cash. | ||||||||||||||||||||||
32 | Increase in units of value per year from evaluation in this scenario | 0 | No value is generated in this scenario. | ||||||||||||||||||||||
33 | |||||||||||||||||||||||||
34 | Expected increase in units of value per year from evaluation | 3,370 | Calculation | ||||||||||||||||||||||
35 | Present value of total units of value generated by evaluation | 27,332 | Calculation | ||||||||||||||||||||||
36 | Cost-effectiveness in multiples of cash, M&E only | 14 | Calculation | ||||||||||||||||||||||
37 | |||||||||||||||||||||||||
38 | Units of value generated from current 3 country grant | 146,007 | This is calculated here in the cost-effectiveness analysis for the MiracleFeet implementation grant. | ||||||||||||||||||||||
39 | |||||||||||||||||||||||||
40 | Total units of value generated from program grant and M&E grant | 173,339 | Calculation | ||||||||||||||||||||||
41 | Total cost of program grant and M&E grant | $5,807,081 | Calculation; the amount of the implementation grant can be found here. | ||||||||||||||||||||||
42 | Total units of value generated per philanthropic dollar spent | 0.030 | Calculation | ||||||||||||||||||||||
43 | Cost-effectiveness in multiples of cash, program grant + M&E | 8.9 | Calculation | ||||||||||||||||||||||
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 |