Companion files · The Private Markets Career Guides

The Investment Sales Broker

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 workbook, the toolkit and the read-me, in one archive88 KB

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.

The files

Three numbers to reproduce first

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 netAt 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 winnerOffer 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.