Changing markets require market to market adjustments.
The Market Change webinars teach appraisers how to select and export MLS data to be analyzed in Excel. Participants will receive a Market Change Excel template and user manual. We show how to save the Excel file as a template so it can be opened instantly without hunting through your file system.
Whether you are new to Excel or a seasoned user, this webinar is for you.
Specifically, this webinar will teach participants:
– How to build and use a Market Change Excel Template
– How to export data from their MLS and import it into Excel;
– How to accelerate their analyses by using excel Tables;
– How to create and format a scatterplot for your analysis/report/workfile;
– How to master the Excel slope function to calculate an adjustment rate;
– How to subtract dates for critical intervals;
– How to apply adjustment rate to interval in days using absolute references;
– How to calculate a market-to-market adjustment using relative references;
– How to lock formula fields and save your Excel template for future use;
– How to protect themselves, by maintaining good records in your workfile;
– What USPAP & the GSEs say about selecting properties for a market change adjustment;
– How to communicate market changes to the client clearly and persuasively;
*This training webinar is not approved for CE credit. It’s just great information and training created to make you better at your job.
Course Instructor
Tim Andersen is an AQB Certified USPAP Instructor, consultant, and reviewer. He also does commercial real estate appraisal and Florida tax appeal work. He travels throughout the US teaching USPAP, and is an Approved Instructor for the Appraisal Institute. Have PowerPoint, Will Travel. Besides all facets of commercial real estate appraisal, other areas of expertise include writing, producing, and presenting webinars on all areas of real estate appraisal.
Specialties: Appraisal Institute member, designated as an MAI, Master of Science degree in Real Estate Appraisal , AQB Certified, USPAP Instructor, State Certified General Real Estate Appraiser, Instructor with the Appraisal Institute, Experienced Public Speaker
Course Author
Scott Cullen is a boots-on-the-ground Certified Residential appraiser from Minneapolis / St Paul with over 20 years of experience. He is a cofounder of Solomon, a suite of cloud-based calculators that help over 500 appraisers daily to quickly support their adjustments using the recognized technique of depreciated cost analysis.
His calculators come with licensed cost data built-in, making it easy and economical to support your sales grid adjustments. Beyond grid adjustments, Solomon supports other assignment results such as effective age, remaining economic life and site value.
Advanced Appraisal Review | Live Virtual Class | Tuesday & Wednesday January...
