How to find ARV using the REI/kit ARV Calculator

By | October 16, 2016

Red house under magnifying glass among white housesIf you want to invest in distressed real estate in another city or state, how can you determine what a property’s ARV (after repair value) is? The remote flipper faces some challenges in finding and evaluating properties. However, as we explained in this post on how to find comps with Redfin, a solid technical toolbox is your best asset. Included in that toolkit should be the REI/kit ARV Calculator, which we walk through step-by-step in this article.

As you read this article, keep in mind that the steps will become easier with practice. Practice will also allow you to have a great overview of property values of the properties in your target area. Having the right numbers to back you up will give you a needed boost. This, in turn, will help you to continue your due diligence on a property after establishing the ARV.

 

The Deal

In this post we show how to find the ARV for a subject property that we received from a wholesaler:

Property sheet from wholesaler for discount property in Los Angeles

 

We have already looked for comps in Redfin and narrowed them down. These three met the five most important criteria of a good comp. They were also in an updated or remodeled condition, reflective of what the subject property will look like after repairs:

Excel spreadsheet showing property comps data for final three comps from part 1

Steps to Find the ARV

The process of finding the ARV using the REI/kit ARV Calculator is broken down into seven parts. We list the major ones below:

  • Enter in the subject property address to populate the subject property information
  • Enter in the comparative addresses to populate their information
  • Establish values for features such as bathrooms, bedrooms, and garage or carport spaces
  • Adjust the value of those features for each property
  • Add any other unique features of the subject or comp properties. Determine those values, such as a pool or view, and adjust as necessary

Getting Started

Now we navigate to the REI/kit ARV Calculator at www.reikit.com/comps to put in our three comps. The first thing you see in the calculator is that there are two tabs: ‘Comps’ and ‘Adjustments.’ The Comps tab is for inputting both your subject property and your comparable properties. After you have added those in,  you switch to the Adjustments tab to continue your calculations:

Two tabs in REI/kit ARV Calculator which are Comps and Adjustments

 

Adding the Subject Property

The first thing we do is enter the subject property in the search field. Underneath, the Google maps suggestions will appear. Select the appropriate location:

Entering subject address into search bar of REIkit Accurate ARV Calculator

 

Evaluating the Suggested Comps

The REI/kit interface uses Zillow data to auto-populate available subject property information. These values can be clicked into and adjusted if necessary. At the same time, the interface also populates five locations. These suggested locations are what Zillow determines are comps based on their data.

 

REIkit Accurate ARV Calculator automatically populates the subject property info from Zillow

 

You should only use these suggested comps as just that — suggestions. To truly find the ARV you need  to come up with your own comps. We outlined how to do this in the post on how to run comps in Redfin. We will be writing another post explaining why you would want to input Redfin comps vs ones found from Zillow, but for now you’ll just have to trust us.

Removing or Omitting Comps

REI/kit shows an adjusted ARV for those current five properties. We will be removing all five of those properties. Why? They are not the comps we discovered during our comps selection process using Redfin. We will be replacing them with the three we found to get to the true ARV of our property.

To remove each comp in the interface, simply click on the trash can at the end of the comp’s row. It is not always necessary to remove them completely. To see the comp in this list but not use it in the analysis, or have it included in the adjusted ARV, you’d uncheck the box to the left of the address:

You can remove the comps that were retrieved by REIkit Accurate ARV Calculator by clicking on the trash can

Adding Comps

After removing all of the comps, notice that the ARV automatically adjusts as well and the address box now says “Search Additional Comp Address”:

After removing all the comps autopopulated by the REIkit Accurate ARV Calculator

 

We input the addresses of the three comps we found. Add each address, selecting it from the addresses that appear below:

Add properties to REIkit Accurate ARV Calculator that are then autopopulated

 

Double-Checking the Data

This additional search box also uses Zillow data to try to auto-populate property data. Zillow may not have complete, or accurate data. You should double check the property stats with those that you found on Redfin. It will then be necessary to adjust them.
In this example below, we put the excel spreadsheet of comps and the REI/kit data side by side. Looking closely, we can see some issues.

Excel spreadsheet showing property comps data for final three comps from part 1

 

Comps from Part 1 entered into REIkit Accurate ARV Calculator

 

One issue is that the 1300 W 90th Pl (row 2) reports 3 beds in Redfin but only 2 from Zillow. Why might this be? According to the Redfin listing, the property “shows” 3 bedrooms, but only 2 are on file in the county records.

Another issue is that the most recent sale in Zillow for the same listing is older than the sale of that property found in Redfin. The newer sale in Redfin shows a 125K increase in price!  Viewing the sales history in Redfin shows that the property was, in fact, sold for $265,000 some months earlier. This underscores the need for having the most recent comps, and the most up to date data:

Redfin listing showing increased price of improved property

 

Property sales data for comp in Redfin showing price difference from Zillow

 

It’s important to double-check your numbers and investigate when they don’t match.

Adjusting Data Fields

We are going to adjust the price of 1300 W 90th Pl in REI/kit. We click into the ‘Sold ($)’ column and type in 390000. Watch those Adjusted ARV numbers go up!

Adjusting the price of a comp that had older information from Zillow

 

We have finished inputting our comps in the Comps tab, so we move on to the next step in REI/kit. Now we perform a deep analysis of the comps in the Adjustments tab. The Adjustment tab has our updated data for 1300 W 90th Pl already populated. As in the Comps tab, you can also easily click into and update most fields.

Viewing the Adjustments Tab

When looking at the REI/kit Calculator’s Adjustments tab, there are a few important items to note. First, the information you entered in the Comps tab is reflected in the Basic information section across the top of the screen:

reikit-arv-calculator-adjustments-tab-vertical-info

 

Second, the major focus of the Adjustments tab are the rows under the gray horizontal bar. Here, you adjust for value based on the Features, or amenities, of the comparable properties.

Features

REI/kit starts off with the five most common features: the lot size, inclusion of a carport or a garage, and the number of bathrooms and bedrooms. However, you can add any number of your own features to compare. Some of these features might be basements, pools, or even views:

Features section of REIkit ARV Calculator

 

Feature Values

Next to the column listing the features are the values you believe those features are worth. You will need to know what those values are based on your own market. You might get the values through your realtor or just based on your own personal experience. Running comps to find the differences between properties that have a particular feature and those that do not is another way (we describe this process later). In a pinch, you can also use construction costs. However, they may not be indicative of actual value, or what people are willing to pay for such a feature. Once you know the values, click into the ‘Feature Values’ field next to the feature and adjust the values as they fit your target area:

Features values section of REIkit ARV Calculator

 

Adding a Feature

If you have additional features not listed, there is an ‘Add feature’ button that allows you to manually add them. These could include swimming pool, as fireplace, or a detached shed with workshop. Whatever features you add, however need to have the appropriate dollar amount assigned to them. The easiest way to get the appropriate amount is to contact a real estate agent for help. Another option is to, through a process of elimination, come by an approximate value. For example, say you have a subject property with a pool, but you don’t know how much a pool is worth in that neighborhood. You would find comps that consist of three very similar houses with swimming pools and three very similar houses without a pool. Provided they were very similar, this equation could be used:

averaged together price of the houses with swimming pools – averaged together price of the houses without swimming pools = approximate value of feature

Explanation of Values Computation

One of the most confusing aspect of adjusting comps is in knowing where to subtract values and where to add values. after choosing the number of features for your property, the REI/kit calculator does the hard work for us. It does this by by adding and subtracting values from comparable properties. You can see this at work when looking at the adjustments calculations above for the bedrooms and bathrooms.

To illustrate, the subject property has two bathrooms, and since all of the comps have two bathrooms, there are no adjustments necessary for that feature. However, the subject property has four bedrooms, and some of the comps have more, and some have fewer of that feature. The sum value of those features gets automatically adjusted as seen in the adjustment columns next to each comparable feature.

For example, 1300 W 90th Pl has only two bedrooms. Since a bedroom feature has a value of $10,000 in that neighborhood, and our subject has four bedrooms, the calculator adds $20,000 upward to the value of our comparable. What does this mean? Essentially, you would have to spend an extra $20,000 to make the comparable the same as our subject property. To show an example of a downward adjustment, notice that the property at 1230 W 88th St has five bedrooms. In that case, it is “better” than our subject property in terms of bedrooms. So, the calculator adjusts the value of the comparable property downward by $10,000.  Essentially, we would have to remove the bedroom from that property in order to make it look like the subject property. 1119 W 89th St has 4 bedrooms, so there is no adjustment necessary for that property’s bedroom feature.

You always adjust the value of the comparables, because you know what their values are. You don’t know the value of the subject property, so you can’t adjust it. After all, you’re trying to determine it’s value.

REIkit ARV Calculator automatically calculates value of the comp property bedrooms based on the inputted values

 

Verify Your Features

We’ve talked about how the adjustments work, so let’s now emphasize the importance of reviewing the listing details of the subject property and its comps. We must compare it to the information from the wholesaler, and also take note of the physical characteristics of each property.

The listing from the wholesaler states that it has a two-car garage. The REI/kit calculator has not added garage spaces for these four properties because that data could not be extracted from Zillow. However, when reviewing the photos of 1230 W 88th St in Redfin, for example, it’s clear that the house has a two-car garage:

 

1230 W 88th Street Redfin listing shows 2 car garage

 

A quick check of the other properties in Redfin shows that all of them have a two-car garage.

For properties that have all of the same feature that’s in the same condition, it’s unnecessary to add those features for adjustment. There simply is no adjustment. If, however, all properties but one had a garage, then adjustments would be necessary. In those cases you would want to add what a garage or garage space was worth in that neighborhood for adjustment. In this neighborhood, the value of a garage space is $10,000. We click into the ‘Feature Values’ field for ‘Garage spaces’ and type in 10000. Then we have to adjust the number of spaces by clicking on the up or down arrows next to all five properties. Again, since in this case the number of garage spaces is the same across the board, we don’t need to adjust anything. You may choose to increase the number of units to two despite the fact that there is no adjustment, for your record. To underline — when looking at features, should there have been some properties with only street parking and some with a one-car garage, we would have adjusted those values accordingly.

Adjusted garage feature for all three properties in the REIkit ARV Calculator

 

Evaluating the Final ARV

Now that we’ve double-checked our values and units and have a final ARV, let’s review what the wholesaler in Part 1 stated was their estimate of the ARV of the subject property: $458,000. Does that match what we came up with?

Even better! The resulting ARV in the REI/kit ARV Calculator after a seven-step adjustment is $12,738 more than the amount that the wholesaler estimated.

 

Final ARV of subject property as calculated by the REIkit ARV Calculator

 

This is good news for us, and a good first step in the analysis process. There are many more factors to take into account before deciding to purchase a property. We go over those in future posts on flip costs and estimating rehab costs.

It’s a Numbers Game

The steps to arrive at an accurate ARV may seem overwhelming at first. With practice, however, you will find the process becomes much faster. You will also start to get a very good feel for your target area ARV’s in general after evaluating a number of properties with the REI/kit ARV Calculator. Knowing your numbers will prevent you from making serious mistakes. Having a solid number will also give you the confidence you need to move forward on a deal. These are all skills worth honing.

If you liked this post and would like to receive posts on how to improve your fix and flip business as soon as they roll out, please subscribe to the Remote Fix and Flip blog.

I want fresh fix and flip news!


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

One thought on “How to find ARV using the REI/kit ARV Calculator

  1. Pingback: How to find comps using Redfin – Remote Fix and Flip

Leave a Reply

Your email address will not be published. Required fields are marked *