Companion files · The Private Markets Career Guides
The Real Estate Appraiser's Guide to Licensing, USPAP, UAD 3.6, AMC and Lender Work, Fees, Hybrid Appraisals and Running an Appraisal Practice.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook rebuilds Wendlecote Appraisal Group, the fictional two-appraiser firm of the case: the margin per hour of each kind of order, the 2027 plan with its hours, rework and profit, a rate cycle, value acceptance, a channel shift and the loss of the largest client, a trainee hire over 24 months, and a fee schedule. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 7 to 14, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Products, Plan, Scenarios, Trainee, Fees. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 14 exercises of Appendix A run on it.
Download the workbook36 KBAppendix 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.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Margin per hour | The AMC full appraisal earns $65.90 an hour and the direct lender order $91.72, for the same work |
| The plan | 570 orders leave a profit of $140,410 before tax and the owner’s draw, with the owner at 1,765.9 of 1,900 available hours |
| The trainee | Six slow months, then $2,222 a month: $12,460 in year 1 and $26,658 in year 2, if the freed hours are sold |
The files are provided as they are, without warranty of any kind. The model is illustrative: Wendlecote Appraisal Group is fictional, and its fees, hours, revision rates, volumes, costs and trainee terms are the book’s assumptions, not market fees or results to expect. Rules, guides and report formats change and differ by state: check the current texts, USPAP and the state board.