Gulham_Exp19_Excel_Ch07_Cap_RealEstate.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Location	Average Sold Price	Number Sold		Dual Agent	Total # Sold	Total Sold Prices	Highest Sold Price		Agent Codes and Commission Rates
2	Alpine				Carey					BA	Buyer's Agent	2.75%
3	American Fork				Hernandez					DA	Dual Agency	5.50%
4	Cedar Hills				Pijuan					SA	Seller's Agent	3.25%
5	Lehi
6	Total Commission by Agent										Input for Bonus
7	Carey										Percent of List	100%
8	Hernandez										Days on Market	30
9	Pijuan										Bonus Amount	$ 1,000
10
11	Number	City	Selling Agent	Agent Type	Agent Type	List Price	Sold Price	Listing Date	Sale Date	Days on Market	Agent Commission	Bonus
12	1	Cedar Hills	Pijuan	DA		$ 725,000	$ 705,000	4/1/2021	6/16/2021
13	4	Lehi	Pijuan	DA		$ 350,799	$ 350,000	4/1/2021	5/25/2021
14	5	American Fork	Pijuan	DA		$ 385,900	$ 385,900	4/1/2021	4/30/2021
15	6	Alpine	Carey	SA		$ 500,000	$ 495,800	4/3/2021	6/10/2021
16	7	Lehi	Pijuan	BA		$ 345,999	$ 345,000	4/3/2021	6/1/2021
17	11	American Fork	Hernandez	DA		$ 325,000	$ 320,000	4/12/2021	5/30/2021
18	12	Alpine	Pijuan	DA		$ 750,250	$ 725,900	4/12/2021	11/1/2021
19	17	Alpine	Carey	DA		$ 645,000	$ 643,000	4/18/2021	6/23/2021
20	19	American Fork	Pijuan	BA		$ 425,000	$ 415,000	4/18/2021	6/30/2021
21	21	Lehi	Pijuan	SA		$ 325,000	$ 330,000	4/28/2021	6/1/2021
22	24	American Fork	Pijuan	SA		$ 425,815	$ 418,000	4/28/2021	9/15/2021
23	27	Alpine	Pijuan	DA		$ 700,000	$ 705,000	4/30/2021	6/19/2021
24	30	Lehi	Hernandez	SA		$ 365,000	$ 363,000	5/1/2021	6/18/2021
25	32	Cedar Hills	Carey	SA		$ 885,500	$ 800,000	5/1/2021	6/6/2021
26	34	Cedar Hills	Carey	SA		$ 610,000	$ 600,000	5/1/2021	6/26/2021
27	35	Cedar Hills	Hernandez	DA		$ 560,700	$ 565,000	5/1/2021	5/30/2021
28	36	American Fork	Hernandez	BA		$ 450,000	$ 450,000	5/2/2021	9/30/2021
29	43	American Fork	Carey	BA		$ 375,000	$ 372,500	5/6/2021	5/15/2021
30	46	Cedar Hills	Carey	SA		$ 650,000	$ 625,750	5/15/2021	6/9/2021
31	48	Alpine	Hernandez	DA		$ 545,000	$ 560,000	5/22/2021	6/16/2021
32	53	Lehi	Carey	SA		$ 315,750	$ 320,000	5/28/2021	6/18/2021
33	61	Lehi	Carey	DA		$ 300,000	$ 300,000	6/2/2021	9/2/2021
34	69	Alpine	Hernandez	DA		$ 589,000	$ 595,000	6/18/2021	7/8/2021
35	70	American Fork	Hernandez	DA		$ 345,670	$ 345,000	6/20/2021	9/30/2021
36	73	Cedar Hills	Carey	BA		$ 555,000	$ 550,000	6/24/2021	6/30/2021
37	75	Alpine	Carey	BA		$ 475,000	$ 485,000	6/24/2021	9/18/2021
38	78	American Fork	Carey	DA		$ 400,000	$ 400,000	6/30/2021	7/15/2021
39	80	American Fork	Pijuan	SA		$ 380,500	$ 365,750	6/30/2021	9/1/2021
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