Pro models

Data Center Development Model Excel Template, Pro Edition

A quarterly development model for a data center campus in up to three phases: grid tranches and rent commencement, cost per MW and S-curves, pre-leasing and lease-up, rent per kW-month, PUE and the power recharge, a construction loan with equity first and an interest reserve, the refinancing, the sale, and three scenarios side by side, with 36 built-in checks.

Get this model inside the course: $199 instead of $99

Data Center Development & Finance includes this model, plus a 31-page Course Book, an Excel workbook that checks your answers and a 162-question quiz with a final exam. Each module of the course has its own sheet in the model.

Get the course with the model, $199 → · Try a module free

Enter the grid tranches, the cost per MW, the three phases, the leasing, the rent and energy terms, the loans and the exit. The workbook finds the quarter each phase can start paying rent, spends the budget along S-curves, leases the campus, bills the power, draws and repays the construction loan without a circular reference, sizes the refinancing on three tests, and returns yield on cost, development spread, value created, IRR and multiple, for Base, Downside and Stress at once.

Data Center Development Model, Pro Edition: $99

One zip file: the model with a worked example, a blank copy and an 18-page PDF user guide. Single-user license.

Buy now, $99 →

Secure checkout by Stripe. Want to learn the whole analysis? Data Center Development & Finance, the course, includes this model ($199). The free data center financial model stays free.

Dashboard of the Data Center Development Model, Pro Edition: cost, NOI, yield on cost, value, IRR, three scenarios and charts
The Dashboard: the selected scenario, Base, Downside and Stress side by side, NOI and leasing by year.

What the model does, sheet by sheet

Blue text on a pale yellow fill marks an input; every other cell is a formula.

Inputs
Turnkey or powered shell, seven cost lines per MW and contingency, grid tranches and peak PUE, three phases, S-curve, rents and operating costs, energy terms, SOFR by year, construction loan, refinancing, sale, three scenarios.
Market
Dated benchmarks (cost per MW, rents, cap rates, PUE, grid timelines) against the model's own figures.
Power
Utility MW per phase, the tranche that serves it, building ready against power available, rent commencement, energized MW.
Budget
Budget and approved budget, land at closing, the grid over its quarters, each phase along its S-curve.
Leasing
Leased MW by phase with pre-leasing and ramp, rent with escalation, operating costs, management fee, NOI, forward NOI, replacement reserve.
Energy
IT energy, tariff, power billed at the lease PUE and bought at the achieved PUE, power margin.
Financing
Commitment, equity first, loan draws, interest paid from NOI or capitalized, extra equity, the three refinancing limits and the stabilized loan.
Returns
Equity and project cash flows, IRR (annualized), multiple, yield on cost, development spread, value created, value per MW.
Scenarios and Engine
Base, Downside and Stress run in full, side by side, whatever scenario the module sheets show.
Checks
36 integrity controls, a master check and 6 alerts.
Financing sheet of the Data Center Development Model, Pro Edition: construction loan by quarter and refinancing
The Financing sheet: equity first, loan draws, interest on opening balances, the refinancing limits.

The worked example

Harlow Ridge Data Campus, a fictional 60 MW turnkey campus in three phases from 2027. Amounts in $ millions:

MeasureValue
Rent commencement, phases 1 to 3Q3 2028, Q3 2029, Q3 2030
Budget / total development cost721.4 / 765.1
Cost per MW / value per MW12.75 / 21.60
Stabilized NOI / yield on cost / spread87.5 / 11.44% / 469 bps
Peak construction loan / stabilized loan432.9 / 712.9
Equity IRR / unlevered IRR / multiple25.32% / 17.55% / 3.93x
Stress: equity IRR / extra equity12.73% / 69.3
Powered shell on the same site: yield on cost11.27%
Checks sheet of the Data Center Development Model, Pro Edition
The Checks sheet: 36 integrity controls, a master check and the alerts a lender will ask about.

Technical notes

Questions people ask about it

Does the model use macros or circular references?

No. Interest is charged on opening balances, the loan commitment is sized on the approved budget with an explicit interest reserve, and spending is funded in a fixed order, so the workbook calculates in one pass.

How is it different from the free data center model?

The free model compares turnkey, powered shell and powered land on a 180 MW site and runs one monthly cash flow. The Pro edition models three phases tied to grid tranches, leasing by phase, the power recharge, a real construction loan and refinancing, three scenarios side by side and 36 checks. The free model stays free.

Does it work in Google Sheets and LibreOffice?

Yes. It uses standard functions only and was recalculated and verified cell by cell in LibreOffice. Charts may look slightly different outside Excel.

What does it leave out?

Tax and depreciation, demand charges and on-site generation, rent-free periods, and more than three phases or two grid tranches. The guide lists every simplification.

Is there a course that uses it?

Yes: Data Center Development & Finance ($199) teaches the whole analysis on the same campus and includes this model.

Can I use it on a live project?

Yes, the blank copy is built for that. The license is single-user, the example campus is fictional and nothing in the model is investment advice.

Data Center Development Model, Pro Edition: $99

Buy now, $99 →