Companion files · The Private Markets Career Guides
How to Place Debt, Raise Equity and Sell Commercial Property: Loan Sizing, Lender Quotes, Joint Venture Waterfalls, Investment Sales and the Career.
These are the companion files of the book. One workbook rebuilds the three fictional deals of the Halsted Capital Advisors team: Marlowe Gardens, an apartment portfolio refinanced after five lender quotes sized against loan-to-value, debt service coverage and debt yield; Wexford Yards, an industrial development whose joint venture equity runs through a three-tier waterfall; and Calder Logistics Park, an industrial park sold through a best and final round. 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 4 to 14
One Inputs sheet holds every assumption: income, value, lender requirements, the stress factor, the joint venture terms, the exit cap rate, the bids and the buyer financing. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook20 KBAppendix B
Financing memorandum outline, lender list builder, quote matrix columns, term sheet review, refinancing closing checklist, equity raise outline, offering memorandum outline, data room index and bid comparison checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Loan sizing | The agency loan on Marlowe Gardens is $214.1 million, set by its 1.20x coverage test, not by its 65 percent loan-to-value limit |
| Waterfall | Tamsin earns a 21.9 percent IRR on Wexford Yards and Oakvale 46.8 percent, with $5.8 million of promote |
| Investment sale | Calder Logistics Park sells for $231.0 million, a 5.19 percent cap rate, $2.4 million above the best first-round bid |
The files are provided as they are, without warranty of any kind. The models are illustrative: Halsted Capital Advisors, Selwyn Residential, Oakvale Development, Tamsin Investment Management, Ferrand Industrial Trust and Lowry Logistics Partners are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting advice.
More in real estate, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.