Data Centre Project Finance & Colocation Model with Power-Constrained Capacity (Excel)

Description
Almost every data centre model in circulation is a real estate model with the words "data centre" on the cover. It takes square feet, applies a rent, escalates it, subtracts an operating cost ratio and capitalises the result. That works for an office block. It does not work here, because this asset is not constrained by floor area. It is constrained by the megawatts the utility has agreed to deliver.

POWER IS THE BINDING CONSTRAINT
The grid connection divided by design PUE gives the IT load you can actually sell - cooling, distribution and losses take the difference - and that figure is a hard ceiling no lease-up plan can breach. Contracted IT load times the average customer draw against committed power gives the load drawn; that times PUE gives facility load; facility load against the connection gives headroom. The Checks tab tests, on every one of the twenty operating years, that the headroom is not negative and that the power balance reconciles exactly. Revenue then follows from the same quantities rather than from an unrelated rent roll: rent on committed IT load, metered energy recharged at cost plus a margin, and cross-connects per megawatt contracted.
The practical consequence is that this file will tell you your plan cannot be built. A real estate model will not, because it never asked the question.

DEBT IS AN OUTPUT, NOT AN INPUT
A lender runs two tests and lends the lesser of them: what the cash flow services at a target cover ratio, and what the asset supports as a share of cost. The model computes the DSCR capacity in closed form - the present value of CFADS over the tenor divided by the target ratio, one division, no goal seek and no solver - computes the loan-to-value cap on capitalised project cost, draws the lesser of the two, and names the binding constraint in words on the Dashboard.

NO CIRCULAR REFERENCES
Twenty-four monthly construction columns take the capital spend through an S-curve you control, fund it at your target gearing, and capitalise the arrangement fee, the commitment fee and the interest during construction month by month. Because interest is charged on the balance at the start of each month, the ledger resolves left to right - no cell depends on itself, and iterative calculation stays switched off. The sculpting recursion is removed the same way, by rolling it forward and solving it algebraically rather than iterating.

LEASE-UP, AND THE REFINANCING IN BETWEEN
A campus is energised with an empty hall and fills over several years, and the financing has to survive that gap. The construction facility remains outstanding on an interest-only basis while the hall fills, with any interest the ramping cash flow cannot pay capitalised rather than assumed away. At the start of the stabilisation year the permanent facility is sized on the stabilised cash flow and drawn to repay it: a shortfall is an equity injection the model shows you, a surplus is released to the sponsor, and the Checks tab reconciles the refinancing to the cent.

THE CONTRACT BOOK IS A BRIDGE
Opening contracted load plus new contracts less churn equals the closing book, capped by the power ceiling, with the average book carrying revenue and the whole ramp shifted by an energisation delay you can set. That delay is the sensitivity that matters on a data centre in this market, and it is one of two exact one-way tables on the Returns tab: every case rebuilds the contract book, recomputes revenue, cost and tax, revalues the exit and re-solves the rate of return, with the workings on the same tab so you can audit them. A campus energised nine months late has spent every dollar of its capital and earned nothing, and this is what that costs.

FOURTEEN INTEGRITY CHECKS
Every one must read PASS before you quote a number. Four of them exist only because this model treats the asset as a power business: the power balance reconciles every year, facility load never exceeds the grid connection, the contract book never exceeds the capacity ceiling, and the book bridge ties year by year. A model built on floor area cannot run them, because it never computes the quantities they test.

THE WORKED EXAMPLE
A 34 MW grid connection at 1.35 PUE, which sells 25.19 MW of IT load, against 24.0 MW of capacity built. Leased up over four years at $155 per kW per month. Capitalised project cost of 325.3 million, a permanent facility of 211.5 million where the LTV cap binds rather than the cover ratio, a project return of 9.68% and an equity return of 12.88%, with a minimum cover ratio of 1.86 times.
Twelve tabs: Read Me, Dashboard, Assumptions, Construction & Funding, Power & Capacity, Contracted Capacity, Revenue & Costs, Debt Sizing, Debt Schedule, Cash Flow, Returns, Checks. Live formulas throughout. No macros, no add-ins, no external links, no locked cells and no passwords. Opens in Excel, LibreOffice, Numbers and Google Sheets.

This workbook models the arithmetic of your own project. It is not investment advice, and the worked example is invented.