Companion files
Data Centers, Fiber, Towers and the Power Behind AI by the Numbers, With the Models Supplied
These are the companion files of The Digital Infrastructure Investor 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).
The Excel workbooks that go with the book. One infrastructure fund studies and buys three assets: Halvard DC1, a data center leased to a hyperscale cloud provider with a pre-leased expansion waiting for its grid connection; Oakmere Fiber, a fiber-to-the-home network half built; and Pellam Towers, 850 wireless towers. The data center costs $900 million, and its signed lease pays back 34.2% of that price. The same building earns 10.69% on equity after a retrofit and -2.98% if its halls are stranded, with identical rent until year 8. Every figure the book prints is reproduced here by live formula and checked.
Free to download. No sign-up, no email address, nothing to fill in.
The four workbooks, the blank models, the timed test, six working documents, three new worked cases and the read-me. Each file can also be downloaded on its own below. Last revised 15 November 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.
Chapters 2 to 7 and 15
The lease at $138 per kW per month on 32 MW, the power clause and its energy margin ($2.42 million in year 1), phase 2 and its grid connection, the four outcomes at lease end, three valuation methods from $557.1 million to $1,616.7 million, the acquisition loan and the refinancing one year before the lease ends. Base case equity IRR 10.23%; a power price 4.0% above the assumption from year 5 already takes it below 10 percent.
Download189 KBChapters 8 to 11
Sixty thousand homes passed building to 120,000, penetration by cohort, ARPU, churn, EBITDA and free cash flow, the open access variant (7.55% against 10.34% for retail) and the grid of penetration against cost per home passed. 10 percent needs 39.4% penetration.
Download191 KBChapters 12 to 14
850 towers, tenancy ratio 1.45 at purchase, ground leases and buyouts (a buyout returns 9.32% held at 16 years of rent, 11.50% sold at the tower multiple), the operator merger, the debt and its covenants. Equity IRR 10.06%.
Download70 KBChapters 16 and 17
The three assets' equity cash flows in nine scenarios. Portfolio equity IRR 10.21% in the base case and 4.05% if the next chip generation arrives early, although fiber and towers are untouched.
Download36 KBFor your own assets
A single-tenant data center lease, a built fiber network and a tower portfolio, compact and empty. Nothing computes until every yellow cell is filled; a Progress sheet counts what is left.
Download15 KBPractice
A new small case: a 12 MW data center, a fiber cluster and a tower cluster. Twelve questions marked as you type, and an answer key computed by live formula from the case.
Download10 KBSix pages to print and use. A4, with margins wide enough for US Letter.
Chapter 19 · Appendix B
The Appendix B diligence lists for the data center (two pages: lease, tenant, power and PUE; then grid, cooling, capital spending and residual value), the fiber network and the tower portfolio, each item with a column for status, owner and note. A threshold register that sets each governing input beside the value at which it breaks, from the power price (+4.0% takes equity below target) to tower tenancies (0.0296 a tower a year). And the Chapter 19 calendar: the first month, quarter, midyear and year, then the four dates that force a decision.
Download the PDF23 KBNew material, not a restatement. Three questions the chapters raise and leave without a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Every figure is the book’s; nothing is assumed that is not solved for.
Chapters 6 and 7 · Case one
Chapter 6 rightly refuses to put odds on the four endings. The price can still be read for the odds it needs. At 10 percent the renewal is worth $8.9m above the equity paid and the re-letting $228.0m below it, so the purchase meets its target only if the chance of a re-letting stays under 3.7% (2.4% for a stranding). Even the retrofit leaves room for one bad ending in eight. And why averaging the four IRRs (5.38%) answers nothing.
Chapter 15 · Case two
The variant Chapter 15 says the model does not compute. A loan the year-7 refinancing could repay without new equity, whatever the tenant decides, is $128.4m, not $495.0m. Equity at closing nearly doubles and the renewal falls to 8.98%. Keeping the book’s loan and amortizing to the same balloon would need $97.1m a year: 0.82x coverage, a default from year 3.
Chapter 17 · Case three
Chapter 17 sells half the data center at cost and leaves the co-investor’s price unpriced. The base portfolio stays at 10% for a discount of up to 4.82% on the half sold ($10.3m); at that price the chips-early row still gains 1.94 points. The ceiling is set by the target, not by the protection.
Download the three cases29 KB| Units | Millions of US dollars unless a cell says otherwise; rent in dollars per kW per month; energy in MWh. |
| Time | Purchase at year 0, ten years of ownership, sale at the end of year 10; annual cash flows at year end. Year 11 is used only for the data center's forward NOI at exit. |
| Returns | Equity IRR after debt and unlevered IRR before it, all before tax. Fiber carries no debt. |
| Checks | Each main workbook has a Checks sheet: printed figure, live value, numeric gap, status, and an overall status that reads PASS only if every check passes. |
| Inputs | Yellow cells with blue type. Nothing is typed inside a formula. |
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. They use no macros and no links to other files, so nothing needs to be enabled or trusted. Everything in the case is fictional and nothing here is investment advice.
| 15 Nov 2026 | Added six working documents to print (the Appendix B diligence lists, a threshold register, the Chapter 19 calendar) and three new worked cases: the odds the price assumes, a loan that could refinance itself, and the price of selling half the data center. The four workbooks are unchanged and their checks still pass. |
The books closest to this one. The full list of titles is on the author page.
9 of the calculations in these workbooks, worked out in full. All articles.
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.