Appendix C
In this chapter · 4 sections
Decision Tables & Calculators
The irreversible decisions in this guide reduce to a handful of arithmetic checks; this appendix is the live calculator layer that runs them, plus the static reference tables that anchor it.
What you'll decide here
- Use the live Calculators for TCO and $/GPU-hr, inference $/M-tokens, facility energy/water and rack-cooling screens. Calculations run in your browser; sharing encodes inputs in a URL fragment, and an explicit signed-in Save uploads a scenario to your account.
- Use the rack-cooling feasibility matrix and redundancy design-basis checklist to collect the evidence two inputs cannot supply: named interfaces, maintenance/fault states, surviving capacity and recovery limits decide whether a design closes.
- Treat every default in the calculators as a placeholder, not a recommendation — replace it with your own quoted capex, contracted power price, measured throughput, and real utilization before you trust an output.
- Carry the outputs back to the chapter that owns the decision: the TCO/token math to Chapter 1.8, the project-finance ratios to Chapter 2.5, the cooling verdict to Chapters 5.1 and 5.4, and the redundancy choice to Chapter 12.1.
- Validate a calculator result against the named equipment schedule and the dated figures in Appendix D before it enters a decision — the model screens, it does not qualify equipment.
This appendix is realized as a live, interactive tool in the site, not a wall of worked arithmetic. The suite is ten calculators — cluster sizing, GPU TCO and cost per GPU-hour, inference cost per million tokens, training-run cost, build cost per megawatt, facility energy/water, rack-cooling feasibility, reliability requirements, site scoring, and the CFADS project-finance model — sharing one scenario, so a change to the rack, the power price or the utilization flows through every connected calculator (site scoring stands alone). What lives on this page is the reference layer around the tool: what each calculator computes, the assumptions baked into its formula, and the static tables that are more useful seen whole than queried one value at a time. The expensive decisions in this guide reduce to checks you can run. Does the named rack's heat split close on air, on a rear door, or only on direct liquid? Which maintenance and fault states must the facility ride through, and is a second full path worth more than a faster checkpoint? Can a contracted cash flow service its debt at the coverage its lease profile has to clear — an investment-grade triple-net lease and a short-lease colocation portfolio sit at very different rating thresholds? Each is a few lines of arithmetic, and getting it wrong at scoping time is how facilities end up mismatched to the revenue they were built to earn.
What each calculator computes
| Calculator | Inputs · unit · allowed range · default | Outputs | Shared-scenario connection | Owning chapter |
|---|---|---|---|---|
| Cluster sizing — model → MW Key lever: Peak demand, throughput assumption, and serving headroom | Sizing basis (mode) · Inference demand / Training fleet · default Inference demandActive training GPUs ( trainGpus) · GPUs · 1–10,000,000 · whole number · default 10000Model size ( params) · B params · 0.1–100,000 · default 70Bytes / param ( bytes) · bytes · 0.01–16 · default 1KV cache / token ( kvKb) · KB · 0–100,000 · default 330Context length ( ctx) · tok · 1–10,000,000 · whole number · default 32000Concurrent requests / replica ( conc) · requests · 1–1,000,000 · whole number · default 64Activation + framework overhead ( ovh) · % · 0–500 · default 15HBM per GPU ( hbm) · GB · 1–10,000 · default 288Peak demand ( demand) · tok/s · 1–1,000,000,000,000 · default 50000Throughput / replica ( tput) · tok/s · 1–1,000,000,000,000 · default 11200Serving capacity ( util) · % · 1–100 · default 70Qualified GPUs / replica ( replicaGpus) · GPUs · 1–10,000 · whole number · default 8GPUs / rack ( perRack) · GPUs · 1–10,000 · whole number · default 72Purchase quantum ( purchaseQuantum) · GPUs · 1–10,000 · whole number · default 72GPU TDP ( tdp) · W · 1–10,000 · default 1400Host overhead ( host) · × GPU TDP · 0.1–10 · default 1.3393PUE ( pue) · ratio · 1–2.5 · default 1.15Underwriting rental rate ( price) · $/GPU-hr · 0–1,000 · default 5 | VRAM / replica GPUs / replica Replicas Active GPUs Installed GPUs Stranded GPUs Installed racks Facility design draw Fractional fleet rental | Connected 19/19 · all fields | Chapters 9.7 / 10.11 |
| Build cost — $/MW capex Key lever: IT MW, scope boundary, and regional multiplier | IT capacity (mw) · MW · 0.001–100,000 · default 0.135Facility, land & utility works ( facility) · $M/MW · 0.01–100 · default 11.8Network & cluster infra (excl. servers) ( fitout) · $M/MW · 0.01–100 · default 4.9Project-priced facility premium ( premium) · % · 0–200 · default 0Regional multiplier ( region) · × · 0.1–10 · default 1 | Facility capex Network & cluster infra Total (excl. servers) $/W excl. servers | Connected 4/5 Local only: premium | Chapter 2.5 |
| Training run — cost & time Key lever: MFU × goodput and cluster size | Model size (params) · B params · 0.1–100,000 · default 70Training tokens ( tokens) · T tokens · 0.001–1,000,000 · default 15Peak per GPU ( pflops) · PFLOPS · 0.001–1,000 · default 2.5MFU ( mfu) · % · 1–100 · default 40Cluster size ( gpus) · GPUs · 1–10,000,000 · whole number · default 10000Goodput ( goodput) · % · 1–100 · default 90Rental rate ( price) · $/GPU-hr · 0–1,000 · default 5GPU TDP ( tdp) · W · 1–10,000 · default 1400Host overhead ( host) · × GPU TDP · 0.1–10 · default 1.3393PUE ( pue) · ratio · 1–2.5 · default 1.15Power price ( power) · $/kWh · 0–10 · default 0.08Grid carbon ( co2) · gCO₂/kWh · 0–10,000 · default 384 | Wall-clock GPU-hours Rental cost Energy CO2 | Connected 12/12 · all fields | Chapter 12.2 |
| Project finance — CFADS, DSCR & IRR Key lever: Revenue ramp, leverage, and rate | Retained fleet earning period (earningYears) · yr · 0–100 · whole number · default 5Project minimum DSCR ( covenantDSCR) · × · 0–10 · default 1.35Total capex ( capex) · $M · 0.01–10,000,000 · default 8.5041Construction period ( constructionYears) · yr · 0–20 · whole number · default 1Debt / leverage ( leverage) · % · 0–100 · default 60Interest rate ( rate) · % · 0–100 · default 7Debt term ( term) · yr · 1–100 · whole number · default 5DSRA ( dsraMonths) · mo · 0–120 · default 6Grace period ( graceYears) · yr · 0–99 · whole number · default 0Revenue (stabilized) ( revenue) · $M/yr · 0–10,000,000 · default 3.1536Ramp to stabilized ( rampYears) · yr · 0–50 · default 1Contract term (take-or-pay) ( contractYears) · yr · 0–100 · whole number · default 3Revenue growth ( revGrowth) · %/yr · -100–100 · default -15Opex ( opex) · % of rev · 0–100 · default 25Sustaining capex ( sustaining) · % of rev · 0–100 · default 3Cash tax rate ( taxRate) · % · 0–100 · default 21Tax depreciation life ( deprLife) · yr · 1–100 · default 10Hold period ( hold) · yr · 1–100 · whole number · default 5Exit multiple ( exitMult) · × EBITDA · 0–100 · default 0NPV discount rate / stated equity hurdle ( discount) · % · 0–100 · default 10 | Equity IRR Project IRR Min DSCR (CFADS) Equity ($M) NPV ($M) Equity NPV ($M) Equity multiple Retained-fleet decision | Connected 20/20 · all fields | Chapter 2.5 |
| GPU TCO & $/GPU-hour Key lever: Owned-use utilization and depreciation life | Annual-average IT load (averageLoadPct) · % of nominal · 0–100 · default 100Server cost ( serverCost) · $ · 0–100,000,000 · default 6249600GPUs / server ( gpus) · GPUs · 1–10,000 · whole number · default 72Depreciation life ( years) · yr · 0.25–20 · default 5GPU TDP ( tdp) · W · 1–10,000 · default 1400Server power multiplier ( host) · × GPU TDP · 0.1–10 · default 1.3393PUE ( pue) · ratio · 1–2.5 · default 1.15Power price ( power) · $/kWh · 0–10 · default 0.08Owned-use utilization ( util) · % · 1–100 · default 70Installed / active allocation ( installedPerActive) · × · 1–100 · default 1.2857Opex ( opexPct) · %/yr · 0–100 · default 8Facility / colocation charge ( facilityRate) · $/kW-month IT · 0–10,000 · default 147.2222Contract rental comparator ( rental) · $/GPU-hr · 0–1,000 · default 5 | $/active GPU-hr Annual cost/active GPU Depreciation Energy Opex Facility charge Breakeven utilization vs rental | Connected 13/13 · all fields | Chapter 1.8 |
| Inference $/M tokens Key lever: Throughput assumption and owned-use utilization | Rented node cost (rentalPerHr) · $/hr · 0–1,000,000 · default 40Owned node calendar cost ( ownedPerHr) · $/hr · 0–1,000,000 · default 34.2007Throughput ( tps) · tok/s · 1–1,000,000,000 · default 11200Owned-use utilization ( util) · % · 1–100 · default 70 | $/M tokens — rented capacity $/M tokens — owned capacity | Connected 4/4 · all fields | Chapter 10.11 |
| Facility energy & water Key lever: IT load, PUE, and WUE | Annual-average IT load (averageLoadPct) · % of nominal · 0–100 · default 100Nominal installed IT power ( it) · MW · 0–100,000 · default 0.135PUE ( pue) · ratio · 1–2.5 · default 1.15Power price ( power) · $/kWh · 0–10 · default 0.08WUE ( wue) · L/kWh IT · 0–100 · default 0.4 | Average facility power Annual energy Annual energy cost Annual water | Connected 5/5 · all fields | Chapter 15.1 |
| Rack cooling feasibility Key lever: Named equipment heat split and the complete facility envelope | Current rack power (screening input) (rack) · kW/rack · 1–1,000 · default 135Upper roadmap rack heat load (screening input) ( future) · kW/rack · 1–1,000 · default 228Heat captured to liquid ( liquid) · % of rack heat · 0–100 · default 90Future heat captured to liquid ( futureLiquid) · % of rack heat · 0–100 · default 90Liquid path qualified at both operating points? ( liquidPath) · No / Yes · default NoQualified liquid-path capacity ( liquidCapacity) · kW/rack · 0–1,000 · default 0Required terminal approach ( approach) · K · 0.1–50 · default 5Air delivery/inlet envelope proven at both duties? ( airflow) · No / Yes · default NoRack water connection available? ( water) · No / Yes · default NoRear-door system qualified? ( rdhx) · No / Yes · default NoQualified door heat-capture duty ( doorCapture) · kW/rack · 0–1,000 · default 0Future door heat-capture duty ( futureDoorCapture) · kW/rack · 0–1,000 · default 0Current TCS supply to rack ( tcsSupply) · °C · -20–120 · default 35Current TCS return from rack ( tcsReturn) · °C · -20–120 · default 45Current FWS supply to CDU ( fwsSupply) · °C · -20–120 · default 30Current FWS return from CDU ( fwsReturn) · °C · -20–120 · default 40Future TCS supply to rack ( futureTcsSupply) · °C · -20–120 · default 35Future TCS return from rack ( futureTcsReturn) · °C · -20–120 · default 45Future FWS supply to CDU ( futureFwsSupply) · °C · -20–120 · default 30Future FWS return from CDU ( futureFwsReturn) · °C · -20–120 · default 40Room residual-air capacity ( residual) · kW/rack · 0–1,000 · default 20 | Current rack heat Liquid heat Residual air heat Preliminary cooling feasibility Future liquid heat Future residual air heat Current cold-end approach Current hot-end approach Future cold-end approach Future hot-end approach | Connected 3/21 Local only: futureLiquid, liquidPath, liquidCapacity, approach, airflow, water, rdhx, doorCapture, futureDoorCapture, tcsSupply, tcsReturn, fwsSupply, fwsReturn, futureTcsSupply, futureTcsReturn, futureFwsSupply, futureFwsReturn, residual | Chapter 5.4 |
| Reliability requirements Key lever: Complete state-and-path design basis | Concurrent maintainability required? (cm) · No / Yes · default YesRide through one component failure? ( fault) · No / Yes · default No | Concurrent-maintenance requirement Single-component-fault requirement Topology decision Required project evidence | Connected 2/2 · all fields | Chapter 12.1 |
| Site-scoring playbook Key lever: Kill gates before the weighted score | Power availability / speed-to-MW (power) · /10 · 0–10 · default 7Interconnect & permitting ( interconnect) · /10 · 0–10 · default 6Power price / PPA ( price) · /10 · 0–10 · default 6Land & expandability ( land) · /10 · 0–10 · default 7Water & climate ( water) · /10 · 0–10 · default 6Incentives / tax ( incentives) · /10 · 0–10 · default 5 | Site score Assessment | Independent 0/6 Local judgment inputs; not inferred from the project scenario | Chapter 3.13 |
The TCO model supplies the owned node calendar-cost basis used by the token model. The token calculator compares rented and owned $/M-tokens on the same guide throughput assumption and owned-use utilization. It has no sell-price input and no margin output. The facility energy/water calculator takes IT MW, PUE, power price, and WUE as inputs, then returns facility MW, annual MWh, annual energy cost, and annual litres. Cluster sizing reports active, installed, and stranded GPUs separately so fractional demand is never mistaken for purchasable rack capacity.
Rack-cooling feasibility reference matrix
Rack kW is the screening input, and it narrows the field fast: rear-door exchangers carry a typical 30–40 kW rack and past 50 kW with active doors, while an HPE GB200 NVL72 at 132 kW puts 115 kW into liquid and leaves 17 kW on air — a rear door sees the air exhaust, not the 115 kW already assigned to cold plates. What kW cannot tell you is which of the remaining candidates closes for the named rack, because two racks at the same draw split their heat differently. The matrix below is the checklist behind Chapter 5.1 and Chapter 5.4: for each candidate, the evidence that rules it in.
| Candidate | Required evidence and facility conditions | Decision boundary |
|---|---|---|
| Qualified air-only | 0% liquid capture; named airflow, pressure, inlet and containment envelope closes through the roadmap case | Air-only remains feasible inside that declared envelope |
| Rear-door-assisted air | Air path plus qualified rear door, rack water, door heat-capture duty and room residual-heat path | RDHx may be feasible; rack kW alone does not establish it |
| Direct liquid + residual air | Named liquid heat fraction, supported TCS/FWS/CDU path, and residual heat within the room's redundancy-case limit, either directly or after a qualified rear door's stated capture | DLC is feasible for the named equipment and facility envelope |
| No closing envelope | Any required equipment, airflow, water, residual-air, service or roadmap condition fails | Change the envelope or density; do not force a technology from kW alone |
Redundancy-topology selector
The live tool takes two requirements — concurrent maintainability, and ride-through of one component fault — and deliberately fails closed on topology and cost: it reports the two requirements and the evidence a topology decision needs, and it does not pick a topology or price a premium, because the state list below is what does that. Project topology requires named maintenance and fault states, the exact affected path, transfer interruption, post-event loading, path and control independence, common-mode dependencies, a recovery SLO, and workload and contract consequences. The starting map is nonetheless simple, and the register supports it. Neither requirement leaves N on the table. Concurrent maintainability alone needs a path you can take out of service with the load held — N+1 components on dual distribution paths (one active), or a distributed-redundant block. Fault tolerance needs a second path that carries the load through a fault — 2N, 2(N+1), or a distributed block designed for it — and that step carries a ~25–40% whole-facility planning premium (single-source heuristic) over the concurrently maintainable design. Which topology inside the class, and what the premium is for your project, follows from the checklist: which paths each state takes out, how the load transfers, what survives, and what the contract charges for the difference. Carry the completed list to Chapter 12.1 for the topology and Chapter 12.5 for the number.
| Required project input | What must be specified before topology selection |
|---|---|
| Named maintenance and fault states | Enumerate each planned-maintenance isolation and unplanned-fault state by subsystem. |
| Exact affected path | Identify the source-to-load power, cooling, network, fuel, and control path affected in each state. |
| Transfer interruption | State whether transfer is open or closed transition and the maximum interruption at the protected load. |
| Post-event loading | Show surviving-path and component loading, including derating, overload duration, and reserve margin. |
| Path and control independence | Prove physical, electrical, mechanical, and control independence through the declared state. |
| Common-mode dependencies | Declare shared switchgear, controls, auxiliaries, fuel, water, rooms, routes, vendors, and operator actions. |
| Recovery SLO | Define detection, isolation, restart or failover, restoration, and return-to-normal deadlines. |
| Workload and contract consequence | Quantify lost work, degraded capacity, request or job impact, revenue loss, and contractual remedy for each state. |
Project-finance model: the ratios that gate a deal
The levered-IRR / project-finance model is the companion to Chapter 2.5. Its mechanics are a standard infrastructure pro-forma: build a contracted (or merchant) revenue line, subtract opex to EBITDA, discount the unlevered free cash flow to an NPV and unlevered IRR, then layer the debt structure to solve for levered IRR. The DSCR (cash available for debt service ÷ debt service) sizes how much leverage the cash flow can carry. Lower billable utilization or rental price reduces receipts against operating cash and scheduled debt payments. Use Chapter 1.8’s matched ownership/rental cash-flow case for the capacity commitment, then Chapter 2.5’s DSCR case for the funding bridge; a procurement saving does not establish debt coverage. Build the sensitivity ranking by running high and low inputs against the displayed annual cash-flow bridge: which assumption — utilization, power price, GPU residual, depreciation life, contract tenor — moves the answer most. The bridge shows revenue, cash costs and taxes, CFADS, interest/principal, reserves, and equity cash; terminal proceeds and debt payoff remain separate. Enter a retained-fleet earning period and project covenant before reading its decision. Sustaining spend creates no replacement fleet: passing DSCR does not demonstrate that a later GPU refresh is funded. In the 2026 market, the dominant fork is contracted versus merchant, because it sets both the discount rate and the achievable gearing.
| Term | What it measures | Contracted (offtake-backed) | Merchant (uncontracted) | Note |
|---|---|---|---|---|
| DSCR (min) | CFADS ÷ debt service — the coverage cushion | ~1.20–1.35x long-term contracted; ~1.05–1.10x investment-grade NNN lease | No merchant data-center band published | BBB criteria: colocation ~1.30–1.75x; contracted ~1.20–1.35x; investment-grade NNN ~1.05–1.10x. Covenants require the agreement. |
| Gearing (debt %) | Debt as share of capital stack | Higher (offtake supports leverage) | Lower (equity-heavy) | Contract quality directly enables debt capacity |
| Discount rate / WACC | Hurdle the cash flows must clear | Lower (investment-grade backstop) | Higher (price + offtake risk) | Bifurcation of cost of capital is the 2026 market inflection |
| Unlevered IRR / NPV | Project return before financing | Set by capex, utilization, price | Same drivers, wider band | Rank the sensitivities here — one model run per assumption, high and low |
| Levered IRR | Equity return after debt | Amplified by cheap, deep debt | Thinner debt → less amplification | The headline equity number; sensitive to rate and depreciation |
Scope & caveats
Select on the named door/rack, air and water conditions, fan state, containment, heat-capture target, residual room heat, climate/rejection, serviceability, redundancy, and future density.
Reference capacity, not a universal ceiling; verify named door/rack, water and air conditions, fan state, containment, and capture target.
Scope & caveats
Exact HPE product profile. Keep this 132 kW / 115 kW liquid / 17 kW air record separate from the OCP MGX Rev. 1.1 reference profile of 120 kW / approximately 102 kW liquid / 18 kW air.
Scope & caveats
Rating-category thresholds for SPE non-recourse project debt, keyed to lease profile. They are not observed lender covenant minimums, and the source publishes no merchant data-center category.
Criteria bands, not market minimums: a project's covenant, its CFADS definition and its amortization structure are set in the facility agreement. The general Table 2 categories (Low/Medium/High risk) carry materially higher thresholds than the data-center table.
Scope & caveats
Secondary-source whole-facility planning estimate quoted by Savills in May 2024; no disclosed estimating population or method. No universal multiplier follows from Uptime Tier criteria.
Single-source planning heuristic: Savills (May 2024) attributes it to Dgtl Infra, which publishes no sample, geography, density or estimating method. The older ~10–25% inverts a McKinsey 2011 statement (10–20% saving moving Tier IV→III). Uptime Tiers are outcome-based, so no universal cost multiplier follows from the standard; re-estimate against the actual design.
Assumptions that control the calculator results
Back-of-envelope models are only as honest as their assumptions:
- TCO is straight-line. It amortizes capex evenly, adds a facility charge per kW of IT so the result compares with a rental rate that already includes space and power delivery, allocates installed units to active units, and applies opex as a flat percentage. Owned-use utilization is the cost denominator; billable capacity factor is separate.
- Token economics start from a guide assumption. Rented and owned $/M-token outputs use the same throughput and owned-use utilization. Replace throughput with a steady-state measurement from the same hardware, model, precision, context, batch/concurrency, latency target, and replica boundary. There is no sell-price or gross-margin model.
- PUE and WUE are planning inputs. The tool annualizes IT load at 8,760 hours; it does not infer PUE/WUE from metered facility loads or model seasonal load/weather variation.
- Cluster sizing separates quantities. Active GPUs follow workload demand; installed GPUs round up to the purchase quantum, and the stranded remainder is reported rather than absorbed.
- Cooling is an envelope check. Rack kW is one input alongside the named liquid/residual heat split, qualified airflow/inlet and rear-door conditions, water availability, room residual capacity, climate/rejection, redundancy, serviceability, and the future density tail.
- Reliability inputs are requirements only. The two requirement choices set the topology class, not the topology; they do not predict availability or price the delta. The build-cost premium is an explicit local input from a priced, like-for-like project comparison.
Cite this chapter
Fehn, J. (2026). Decision Tables & Calculators (Chapter C). The Definitive Guide to AI Data Centers. https://aidatacenterguide.com/appendix-appendices-and-reference-data/c-decision-tables-and-calculators (accessed 2026-09-29).
@misc{aidc-C,
author = {Fehn, Jacob},
title = {Decision Tables & Calculators (Chapter C)},
howpublished = {The Definitive Guide to AI Data Centers},
year = {2026},
url = {https://aidatacenterguide.com/appendix-appendices-and-reference-data/c-decision-tables-and-calculators},
note = {Accessed 2026-09-29}
}