ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Gift Table
2
Fill in the yellow cells (Gift Amount, # of Gifts, # of Prospects) — everything else calculates automatically.
3
4
Campaign Goal ($)$100,000
5
6
Gift Amount# of Gifts Needed# of Prospects Needed
Total from Level ($)
Cumulative Total ($)
7
$10,00028$20,000$20,000
8
$5,000416$20,000$40,000
9
$2,500832$20,000$60,000
10
$1,0001040$10,000$70,000
11
$5002080$10,000$80,000
12
$25040160$10,000$90,000
13
$100100400$10,000$100,000
14
GRAND TOTAL184736$100,000$100,000
15
% of Goal100.0%
16
17
How to use this table:
18
1. Yellow cells are editable inputs: Gift Amount, # of Gifts Needed, and # of Prospects Needed.
19
2. "Total from Level" and "Cumulative Total" calculate automatically.
20
3. Rule of thumb: aim for roughly 3-4 prospects for every 1 gift you need at that level (people say no, or give at another level).
21
4. Add or delete rows as needed for your campaign — just extend the formulas down.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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