Assignment Instructions:
1. Your Task
Welcome to this single-family home valuation assignment! Here you will build your skills in valuing single-family homes using the sales comparison approach. Imagine you are working as an appraiser and have been asked by your client (the lender) to complete an appraisal for a getaway house called Valley Views (shown below). You have done your own in-depth market research and gathered five comparable properties to determine a fair price for the house. Your task: Calculate the subject property's market value using the sales comparison method.
2. Assumptions
General assumptions:
* All properties are located in the same neighborhood.
* Comparable properties were sold in the last six months.
* Comparable transactions are fee-simple and use conventional financing.
Value-added assumptions:
* Living area: $245/sf
* Bathrooms: $30,000
* Effective Age: $150,000
* The effective age of the subject property and comparables 2-5 is 20-25 years. The effective age of comparable 1 is 0-5 years.
* The market indicates an age adjustment is necessary for 0-5 years of $150,000.
* Fireplace: $750
* Garage: $11,500
* Pool: $15,500
* Accessory Dwelling Unit: $73,000
* Solar Panels: $5,749
* Balcony: $15,000
* Professional Landscaping: $10,000
* Yard Sprinklers: $6,000
Reconciliation Weights:
* Comparable 1: 17%
* Comparable 2: 25%
* Comparable 3: 30%
* Comparable 4: 17%
* Comparable 5: 11%
3. Instructions
1. Download the Valuation Template, Comparable Properties, and Subject Property files.
2. Review the information provided and find the indicated market value of the subject property using the sales comparison approach.
* Fill in the given information for the comparable and subject properties in the corresponding columns. For example, the information for the subject property would go under the "Subject" column in the table.
* In the Amenity Adjustments table to the right, fill in the given value-added assumptions.
* Using the information in the Amenity Adjustments table calculate the adjustments for each comparable next to the corresponding amenity. The table will automatically calculate the sum of your adjustments.
* After you calculate the adjusted price of each comparable fill in the remaining tables. In the reconciliation table fill in the given reconciliation weights for each comparable.
* Hint: multiply the weight by the adjusted value for each comp to calculate indicated market value of the subject property.
3. Calculate the indicated market value of the subject property.
4. Once you complete the Valuation Template, complete the "2.1 Tell Us Your Answers".
* This is a series of 15 multiple-choice questions about the Valuation Template you've just completed along with theoretical questions about the sales comparison approach to valuation.
5. Upload your completed Valuation Template in "2.2 Upload Your Work Here".
6. If you get stuck, take a look at the video content & practice problems in the following module: Valuation Approach (Sales, Cost & Income)
Hint: Summary of Adjustments table is new, so here are the key terms defined.
Net Adjustments: These are net adjustments made to the Selling Price. Essentially it's the Adjusted Price less Selling Price.
Min Adjustment: The smallest nominal adjustment made to the Selling Price except $0. It's $6,000 for the first comp.
Max Adjustment: The biggest nominal adjustment made to the Selling Price. It's $150,000 for the first comp.
Range of Adjusted Prices: the difference between the smallest "Adjusted Price" derived (Low) & the largest Adjusted Price (High).
