Choose your path
 
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

Advanced Spreadsheet Modeling for Valuation Applications

EMAIL   Date: May 10 - 11, 2018   Location: Rockville, MD
 
  Course  
Category  Other [Oth]  
Attendance Hours  14.0  
Exam Hours  1.0  
Current Price  $ 350.00 AI Price *  
$ 400.00 Full Price *  
* includes late fee
Late Fee  $ 25.00  
 
  Instructor  
Mark V. Smeltzer, MAI, SRA, AI-RRS  
    
 
  Location  
Name  Greater Capital Area Association of REALTORSĀ®  
Rep  Carol Blattau  
Address  15201 Diamondback Drive, Suite 100  
City  Rockville  
State  MD  
Zip  20850  
Phone  (301) 590-2000  
 
Click Here to check state approvals
    
 
  Sponsor / Contact  
Chapter  Washington DC Metropolitan Area
Website  www.appraisalinstitutedc.org  
Contact Name  Peter Houstle  
Email  phoustle@marinermanagement.com  
Phone  (301) 924-1020  
Fax  (301) 238-4579  
 
  Description  
This two-day course will teach appraisers to prepare advanced analyses in a simpler manner and with fewer errors. It will appeal to participants with experience in market analysis and highest and best use and also those with experience in applying inferred market analysis. The focus is on problem solving and efficiency while uncovering some of the tools of the spreadsheet program that will strengthen an analysis and increase productivity. Participants will find the applications especially helpful in the areas of market analysis, feasibility analysis, and highest and best use. Gain techniques to solve real-world problems and develop best practices in modeling that can be applied in other situations.

Important note: This course includes the same content as the seminar of the same name. It is now in the Analytics for Valuation Professional Development Program and therefore, an exam was added. For more information, click here.

Upon completion of the course, participants should be able to:
• Recognize best practices and what to consider in financial model development
• Demonstrate how and when to use defined names in cells and ranges
• Identify key inputs in maximum building-size calculations
• Describe how to use key features of a spreadsheet program to easily make complex calculations
• Identify key inputs in land residual analysis

Downloads
Schedule (PDF)
Table of Contents and Overview (PDF)
 
  Audience  
• MAIs or SRAs who want to further their statistics knowledge and skill base

• Residential or general certified appraisers

• Reviewers

• Real estate brokers

• Underwriters
 
  Equipment  
• Laptop
• A four-function calculator is required for the exam. You may use a financial calculator if you prefer. Note: Cellular phones, tablets, iPads, and other devices that connect to the Internet are NOT permitted during the exam.
• Microsoft Excel 2007 loaded and operational. If you do not have Excel, you may download a free trial version at http://office.microsoft.com/en-us/try/. Please note that this links to the latest version of Excel. There may be minor differences between versions.
Solver Add-in and Analysis Tool Pak. Add-in must be installed prior to class.

Note to Mac users: The course will be taught in Windows using Excel 2007. You will need the latest version of Excel (2011) in order to perform some of the exercises. Also, Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality.

For more information, click here.
 
  Prerequisites  
• Basic knowledge of spreadsheets, especially in Excel
• Experience in market analysis, highest and best use, and inferred market analysis

Recommended
Using Spreadsheet Programs in Real Estate Appraisals - The Basics or similar course/seminar

Participants must sign a waiver at the beginning of the course stating that they have the prerequisites. If they do not, they will not hold the Appraisal Institute responsible and will not expect to receive special attention during the course.
 
  Disclaimer  
Cancellation Policy
  • Up To 14 days prior to program start date, refund in full.
  • 5 - 13 days prior to program start date, $50.00 cancellation fee.
  • Less than 5 days prior to program start date, forfeit of payment.
  Transfer Policy
  • Up To 14 days prior to program start date, no transfer fee.
  • 5 - 13 days prior to program start date, $25.00 transfer fee.
  • Less than 5 days prior to program start date, no transfer allowed.
   


Program materials can be downloaded by the student.
 
  Additional Information  
Class will be held at the Greater Capital Area Association of Realtors office in Rockville, MD.

Schedule:
Registration begins at 8:00am. Seminar is from 8:30am-5pm with a one hour lunch (on your own).

Greater Capital Area Association of Realtors
15201 Diamondback Drive
Rockville, MD 20850
301.590.2000




  Directions  

 

 
















 
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 © 2017 Appraisal Institute. All rights reserved.