Real estate schedules · in 2 models

Development returns and spread

Yield on cost, development spread, profit on cost, IRR.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: development returns and spread.Updated 2 October 2026

Part of real estate models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

What it does

How a development is judged. Yield on cost is stabilised NOI over total development cost including capitalised interest; the development spread is that yield less the cap rate the building would sell at, the margin that pays for construction, leasing and market risk; profit on cost is value less cost over cost. The quarterly unlevered and levered cash flows give IRRs, annualised, and the equity multiple, with a sensitivity to the exit cap rate.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Real estate development model
  • Assumptions, rows 38–40: Exit cap rate, Selling costs, % of sale price, Exit cap rate sensitivity increment
  • Exit, rows 16–19: Forward NOI at sale, Gross sale price, Selling costs, Net sale proceeds
  • Returns, rows 6–7: Ownership flag, Unlevered cash flow
  • Returns, rows 10–13: Permanent loan flag, Permanent loan interest, NOI to equity after interest, Levered cash flow to equity
  • Returns, rows 16–24: Total development cost including capitalised interest, Stabilised NOI, Yield on cost, Development spread…
  • Returns, rows 27–29: Exit cap rate, Sale price by exit cap rate, Development spread by exit cap rate
Data centre colocation model
  • Assumptions, row 8: Exit, end of year
  • Assumptions, rows 52–54: Exit cap rate, Sale costs, Equity discount rate
  • Operations, rows 20–27: Leased MW at stabilised occupancy, Rent revenue, Power cost, Power billed at cost plus margin…
  • Cash Flow, rows 6–7: NOI in the year after the exit, Sale price
  • Cash Flow, rows 10–18: CFADS while held, Development cost, Net sale proceeds, Unlevered cash flow…
  • Returns, rows 5–11: Unlevered IRR, Equity IRR, Equity invested, Equity distributed…
  • Returns, rows 14–23: Development cost before financing, Construction loan interest, Construction loan fees, Total development cost…
  • Returns, rows 26–29: NOI in the year after the exit, Sale price, Sale price per MW, Occupancy in the exit year

What a reviewer looks for

  • Yield on cost on cost before financing.
  • A quarterly IRR quoted as annual.
  • A spread measured against today’s cap rate rather than the exit cap rate.

Learn it, then build it

Vocabulary: Yield on Cost, Development Spread, Profit on Cost, Equity Multiple.

Other real estate schedules