I just fielded a call from a potential client who was curious about how an appraiser would go about extracting an adjustment from the market, in this case specifically basement finish. In the discussion I explained that there is no factor that appraisers use, but that we turn to the market to try and show us what buyers are paying. Because different markets can act quite differently, I thought putting up a couple of examples of this type of extraction might be useful, both to my potential client, as well as my audience in general. The following show two different examples of an extraction for basement finish, one in Ann Arbor related to a generally newer house in the $400,000 or so price range, and the other in Lincoln school district in the under $200,000 price range. Both use the same methodology and both show substantial differences in final results, which is why an appraiser cannot just provide a number. Instead the appraiser has to look at the market. The first sample I went back two years and narrowed my market data to houses between 2000 and 3000 sqft, built between 1990-2010 on the west side of Ann Arbor (used areas 82, 83, and 84) and then downloaded all these sales to Excel and segmented the sales between houses with finished basements and without. The results were 37 sales without finished basements and 62 identified with finished basements. I looked at median and average sales price differences and median and average amount of basement finish, and came up with between $21,647 and $24,500 difference in price favoring those with the basement finish, and between $24.24 per sqft and $27.75 per sqft of basement finish. This provided me with some support for my adjustment. I don’t recall what my adjustment was, but I think anywhere between $20,000 and $25,000 is supported based on this data. That and in my experience, basements in this area cost about $40 per sqft to actually finish. Here is what it looks like on a spreadsheet: The next example is using sales in the Lincoln school district, and in this one my isolated properties were between 1,200 – 1,700 sqft in size and built between 1985-2010, also going back two years. I had 48 sales without basement finish and 36 with basement finish, and the median difference in price was $8,953 and the average price difference was $14,420. The median size of finish was 625 sqft and the average size of finish was 703 sqft, supporting adjustments per sqft of $14.32 to $20.51. As you can see, there are differences in price between the areas and the sizes, as would be expected. Cost remains about the same to complete. Each appraisal may be different, and the numbers found here in these two samples could change depending on how far back the appraiser goes on their data research and what they set as the perimeters for the data search. I offer this to you, my readers, as a simple study showing how I often go about trying to extract an adjustment from the market. A final word of caution; I would not expect to see an appraiser put this analysis into their appraisal. They will likely do it, and say something in the report about the adjustment being analyzed through market data. This is what they likely mean, but won’t put the actual results into the report, instead they will have it in their files, be it in the office in general, or specific to an appraisal they were working on. Hope you all enjoyed this simple explanation, and if you have questions about appraisals and appraisal processes, please feel free to contact me. Easiest way to reach me is via email at rach mass at comcast dot net.
Rachel Massey, SRA, AI-RRS
Woody Fincham, SRA
Tim Andersen,MAI, Msc., CDEI, MAA
Originally published at http://www.appraisalbuzz.com/depreciated-cost-test-reasonableness/
With all of the clamor and excitement that Fannie Mae’s Collateral Underwriter (CU) is creating, we started working on a new article that addresses some possible solutions. In this one, we are expanding a bit on using the cost approach as a means to develop and support some adjustments. Each of the three traditional approaches to value can be used to develop a basis of analysis in any of the approaches. As such, the cost approach can be a reliable means to develop a gross living area adjustment, or lend additional support for it. While it does not work each time, has proven successful for us many times, and as such, we do urge studying it and putting it into your toolbox of solutions for supporting adjustments.
Quantitative adjustments require some type of support. CU is not changing anything regarding this premise. Appraisers are supposed to have support within the workfile for adjustments made, and then support the adjustments with commentary within the report. This is in harmony with USPAP. Many appraisers do not address specifics on the adjustments made, let alone explain how they were developed and applied. So here is one method that can be relied on as a means to support a gross living area (GLA) adjustment. Sometimes it can be used for other items.
One aspect of Collateral Underwriter (CU) that many have been discussing concerns price/SF. In the example from the CU webinar, it is stated that if an appraiser is using $15/SF for adjustments regarding gross living area (GLA) adjustments and the comparables sales indicate $200-$300/SF, then it will be probably be flagged as a higher-risk item. So part of the advantage of using this technique will help you address this with analysis. Let us look at some improved sales now that we have an idea of what site values are for the market
|Comp 1||Comp 2||Comp 3||Comp 4|
|Price||$ 308,300||$ 300,000||$ 295,000||$ 283,000|
|$/SF||$ 127.71||$ 129.98||$ 119.53||$ 122.51|
In this data set, we have four sales. The range of price/SF is $119.53 to $129.98. The problem with price/SF is that it deals with all attributes of the property. This can be problematic because it is inclusive of the land, which can skew the usefulness of using it as a unit of comparison. Once we get part way through this article, we will start discussing residual improvement value (RIV). RIV can be an effective defense against overall price per square foot concerns.
Simple Depreciated Cost
We are going to walk through a case study of a file that Rachel worked on recently. Obviously, some things have been changed. Some of you will notice that the data set is anything but like what we all normally see in classroom case studies. Hardly ever do we see perfect sets of data like what often seen in most case studies in an educational offering. With that said, this may not be something to use if you are starting newly in the profession. This article is written with an experienced residential appraiser in mind.
Depreciated cost can be a test of reasonableness for some adjustments, and here it is used as a basis for the gross living area adjustment, tied to sensitivity analysis. It is not meant as a means of arriving at an adjustment, but instead as either a place to start, or a second or third approach. Because each of us have used it extensively we felt it would be a great place to help some of you establish a benchmark or test of reason to use for a gross living area adjustment, in particular as the example is from the real world.
Site value – you really need to get a handle on site values for using this approach (while you can use the depreciation factors to get to land values, having a grasp on site values is easier with land sales). Most communities have land sales, even if they are not in the immediate area. For example, this grouping of data presented here was for a property in Michigan and there have not been a great number of land sales in the immediate area over the past few years. There have been no land sales in the subject neighborhood. There were however, enough land sales from competing areas to provide some basis from an opinion of the value of the subject site as if vacant.
The following chart shows seven sites that sold and three acreage parcels:
|Sale||Sold date||Sold price||$ To Acquire||DOM||Size||Frontage||$/SF||$/FF|
|Comp 1 (Demo)||9/17/2014||$42,050||$51,050||673||13,068||100||$3.91||$510.50|
*Note we included a couple of acreage properties because one of the improved comparable sales was an acre property and support was needed support for a site adjustment.
In the example, we see that the smaller the lot, of course, typically the higher price per square foot (SF). This is known as increasing and decreasing returns; see definition below. While there are exceptions, this is a general rule. Comparable sale-1 is a tear down property. Because the data is actual real world data, it is not perfect as we typically see in many academic examples, but it does allow a supportable conclusion to be derived.
increasing and decreasing returns
The concept that successive increments of one or more agents of production added to fixed amounts of the other agents will enhance income (in dollars, benefits, or amenities) at an increasing rate until a maximum return is reached. Then, income will decrease until the increment to value becomes increasingly less than the value of the added agent or agents; also called law of increasing returns or law of decreasing returns.
With the data shown above, we can see that price/SF averages $4.19 and the range is $3.00 to $4.97/SF in this market. Front footage (FF) averages $548.42/FF and the range is $421.69 to $695.88/FF. By establishing an estimate of land value for the comparables used in the sales analysis, it helps to develop cost-derived adjustment.
Using comparable sale-1 as an example, the estimated cost looks like this:
|Dwelling||2,414||$ 87.85||$ 212,069.90|
|Basement||1,142||$ 22.17||$ 25,318.14|
|Basement Finished||1,000||$ 15.00||$ 15,000.00|
|Garage||504||$ 27.57||$ 13,895.28|
|Cost New Estimate||$ 114.45||$ 276,283.32|
|Sales Price||$ 308,300.00|
|Site Value||$ (55,000.00)|
|Depreciated Value of Improvements (or RIV)||$ 253,300.00|
|Minus Cost New||$ 22,983.32|
Below, we have estimated the site value and subtracted it from each of the comparable sales. The resulting unit of comparison is much better than overall price/SF. The price /SF-RIV can be used as an indicator of the highest possible reasonable adjustment for GLA. We like this as a test of reasonableness for any adjustment made for differences in gross living area. The resulting $/SF-RIV is going to be the upper limit of how much you can adjust.
|Sales||Sale Price||Land Value||RIV||GLA||$/SF-RIV|
|What about Fireplaces and Decks, etc. is this approach right for that? Decks and other items like decks and outbuildings typically depreciate at a faster rate than the house. One would try to steer away from using this methodology with such items. We still believe that this approach can be used in measuring the top end of the adjustment range, or as a test of reasonableness, but with the caveat that the rates of depreciation may vary.Depreciated cost may offer one of the only adjustments that you need at all, if your comparable sales are all very similar. It can be difficult to support adjustments for additional features like decks and fireplaces. Sometimes those types of amenities are sometimes best dealt with using qualitative reasoning. If you are looking at sales that all have similar external features, are of the same quality/condition as the subject it may not be required to adjust for them. These items are difficult to extract and may be summed up with qualitative reasoning. It will depend on what information you have learned about from the market. This is an excellent area to discuss with real estate agents and ask if such features are strong considerations by buyers. It is also important to understand how the sellers are looking at such items as well. We find that talking to both agents on a transaction can be beneficial to glean such information. In the end, if no adjustments are supportable for such amenities, the appraiser can discuss the additional amenities present for a sale and use that in the final weighting during the reconciliation of the sales comparison approach.|
We can apply these figures to the improved sales that we are using in the sales approach to get a residual improvement value (RIV). As mentioned earlier, RIV is a better indication of comparability as it allows us to compare apples to apples. It removes the land component, and other improvements not related specifically to the house itself. Just getting this far into the process with each of the comparables, and looking at the RIV/SF as a metric will assist with the concerns many are having about the CU overall price/square foot metric.
The next process is to take each sale and develop a cost approach using Marshall & Swift Residential Cost Handbook (disclaimer, huge fans here) for the appropriate quality. It is important to make adjustments for energy and foundation (bottom of the page related to the type of housing) if they apply, refinements for floor covering, heating and cooling, etc. as well as applying the quarterly multipliers to region and location. From there you should compare total cost to the depreciated remainder for an account of depreciation.
You would then do one for each of the sales in the study.
|Sales||Cost New||RIV||Total Depreciation||% Depreciated||Age||Depreciation/yr|
*Note: This type of approach utilizes all forms of depreciation. If there were cases of functional or external depreciation present for any of the comparable sales, this would need to be adjusted for as well. In this case, study, there were neither additional forms of depreciation.
This information can be valuable in terms of understanding depreciation, as well as supporting either an age or a condition adjustment (look at how sales 3 and 4, which are older houses, have much more depreciation than the newer houses overall). Since each house is depreciated between ~6 and ~15 percent, you also have supportable adjustments to make for age or condition.
You can also utilize this type of adjustment for amenities such as basements. For example, say comparable sale-1 has a finished basement that is older and not high quality. The finish costs an additional $15 per square foot rounded over and above the cost of the basement. This finish is a recreation room only and the cost new is around $15,000. The overall rate of depreciation for this property is 8.32% or $1,250(rounded). This means that logically the basement finish would now contribute about $13,750 to the property value. That may not be sufficient to stand alone, but does offer a method of support.
Additional support can be from running simple statistics such as isolating a group of sales based on some commonalities. For the following sample, we took houses in this particular market separated between houses built between 1995 and present, but excluding proposed construction. They were further narrowed to include 1,800 to 2,800 SF and no walkout basement. By doing a simple version of grouped paired analysis, we see the result was a difference between $14,843 and $15,377 between the two types, with many having bathrooms in addition to finished rooms. With an indication of $13,750 from comparable sale-1 and the paired group analysis showing a range of $14,800- $15,400, it is easy to deduce a reasonable adjustment amount.
|No Walk Out||# Sales||Avg Price||Median Price||Avg GLA||Med GLA||Avg $/SF||Median $/SF|
|1800-2800 SF Unfinished Basement||42||$340,559||$329,623||2392||2402||$142.37||$137.23|
|1800-2800 SF Finished Basement||89||$355,402||$345,000||2399||2408||$148.15||$143.27|
Completing a cost approach on each sale is a good exercise in terms of seeing cost in action, as well as testing depreciation. The greater the depreciation exhibited in the individual sales, the greater the difference in either condition or age, or a combination of both. So this methodology can also create support for other types of adjustments as well, such as the basement finish adjustment shown above. Many will say this takes a lot of time, and our answer is, “Yes, but it’s something that uses some commonsense and appeals to reasonableness”. We would also add that explaining this is much easier than trying to use regression analysis or find that elusive matched paired sales. Most appraisers can reasonably explain cost-based extractions to a jury or licensing board. It does not require much in the way of additional tools. Excel©, cost estimation software and appraisal software is all that is really needed.
Depreciated cost does work in many markets, so give it a try to see if it is something that will work for you. Use it in addition to some other methods of supporting adjustments. We consider it an excellent test of the reasonableness of both the value conclusion, and the elements of comparison within the value conclusion. We have each successfully used it in lending and non-lending work assignments.
Fannie Mae and CU are specifically going to target our size adjustments. In the past, many appraisers used “rules of thumb” as the basis for a size adjustment. As we are all now aware, rules of thumb do not work anymore because CU has the ability to calculate size adjustments from market sales data. The model above, while not based on CU’s sophisticated algorithm, also functions quite well in isolating the sales price of the improvements. Using this model, appraisers are able to isolate such differences within a reasonable range of values. Even more importantly, this range of values is market-derived, thus in full compliance with CU’s requirements. Be sure, too, to save all of these calculations in the workfile for future reference. Gone are the days when we can justify out adjustments by invoking “my 30-years of appraisal experience”. Now, we must prove our adjustments. This model is one of those proofs. Finally, what we have presented here is nothing new. This well-known method has been published in numerous books and in courses. We thought presenting a “real-world” example might be helpful in showing how even without perfect results; the results can be, nonetheless, meaningful.
 Appraisal Institute, The Dictionary of Real Estate Appraisal, 5th ed. (Chicago: Appraisal Institute, 2010)
All Three of us worked on this piece. I won’t post it in the entirety yet as it’s brand new today and should be given full look at through the publishing site. But if you happen across it here, please click through to read it.
OK, so what does the Cost approach tell appraisers (at least, those who are willing to listen) about the market? The listening is in the analytics.
Consider, first of all, the site value as if vacant. This is a separate appraisal within the appraisal. If the appraiser does not know to a professional certainty the value of the subject site as if vacant, how can that appraiser adjust the comparable sites (as if vacant) to it? It is ironic that, to adjust the comparable site’s value to that of the subject, the appraiser must know, to the same certainty, the value of the comparable site as if vacant, too. Assuming three comps and a listing, then the appraiser goes thru this site-as-if-vacant analysis five (5) times. If the appraiser is listening, an analysis five (5) sites deep will tell the appraiser an abundance about a market.
Now, consider the entrepreneurial incentive/profit aspect of the analytics of the Cost approach.
Too many appraisers have fallen into the trap of saying there is not such a profit or incentive in the cost approach since the sale of the property is from one retail buyer to another. It is not a sale from a builder/developer to a retail buyer. This is true. It is true, yet it is also thunderously irrelevant. An appraiser builds the house new on paper. Don’t new houses sell (hopefully!) at a profit from the developer/builder to a retail user? Since it is physically impossible to construct a used house, the analytics of the Cost approach assume a new house first. Therefore to estimate the reproduction or replacement cost new of a house and not include an entrepreneurial incentive or profit is to fail to take a step the market commonly takes. How reflective of the market is that?
For grins and giggles, assume a 15% entrepreneurial incentive to the cost new before any depreciation. This is a trail balloon the appraiser floats to see if there is such a reward in the market. If the market will not pay such a reward there is, by definition, an external obsolescence factor in the market. This is a market condition which the appraiser has an obligation to describe within the report. Yet, if the appraiser is not willing to measure the market to see if such a reward is present, how can s/he report it? The analytics of the Cost approach show if such a reward is present. The analytics of the Sales Comparison approach do not and cannot.
A blog such as this one is not the time or place to present a long article on calculating depreciation. The point is that while FannieMae, et al, no longer require a Cost approach to be part of an appraisal report going to them, whoever said the analytics of the Cost approach should not be part of an appraisal? FannieMae surely did not. How can an appraiser listen to, and then interpret the market, if s/he ignores two-thirds (Cost and Income approaches) of what it says?
Given there have not been all that many flat residential real estate markets in the past 10-years, how market-accurate, then, are the published tables? SR2-3 requires appraisers to certify to the fact that the statements of facts in an appraisal report are both true and correct. If there have been essentially no flat markets in the last 10-years, how can we certify our depreciation is both true and correct if the published depreciation tables are based on a flat market? If markets are dynamic, but the published tables assume a flat market, how accurate are they?
Another issue with the published tables is their self-recognized inability to speak to the appraiser about functional obsolescence and external or locational obsolescence. Appraisers know there are three components to accrued depreciation. Yet they depend on the published tables to conclude as to all three of depreciation’s components. These tables do not and cannot estimate the latter two forms of depreciation. In addition, it is a logical fallacy to assume a property has only one form of depreciation (even, sometimes, in a new one).
The Comment to SR1-3(a) is very clear about unsupported assumptions. If the appraiser does not engage in the analytics of the Cost approach, how is the appraiser sure there is no functional obsolescence? If the appraiser does not engage in the analytics of the Cost approach, how is the appraiser sure there is no external or locational obsolescence? If the appraiser does not engage in the analytics of the Cost approach, how can the appraiser certify that everything in the Cost Approach is both true and correct? Falling rents and/or falling multipliers may indicate the presence of these other two components of accrued depreciation. However, how many appraisers, via the residential income approach, go to the effort to read the market’s tea-leaves?
To professional appraisers, then, the issue is to extract accrued deprecation from market data. Published tables may be a help with depreciation’s age-life component, true. But they cannot aid the appraiser with conclusions as to functional or locational/external obsolescence. These tables simply cannot calculate them; the appraiser must extract them from the market evidence. Yet, unfortunately, many do not. And, equally unfortunately, many appraisers do not understand when, where, and how to account for an entrepreneurial profit/incentive. Because of this lack of competency, therefore, many appraisers do not understand the market since they are unable to listen to it.