ABCDEFGHIJKLMNOPQRSTUVWXY
1
Cash Transfers - GiveDirectlyDimensionOriginalCorrectedActiveCheck
2
Unit checks
3
Money multiplier1.001.002.15
4
Household multiplier1.001.003.43
5
People multiplier1.001.005.75
6
Time multiplier1.001.005.51
7
8
Size of transfer
9
Arbitrary donation sizeM$100,000$100,000$215,470$100,000
10
Transfers as a percentage of total cost183%83%83%83%
11
Total funding available for cash transfers out of hypothetical donationM$83,000$83,000$178,840$83,000
12
Total size of transfer per household (nominal USD)M/H$1,000$1,000$628$1,000
13
Average household sizeP/H4.74.77.94.7
14
Size of transfer per person (nominal USD)M/P$212.77$212.77$79.71$212.77
15
16
Investment returns
17
Percentage of transfers invested139%39%39%39%
18
Duration initial spending is spentT1.005.511.00
19
Amount invested (nominal USD)M/P$83$83$31$83
20
Total increase in consumption per person made possible by funds transferred (nominal USD)M/PT$130$130$9$130
21
Return on investment1/T10%10%2%10%
22
Annual increase in consumption per person made possible by investment returns (nominal USD)M/PT$8.30$8.30$0.56$8.30
23
24
Present value of transfer
25
Baseline annual consumption per capita (in nominal USD)M/PT$285.92$285.92$19.43$285.92
26
Total immediate increase in ln(consumption) per person made possible by funds transferredT0.370.372.060.37
27
Future annual increase in ln(consumption) per person — from returns on investments10.030.030.030.03
28
Discount rate^(1/T)4.00%4.00%0.71%4.00%
29
Duration of investment benefits (in years)T10105510
30
Duration of the end of benefitsT1.005.511.00
31
Present value of future increases in ln(consumption) per person (excluding the last year of expected benefits)
Unknown (But should be T)
0.210.21
32
My Continuous PV formula, approximate of aboveT0.220.221.200.22
33
Percent of investment returned when benefits end120%20%20%20%
34
Present value of ln(consumption) increase in the last year of expected benefitsT0.060.060.310.06
35
Present value of all future increases in ln(consumption)T0.270.271.510.27
36
Total present value of cash transfer in terms of increases in ln(consumption)T0.650.653.570.65
37
Discount to the benefits of cash from potential negative spillover effects on consumption15%5%5%5%
38
Total present value of cash transfer accounting for spilloversT0.620.623.390.62
39
Total units of increase in ln(consumption) per householdTP/H2.892.8926.732.89
40
41
Number of transfers madeH838328583
42
Total units of increase in ln(consumption)TP2402407,611240
43
Value assigned to increasing ln(consumption) by one unit for one person for one yearV/PT1.441.440.051.44
44
45
Total units of value generatedV346346346346
46
Units of value generated per dollar spentV/M0.003455970830.003455970830.001603922050.00345597083
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