Articles

How to calculate yield on cost for a data center development

Divide stabilized NOI by total development cost, interest during construction included, and compare it with the cap rate: here 11.44% against 6.75%, a spread of 469 bps.

Data center yield on cost is stabilized net operating income divided by total development cost. On a fictional 60 MW turnkey campus, forward NOI of 87.5m over a total cost of 765.1m (12.75m per MW, interest and fees included) gives 11.44%. Against a 6.75% cap rate, the development spread is 469 bps and the campus is worth 1,296.2m.

The case comes from The Data Center Development Handbook and the Data Center Development & Finance course by Julian R. Sterling.Get the DRM-free PDF, $19.99 →or see it on Amazon

Yield on cost is the first number a developer, a lender and an investment committee look at, because it answers the only question that matters before the capital is spent: will the finished, leased asset earn enough on what it cost to be worth more than it cost? The steps below compute it on one campus, with every line traceable.

The case

The running case: Harlow Ridge Data Campus (fictional), $m unless stated.
InputValue
IT load, in three phases of 20 MW60 MW
Design peak PUE / utility capacity1.30 / 78.0 MW
Cost per MW before contingency (turnkey) / contingency11.45 / 5%
Rent, $ per kW-month (2027), escalator110.00, 3%
Construction loan: loan to cost + interest reserve60% + 6%
Cap rate (refinancing and exit)6.75%

Step 1: total development cost, not the budget

Budget = cost per MW × (1 + contingency) × MW = 11.45 × 1.05 × 60 = 721.35m

Interest during construction, to the quarter the last phase starts paying rent: 38.99m

Arrangement fee on the construction loan: 4.76m

Total development cost = 721.35 + 38.99 + 4.76 = 765.10m, or 12.75m per MW

The budget alone would overstate the yield: 87.5 / 721.4 = 12.13%. Interest and fees are part of what it cost to deliver the asset. The case's all-in 12.75m per MW sits inside the $8.9m to $23.3m range of Cushman & Wakefield's 2026 guide; how much a data centre costs to build per MW breaks the lines down.

Step 2: stabilized NOI

NOI = rent + power margin − operating costs − management fee

Forward NOI at the refinancing (Q4 2032, the next four quarters): 87.49m

Rent is $110 per kW-month in 2027 money on 60 MW of leased capacity, rising 3% a year. The landlord also keeps a small margin on power, billing the tenant at a PUE of 1.35 and buying at 1.25. Use forward NOI from a fully leased rent roll: on the first fully leased year (84.3m) the yield would read 11.02%. Say which year you use.

Module 7 of the course works this calculation on the full campus

A course built on one 60 MW campus, from grid tranches and cost per MW to leases, the power recharge, the construction loan, the refinancing and the stress tests, with Excel exercises, a 162-question quiz and the Data Center Development Model, Pro Edition included ($199).

Try module 3 and ten quiz questions, free →

Step 3: yield on cost, spread and value

Yield on cost = 87.49 / 765.10 = 11.44%

Development spread = 11.44% − 6.75% = 469 bps

Value = forward NOI / cap rate = 87.49 / 6.75% = 1,296.2m; value created 531.1m

In Excel: =NOI/TotalCost and =NOI/CapRate-TotalCost

The spread is the margin of safety. Developers usually want a few hundred basis points over the exit cap rate to be paid for the grid, construction and lease-up risks. CBRE put Class A data center cap rates at 100 to 150 basis points over the 10-year Treasury in 2025; the case uses a higher 6.75% to price a single tenant in a secondary market.

Same campus, three ways to build it or stress it.
CaseTotal costYield on costSpread
Turnkey, base case765.111.44%469 bps
Powered shell on the same site227.711.27%452 bps
Stress: overrun, late power, lower rent, higher rates and cap rate865.99.17%167 bps

The trap: comparing a yield on cost computed on the budget with one computed on total cost, or a turnkey yield with a powered-shell yield as if the capital were the same. The shell yields 17 bps less on less than a third of the capital; powered shell vs turnkey compares them in full.

Takeaway

Free Excel template: data center financial model.

Sources

  1. Julian R. Sterling, Data Center Development & Finance (course, 2026): running case Harlow Ridge Data Campus
  2. Julian R. Sterling, The Data Center Development Handbook
  3. Free data center financial model (Excel)
  4. Cushman & Wakefield, 2026 Data Center Development Cost Guide, as reported by IREI (August 2026): costs up 21% per MW since late 2024
  5. CBRE, North America Data Center Trends H1 2025: Class A cap rates 100 to 150 bps above the 10-year Treasury

Every figure is computed by script from the course's running case, Harlow Ridge Data Campus, a fictional 60 MW campus, and checked on 17 November 2026. Market figures are dated assumptions of the case. For education, not investment advice.

Learn the whole method: Data Center Development & Finance

A course built on one 60 MW campus, from grid tranches and cost per MW to leases, the power recharge, the construction loan, the refinancing and the stress tests, with Excel exercises, a 162-question quiz and the Data Center Development Model, Pro Edition included ($199).

Try module 3 and ten quiz questions, free →

Questions readers ask

What is a good yield on cost for a data center?

One that clears the exit cap rate by a few hundred basis points. In the worked case, 11.44% on cost against a 6.75% cap rate leaves 469 bps; the stress case leaves 167 bps.

Should interest during construction be in the cost?

Yes. Without the 39.0m of interest and the 4.8m fee, the case's yield would read 12.13% instead of 11.44%.

Is yield on cost the same as the cap rate?

No. Yield on cost divides NOI by what the asset cost to build; the cap rate divides NOI by what a buyer would pay for it. The gap between them is the development spread.

Which NOI do you use?

Stabilized NOI from a fully leased rent roll, usually forward NOI at stabilization. State the year: lease-up NOI understates the yield and a later year overstates it.

Read the whole case

The turnkey cost is worked into a full underwrite in chapter 13 of The Data Center Development Handbook. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99

Read The Data Center Development Handbook already? A few honest lines on Amazon help the next reader: write a review.

Also on this site

All 1908 articles →