Skip to content

Behind the model

How the data centre model works

Every number in the model is worked out from your inputs; nothing is hidden. Below is each formula, paired with a worked example from the default 10 MW Tier III colocation build (space, power and cooling rented to other companies’ servers). Change any input in the model and the same formulas apply.

Sizing

Total IT load (the power the tenants’ servers can draw) is the sum of the build phases: the schedule sets the capacity, not a separate input. The facility settings then work out the number of data halls, racks and the main power and cooling equipment, with the spares the tier needs (N+1 means one spare of each).

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 and shared spares

each phase’s base units are sized from its own MW; the spare unit 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

Equipment subtotal

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

₹85.8 Cr

Set-up cost (CapEx)

The power and cooling equipment, plus site-wide costs (paid once), plus the costs for each data hall, then a buffer for surprises and interest during construction. Every line is tagged by what it is for (land, building, power, cooling, IT, security, soft costs), which also drives depreciation and maintenance. Cost per MW is worked out, never assumed.

Site-wide costs (paid once)

Σ site-wide lines

₹89.8 Cr

Costs for each data hall

Σ per-hall lines × number of halls

₹38.5 Cr × 5 = ₹193 Cr

By what it is for

every line sorted into land, building, power, cooling, IT, security or soft costs

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

Subtotal

equipment + site-wide + per-hall

₹368 Cr

Buffer for surprises (contingency)

subtotal × 8%

₹29.4 Cr

Interest during construction (IDC)

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

18 months → ₹17.9 Cr

Total project cost

subtotal + buffer + IDC

₹415 Cr

When costs are paid (upfront or phased)

upfront = paid once with phase 1 (land, grid, design…); phased = paid in proportion as each phase is built. The buffer and IDC are split so upfront + phased = total.

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

Build price rise

each phase’s phased cost × (1 + 5%)^(build year). Phase 1 (year 0) has no rise, so a build in one go is unaffected; staging later raises the as-built total.

5% a year

Land: own or lease

owned land sits in the set-up cost; leased land is left out of it and paid as a yearly running cost instead

owned: ₹31.8 Cr in the set-up cost

Stamp duty on land

land value × 6%: owned land only, added to the land cost (never depreciated, insured or maintained). 5–7% depending on the state; Uttar Pradesh and Tamil Nadu data centre policies waive it.

₹1.8 Cr

GST (planning note, not a model line)

18% GST applies on equipment and construction services; the GST on the building shell can’t be claimed back (section 17(5) of the CGST Act), so budget it as cost

enter cost lines including GST

Set-up cost per MW (worked out)

total project cost ÷ IT load

₹41.5 Cr / MW

Running costs (OpEx)

Electricity grows with the capacity built and how full it is, with an option for overhead that runs whatever the load. Maintenance is split by asset type on the depreciable cost; insurance is on the installed assets, not land. Generator fuel and (when land is leased) the land lease are separate lines. Fixed costs rise 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)

once leased up: ₹98.3 Cr a year

Power pass-through (revenue)

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

recovered ₹98.3 Cr a year

Generator fuel

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

year 1: ₹1.9 Cr a year

Maintenance (split by asset type)

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

₹9.7 Cr a year (with yearly rises)

Insurance (land left out)

installed assets, not land, × 0.35% a year

₹1.55 Cr a year

Upkeep only on what is built

in a staged build, maintenance, insurance and generator-test fuel scale with the share already built; phases not yet built carry no upkeep

single build: full base from year 1

Land lease (leased land only)

land value × 8% a year: only when land is leased

owned → 0 (land is in the set-up cost)

Fixed lines escalate

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

staff, connectivity, property tax

Revenue

One rent per kW of IT power the tenants take, covering space, cooling and service but not electricity. Tenants’ electricity is billed on top when pass-through is on. Capacity, occupancy and lease-up (how fast tenants fill the space) all live in the build schedule: total IT load is the sum of the phases, one phase is a build in one go, and more phases build it in stages.

Rent revenue

occupied IT kW × rent per kW a month (₹7,200) × 12 × (1+esc)^(yr−1) + (pass-through ? energy : 0)

once leased up: ₹188 Cr a year

Power pass-through

pass-through on → tenant energy billed on top of the rate; off → you absorb the power cost

on: recovered ₹98.3 Cr a year

Lease-up (per phase, straight line)

start + (steady − start) × (age − 1) ÷ (years to fill − 1)

40% → 95% over 4 years (starting phase)

When a phase opens (set year, or when the previous one fills)

phase 1 opens in its set year; a later phase either has a set year or opens once the previous phase reaches its fill level, plus the years to build

70% full + 1 year to build (default for added phases)

One schedule for everything

the phases are the only schedule, capacity = Σ phase MW; each phase is paid for the year before it opens and fills on its own curve; site-wide costs are carried by the first phase

site-wide costs carried by phase 1

Loan, tax and depreciation

A long infrastructure loan with an interest-only holiday (moratorium) while tenants fill the space, straight-line depreciation split by asset type, and tax with losses carried forward.

Loan and your money

loan = total cost × loan% ; your money = the rest

₹249 Cr loan · ₹166 Cr your money

Repayment holiday (moratorium)

interest only for the first N years after opening, then repay principal

3-year holiday, 12-year loan term

Equal principal repayment

loan ÷ (loan term − holiday) in each repayment year

₹27.7 Cr

Fixed EMI option

loan × r ÷ (1 − (1+r)^−(loan term − holiday))

same payment every year

Interest

outstanding balance × interest rate

year 1: ₹24.9 Cr

Depreciation (straight-line, by asset type)

building cost ÷ building life + equipment cost ÷ equipment life (from the build-cost categories; land left out, soft costs, buffer and IDC shared in proportion)

30-yr building · 12-yr equipment

Tax (with loss carryforward)

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

shelters early-year losses

Returns and loan cover

Cash flows before any loan give the project return; cash flows after the loan give the return on your money. The project return leaves out the tax saved on interest, so it does not depend on how you borrow.

Operating profit (EBITDA)

revenue − running costs

once leased up: ₹68.1 Cr (36% margin)

Project cash flow

EBITDA − project tax − set-up cost (project tax ignores interest)

project return (IRR) 13.9%

Cash to you

PAT + depreciation − principal − set-up cost paid from your money

return on your money 18.9%

Value above your hurdle (NPV)

Σ project cash flow ÷ (1 + minimum return)^t

@ 11% = ₹105 Cr

Payback

year the running total of project cash flow first turns positive

9.4 yr

Loan cover (DSCR)

cash for loan (CFADS) ÷ loan repayment ; CFADS = EBITDA − tax (repayment years only)

min 1.29× · avg 1.53×

Loan-life cover (LLCR)

today’s value of CFADS over the loan’s life ÷ loan

1.30×

Money back per ₹1 (equity multiple)

Σ cash returned to you ÷ your money put in

5.83×

Sale value at the end (exit)

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

₹939 Cr

Break-even occupancy

steady-state occupancy at which NPV = 0

80%

Energy, water and carbon

What the facility uses and emits once leased up, and the physical limit on how many racks fit.

Actual power overhead (PUE)

facility power ÷ IT power (at or above the design figure when some overhead is fixed)

1.50

Design availability (by tier)

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

Tier III: 99.982% → 1.6 hours a year

Carbon

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

89,163 tonnes CO₂e a year

Water

WUE × IT energy

149.8 million litres a year

What limits the build

min( racks by power, by server floor, by cooling )

power-limited

These are planning estimates you can check line by line, not a quote. The typical Indian figures are assumptions from public sources, not ClarWorks data, and every one can be changed in the model. Open the model →

Advisory · Project report and bank finance

Taking this to a bank? Get the numbers checked first.

We go through your model with you: the assumptions, the costs, the loan structure and the risks. If you need one, we write the detailed project report your bank will appraise. The loan decision is always the bank’s; our job is to make your case clear and complete.

  • Free 30-minute first call, online
  • Paid work quoted before it starts
  • Direct with the person doing the work

Replies within 24 hours. Prefer WhatsApp? Message us

Funded and getting ready to open? We also build the software a business runs on: orders, billing, stock, and WhatsApp ordering. Fixed scope, fixed price, in writing before work starts.