Wednesday, April 1, 2009

How accurate are the 2009 Albemarle County Assessments

There has been some heated discussion on the relevance of the county assessments to actual sales pricing. I decided to take a look at all the properties that have sold within the last 3 months and create a linear regression of the sales versus the 2009 assessment price.

To the non-data geeks out there a regression is a means of looking at past data and creating a simple formula that would allow you to predict what future sales may be like based upon past data.

The reason I put MAY in bold is that the past is never a great predictor of the future, the stock market is a great example of that. How many people were thinking that their 401Ks that had been growing steadily would drop 50% in one year? Not me!

After looking at the total sales, I eliminated the following types of transactions from the sales data:
  1. Related party transactions (family member selling to family member)
  2. Foreclosures
  3. Commercial Property
  4. Properties valued over $1 million
  5. Dumb Buyers (People paying over $200/sq ft for new construction this year)
From that I was left with 155 properties to build the regression. I wanted to build a formula so that I could predict the Sales price based upon the 2009 Assessment.

The statistics of the properties are as follows:
  • Median sales price was $248,900
  • Standard Deviation is $170,413
I created a data field that I called assessment error. All this is is the Last Sale Price minus the 2009 Assessment. For example if a house sold in March of 2009 for $500,000K and the 2009 Assessment was $600K, the assessment error would be -$100K.

Creating a histogram of the data you can see the distribution:



A histogram is just a fancy way of saying we want to graph the number of times (the frequency) the assessment error was within a certain value range. You can see that the total number of properties that have apssessment errors that are $5K more than the selling price or $5K less than the selling price is about 30.

On the side of the graph you will see the following variables:

mean -4,578

That tells us that the average assessment is $4,578 higher than what the house actually sold for.

standard deviation 30,861

In statistics the assumption is for a bell shaped distribution 68% of the data is captured within 1 standard deviation ($30,861) from the mean. 95% of the data will be captured within 2 standard deviations from the mean ($61,772).

That tells us that most properties (95%) will sell with an assessment error between -$66,300 and $57,144. Remember a negative assessment error means that the property is assessed at more than it will sell for, and a positive assessment error means that the property is assessed less than it will sell for.

N 155

Tells us that this data is being built off of 155 different properties.

From the bell shape of the data we can assume that the assessment error approximates a normal distribution.

So we want to look at all the previous assessment prices and figure out a formula that looks like this:

Sales Price = Fixed Constant + Assessment_Coefficient * 2009 Assessment

What this does is if we have a property we can plug in the 2009 Assessment value and the Fixed Constant and Assessment_Coefficients to get the price. Thankfully we have computers that can take that raw data and figure out the coefficients for us.

The linear regression looks like this:



The blue line is what the computer has generated based upon the current data points. It tries to draw a straight line so that if you were to enter a 2009 assessment value you could calculate what the likely sales price would be. The red dots indicate where the sale actually occurred and the distance between that red dot and the blue line is the error of the prediction.

The R-sq value on the graph shows how well does this line fit the data. It fits the data about 96.7%. Not a perfect fit, but as the phrase goes good enough for government work!

So the formula looks like this:

Sales Price = -$6,650 + 1.007 * Assessment

What that tells us if you take a property and use the 2009 assessment and increase it by .7% and then subtract $6,650 dollars you should have the likely selling price.

Lets check it against some of the data we have:

503 Jester Lane, Charlottesville, VA

It was assessed at $142,000 in 2009. Using the formula we can expect the sales price to be:

Sales Price = -$6,650 + 1.007 * $142,000
= $136,344

It actually sold for $136,700 so it was only off by $357.

Don't be so surprised that the model can be this accurate, because we built the model based upon this data. If you look at the data most of the sample data is for sales within $200K - $400K.

Lets look at another two which will demonstrate the extremes.

145 Ivy Ridge Rd, Charlottesville, VA

It was assessed at $721,700 in 2009. Using the formula we can expect the sales price to be:

Sales Price = -$6,650 + 1.007 * $721,700
= $720,102

It actually sold for $780,000 so the model was lower by $59,898.

This should not comes as a surprise since there are fewer sample points to build the regression model from in the $700K or greater valuation price.

1225 Old Garth Rd, Charlottesville, VA

It was assessed at $469,600 in 2009. Using the formula we can expect the sales price to be:

Sales Price = -$6,650 + 1.007 * $469,600
= $466,237

It actually sold for $405,000 so the model was higher by $61,237.

So what does all of this tell us?

With the regression model showing only a 0.7% increase to the 2009 assessed value and then subtracting off $6,650 before getting to the sales price tells me that most buyers are paying very close attention to the 2009 assessed values.

Bear in mind IT IS ONLY A FORMULA. And since it is based upon the past, so to be accurate this formula needs to be updated. I plan on tracking this on a monthly basis and seeing how the market is changing.

I would be interested in people's feedback on what they think of the current pricing formula. Feel free to leave a comment.

8 comments:

  1. I presume you are referring to the assessed values that the county/city associates with each property vs. appraised value? I am a real estate agent and represented two sellers last year whereby one home sold for approximately $100K more than assessed (assessed was 390K sold for 490K; 1420 Singleton Ln) and the other sold for approximately $100K less than assessed value (assessed at 360K and sold for 260K; 302 Monte Vista Ave)...maybe you would say these are outliers but these instances also tell me that assessed value does NOT reflect market value and therefore you still have to look at each property on a case by case basis. Interestingly, you can also call the county or city and have them come out to your property to do a full appraisal, especially if you tell them you feel the assessed value is too low in which case they will do a full market analysis/appraisal and potentially raise your assessed value. May not be such a bad idea if more and more buyers look to that figure as the be all end all figure for valuating a house.

    ReplyDelete
  2. Christine thank you for your post and your examples!

    Yes I have created a bit of confusion regarding assessment versus appraisal. I have changed the wording to show Assessment instead of Appraisal.

    Regarding your 1420 Singleton listing it looks like it sold for $81.4K above the (2008 assessed value was $408.6K - $115K land and $293.6K in improvements). I would have to say that the higher sales price had everything to do with timing and that it was your house that you were selling! :-)

    The sale didn't complete until 8/8/2008 which means it most likely went under contract in mid June. The economy still seemed pretty good back then. Additionally the house was built in 2005 with 2,754 sq feet of living space so adjusting the sales price for the land assessed value gives us $136/sq ft. Not as bad as $226/sq ft, but I would tend to think that the county's assessed value would have been more fair at $107/sq ft. The county now assesses the property at $407K.

    Regarding 302 Monte Vista it is not a fair comparison to your other listing. This is a house that was built in 1957 with 1013 sq ft of main floor living space. The fact that it even sold at $265K on 7/24/2008 is probably a testament to timing as well as an informed buyer. They were probably comparing that house with:

    117 Monte Vista which sold for $208K on 5/30/08 (smaller house)
    223 Monte Vista which sold for $309K on 3/20/08 (larger house)

    The 2009 assessment still shows it at $265K.

    My current linear regression model is only good for a short period of time (probably only a month at best) and it is only based upon sales during the last 3 months. I will be updating this regression as time goes on.

    I doubt the county/city is as complicit in trying to inflate real estate values as realtors and sellers are. And even if they were to take this approach people can count on my blog to point out overinflation of value regardless of its source! :-)

    ReplyDelete
  3. The assessment itself is a model, and judging from your graph, it too is pretty close to the mark. Thanks for an interesting analysis.

    ReplyDelete
  4. I just wanted to tell you how useful I have found this information! As a first time home searcher, I have referred back to it time and time again (as a resource) and have shared it with many! Thanks for putting it together.

    ReplyDelete
  5. i think this site is dead, not a new post in 3 months

    ReplyDelete
  6. Great analysis !! I am wondering if you are going to post a repeat analysis for this year ? Willing to help with the analysis.

    ReplyDelete
  7. He said nexttime he came over he would bring the nipple clamps for me plussome other sexy toys he had. I then pay thebill and we move from the eating side of the bar to the barstools.
    free adult movies stories
    free sex stories about fucking animals
    stories of bondage free
    old gay sex stories
    free young taboo sex stories
    He said nexttime he came over he would bring the nipple clamps for me plussome other sexy toys he had. I then pay thebill and we move from the eating side of the bar to the barstools.

    ReplyDelete
  8. A rat . Hegets a serious look on his face and says Ill do this one for free.
    incest and bestiality stories
    free hot kinky sex stories
    girls having sex with dog stories
    sexy exrotic stories
    rape stories free
    A rat . Hegets a serious look on his face and says Ill do this one for free.

    ReplyDelete