Tagged: spreadsheet

Visualizing Market Activity Using Graphs & Trendlines 4

Visualizing Market Activity Using Graphs & Trendlines

Spreadsheets and graphs are powerful tools for appraisers. With proper data, and incorporated into reports, they can enhance your professionalism and decision-making ability.  Appraisers, this article will highlight the process I use to bring clarity to my research and analysis of ‘comparable’ properties. This completed process becomes an exhibit in all my appraisal reports because it helps the Intended User(s) visually see what the market has been doing over a known time period. The exhibit graph also indicates a daily rate of change for the sales over the time period, which can then be applied as a ‘time’ (market) adjustment...

Appraiser Bias Allegations Unmask Nonbank Lenders Debt Traps 10

Appraiser Bias Allegations Unmask Debt Traps

Claims of tainted appraisal unmask something else… the renewed “churning” of mortgages by nonbank lenders. Convinced racism torpedoed valuations in their home refinancings, the owners of three properties in the San Francisco Bay Area told their stories to Julian Glover, a reporter who covers the race, culture and social justice beat for ABC’s San Francisco affiliate. Similar claims of tainted appraisals have surfaced in Philadelphia, Chicago and, more recently, Maryland. A civil lawsuit was filed in one of the cases in a federal district court. A claim was dismissed Wednesday based on a flaw unrelated to the case’s core allegation...

Don Machholz Passing 6

Don Machholz Passing

Folks, yesterday, August 11, I received the following notice about Don Machholz from a California appraiser, who requested this be circulated: With sadness, I wanted to share the news of Don Machholz passing on Tuesday, August 9 in Wikieup, AZ due to complications with COVID-19. Don was a real estate appraiser from 2003-2018 and was well known within the appraisal industry. He was active in the Real Estate Appraisers Organization (REAA) and the Nevada County and Placer County Association of Realtors throughout his career. Don was known for his market updates and sense of humor at the weekly marketing meetings....

Solving the ANSI Measuring Dilemma - A Simple Work Around 39

Solving the ANSI Measuring Dilemma

…a brilliant ‘work around’ to solve the subject & comps adjustment issues, which Fannie Mae thinks is no big deal… Appraisers, I was chatting with an appraiser buddy last week about the ANSI measuring dilemma we all face when doing Conventional lending reports, which ultimately will wind up with Fannie Mae. In my view, my appraiser buddy has a brilliant ‘work around’ to solve the subject & comps adjustment issues, which Fannie Mae thinks is no big deal, but we all know will cause considerable consternation among users of our reports, and with appraisers trying to figure out how to...

Why is Price Indexing Important. Opinion, Estimate, or Prediction? 1

Opinion, Estimate, or Prediction?

Join George Dell & Craig Gilbert for a free 2-hour webinar on Market Price Indexing: For Peaking Prices… Price indexing is also known by other words, such as time adjustments or market conditions adjustments or trend analysis. A number of techniques have been recommended over the years. Most are flawed. Oddly, the algorithm mechanics of calculating are fairly simple and intuitive. Best of all, once done correctly, the payoff is really high: You effectively increase the data available for comparison. For example, a very similar property is perfect, but is say 20 months ago, it becomes your best comp. It makes other adjustments easier to...

Why is Residential Appraisal in trouble? Is Residential Appraisal Finished? 29

Why is Residential Appraisal in Trouble?

Why is Residential Appraisal in trouble? Is Residential Appraisal Finished?… There will soon be no need for residential appraisers. I remember years ago, doing education for my merging AIREA/SREA chapter(s) in San Diego. AVMs were just coming to our attention. I invited a MAI who happened to also be a PhD in economics, Phil Mitchell. The room was full. Someone asked about those “automated algorithmic computer calculated appraisals.” Could a canned program do as well as an appraiser? Without hesitation, he answered: “Not only will these models be able to appraise – they will do it better!” That was 24 years ago. He was right, partially. I...

We Need Software which Enables & Empowers the Analyst... the Appraiser 7

What Skills Do I Need Now?

Analyst software focuses on analysis – sorting, classifying, comparing, and associating data to turn it into useful information… New technologies require new skills. The bad news is that new data science skills are not taught in appraiser education. The good news is that the new technologies are things an appraiser can sell. Let’s look at the good news! Data science skills include the ability to: Identify the relevant data. Turn the data into useful knowledge. Express the analytic flow to a customer. Who can best collect, analyze, and explain an analysis? Well, it takes someone who understands the subject (the market), the analytics (algorithms), and communication (visuals and summaries).  Machines...

Skeptics, traditional, vocational or advanced appraiser. What kind are you? 31

What Kind of Appraiser Are You?

Skeptical skeptics are a rare breed. But growing in number… Different appraisers have different attitudes! Some have a lot of experience, others a lot of education. Others emphasize the ‘art’, while others consider themselves ‘quants’. Let’s put aside the ‘art’ versus ‘science’ discussion, where the artists say: “No computer will ever replace the appraiser”, or “No amount of education will ever replace experience”. The other side seems a bit confused. There are traditionalists. And there are the “advanced” appraisers. And there are the “vocational” appraisers, who don’t seem to care much about all of this. They just want to push through as many reports as possible. The skeptics tend to doubt...

How Zestimate Works - Accuracy Is an iIsue with Zestimates 8

How Zestimate Works

Accuracy is an issue with Zestimates… I happened to find this article, which explains the processes used to generate Zillow’s Zestimate, the estimate of residential property value: Inside the Zestimate: Data Science at Zillow I found it interesting that they use the ‘R’ spreadsheet for doing some number-crunching, not Excel. ‘R’ is what George Dell has been demonstrating in his classes. But the graphs are generated by a different software. Accuracy is an issue with Zestimates, according to Zillow, per the article:  “Nationally, the median error rate is 8.3 percent, the company says.” However, they don’t define what ‘error rate’ means. Is...

Schizophrenic Adjustments - Down to Exact Dollar Amount 35

Schizophrenic Adjustments

Appraisers, I’ve written in the past about what I believe are strange ways to report adjustments in appraisals, and suggested ‘rounding’ is a perfectly acceptable way to report them. This is largely due to buyers and listing agents thinking and listing in $100 increments – not down to exact dollar amounts. During the past couple of weeks, I ‘came in contact with’ two separate appraisals done by different appraisers on totally different properties, in different market areas. What struck me was the incredibly precise adjustments made for only certain items in these reports, while the rest of adjustments were ‘rounded’ to...

xml sitemap
blank