Today, many lenders require more support for adjustments, especially for market conditions. In litigation, recent court decisions require experts to prove their work or risk exclusion by judges. The appraisal profession faces increased competition from brokers and accountants who want to provide alternative valuation products like AVMs and BPOs.
This two-day seminar, a hands-on experience, is designed for both residential and commercial appraisers. Participants will use Microsoft Excel's statistical and graphic tools to aid many everyday valuation problems, such as statistical support for market delineation, highest and best use, adjustments, and value estimates. Students will complete this seminar a step ahead of the competition with a new set of skills they can use the very next day!
Upon completion of the seminar, participants should be able to:
Use simple regression and small data sets to support a variety of adjustments
Understand how statistical modeling can improve valuation support
Compute descriptive statistics that assist in identifying market segments
Use indications of dispersion to evaluate risk
Utilize statistics to expand the availability of data
Interpret results of statistical analyses
Prepare dazzling graphs to communicate findings in a pictorial and persuasive fashion
Prerequisites
This seminar is designed for both residential and commercial appraisers with a basic knowledge of spreadsheets, especially Excel. Participants should also have a basic understanding of market analysis, highest and best use, and the sales comparison approach.
Note. This seminar will be taught using Excel 2007 or 2010. 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.
