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

EMAIL   Date: May 23, 2019   Location: Charlottesville, VA
Category  Residential [Res]  
Level  Intermediate  
Attendance Hours  7.0  
Current Price  $ 155.00 AI Price  
$ 175.00 Full Price  
James B. Atwood, SRA  
Name  The Junction  
Rep  Rob Duke  
Address  421 Monticello Rd.  
City  Charlottesville  
State  VA  
Zip  22902  
Phone  (434) 465-6131  
Click Here to check state approvals
  Sponsor / Contact  
Chapter  Virginia Commonwealth
Contact Name  Nancy Linton-Hall  
Address  122 W. Murphy St.  
   Suite 3  
City  Madison  
State  NC  
Zip  27025  
Phone  (336) 297-9511  

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
  • Up To 15 days prior to program start date, $25.00 cancellation fee.
  • 7 - 14 days prior to program start date, $50.00 cancellation fee.
  • Less than 7 days prior to program start date, forfeit of payment.
  Transfer Policy
  • Up To 15 days prior to program start date, $5.00 transfer fee.
  • 1 - 14 days prior to program start date, $25.00 transfer fee.
  • Less than 1 day prior to program start date, no transfer allowed.
All cancellations must be received in writing. There is a minimum $25 cancel fee before materials are shipped and the cost of credit card processing fees. After materials are shipped there is a $50 cancel fee. No refund for cancellations within 7 days of the course. The chapter reserves the right to cancel the course due to lack of enrollment, inclement weather, etc., with full refund issued less cost of materials already shipped. Prices subject to change without notice.

ADA Policy
If you have a disability and require accommodations, please notify the Virginia Commonwealth Chapter office via, at least two weeks in advance and we will arrange for reasonable accommodations.

Program materials can be downloaded by the student.
  Additional Information  
Seminar Materials
Materials will be available for pick-up during registration, UNLESS a SAVINGS of $15 is preferred and the "Download Materials" Option is chosen.
If the download option is chosen, please do not forget to bring the materials with you as none will be available on site.

Seminar Schedule
Registration: 5/23/19: 8 a.m. - 8:30 a.m.
Class: 5/23/19: 8:30 a.m. - 4:30 p.m.

Attendance Policy
The Appraisal Institute and the AQB require full attendance (100%) at the seminar.
If the attendance roster reflects less than 100%, it could/will show up on the roster submission to the states.

Classroom Hours
7 Hours

CE Credit Approvals
Appraisal Institute: Attend only: 75 points
Virginia Appraisal Board: 7 Hours
For other states:

Tuition Includes
Seminar materials and breaks

Seminar Location
The Junction, 421 Monticello Rd., Charlottesville, VA 22902 T. 434-465-6131

James B. Atwood, SRA of Nashville, TN

  Driving Directions  



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.