# The Real Estate Acquisitions Analyst: companion files

Julian R. Sterling

## What is here

- **Acquisitions_Analyst_Model.xlsx**: the workbook that rebuilds the book's two case files and the pipeline year with live formulas. Sheets: Inputs, Larkspur_CF, Larkspur_Returns, Sensitivities, MaxBid, Route9_CF, Route9_Prices, Pipeline, Checks.
- **Acquisitions_Toolkit.docx**: the checklists of Appendix B (screening, underwriting, investment committee memo outline, LOI terms, due diligence, closing, handoff), in editable form.

## Which sheet answers which chapter

- Chapters 4 and 15: Pipeline (the funnel from deals screened to deals closed, equity deployed, Fund IV deployment)
- Chapters 6, 7 and 10: Larkspur_CF (Larkspur Commons: rent to NOI, renovations, reserve, debt service, cash flows, exit)
- Chapter 9: Larkspur_Returns, Sensitivities and MaxBid (cap rates, yield on cost, coverage, IRRs, five sensitivities, the maximum bid)
- Chapters 8, 12 and 14: Route9_CF and Route9_Prices (Route 9: rollover, downtime, TI and commissions, ask, LOI, roof, retrade)

## Two inputs to change first

1. On Inputs, raise the Larkspur exit cap rate by 25 basis points: watch the levered IRR on Larkspur_Returns and the maximum bid on MaxBid.
2. On Inputs, lower the probability that the Route 9 tenant renews: see what happens to the unlevered IRR at each price on Route9_Prices. 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 maximum bid is solved in closed form, without goal seek. The Checks sheet should read ALL CHECKS OK on the default inputs.

Brightwater Real Estate Partners, Brightwater Fund IV, Larkspur Commons and Route 9 Logistics Center are fictional; the models are simplified teaching models; all case figures are illustrative assumptions, not market terms or forecasts. Provided as is, without warranty. Not investment advice.
