ClarWorks

Behind the model

How the data center model works

Every number in the calculator is derived bottom-up from your inputs — no black box. Below is each formula, paired with a worked example from the default 10 MW Tier III colocation build. Change any input in the tool and these relationships hold.

Sizing

Total IT load is the sum of the build phases (capacity is defined by the schedule, not a standalone input). The intensity and land inputs then derive the hall count, rack count and the auto-sized critical equipment (with tier redundancy).

Total IT load

Σ phase MW (the single capacity input)

10 = 10 MW

Data halls

⌈ IT load ÷ MW per hall ⌉

⌈ 10 ÷ 2 ⌉ = 5

Total racks

⌊ IT load × 1000 ÷ rack kW ⌋

⌊ 10000 ÷ 8 ⌋ = 1,250

Facility power

IT load × PUE

10 × 1.5 = 15.0 MW

Equipment count (Tier III = N+1)

⌈ served load ÷ unit rating ⌉ + 1 spare

DG: ⌈ 15 ÷ 2 ⌉+1 = 9; UPS: 21

Per-phase sizing & pooled redundancy

each phase's base units are sized from its own MW; the redundancy spare is added once (with phase 1) and shared across the facility, not repeated per phase

a 5+5 MW build keeps the same 9 DG sets as a one-shot 10 MW build

System sub-total

Σ (unit count × unit cost), all four systems

₹85.8 Cr

CapEx — build cost

Auto-sized systems + shared infra (once) + per-hall infra (× halls), then contingency and interest-during-construction. Every line carries a function, so the same numbers roll up into a clean MECE taxonomy that also drives depreciation and maintenance. Per-MW is an output, never an assumption.

Shared / core infra (×1)

Σ shared line items

₹89.8 Cr

Per-hall infra (× halls)

Σ per-hall items × hall count

₹38.5 Cr × 5 = ₹193 Cr

By function (MECE)

every line classified into Land / Building / Power / Cooling / IT / Security / Soft

Land ₹31.8 Cr · Building & civil ₹132 Cr · Power & electrical ₹128 Cr · Cooling & mechanical ₹33 Cr · IT / white-space ₹20 Cr · Security & BMS ₹10 Cr · Soft costs ₹13 Cr

Sub-total

systems + shared + per-hall

₹368 Cr

Contingency

sub-total × 8%

₹29.4 Cr

Interest during construction (IDC)

total × debt% × interest% × (months ÷ 12) × ½

18 mo → ₹17.9 Cr

Total project cost

sub-total + contingency + IDC

₹415 Cr

Cost timing (upfront vs phased)

upfront = built once with phase 1 (land, grid, design…); phased = drawn pro-rata as each phase commissions. Contingency + IDC are allocated so upfront + phased = total.

₹101 Cr upfront + ₹314 Cr phased = ₹415 Cr

Construction-cost escalation

each phase's phased capex × (1 + 5%)^(build year). Phase 1 (year 0) is unescalated, so a single-phase build is unaffected; staging later raises the as-built total.

5%/yr

Land (Own vs Lease)

owned land sits in CapEx; leased land is dropped from CapEx and recovered as an annual OpEx

owned — ₹31.8 Cr in CapEx

Stamp duty on land

land value × 6% — owned land only, capitalized into the land basis (never depreciated, insured or maintained). 5–7% by state; UP/TN data-center policies waive it.

₹1.8 Cr

GST (planning note, not a model line)

18% GST applies on equipment and construction services; input tax credit on the civil shell is blocked u/s 17(5) CGST — budget unrecoverable GST on the building share as cost

enter cost lines GST-adjusted

CapEx per MW (derived)

total project cost ÷ IT load

₹41.5 Cr / MW

OpEx — annual running cost

Energy scales with online capacity and occupancy (with a part-load PUE option); maintenance is split by asset class on the depreciable base, insurance is on the installed base excluding land; genset fuel and (when land is leased) land lease are explicit lines; fixed lines escalate each year.

Facility power drawn

IT × occ + (PUE−1) × IT × (fixedOH + (1−fixedOH) × occ)

year 1: 6.0 MW

Energy cost

facility power × 8760 h × tariff × 1000 × (1+esc)^(yr−1)

stabilized: ₹98.3 Cr/yr

Power pass-through (revenue)

when pass-through is on, energy is billed back on the revenue side (margin-neutral)

recovered ₹98.3 Cr/yr

Generator fuel

facility power × test hours × 1000 × 0.27 L/kWh × diesel price × (1+esc)^(yr−1)

year 1: ₹1.9 Cr/yr

Maintenance (split by class)

building base × 1% + equipment base × 3% (land excluded)

₹9.7 Cr/yr (escalated)

Insurance (excl. land)

installed base excl. land × 0.35% / yr

₹1.55 Cr/yr

Upkeep only on commissioned assets

in a staged build, maintenance, insurance and genset-test fuel scale with the commissioned share of the as-built cost — phases not yet built carry no upkeep

single build: full base from year 1

Land lease (lease tenure only)

land value × 8% / yr — only when land is leased

owned → 0 (land in CapEx)

Fixed lines escalate

base × (1 + 5%)^(yr−1)

staff, connectivity, property tax

Revenue

A single power-exclusive rate per kW of occupied IT power — the space + cooling + service fee. Tenant power is recovered separately via the pass-through toggle. Capacity, occupancy and lease-up all live in the build schedule — total IT load is the sum of the phase MW; a single phase is the complete one-time project; add phases to stage the build.

Rent revenue

occupied IT kW × rate/kW/mo (₹7,200) × 12 × (1+esc)^(yr−1) + (pass-through ? energy : 0)

stabilized: ₹188 Cr/yr

Power pass-through

pass-through on → tenant energy billed on top of the rate; off → operator absorbs energy as a cost

on — recovered ₹98.3 Cr/yr

Occupancy ramp (per phase, linear)

start + (stabilized − start) × (age−1) ÷ (ramp yrs − 1)

40% → 95% over 4 yrs (default phase)

Phase commissioning (fixed year vs fill-triggered)

phase 1 commissions on its online year; a later phase either pins a fixed year or commissions when the PRIOR phase hits its fill threshold, plus a build lag

fill 70% + 1-yr lag (default for added phases)

Single-source phasing

phases are the only schedule — capacity = Σ phase MW; each phase draws capex the year before online and leases up on its own ramp; shared/upfront cost is carried by the first phase

shared infra carried by phase 1

Financing — debt, tax & depreciation

Long-tenor infrastructure debt with an interest-only moratorium during lease-up, straight-line split depreciation, and tax with loss carryforward.

Debt / equity split

debt = total cost × debt% ; equity = remainder

₹249 Cr debt · ₹166 Cr equity

Principal moratorium

interest-only for the first N years from first online, then amortize

3 yr grace, 12 yr tenor

Equal-principal repayment

debt ÷ (tenor − moratorium) each amortizing year

₹27.7 Cr

Annuity (EMI) option

debt × r ÷ (1 − (1+r)^−(tenor−moratorium))

level payment alternative

Interest

outstanding balance × interest rate

year 1: ₹24.9 Cr

Depreciation (straight-line, by class)

building-class base ÷ building life + equipment-class base ÷ equipment life (from the CapEx functional categories; land excluded, soft/contingency/IDC allocated pro-rata)

30-yr building · 12-yr equipment

Tax (with loss carryforward)

max(0, PBT − losses) × 25% ; losses carry forward

shelters early-year losses

Returns & coverage

The unlevered cash flows give the project view; the equity cash flows give the geared view. Project IRR excludes the interest shield so it is financing-independent.

EBITDA

revenue − operating cost

stabilized: ₹68.1 Cr (36% margin)

Unlevered (project) FCF

EBITDA − project tax − CapEx (project tax excludes interest)

Project IRR 13.9%

Equity FCF

PAT + depreciation − principal − equity-funded CapEx

Equity IRR 18.9%

NPV

Σ unlevered FCF ÷ (1 + discount)^t

@ 11% = ₹105 Cr

Payback

year cumulative unlevered cash flow first turns positive

9.4 yr

DSCR

CFADS ÷ debt service ; CFADS = EBITDA − tax (amortizing years only)

min 1.29× · avg 1.53×

LLCR

PV(CFADS over loan life) ÷ debt

1.30×

Equity multiple (MOIC)

Σ equity cash returned ÷ equity invested

5.83×

Terminal value at exit

exit multiple × final-year EBITDA (− capital-gains tax)

₹939 Cr

Break-even occupancy

stabilized occupancy at which NPV = 0

80%

Operations & ESG

What the facility consumes and emits at the stabilized run-rate, plus the physical capacity ceiling.

Effective PUE

facility power ÷ IT power (≥ design PUE when overhead is fixed)

1.50

Design availability (by tier)

Uptime Institute target; downtime = (1 − uptime) × 525,600 min

Tier III: 99.982% → 1.6 h/yr

Carbon

grid energy (net of renewables) × grid factor + diesel test energy × diesel factor

89,163 tCO₂e/yr

Water

WUE × IT energy

149.8 ML/yr

Binding constraint

min( racks by power, by white-space, by cooling )

power-limited

These are transparent planning estimates, not a quote. A real build needs a proper feasibility study — that’s where we help. Open the calculator →