Sunday, February 25, 2018

Homequant Offers Blog Marketing Service

(Click on the image to enlarge)

Friday, February 23, 2018

Homequant Offers Custom Pivot Table Service

(Click on the image to enlarge)
** US Businesses Only **

Tuesday, February 20, 2018

Homequant Offers QA/Review AVM Seminar - 100% Excel-based

(Click on the image to enlarge)
** CLOSED **

The following backgrounds are preferred: Real Estate Appraisal/Assessment; RE Appraisal/Assessment QA/Review; Mortgage/Loan Portfolio QA/SQC/Review; Automated Valuation Modeling; CAMA Modeling; Housing Economics; Statistical Forecasting and Modeling; Data Analytics and Modeling, and such related areas. 

Please send requests to:

Monday, February 5, 2018

Homequant Offers Ultra-niche Job Board Licensing Opportunity

(Click on the image to enlarge)

A Structured Research Methodology for First-time Homebuyers

First-time Homebuyer = John Doe

1. Pre-qualification – Since qualified salespeople will not work with John without a recent pre-qualification letter, he must start the process with a pre-qual, which, additionally, allows him to understand the price-level to target.

2. Research Design – With a pre-qual in place, he must not run to a brokerage and get caught into their in-house exclusives; instead, he should educate himself (re: price-level, neighborhoods, type of property, sales vs. comps, brokers, etc.) to a point that lets him call his own shots (i.e. capable of identifying the properties he would like to visit while letting a qualified salesperson arrange the mere showings).

3. Research Step 1 – Considering it’s all about ‘Location, Location, Location’ his research begins by identifying the neighborhoods he might be interested in. There are many websites that offer the soft stats broken down by zip codes, census tracts, towns, neighborhoods, etc.

4. Research Step 2 – Once he selects a handful of neighborhoods, he needs to zero in on the respective price-levels, in line with the pre-qual. In researching the price-levels, he needs to identify and use sites that are top-down (including top-down subject valuation meaning town to neighborhood to subject; fixed location valuation; and neighborhoods that are under or over assessed) – not MLS or private brokerage sites that are inherently bottom-up (comps based). 

5. Research Step 3 – Understanding Comps… John must:
a. Learn to differentiate between Sales and  Comparable Sales, i.e. making quantitative adjustments to comps.

b. Understand Least Adjustment method in selecting comps vs. Distance Radius or Sales Recency

c. Understand Time Adjustment (Three Similar Sales from Three Prior Quarters - Unadjusted for Time of Sale - are not Comps)

d. Demand to See the Comps Spatially, as the comps from the other side of a major artery - despite meeting the distance search - are not necessarily comps (when presented by the salesperson)

e. Insist on Five Best Comps to Value a Subject (when presented by the salesperson)

f. Verify Salesperson’s Listing Price/Appraiser's Value in Four Easy Steps

g. Validate All Values at a Self-directed Site, rather than at the Broker’s Site

6. Research Step 4 – John needs to connect with recent homebuyers on social media, to avoid having to reinvent the wheel (will help avoid many trips to the ER, so to say!).

Sunday, February 4, 2018

An Illustrated Guide to Automated Valuation Modeling (AVM) - 100% Excel-based

(Click on the image to enlarge)

What the Experts are Saying:

First off, may I say congratulations and what a tremendous effort. Our small appraisal business (by your standards) works almost solely in the Excel domain and we have patched together bits of code over the years which constitutes our AVM toolkit. Your publication is therefore most welcome. More than that, it dumbs down so much of the process for the likes of us valuers. Practitioners with a basic understanding of AVM’s and a good grasp of Excel, will realize how effective your methods are at modelling, model testing and as a value and sales review tool." Mass Appraisal Director ...

An Illustrated Guide to AVM in Excel is a great book for those with a fundamental knowledge of Valuation Model Building.  It provides an excellent overview of the process and serves as a thorough check list of things to consider whether you are using Microsoft Excel or a Statistical Software package. Chief Assessor