Companion file
Site Selection, Power, Permitting and the Deal, End to End
These are the companion files of The Data Center Development Handbook by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books · Google Play, and as a DRM-free PDF edition ($19.99).
These are the workbook and documents that go with the book. Chapter 13 works three business models on the same 180 MW site, prints a figure for each, and closes with a levered return in the high teens — a number it never builds. The original workbook builds it, on the chapter’s own figures. Around it: the same model with the inputs emptied, four printable working documents from the appendices, a question book that marks itself, and three cases the book names and never takes to a number.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Read the book already? An honest review on Amazon, good or bad, is what the next reader goes on: write a review. The files stay free either way.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Learn to develop and finance a data center campus, step by step: the Data Center Development & Finance course →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Appendix G · Chapter 13
The three models reconcile first. Turnkey at $11 million per MW is $1,980 million; at $105 per kW-month, gross rent is $226.8 million, yield on cost 10.86 per cent, stabilised value $2,774 million, value created $794 million, spread 311 basis points. The chapter prints about 227, 10.9 per cent, 2.77 billion, 790 and 310. Everything comes back. Nothing on this page is a disagreement about arithmetic.
The interest rate is taken out of the chapter, not out of the air. Chapter 13 says a twelve-month slip costs roughly $75 million of extra interest. At 60 per cent loan-to-cost the drawn balance is $1,188 million, so that implies 6.3 per cent. Used throughout, the delay case reproduces the chapter’s own figure rather than replacing it: $74.8 million of interest and $94.8 million all-in against the chapter’s “near $95 million”.
The levered return, and the assumption behind it. With no rent escalation the answer is 18.6 per cent — high teens, as the chapter says. With a three per cent escalator on the same lease it is 22.6. Four points of return sit between a flat lease and a three per cent one, on identical dirt and identical capital. Both are defensible; only one is stated.
The delay costs more than the rent miss, and here is the gap. On the chapter’s own basis, an eight per cent rent miss costs 257 basis points and a twelve-month energization slip costs 399. The chapter’s two claims are both right, and now measured. The correlated case — delay, five per cent cost overrun, rent miss and 25 basis points of exit cap — costs 809, and the capital call is 24.9 per cent of committed equity against 12.0 for the delay alone.
And one correction. Chapter 13 says an eight per cent rent miss reduces exit value by roughly $215 million. Its own arithmetic gives $222 million — and in giving it, shows what it assumes: that the shortfall never escalates. A first-year shortfall is a shortfall in the rent that escalates. Priced at the exit under the chapter’s own three per cent escalator, the loss is $273 million, twenty-three per cent larger.
Two numbers the chapter asks for and does not give. One point of escalator is worth 7.5 per cent of face rent over a fifteen-year lease — the exchange rate behind the chapter’s claim that escalators beat first-year rent. And the powered-land break-even hit rate is 25.8 per cent: a near-fourfold multiple on the winners is a losing business below one site in four. Thirty-one checks.
Download the workbook51 KBSet the escalator on sheet 1 to zero. The levered return falls from 22.6 per cent to 18.6 — the chapter’s “high teens”. That is the assumption behind the chapter’s headline number, and the chapter does not state it. Then set the hit rate on sheet 6 to one in five and watch the powered-land business lose money at a 3.9 times multiple.
It cannot tell you your own hit rate on powered land — that number lives in your pipeline history and nowhere else, and it is the one that decides whether the business is a business. It cannot tell you whether your utility will hold its energization date; utilities do not generally pay damages for missing one, which is why the chapter puts that risk in the “taken” box and not the “shifted” one. And it cannot price a re-leasing problem: a slip that trips a lease outside date stops being a return haircut and becomes a different project.
The underwrite with the same formulas and every input on sheet 1 emptied. Type your own site into it and the whole model re-solves.
Blank set · one workbook
Capacity, the two capital costs, the two rents and their net operating income, the exit caps, the loan to cost and the hold, then the added terms the chapter never states: the development period, the construction rate, the escalator, the cost of sale, the delay overheads and the draw profile, and the powered-land inputs. The checks sheet counts the inputs still empty and runs the tests that hold on any campus: turnkey costing more per MW than a shell, NOI below gross rent, a yield on cost above the exit cap, a hold longer than the build.
Put the book’s inputs back, listed in the archive, and the book’s figures come back with them: 10.9 per cent on cost, 22.6 per cent levered, 18.6 on flat rent, a 25.8 per cent break-even hit rate.
Download the blank set31 KBSix pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices A to D
The Appendix A site screening scorecard: the seven hard fails first, then sixteen weighted criteria with a score, a confidence and the evidence. The Appendix B first utility conversation: the package to assemble and the question groups to take in. The Appendix C diligence and document checklists, six groups from title to the closing binder, each item with an owner, a date and the document that closes it. And the Appendix D long-lead equipment tracker, from specification freeze to the float against the date the equipment is needed.
Download the PDF19 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
The numerical questions work the book’s own figures: the three business models of Chapter 13 and Appendix G, the levered return and its scenarios, the escalator and the powered-land hit rate, the Chapter 8 demand charge against load factor, and the Appendix D lead times. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by part of the book.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book16 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Case one · extends the ratchet in Chapters 5 and 8
A full-load commissioning test at 180 MW on a campus that draws 30 and ramps by 15 a month. The 80 per cent ratchet fixes billing demand at 144 MW for seven months and costs 4.54 million dollars of demand charges on capacity nobody used. Testing at 60 MW would have cost 36,000.
Case two · extends bridge power in Chapter 7
The chapter’s gap: 60 MW wanted in month 18, the grid in month 48. On illustrative costs, bridging with engines is worth about 28 million dollars; if the gas arrives nine months late it loses 4.7 million. Bridge power can rise to about 117 dollars a MWh before the answer changes: the margin on price is wide, the margin on time is not.
Case three · extends the minimum take in Chapter 5
The five years of naked exposure the chapter names, valued: 85.8 million dollars at lease expiry if nobody takes the space, 8.2 million expected at signing, 27.0 million in the worst case. A termination payment fixed at signing halves the bad case; a minimum take matched to the lease removes it.
Download the three cases31 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| ADDED | an input the book does not state — ten of them, each labelled with the reason |
| Checks sheet | thirty-one controls — five test the file against the book, and two sit side by side on the one figure it corrects |
Every figure is illustrative, as the campus in Chapter 13 is. The site, the tenant and the lender are the book’s own invented case; the development period, the interest rate, the draw profile and the escalator are added because the book does not state them, and each is an editable cell.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | Blank model set, four printable working documents, the question book and three new cases added. The workbook can now be downloaded on its own. Read-me rewritten. |
More in infrastructure and energy, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: data center financial model.
The Data Center Development Handbook develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisThese files accompany 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 workbook stays free either way.
The Data Center Operations Handbook picks up where this book stops: a 36 MW campus run for three years, its contracts, its power bill, its incidents and service credits, and the liquid-cooling retrofit. Its companion workbook is free.
See the operations companion files