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!!

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!!

ADU vs. Two-Family Property for Appraisers

Newz: ADU vs. Two-Family Property,
Everyone Must Be Ready for UAD 3.6

November 21, 2025

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

  • LIA: Protecting My Appraisal Report
  • How to Identify a Single-Family with ADU vs. Two-Family Property
  • $1 Million Midcentury Modern Ranch House on Lake Michigan Holds a Wild Surprise in the Basement
  • Top Appraisers Advise on How to Generate New Business
  • When One Bulb Fails… Why Everyone Must Be Ready for UAD 3.6 By Tony Pistilli
  • A Real Estate Agent’s Guide to Understanding the New UAD 3.6 Appraisal Report By Tom Horn
  • MBA: Mortgage applications decreased 5.2 percent from one week earlier

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

SFR or 2 units with an ADU?

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


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

How to Identify a Single-Family with ADU vs. Two-Family Property

Excerpts: Across the country, accessory dwelling units (ADUs) are becoming more common. Cities and counties are updating zoning laws to encourage them, whether to increase housing supply, create affordable rental options, or allow families to live closer together. Appraisers need to understand how ADUs fit into their local markets, how they’re used and perceived, and how to properly distinguish them from true two-family properties.

The presence of an additional living unit can complicate the appraisal process by making it difficult for you, the appraiser, to know how to classify the subject property. How do you know whether you’re dealing with an accessory dwelling unit (ADU) or a second unit? In this article, you’ll learn about ADU meaning and types as well as how to identify a single-family with ADU vs. two-family property.

Topics include:

  • What Is an ADU?
  • Do ADUs Add Value to a Property?
  • Types of ADUs
  • What Is a Two-Family Property?
  • Is It a Single-Family with an ADU or Two-Family Property?

To read more and watch an ADU video, Click Here

My comments: Good explanations of ADU issues. Well done short video. UAD 3.6 requires including details on ADUs.

Read more!!

Fannie Mae’s Selling Guide Updates

Newz: Fannie Mae’s Selling Guide Updates, Appraisers and Certainty in Mortgage Lending

November 14, 2025

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

  • LIA: Conflicting Assignments and Professional Ethics
  • Beyond Terminology: What Fannie Mae’s Selling Guide Updates Mean for Appraisers
  • Genius’ Midcentury Modern Home Designed by Jimi Hendrix’s Studio Architect Lists in Woodstock for $3.5 Million
  • App-solutely Clueless: When Sales Tries to School Appraisers
  • Trump Defends 50-Year Mortgage Plan as ‘Not a Big Deal’ After Furious Backlash
  • The Strategic Advantage of Certainty in Mortgage Lending What it means for appraisals
  • MBA: Mortgage applications increased 0.6 percent from one week earlier

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

Changes to Fannie Selling Guide dated April 15, 2014

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

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

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

Beyond Terminology: What Fannie Mae’s Selling Guide Updates Mean for Appraisers

by Scott DiBiasio, Director of Government Affairs, Appraisal Institute

Excerpts: Fannie Mae recently issued important updates to its Selling Guide that may look like technical revisions but have significant implications for appraisers, consumers, and the valuation profession. The most visible changes involve the retirement of the term “appraisal waiver” in favor of “value acceptance” and adjustments to the Reconsideration of Value (ROV) process. Together, these changes reflect the GSEs’ modernization priorities—but also highlight the ongoing tension between efficiency and transparency.

From “Appraisal Waiver” to “Value Acceptance”

Fannie Mae has decided to eliminate the term “appraisal waiver” from the Selling Guide, replacing it entirely with “value acceptance.” Even the parenthetical “(appraisal waiver)” has been removed. The stated goal is to unify industry language and create consistency across the valuation spectrum.

That may sound harmless, but let’s be clear: the average consumer is not going to recognize that “value acceptance” means their lender has waived an appraisal altogether. That lack of clarity undermines transparency at a critical stage of the lending process.

The Appraisal Institute (AI) will absolutely continue to call these products what they are: appraisal waivers. Language matters. Consumers and appraisers alike deserve accuracy, not euphemisms, when it comes to understanding whether an independent appraisal has been performed.

Why This Matters for Appraisers

Taken together, the Selling Guide updates and the expansion of waiver-based models point to several key takeaways:

1. Language shapes perception. If consumers don’t recognize that value acceptance is an appraisal waiver, transparency suffers. That’s why AI will continue to call these products by their true name.

2. Efficiency is not clarity. Simplifying disclosures may ease compliance for lenders, but it risks reducing borrower awareness of their rights.

3. Modernization is accelerating. With waivers, UPDs, and hybrid appraisals expanding, appraisers must adapt their skills to remain at the center of the valuation process.

4. Incursion is real. Regulators, property data collectors, and third-party vendors are positioning themselves between appraisers and their clients. The profession cannot afford to cede ground.

To read more, Click Here

My comments: I had never read about what is discussed in this article. I don’t always read the Fannie Selling Guide Updates. Now I know why it is important.

When I wrote my article on Appraisal Regulatory Chaos in the monthly Appraisal Today newsletter, Scott let me include excerpts from what he has written about it plus sent me new information. This article has a few “promotional” comments about AI and classes, but well worth reading.

Read more!!

Bias in Appraisals. What Does It Mean?

Newz: Tariffs Effects on Home Building,
The Cupola and Its Cooling Comeback

October 17, 2025

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

  • LIA AD: Unreasonable Subpoena Request
  • California home built around giant boulder lists for $2 million
  • What’s That Box on the Roof? The Cupola and Its Cooling Comeback
  • Trump’s Tariffs on Lumber and Cabinetry Kick In, Hitting Homebuilding and Renovation
  • The Appraiser’s Guide to Evaluating Home Value Before You Buy
  • Mortgage applications decreased 1.8 percent from one week earlier

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

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

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

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

What does “bias” in appraisal really mean?

Hal Humphreys

and Peter Christensen Video

Excerpts: What constitutes “bias” in appraisal isn’t always what you expect, according to an attorney who handles cases involving appraisers.

Now let’s zoom in on bias. This topic does NOT inspire feelings of neutrality in the appraisal community. That non-neutrality comes out (a bit explosively) in comments threads and appraiser forums, and sometimes even in the classroom. I’ve sat in on several of Peter Christensen’s in-person classes on bias and fair housing law, and invariably somebody in class pushes back. Sometimes the air gets pretty hot and hostile. But Peter always handles the pushback with calm and aplomb. He hears folks out, responds respectfully, and steers the conversation back to his thesis — that bias exists, and it can take forms that we don’t necessarily expect.

In a brief interview I did with him (see the video below), he tells a story about a case he handled, in which an appraiser’s report was found to exhibit bias to a homeowner whose political views he loathed. Peter tells this story in his class, and it always surprises people, because they’ve seen this divide in their own lives and can imagine something like this actually happening.

I thought I knew what bias looked like, but I’ve begun to realize that it can creep in when we’re least expecting it. —Hal Humphreys

To read more and watch the video, Click Here

My comment: Interesting analysis. Very good video. Worth watching the video and reading the text.

Read more!!

Condo Prices, up/down/?? for Appraisals

Newz: NAR Calls Out Unregulated Middlemen (AMCs), Modular Construction?

October 10, 2025

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

  • LIA AD: Dealing with Unhappy Buyers as an Appraiser
  • Condo prices are obviously dropping, By Ryan Lundquist
  • Foreclosure Fixer-Uppers Ready for Their Next Chapter: 5 Abandoned Homes Offering a Bargain Deal to Buyers
  • The Modular Construction Revolution That Hasn’t Happened (Yet)

By Ivan Rupnik

  • NAR Calls Out Unregulated Middlemen: A Wake-Up Call for FHFA
  • When Appraisers Rally: Korea Sends the U.S. a Wake-Up Call
  • MBA Mortgage applications decreased 4.7 percent from one week earlier,

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

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

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

 


Condo prices are obviously dropping

By Ryan Lundquist

Excerpts: So many price graphs right now look pretty flat, but this condo scatter graph shows definitive declines, right? This is stunning to see, but it’s also not a shocker since the condo market has been hit harder over the past couple of years. Keep in mind I’m showing the entire county, and not every single subdivision will have the exact trend.

WHAT’S HAPPENING WITH CONDOS?

Buyers have been turned off lately with condos, and so much of it has to do with HOA fees rising and affecting purchasing power (see paragraph below). There can also be issues with obtaining financing. Moreover, SB326 is a new balcony law in California in 2025, and that’s also something we want to keep watching. Yet, the declines began before 2025, so don’t blame SB326 alone.

LOSING PURCHASING POWER IS A BIG PROBLEM – SEE GRAPHIC BELOW

Check out the huge difference in purchasing power between the following two properties. The monthly payment is the same for a $350K condo with a $600 monthly HOA fee and a $450K detached home without an HOA fee. While there is some advantage in having the HOA cover exterior maintenance or even having a gym on site, buyers are looking at the math, and the higher fee has been a roadblock for condos.

SUPPLY HAS GROWN FASTER WITH CONDOS

Condo supply has been growing at a faster pace all year than the detached market in Sacramento County. This is a good reminder that not all parts of the market are experiencing the same trend (key point). No wonder why prices have gone down at a quicker rate for condos, right?

To read more, Click Here

My comments: What’s happening in your market??

Over my 40 years appraising in my local market, condo markets are almost always different than the market for detached homes.

Many condos in my city are conversions of apartments built prior to 1970. Today, there are new condos are being built here and all over the Bay Area due to very high land prices. Across the street from my office are many 3-5 story new condos with a few attached townhomes. They are sorta boring and look the same. A marina is being converted to residential mostly. I had my business there for over 30 years and had to move as my office building was destroyed in the first year of Covid.

Read more!!

Q3 2025 Fannie Mae Appraiser Update

Q3 2025 Fannie Mae Appraiser Update, When Sales are not Comps

September 26, 2025

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

  • LIA AD: When a Property Owner Wants to Do the Appraiser’s Job
  • Q3 2025 Fannie Mae Appraiser Update
  • 14 Mile Island House: $10.8 Million Historical Estate on a Private Island in New York Is Listed for Sale for the First Time in 60 Years
  • It’s the Right Time By Jeff Bradford, Founder and CEO of Bradford Technologies
  • Sales Don’t Always Become Comps By Ryan Lundquist
  • Is Commercial Property Appraisal Right for You?
  • Mortgage applications increased 0.6 percent from one week earlier
    —————————————————————————
  • Humor for Appraisers

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

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

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

Q3 2025 Fannie Mae Appraiser Update

Excerpts: In this edition, we share information and resources to help you navigate recently announced changes.

Perhaps the most significant appraisal policy change in recent memory is the launch of the new Uniform Appraisal Dataset (UAD) 3.6. In this edition we continue to unpack UAD 3.6 changes with the Update Report and the Completion Report.

To help with UAD 3.6 implementation, we have created a tool for appraisers to check their reports for UAD 3.6 compliance.

We also review recent Selling Guide changes related to reconsideration of value (ROV). Speaking of the Selling Guide, we provide some tips on how to make the most of this important resource for appraisers and we highlight changes to our ANSI fact sheet.

Topic LIst

  • Restricted Appraisal Update and Completion Reports
  • Comp driveby not required for UAD 3.6
  • UAD 3.6 compliance checker
  • Reconsideration of Value update
  • Stay up to date on Selling Guide changes

My comments: No more driving comps is a big change and is somewhat controversial for appraisers. Will lenders who don’t require UAD 3.6 drop the comp inspection requirement?

To read more, Click Here

Read more!!

Appraisal Clipboards and UAD 3.6

Newz: Concessions, Clipboards in Appraisals?

September 19, 2025

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

    • LIA AD: Protecting My Appraisal Report
    • Robots in Surgery, Clipboards in Appraisals: A Tale of Two Professions
    • Custom Barndominium ‘Like No Other’ With Hobby Farm and Room for Helipad Hits the Market for $12.5 Million
    • Concessions: Sellers are struggling to listen to the market by Ryan Lundquist
    • Do Nearby Home Sales Affect My Home’s Value? By Tom Horn
    • The Short-Term Rental Dilemma by JoAnn Apostol
    • Mortgage applications increased 29.7 percent from  one week earlier

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

Dear Clipboard and Measuring Wheel – A Walk Down Memory Lane

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

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

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

Robots in Surgery, Clipboards in Appraisals:
A Tale of Two Professions

By Tony Pistilli

September 15, 2025

Excerpts: In the distant past, a doctor could build a career practicing medicine in much the same way for decades. But today, with the rapid pace of medical advancement, it means doctors who refuse to adopt new technologies either retire early, find their practices so limited that they cannot effectively compete or fade away into irrelevance.

The technological toolbox available to doctors today is full and growing. Consider just a few of these examples.

Robots allow doctors to perform minimally invasive procedures with greater precision, fewer complications, and faster recovery times. Surgeons control the robot’s every movement, combining human judgment with precision accuracy.

Doctors vs. Real Estate Appraisers

Of course there had to be a correlation to appraisers!  In summary, doctors have largely embraced technology, reshaping their profession and improving outcomes for millions of people around the world.

Contrast that with real estate appraisers.

While doctors are saving lives with robotic tools, appraisers are often still clinging to their clipboards, tape measures and manual data entry. While physicians have adopted telemedicine to expand their reach, many appraisers have resisted bifurcation that could streamline valuation processes and bring more work and ultimately more revenue.

To read more, Click Here

My comments: Interesting analysis. A few years ago, I had major surgery where robotics were used. I was worried, but when I research robotics I found out that they can work very well. And that the robots were not doing the surgery! My surgeon determined what the robots did by the surgeon manipulating the surgical instruments in an external device to do the surgery.

UAD 3.6 is coming. Using a tablet app in the field to collect data can really help. What if you don’t want to use an app and want to use a clipboard? I spoke with a software vendor recently who will have paper check lists of what data and photos are needed when using a clipboard.

Read more!!

Appraiser-Client Relationships for Appraisers

Newz: WA appraisers fee hikes, AI and an appraiser defense

June 20, 2025

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

  • LIA Ad: Protecting My Appraisal Report
  • How to Build Strong Appraiser-Client Relationships
  • Cardiologist Lists Glass Mansion in Jackson Hole for $60 Million
  • WA Appraisers Stung by Fee Hikes and Veto
  • FOIA, AI, & the Appraiser’s Defense: A Blueprint for Fighting Back
  • MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey

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

Real Estate Agents and Comparable Sales – Tips for Appraisers

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

 

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

 

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

How to Build Strong Appraiser-Client Relationships

Excerpts: The most successful appraisers are those who consistently bring in new clients. Are you looking to earn more referrals and repeat business? Start by fostering good relationships with your appraisal customers. Taking the time and effort to build strong appraiser-client relationships is a great way to establish a good reputation and distinguish yourself from the competition so that you can easily generate new business through client referrals and word-of-mouth.

Not sure where to begin? To help you out, we asked our community of real estate appraisers, “Which is MOST important for building strong appraiser-client relationships?” Read their responses below for insights into several effective strategies you can use to keep your customers happy and keep business flowing.

Produce credible, high-quality work (47%)

Have clear communication (20%)

Be courteous and professional (11%)

Deliver reports on time (7%)

Go above and beyond (4%)

Other (7%)

To read more, Click Here

My comments: Worth reading the appraiser comments.

Read more!!

Pending Sales for Appraisers

Newz: PAVE Problems, Outdated Mortgage Regulations

May 30, 2025

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

  • LIA ad: Should I Complete this Assignment?
  • Pending Sales May Be Your Secret Weapon To Accurate Listings and Appraisals
  • $3.69 Million ‘Tron’-Inspired Mansion With ’80s Speakeasy and Ferrari-Themed Office
  • The Full Measure: May 2025 Housing Market Recap for Appraisers
  • TEAPOTS Exposed: The PAVE Initiative’s Illusion of Justice
  • Outdated Mortgage Regulations
  • Mortgage applications decreased 1.2 percent from one week earlier

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

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

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

Pending Sales May Be Your Secret Weapon To Accurate Listings and Appraisals

Excerpts: Bottom line: Pending sales show you what’s happening now and where prices are headed. Skip them, and you’re stuck looking at yesterday instead of today.

Closed Sales Lag—Pendings Lead

The Built‑In Delay

  • A March 1 contract might not close until late April. By then:
  • Rates could move 50–75 basis points.
  • A new round of housing inventory could hit the market.
  • Economic news—jobs reports and inflation scares can spook buyers.

Appraiser’s View: How We Use Pending Sales (Even When We’re Handcuffed to Closings)

Time adjustments

Compare contract prices to 30‑60‑day‑old closings to justify ± market‑trend tweaks. If pendings are 3 % higher, you can show upward pressure — great ammo for your list price.

Feature bracketing

No pool comps closed? A pool home pending $25 k higher becomes my clue. Helps you price premium features correctly.

To read more, Click Here

My comments: Good discussion of many aspects of using pendings. Written for real estate agents, but many good tips for appraisers. I always look at pendings, including the ratio of pendings to listings. I got some good ideas from this blog post.  I have been appraising for 50 years. I like learning something new!

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

$3.69 Million ‘Tron’-Inspired Mansion With ’80s Speakeasy and Ferrari-Themed Office

Excerpts: 3 bedrooms, 3.5 baths, 4,853 sq.ft., 8,509 sq.ft. lot

Futuristic, three-bedroom mansion that was inspired by the hit 2010 sci-fi movie “Tron: Legacy” has made a high-speed return to the market in Dallas, where it is listed for $3.69 million.

The decked-out dwelling, which also boasts an auto showroom in the living room and a Ferrari-themed home office, has been driven right to the top of the week’s most popular home’s list, after pulling in a huge amount of interest from buyers thanks to its very unique aesthetic.

Opulence abounds in every room of the property, which is spread across 4,853 square feet and includes a 1980s speakeasy with “turquoise tufted walls,” as well as a dramatic two-story living room with soaring ceilings.

To see the listing with 40 photos and a virtual tour, Click Here

My comments: See the wild interior photos with Ferraris and many unusual features!

Read more!!