Free Excel templates

A free data center financial model: three business models, one campus

A 180 MW campus underwritten as turnkey, powered shell or powered land, a monthly construction cash flow, levered returns, and what a rent miss, a delay and a correlated downside each cost.

The same 180 MW site can be three different businesses. Built turnkey at $11 million a megawatt it yields 10.9% on cost; as a powered shell at $5 million, 10.2%; sold as powered land it is a trade, not a building. This model underwrites all three and then runs the monthly cash flow: a base levered return of 22.6%, and 18.1% if energization slips twelve months.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

The_Underwrite_Computed.xlsx (51 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

Need the full project or fund? The Pro Editions go further: Development (60 months, S-curves, senior and mezzanine loans, JV waterfall), $99 → · Fund (up to eight assets, European or American waterfall), $129 →

The book behind this model

This file is one worked case from The Data Center Development Handbook. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

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

Go further than this free model

Data Center Development Model, Pro Edition: three phases tied to grid tranches, cost per MW and S-curves, pre-leasing, PUE and the power recharge, a construction loan with equity first and an interest reserve, the refinancing, three scenarios side by side and 36 checks. $99 → · See what is inside

Data Center Development & Finance, the course: eight modules from power to stabilised value on one 60 MW campus, an Excel workbook that checks your answers, a 162-question quiz with a final exam, and the Pro model included ($199). Try module 3 free →

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

Real Estate Fund Model, Pro Edition: a closed-end fund with up to eight assets, fees, European or American waterfall, 30 built-in checks, a blank copy and a 19-page guide. $129 → · See what is inside

REPE Interview Prep Pack: 18 real estate PE interview cases solved step by step, with three Excel models. $129 →

Real Estate Acquisition and Development Model, Pro Edition: monthly ground-up model over 60 months, S-curves, senior and mezzanine loans, bulk or unit sale, JV waterfall, 33 checks, a 14-page guide. $99 → · See what is inside

The Pro Models Bundle: LBO, Development and Fund models, Pro Editions. $199 instead of $327 → · See what is inside

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 19 paperbacks by Julian R. Sterling on energy, infrastructure and land, printed on demand and shipped worldwide. Browse the bookshop →

The three business models

TurnkeyPowered shellPowered land
Capital cost per MW$11m$5m
Rent, $ per kW-month10545
Yield on cost10.9%10.2%
Value created$794m$327m$33.4m

What goes wrong, in basis points

ScenarioLevered returnAgainst base
Base (3% rent escalator)22.6%
Rent 8% below plan20.2%-239 bp
Energization 12 months late18.1%-450 bp
Correlated: delay, +5% cost, -8% rent, +25bp exit cap14.5%-809 bp

The delay costs more than the rent miss, and it has to be funded: $94.8m of new equity, because lenders do not enlarge a construction loan for delay. And the combined case is not the sum of its parts. Run it, do not add it.

What is in the file

1. The Inputs
Capacity, capital cost, rents, NOI, exit caps, loan to cost and hold. The inputs the book does not state are marked ADDED, with the reason.
2. The Three Models
Turnkey, powered shell and powered land reconciled to the figures the chapter prints.
3. The Cash Flows
Monthly, five scenarios side by side, each driven by its own parameter block.
4. Scenarios
Levered returns and capital calls side by side, in basis points.
5. The Escalator
What a point of rent escalation is worth over a fifteen-year lease.
6. Powered Land
The hit rate at which buying and entitling land breaks even, in one cell.
7. Checks
Thirty-one controls, all passing as shipped.

Questions people ask about it

Turnkey or powered shell?

Turnkey earns the higher yield on cost and the higher rent, and carries the fit-out and the tenant risk. The model shows both on the same site so the choice is a number, not a view.

Where does the construction interest rate come from?

It is derived, not invented: the chapter's own figure for the interest cost of a twelve-month slip, on its own drawn balance.

Can I change a single scenario?

Yes. Each scenario column on the cash flow sheet has its own parameter block.

Is it free?

Yes, and nothing is locked. An email address opens the download.

The rest of the files

This template is one of the companion files for The Data Center Development Handbook: the full set adds a blank model set, working documents, forty self-marking questions and three worked cases. Free, like this one.

Open the companion files →

Worked questions from the same book

Short articles that each answer one question with the arithmetic shown, on the same ground as this model.

Other free templates

This template comes from The Data Center Development Handbook. The book is on Amazon.

If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.