An appraiser builds a spreadsheet regression to support adjustments. How is it treated?
Correct Answer
B) As analysis the appraiser must be able to support
Why this is correct: Any analytical tool used by an appraiser, including self-created spreadsheets, must be supported by credible data and logical analysis. The appraiser is responsible for the results and must be able to explain and defend the methodology and inputs if challenged. Why the other choices are wrong: "As exempt from disclosure, being the appraiser's own" is incorrect; self-created tools are not exempt from scrutiny or disclosure requirements. "As an automated valuation model under the AVM rule" is incorrect; a personal spreadsheet used as an analytical aid is typically not classified as an AVM for regulatory purposes. "As a substitute for reconciling the approaches" is incorrect; it is a tool within an approach, not a replacement for the reconciliation process. Exam tip: Self-made tools require the same support and defensibility as any other method you use.
Why This Is the Correct Answer
Option B is correct because a self-built regression is analysis the appraiser must be able to support, exactly like any other technique. Authorship confers no exemption and arguably raises the burden, since no vendor documentation or third-party validation stands behind it. Support means the data, the specification, and the results can each be explained and defended. That obligation also drives what belongs in the workfile and what must be summarized in the report.
Why the Other Options Are Wrong
Option A: As exempt from disclosure, being the appraiser's own
Nothing exempts an appraiser's own tools from scrutiny, and the reasoning would be perverse, since a proprietary method with no external validation warrants more explanation rather than less. Intended users cannot evaluate a conclusion produced by a black box they are told nothing about. Reporting requirements turn on the reader's understanding, not on who authored the method.
Option C: As an automated valuation model under the AVM rule
An automated valuation model is a computer program that produces an estimate of value for a property, generally operating without appraiser analysis of the individual property. A spreadsheet used by an appraiser to derive an adjustment within a larger analysis is an analytical aid, not a value-producing system. Conflating the two would also invoke regulatory frameworks that do not apply to an internal tool.
Option D: As a substitute for reconciling the approaches
Reconciliation weighs the indications produced by the approaches and judges their relative reliability, which is a step no adjustment-derivation tool can perform. A regression operates inside the sales comparison approach; it does not evaluate that approach against the cost and income approaches. Substituting a tool for a required analytical step would leave the report missing its reconciliation entirely.
You Built It, You Defend It
Building the tool yourself does not make it beyond question; it makes you the only one who can answer for it. Every variable, every formula, every coefficient is yours to explain. Keep the data and the model in the workfile so you can rebuild the argument later.
How to use: Treat any analytical tool, purchased or homemade, as requiring the same support: explain the inputs, the method, and why the output is reasonable. Reject options claiming exemption, misclassifying the tool as a regulated system, or letting it stand in for a required step such as reconciliation.
Exam Tip
Check coefficient signs and magnitudes against appraisal logic before relying on a model; a statistically strong result that says a garage reduces value is telling you the specification is wrong.
Common Mistakes to Avoid
- -Relying on a model whose coefficients are implausible because overall fit looks strong
- -Omitting the data set and model from the workfile so the analysis cannot be reconstructed
- -Reporting adjustments from a regression without summarizing the method for intended users
Concept Deep Dive
Analysis
This question tests responsibility for analytical tools the appraiser builds. A spreadsheet regression is a recognized method of deriving adjustments, and nothing in USPAP discourages quantitative techniques; what the standards require is that the appraiser correctly employ the methods used and be able to support the results. Building the tool personally changes nothing about that burden. The appraiser must be able to explain the model's specification, the variables included and excluded, the source and cleaning of the data, the reasonableness of the coefficients, and the diagnostics that indicate whether the model fits and whether its assumptions hold. Formulas must also be checked, since a spreadsheet error is invisible in the output and propagates silently through every adjustment. The workfile should retain the data set and the model so the analysis can be reconstructed, and the report should summarize the method sufficiently for intended users to understand it. A model whose coefficients carry implausible signs or magnitudes is not saved by a good fit statistic; the appraiser must judge whether the results make appraisal sense before relying on them.
Background Knowledge
You need to know that USPAP requires appraisers to be aware of, understand, and correctly employ recognized methods and techniques, and to avoid substantial errors of omission or commission. You should also know the Record Keeping Rule's requirement that the workfile contain the data and analyses supporting the conclusions, and enough regression fundamentals to evaluate specification, coefficient reasonableness, significance, and fit.
Real-World Application
An appraiser builds a regression on 180 verified sales to derive living area and lot size adjustments, retains the data set, formulas, and diagnostic output in the workfile, summarizes the specification and the derived rates in the report, and tests the two most significant adjustments against paired sales as a cross-check.
More Emerging Methods Questions
How does an alternative inspection method affect the appraiser's disclosure obligations?
A collector's photographs show a condition the appraiser believes needs specialist assessment. What is the appropriate step?
What responsibility does an appraiser retain for an error originating in a third-party database?
Under current USPAP guidance, what is the output of an automated valuation model before an appraiser analyzes it?
Which assignment type still requires the appraiser to develop an opinion of value?
A model returns an estimate far from the appraiser's own conclusion. What is the appropriate response?
What does it mean that a tool cannot comply with USPAP?
An appraiser is asked to review an assignment where an AVM supplied the value. What does the review examine?
Why is the date a data extract was pulled worth recording in the workfile?
A desktop appraisal is best described as an assignment completed how?
People Also Study
Real Estate Market
13.6% of exam
Property Description
11.8% of exam
Land or Site Valuation
4.5% of exam
Sales Comparison Approach
16.4% of exam
Cost Approach
13.6% of exam