Webinar Description
In a rapidly-changing market with few current sales, you need to support time adjustments. A time adjusted sale from months ago may be more credible than several adjustments to a recent sale.
Whether you are new to Excel or a seasoned user, this webinar is for you.
The goal of this webinar is to teach appraisers the basics of excel and how to make a market change adjustment. Participants will receive an Excel template and learn how to export MLS data to get started right away. We will teach you how to build your own template so you can design custom charts and re-use them instantly.
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;
