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

Residential Applications: Using Technology to Measure and Support Assignment Results

    Date: September 19, 2014   Location: Bloomington, IL
 
  Seminar  
Category  Residential [Res]  
Level  Intermediate  
Attendance Hours  7.0  
Current Price  $ 145.00 AI Price  
$ 175.00 Full Price  
Note
Please register early  
After Sep 05, 2014
$ 30.00  
 Late Fee
 
  Instructor  
Kern G. Slucter, MAI, SRA  
    
 
  Location  
Name  Parke Regency Hotel & Conference Center  
Rep  Mary Jane Lukas  
Address  1413 Leslie Drive  
City  Bloomington  
State  IL  
Zip  61704  
Phone  (309) 665-3904  
 
Click Here to check state approvals
    
 
  Sponsor / Contact  
Chapter  Chicago
Website  www.ccai.org  
Contact Name  L.A. Anderson  
Email  LA@ccai.org  
Phone  (312) 616-9406  
Fax  (312) 616-9404  
 
  Description  

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.

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

-- Sandy Adomatis, SRA

Participants will learn how to provide market-derived support for the following assignment results:

    • Market conditions
    • Days on market
    • Sales-to-list-price ratio
    • Adjustments for location, design, quality of construction, and numerous other property amenities
    • Market extraction for cost and depreciation estimates
    • Market extraction for market rent and gross rent multipliers
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. Residential appraisers of the future may be required to use these tools to produce slick, professional charts and graphs as clients become more technologically sophisticated.

At the conclusion 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
This seminar is for participants with a basic level of knowledge of spreadsheets, especially Excel, such as those obtained from

Note. This seminar will be taught from Windows using Excel 2007. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises. 

Recommended Texts

 
  Equipment  
AI strongly recommends, but does not require, that participants bring a laptop computer to class. All participants with a laptop MUST HAVE Microsoft Excel 2007 or 2010 loaded and operational. No version prior to Excel 2007 will be taught in the seminar.

Note. This seminar will be taught from Windows using Excel 2007. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises.

Be sure that Solver Add-in and Analysis Tool Pak Add-in are installed prior to class.

If you do not currently own Excel, you can download a free copy for 60 days at http://office.microsoft.com/en-us/try.

Note. This seminar is hands on! When participants receive a registration e-mail confirmation, a secure link will be available where they will be instructed to download Excel files to use for in-class exercises. These files must be downloaded prior to the seminar.

 
  Disclaimer  
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.
  Program Material Policy

Beginning 4 weeks before the offering start date, program material will be shipped directly to the student. If this material has been shipped and you request a registration cancellation, you will automatically be charged a $25.00 fee and you may keep the material. Once the fee is charged, your refund will be processed. Material returns are no longer accepted. Contact the offering sponsor for more information.
  • Cancel Offering, $25.00 material fee.
The Chicago Chapter enforces the attendance requirements as mandated by the State of Illinois and the AQB. There is a 100% attendance policy. . If you are late the first day of the course, you may stay in class but you will not receive full credit. Registration begins at 8:00 am for every course. Each course begins promptly at 8:30 am each day. Program Material Policy You will be picking your materials up at the beginning of the class from the Chapter. If you would like to review the materials prior to class, you may go to the Knowledge Center (KC) at http://knowledgecenter.appraisalinstitute.org/ Cancellation & Transfer Policy: Please read carefully. The Chicago Chapter charges a $50 cancellation AND $50 transfer fee. If you cancel less than 3 BUSINESS DAYS before the start of the course or seminar you will receive NO REFUND. Most classes start on Monday so if, for example, you cancel on Wednesday of the week before the class begins you will FORFEIT YOUR TUITION. The Chicago Chapter reserves the right to cancel, limit or reschedule the programs and to change faculty assignments at any time. Prospective students should confirm their registrations before making any non-refundable airline reservations. If you cancel there is an additional $25 material charge from the national office. You do not return course materials any longer.

Program materials can be downloaded by the student or can be shipped directly to the student. If you choose to have the material shipped and do not receive your materials within 5 days before the offering start date, please call the sponsor to inform them.
 
  Additional Information  
Class Schedule: Registration: September 19, 2014 8:00a-8:30a Class: 8:30 -4:30 Sept 19 at the Parke Regency Hotel and Conference Center in Bloomington, IL Please contact Mary Jane, maryjane@ccai.org, 312.616.9400 if you have any questions or need assistance.

 

 
















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