Residential Applications: Using Technology to Measure and Support Assignment Results

Some AI educational programs may not be approved in every state.

Students should check state approvals prior to registering for any Appraisal Institute program.

To register for this program, go to the bottom of the page.



Who should enroll Residential real property appraisers
Description This seminar provides easy-to-use, highly efficient technological tools to supplement and enhance the traditional methods of adjustment and support. 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; sale-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.

 

Objectives
  • Recognize the connection between statistics and residential appraising.
  • Apply graphic analysis to support market analysis conclusions.
  • 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


Refer to this page for details of state approval hours for this course.

  • Attended Only:

    75
  • Attended Only:

    75
  • Attended Only:

    75
7 hours
Yes. After you register for this class, please go to your Education and Events page for
details on what you must complete BEFORE class begins.
 
To access your Education and Events page, log on to the Appraisal Institute website at https://ai.appraisalinstitute.org/eweb (click on the three horizontal lines to the left of the AI logo and select “My
AI Account” from the drop-down menu).
 
No
N/A
Intermediate
  • A laptop computer is required.
  • Microsoft Excel 2007 or 2010 with Solver Add-in and Analysis Tool Pak Add-in must be installed prior to class. Download a trial copy of Excel by clicking here.
  • Note to Mac users: Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2008 or Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here for 2008 or click here for 2011.
  • You must be familiar with basic Excel operation when the seminar begins. Do not enroll expecting to be taught how to use Excel.
  • The registration email confirmation will provide a secure link to download Excel files for in-class exercises.

 
N/A
  • A laptop computer is required.
  • Microsoft Excel 2007 or 2010 with Solver Add-in and Analysis Tool Pak Add-in must be installed prior to class. Download a trial copy of Excel by clicking here.
  • Note to Mac users: Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2008 or Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here for 2008 or click here for 2011.
  • You must be familiar with basic Excel operation when the seminar begins. Do not enroll expecting to be taught how to use Excel.
  • The registration email confirmation will provide a secure link to download Excel files for in-class exercises.

 
Classroom Requirements Online Requirements Synchronous Requirements
No additional information


Classroom Offerings

No offerings at this time

Synchronous Offerings

No offerings at this time