Shopping Cart    
Search
   
Residential Applications: Using Technology to Measure and Support Assignment Results Education Schedule (PDF)
Education Catalog (PDF)
Some AI educational programs may not be approved in every state.
Students should check state approvals prior to registering for any Appraisal Institute program.

ClassroomOn-Demand Online EducationLive Online (Synchronous)

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

Prerequisites
• 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

Program Overview
• Table of Contents and Overview (PDF)
• Schedule (PDF)

Type
Residential

Ordering Information
To order books and other materials go to
our store

Tuition
Please contact the sponsoring chapter for information on fees applicable to chapter programs.

Required
None Specified.

AI CE Credit for Designated Members and Practicing Affiliates
Attend Only = 75 points

Level
Intermediate

Click Here for State Approvals


  
Class Schedule & Location







Pop up content here.

Agree Disagree