5 Excel Resources and How-To Guides for Appraisers

By on January 9, 2026   /   appraisal business, appraisal charts and graphs, forecast, state appraiser regulators, USPAP   /   Leave a comment
Tags: , , ,

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

Back to Top

Appraisal Adjustments

By on August 29, 2025   /   adjustments, appraisal how to, FHA, liability, New URAR, UAD, UAD 3.6, USPAP   /   Leave a comment
Tags: , , , ,

Newz: Appraisal Adjustments, How Freddie and Fannie Inflated Home Prices, FHA to Adopt UAD 3.6

August 29, 2025

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

  • LIA AD Navigating Value Revisions in Appraisals
  • Appraisal Adjustments: Types, Methods, and Cheat Sheet Appraisal By Kevin Hecht
  • Inside Artificial Heart Inventor’s $4.8 Million Midcentury Modern Salt Lake City Utah Home
  • Inflated Prices, Taxed to Death, by Jeremy Bagott
  • Can the direction a home faces affect its value? By Ryan Lundquist
  • The Competence to Perform an Assignment, by Timothy C. Andersen, MAI
  • FHA to adopt UAD 3.6
  • MBA: Mortgage applications decreased 0.5 percent from one week earlier

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

Time Adjustment Changes for Appraisers

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

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

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

Appraisal Adjustments: Types, Methods, and Cheat Sheet Appraisal By Kevin Hecht

Excerpts:

Types of Appraisal Adjustments

Appraisal adjustments can take several forms, depending on the property characteristics being compared. Each type of adjustment addresses a different element that may influence value. Below are descriptions of common adjustment categories and their uses, followed by a “cheat sheet” chart with examples.

  • Qualitative Adjustments
  • Quantitative Adjustments
  • Transactional Adjustments
  • Market Conditions Adjustments
  • Property Adjustments
  • Locational Adjustments

Common Methods for Making Appraisal Adjustments

A long list, from matched paired sales to Cost Analysis

Appraiser Survey: What’s Your Go-To Method for Adjustments?

Paired sales/matched pair analysis (Most popular answer!)

“I typically cover rural areas where sales are scarce and there is not enough data for meaningful statistical analysis to be performed. Due to this, paired sales analysis is the most reasonable and defensible analysis position available.”

“I use linear regression to understand market changes and to calculate any necessary market change adjustments.”

“Depends on what item is being adjusted. If it is site or GLA, it is usually a percentage of the per acre or per square foot sales price. Other items are usually paired sales analysis or consideration for depreciated cost.”

To read more, Click Here

My comments: Comprehensive lists and interesting appraiser comments. I quit doing grid dollar adjustments many years ago. A person from our state regulator, speaking at a local appraisal meeting, said they would require support for all adjustments. I started by doing Plus and Minus grid adjustments and then went to “total property comparison” with a value. I do a qualitative analysis comparing the comps.

The only supported dollar adjustments I make are for market conditions and high dollar features such as a fantastic view of the Golden Gate Bridge from very high up a hill.

Inside Artificial Heart Inventor’s $4.8 Million Midcentury Modern Salt Lake City Utah Home

Excerpts: 4 bedrooms, 4.5 baths, 5,447 sq.ft., 0.55 acre lot, built in 1957

The mastermind behind the one-of-a-kind estate was none other than Swiss architect Eduard Dreier, who brought Bauhaus principles to the modernist movements of Utah and Nevada.

Lovingly restored and awarded the Utah Heritage Award for Restoration and Renovation, this 5, 447 sq ft architectural gem blends timeless Dreier elements-exposed steel beams, walls of glass and cantilevered roof line, granite rock walls-with warm modern luxury. The 1,110 sq ft glass-and-steel attached guest house, designed by Dreier protge Brent Groesbeck in 2016, floats above the main home, expanding living where entertaining is elevated to an art form.

To read more, Click Here

To see the listing with 43 photos and a video tour, Click Here

Read more!! →

Back to Top

Appraisal Cost Approach and Highest and Best Use

By on November 16, 2024   /   AI, appraisal, appraisal how to, cost approach, Economic analysis, forecast, future, Highest and Best Use, liability, USPAP, zillow   /   Leave a comment
Tags: , , , ,

Newz: Now What For Appraisers After Election? Generative AI and adjustments?

November 15, 2024

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

  • (LIA ad) Intended Use and User
  • 10 Questions on the Cost Approach and Highest and Best Use
  • A Real-Life ‘Yellowstone’: Historic 52,000-AcreArizona Ranch Hits the Market for $42 Million—Complete With a Private Airstrip and Off-Grid Cabin
  • Now What? On a New Trump Administration
  • Can Generative AI solve the adjustment support paradigm
  • How Deep Fakes Have Burrowed Into Home Finance
  • Murder in the flying saucer: inside The Chemosphere in Los Angeles, CA
  • Mortgage applications increased 0.5 percent from one week earlier
  • So Many Appraisal Cost Approach Questions
  • Appraisal Business Tips 
    Humor for Appraisers


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

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

10 Questions on the Cost Approach and Highest and Best Use

By Timothy Andersen

Excerpts: It is clear most appraisers do not like to perform the analytics inherent in the Cost Approach. This may be because most appraisers simply do not appreciate its power. Consider these 10 Cost Approach questions.

10 QUESTIONS TO CONSIDER

Take a look at these 10 questions on the Cost approach (and various items related to it). After you are finished, you will still not like to do it. But you may appreciate its analytical and interpretative powers even more.

1. On the 1004 form is the indication that Fannie Mae does not require the Cost Approach to Value. However, where does the form instruct the appraiser not to complete the analytics of the Cost approach? (Spoiler Alert: It does not.)

2.   Instructions on the form state the appraiser is to “…[p]rovide adequate information to the lender/client to replicate the [herein] cost figures and calculations.” However, where does the typical appraiser provide such replicable information?

3. In addition, the reporting form requires the appraiser to “…[s]upport the opinion of site value [with a] summary of comparable land sales or other methods for estimating site value.” Nevertheless, where does the typical appraiser provide such summary information?…

So, it is clear from these Fannie Mae instructions that the appraisal of a SFR includes an analysis and valuation of the subject site separate from the valuation of the site as improved. Does this mean to conclude a site value as if the subject site were vacant and available to be put to its highest and best use? (Spoiler Alert: Yes, it does.)

To read all 10 Q&As, Click Here

My comments: Of course, for custom home construction the Cost Approach is required to determine the feasibility of construction before building the home. I got some good ideas on using the Cost Approach from this article.

Read more!! →

Back to Top

Why Appraisal Workfiles Are Important

By on April 5, 2024   /   appraisal business, bias, Economic analysis, USPAP, waivers   /   Leave a comment
Tags: , ,

Why an Organized Workfile is Your Best Defense

By Craig Capilla

Excerpts: We all know that the Uniform Standards of Professional Appraisal Practice (USPAP) set the baseline for what must be included in a workfile. We’ve all also heard ad nauseum that USPAP is a minimum standard. Still, all too many appraisers seek only to meet that minimum standard and little more. That’s where the trouble begins. Particularly when speaking about the workfile, for my money, the most dangerous words in USPAP are “or references to the location(s) of such other data, information, and documentation.” There it is, right there in plain English: USPAP permits appraisers to maintain a reference to the data, information, and documentation considered as a part of the assignment, and the appraiser is NOT obligated to keep a contemporaneous copy of those items.

That minimum standard is all well and fine until one day many months later, when an enforcement agency demands that the appraiser produce that information, usually on a tight timeline, and the information is no longer available or the source now shows different information than what was available at the time of the assignment.

Believe me when I tell you that it is not a good feeling when a regulator asks you to explain why you didn’t consider a particular piece of information, and you cannot summon an answer. Similarly, there are few things more liberating than producing a document that shows the information you are being asked about was not available to you at the time you performed the assignment. I’ve seen this happen. Systems fail. MLS aggregators have software glitches. Public record updates at its own pace. And sometimes, that one crucial piece of information isn’t there anymore when you need it.

To read more, Click Here

My comments: The article also discusses bias. Capilla is an attorney who defends appraisers. Newer appraisers are lucky. Scanning work files is easy. I started appraising before the Internet and easy scanning and filing. My office and home garage are filled up with paper files! I have PDF copies of all the appraisals I have done as a fee appraiser on my main computer, except those done before PDFs were available.

Appraisal Business Tips 

Humor for Appraisers

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

NOTE: Please scroll down to read the other topics in this long blog post on appraiser discrimination lawsuit, waivers, staying positive with slow business, appraiser’s economic forecast, unusual homes, mortgage origination stats, etc.

Read more!! →

Back to Top

How To Appraise Rural Properties

By on March 15, 2024   /   appraisal business, appraisal how to, modernization, Uncategorized, USPAP   /   Leave a comment
Tags: , , ,

How To Appraise Rural Properties

Excerpts: Appraising residential properties in rural areas can be both challenging and rewarding. Unlike the standardized expectations of urban and suburban properties, rural properties often present unique characteristics that require a nuanced approach to valuation. Whether you’re a seasoned appraiser or new to the field, having a better understanding of rural properties is essential for providing credible appraisals. In this guide, we’ll explore what defines a rural property, the challenges appraisers face, reasons for conducting rural appraisals, strategies for finding comparables, and tips for writing a compliant appraisal report.

  • Defining rural properties – USDA and GSEs
  • Challenges of appraising rural properties
  • Appraising rural properties presents unique challenges due to their diverse characteristics and market dynamics.

Topics include:

  • Diverse property types and uses
  • Unique property characteristics
  • Limited market activity and more
  • Writing your rural property appraisal report – good ideas

To read more, click here

My comments: Worth reading, if only to find out about rural appraising. Well written. There are relatively few residential lender appraisals available now. This is an excellent diversification opportunity, with little competition from other appraisers or the GSEs use of other ways to get a value without human appraisers.

What if there are few rural areas near you?

You can expand your area to include rural appraisals to get more business.

When I worked for a northern California assessor’s office with rural areas I learned a lot about almond growing (the main crop) and other ag topics. It is not hard to learn the valuation factors. I had niece who had several horses for many years where she lived. There are equestrian facilities within 5 miles from my house in Oakland hills and in farther out Bay Area cities with larger lots. You may have some similar rural experience now!

The American Society of Farm Managers and Rural Appraisers www.asfmra.org has a specialty in Rural Appraising, but it requires a Certified General. There may be seminars available. Another reason for upgrading!

Urban, Suburban, Rural in Appraisals

Appraisal Business Tips 

Humor for Appraisers

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

NOTE: Please scroll down to read the other topics in this long blog post on USPAP and Personal Inspection, GSE Appraisal Modernization, Transaction costs and values including real estate commissions, unusual homes, mortgage origination stats, etc.

==============================================

Read more!! →

Back to Top

What level appraiser are you?

By on October 13, 2023   /   appraisal business, Highest and Best Use, USPAP, zillow   /   Leave a comment
Tags: , , ,

How to Level Up as an Appraiser

By Conrad Meertins Jr.

Excerpts: The key is not the letters but the competency or skill. For example, are you competent to prepare an entire appraisal from start to finish? You might answer, “Absolutely!” But what if the appraisal form was completely blank with no boilerplate text? Do you still feel the same level of assuredness? What if you could not use the URAR form at all, but still had to produce an appraisal report that could stand up in court? Are your legs shaking? These questions help us to start to gauge our current level.

The three levels that we are going to discuss are “Beginner,” “Intermediate,” and “Pro.” Now, we could go deep and say that there are levels within the levels, but for now we will keep it simple and explore these three main levels. Some view each level as a stepping stone, and some view each level as a permanent parking space. It’s your choice which level you choose to pursue. The goal here is for us to evaluate which level we are at and determine which level we want to achieve.

Level 1 – Beginner

This is where we all start. There is no shame in this level. Depending on how you were trained, at the beginner level you typically view appraisals as forms — forms with checkboxes to be checked or left blank. If all the right boxes are checked and your report is signed with a value, mission accomplished!

Level 2 – Intermediate

At the intermediate level, you realize there is more to appraising real estate than checking boxes. Here is where you provide more explanations. If you say the market is stable, perhaps you add a sentence or two to expound on that. If you say that comp #1 was the best comp, you add a sentence explaining why. If you don’t adjust for the subject being on a busy road, you add a sentence about the neutral impact of the busy road and a comparable to support that conclusion—before being prompted to do so by the underwriter.

Level 3 – Pro

There is a subtle difference between Level 2 and Level 3. But one indicator that you have crossed the line from intermediate to pro is understanding how all the pieces fit together. For example, you understand that you do not need a form to produce an appraisal.

To read more, click here

My comments: Hybrid Appraisals are coming fast for lender appraisals, when any “human” appraisals are done. Full appraisals that Level 1 and most Level 2 appraisers cannot do will be done by Level 3 appraisers. I am writing two long articles for the November issue about Hybrid Desktops and Property Data Collectors. Both positive and negative sides for appraisers. If you want to continue to do AMC appraisals, this is an option.

What if you don’t want to do either one? If you have done AMC lender appraising only, you only appraise homes that conform to GSE requirements. You have a low skill level.

If I did lender work now, I would be in the “top tier” to be called when other appraisers said no. For as long as I have been appraising, lenders had special lists for the tough ones, or for a valuable bank client that borrows money from the bank and has large deposits.

Appraisal Business Tips 

Humor for Appraisers

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

NOTE: Please scroll down to read the other topics in this long blog post on  retirement, USPAP 2024 Changes, school district app, unusual homes, mortgage origination and more!

Read more!! →

Back to Top

2024 USPAP For Appraisers

By on October 6, 2023   /   adjustments, appraisal how to, Economic analysis, Fannie, hybrid appraisals, non-lender appraisals, real estate market, USPAP   /   Leave a comment
Tags: , , , , ,

2024 USPAP

Source: Appraisal Foundation

The 2024 Uniform Standards of Professional Appraisal Practice is now available for purchase in physical and digital formats.

This year, for the first time, you can purchase just the book of USPAP standards for $35. This covers all Definitions, Rules, and Standards.

We also have a new product launching this year. All Advisory Opinions, Frequently Asked Questions and the recently launched Reference Manual will now be part of a standalone publication called the 2024 USPAP Guidance and Reference Manual.

This change reflects the maturation of USPAP, resulting in longer effective dates. The ASB will continue to review USPAP for changes when necessary but will shift much of its focus to providing more guidance to the marketplace. Appraisers can now buy one set of USPAP standards and keep that publication on their bookshelf for as long as that edition is effective and purchase just the Guidance and Reference Manual as needed for coursework and updates.

If you like having the USPAP standards and guidance material linked, we still have you covered. You can also purchase a linked digital version of the eUSPAP and Guidance and Reference Manual and get seamless access across both documents.

To read the full letter, click here

My comments: USPAP 2024 is effective January 1, 2024. I’ve been waiting for a very long time for longer than 2 years between effective dates. Also, there is no ending date for the 2024 version.

When USPAP started, it was very exciting as appraisers had to decide what needed to be changed or added. Lots of people wanted to be on the ASB. Over time, I quit following the updates as there were few significant changes.

2024-2025 USPAP 7-Hour Update Course is being approved or is approved, in the states. I assume a new class will be required every two years in the future. Gotta keep that money coming into the Appraisal Foundation, I guess…

I really hated the classes when there was not much to say except a rehash of the past. I taught USPAP before the ASB told you what to teach. It was my favorite class as we could focus on issues in our current market. Of course, now there is appraiser discrimination, the current hot topic. Personally, I think there is very, very little intentional discrimination by appraisers, compared with the intentional discrimination by lenders (and others). “Red Lining” still exists, some are in the same locations.

=====================================================

Appraisal Business Tips 

Humor for Appraisers

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

NOTE: Please scroll down to read the other topics in this long blog post on  non-lender appraisals, economics analysis, Fannie getting rid of appraisers?, unusual homes, mortgage origination

Read more!! →

Back to Top

The End of Lender Appraisals?

By on August 4, 2023   /   appraisal business, bias, real estate market, USPAP   /   Leave a comment
Tags: , , ,

The End of Home Appraisals?

By Jeremy Bagott, MAI

Excerpts: In his 1946 essay “Politics and the English Language,” the late British novelist, essayist and critic George Orwell examined the connection between political orthodoxies and the debasement of the English language. In a truly Orwellian move, mortgage giant Freddie Mac recently announced its intent to censor an arbitrary collection of words such as “desirable,” “safe,” “well-kept,” “student” and “crime” when they appear, in any context, in the hundreds of thousands of appraisal reports it relies on in mortgage underwriting. It would be hard to make this up.

As with all banned words, Freddie’s list will lead to the need to ban additional words over time as appraisers, expunging the word “desirable,” will find synonyms when analyzing market reaction to the views of two homes or to the cul-de-sac location of a home versus the midblock location of a comparable. When discussing how market participants view side-by-side school districts, appraisers will figure out they can use synonyms like “advantageous,” “preferable,” or “beneficial” instead. Soon, these words, too, will need to be banned. In a college town, the banned word “students” will become “matriculants,” a word that will likewise need to be banned.

The attack on the protected speech of independent appraisers erodes their ability to describe how the properties they appraise relate to the preferences of market participants. The censorship is part of a march toward what appraiser and podcaster Phil Crawford has coined “universal basic home value” – a utopian vision among idealogues in which government technocrats dictate the supposed value of a property using algorithms and machine learning. The censorship began with Fannie Mae, and has now predictably spread to Freddie Mac.

To read more plus appraiser comments, click here

My comment: Worth reading. Lots more AMC/lender appraisal correction requests. Last week’s email had a discussion of the “words” which got a lot of clicks by appraisers wanting more information.

The Future of Residential Lender Appraisers

Appraisal Business Tips 

Humor for Appraisers

Fannie: Words and Phrases in Appraisals

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

NOTE: Please scroll down to read the other topics in this long blog post on non lender appraisals, USPAP, Bias, real estate market, mortgage rates, unusual homes, mortgage origination

 

Read more!! →

Back to Top

FHA: Cosmetic vs. MPR Repairs

By on May 26, 2023   /   bad appraisers, bias, FHA, lender appraisals, USPAP   /   Leave a comment
Tags: , , ,

Cosmetic vs. MPR Repairs: Guidance for FHA Appraisers

By: McKissock

Excerpts: If you are appraising a property that needs some cosmetic repairs but meets FHA minimum property requirements (MPR) in its current condition, you should make the appraisal “as-is.” Here is some guidance on cosmetic repairs vs. MPR repairs.

Topics include:

  • When can an FHA appraisal be completed “as-is” vs. “subject to”?
  • Cosmetic repairs Examples
  • MPR repairs Examples
  • Conditions that require inspection Examples

To read more, click here

My comments: If you do FHA appraisals, read this blog post. Photos and lots of examples. I quit doing FHA appraisals in the mid-1980s because of the inspection requirements compared to conventional appraisals, that did not have the requirement.

Appraisal Business Tips 

Humor for Appraisers

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

NOTE: Please scroll down to read the other topics in this long blog post on appraisal “modernization”, bias hearing, bad appraiser, USPAP, unusual homes, mortgage origination stats, etc.

To read more of this long blog post with many topics, click Read More Below!!

Read more!! →

Back to Top

Appraiser Professional Goals

By on January 4, 2023   /   non-lender appraisals, real estate market, USPAP   /   Leave a comment
Tags: , ,

1-6-23 NEWSLETTER

Appraisers Share Their Top Professional Goals for 2023

By: McKissock (Survey)

Excerpts:

  • Maintain my current business (26%)
  • Earn a designation or certification (16%)
  • Grow my business (15%)
  • Prepare for retirement (12%)

“I would like to turn over my appraisal business to my daughter, who is certified.”

Should have retired last year but put it off due to the high amount of requests!”

After 23 years in appraising, which was very beneficial for me and my customers, I’m preparing for retirement.”

  • Achieve a better work-life balance (10%)
  • Other (6%)

To read more, including personal comments from appraisers, click here.

My comments: The post has links to some topics above with many tips. I have recently been writing about many of these topics since the market changed.

I write about non-lender work, staying up when business is down, retirement planning, and more in my monthly newsletter. I will be writing soon about upgrading to Certified General. I have always done both commercial and residential. My business has been much more stable as I can shift between them when the appraisal markets change, especially fees.

What are you planning to do in 2023? Now is the time to learn all the features in your MLS and forms software, upgrade your skills by taking seminars and classes, and more.

The future of residential appraising

Appraisal Business Tips 

Humor for Appraisers

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

To read more of this long blog post with many topics, click Read More Below!!

NOTE: Please scroll down to read the other topics in this long blog post on USPAP and non-traditional appraisals, Non-lender appraisals, reos, tear downs, unusual homes, mortgage origination stats, etc.

Read more!! →

Back to Top