Challenge 7-4 EXCEL
Sheial 234
EX2016-ChallengeYourself-7-4-solution.pdf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
A B C D E F G H I J K L M N O P Q
House Type
Modern $9,505,000
Condo $13,205,000
Ranch $18,515,000
Mediterranean $15,855,000
Modern 17%
Condo 23%
Ranch 32%
Mediterranean 28%
Sales by House Type
Modern Condo Ranch Mediterranean
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
$16,000,000
$18,000,000
$20,000,000
Modern Condo Ranch Mediterranean
Sales by House Type
32% of total
Summary by Type
SOLUTION SAMPLE
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
3/21/2016 5/10/2016 6/29/2016 8/18/2016 10/7/2016 11/26/2016 1/15/2017 3/6/2017 4/25/2017
1 and 2 Bedroom Condo Sales
SOLUTION SAMPLE
Date of Purchase House Type Purchase Price Agent Buyers BedroomsBathrooms Fireplace Near SchoolsRate Bank Mortgage Years
3/4/2017 Condo $425,000 Remax Wilson 2 2 Yes No 5.75% People's 15
3/4/2017 Condo $385,000 By Owner Zimmerman 2 1 Yes No 6.75% Bank Of America 30
9/17/2016 Condo $225,000 Remax Jackson 2 2 No Yes 5.50% First Federal 30
9/17/2016 Condo $355,000 Century 21 Grande 2 2 No Yes 6.50% First Federal 30
9/15/2016 Condo $440,000 By Owner Chipman 1 2 No Yes 6.75% Citywide 30
7/16/2016 Condo $550,000 Century 21 Holland 2 1 Yes No 5.50% Citizens 30
7/16/2016 Condo $550,000 Remax Nettle 2 1 No Yes 6.25% First Federal 40
7/16/2016 Condo $550,000 By Owner Hawkins 2 1 Yes No 6.75% People's 15
4/20/2016 Condo $385,000 Homes and Garden Melon 2 1 No Yes 5.75% Nations 15
4/20/2016 Condo $425,000 Homes and Garden Perry 1 1 Yes No 6.75% Bank Of America 30
Total $4,290,000 10 1.8 1.4 6.23% 26.5SOLUTION SAMPLE
