Scatter Charts for Appraisers

Newz: Scatter Charts, Do Not Use List, UAD 3.6 Key Changes and Resources

March 30, 2026

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Am I Still on the ‘Do Not Use’ List
  • The Power of Scatter Charts: Bringing Objectivity to Appraisals
  • by Scott Cullen
  • 1780 Tiny Home That Was Built by a British Sea Captain Hits the Market in Georgetown for $1,198,000
  • MY AD: Highest and Best Use of the Cost Approach
  • The housing market so far in 2026 By Ryan Lundquist, March 11, 2026
  • Trump’s Executive Order on Access to Home (including appraisers)
  • MBA Origination Stats: Mortgage applications decreased 10.9 percent from one week earlier

 

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

————————————————

The Power of Scatter Charts: Bringing Objectivity to Appraisals

by Scott Cullen

Excerpts:

“Objectivity is isolating the effect of individual variables on value.”

Once upon a time, in a suburban neighborhood not so far away, an appraiser came across a pure pair, two homes that seemed almost identical. They shared the same neighborhood, lot size and condition. The only difference was size. One house had 2,500 square feet of above grade finished area and the other had 2,300. The first sold for $460,000, the second for $446,000. The difference in price was $14,000. The difference in area was 200 square feet—producing an adjustment of $70 per square foot.

Traditionally, an appraiser might document this relationship as a simple table, noting the difference in sale price and living area. Unfortunately, pure pairs are so rare that they often seem like a fairytale—something every appraiser dreams of finding but seldom does. In the real world, properties rarely align so neatly. Markets shift, concessions appear, and location nuances creep in. Yet there is hope. By learning to use scatter charts, embracing adjusted pairs, and understanding sensitivity analysis, appraisers can move closer to true objectivity in their valuation work.

From Paired Sales to Sensitivity Analysis

The Appraisal of Real Estate, 15th Edition defines paired data and grouped data as forms of sensitivity analysis—a method used to isolate the effect of individual variables on value. Sensitivity analysis is the overarching principle that allows us to quantify how much one variable contributes to price, while holding others constant (Appraisal Institute, 2020, p.371). Scatter charts are among the most powerful tools available to visualize and calculate these relationships.

Why Visualization Matters

Scatter charts do more than calculate—they communicate. They combine mathematical precision with the clarity of visualization. For appraisers, this means turning abstract numbers into evidence that both clients and reviewers can see.

A well-constructed scatter chart illustrates the logic behind the adjustment and lends weight to the appraiser’s conclusions. It reinforces transparency: others can replicate the math, verify the trendline, and confirm that the adjustments are derived from observable market behavior.

As the saying goes, “A picture is worth a thousand words.” In appraisal, it’s also worth credibility. Scatter charts bring statistical discipline to the craft of valuation, grounding professional judgement in data.

To read more, Click Here

My comments: Read more to see scatter chart samples and how they are used.

—————————————————-

1780 Tiny Home That Was Built by a British Sea Captain Hits the Market in Georgetown for $1,198,000

Excerpts: 1 bedroom, 1.5 baths, 1,015 sq.ft., 1,307 sq.ft.lot built in 1780

An adorable red tiny home that is said to have been built by a British sea captain nearly 250 years ago has hit the market in Washington, DC, for just a touch under $2 million.

Described in its listing as a “treasure,” the home, which is “believed to be one of the oldest homes in Georgetown,” comes complete with just one bedroom and 1.5 bathrooms, and spreads across a pint-sized 1,015 square feet of living space.

But what the dwelling lacks in stature, it more than makes up for in rich history, which dates back to 1780, when it is understood to have been constructed by the European sailor, with some reports suggesting that the hand-hewn beams inside the home were made with wood from a ship that had come aground in the area.

More recently, the adorable abode was home to Ann Caracristi, a cryptologist, World War II veteran, and the first woman to serve as deputy director of the NSA. Caracristi purchased the dwelling in the mid-1900s and lived there for more than six decades until her death in 2016.

According to the listing, the home is being made available with many of the traditional decor elements seen in the listing photos, including a personal library of books that belonged to Caracristi.

Soon after her death, the dwelling was purchased for $825,000—before later trading hands again in 2023, this time for $1.1 million.

The home is being offered partially furnished, allowing buyers to get their hands on wooden desks, rustic decor, pewter pieces—and Caracristi’s personal library.

To see the listing with many photos, Click Here

My comments Fascinating to see a home this old with a known history.

————————————————————–

UAD 3.6 Key Changes (And Resources You Need to Know)

Excerpts: Key Changes to Note:

Material Difference

One of the first things appraisers notice about the new UAD is the way property characteristics are captured. Gone are the days of squeezing every nuance into a comment box the size of a Post-it note. Instead, the new system requires us to think more like data scientists — a structured, repeatable process that logically organizes the characteristics of each property.

That includes thinking differently about what counts as a “material difference.” Appraisers have always had to consider market-relevant features, but now those distinctions need to be expressed in a standardized way.

Ceiling Height

If you were to search for “ceiling height” within the F1 reference guide, you’ll find that one of the references (report field ID: 10.045) details when to include it, and the answer is always. But I’m going to back up real quick and read what it says about starting under walls and ceiling.

“The appraiser must…” Must is not a suggestion, folks; must means you have to do it — i.e., “provide information about the walls and ceilings in the unit.”

The walls and ceilings row always displays in the interior features table, and you have to choose one or more of the allowable answers. So ceiling height (that is, the approximate ceiling height in the unit, rounded to the nearest foot) is always required.

Broadband Internet

Let’s talk about one of the more surprising features in the new UAD: broadband availability.

Yes, you read that right. In 2025, internet access joins the ranks of site, view, and utilities. And honestly, it’s about time. If you’ve ever tried to run your business off two bars of rural cellular service, you know that internet speed can be a real market factor.

It’s a simple question – “Is broadband internet available?” — and your answers are yes and no.

If you check “yes,” you’re confirming high-speed internet access is publicly available exclusively through a digital subscriber line, fiber optic, or cable. If you answer “no,” you’re saying public high-speed internet access is unavailable, or it’s only available through a private satellite. If it’s a satellite, it’s a no. You might say, “Well, what if it’s Starlink? Is that a satellite?” Nope, the answer is still no.

But how do you verify it

To read more, Click Here

My comments: Good discussion on how the new URAR reports are dramatically different from the legacy forms. Real estate agents, appraisal reviewers, attorneys, buyers and sellers etc. all prefer the new reports. The days of typed appraisal reports are long over. If I was doing lender appraisals I would do the new URAR reports.

———————————————————–

Are you getting too many ad-only emails?

4 ways to get only the FREE email newsletters and NOT the ad-only emails.

1. Twitter: https://twitter.com/appraisaltoday Posted by noon Friday

2. Read on blog www.appraisaltoday.com/blog Posted by noon Friday. You can subscribe to the blog in the upper right of each blog page. NOTE: the popular ads with liability tips are below the first topic on my blog posts.

3. Email Archives: https://appraisaltoday.com/archives

(posted by noon Friday) The link is above and to the left of the big yellow email signup form. Newsletters start with “Newz.” Contains all recent emails sent.

4. Link to the 10 most recent newsletters (no ads) at www.appraisaltoday.com. Scroll down past the big yellow signup block. The newsletters have abbreviated titles, taken from their blog posts.

To read more about the 4 ways, plus information on why I take ads, etc.

Click here

———————————————————–

Highest and Best Use of the Cost Approach

By Scott Cullen

In the April, 2021 issue of Appraisal Today

Excerpts: To most residential appraisers, the Cost Approach is like old school

comedian Rodney Dangerfield. “It don’t get no respect.”

Effective Age

Where do we get effective age? Residential appraisal forms assume the

economic age-life method of depreciation. Effective age includes all forms

of deprecation.

“In applying the concepts of economic life, effective age, and remaining

economic life expectancy, appraisers consider all elements of depreciation

in one calculation. Therefore, the effective age estimate includes not only

physical wear and tear but also any loss in value for functional and external

considerations.” [2] Source: The Appraisal of Real Estate 15th Edition, The

Appraisal Institute, Chicago p562.

Because all forms of depreciation are included in effective age, the

percentage of depreciation applied to economic life is the effective age.

Sixty year economic life x 10% = 6 years effective age.

Calculating GLA Adjustments

Knowing that the house’s market reaction is 90% of value, we can

extract a GLA adjustment from the cost data.

When we compared the pure pair of houses that sold for $310,000 and

$294,800, we divided the price difference by the difference in GLA to get a

GLA adjustment of $76.

We get the same result by applying market derived depreciation to the

difference in GLA cost of those houses. We extracted depreciation from the

market using unbiased, third party cost data. We used the same data to

compare cost. Even if the cost data is not exact (it never is), we get

credible results when we use the same data to calculate depreciation as

we do to calculate the cost difference.

When depreciation is extracted from the market, depreciated cost is a

market based method of developing sales grid adjustments.

The same reasoning can be applied to a bath count adjustment. If the

unbiased third party cost data states that a full bath costs $12,000, and the

market reaction is 90%, a bath count adjustment is $10,800.

To read the full article, plus 3+ years of previous issues, subscribe to the paid Appraisal Today at www.appraisaltoday.com/order .

Not sure if you want to subscribe?

Sign up for monthly auto renewal for $8.25!

Cancel at any time for any reason! You will receive a prorated refund.

$8.25 per month, $24.75 per quarter, and $89 per year (Best Buy)

or $99 per year or $169 for two years

Subscribers get FREE: past 18+ months of past newsletters
——————————————
What’s the difference between the Appraisal Today free Weekly email newsletter and the paid Monthly newsletter? Click here for more info.

——————————————————————–

If you are a paid subscriber and did not receive the

March, 2026 issue emailed on

Monday March 2, 2026 please email info@appraisaltoday.com, and we will send it to you. You can also hit the reply button. Be sure to include a comment requesting it. Or, call 510-865-8041

————————————————————

The housing market so far in 2026

By Ryan Lundquist, March 11, 2026

Excerpts: All ships rise and fall with the tide. That’s one of my favorite things to say in real estate because the trends we see in one local county are often seen in other counties.

SPRING VIBES IN THE STATS

We’re starting to see spring show up in the stats. Here are two examples. Do you see days on market starting to tick down for the season? And check out the median sales price rising in February. These were both expected. Price change ahead is still to be determined, but a February uptick was a safe bet.

“MY AREA DIDN’T DECLINE LAST TIME”

Sometimes people say things like, “My neighborhood didn’t decline during the Great Financial Crisis.” I get the sentiment, but every local neighborhood saw price declines back then. It’s just some higher price points were able to weather the storm a bit better as there wasn’t extreme carnage like entry-level price points had. In short, no neighborhood escaped the trend back then, and the same is true today with every area feeling more softness over the past year (and now heating up for the spring). Know what I’m saying?

To read more, Click Here

My comments: Ryan writes for his local market. He writes this for real estate agents, the best source of referrals for residential appraisers. See how Ryan explains what is happening to apply it to your appraisals when possible. Graphs and tables are very important to let your clients see what is happening.

———————————————————-

Trump’s Executive Order on Access to Home Loans

EXPANDING ACCESS TO HOME LOANS: Today, President Donald J. Trump signed an Executive Order to reduce regulatory burdens that have driven up mortgage costs, limited access for creditworthy borrowers, and weakened community bank participation in lending. March 13, 2026

How it affects appraisals

Sec. 6. Appraisal Modernization.

(a) The Vice Chairman for Supervision of the Federal Reserve, the Director of the CFPB, the Chairman of the NCUA Board, the Chairperson of Board of Directors of the FDIC, the Comptroller of the Currency, and the Director of the FHFA shall consider, as appropriate and consistent with applicable law and their statutory authorities:

(i) modernizing appraisal regulations and guidance to expand the use of alternative valuation models, desktop and hybrid appraisals, and artificial intelligence valuation tools;

(ii) simplifying appraiser qualification requirements; and

(iii) reducing appraisal requirements for low-risk transactions, including low loan-to-value refinancing and small‑balance loans; and setting clear appraisal timelines.

(b) The Secretary of Housing and Urban Development (HUD) and the Secretary of Veterans Affairs (VA) shall consider, as appropriate and consistent with applicable law:

(i) aligning appraisal standards between the Federal Housing Administration and VA Home Loan Program where risk is comparable;

(ii) clarifying the distinction in an appraisal inspection between safety and habitability concerns that necessitate pre-closing repairs versus cosmetic concerns; and

(iii) expanding post-closing repair flexibility.

To read the Fact Sheet for the Executive Order, Click Here

My comments: Interesting suggestions. Who knows what will be implemented.

————————————————————–
Note: I publish a graph of this data every month in my paid monthly newsletter, Appraisal Today. For more information or get a FREE sample go to www.appraisaltoday.com/order Or call 510-865-8041, MTW, 7 AM to noon, Pacific time.

My comments: Rates are going up and down. We are all waiting for rates to drop lower in 2026.

Mortgage applications decreased 10.9 percent from one week earlier

WASHINGTON, D.C. (March 18, 2026) — Mortgage applications decreased 10.9 percent from one week earlier, according to data from the Mortgage Bankers Association’s (MBA) Weekly Mortgage Applications Survey for the week ending March 13, 2026.

The Market Composite Index, a measure of mortgage loan application volume, decreased 10.9 percent on a seasonally adjusted basis from one week earlier.  On an unadjusted basis, the Index decreased 10 percent compared with the previous week. The Refinance Index decreased 19 percent from the previous week and was 69 percent higher than the same week one year ago. The seasonally adjusted Purchase Index increased 1 percent from one week earlier. The unadjusted Purchase Index increased 2 percent compared with the previous week and was 12 percent higher than the same week one year ago.

“Mortgage rates continued to move higher, driven by increasing Treasury yields as the conflict in the Middle East kept oil prices elevated, along with the risk of a broader inflationary shock. Mortgage rates increased across the board, with the 30-year fixed rate rising to 6.30 percent, the highest rate since December 2025,” said Joel Kan, MBA’s Vice President and Deputy Chief Economist. “Rates were around 20 basis points higher than they were two weeks ago and this caused a reversal in refinance activity, particularly for conventional refinance applications, which decreased 27 percent over the week. Government refinances also declined but by 5 percent, as FHA rates have not increased quite as rapidly. Purchase applications remained steady despite the higher rates, with conventional purchase applications unchanged and growth in both FHA and VA segments. Overall purchase applications remained ahead of last year’s pace, supported by higher inventory and slowing home-price growth in many markets.”

The refinance share of mortgage activity decreased to 52.3 percent of total applications from 57.8 percent the previous week. The adjustable-rate mortgage (ARM) share of activity decreased to 8.0 percent of total applications.

The FHA share of total applications increased to 19.4 percent from 17.1 percent the week prior. The VA share of total applications increased to 16.7 percent from 16.1 percent the week prior. The USDA share of total applications remained unchanged at 0.4 percent from the week prior.

The average contract interest rate for 30-year fixed-rate mortgages with conforming loan balances ($832,750 or less) increased to 6.30 percent from 6.19 percent, with points increasing to 0.63 from 0.58 (including the origination fee) for 80 percent loan-to-value ratio (LTV) loans. The effective rate increased from last week.

The average contract interest rate for 30-year fixed-rate mortgages with jumbo loan balances (greater than $832,750) increased to 6.39 percent from 6.26 percent, with points increasing to 0.34 from 0.30 (including the origination fee) for 80 percent LTV loans. The effective rate increased from last week.

The average contract interest rate for 30-year fixed-rate mortgages backed by the FHA increased to 6.08 percent from 6.02 percent, with points remaining unchanged at 0.70 (including the origination fee) for 80 percent LTV loans. The effective rate increased from last week.

The average contract interest rate for 15-year fixed-rate mortgages increased to 5.66 percent from 5.54 percent, with points increasing to 0.73 from 0.68 (including the origination fee) for 80 percent LTV loans. The effective rate increased from last week.

The average contract interest rate for 5/1 ARMs increased to 5.65 percent from 5.26 percent, with points increasing to 0.67 from 0.64 (including the origination fee) for 80 percent LTV loans. The effective rate increased from last week.

The survey covers U.S. closed-end residential mortgage applications originated through retail and consumer direct channels. The survey has been conducted weekly since 1990. Respondents include mortgage bankers, commercial banks, thrifts, and credit unions. Base period and value for all indexes is March 16, 1990=100.

——————————————————-

Anne O'Rourke PortraitAnn O’Rourke, MAI, SRA, MBA

Appraiser and Publisher Appraisal Today

1826 Clement Ave. Suite 203 Alameda, CA 94501

Phone: 510-865-8041

Email:  ann@appraisaltoday.com

Online: www.appraisaltoday.com

UAD 3.6 and Appraisal Workflow

Newz: Practical AI Uses for Appraisers, Appraisal Forms Humor 

March 13, 2026

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Client Insists on Cost to Cure
  • UAD 3.6 Is Coming: A Practical Moment to Rethink Your Workflow
  • Appraisal By Kevin Hetch
  • One of Palm Springs’ ‘Storied’ Rock Houses Hits the Market for $1.5 Million: ‘A Rare Treasure’
  • Getting 94 offers & a tighter housing market By Ryan Lundquist
  • MY AD: Do I really have to report that state board issue to my E&O insurance? By Peter Christsen, Esq.
  • Beyond the Hype: How I’m Using AI to Actually Save 10 Hours a Week By Dustin Harris
  • Appraisal Forms – the next Generation – Humor
  • MBA : Mortgage applications increased 3.2 percent from one week earlier

——————————————————————–

 

 

—————————————————————————

UAD 3.6 Is Coming: A Practical Moment to Rethink Your Workflow Appraisal

By Kevin Hecht

Excerpts: For many appraisers, the transition to UAD 3.6 feels different from past form updates. This is not simply a revised version of the URAR with a few new fields or definitions. It represents a structural shift in how appraisal data is organized, communicated, and delivered.

While change on this scale can feel disruptive, it also creates an opportunity to improve efficiency, modernize workflows, and position your business for the future.

This transition is not just about learning a new report format. It is about adapting to a new data-centric environment. And one of the most important places to start is with your appraisal software.

This Is a Moment of Opportunity

Transitions like this can feel uncertain, but they also offer a chance to improve how you work.

By taking time now to understand UAD 3.6, evaluate your software options, and refine your workflow, you can position your business to operate more efficiently and confidently in the new reporting environment.

The goal is not simply to adapt. It is to build a workflow that supports you well into the future.

UAD 3.6 is coming. And with the right preparation, it can be a step forward for both the profession and your practice.

Topics

  • This Is More Than a Form Update
  • Start by Looking at Your Process, Not Just Your Software
  • Not All Software Will Handle This Transition the Same Way
  • Efficiency Gains Are Possible, But They May Require Change
  • Focus on What Supports Your Business Long Term
  • The Appraiser’s Role Remains the Same
  • This Is a Moment of Opportunity

To read more, Click Here

My comments: I had never thought about the “big picture”: how the software affects your business. Worth reading.

I have been writing about the appraisal software for a year and just wrote another article on Appraisal software vendor Timelines for my April newsletter. Only 1 or 2 are ready to go. The others need more work done. Appraisers cannot learn to use the software until it is fully completed.

Why is this going so slow? The GSEs did not check with the software vendors to see how much time they needed to complete their software. The actual time needed has been longer than expected. Also, GSE requirements to make all the software the same for the reporting section had to be exactly the same for all the vendors. Also, PDF and XML reports must be correctly done. Getting this all validated by the GSEs is taking time.

Read more!!

UAD 3.6 Humor for Appraisers

Newz: UAD 3.6 Humor, UAD 3.6 Reality. Appraisal Volume, Waivers, PDCs

March 6, 2026

What’s in This Newsletter (In Order, Scroll Down)

LIA AD: Judicial Appraiser Panels: Balancing Opportunity and Liability
UAD 3.6 – She’s Gonna Blow CARTOON!
Lake Como-Inspired Hillsborough, CA Megamansion With Koi Pond and Private Spa Lists for an $88 Million
What are home prices doing? It depends. By Ryan Lundquist
MY AD: UAD 3.6: Yes, No or Maybe
What the latest war means for mortgage rates
UAD 3.6, the New URAR, and the Reality Nobody Wants to Say Out Loud
2026 Market Update: Appraisal Volume, Waivers, and PDCs
Mortgage applications increased 11.0 percent from one week earlier’
———————————————-

————————————————————————————

UAD 3.6 – She’s Gonna Blow CARTOON!

Acme Appraisal Company Replies to Their First UAD 3.6 Appraisal Order

To See the Cartoon, Click Here

My comment: Very Funny ;> And Appropriate!

——————————————

Lake Como-Inspired Hillsborough, CA Megamansion With Koi Pond and Private Spa Lists for an $88 Million

Excerpts: 6 bedrooms, 7.5+ bath, 12,404 sq.ft., 12.33 acre lot, built in 2013

It was inspired by the masterful megamansions found on the shores of Italy’s Lake Como.

The sprawling property in Hillsborough, CA, is focused almost entirely around serenity and relaxation, boasting an Asian garden, koi pond, rose garden, reflection pond, and an English spiral mound.

Known as Villa de Verano, the expansive estate begins with a tree-lined driveway that leads to a grand motor court, primary residence, guest home, amphitheater, event lawn, and pool.

Over-the-top highlights found throughout the 12,404-square-foot main residence include a fitness center, home theater, game room, spa, and saltwater aquarium.

A sports pavilion boasts a two-story lounge with viewing platform that overlooks a sunken tennis court, pickleball court, volleyball court, badminton court, bocce ball court, horseshoe court, shuffleboard court, and putting green. There is also an executive length golf course found on the property.

To read the listing, Click Here

My comment: Hillsborough is a city with many expensive homes located in the San Francisco Bay Area

Read more!!

Appraising with Limited Comps

Newz: Limited Comps, Freddie Mac: Property Data Collection, Avoiding ourt

January 23, 2026

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Avoiding Court
  • Arriving at a Credible Appraisal When Comparable Sales Are Limited By Kevin Hecht
  • MAPPED: The Most Expensive Home Sales of 2025—From Palantir CEO’s Record-Breaking Ranch to Florida’s Priciest Mansion
  • MY AD: The AMC Conundrum in the Appraisal Business by Dave Towne
  • From Data to Value: How Mass Appraisal Delivers Fair Market Assessments
  • Freddie Mac. Insight Articles: Property Data Collection: An Overview
  • Housing Market Predictions for 2026
  • MBA: Mortgage applications increased 14.1 percent from one week earlier

———————————————————————–

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

 


Arriving at a Credible Appraisal When Comparable Sales Are Limited
By Kevin Hecht

Excerpts: Limited sales activity is common in rural markets, custom-home neighborhoods, and low-turnover areas. When comps are few, the appraiser’s task is not to find perfect matches, but to show that the selected sales are the best available indicators of value and that all departures from ideal data are well supported.

In this article, we’ll answer questions like: How far back do appraisers look for comps? How far out geographically? What other tips and tricks do appraisers use to arrive at a credible appraisal, even when comps are limited? Additionally, we’ll share some insights from appraisers who answered our survey question, “What do you do when appraisal comps are few?”

When recent, proximate, and similar sales are unavailable, appraisers typically rely on some combination of the “Three D’s” to broaden their search for comparable property sales:

Dated – Search for older sales within the subject neighborhood.Distant – Search for similar sales farther away in competing neighborhoods.

Dissimilar – Search for dissimilar sales within the subject neighborhood by widening the parameters for improvements (GLA, age, features, etc.).

How Far Back Do Appraisers Look for Comps?

Time adjustments draw scrutiny. Most agency assignments expect appraisers to use the most recent closed sales available, typically within the prior 12 months when possible.1 When older sales are used, market conditions adjustments often become central to the analysis.

Time adjustments should be supported with clear data, applied consistently, and reconciled logically. Underwriters pay close attention to whether these adjustments reflect documented market behavior rather than assumptions, particularly in shifting markets.

We surveyed our appraisal community to find out, “What do you do when appraisal comps are few?” The following comments show how individual appraisers often put their own spin on the “Three D’s” when expanding the search for comparable sales:

“Time and distance. My preference is to go back farther in time within the same neighborhood and/or market area and make market condition adjustments. If that still doesn’t provide enough comps, I expand the market area, looking for more recent sales with similar characteristics to the subject property.”

“First consider a broader time frame. Market conditions adjustments are very supportable.”

“Expand search to other competitive neighborhoods. Next, go back in time.”

To read more, Click Here

My comments: I usually go back in time sometimes several years or longer if needed. Of course, I don’t do GSE appraisals with their restrictions…

 


Read more!!

5 Excel Resources and How-To Guides for Appraisers

Newz: Forecasts, Appraisal Forgery,
Excel Appraiser Resources

January 9, 2026

What’s in This Newsletter (In Order, Scroll Down)

  • LIA ad: A Case of Forgery
  • 5 Excel Resources and How-To Guides for Appraisers
  • Appraisal By Jim Amorin, MAI
  • Rare Sculptural Masterpiece by Architect Charles Haertling Hits the Market in Boulder for Under $4 Million
  • USPAP and the State Board By Timothy Andersen, The Appraiser’s Advocate
  • 2026 Housing Market Forecast: The Great Recalibration Appraisal By Kevin Hecht
  • When Protecting Tenants Starts With Targeting Property Rights By Desiree Mehbod
  • MBA: Mortgage applications decreased 9.7 percent from two weeks earlier

———————————————-

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

———————————-

—————————————————-
5 Excel Resources and How-To Guides for Appraisers

By Jim Amorin, MAI

Excerpts: Are you getting the most out of Excel in your real estate appraisal work? If you’ve ever found yourself drowning in data or spending too much time on tedious tasks, it’s time to transform how you complete your appraisal tasks.

We’ll dive into five essential functions that can streamline your appraisal process and boost your efficiency as well as provide real-world examples to help you master these Excel tools and revolutionize your workflow.

VLOOKUP: Your Go-To for Vertical Data Retrieval

Imagine this: You’re working on an appraisal, and you need to verify the sale price of a property quickly. Instead of sifting through pages of data, VLOOKUP does the heavy lifting for you to pull information in a snap.

HLOOKUP: The Horizontal Companion

Now, let’s talk about HLOOKUP. If VLOOKUP is your vertical search tool, HLOOKUP is the horizontal counterpart. It’s perfect for those times when your data is organized across columns rather than rows.

XLOOKUP: The All-Rounder

XLOOKUP was introduced in 2019 as the successor to the VLOOKUP and HLOOKUP functions. XLOOKUP empowers real estate appraisers to navigate vast datasets seamlessly and enhance the precision of their valuations.

IF Statements: Decision-Making Made Simple

In Excel, the IF statement acts like a swift decision-maker, constantly asking, “Is this true or false?” Based on the response to this straightforward yet powerful question, Excel takes a divergent path, calculating different outcomes for the true condition compared to the false one.

To read more, Click Here

My comments: Understandable. I had never heard of this software. Detailed answers on how to use the tools by an expert: Jim Amorin, MAI

Read more!!

Crazy Appraiser Stories

Newz: Crazy Appraiser Stories,
How to Do Regression, Resolutions

CHANGE YOUR TEMPLATES!!

January 2, 2026

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Borrower Wants Answers Appraiser Can’t Give
  • Off the Rails: Crazy Appraiser Stories
  • Inside Pacific Palisades’ Most Expensive Home—a $39.5 Million Hilltop Marvel
  • How to Build a Regression Model in Excel: A Guide for Real Estate Appraisers by Jim Amorin
  • Why Resolve anything? By George Dell, MAI
  • MBA, Fannie Mae see 2027 (and 2026) housing markets very differently
  • MBA STATS – None This Week

Crazy Appraiser Stories!!

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

——————————————————

Off the Rails: Crazy Appraiser Stories

You’ve all got stories of crazy inspections: eccentric collections, mysterious apparitions, and unorthodox decor. Here are a few we found to be the most Buzzworthy.

Excerpts: Reflections

My assignment: a log home in the middle of the city. I go into the owner’s suite, and right in the middle of the room is this built-in whirlpool tub up on a pedestal with velvet steps leading up to it. The whole ceiling is just mirrors. I think, How am I going to deal with this? The owner is so proud of this custom owner’s suite they’ve built.

It isn’t something that the normal market would want, so it has a certain…market impact, let’s say. I handled it by cost to cure.

—Jared Preisler

Let That Sink In

When I was an appraiser trainee, I was tagging along with my supervisor on a packed day of about eight appointments. It was mid-January in upstate New York. Trust me when I tell you it was COLD. First appointment, 9am: we finished walking through the inside of the home and headed outside. I began walking around the back yard (tall winter boots on, of course) when I suddenly realized I was about three feet lower than I had been moments ago. I looked down to see brown, icy water pooling around my feet. I struggled to comprehend what was happening as my boots became completely submerged. Seconds later, the homeowner cracked the door open just wide enough to shout, “Watch out for the koi pond! It’s probably covered in snow!”

I spent the rest of the day wearing socks I borrowed from a homeowner and plastic bags stuffed into my boots, while a swampy smell permeated my boss’s car. Lesson learned.

—KWAppraisalGroup

To read more, Click Here


Read more!!

Appraisal Condition Ratings Under UAD 3.6 and the New URAR

Newz: Appraisal Condition Ratings,

Disaster Risks and Appraisals

December 26, 2025

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Navigating Value Revisions in Appraisals
  • Understanding Appraisal Condition Ratings Under UAD 3.6 and the New URAR By Kevin Hecht
  • Off-Grid ‘Bug-Out’ Bunker With a Maze of Secret Rooms That Have Never Been Lived In Lists for Just $715K
  • Insurance problems aren’t going away in 2026 By Ryan Lundquist
  • My AD: Review of Appraiser’s Guide to the New URAR Class
  • Where to get the list of Fannie Mae’s list of verified (approved) appraisal UAD 3.6 software providers
  • Disaster Risk and the Housing Market: Telling the Future
  • Mortgage applications decreased 5.0 percent from one week earlier

——————————————————————————–

——————————————————————————

2024 Updated UAD and URAR – What does It Mean for You?(Opens in a new browser tab)

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

———————————————————————————

Understanding Appraisal Condition Ratings Under UAD 3.6 and the New URAR

By Kevin Hecht

Excerpts: One of the biggest changes from the legacy forms is that condition is no longer captured with a single rating for the entire property. UAD 3.6 breaks condition into several components.

Appraisers now provide an exterior condition rating, an interior condition rating, room-level condition details for each kitchen and bathroom, and finally an overall condition rating in the Reconciliation section. The “overall” rating must reflect the information documented earlier in the report rather than serving as an isolated judgment.

How Updating Is Reported in UAD 3.6

The previous “not updated,” “updated,” and “remodeled” categories are no longer part of UAD reporting. Instead, the URAR captures updating within the required Kitchen and Bathroom Details.

For each kitchen and bathroom, the appraiser reports the update status, the time frame in which updates occurred, the room’s condition status, and brief comments describing the work. This approach provides better clarity and consistency without relying on broad categories.

More topics:

  • Understanding Each Property Condition Rating (C1–C6)
  • The Role of Defects, Damages, and Deficiencies
  • Where Condition Appears in the New URAR
  • Condition Ratings and GSE Eligibility

Video 7 minutes 20 seconds by Kevin Hecht – short and covers topics briefly.

To read more, Click Here

My comments: Listen to the short video. The article is well written, explaining the difference between the current forms and new UAD 3.6 QC ratings. This makes the changes easier to understand.

Read more!!

Few comps in 2026 for Appraisers

Newz: Few comps in 2026, NAR Revises Nonmember Broker/Appraiser Access Policy

December 12, 2025

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Can’t Certify the Work
  • The problem with comps in 2026 (and the good news)
  • Gravity-Defying Colorado Mansion Designed by a Rocket Scientist Hits the Market for $2.7 Million
  • Creating a Histogram in Excel: A Guide for Appraisers
  • My ad: The AMC Conundrum in the Appraisal Business, By Dave Towne
  • NAR Revises Nonmember Broker/Appraiser Access Policy Language
  • MBA Mortgage applications increased 4.8 percent from one week earlier

Appraisers and Local Market Analysis

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

——————————————————

 

——————————————————-

The problem with comps in 2026 (and the good news)

By Ryan Lundquist

Excerpts: We have a problem with comps in real estate. There just aren’t that many, and it’s made it much more challenging to figure out value. Yet, this could get a little better in 2026.

WE’VE HAD A COMP PROBLEM FOR THREE YEARS:

We’ve been missing about 30% of the normal number of sales. This is true both locally and nationally. This chart from Calculated Risk shows the gravity of the situation as we’ve been flirting with historically low volume for three years now. And what this means is we’ve had 30% less comps to choose from. Yikes!! This is exactly why it’s been challenging to value properties.

THE BAD NEWS

We’re still poised to have historically low volume until there is a sharper change with affordability. The housing market simply feels stuck, and there isn’t a mechanism to quickly increase the number of buyers. In other words, it’s not going to be a market with robust volume for a long time since it’s going to take years to get buyers and sellers back. Yet, if the projection is correct about next year, it’s going to be something positive to get even a little more volume back. This isn’t standing ovation news, but maybe a golf clap is in order. And for my real estate friends, this is a solid reminder to stay focused.

SOMEONE WAS MAD AT ME FOR USING OLD COMPS

I had someone angry with me recently that I used much older sales as comps in a private appraisal. I tried to explain my rationale, but the person wasn’t willing to listen. Here’s the deal though. If there aren’t any recent comps, then we have two choices. Use older sales and adjust for how the market has changed, or go out further into other markets for more recent sales (doable, but not always ideal). In real estate textbooks, this issue doesn’t come up since there are always three model match sales over the past 90 days, but the real world is different. The truth is valuations today look a bit messy since we don’t have the luxury of ample recent sales. We simply have to do the best with what we have. Remember, when the market changes, how we do things sometimes has to change also.

To read more, Click Here

My comments: Some interesting appraiser comments. This is a hot topic for appraisers now. Definitely a problem in most areas. What is your market like?

Read more!!

Appraising with Inventory Shortages and Surpluses

Newz: UAD Quality Ratings,

Appraising with Inventory Shortages and Surpluses

December 5, 2025

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: When a Property Owner Wants to Do the Appraiser’s Job
  • Understanding UAD Quality Ratings (Updated for UAD 3.6 and the New URAR)
  • Gothic-Inspired ‘Fairytale Castle’ in Miami’s Exclusive Coconut Grove Michigan Hits the Market for $24 Million
  • Navigating the Challenges of Inventory Shortages and Surpluses in Real Estate: Insights from a Chief Appraiser at a National AMC By Jim Jenkins, Chief Appraiser
  • What Is a Scatter Chart Analysis in Appraisal?
  • 53% of U.S. homes lost value in the past year, the most since 2012 – Zillow
  • MBA:  Mortgage applications decreased 1.4 percent from one week earlier

————————————-

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

————————————————

—————————————-

Understanding UAD Quality Ratings (Updated for UAD 3.6 and the New URAR)

Excerpts: Quality ratings are one of the most familiar parts of UAD, but the way appraisers report them has changed under UAD 3.6 and the new dynamic Uniform Residential Appraisal Report (URAR). While the Q1–Q6 scale remains in place, the way you apply, support, and reconcile quality is more structured and data-driven than in the legacy forms.

What “Quality” Means in UAD 3.6

In UAD 3.6, quality represents the materials, craftsmanship, and construction standards of a dwelling. The familiar Q1 through Q6 framework still applies, but the workflow is different:

Quality is no longer a single, form-level checkbox.

You now provide quality ratings in multiple places:

  • Exterior Quality Rating (Dwelling Exterior section)
  • Interior Quality Rating (Unit Interior section)
  • Kitchen and Bathroom Detail tables
  • Overall Quality (reconciled in Section 15)
  • The “overall” rating is informed by the component-level data you report in these earlier sections.

Other topics include:

  • What Does UAD Stand For?
  • What Are the Quality of Construction Ratings?
  • Breaking Down the UAD Quality Ratings (Q1–Q6)
  • How Quality Is Applied in the New URAR
  • Tips for Applying Quality Ratings Credibly

Final Thoughts

Quality ratings remain an important part of UAD, but the approach is more precise now. UAD 3.6 pushes appraisers to rely on observable details rather than broad descriptions or market norms. When you follow the definitions, support your ratings with the structured data, and reconcile logically, the quality rating becomes a clear and defensible part of your analysis.

To read more, Click Here

My comments: Comprehensive and well written. Worth reading.

Read more!!

Fannie: Inspection and Reporting Tips UAD 3.6

Newz: Fannie: Inspection and Reporting Tips UAD 3.6, Appraising Haunted Houses

October 31, 2025

What’s in This Newsletter (In Order, Scroll Down)

  • LIA AD: Legal Request for Old Appraisal
  • Inspection and Reporting Tips for Appraiser Uniform Appraisal Dataset (UAD) Specification Issued by Fannie Mae and Freddie Mac
  • Penthouse One – 3 Story in Florida listed for $47,500,000
  • “No Name” Licenses, No Accountability: From Highways to Housing
  • Appraising Haunted Houses
  • Foolish Mortals or Bargain Buyers: 1 in 2 Americans Would Buy a ‘Haunted’ House for the Right Price
  • Mortgage applications increased 7.1 percent from one week earlier

—————————————————————————————-

Click here to subscribe to our FREE weekly appraiser email newsletter and get the latest appraisal news

—————————————————————————–


———————————————————-

Uniform Appraisal Dataset (UAD) Specification Issued by Fannie Mae and Freddie Mac

Document Version 1.0

October 21, 2025

Excerpts: Navigating changes to the appraisal process can be complex – make the transition to the Uniform Appraisal Dataset (UAD) 3.6 easier with the new Inspection and Reporting Tips for Appraisers guide. This resource clarifies key differences between the new Uniform Residential Appraisal Report (URAR) and legacy UAD 2.6 forms, providing the information you need when researching or physically inspecting a property.

The purpose of this document is to assist the appraiser by highlighting the notable differences between UAD 3.6 and UAD 2.6, and direct the appraiser to appropriate section(s) in the Uniform Residential Appraisal Report (URAR) Reference Guide on the Fannie Mae and Freddie Mac UAD web pages.

The document offers tips for different sections within the URAR that may be helpful to an individual who is completing various aspects of an appraisal assignment.

• Inspection Tips: When physically inspecting the property, or

• Reporting Tips: When researching and completing the URAR, including new information that may require research from a website, the homeowner, or other source.

Items to Note:

• When there are no material differences between UAD 3.6 and UAD 2.6 with respect to

information collected, those URAR sections are omitted from this document. For example, the

information collected for “Assignment Information” is not included below because it’s very similar between UAD 3.6 and UAD 2.6.

• Review the URAR Reference Guide chapters 22 through 24 to understand the dynamic nature of the grids (Sales Comparison, Rental Comparison, GRM Comparison).

To access the Inspection and Reporting Tips for Appraisers resource, Click Here.

My comments: Worth reading. The only document I have read that compares UAD 2.6 (current form reports) and UAD 3.6 in specific fields. Uses tables that make it easier to understand. Refers to F-1, the document that contains information on fields. Hopefully, when you are doing UAD 3.6 Reports, your software will pull in the relevant sections from F-1.

I have written 6 articles on UAD 3.6 in my paid monthly newsletter, including a list of what has changed on each page of the sample SFR1 (Single Family) report. The November newsletter includes an update on software vendors and where to get demos. None have completed their UAD 3.6 software, including verification by GSEs.

Read more!!