Product - Basics Spreadsheet - Business Plan To Actual - Blank and Formual.xls

	A	B	C	D	E	F	G	H	I	J	K	L
1					Business Plan to Actual
2
3		Written	Written	Written	Written	Written	Written			Month	Month	Year To Date
4		Listing	Sales	Listing	Sales	Total	Total	Closed	Closed	Paid	Referral Paid	Paid
5		Transactions	Transactions	Volume	Volume	Transactions	Volume	Transactions	Volume	Commission	Commission	Commission
6	Objective
7	January
8	February
9	March
10	April
11	May
12	June
13	July
14	August
15	September
16	October
17	November
18	December
19	Year End
20
21
22
23					Example Business Plan to Actual
24
25		Written	Written	Written	Written	Written	Written			Month	Month	Year To Date
26		Listing	Sales	Listing	Sales	Total	Total	Closed	Closed	Paid	Referral Paid	Paid
27		Transactions	Transactions	Volume	Volume	Transactions	Volume	Transactions	Volume	Commission	Commission	Commission
28	Objective	1 mo/12 yr	1 mo / 12 yr	$1,000,000 yr	$1,000,000 yr	2 mo / 24 yr	$2,000,000 yr	2 mo / 24 yr	$2,000,000 yr	$4,000 (3.5% @ 70%)	$500.00	$54,000.00
29	January	1	1	$175,000.00	$50,000.00	2	$225,000.00	2	$225,000.00	$5,512.50	$1,000.00	$6,512.50
30	February	1	0	$65,000.00	$0.00	3	$290,000.00	1	$290,000.00	$1,592.50	$0.00	$8,105.00
31	March	2	3	$210,000.00	$280,000.00	8	$780,000.00	4	$605,000.00	$7,717.50	$0.00	$15,822.50
32	April	2	1	$125,000.00	$75,000.00	11	$980,000.00	3	$805,000.00	$4,900.00	$1,500.00	$22,222.50
33	May	0	3	$0.00	$330,000.00	14	$1,310,000.00	3	$1,135,000.00	$8,085.00	$0.00	$30,307.50
34	June	1	1	$80,000.00	$90,000.00	16	$1,480,000.00	1	$1,215,000.00	$1,960.00	$0.00	$32,267.50
35	July	1	3	$150,000.00	$210,000.00	20	$1,840,000.00	3	$1,425,000.00	$5,145.00	$0.00	$37,412.50
36	August	1	0	$65,000.00	$0.00	21	$1,905,000.00	1	$1,490,000.00	$1,592.50	$575.00	$39,580.00
37	September	2	1	$145,000.00	$90,000.00	24	$2,140,000.00	3	$1,725,000.00	$5,757.50	$0.00	$45,337.50
38	October	0	2	$0.00	$175,000.00	26	$2,315,000.00	2	$1,900,000.00	$4,287.50	$0.00	$49,625.00
39	November	0	1	$0.00	$125,000.00	27	$2,440,000.00	1	$2,025,000.00	$3,062.50	$1,200.00	$53,887.50
40	December	1	0	$195,000.00	$0.00	28	$2,635,000.00	1	$2,220,000.00	$4,777.50	$0.00	$58,665.00
41	Year End	12	16	$1,210,000.00	$1,425,000.00	28	$2,635,000.00	25	$2,220,000.00	$54,390.00	$4,275.00	$58,665.00
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