A comparable sale grid analysis (5 Pts). I recommend you complete this question using MS excel and then enter the answers here below. However this is not obligatory, you can do the calculations manually.

An appraiser is attempting to estimate the value of a house. The subject property has four bedrooms and a swimming pool, a 2 stall garage, 1500 SFT (AGLA), 1000 SFT of finished basement SFT and and 500 SFT of unfinished basement.

The appraiser has found three comparables that have recently sold. Comp 1 sold for $200,000 has 5 bedrooms and no pool, a 1 car garage, 1200 SFT of AGLA, 800 SFT of finished basement and 400 SFT unfinished basement . Comp 2 sold for $220,000 has 4 bedrooms and no pool a 1 car garage, 1000 SFT of AGLA, 600 SFT of finished basement and 400 SFT unfinished basement . Comp 3 sold for $260,000, has 3 bedrooms and a pool, a 3 car garage, 1700 SFT of AGLA, 1000 SFT of finished basement and 500 SFT unfinished basement .

AGLA is valued at $40/sft, finished basement square footage is 50% of AGLA and unfinished basement square footage is 50% of finished square footage. Pools are valued at $10,000 and garage stalls at $8000.

Fill in the comparable sale grid below that illustrates key adjustment features comp sale prices, adjustment values, net adjustments, adjusted sale prices, the % of adjustment and then estimate the value of the subject property based on the mathematical average of the 3 adjusted sale prices of the comparables (even though appraisers are not supposed to calculate such an average). Finally state the value of the best comparable

	Subject	Comp1	Comp 2	Comp 3
Sale Price
Adjustment Features
1) SFT (AGLA)
2) SFT (FIN Base)
3) SFT (Unfin Base)
4) Garage
5) Pool
Net Adjustment ($)
Adjusted Sale Price
Adjusted Sale Price as a % or Original Sale price along with the sign
Avg. of Adjjusted Comp. Values
Adjusted valuye fo the best comparable