How to Excel for Appraisers, Episode 5
Reconciliation
Reconciling Value Indications with Weighted Analysis
Recorded Version
Aired on Thursday, August 17th, 2023
90 Minutes
$49.95 (NON-CE Webinar)
*This training webinar is not approved for CE credit. It’s just great information and training created to make you better at your job.
*Registration Includes:
- Reconciliation (Excel) Workbook with 5 tabs:
- Tab 1 – Weighted Gross Adjustment
- Tab 2 – Weighted Proximity Analysis
- Tab 3 – Ranking Analysis
- Tab 4 – Recency,
- Tab 5 – Summary & Final Value Opinion Analysis
- Access to the .mp4 webinar recording (even if you can’t attend live) and all materials
- 1-on-1 instructor support and Q&A during the live event and by appointment.
Webinar Description
In Episode 5 of our webinar series, How to Excel for Appraisers, we focus on Reconciliation. In the valuation process, it is very common for appraisers to apply more than one approach to value to their assignments. When two or more approaches are used, appraisers must reconcile the value indications.
The goal of this webinar is to equip appraisers with a deep understanding of using weighted analyses to reconcile value indications (Gross adjustments, proximity, recency of sale, ranking etc.) within an approach, and then to form a final value opinion.
By the end of this webinar, participants will be able to:
– Use the included Excel file to apply weighted analyses to four dimensions within the Sales Comparison Approach.
– Summarize approaches to value and develop a final value opinion.
– Understand the importance of analyzing more than one value indicator.
– Learn to recognize that some data indices are more market-oriented than others.
Webinar Registration Includes:
- Reconciliation (Excel) Workbook with 5 tabs:
- Tab 1 – Weighted Gross Adjustment
- Tab 2 – Weighted Proximity Analysis
- Tab 3 – Ranking Analysis
- Tab 4 – Recency Analysis
- Tab 5 – Summary & Final Value Opinion
- Access to the .mp4 webinar recording (even if you can’t attend live) and all materials; and
- 1-on-1 instructor support and Q&A during the live event and by appointment.
Webinar System Requirements
- This webinar is offered via Zoom meeting. Computer Audio, Video and a reliable internet connection are recommended.
- If you’re new to zoom, click the following link to launch a test meeting: https://zoom.us/test.
- Older versions of Excel should work, but instructors will be using Excel 365 to build the Killer Worfkile Template
- The Killer Workfile Excel template, with User Manual/Instructions, will be emailed to all registered attendees on the day before and the morning of the webinar.
Course Instructor
Tim Andersen
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
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.
