# The Investment Sales Broker: companion files

Julian R. Sterling

## What is here

- **Investment_Sales_Broker_Model.xlsx**: the workbook that rebuilds the Sedgecombe sale and reproduces the figures of the book with live formulas. Sheets: Inputs, Rent roll, T-12, Year 1, BOV, Fee and net proceeds, Offers, Buyer debt, Retrade, Checks.
- **Investment_Sales_Broker_Toolkit.docx**: the 9 checklists of Appendix 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)), in editable form.

## Which sheet answers which chapter

- Chapter 3: Rent roll and T-12 (216 units, gross potential rent $4,116,960, T-12 NOI $2,573,303)
- Chapter 4: Year 1 (the buyer's first year, NOI before real estate taxes $2,960,654)
- Chapter 5: BOV (taxes reset on the price; $42.00 million to $45.20 million, midpoint $43.54 million, guidance $43.50 million; the comparables and the tax trap)
- Chapters 2 and 6: Fee and net proceeds (fee $380,000 and net $16,195,000 at the guidance)
- Chapters 10, 11 and 12: Offers (the calendar, the four best and final offers, expected nets $16,336,625 for A and $16,344,376 for B, the assumption, the pre-emptive offer)
- Chapter 9: Buyer debt (Offer A's loan, $27.02 million, capped by the coverage test)
- Chapters 14, 15 and 16: Retrade (accept, counter or walk; the closing at $43.35 million; the 1031 dates; the fee split)
- Appendix A: 12 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, move the effective tax rate after the sale from 1.30 percent to 1.10 percent: watch the value at the midpoint on BOV.
2. On Inputs, raise Offer A's closing probability from 70 percent to 80 percent: watch which offer leads on Offers. 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. The rent roll lists the 216 units by type and rent; lease dates are not part of the case model.

Merrivane Realty Advisors, Brennick Holdings, The Sedgecombe Apartments, the bidders and the comparable sales are fictional; fees, splits, deposits, cap rates, rents, costs, probabilities and dates are teaching assumptions, not market rates, market fees or market data. Rules change: check the current text. Provided as is, without warranty. Not legal, tax, licensing or investment advice.
