Choose your path
Find An Appraiser         Online Store         Donate         Lum Library         Join
 View Cart View Cart
0 Registrations in Cart
Appraisal Institute  
AI Resources Education Publications Professional Practice News Advocacy About Us
Select an Offering

Residential Applications Part 1: Using Technology to Measure and Support Assignment Results

    Date: June 3, 2019   Location: Chicago, IL
Category  Residential [Res]  
Level  Intermediate  
Attendance Hours  7.0  
Current Price  $ 145.00 AI Price  
$ 165.00 Full Price  
Mark V. Smeltzer, MAI, SRA, AI-RRS  
Name  Chicago Chapter  
Rep  L A  
Address  205 W Wacker #202  
City  Chicago  
State  IL  
Zip  60606  
Phone  (312) 616-9400  
Click Here to check state approvals
  Sponsor / Contact  
Chapter  Chicago
Contact Name  L.A. Anderson  
Phone  (312) 616-9406  
Fax  (312) 616-9404  

Fannie Mae's new Collateral Underwriter (CU) requirement requires residential appraisers to prove their adjustments.
This seminar provides the knowledge needed to do just that!

"I created this pivot table in less than 10 minutes to prove a swimming pool adjustment. Supporting my adjustments is much easier now that I attended the Residential Applications seminar and learned to use Excel with data downloaded from the MLS."
Sandy Adomatis, SRA

"The seminar is exactly what residential appraisers need today to understand how CU works, since it explains linear regression using their own MLS data combined with Excel. It gives them the tools to use regression in their own markets to understand what Fannie Mae's CU will be generating for typical adjustments."
Craig Steinley, SRA, AI-RRS

This seminar provides easy-to-use, highly efficient tools to supplement and enhance the traditional methods of adjustment and support through the use of technology. You will gain practical, hands-on, step-by-step training on how to use charts, graphs, spreadsheets, and pivot tables to support residential assignment results for market conditions; days on market; sales-to-list price ratio; adjustments for location, design, quality of construction, and other property amenities; market extraction for cost and depreciation estimates; and market extraction for market rent and gross rent multipliers.

Upon completion of the seminar, participants should be able to:
• Recognize the connection between statistics and residential appraising
• Apply graphic analysis to solve and support market analysis issues
• Apply graphic analysis to support conclusions for the three approaches to value
• Apply Excel techniques to analyze data that can be imported into the Fannie Mae 1004MC appraisal report form

• Basic level of knowledge of spreadsheets, especially Excel, obtained from seminars such as Using Spreadsheet Programs in Real Estate Appraisals—The Basics or Thinking Outside the Form: Tools, Techniques, and Opportunities for Residential Appraising
• Experience in market analysis, highest and best use, and inferred market analysis

Recommended Equipment
• Laptop
• Microsoft Excel 2007 or 2010 loaded and operational. Apple MacBook will need the latest version of Excel (2011). Solver Add-in and Analysis Tool Pak Add-in installed prior to class. Download a trial copy of Excel by clicking here.
• The registration e-mail confirmation will provide a secure link to download Excel files to upload for in-class exercises.

Recommended Texts
An Introduction to Statistics for Appraisers
Appraising Residential Properties,4th ed.
Practical Applications in Appraisal Valuation Modeling
The Appraisal of Real Estate, 14th ed.
Visual Valuation: Implementing Valuation Modeling and Geographic Information Solutions
This seminar addresses Fannie Mae’s new CU requirement!
Cancellation Policy
  • $50.00 cancellation fee.
  • Less than 2 days prior to program start date, forfeit of payment.
  Transfer Policy
  • $50.00 transfer fee.
  • Less than 2 days prior to program start date, no transfer allowed.
The State and the AQB requires that you be in class 100% of the time. You will not receive credit if you don't fulfill this requirement

Program materials can be downloaded by the student.
  Additional Information  
class registration May 22 8:00am class lecture 8:30-4:30

Hotel Reservation: Crowne Plaza Chicago West Loop



Appraisal Institute
200 W. Madison, Suite 1500, Chicago, IL 60606
888-7JOINAI (756-4624)  |
Contact Us   |   Site Map   |   Terms & Conditions   |   Privacy Policy   |   Advertise
  Copyright © 2017 Appraisal Institute. All rights reserved.