Drabkin & Conway has executed a strategy in recent years of acquiring residential real estate in River North and taking advantage of decreasing cap rates in that area, allowing the value of the...

1 answer below »

Drabkin & Conway has executed a strategy in recent years of acquiring residential real estate in River North and taking advantage of decreasing cap rates in that area, allowing the value of the condominiums to appreciate in value. However, with River North’s extreme growth for the last ten years, increased recent building in the area and with River North cap rates down to 4.5%, we do not see cap rates falling any further. The firm is deciding whether to continue to invest there.

In that vein, we have identified a property that we would like to bid on and we are looking to you to provide a valuation of the property using the 1) Sales Comparison approach and the two income approaches, the 2) Direct Capitalization method and the 3) Discounted Cash Flows method.

The property is apartment 1304 at 200 W. Grand Ave. Built in 2004 as a luxury building, 200 W. Grand Ave has provided consistent value in the area. It is at a desirable corner at Grand and Wells in the heart of River North, but yet the prices in the building currently lag the price of new construction considerably.

The listing of the property can be found here:

HYPERLINK "https://www.redfin.com/IL/Chicago/200-W-Grand-Ave-60654/unit-1304/home/ XXXXXXXXXX" https://www.redfin.com/IL/Chicago/200-W-Grand-Ave-60654/unit-1304/home/ XXXXXXXXXX

You can also search for the property on Zillow or similar sites.

Sales Comparison Approach

We have provided MLS data on other 04 units in the building that you should use to evaluate the property. All of the units are the same square footage and same layout. Please adjust the comparables for 1) Market Conditions (time), 2) Floor and 3) Parking. Please use apartments 1004, 1204 and 1404 for comparison.

There is one sale that is not listed on MLS. Details below:

Unit: 1404

Close Date: February 1, 2016

Single Space Parking Included

Sale Price: $494,000

Unit 1004

Close Date: 7/01/2016

Single Space Parking Included

Sale Price: $470,000

Unit 1204

Close Date: 1/01/2016

Single Space Parking Included

Sale Price: $435,000

Unit 1004

Close Date: 6/01/2017

Single Space Parking Included

Sale Price: $299,000

For 1) Time, you should use the closing date as the day for comparable. You should also not worry about the specific date within the month, just adjust for the number of months and assumes that we would close on our condo November 1, 2017. Meaning if one condo sold April 2, 2016, that is 18 months ago, as is April 29, 2016. You should use Unit 1004 here as that unit has sold twice in recent years.

For 2) Floor, the first two numbers of the apartment are the floor number. Just find two that are similar and use those.

For 3) Parking, look in the listing see if the parking was included in the sales price or not. You will see by garage ownership if it says “Deeded Sold Seperately,” you can assume that deeded parking was not included. Single spaces consistently sell for $35,000 and tandem spaces for $45,000 there and you can assume those values.

Direct Capitalization & DCF

In calculating NOI, please make the following assumptions:

Rent the unit for $3,100 per month for the next year. This will increase 3% per year starting in May, 2018

A vacancy rate of 5%

Monthly assessments as shown in the listing, we will assume these will stay the same for the next five years (don’t forget to multiply by 12!)

Property taxes of $4500/year to increase by 8% per year based on City budget problems

The cap rate today is 4.5% to stay steady for the next 5 years

We anticipate selling the property on May 1, 2022 or exactly 5 years later

You can assume that our discount rate is 8%

Deliverable

Please provide a valuation using all three methods and also what you think we should bid. As we have full legal and diligence capability on staff, you can assume $0 in closing costs.
Answered Same DayNov 04, 2019RE350

Answer To : Drabkin & Conway has executed a strategy in recent years of acquiring residential real estate in...

David answered on Dec 27 2019
68 Votes
Prop Val Syllabus Winter 2002
DePaul University
Driehaus College of Business
    RE350/FIN350
Real Estate Analysis
Case 2
R
e: Valuation of 200 W. Grand Ave, Apt. 1304
    
    Professor Danielle Drabkin
[email protected]
Drabkin & Conway has executed a strategy in recent years of acquiring residential real estate in River North and taking advantage of decreasing cap rates in that area, allowing the value of the condominiums to appreciate in value. However, with River North’s extreme growth for the last ten years, increased recent building in the area and with River North cap rates down to 4.5%, we do not see cap rates falling any further. The firm is deciding whether to continue to invest there.
In that vein, we have identified a property that we would like to bid on and we are looking to you to provide a valuation of the property using the 1) Sales Comparison approach and the two income approaches, the 2) Direct Capitalization method and the 3) Discounted Cash Flows method.
The property is apartment 1304 at 200 W. Grand Ave. Built in 2004 as a luxury building, 200 W. Grand Ave has provided consistent value in the area. It is at a desirable corner at Grand and Wells in the heart of River North, but yet the prices in the building cu
ently...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here