ABCDEFGHIJKL
1
Fundraising ROI Calculator for Direct Mail
2
List name# Mailed# ResponsesTotal $Cost to mail% ReponseAverage donationNet Revenue (List)ROI (List)Cost to raise $1Cost to acquire each new donor
3
Current Donors#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
4
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
5
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
6
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
7
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
8
Acquisition Lists#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
9
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
10
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
11
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
12
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
13
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
14
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
15
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
16
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
17
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
18
TOTALS:00$0$0.00#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
19
Current Donors:00$0$0.00#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!
20
Acquisition Lists:00$0$0.00#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
21
22
Total cost of mailing:— Fill in columns B–F. Leave extra rows blank— Columns G–L calculate automatically.— Use the FILE menu to download a copy.Learn more/Get help.
23
Cost per envelope:#DIV/0!
24
25
26
27
Spreadsheet with sample data...
28
List name# Mailed# ResponsesTotal $Cost to mail% ReponseAverage donationNet Revenue (List)ROI (List)Cost to raise $1Cost to acquire each new donor
29
Current Donors$20 Donors8563731$8,568$3,805.628.54%$11.72$4,762.70125.15%$0.44
30
$50 Donors2106118$5,963$935.965.60%$50.53$5,027.04537.10%$0.16
31
$100 Donors28833$5,575$127.9911.46%$168.94$5,447.014255.65%$0.02
32
Test Segment A120289$1,922$535.536.22%$21.60$1,386.47258.90%$0.28
33
Test Segment B120575$2,413$535.536.22%$32.17$1,877.47350.58%$0.22
34
Acquisition ListsList A12250128$684$6,127.741.04%$5.34-$5,443.74-88.84%$8.96$47.87
35
List B1378883$736$6,127.740.60%$8.87-$5,391.74-87.99%$8.33$73.83
36
List C8700180$1,296$1,558.162.07%$7.20-$262.36-16.84%$1.20$8.66
37
List D350656$950$1,558.161.60%$16.96-$608.16-39.03%$1.64$27.82
38
List E299823$292$1,737.700.77%$12.70-$1,445.70-83.20%$5.95$75.55
39
List F391052$842$1,737.701.33%$16.19-$895.70-51.55%$2.06$33.42
40
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
41
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
42
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
43
#DIV/0!#DIV/0!$0.00#DIV/0!#DIV/0!#DIV/0!
44
TOTALS:585161568$29,241$24,787.832.68%$18.65$4,453.2917.97%$0.85
45
Current Donors:133641046$24,441$5,940.647.83%$23.37$18,500.68311.43%$0.24
46
Acquisition Lists:45152522$4,800$18,847.191.16%$9.20-$14,047.39-74.53%$3.93$36.11
47
48
Total cost of mailing:$26,006
49
Cost per envelope:$0.444
50
51
52
About this spreadsheet...
53
54
In 2012, an organization asked me to help them interpret the results from their direct mail campaigns. I created this spreadsheet to help them.
55
56
Over the years, I've seen that many organizations need this kind of help. I hope that by sharing this spreadsheet many organizations will benefit. Feel free to copy, download and modify this sheet as you see fit.
57
58
Use this data to compare direct mail (or email) campaigns against each other and against other fundraising activities.
59
60
— A. Z. Narrow(845) 694-4384
61
aryehzev at gmail dot com
62
My old blog lurks here: https://nonprofitspark.wordpress.com/
63
64
65
66
Further reading...
67
68
Recent blog posts:
69
The Invisible Posthttps://aznarrow.com/the-invisible-post/
70
Turpis tempor sodales nemo an egestas volutehttps://aznarrow.com/turpis-tempor-sodales-nemo-an-egestas-volute-3/
71
A blog about non-profit marketing and fundraising messages.Egestas volute nemo the ipsam sodales the turpishttps://aznarrow.com/egestas-volute-nemo-ipsam-at-turpis-porta-sodales-3/
72
Nemo ipsam on gravida donec sodales sapienhttps://aznarrow.com/nemo-ipsam-undo-gravida-donec-sodales-sapien-2/
73
Turpis tempor sodales nemo an egestas volutehttps://aznarrow.com/turpis-tempor-sodales-nemo-an-egestas-volute-2/
74