NOBLE FINANCIAL-leads-roi-calculator.xlsx

	B	C	D	E	F	G	H	I	J	K
1	Insurance Lead ROI Calculator
2	DIY INSURANCE LEAD GENERATION HERE: https://noblefinancialagency.com/life-insurance-leads/
3	Lead Source	Total # of Leads Purchased	Total # of Leads Closed	Cost For Each Lead	Lead Close Ratio	Total Cost of Leads	Average Cost Per Sale	Total Premium Written	Avg. Commission Per Sale	ROI on Every Dollar Spent
4
5
6
7
8
9
10
11
12
13
14
15
16
17	Sample Data
18
19	Agent Insider	100	32	$11.00	32.00%	$1,100.00	$34.38	$17,500	$492	$14.32
20	Insure Me	50	21	$8.00	42.00%	$400.00	$19.05	$12,000	$514	$27.00
21	NetQuote	47	16	$10.00	34.04%	$470.00	$29.38	$13,000	$731	$24.89
22
23
24
25
26
27
28		197	69	$9.67	36.01%	$1,970.00	$27.60	$42,500	$579.24	$22.07
29
30	YOU FILL IN THE GREEN BOXES		THE YELLOW BOXES WILL FILL AUTOMATICALLY					Commission %:	90.0%
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