EXCEL 1
Sheial 234
EX2016-SkillReview-5-2-solution1.pdf
4/19/2016, $355,000
7/15/2016, $550,0007/15/2016, $550,000
7/15/2016, $395,000
9/14/2016, $440,000
9/14/2016, $575,000
3/3/2017, $385,000
3/3/2017, $550,000
3/26/2017, $440,0003/26/2017, $440,0003/27/2017, $445,000
3/27/2017, $425,000 3/27/2017, $440,000 3/27/2017, $425,000
4/19/2016 5/19/2016 6/19/2016 7/19/2016 8/19/2016 9/19/2016 10/19/2016 11/19/2016 12/19/2016 1/19/2017 2/19/2017 3/19/2017
For Sale By Owner
SOLUTION SAMPLE
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
28
29
A B C D E F G H
Average of Purchase Price Column Labels
Row Labels Condominium Mediterranean Modern Ranch Grand Total
By Owner 395000 366250 385000 453214.2857 418571.4286
Century 21 461250 415500 428125 423333.3333 427321.4286
Homes and Garden 447857.1429 390555.5556 423000 418461.5385
Remax 434000 475000 356250 328000 400178.5714
Williman's 505000 408636.3636 416250 366500 405000
Grand Total 440166.6667 410384.6154 395000 409333.3333 413840.5797
0 200000 400000 600000
By Owner
Century 21
Homes and Garden
Remax
Williman's
Ranch
Modern
Mediterranean
Condominium
House Type
Agent
Average of Purchase PriceSOLUTION SAMPLE
1
2
5
8
13
28
30
42
47
89
93
101
103
104
125
140
A B C D E F G H I J K L
Date of Purchase Agent Buyers House Type Bedrooms Bathrooms Fireplace Near Schools Purchase Price Rate Bank Mortgage Years
3/27/2017 By Owner Bond Modern 4 1 No Yes $445,000 4.10% Bank Of America 15
3/27/2017 By Owner Williams Ranch 4 2 No Yes $425,000 4.20% Citizens 15
3/27/2017 By Owner Chama Ranch 4 2 No Yes $440,000 3.80% Nations 15
3/27/2017 By Owner Johnson Mediterranean 5 1 No Yes $425,000 4.30% Citywide 30
3/26/2017 By Owner Jones Ranch 4 1 Yes No $440,000 3.60% Nations 30
3/26/2017 By Owner Willows Ranch 5 1 No Yes $440,000 3.90% Bank Of America 40
3/3/2017 By Owner Zimmerman Condominium 5 1 Yes No $385,000 3.50% Bank Of America 30
3/3/2017 By Owner Castle Ranch 4 1 Yes No $550,000 3.50% Citywide 30
9/14/2016 By Owner Chipman Condominium 4 2 No Yes $440,000 3.70% Citywide 30
9/14/2016 By Owner Nagato Ranch 5 1 No Yes $575,000 3.90% Citizens 30
7/15/2016 By Owner Johnson Modern 4 1 Yes No $550,000 3.50% Citizens 40
7/15/2016 By Owner Hawkins Condominium 5 1 Yes No $550,000 4.50% People's 15
7/15/2016 By Owner Downing Condominium 4 1 Yes No $395,000 3.70% Citywide 15
4/19/2016 By Owner Nagasaki Ranch 5 2 Yes No $355,000 3.20% Nations 30
Total 14 4.42857143 1.285714286 $458,214 3.81% 26.07142857SOLUTION SAMPLE
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
A B C D E F G H
Loan Payment per $100,000 Borrowed 4.00% 15 years
Rates Loan Payment $950.00
$739.69 15 30 40 Rate 4.00%
4.00% 739.69$ 477.42$ 417.94$ Years 30
4.05% 742.20$ 480.30$ 421.05$
4.10% 744.71$ 483.20$ 424.18$
4.15% 747.23$ 486.10$ 427.32$ Amount to Borrow 198,988$
4.20% 749.75$ 489.02$ 430.46$
4.25% 752.28$ 491.94$ 433.62$
4.30% 754.81$ 494.87$ 436.79$
4.35% 757.35$ 497.81$ 439.97$
4.40% 759.89$ 500.76$ 443.16$
4.45% 762.44$ 503.72$ 446.35$
4.50% 764.99$ 506.69$ 449.56$
4.55% 767.55$ 509.66$ 452.78$
4.60% 770.11$ 512.64$ 456.01$
4.65% 772.68$ 515.64$ 459.25$
4.70% 775.25$ 518.64$ 462.50$
4.75% 777.83$ 521.65$ 465.76$
4.80% 780.41$ 524.67$ 469.03$
4.85% 783.00$ 527.69$ 472.30$
4.90% 785.59$ 530.73$ 475.59$
4.95% 788.19$ 533.77$ 478.89$
Years
If you can afford this loan:
You can borrow this much:SOLUTION SAMPLE
