Growth & Scale Advisory - Sales Calculator

	A	B	C	D	E	F	G	H	I	J	K	L
1	Past Numbers Based on Rev (Use Prev Month)			New Model			This Month		Projection		Days Into Month	Total Days
2	Leads	2000		Leads	2000		Leads	1000	Leads	6200
3	Booked Call	131		Booked Call	131		Booked Call	50	Booked Call	310
4	Booking Rate	7%		Booking Rate	7%		Booking Rate	5%	Booking Rate	5%
5	Showed	104		Showed	104		Showed	30	Showed	186	5	31
6	Deals Won	31		Deals Won	31		Deals Won	10	Deals Won	62
7	Show %	79%		Show %	79%		Show %	60%	Show %	60%	Upsell Price	Core Offer Price
8	Close %	29.81%		Close %	29.81%		Close %	33.33%	Close %	33.33%	$25,000.00	$5,000.00
9	FE AOV	$4,200.00		FE AOV	$4,200.00		FE AOV	$4,200.00	AOV	$4,200.00
10	UPSELL AOV	$5,000.00		UPSELL AOV	$5,000.00		UPSELL AOV	$5,000.00	UPSELL AOV	$5,000.00
11	Upsells	3		Upsells	3		Upsells	3	Upsells	18.6
12	Upsell %	10%		Upsell %	10%		Upsell %	30%	Upsell %	30%
13	FE Cash Collected	$130,200.00		FE Cash Collected	$130,200.00		FE Cash Collected	$42,000.00	FE Cash Collected	$260,400.00
14	Upsell Cash Collected	$15,000.00		Upsell Cash Collected	$15,000.00		Upsell Cash Collected	$15,000.00	Upsell Cash Collected	$93,000.00
15	Upsell Rev	$75,000.00		Upsell Rev	$75,000.00		Upsell Rev	$75,000.00	Upsell Rev	$465,000.00
16	Total Cash Collected	$145,200.00		Total Cash Collected	$145,200.00		Total Cash Collected	$57,000.00	Total Cash Collected	$353,400.00
17	New Customer Rev	$155,000.00		New Customer Rev	$155,000.00		New Customer Rev	$50,000.00	Total Revenue	$310,000.00
18	Total Rev	$230,000.00		Total Rev	$230,000.00		Total Rev	$125,000.00	Total Rev	$775,000.00
19	Cash Collected %	63.13%		Cash Collected %	63.13%		Cash Collected %	45.60%	Cash Collected %	45.60%
20	Fullfillemnt Cost			Fullfillemnt Cost			Fullfillemnt Cost		Fulfillment Cost
21	Closer Commission	$14,520.00		Closer Commission	$14,520.00		Closer Commission	$5,700.00	Closer Commission	$35,340.00
22	Setter Commission	$6,510.00		Setter Commission	$6,510.00		Setter Commission	$2,100.00	Setter Commission	$13,020.00
23	Total Misc Costs	$17,000.00		Total Misc Costs	$17,000.00		Total Misc Costs	$17,000.00	Total Misc Costs	$7,000.00
24	Other Fixed Cost			Other Fixed Cost			Other Fixed Cost		Other Fixed Cost
25	Ad/Marketing Cost	$40,000.00		Ad/Marketing Cost	$40,000.00		Ad/Marketing Cost	$10,000.00	Ad/Marketing Cost	$62,000.00
26	CPA	$1,290.32		CPA	$1,290.32		CPA	$1,000.00	CPA	$1,000.00
27	Profit Margin	46.26%		Profit Margin	46.26%		Profit Margin	38.95%	Profit Margin	54.93%
28	Net Income	$67,170.00		Net Income	$67,170.00		Net Income	$22,200.00	Total Profit	$143,040.00
29	Total Cost	$78,030.00		Total Cost	$78,030.00		Total Cost	$34,800.00	Total Cost	$117,360.00
30	Est Taxes	$20,151.00		Est Taxes	$20,151.00		Est Taxes	$6,660.00	Est Taxes	$42,912.00
31	Profit After Taxes	$47,019.00		Profit After Taxes	$47,019.00		Profit After Taxes	$15,540.00	Profit After Taxes	$100,128.00
32	Prof Margin After Taxes	32.38%		Prof Margin After Taxes	32.38%		Prof Margin After Taxes	27.26%	Prof Margin After Taxes	28.33%
33	Identify your top lead source
34	Lead Source	Lead Amount	Won	AOV	Rev	Lead Cost	Marketing total	CPA (Cost Per Aquisition)	Close %
35	Houzz	20	5	15000	75,000.00	200	4000	800	25.00%
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