• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

"Sample" Appraisal: Subjective Value Containment Approach

Status
Not open for further replies.
So what? At the time of sale it was R1.
I highly doubt that. I saw the street pics for that block. This parcel is 2 doors west of that site - AWAY from San Francisco Ave, which also has some older existing multifamily on it. This building wasn't built in the last 36 months.

168.JPG

Why don't you just admit that you didn't really look at these land sales? Because if you had you wouldn't have cited this one as any type of comparable to your site. You basically put a bunch of unqualified garbage into that "valuation engineering" model which then proceeded to spit a number out which is just as likely to be unreasonable as reasonable. No better than a coin toss

Would you really have appraised a vacant site on Hibbert Ct using these protocols and this model?
 
Last edited:
Well the first umpteen pages are very thorough but are they needed for the intended user? Does the intended user really need all of this? They certainly don't expect it. That is more detail than I put in a commercial report.

Your effective date has been redacted but I am going to assume 2015 or 2016 since those are the latest land sales included. How is a land sale from 2000 or 2009 pertinent to the effective date?

In the land value section you give 18 sales from 2000-2018 and then with nothing else tell me a land value of $345,000? This section doesn't tell me how you got there. I am going to assume it is far later in the report? Wouldn't a column telling the reader the $/SF for the land sales be useful information?

In the lease comparable table I would (as an appraiser) like to see $/SF for the leased properties. It tells a lot more story than the table included.

Are we comparing apples to apples here? Two of your rent comps are 2,100 SF while others are about 1,000 SF. We have only 18 data points with significant size differences and an R2 of ~0.70.

A cap rate was used similar to apartment buildings? I am not sure I buy that and your peers do not use cap rates for residential properties but rather GRMs. Maybe the GRM analysis comes later. Is it not typical for landlords to pay water/sewer and trash? If so that would be an added expense.

I like Figure 23 on page 50.

On page 77 it appears you are implying an adjustment of $70/SF for difference in GLA yet the total cost new of the improvements is only ~$130/SF (for the house).

The hardwood only feature indicates that my house with 50% hardwood is worth $10,000 more when the total cost new is only $130/SF and the depreciated value is ~50% of that.

The difference in one bathroom vs. two bathrooms is ~$18,000? That is higher than cost new for a bathroom.

I like the interior photos of the comps in the report. We do that for all of our reports.

You use a lot of subjective interpretations throughout the report.

I got to page 82 of the report and from the beginning I didn't buy any of this. Then I saw a $1,484 adjustment for a ~$800,000 property in your grid. $2k is 0.00025% of the property value. Appraisers are not that good and this is based on a regression model with a ~0.7 R2.

I couldn't quit reading this. So we have a cost approach value of $400,000, an Income Approach Value of $500,000 and a SCA value in the $800,000 range.

Houston, we have a serious problem here. When one approach is 50% of another approach one of them was completed completely wrong (actually two in this case).

If the land value is $345,000 (I don't buy that either as there is nothing telling me how you got there) and the value of the home by the SCA is ~$800,000 then the improvements have a contributory value of $455,000 or ~$529/SF which is more than three times your cost of the improvements NEW.

Your income approach is not even remotely reliable. Using a GRM of 200 ($3,600/month rent) would be a value of $720,000. Your cost approach does not take into account EI which in my world is 20% but even that doesn't help your valuation although it does push the cost approach to $480,000.

Your ten sales, adjusted (from the grid), tell us that your value is somewhere between $747,000 and $806,000 but it takes you 150 pages to give us completely unsupported analysis for two approaches and you make a $1,454 adjustment for an $800,000 property. I find the whole thing to be hogwash.
I am kinda impressed with the flow of data so I decided to try and recreate it the old fashioned way and also through the eyes of a real market participant. I went to the MLS and searched all 800 Sq.Ft to 1,000 Sq.Ft homes and ended up with about 8 closed sales. The years built were 1956 to 1967-The average lot size was between 4,600 to 5,500 Sq.Ft. All of the sales appeared to be basic builder stock quality similar to a Fannie Q4 rating. My four most similar sized homes were 800 to 840 Sq.Ft and 2 bedroom & 1 bath models. The larger models were 920 to 1,080 Sq.Ft.

The old fashioned results: No regression method ( Note all the comparable sale's had updated kitchens and baths and based on MLS interior photos all were in good condition or a Fannie C-3- Based on the OP'S description the subject was dated and probably rated as Average or C-4 Fannie.

1- My adjusted sales range was between $790,000 to $802,000 with a weighted average of $798,592. The market trend back then appears to have been slightly positive with almost all closed sales and listings with green arrows. If this was a desk top report and using the information provided my final opinion of value would have been $795,000 to $800,000. I do not want to beat up on Bert's regression or the other analytical tools he uses but I did not find most of the adjustments to be credible or supportable and both the cost and income approaches were way off.



My conclusions : On Bert's-Nuclear Powered Flux-Capacitor Super Regression Machine.

1- The sales comparison approach at $800,000 is supported - Although it' results would have almost been the same if he had taken-ten similar sized 800 to 900 square foot comparables, totaled the prices and simply divided them. I actually tried it and I magically arrived at a value of $812,000.

2- The cost approach was not even close and based on my research of lot small lot sales in that City I was seeing $500,000 to $550,000 just for the lot. I did my own cost approach and using a site value of $500,000 I arrived at about $782,000.

3- The income approach was not credible or supported because I did a rental survey. I won't argue with Bert's estimated rents although I have my doubts. Anyway I used his rents and a typical GRM up there is normally between 220 to 222- I used 220 as my multiplier and arrived at $792,000. I have no idea why Bert used a Capitalization Rate because its not a traditional or recognized method on residential properties, and that may have been one reason the income approach was so out of wack.

4- Adjustment issues :
I am not going to try and micro manage his or anyone else's adjustments but I believe his regression and data pool may be so large that on a small 800 square foot home the machine is confused and coming up with adjustments that are not market supported. A $1,400 separate line item adjustment on a $800,000 home is just not how buyers or sellers act in a real market. In my opinion even using a percentage based system it would be very rare that I used anything less than 1% and often that would be on a cost to cure or repair item.

5- The bottom line is the appraiser may need to consider that a typical reader or user is not going to read this report and they will go directly to the value based on the Sales Comparison Approach. If it was reviewed by a peer group of MAI or SRA'S they would not be able to replicate it, and therefore most likely they would reject it as nothing more than a poorly programmed AVM. Even if these type of reports are used only for private assignments, who wants or needs this much data on a stupid 800 Sq.Ft. California Bungalow.

Funny : This kinda gives me flashbacks to 1979 when my father and I were going to pour a patio, I had framed and poured quite a few sidewalks, driveways and patios, and so I knew what I was doing. My father had a PHD in both engineering and mathematics. Anyway I am framing the patio and he comes over and says is 4" inches going to be thick enough ? I respond yes it will- He then pulls out his stupid HP scientific calculator and asks me how much weight it will hold ? I respond with I have no idea and I don't care. He then says wow I think it will hold X-thousands of pounds- I yell at him that we are not gong to drive a freaking truck across it !- He was highly offended and walked back into the house, we did not talk for three days and then he lectured me on why I needed to be more detail oriented, I kinda feel that way about Bert's regression machine, Hey Bert we are just appraising a stupid little house were even the most goofy Realtor could arrive at a value just by looking at three or four recent sales.
 
Meh, the two sales in his analysis that actually had a 2bd/1ba count sold for $750k and $780k, and both look to be at least a little superior in condition. If I'm doing a qualitative analysis I'm probably ranking the subject inferior to both of them.

Sometimes a cigar is just a cigar.
 
I am kinda impressed with the flow of data so I decided to try and recreate it the old fashioned way and also through the eyes of a real market participant. I went to the MLS and searched all 800 Sq.Ft to 1,000 Sq.Ft homes and ended up with about 8 closed sales. The years built were 1956 to 1967-The average lot size was between 4,600 to 5,500 Sq.Ft. All of the sales appeared to be basic builder stock quality similar to a Fannie Q4 rating. My four most similar sized homes were 800 to 840 Sq.Ft and 2 bedroom & 1 bath models. The larger models were 920 to 1,080 Sq.Ft.

The old fashioned results: No regression method ( Note all the comparable sale's had updated kitchens and baths and based on MLS interior photos all were in good condition or a Fannie C-3- Based on the OP'S description the subject was dated and probably rated as Average or C-4 Fannie.

1- My adjusted sales range was between $790,000 to $802,000 with a weighted average of $798,592. The market trend back then appears to have been slightly positive with almost all closed sales and listings with green arrows. If this was a desk top report and using the information provided my final opinion of value would have been $795,000 to $800,000. I do not want to beat up on Bert's regression or the other analytical tools he uses but I did not find most of the adjustments to be credible or supportable and both the cost and income approaches were way off.

You don't have the effective date of my appraisal. So, your comparisons are worthless!!!!! This is so basic!

My conclusions : On Bert's-Nuclear Powered Flux-Capacitor Super Regression Machine.

1- The sales comparison approach at $800,000 is supported - Although it' results would have almost been the same if he had taken-ten similar sized 800 to 900 square foot comparables, totaled the prices and simply divided them. I actually tried it and I magically arrived at a value of $812,000.

My model can be used with almost all of the home in the neighborhood under 1200sf GLA. My method of scoring for subjective values is also set up to be easily applied to any house.

2- The cost approach was not even close and based on my research of lot small lot sales in that City I was seeing $500,000 to $550,000 just for the lot. I did my own cost approach and using a site value of $500,000 I arrived at about $782,000.

You don't have the effective date of my appraisal. So, your comparisons are worthless!!!!! So basic. In my data set, which is ALL lot sales before the effective date of appraisal, only one was over $500K.

3- The income approach was not credible or supported because I did a rental survey. I won't argue with Bert's estimated rents although I have my doubts. Anyway I used his rents and a typical GRM up there is normally between 220 to 222- I used 220 as my multiplier and arrived at $792,000. I have no idea why Bert used a Capitalization Rate because its not a traditional or recognized method on residential properties, and that may have been one reason the income approach was so out of wack.

You don't have the effective date of my appraisal. So, your comparisons are worthless!!!!! Whew ... believe it or not. Where did this guy come from?

4- Adjustment issues :
I am not going to try and micro manage his or anyone else's adjustments but I believe his regression and data pool may be so large that on a small 800 square foot home the machine is confused and coming up with adjustments that are not market supported. A $1,400 separate line item adjustment on a $800,000 home is just not how buyers or sellers act in a real market. In my opinion even using a percentage based system it would be very rare that I used anything less than 1% and often that would be on a cost to cure or repair item.

I have an R2 in my model of around 0.90 Stage I. My adjustments are very well supported. You don't stand a chance against me.

5- The bottom line is the appraiser may need to consider that a typical reader or user is not going to read this report and they will go directly to the value based on the Sales Comparison Approach. If it was reviewed by a peer group of MAI or SRA'S they would not be able to replicate it, and therefore most likely they would reject it as nothing more than a poorly programmed AVM. Even if these type of reports are used only for private assignments, who wants or needs this much data on a stupid 800 Sq.Ft. California Bungalow.

The AVM is Salford Systems MARS, which has won numerous awards and data mining competitions. Who are you to say it is poorly programmed or that some group of MAI or SRA's would not be able to replicate it?

Your primary qualification is that you don't understand what you are talking about UNDER THE ASSUMPTION that others also are as lacking as you.

Funny : This kinda gives me flashbacks to 1979 when my father and I were going to pour a patio, I had framed and poured quite a few sidewalks, driveways and patios, and so I knew what I was doing. My father had a PHD in both engineering and mathematics. Anyway I am framing the patio and he comes over and says is 4" inches going to be thick enough ? I respond yes it will- He then pulls out his stupid HP scientific calculator and asks me how much weight it will hold ? I respond with I have no idea and I don't care. He then says wow I think it will hold X-thousands of pounds- I yell at him that we are not gong to drive a freaking truck across it !- He was highly offended and walked back into the house, we did not talk for three days and then he lectured me on why I needed to be more detail oriented, I kinda feel that way about Bert's regression machine, Hey Bert we are just appraising a stupid little house were even the most goofy Realtor could arrive at a value just by looking at three or four recent sales.

You don't see the broader picture, the context, which is very simply stated in the title on the website: "Sample Appraisal Using The Subjective Value Constraint Approach". I'm puzzled as to why you can't comprehend that. An even broader context, is that the appraisals I do are intended to be advances in the state of the art. As such they are intended to handle entire neighborhoods.

But look. Some people are very difficult to get through to. You can tell them something, they don't hear it. Kind of like your dad and you. And boy, do I know the problems. Some people are just born dense as hell, and they are like that their whole life. You can never get through to them, except at their frigging level. I imagine your Dad eventually gave up. No?
 
Last edited:
Meh, the two sales in his analysis that actually had a 2bd/1ba count sold for $750k and $780k, and both look to be at least a little superior in condition. If I'm doing a qualitative analysis I'm probably ranking the subject inferior to both of them.

Sometimes a cigar is just a cigar.

The ranking of the comparables on Condition, Quality, Appeal, is done by the method, based on residuals. The appraiser has no input, other than deciding on the transaction data to be entered into the regression. And, basically, the Sales Price minus regression contributions based on physical attributes, or the residual, determined that value. For better or worse. That's it - you have no say as to whether Comp A is better than Comp B. All you can do is rank your subject against the already ranked comparables. I can't guarantee that won't be problematic, but I have never had a problem. In fact, it has been easy.

But .... that damn sales price incorporates market reaction to CQA far better than your .... hmmmm ... opinion whatever that is now worth. Caught you in a trap buddy. You didn't see it. Your personal subjective judgment is NOT supported by the hard cold facts. I guess you "could" argue that the market reaction is flawed in comparison to your superior judgment. Heck you can argue all you want. I'd rather just have the sale price on my side.
 
Last edited:
I highly doubt that. I saw the street pics for that block. This parcel is 2 doors west of that site - AWAY from San Francisco Ave, which also has some older existing multifamily on it. This building wasn't built in the last 36 months.

View attachment 43052

Why don't you just admit that you didn't really look at these land sales? Because if you had you wouldn't have cited this one as any type of comparable to your site. You basically put a bunch of unqualified garbage into that "valuation engineering" model which then proceeded to spit a number out which is just as likely to be unreasonable as reasonable. No better than a coin toss

Would you really have appraised a vacant site on Hibbert Ct using these protocols and this model?

Here is the MLS listing. You can pull this right off the MLS. What is wrong with you?

ML81497440R1016-345-2000 Brighton Road
12,060​
36.07​
9/4/2015​
879​
$435,000​
NNN0
-122.484​
37.63105​
This large lot that is approximately 12,060 Sq Ft, gives you the opportunity to design and build your dream home in Pacifica where you can enjoy living on the coast! Convenient to SF and Silicon Valley! Survey Done. This property is located between 501 and 547 Brighton. But do not disturb the neighbors.
 
You don't have the effective date of my appraisal. So, your comparisons are worthless!!!!! Whew ... believe it or not. Where did this guy come from?

As Glenn Walker probably did, I would say your effective date was sometime in November 2018 but you had pictures dated December 7 2018. both of these snapshot photos taken directly from your report.

Also, you MLS printouts had a copyright of 2018. Guess you did not redact everything.
 

Attachments

  • 1.JPG
    1.JPG
    24.7 KB · Views: 8
  • 2.JPG
    2.JPG
    20.5 KB · Views: 8
Last edited:
But I would guess you are not an SRA or MAI.

I am an SRA and that income approach is nowhere near credible and neither is the cost approach. There is no justification to put that kind of analysis in the report when it doesn't even remotely follow basic procedures. What you have demostrated is you don't know how to do either.
 
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Back
Top