Companion files · Real Estate Appraisal

Appraised at $12,100,000, sold at $12,850,000

Real Estate Appraisal: Appraisal by the Numbers: The Three Approaches, Reconciliation, and Why the Appraised Value Differs from the Price, With the Models Supplied.

These are the companion files of Real Estate Appraisal by Julian R. Sterling.The book on Amazon →

These are the companion files of the book. A 72-unit apartment property is appraised for the buyer's lender by the three approaches: sales comparison $12,150,000, income $12,050,000, cost $12,500,000, reconciled at $12,100,000 as is. The contract signed three weeks earlier says $12,850,000. The workbooks take the $750,000 gap apart component by component until $45,906 remains, and carry the residential case alongside. Four workbooks reproduce every figure the book prints. No sign-up, no email is asked for, nothing is locked. Yellow cells with blue type are inputs; grey cells are formulas.

All the companion files and the read-me, in one archive277 KB

The archive holds the eight files below and the three worked cases in a Cases folder, with 00_START_HERE.md at its root. Last revised 15 November 2026. No macros, no circular references, no external links in any workbook. They recalculate in Excel, LibreOffice or Google Sheets.

Get an email if these files are corrected

Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.

Join the reader list

Run by MailerLite, off this site. How your address is used.

The files

Three cases the book does not work

New material, not a restatement. Each case takes a situation the book names and does not compute, on Kestrel Park’s own figures. Each is one workbook: the note is the first sheet, then the model in live formulas, then a checks sheet that reproduces figures the book prints and ends ALL OK. Any value the book does not give is marked ADDED.

Three numbers to reproduce first

One cap rateFive sales report a mean cap rate of 6.03 percent on the brokers' NOI; restated with reserves and a market management fee, the mean is 5.80 percent, and the appraiser concludes 5.75 percent
One valueNOI of $702,822 at 5.75 percent gives $12,222,983 as stabilized; less the roofs and half a year of loss to lease, $12,050,000 as is
One gapPrice $12,850,000 less value $12,100,000 is $750,000; the eight components explain $704,094 of it, and the appraiser's own share (the date lag and the residual) is $102,623, 0.85 percent of value

The files are provided as they are, without warranty of any kind. The models are illustrative: the property, the city, the parties and every comparable sale are fictional, and the figures are the book's assumptions, not market statistics or forecasts. Nothing here is appraisal, investment, legal or tax advice, and none of it is an appraisal of any property.

What changed, and when

15 Nov 2026Added three new worked cases: which lending test binds and where it changes hands, the taxes at the price and the first mark, and what the discount on a half interest implies. The seven workbooks are unchanged and their checks still pass.
25 Sep 2026Companion files published with the book.

Also by Julian R. Sterling

More in real estate, with free companion files. The full list of titles is on the author page.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbooks stay free either way.