Companion files · The Private Markets Career Guides
Commercial Real Estate Investment Sales: Broker's Opinion of Value, Offering Memorandum, Call for Offers, Best and Final, and Closing the Sale of an Income Property.
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 the sale of The Sedgecombe Apartments, the fictional 216-unit community of the case, by Merrivane Realty Advisors for Brennick Holdings: the rent roll and the T-12, the buyer’s year 1, the broker’s opinion of value with taxes reset on the price, the fee and the seller’s net proceeds, four best and final offers compared on expected net proceeds, the winning bidder’s debt, a retrade on three roofs and the closing. A toolkit holds the checklists of Appendix B in an 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 2 to 6, 9 to 12 and 14 to 16, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the sale: Rent roll, T-12, Year 1, BOV, Fee and net proceeds, Offers, Buyer debt, Retrade. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 12 exercises of Appendix A run on it.
Download the workbook54 KBAppendix B
Pitch and BOV; Engagement letter; Offering memorandum and data room; Call for offers and best and final; Comparing offers; Due diligence period; Retrade; Closing week; Tax flags for the seller's advisers (1031, FIRPTA).
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| The value | $2,960,654 of NOI before taxes over a 5.50 percent cap rate plus a 1.30 percent tax rate: $43.54 million, against $46.79 million if the old tax bill is kept |
| The net | At the $43.50 million guidance, after a fee of $380,000, closing costs, the loan payoff and its prepayment premium, the seller keeps $16,195,000 |
| The winner | Offer A at $44.60 million has an expected net of $16,336,625; Offer B at $43.70 million, all cash, $16,344,376 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Merrivane Realty Advisors, Brennick Holdings, The Sedgecombe Apartments, the bidders and the comparable sales are fictional, and fees, splits, deposits, cap rates, rents, costs, probabilities and dates are the book’s assumptions, not market rates, market fees or market data. Rules change. Nothing here is legal, tax, licensing or investment advice.