# The Life Science Real Estate Investor: companion files

Julian R. Sterling

## What is here

- **Life_Science_RE_Model.xlsx**: the workbook that rebuilds the Corlund case and reproduces the figures of the book with live formulas. Sheets: Inputs, Rent Roll, Leasing, Operating Costs, Cash Flow, Debt, Returns, Scenarios, Conversion, Development, Checks.
- **Life_Science_RE_Toolkit.docx**: the 8 checklists of Appendix B (the building test; systems and hazardous materials; the lab lease; tenant credit; tI, leasing and downtime; financing; conversion feasibility; development go or no-go), in editable form.

## Which sheet answers which chapter

- Chapters 6 and 7: Rent Roll (three tenants and a vacant suite, in-place base rent $10.12 million; the biotech's runway, letter of credit and capped claim)
- Chapter 8: Leasing (every lease the plan assumes, its rent, TI and commissions; net effective rent of the vacant suite $62.60 per RSF)
- Chapter 5: Operating Costs (occupancy, costs on vacant space, the owner's costs)
- Chapter 9: Cash Flow (2027 NOI $9.18 million, cash flow before debt from 2027 to 2031 and the forward year)
- Chapter 10: Debt (a loan of $77.00 million, interest cover and debt yield, the cash management test)
- Chapter 11: Returns (price $140.00 million; unlevered 9.97 percent, levered 13.64 percent, 1.82x; the grid by price and exit yield)
- Chapter 11: Scenarios (biotech default, slow lease-up, lower rents, higher exit yield, and the combined case at 6.47 percent)
- Chapter 12: Conversion (the Evenmoor office building, a yield on cost of 5.84 percent)
- Chapter 13: Development (the Thornell site, a yield on cost of 6.71 percent)
- Appendix A: 10 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, raise the exit yield from 6.75 percent to 7.00 percent: the sale price falls and the levered IRR loses more than a point. Most of the value is received at the exit, so the yield nobody controls carries much of the return.
2. On Inputs, move the vacant suite's first lease year from 2028 to 2029: the exit value does not move, but the empty months and the costs on vacant space come out of the cash flow. 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.

Quaywright Real Estate Partners, Quaywright Life Science Fund I, the Corlund Science Center, the Evenmoor building, the Thornell site and the three tenants are fictional; rents, costs, prices, yields, rates and dates are teaching assumptions, not the terms of any real building, tenant or lender, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, engineering or investment advice.
