|
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
|
|
Downloads
Table of Contents and Overview [PDF] 
Schedule [PDF]
Type
Residential
Equipment Required
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.
Tuition
Please contact the sponsoring chapter for information on fees applicable to chapter programs. |
Classroom Hours
7.0
AI CE Credit for Designated members and Candidates for Designation
This program is approved for 1.25 hours of Appraisal Institute CE credit for every hour taken.
To receive credit, participants must attend 100% of the program.
Level
Intermediate
For Further Reading
None Specified.
Registration Information
None Specified.
Click Here for State Approvals
| |
Class Schedule & Locations |
06/13/2013 - 06/13/2013
Location: Bloomington, IL
Click here for location details
Sponsor: Chicago
Contact: L A Anderson, (312) 616-9400
Instructor: Slucter, Kern G., MAI, SRA
06/14/2013 - 06/14/2013
Location: Chicago, IL
Click here for location details
Sponsor: Chicago
Contact: L A Anderson, (312) 616-9400
Instructor: Slucter, Kern G., MAI, SRA
10/02/2013 - 10/02/2013
Location: Norfolk, VA
Click here for location details
Sponsor: Hampton Roads
Contact: Keith Byers, (757) 397-1363
Instructor: Amorin, Jim, MAI, SRA
11/15/2013 - 11/15/2013
Location: Nashville, TN
Click here for location details
Sponsor: Greater Tennessee
Contact: Myra Withers, (615) 515-9700
Instructor: Atwood, James B., SRA
|
|
