Home | Site Map | Contact Us
  View Cart              View Cart             
0 Registrations in Cart
 
 
Welcome. If you are a returning student or previously created an AI website account, please log in.
Back to Schedule  |  Select an Offering  |  Forgot Password?  |  Create Login
 
   


Residential Applications: Using Technology to Measure and Support Assignment Results

CALL   Date: March 6, 2013   Location: Ft. Washington, PA
 
  Seminar    
Category  Residential [Res]  
Attendance Hours  7.0  
Current Price  $ 190.00 AI
$ 205.00 Full
 
  Instructor    
Mark V. Smeltzer, SRA  
    
 
  Location    
Name  Manufacturers Golf & Country Club  
Address  511 Dreshertown Road  
City  Ft. Washington  
State  PA  
Zip  19034  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  Philadelphia Metropolitan
Website  www.aiphilametro.org  
Contact Name   Tiffany L. Lewis  
Address  1213 Matthew Woods Drive  
City  Braintree  
State  MA  
Zip  02184  
Email  contact@aiphilametro.org  
Phone  (610) 326-0100  
 
  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
  • Up To 15 days prior to program start date, $50.00 cancellation fee.
  • 7 - 14 days prior to program start date, $125.00 cancellation fee.
  • Less than 7 days prior to program start date, forfeit of payment.
        
ENROLLMENT POLICY: Your enrollment form and payment by check or online registration must be received by the chapter office at least 10 business (10) days prior to the start of the course to avoid a late charge. Any forms received within 9 business days or less of the first day of class will pay an additional $50.00. We do not accept walk-in students. ATTENDANCE POLICY. Please be aware that the Appraisal Institute enforces the 100% attendance requirements mandated by the Appraisal Foundation and state regulatory agencies. If you do not attend 100% of the course or seminar, you will receive a notice with your examination results from the Appraisal Institute stating that you have not met the attendance requirement. You must sit for the exam on exam day, pass the exam, and attend all classes to receive a certificate of completion. Pennsylvania State Appraisal Board requires 100% attendance and a passing grade on the exams. Partial credit not awarded. If you have a disability and may require some form of accommodation, please notify us in writing at least 2 weeks in advance and we will arrange for reasonable accommodation.

Program materials can be downloaded by the student or can be picked up at the site.
 
  Additional Information    
COMPLETION OF REGISTRATION PROCESS CONSTITUTES ACCEPTANCE OF THE CANCELLATION POLICY AS OUTLINED ABOVE. Dress Code: Country CLUB DRESS CODE IN EFFECT!!! COLLARED SHIRTS, NO SHORTS, NO JEANS. Anyone not conforming will be asked to leave without a refund. REGISTRATION: 8:00am Seminar begins 8:30am End: Approx 4:30pm ***DIRECTIONS TO MANUFACTURERS' COUNTRY CLUB*** 511 Dreshertown Road, Ft. Washington, PA 19034 Following are directions from the Ft. Washington Exit of 309 as well as directions off the PA Turnpike in Ft. Washington: Off PA Turnpike at Ft. Washington Exit. Follow sign for Oreland Exit. Follow to your second traffic light and make a left onto Camp Hill Road. Almost immediately bear right onto Dreshertown Road. Manufacturers' is about 1 ¼ miles on your right.