EXCEL 1

profileSheial 234
EX2016-SkillReview-5-21.xlsx
Home>Computer Science homework help>EXCEL 1

Sales Data

Date of Purchase Agent Buyers House Type Bedrooms Bathrooms Fireplace Near Schools Purchase Price Rate Bank Mortgage Years
3/27/17 By Owner Bond Modern 4 1 No Yes $445,000 4.10% Bank Of America 15
9/16/16 By Owner Scott Modern 2 2 Yes No $320,000 3.50% Citywide 30
7/15/16 By Owner Johnson Modern 4 1 Yes No $550,000 3.50% Citizens 40
1/14/17 By Owner Nosmiles Modern 3 1 No Yes $225,000 3.70% People's 30
7/15/16 Century 21 Grande Modern 5 1 No Yes $425,000 3.50% Bank Of America 30
3/26/17 Century 21 Hairless Modern 1 2 Yes No $390,000 3.90% People's 30
9/16/16 Century 21 Muchley Modern 5 2 Yes No $225,000 3.40% Citywide 15
3/26/17 Century 21 Holland Modern 1 2 Yes No $575,000 3.40% Nations 30
3/26/17 Century 21 Sanchaz Modern 2 1 Yes No $355,000 4.50% Bank Of America 15
3/26/17 Century 21 Watkins Modern 3 1 Yes No $440,000 3.30% Citywide 40
9/14/16 Century 21 Thatcher Modern 1 1 Yes No $440,000 3.50% People's 40
4/19/16 Century 21 Cater Modern 5 1 Yes No $575,000 3.90% Bank Of America 15
9/14/16 Williman's Roger Modern 5 2 No Yes $440,000 3.90% People's 30
3/26/17 Williman's Slocum Modern 3 2 Yes No $445,000 4.30% Bank Of America 15
9/16/16 Williman's Melon Modern 3 2 No Yes $425,000 3.90% Citywide 15
9/16/16 Williman's Ace Modern 3 2 No Yes $355,000 3.90% Nations 30
4/19/16 Remax Smith Modern 1 2 Yes No $575,000 4.40% People's 30
9/16/16 Remax Jackson Modern 4 1 Yes No $245,000 3.50% Bank Of America 40
9/16/16 Remax Newman Modern 5 1 No Yes $445,000 4.00% Citizens 15
3/27/17 Remax Nicks Modern 3 2 No Yes $320,000 4.10% Citizens 30
3/26/17 Remax Wilson Modern 3 2 Yes No $440,000 3.70% Bank Of America 40
3/26/17 Remax Nettle Modern 1 2 No Yes $225,000 3.70% First Federal 30
9/16/16 Remax Frost Modern 1 1 Yes No $355,000 4.40% Bank Of America 30
3/3/17 Remax O'Neil Modern 4 1 Yes No $245,000 3.40% First Federal 15
7/15/16 By Owner Hawkins Condominium 5 1 Yes No $550,000 4.50% People's 15
9/14/16 By Owner Chipman Condominium 4 2 No Yes $440,000 3.70% Citywide 30
3/3/17 By Owner Zimmerman Condominium 5 1 Yes No $385,000 3.50% Bank Of America 30
7/15/16 By Owner Downing Condominium 4 1 Yes No $395,000 3.70% Citywide 15
4/19/16 By Owner Bryant Condominium 3 1 No Yes $355,000 4.00% Citywide 15
9/14/16 By Owner Jacobs Condominium 3 1 No Yes $245,000 3.60% First Federal 30
9/16/16 Century 21 Grande Condominium 4 2 No Yes $355,000 4.30% First Federal 30
3/27/17 Century 21 Hairless Condominium 3 1 Yes No $390,000 4.30% First Federal 30
3/26/17 Century 21 Muchley Condominium 2 2 No Yes $550,000 3.70% Nations 30
7/15/16 Century 21 Holland Condominium 5 1 Yes No $550,000 3.50% Citizens 30
1/14/17 Williman's Sanchaz Condominium 2 1 Yes No $390,000 3.20% Nations 30
1/14/17 Williman's Watkins Condominium 5 1 Yes No $550,000 3.40% Bank Of America 30
9/14/16 Williman's Thatcher Condominium 1 1 Yes No $575,000 3.80% Nations 30
1/14/17 Homes and Garden Cater Condominium 2 1 Yes No $425,000 4.40% Bank Of America 30
3/3/17 Homes and Garden Roger Condominium 1 2 Yes No $355,000 4.10% First Federal 30
9/16/16 Homes and Garden Slocum Condominium 2 2 Yes No $550,000 4.30% People's 30
4/19/16 Homes and Garden Melon Condominium 4 1 No Yes $385,000 3.50% Nations 15
3/26/17 Homes and Garden Ace Condominium 5 1 Yes No $550,000 4.00% Nations 30
4/19/16 Homes and Garden Perry Condominium 4 1 Yes No $425,000 4.20% Bank Of America 30
1/14/17 Homes and Garden Smith Condominium 1 2 No Yes $445,000 4.00% Bank Of America 30
9/16/16 Remax Smith Condominium 1 2 No Yes $425,000 4.20% Nations 30
9/16/16 Remax Jackson Condominium 1 2 No Yes $225,000 3.40% First Federal 30
9/14/16 Remax Newman Condominium 2 2 No Yes $390,000 4.10% People's 30
4/19/16 Remax Nicks Condominium 4 1 No Yes $385,000 3.80% People's 40
3/3/17 Remax Wilson Condominium 1 2 Yes No $425,000 3.70% People's 15
7/15/16 Remax Nettle Condominium 1 1 No Yes $550,000 4.50% First Federal 40
3/26/17 Remax Frost Condominium 2 2 Yes No $550,000 3.30% People's 30
3/26/17 Remax O'Neil Condominium 2 1 Yes No $390,000 3.50% People's 15
7/15/16 Remax Hawkins Condominium 5 2 Yes No $575,000 3.50% Nations 30
7/15/16 Remax Na Condominium 3 1 Yes No $425,000 4.10% People's 30
3/27/17 By Owner Williams Ranch 4 2 No Yes $425,000 4.20% Citizens 15
3/27/17 By Owner Pell Ranch 1 2 No Yes $390,000 3.30% Nations 15
3/3/17 By Owner Jones Ranch 1 1 No Yes $550,000 3.60% Bank Of America 30
3/26/17 By Owner Jones Ranch 4 1 Yes No $440,000 3.60% Nations 30
3/26/17 By Owner Lee Ranch 1 2 Yes No $390,000 3.80% Citywide 30
9/14/16 By Owner Nagato Ranch 5 1 No Yes $575,000 3.90% Citizens 30
4/19/16 By Owner Nagasaki Ranch 5 2 Yes No $355,000 3.20% Nations 30
4/19/16 By Owner Lonsdale Ranch 2 2 Yes No $445,000 3.20% Nations 30
3/27/17 By Owner Negreedy Ranch 1 1 No Yes $575,000 3.50% Nations 40
3/27/17 By Owner Chama Ranch 4 2 No Yes $440,000 3.80% Nations 15
3/3/17 By Owner Smith Ranch 1 2 Yes No $385,000 3.20% Bank Of America 30
3/3/17 By Owner Castle Ranch 4 1 Yes No $550,000 3.50% Citywide 30
3/26/17 By Owner Willows Ranch 5 1 No Yes $440,000 3.90% Bank Of America 40
1/14/17 By Owner Bond Ranch 2 2 No Yes $385,000 3.90% People's 40
9/14/16 Century 21 Scott Ranch 3 2 Yes No $550,000 3.20% Bank Of America 30
7/15/16 Century 21 Johnson Ranch 5 1 No Yes $355,000 4.50% Citywide 30
9/14/16 Century 21 Cowoart Ranch 3 1 Yes No $445,000 3.80% Citizens 30
3/3/17 Century 21 Greenston Ranch 4 1 Yes No $425,000 3.30% Bank Of America 30
3/27/17 Century 21 King Ranch 5 1 Yes No $445,000 4.00% Citywide 15
9/16/16 Century 21 Tinker Ranch 4 2 No Yes $320,000 3.90% Bank Of America 30
7/15/16 Williman's Zink Ranch 5 1 No Yes $320,000 4.20% People's 15
3/3/17 Williman's Weston Ranch 1 1 Yes No $385,000 3.60% Citywide 30
7/15/16 Williman's Tinkleman Ranch 5 2 Yes No $425,000 3.20% Citywide 30
3/26/17 Williman's Kenney Ranch 1 2 No Yes $320,000 3.50% Citywide 40
9/14/16 Williman's Childs Ranch 5 1 No Yes $225,000 4.50% Nations 30
1/14/17 Williman's Nelson Ranch 2 2 No Yes $390,000 3.50% Bank Of America 15
3/27/17 Williman's Matherson Ranch 3 1 No Yes $225,000 3.90% Bank Of America 30
1/14/17 Williman's Timmerman Ranch 3 1 Yes No $550,000 4.10% Citywide 30
1/14/17 Williman's Pippen Ranch 5 2 No Yes $440,000 4.20% Nations 30
3/3/17 Williman's Bryant Ranch 3 2 Yes No $385,000 3.90% First Federal 15
3/3/17 Homes and Garden Smythe Ranch 2 2 Yes No $445,000 3.90% First Federal 30
3/26/17 Homes and Garden Tithers Ranch 2 1 Yes No $425,000 3.60% Citywide 15
4/19/16 Homes and Garden Harris Ranch 5 2 Yes No $245,000 4.00% Nations 15
4/19/16 Homes and Garden Bergquist Ranch 3 1 Yes No $575,000 4.10% Citizens 30
3/3/17 Homes and Garden Smithers Ranch 2 1 No Yes $390,000 3.40% Citizens 15
3/26/17 Homes and Garden Pod Ranch 5 1 Yes No $385,000 4.10% People's 40
7/15/16 Homes and Garden Sikes Ranch 5 2 Yes No $445,000 3.40% First Federal 15
9/16/16 Homes and Garden Grant Ranch 5 2 No Yes $320,000 3.90% People's 30
9/14/16 Homes and Garden Smith Ranch 3 1 Yes No $425,000 4.00% Citizens 40
3/27/17 Homes and Garden Smathers Ranch 2 1 No Yes $575,000 3.60% Bank Of America 30
3/27/17 Remax Bryan Ranch 5 2 No Yes $355,000 3.20% Bank Of America 30
1/14/17 Remax Able Ranch 2 1 No Yes $225,000 4.50% First Federal 30
3/26/17 Remax Kinnon Ranch 1 1 Yes No $385,000 3.50% Nations 15
7/15/16 Remax Collarserdo Ranch 3 1 Yes No $320,000 4.50% Bank Of America 30
4/19/16 Remax Bell Ranch 5 2 Yes No $355,000 4.50% Bank Of America 40
7/15/16 By Owner Snipes Mediterranean 3 2 Yes No $225,000 4.30% Bank Of America 40
3/27/17 By Owner Johnson Mediterranean 5 1 No Yes $425,000 4.30% Citywide 30
4/19/16 By Owner Jackson Mediterranean 1 2 No Yes $425,000 4.10% First Federal 40
3/27/17 By Owner Nyne Mediterranean 2 2 Yes No $390,000 4.00% Citywide 15
3/26/17 Century 21 Charleson Mediterranean 3 1 No Yes $440,000 4.20% Nations 30
4/19/16 Century 21 Taylor Mediterranean 3 1 Yes No $445,000 3.70% Bank Of America 30
3/26/17 Century 21 Smith Mediterranean 4 1 Yes No $575,000 4.50% Bank Of America 30
3/3/17 Century 21 Bennett Mediterranean 1 2 Yes No $575,000 3.20% People's 15
4/19/16 Century 21 Withers Mediterranean 5 2 Yes No $395,000 3.30% People's 40
9/14/16 Century 21 Perkins Mediterranean 1 1 No Yes $320,000 3.20% People's 40
3/26/17 Century 21 Victor Mediterranean 4 1 Yes No $225,000 3.50% Citywide 30
3/26/17 Century 21 Smythe Mediterranean 2 2 Yes No $385,000 4.40% People's 30
4/19/16 Century 21 Millhouse Mediterranean 2 1 No Yes $245,000 3.60% Citywide 30
3/3/17 Century 21 Taylor Mediterranean 4 1 No Yes $550,000 4.20% Bank Of America 30
4/19/16 Williman's Vu Mediterranean 1 2 Yes No $320,000 3.70% People's 30
3/3/17 Williman's Xavier Mediterranean 4 1 Yes No $445,000 3.80% Citizens 40
7/15/16 Williman's Reynolds Mediterranean 2 2 No Yes $550,000 4.20% First Federal 30
7/15/16 Williman's Nanowski Mediterranean 2 1 Yes No $440,000 4.20% Citizens 15
9/16/16 Williman's West Mediterranean 2 1 No Yes $245,000 3.40% First Federal 30
7/15/16 Williman's Henney Mediterranean 2 1 No Yes $575,000 4.10% First Federal 30
3/3/17 Williman's Young Mediterranean 2 2 No Yes $395,000 3.40% People's 15
9/16/16 Williman's Bytes Mediterranean 3 1 Yes No $245,000 3.30% Citywide 40
4/19/16 Williman's Victoria Mediterranean 2 1 Yes No $445,000 3.40% Nations 30
9/14/16 Williman's Youngston Mediterranean 1 2 No Yes $390,000 3.70% People's 15
4/19/16 Williman's Thompson Mediterranean 4 2 No Yes $445,000 3.30% Bank Of America 30
4/19/16 Homes and Garden Nelson Mediterranean 4 1 Yes No $575,000 3.40% People's 30
4/19/16 Homes and Garden Whitman Mediterranean 3 2 Yes No $355,000 3.60% Nations 30
7/15/16 Homes and Garden Smith Mediterranean 3 1 Yes No $245,000 4.20% Citizens 30
9/16/16 Homes and Garden Berquist Mediterranean 3 2 Yes No $440,000 3.80% People's 30
3/26/17 Homes and Garden Hesche Mediterranean 2 1 No Yes $390,000 4.20% Bank Of America 30
9/16/16 Homes and Garden Zinker Mediterranean 4 1 Yes No $440,000 4.30% Nations 30
3/27/17 Homes and Garden Charles Mediterranean 3 1 Yes No $320,000 4.50% Bank Of America 30
3/26/17 Homes and Garden Young Mediterranean 2 1 No Yes $355,000 3.90% People's 30
3/3/17 Homes and Garden Harris Mediterranean 2 1 Yes No $395,000 4.50% Nations 30
3/27/17 Remax Zimmerman Mediterranean 4 1 No Yes $390,000 3.30% First Federal 30
3/3/17 Remax Rodman Mediterranean 3 1 No Yes $445,000 4.50% Citywide 30
9/14/16 Remax Reynolds Mediterranean 5 1 Yes No $390,000 4.20% People's 30
4/19/16 Remax Nelson Mediterranean 4 2 Yes No $575,000 4.00% Citizens 30
3/3/17 Remax White Mediterranean 2 2 Yes No $575,000 3.40% First Federal 15

Loan Worksheet

Loan Payment per $100,000 Borrowed
4.00% 15 years
If you can afford this loan:
Rates Years Loan Payment $477.42
$739.69 15 30 40 Rate 4.00%
4.00% Years 30
4.05%
4.10% You can borrow this much:
4.15% Amount to Borrow $ 100,000
4.20%
4.25%
4.30%
4.35%
4.40%
4.45%
4.50%
4.55%
4.60%
4.65%
4.70%
4.75%
4.80%
4.85%
4.90%
4.95%