# The Residential Appraiser: companion files

Julian R. Sterling

## What is here

- **Residential_Appraiser_Model.xlsx**: the workbook that rebuilds the Wendlecote case and reproduces the figures of the book with live formulas. Sheets: Inputs, Products, Plan, Scenarios, Trainee, Fees, Checks.
- **Residential_Appraiser_Toolkit.docx**: the 8 checklists of Appendix B (reading the order and the engagement letter; competency, conflict and independence before acceptance; inspection day; the workfile; before delivery: the pre-submission check; answering a revision request or an ROV; compliance calendar: license, continuing education, E&O, panels; before hiring a trainee), in editable form.

## Which sheet answers which chapter

- Chapters 7, 9 and 10: Products (fee, variable cost, expected hours and margin per hour of each kind of order: $450 AMC full appraisal at $65.90 an hour, $600 direct lender order at $91.72; the pre-submission checklist)
- Chapters 10, 11 and 13: Plan (570 orders, revenue $276,500, profit $140,410 before tax and the owner's draw; capacity, rework and break-even)
- Chapters 8 and 11: Scenarios (rate cycle $98,110, value acceptance $133,242, channel shift $143,410; revenue by client and the loss of AMC 1)
- Chapter 14: Trainee (24 months: $12,460 in year 1, $26,658 in year 2, log past 1,000 hours in month 15)
- Chapter 9: Fees (every product by margin per hour against the AMC order; a direct lender fee schedule up to $975)
- Appendix A: 14 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, raise the AMC fee from $450 to $500: watch the margin per hour on Products and the profit on Plan.
2. On Inputs, set the rate cycle to 50 percent of plan instead of 70 percent: watch the profit on Scenarios. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs. Amounts are in US dollars; profit is before income tax and before the owner's draw.

Wendlecote Appraisal Group, Fallowmead County, AMC 1 and AMC 2 are fictional; fees, hours, revision rates, volumes, costs and the trainee terms are teaching assumptions, not market fees, market rates or results to expect. Rules, guides and report formats change and differ by state: check the current texts, USPAP and the state board before relying on any of them.
