When we track our net worth, one of the line items is the value of our home. We keep it as an offset against the mortgage, otherwise our net worth would be lopsided.
One of the challenges with home values is that it's difficult to mark them to the market. “Mark to market” just means assigning a value based on what the market has determined is the true price. It's easy when you have a public company's stock – it gets traded all the time every day on the public markets. If you want to know the price of Apple stock, look up APPL.
Homes are not. You have comparables, which I feel is a thing people make up for appraisals because it's better than nothing, but those aren't truly accurate. Even if you live in a condo with identical units, there is enough variance that it's not accurate. Is a 2 bedroom, 1 bathroom on the first floor the same as the same bed/bath on the top floor? How much is the top floor worth? Too much variance.
My solution to our tracking is to set the home value at the purchase price and leave it at that forever. I like it because it's simple and I don't care about home value when it comes to our net worth (sadly, this is quite uncommon since most of American's net worth is locked in home equity).
If you aren't too keen on that, what are some other ways?
Table of Contents
Use an Actual Appraisal
There may come a time when we need a home appraisal, perhaps for a home equity loan or line of credit. In the event we do, I'll treat that as an accurate home valuation and adjust our home value in the spreadsheet.
For what it's worth, if we get an “professional” appraisal, I would adjust our home value to this.
Use Tax Assessments
It's what the tax man uses to assess property taxes, it seems reasonable to use this to value your home.
The tricky part with this figure is that you may try to decrease it, to lower your tax burden, and that might mean it's value is lower than what it would sell for. If you're OK with this discrepency, this seems like a fine way to fake a “mark to market” every few years.
Use Historic Median Home Price Growth Rates
Historic data from the U.S. Census has shown that median home prices don't rise all that quickly.
In 1940, the median price of a home was $2,938. (these figures have NOT been adjusted for inflation)
In 2000, the median price of a home was $119,600.
That's an annual growth rate of about 6.37%. (if adjusted for inflation, the growth rate is a mere 2.3%)
You could get more specific to the state level – for Maryland that's a growth rate of 6.67%. (it's even lower if you just look from 1990-2000, the growth rate is a mere 2.28%)
Set the growth rate to 6% per annum, so you have a little buffer, and then leave it alone.
I love hearing stories of people buying homes in 1980 for $30,000 and then selling them 20 years later for a tidy sum. The numbers get big because everything gets big over 20 years. $30,000 in January 1980 is the equivalent of $65,000 in January 2000. (the accurate way to think about it is that over those 20 years, the purchasing power of a dollar was cut in half)
What is the inflation figure we should use? I think CPI-U (inflation for all urban consumers, it's all items except food and energy) is probably the best bet and you can get the figures from the BLS.
The numbers for each month is not monthly inflation, it's inflation for the previous 12 months through that month. So September 2017 showing 1.7% indicates that when you include September, inflation for the previous 12 months was 1.7%.
If I were to use this, I'd look at the inflation figure for December of each year, adjust my home value once a year and call it a day.
Use Home Price Tools to Check
There are a ton of tools you can use to get a free online home appraisal. Since you're doing this for tracking purposes, I would not waste money on this.
As for accuracy, it's hard to say. Make sure the information they have on your home is accurate – including but not limited to square feet, bedrooms, bathrooms, and age of the home.
We purchased our home four years ago so the “accuracy” will simply be a percentage value away from our home value. Oddly, our home didn't appear in a lot of these tools so there won't be an accuracy figure.
Here are some of the more popular free home appraisal tools I found (with some caveats and warnings):
- Zillow – They're one of the biggest real estate sites and they offer a Zestimate, which is an estimate for your home's value. You can sign up for an account, claim a home, and they'll email you updates if their Zestimate changes. (Accuracy 2.4%)
- Redfin – Redfin is both a real estate research site and a brokerage, but when you claim your home you can get an estimate of home value based on your home's characteristics.
- Realtor.com – Unlike the other sites, which are geared towards homes, realtor.com has the home search, estimates, and whatnot; but also articles and videos related to real estate. They have a home estimate tool on their site, which doesn't require you to sign in or claim a home to see a home estimate. Sadly, our home was not listed (which is weird, all of our neighbors are listed).
- eepraisal.com – They will pull data from a variety of sources, including Zillow's Zestimate, to make a determination. Their tool shows neighboring sales in a convenient way. They did not have an eppraisal.com estimate for our home.
- Trulia – Trulia is similar to Zillow in its design and purpose but it does not offer an estimate of home value.
- Chase Home Value Estimator – Enter your address, click Get Value, and get an estimate straight from Chase. I can't tell what data powers this tool but for my address there was no estimate. I pulled up an estimate for our previous home and it seemed within reasonable range.
- ReMax – As a broker, ReMax probably wants to sell your house but you can use their tool anyway. Sadly, our address is not listed for some reason. The tool is easy to use, includes a nice Google Map. and you can fly around your neighborhood sneaking a peek into your neighbor's financial windows.
- HomeGain (do not use this tool) – I stopped the process of getting a home value estimate because it required my name, phone number, and email to be sent to AgentHomeValues.com – I didn't want an “expert agent” to give me a “detailed market analysis.” I would skip these guys.
If I were to do this, I'd just pick Zillow and normalize the figure to my purchase price in year one and take the adjustments. So if I bought a house for $100,000 and Zillow said it was worth $50,000 – I'd double Zillow's Zestimate from now until eternity.
How do you handle your home's value in net worth tracking?