Shopping Cart    
Search
Login
Welcome,   My Account


   
Residential Applications Part 2: Using Microsoft Excel to Analyze and Support Appraisal Assignments 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!

"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

Building on the skills and techniques highlighted in Residential Applications Part 1: Using Technology to Measure and Support Assignment Results, this practical, hands-on seminar provides residential appraisers with an additional set of technological tools to measure and support work results that will increase client satisfaction.

Learn how to create charts, graphs, and tables to provide market-derived support for the following appraisal issues: neighborhood age and sale price, neighborhood predominant age and sale price, exposure time, gross living area adjustments, site value and site adjustments, stigma, external obsolescence, liquidation value, and market analysis using the Fannie Mae 1004MC. Immediately use your seminar handbook full of examples and step-by-step instructions for later reference. This could be one of the most valuable residential seminars you have ever taken!

Upon completion of the seminar, participants should be able to:
• Apply spreadsheets, PivotTables, simple regression, charts and graphs to everyday appraisal problems
• Support a neighborhood age range and predominant age
• Support a neighborhood price range and predominant sale price
• Support an opinion of exposure time
• Support a gross living area adjustment
• Support a site value and site adjustments
• Support stigma
• Support external obsolescence
• Support liquidation value
• Find and support data to complete the Fannie Mae 1004MC 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 at http://office.microsoft.com/en-us/try.
• 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, Candidates for Designation, and Practicing Affiliates
Attend Only = 75 points

Level
Intermediate

Click Here for State Approvals


  
Class Schedule & Locations

03/14/2015 - 03/14/2015
Location: Orlando, FL
Click here for location details
Sponsor: East Florida
Contact: Lauren Dowling, (813) 651-5904
Instructor: Smeltzer, Mark V., SRA
Register


03/23/2015 - 03/23/2015
Location: Louisville, KY
Click here for location details
Sponsor: Bluegrass
Contact: Susan Katz, (502) 727-9181
Instructor: Smeltzer, Mark V., SRA
Register


04/02/2015 - 04/02/2015
Location: St. Paul, MN
Click here for location details
Sponsor: North Star
Contact: Maribelle E. Cushman, (651) 633-0676
Instructor: Atwood, James B., SRA
Register


04/27/2015 - 04/28/2015
Location: Jackson, MS
Click here for location details
Sponsor: Mississippi
Contact: Carol McKinnon, (601) 981-7676
Instructor: Atwood, James B., SRA
Register


04/30/2015 - 04/30/2015
Location: Anchorage, AK
Click here for location details
Sponsor: Alaska
Contact: Darcy Schmidt, (206) 622-8425
Instructor: Smeltzer, Mark V., SRA
Register


06/04/2015 - 06/04/2015
Location: Des Moines, IA
Click here for location details
Sponsor: Iowa
Contact: Wayne J. Hennessey, MAI, SRA, (515) 971-5285
Instructor: Atwood, James B., SRA
Register


06/05/2015 - 06/05/2015
Location: Davenport, IA
Click here for location details
Sponsor: Iowa
Contact: Wayne J. Hennessey, MAI, SRA, (515) 971-5285
Instructor: Atwood, James B., SRA
Register


08/13/2015 - 08/13/2015
Location: Memphis, TN
Click here for location details
Sponsor: Memphis-Tennessee
Contact: Susan F. Evans, (901) 218-0782
Instructor: Atwood, James B., SRA
Register


09/25/2015 - 09/25/2015
Location: Bloomington, IL
Click here for location details
Sponsor: Chicago
Contact: L.A. Anderson, (312) 616-9406
Instructor: Smeltzer, Mark V., SRA
Register






Pop up content here.

Agree Disagree