In this Lesson we will learn how to analyze Comparable Sales just like an appraiser so you can accurately forecast the After Repair Value for a property.
What Is The After Repair Value?
The After Repair Value is the amount you can re-sell the property for after you make the necessary improvements and repairs.
How Is The After Repair Value Calculated?
To estimate the After Repair Value of a property you want to step into the shoes of an Appraiser. Home Appraisers use an appraisal method called the Sales Comparison Approach which compares recent comparable sales of similar properties in the area.
To estimate the value of a property the Appraiser will 'pull comps' of 3 to 5 comparable properties that have sold within the last 1 to 6 months (more recent the better). Recent comparable sales should be in close proximity to your property, have similar square footage, # of beds/baths, similar level of finishes and amenities.
The Appraiser then compares the 'Subject Property's' features and amenities with the comparables and makes pricing adjustments up and down to create an equilibrium and make the properties apples-to-apples. The Appraiser then uses price adjustments to adjust the Sales Prices of the comparables to estimate an approximate value of the 'Subject Property'.
Getting A Pulse On Your Market
<span class="lesson-quote--tag orange">REALITY CHECK</span>
<p style="margin-bottom:10px;">Before We Get Ahead Of Ourselves And Worry Too Much About The Complexities Of Performing A Comparable Market Analysis, Let's Start With The Basics.</p>
<p style="margin-bottom:0px;">In Order To Quickly Analyze Deals And Predict The After Repair Value Of A Property You Need To Have A 'Pulse' On Your Market And Understand The Value Of Properties In Your Area.</p>
Establish A 'Farm Area
'In our previous Article, we discussed targeting a 'farm area' that you will use to 'farm, cultivate, and grow' your flipping business. This 'farm area' is a targeted region in your area, such as specific school districts & neighborhoods where you will be focusing on finding deals & rehabbing houses.
By focusing on these targeted 'farm areas', you can quickly become an expert on buying prices, comparable sales & market competition in your area, and ultimately help you get a pulse on the market.
Once your business starts to grow you can start to grow your farm area & expand your market reach.
Targeting a 'Farm Area to Flip Houses'
<iframe width="560" height="315" src="https://www.youtube.com/embed/1k_sDc9ctnE" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
Daily MLS Notifications
The best way to get a pulse on your market is to get daily email notifications of new MLS listings in your 'farm area'. Find a local Real Estate brokerage, setup an account & setup your property criteria to get daily notifications of new listings. Every morning you will get a new batch of listings which to help you get a pulse on the competition & sales values on the market.
Although Daily MLS Notifications will tell you what sellers are asking, it doesn't tell you the actual sales price the property sold. In order to really see what properties are selling for, you need to get access to the MLS.
- Realtor - Your real estate agent should be able to get you access to the MLS. Have your Agent pull Comparable Sales information dating back 4 to 6 months so you can get a full understanding of comparable sales prices & the average days-on-market.
- Zillow/Redfin - If you can't get direct access to the MLS, Zillow & Redfin can be decent resources for finding recently sold information, but unfortunately their data feed can be delayed.
- FlipperForce - We have a Comps Tool that populates recent comparable sales so you can forecast the ARV for your subject property and create a Professional CMA for your business partners and lenders!
Spy On The Competition
To really understand your comps and competition, you should physically walk through the properties for sale in your neighborhood to get a pulse on the competition's pricing and finished product. This will help you understand exactly what kind of flipping competition you are up against in your market.
How To Compare & Analyze Comparable Sales
By just having a 'pulse' on the market will be able to quickly and intuitively predict the approximate resale value of property that can be used in your initial analysis. Once you get further into due diligence, you will want to 'run comps' of the subject property to ensure that your initial resale assumptions are supported by recent comparable sales in the area.
Step #1 Run Comps
Have your Agent 'run comps' (or get on Redfin) and create a Comparable Market Analysis for the subject property. A Comparative Market Analysis will show active listings currently for sale, pending home sales, & recently sold listings for the last 6 months.
Identify 3 To 5 Of The Best Comps
Once you receive your CMA, you and your Agent should try to identify the 3 to 5 of the best, most comparable properties.
- Similar square footage - Appraisers compare homes based upon the square footage of the property. Therefore, you need to find comps that have similar square footage, ideally within +/- 10%.
- Similar amenities, upgrades & condition - Appraisers adjust property values based upon property amenities and upgrades. If other homes have 3 bathrooms and your property only has 2, the appraiser will deduct value from your property appraisal.
- Similar age of construction - Mixed-age subdivisions are common, but the prices of the properties will vary depending on the year it was built. A brand new home will be more expensive than a home built in the 1980s. Ideally, when identifying comps the age of the home should be within a few years.
- Location - Everyone knows real estate is valued on location, location, location, but do you know what that means? Compare your home to similar locations. If your home sits next to a busy, noisy highway, look for other homes that are located with highway exposure.
- Sales Date - Real estate market values can change quickly, so it's important to use recent comparable sales dates of less than 6 months.
Identify 3 To 5 Of The Best Comps
Once you identify 3 to 5 of the best comps for your Subject property, you need to make price adjustments to make an 'apples-to-apples' comparison. This adjustment process is the 'Sales Comparison Approach' which professional appraisers use to make price adjustments for differences in the subject property and comps.
- Compare Subject Property Amenities to Comps: Number of bedrooms, Bathrooms, Square footage, Garages, Upgrades
- Make Adjustments to Comps for Differences in Amenities - Once you have identified the differences, you need to make price adjustments to the comparables to equalize the values.
- Calculate Comparables $/SF - Once the Comparables are 'equalized', calculate the $/SF value for the property. This $/SF value can then be multiplied by the Subject Property's square footage to calculate the After Repair Value of the property.
<span class="lesson-quote--tag orange">IN SUMMARY</span>
<p>So In Other Words, Find At Least 3 Properties That Are Similar To Your Rehab Project And Compare Their Sales Prices, Features And Amenities And Make $ Adjustments Accordingly. If You Need Help With This Process, A Real Estate Agent Should Be Able To Provide A Comparable Market Analysis For Your Property.</p>
In the example below, we have identified 3 recent comparable sales to analyze against our Subject Property.
Comp 1 is a little bit smaller than the Subject Property so we need to equalize Comp 1 to have the same square footage as the Subject. To do so, we multiplied 25sf x ~$120/sf = $3,000
Comp 2 has an additional bedroom and an additional half bathroom, and 25 extra square feet. In order to equalize Comp 2, we need to deduct the value of the amenities.
Comp 3 is basically the same floor plan as the Subject property, but the level of finish is not as nice as the rehabbed properties on the market, so it needs a positive adjustment to account for the added value for the rehab.
Once we have equalized the property values, we divide the values by the Subject Square footage to calculate a $/sf amount.
In this scenario, the Comps are selling for $118 to $119/sf.
To calculate our ARV, we multiply the $/sf amount by the Subject Square footage.
Subject Property Value = Comps $/sf * Square Footage
Subject Property Value = $118 * 1,700 sf
Subject Property Value (ARV) = $200,600
<table id="costs"> <tbody><tr> <th style="width: 20%;"></th> <th style="width: 20%;">Subject</th> <th style="width: 20%;">Comp 1</th> <th style="width: 20%;">Comp 2</th> <th style="width: 20%;">Comp 3</th> </tr> <tr> <td>Sales Price</td> <td>TBD</td> <td>$200,000</td> <td>$210,000</td> <td>$190,000</td> </tr> <tr> <td># of Beds</td> <td>3</td> <td>3</td> <td>4 (-$5k)</td> <td>3</td> </tr> <tr> <td># of Baths</td> <td>2</td> <td>2</td> <td>2.5 (-$1k)</td> <td>2</td> </tr> <tr> <td>Square Footage</td> <td>1,700</td> <td>1,675 (+$3k)</td> <td>1,725 (-$3k)</td> <td>1,700</td> </tr> <tr> <td>Condition</td> <td>Rehabbed</td> <td>Rehabbed</td> <td>Rehabbed</td> <td>Some Updates (+$10k)</td> </tr> <tr style="border-top: 3px double black;"> <td><strong>Totals</strong></td> <td></td> <td><strong>$203,000</strong></td> <td><strong>$201,000</strong></td> <td><strong>$200,000</strong></td> </tr> <tr> <td>$/sf</td> <td></td> <td><strong>$119/sf</strong></td> <td><strong>$118/sf</strong></td> <td><strong>$118/sf</strong></td> </tr> </tbody></table>