Articles

How to build a data center development model, step by step

Eight steps, in the order a development analyst builds them, each checked on the same 60 MW campus.

A data center development model is built power first: the grid decides when each phase can pay rent, the cost is counted per MW, the rent per kW-month, and the electricity is a recharge with its own margin. On a fictional 60 MW campus the eight steps below produce a total cost of 765.1m, a yield on cost of 11.44% and an equity IRR of 25.32%, every figure checked.

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

Most templates for this asset start from a real estate model and add a rent per kW. That misses what makes data centers different: a finished building can wait months for power, the cost per MW changes with the denominator, and a lease PUE can turn the power line into a loss. The order below follows how a development analyst builds a campus model, from the grid connection to the stress test.

The campus

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: Set the timeline and the grid

Quarterly periods, three phases, and the grid tranches that power them. Each phase needs its cumulative IT load times the peak PUE (78.0 MW for the whole campus) and pays rent from the later of the building being ready and power being available: Q7, Q11 and Q15 in the case. More: what a grid delay costs.

Step 2: Build the cost per MW

Seven lines per MW (land, grid, shell, electrical, mechanical, fit-out, soft costs), 11.45m before contingency, 721.4m of budget. Land and the substation come first; each phase follows an S-curve. More: the cost per MW build-up.

Step 3: Lease the campus

Pre-leased share and lease-up ramp for each phase, rent per kW-month with its escalator, operating costs per energized MW and the management fee. NOI is the sum. More: revenue per MW.

Step 4: Model the power recharge

IT energy from leased MW and average draw, billed at the lease PUE (1.35) and bought at the achieved PUE (1.25). Show the margin as its own line; it is not revenue. More: the PUE margin.

The course builds this model with you, one module per step

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 5: Finance construction

Commitment = (loan to cost + interest reserve) × approved budget = 476.1m. Equity first, then the loan up to loan to cost, then extra equity; interest on the opening balance, paid from NOI or the reserve. No circular reference. More: interest during construction.

Step 6: Refinance at stabilization

Once fully leased, size the stabilized loan on value, debt yield and cover; here loan to value binds at 712.9m and 272.8m goes back to equity. More: how much debt a data centre supports.

Step 7: Compute returns

Yield on cost 11.44%, spread 469 bps, value 1,296.2m, and the IRR of quarterly flows, annualized by compounding: 17.55% unlevered, 25.32% to equity. More: yield on cost.

Step 8: Stress it, and add checks

Run delay, overrun, rent, lease-up, rates and exit one at a time and together (the stress takes the IRR to 12.73%), then add integrity checks: sources equal uses, loan roll-forward, leased never above energized. More: delay or rent miss.

The trap: letting the construction loan grow with an overrun or a delay. Lenders commit to an approved budget; in the case a 10% overrun is 69.3m of extra equity, and the model must show it.

Start from the free template: data center financial model, or get the full quarterly model: Data Center Development Model, Pro Edition.

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 goes into a data center development model?

A timeline with grid tranches, cost per MW and phasing, leasing and NOI, the power recharge, a construction loan and the refinancing, returns, scenarios and integrity checks.

Should a data center model be monthly, quarterly or annual?

Quarterly is a good compromise for a phased campus: fine enough to see a grid delay or a lease-up ramp, simple enough to audit. Annual hides the timing that decides the result.

How do you avoid circular references with construction interest?

Charge interest on the opening balance, size the commitment on the approved budget with an explicit interest reserve, and fund spending in a fixed order: equity first, the loan, then extra equity.

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 →