Tuesday, February 28, 2012

Reality-Checking the Reassessments: Part 2

This article is part of a series examining how Mt. Lebanon is likely to be affected by the recent county-wide reassessment. For other articles in the series, see Blog-Lebo’s Reassessment Series. —Tom

In our previous article, Reality-Checking the Reassessments, we compared the new assessments to recent residential property sales in Mt. Lebanon to see if we could learn whether they fairly represented actual market prices. Taken as a whole, they seemed reasonable (“not horrible” was the technical term I used), but for many individual properties, they seemed far from reality. Also, it seemed that less-expensive properties tended to be overassessed and more-expensive properties underassessed. So there seems to be some cause for grumbling.

Now we perform a second reality-check: Do the new assessments do better than the old assessments? (Recall that the motivation for the new assessments was to remedy the inequities of the old assessments.) To help answer this question, we return to our data set of recent Mt. Lebanon residential property sales (courtesy UCSUR) and compare recent sales to the new assessments. But this time, we also compare them to the old assessments, to see whether new or old are closer to the actual market.

The easiest way to see how new compares to old is, well, to see how they compare. So here’s another statistical plot, much like the plot from our previous article, but this time with two dots for each home sold in Mt. Lebanon in 2010 or 2011. Take a look and then I’ll explain more below.


(Click image for a printable high-resolution version in PDF format.)

Here’s what’s going on. For every home sold in Mt. Lebanon, there are two dots, one red and one blue, connected by a horizontal gray line. The vertical position of that line gives the home’s actual sales price. The horizontal positions of the dots give the old and new assessed values of the same home. The red dot represents the old assessment; the blue, the new assessment. You can think of a house’s assessed value as having “traveled” along the horizontal line from the red dot (old) to the blue dot (new). The question, then, is whether they traveled toward (or away from) fair-market prices.

To help answer that question, we have added a 45-degree reference line to show where the assessed values would line up if they perfectly reflected market prices, as estimated by our recent sales data. To the extent that a home is underassessed, it will appear to the left of this line; to the extent it is overassessed, to the right. The actual market is a bit of a moving target, so we won’t worry too much about assessments near the reference line, just those far from it.

So what can we see? First, the blue dots are almost always to the right of the red dots. That means that most of the homes had their assessments increase. And that’s what we would expect, given that property values have generally increased since the old assessments took place. So far, so good.

Second, the blue dots are closer to the 45-degree reference line than the red dots. That means the new assessments are closer to actual market prices than the old. In other words, the new assessments seem to be closer to reality than the old assessments. That’s a clear improvement.

Okay. So the new assessments are truer.

But are they fairer? We’ll look into that question next time.

Until then, comments are open. Let us know your thoughts.

Labels: , , , , ,

Bookmark and Share

25 Comments:

Blogger John said...

Great posts, this is very helpful information.
We bought our house in May 2011, so our house is in the dataset of recently sold houses. How much of the reassessment is based on the recent sales price? I am wondering whether there is a systematic bias in which houses that have been sold in the past 5-10 years are assessed for higher values than houses that have not been sold.
I'd be interested in seeing a plot of old value vs. new value, with points colored by whether they had been sold in the past 5 years.
John Brehm

February 28, 2012 10:17 AM  
Blogger Tom Moertel said...

John, I don't have sales data for the last 5 years, only 2010 and 2011. But if you can live with a plot that only considers those sales, here you go: New vs. Old assessments colored by recent sales.

February 28, 2012 12:13 PM  
Anonymous Anonymous said...

Tom,
Thanks for another interesting snapshot. Aside from what may show about the new assessments, at a glance the old assessments look less consistent among themselves. Even without your reference line on the last plot of 2013 assessments, the eye could fill in a line just above and to the left of where the reference line is because there was a visible density in the dots. In looking at the red dots above, no such line jumps out, or what could be a line is certainly less definite. Is there another reason for that other than less uniform or consistent 2012 values in the various price ranges? It's such a small group of properties since it only includes sales from 2010 and 2011.
Lisa Brown

February 28, 2012 9:57 PM  
Anonymous Anonymous said...

Tom,
Not sure if my last question was clear. Would we need to look at a set of properties that sold similarly close to the last assessments (2000 or 2001, I guess) and compare those sales to 2012 assessments to see such a clear line? Is the clarity of the line created by the density of dots in the 2013 plot just because the sales relate better to these assessment numbers?
Lisa Brown

February 28, 2012 10:12 PM  
Blogger PittByrne said...

This is an extremely insightful series. Thank you, Tom.

The New vs Old assessment plot is very useful since it gives a quick sense of the range of new assessment values for groups of properties that had been similarly assessed.

Steve Byrne

February 28, 2012 10:24 PM  
Anonymous Anonymous said...

Tom,

Why does the data stop at $500,000?

-John Kendrick

February 29, 2012 5:39 PM  
Blogger Tom Moertel said...

John, as I mentioned in the previous article, I limited the sales "reality check" to residential properties between $50K and $500K, which accounts for about 95% of Mt. Lebanon.

I did this for two reasons. First, to eliminate outliers like the $1 "fair-market prices" that would have been suggested by in-family transactions.

Second, to focus the plot on the action. Including the few properties outside of that range causes the bulk of properties to be squished into the lower-left quadrant, making them hard to see. Since that's the information most relevant to most taxpayers, I wanted to put it front and center.

But if you do want to see the whole thing, here's the equivalent plot that includes everything.

Cheers,
Tom

February 29, 2012 5:52 PM  
Anonymous Anonymous said...

Tom,

Related to above comments, and to your statement in the OP that "...new assessments are truer. But are they fairer?":

I took a look at the new assessments for the houses listed by the County as comps on my old assessment. Did not look at sale dates nor try to allow for improvement/degradation of any of this (small, very small) group of properties, which I acknowledge is sloppy, but still I did some back-of-the-napkin figuring that got me thinking.

For my house plus 4 comps, the new assessments went up by an average of 32.9%, low 21.49%, high 48.65%.

The old comps' highest value was about 5% over the lowest value, whereas the highest new value is about 20% higher than the lowest new value.

This may be part of Part 3 of your series, but I wonder: setting aside the relationship between what I actually paid in 2005 and the re-assessed value (which seems pretty good, BTW), shouldn't/wouldn't I also expect that my erstwhile comps would stay clustered a bit more than they seem to have? Or is it "That was then, this is now," and old comps are utterly useless?

Maybe the spreads I've noticed are reasonable, or at least not unreasonable, but others might have noticed similar things and have similar questions.

Thanks very much for all this, it's really terrific.

Brian Auer

February 29, 2012 6:03 PM  
Anonymous Anonymous said...

Hi Tom,

I put some street addresses on Osage into the Co Real Estate website, and I am noticing that the assessed values in 2012 have declined, but when I examine your graphic, I don't see very many lines that indicate a decline in assessed values.

Do you notice the same thing? How did you validate your scripts? Did you run a set of test data?

-John Kendrick

February 29, 2012 6:05 PM  
Blogger Tom Moertel said...

John,

For my "reality-check" data set, which includes 862 residential sales in 2010 and 2011, there were 31 properties whose assessments declined. For the expanded data set not limited to $50 to $500 thousand, it's a ratio of 53 : 1131.

If you would like to double-check any of my analysis or conclusions, feel free. I've linked to all the data in the main articles.

Cheers,
Tom

February 29, 2012 6:16 PM  
Anonymous Anonymous said...

Thank you - so just as a point of clarification, this data set does not show ALL of the homes that were reassessed, only SOME of the homes that were reassessed.

This data set only shows the new assessed values of the homes that were sold in 2010 and 2011. So, for instance, if a home was on Osage and was sold in 2009, or 2006 and the assessed value declined then it would not be present in this data.

Thank you for providing clarity.

-John Kendrick

February 29, 2012 6:25 PM  
Blogger Tom Moertel said...

John, that's right. But to clarify the clarification, this data set which is graphed in this article is limited to recent residential sales. But the data set in our previous article, Making Sense of the New Assessments: Winners and Losers, I believe to cover almost all properties in Mt. Lebanon.

Cheers,
Tom

February 29, 2012 6:31 PM  
Anonymous Anonymous said...

Tom,

When I look at the color-coded map it looks like only some of the properties have changed color. When I enter addresses on Osage, for example, I see that there is a consistent decline; but the visualized result on the map only has a few properties on Osage that are not colored the same as the Google map.

Does this indicate that the taxes for those homes are not changing even if their assessed values declined?

-John Kendrick

February 29, 2012 6:50 PM  
Blogger Tom Moertel said...

John, which map are you looking at? The "reality check" map from the previous post, or the "winners and losers" map from the original article in the series? When I check out Osage on the original property-tax winners and losers map, it looks like most of the properties are colored in the blues, representing lower property taxes under the new assessments. If you click on any property, details will pop up and you can see not only the old and new assessments but my predicted change in property taxes for the property. (Let me know if you see anything that doesn't match up with your expectations.)

Cheers,
Tom

February 29, 2012 6:59 PM  
Anonymous Anonymous said...

Hi Tom,

I don't have any expectations, I am only asking about your analysis.

Let's continue with Osage as an example...

The Google Map on my browser doesn't have a link for every property - only some of the properties on Osage. Should I interpret that to mean that if there is no link and no color other than the default map background, then the taxes will not be changing?

I think that someone also said that if your assesssed value increased by up to 25% then the School Tax would not increase. But does that mean that if the assessed value of a property decreased then the taxes would also not change, or is there a lowerbound (something like a 25% decline in assessed value) where the taxes do not change?

Thank you,
-John Kendrick

February 29, 2012 7:19 PM  
Blogger Tom Moertel said...

JDK, I ask again: Which map are you looking at? So far, I've published two.

The first one shows projected property-tax increases. That's the one you want to look at if you're concerned about the reassessment's effect on property taxes.

The second map shows how recently-sold residences are assessed w.r.t. their sales prices. That map is sparsely populated because the data set is sparse: only a small percentage of Mt. Lebo homes have been sold recently.

If you're seeing that most properties are not shaded and clickable, you're looking at the second map, which is the wrong map if you're interested in property taxes.

On your question at the end of your comment, if a property's assessment did not increase by more than 30%, which is the overall assessment increase in Mt. Lebanon, then its taxes will decrease. An assessment decrease, being a "negative" increase and therefore an increase of less than 30%, has the same effect: it will result in a decline in property taxes (by a lot).

Here's the formula:

(new taxes) = (old taxes) * (new assessment) / (1.3 * old assessment)

where 1.3 represents the community-wide anti-windfall adjustment.

Cheers,
Tom

February 29, 2012 7:34 PM  
Anonymous Anonymous said...

Hi Tom,

This is interesting...

So, if I understand you correctly, then there is a "band" within which the school district taxes will not change. Again, if I understand you correctly, you are saying that there is essentially a pivot point or fulcrum that balances a seesaw. Am I understanding you correctly?

-John Kendrick

February 29, 2012 7:41 PM  
Blogger Tom Moertel said...

JDK, in effect, yes.

The tax revenue collected before and after reassessment must be about the same, so if the total assessment community wide is now X times what it used to be, the new tax rate must adjusted to 1/X times what it used to be.

For an individual property, if its new assessment is Y times its old, its new tax burden will be Y/X. So when Y is nearly X, the property's taxes won't change much. Hence the "band" you described.

Cheers,
Tom

February 29, 2012 7:54 PM  
Anonymous Anonymous said...

Hi Tom,

Now this... this is very, very interesting.... muy interesante...

Interesting because if your model and our interpretation is correct then it would mean that a net decline in revenue from reassessed property values of the more expensive homes and at the same time an increase in the assessed value of the lower and lowest priced homes could have the effect of having the wealthier residents paying less in taxes while those in the lowest income groups pay more in taxes at the same time. Wouldn't it be interesting to test this hypothesis? Becasue, if this hypothesis is true, then our school district and other taxing bodies would have enacted a policy of shifting the tax burden from rich to poor - and perhaps (and I emphasize perhaps) this could result in gentrification, right?

Do you think that when the Board comtemplated generating additional revenues from: (1) reassessment and (2) an increase in the milage that they considered the possibility that some elderly and disadvantaged individuals could be driven from their homes? - and I am not even thinking about looking at equity from the perspective of the proportion of income (at least not in this discussion anyway)... ;)

WOW! Now I am really looking forward to your next article in this series.

Thank you for sharing your model with me Tom.

Please carry on, and good night.

-John Kendrick

February 29, 2012 8:07 PM  
Anonymous Richard Gideon said...

Mr. Kendrick:
If you don't mind, I'd like to address your question to Mr. Moertel concerning whether the MLSB "..considered the possibility that some elderly and disadvantaged individuals could be driven from their homes?" It is entirely possible that board members discussed this amongst themselves; but the Board's focus is on the new high school, and "the ends justify the means." I doubt the majority of Board members will lose any sleep over anyone in Mt. Lebanon losing his or her home - as long as it does not take too long to replace the hapless owner with one more "qualified" to live in Mt. Lebanon. Frankly, given the geographic and housing limitations of the Municipality, it benefits both the District and the Municipality to cull as many retired people as possible from this town, replacing them with younger, richer, and fertile families.

Using 2011 figures, a family of four with a total income of $75,000 and a home assessed at $227,000 paid just shy of 11% of its gross income in total property taxes, with the largest share going to the District. A similarly possessed family, but with a total income of $50,000, paid 16.38% of its gross in property taxes. Keep in mind these percentages are calculated against the GROSS; in real life real estate taxes are paid out of NET earnings (or take-home pay), making the disparity even greater.

It is because of this disconnect between what non-productive, residential property is actually worth (which may only be accurately determined by a sale), and the means by which the real estate tax is paid (net income from a salary or profit), that many people think the real estate tax is an anachronism and needs to go - and those people are correct.

March 01, 2012 9:12 AM  
Anonymous Anonymous said...

Mr. Gideon,

Very well put. I think that part of the problem is that many Board members do not have a deep respect for the right of Mt Lebanon residents to own private property. Instead, they have a "communial" perspective that sees the rights of the government above the rights of the residents.

I hope that you will consider running for the next elected office. You frequently offer very interesting perspectives. ;)

-John Kendrick

March 01, 2012 10:44 AM  
Anonymous Anonymous said...

Tom,
Perhaps you would consider using Mr. Gideon's comment (if he doesn't mind) to start a separate article or thread in which people could discuss whether or not property taxes (even if done with relatively accurate property assessments) are the right way to generate this revenue. Such a dialogue has been popping in and out among the comments in your series but it might be nice to see it all in one place. If the court issues and political wrangling on property taxes in Allegheny County bring the issue to a head, could a fundamental change the method of taxation occur at the state and local levels?
Lisa Brown

March 01, 2012 11:45 AM  
Anonymous Anonymous said...

The new school is being built...we're going to get the building...

Right now there is a plan/framework/set of laws that outline who will get the bill.

But as for who will ULTIMATELY pay for it - that part, tax policy, can always be changed...

-and contrary to the professor's perspective, one of the great successes of the Reagan presidency was that he showed our counrty that anything is possible.

Right Chris?

8)

-John Kendrick

March 01, 2012 12:56 PM  
Anonymous Richard Gideon said...

Mr. Kendrick:
Your suggestion that I run for public office is very flattering and I thank you for it, but I have no interest in doing so.

Ms. Brown:
I believe Mr. Moertel is going to start a thread about the "fairness" of the property tax assessment system, and that may be an appropriate place to discuss alternatives to the residential real estate tax. I agree with your observation that the courts and politicians could be bringing this issue into more productive light - time will tell.

March 02, 2012 11:21 AM  
Blogger James Fraasch said...

Tom

I think for the last piece of this to fit (at least for me) we need to see at what levels reassessments tend to reflect market value more accurately. So what I propose is breaking homes into 2 sections to start (add more if you wish) and those sections would be from $0-$250,000 and $250,001-$1,000,000 or perhaps you could exlude the +$500k and the less than $50k like you have before.

What we would need to see is the collective deviation from market value of the new assessment.

The goal of course is to prove or disprove the hypothesis that this reassessment is affecting middle/working class priced homes more than it is impacting those in higher priced home.

Thanks.

James

March 03, 2012 6:39 PM  

Post a Comment

<< Home