Case 1
You are appraising a single-family residence located in the Huntington neighborhood at 4632 NW 56th Drive. The property is being acquired by a mortgage applicant and you have been asked to appraise the property by the lender. Seven potential comparable sales were initially identified. However, three of these seven were highly similar to the subject property in their transactional, physical, and locational characteristics. You therefore decided to exclude the other four transactions from the comparable set.
The elements of comparison you used to compare and adjust the sale prices of the comparable properties are listed in the market data grid below. The property rights being conveyed in the acquisition of the subject property are fee-simple absolute. Conventional mortgage financing will be used by the purchaser and the acquisition appears to be an arm’s-length transaction. Thus, no adjustments need to be made to the sale prices of the comparable properties for the type of property rights conveyed, financing terms, or conditions of sale. However, the buyer of Comparable 2 was aware that she would have to replace one of the air-conditioning units immediately after acquiring the property (which she did); thus, she was able to negotiate a $3,000 price reduction from the seller.
Comparable 1 sold three months ago, while Comparables 2 and 3 sold six months ago. Based on your knowledge of recent price appreciation in this market, you have decided that Comparable 1 would sell for 2 percent more if sold today and that Comparables 2 and 3 would sell for 4 percent more if sold today. The subject property is located in Huntington, as is Comparable 1. However, Comparables 2 and 3 are located in Kensington and Millhoper, respectively. Although Huntington is a high-end neighborhood, both Kensington and Millhoper are generally considered to be slightly more desirable. In fact, homes in these two neighborhoods generally sell for about a 3 percent price premium relative to similar homes in Huntington.
In these neighborhoods, an incremental square foot of lot size or living area is worth about $20 per square foot and $80 per square foot, respectively. Each year of effective age reduces the value of properties in this market by about $3,000 per year. Your experience suggests that each additional half-bath is worth $500; each additional full bath $1,000. Additional garage spaces, wood decks, and pools in Page 189these neighborhoods are worth $8,000, $1,000, and $12,000, respectively. No significant nonrealty items were included in the comparable transactions.
Elements of Comparison Subject Comp Sale 1 Comp Sale 2 Comp Sale 3
Sale price of comparable $510,000 $525,000 $499,000
Transaction characteristics
Property rights conveyed Fee Simple Same Same Same
Financing terms Conventional Same Same Same
Conditions of sale Arm's Length Same Same Same
Expenditures immed. after purchase None $3,000 None
Market conditions Today
3 mos. ago: add 2% total
6 mos. ago: add 4% total 6 mos. ago: add 4% total
Property characteristics
Location Huntington Huntington Kensington Millhoper
Physical characteristics:
Site/lot size 6,662 sq. ft. 6,700 sq. ft. 6,800 sq. ft. 6,600 sq. ft.
Construction quality Typical Typical Typical Typical
Condition Average Average Average Average
Effective age 5.5 years 7 years 8 years 10 years
Living area 3,473 sq. ft. 3,920 sq. ft. 3,985 sq. ft. 3,835 sq. ft.
Number of baths 3.0 baths 3.5 baths 3.0 baths 2.0 baths
Garage Spaces 2-car 2-car 2-car 1-car
Porch, patio, deck Cov. Porch/wood deck Cov. Porch Cov. Porch Cov. Porch
Fence, pool, etc. None None Pool Pool
Economics characteristics N.A. N.A. N.A. N.A.
Use Single-family Same Same Same
Nonrealty components None None None None
Questions :
1. Based on the above discussion of the elements of comparison, complete an adjustment grid for the three comparable properties.
2. What is the final adjusted sale price for Comparables 1, 2, and 3?
Case 2:
Given the following owner’s income and expense estimates for an apartment property, formulate a reconstructed operating statement. The building consists of 10 units that could rent for $550 per month each.
Owner’s Annual Income Statement
Rental income (last year)
$60,600
Less: Operating & capital expenses
Power
$2,200
Heat
1,700
Janitor
4,600
Water
3,700
Maintenance
4,800
Reserve for capital expenditures
2,800
Management
3,000
Tax depreciation
5,000
Mortgage payments
6,300
Estimating vacancy and collection losses at 5 percent of potential gross income, reconstruct the operating statement to obtain an estimate of NOI. Assume an above-line treatment of CAPX. Remember, there may be items in the owner’s statement that should not be included in the reconstructed operating statement.
Questions:
1. Using the NOI and a Ro of 11.0 percent, calculate the property’s indicated market value. Round your answer to the nearest $1,000.
Case 3:
You have been asked to estimate the market value of an apartment complex that is producing annual net operating income of $44,500. Four highly similar and competitive apartment properties within two blocks of the subject property have sold in the past three months. All four offer essentially the same amenities and services as the subject. All were open-market transactions with similar terms of sale. All were financed with 30-year fixed-rate mortgages using 70 percent debt and 30 percent equity. The sale prices and estimated first-year net operating incomes were as follows:
Comparable 1: Sale price $500,000; NOI $55,000
Comparable 2: Sale price $420,000; NOI $50,400
Comparable 3: Sale price $475,000; NOI $53,400
Comparable 4: Sale price $600,000; NOI $69,000
Question:
1. What is the indicated value of the subject using direct capitalization?
Case 1
You are appraising a single-family residence located in the Huntington neighborhood at 4632 NW 56th Drive. The property is being acquired by a mortgage applicant and you have been asked to appraise the property by the lender. Seven potential comparable sales were initially identified. However, three of these seven were highly similar to the subject property in their transactional, physical, and locational characteristics. You therefore decided to exclude the other four transactions from the comparable set.
The elements of comparison you used to compare and adjust the sale prices of the comparable properties are listed in the market data grid below. The property rights being conveyed in the acquisition of the subject property are fee-simple absolute. Conventional mortgage financing will be used by the purchaser and the acquisition appears to be an arm’s-length transaction. Thus, no adjustments need to be made to the sale prices of the comparable properties for the type of property rights conveyed, financing terms, or conditions of sale. However, the buyer of Comparable 2 was aware that she would have to replace one of the air-conditioning units immediately after acquiring the property (which she did); thus, she was able to negotiate a $3,000 price reduction from the seller.
Comparable 1 sold three months ago, while Comparables 2 and 3 sold six months ago. Based on your knowledge of recent price appreciation in this market, you have decided that Comparable 1 would sell for 2 percent more if sold today and that Comparables 2 and 3 would sell for 4 percent more if sold today. The subject property is located in Huntington, as is Comparable 1. However, Comparables 2 and 3 are located in Kensington and Millhoper, respectively. Although Huntington is a high-end neighborhood, both Kensington and Millhoper are generally considered to be slightly more desirable. In fact, homes in these two neighborhoods generally sell for about a 3 percent price premium relative to similar homes in Huntington.
In these neighborhoods, an incremental square foot of lot size or living area is worth about $20 per square foot and $80 per square foot, respectively. Each year of effective age reduces the value of properties in this market by about $3,000 per year. Your experience suggests that each additional half-bath is worth $500; each additional full bath $1,000. Additional garage spaces, wood decks, and pools in Page 189these neighborhoods are worth $8,000, $1,000, and $12,000, respectively. No significant nonrealty items were included in the comparable transactions.
Questions :
1. Based on the above discussion of the elements of comparison, complete an adjustment grid for the three comparable properties.
2. What is the final adjusted sale price for Comparables 1, 2, and 3?
Question:
1. What is the indicated value of the subject using direct capitalization?
Flag question: Question 1
Upload your excel here.
Case 1:
After transaction adjustments what is adjusted price for comparable 1?
Group of answer choices
520,200
500,200
420,200
510,000
Question 3
Case 1:
After transaction adjustments what is adjusted price for comparable 2?
Group of answer choices
549,120
509,120
649,120
525,000
Flag question: Question 4
Case 1:
After transaction adjustments what is adjusted price for comparable 3?
Group of answer choices
518,960
598,960
578,960
499,000
Question 5
Case 1:
What is final adjusted sale price(after transcation and property adjustments) for comparable 1?
Group of answer choices
488,680
418,680
588,680
458,680
Question 6
Case 1:
What is final adjusted sale price(after transcation and property adjustments) for comparable 2?
Group of answer choices
485,426
445,426
585,426
400,42
Question 7
Case 1:
What is final adjusted sale price(after transcation and property adjustments) for comparable 3?
Group of answer choices
487,171
587,171
417,171
517,171
Question 8
Case 2:
What is the Potential Gross Income (PGI)?
Group of answer choices
66,000
60,000
120,000
55000
Question 9
Case 2:
What is the Effective Gross Income (EGI)?
Group of answer choices
62,700
52,700
12,700
42,700
Question 10
Case 2:
What is the Net Operating Income (NOI)?
Group of answer choices
39,900
29,900
49,900
59,900
Question 11
Case 2:
What is the indicated value of property?
Group of answer choices
$362,727
$462,727
$562,727
$302,727
Question 12
Case 3:
What is the average of four comparable cap rates?
Group of answer choices
0.114
0.1
0.213
0.09
Question 13
Case 3:
What is the indicated value of the property?
Group of answer choices
$390, 351
$490, 351
$350,000
$445,000