# The Real Estate Capital Markets Advisor: companion files

Julian R. Sterling

## What is here

- **Real_Estate_Capital_Markets_Model.xlsx**: the workbook that rebuilds the three case deals and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Loan Sizing, Quote Matrix, Waterfall, Sale, Checks.
- **Real_Estate_Capital_Markets_Toolkit.docx**: the checklists of Appendix B (financing memorandum, lender list, quote matrix, term sheet review, refinancing closing, equity raise outline, offering memorandum, data room index, bid comparison), in editable form.

## Which sheet answers which chapter

- Chapters 4 to 9: Loan Sizing (Marlowe Gardens: five lenders, loan-to-value, debt service coverage, debt yield, binding constraint, stress factor)
- Chapter 7: Quote Matrix (cash out or in for each quote)
- Chapters 10 and 11: Waterfall (Wexford Yards: three tiers, Tamsin and Oakvale returns, exit cap rate)
- Chapters 12 to 14: Sale (Calder Logistics Park: bids, cap rates, price per square foot, buyer financing)

## Two inputs to change first

1. On Inputs, set the stress factor to 10 percent: watch which constraint binds for each lender on Loan Sizing and which quotes turn to cash in on the Quote Matrix.
2. On Inputs, set the Wexford exit cap rate to 6.25 percent: see how much of Oakvale's promote survives on the Waterfall sheet. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light yellow background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Halsted Capital Advisors, Selwyn Residential, Oakvale Development, Tamsin Investment Management, Ferrand Industrial Trust and Lowry Logistics Partners are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market terms, ratings or forecasts. Provided as is, without warranty. Not investment, legal, tax or accounting advice.
