xcalc — ROI / Payback

Inputs

kWh / location / day

Number of locations

Margin (profit) per kWh (€)

Net margin after all variable costs (your business assumption).

CAPEX per location (€)

OPEX per location per year (€)

Fixed yearly costs: rent, service, comms, etc.

Utilization factor (%)

100%

100% means “as entered”. Use <100% for ramp/down-time. >100% for upside.

Outputs

Annual gross margin

—

Annual OPEX

—

Annual net profit

—

Total CAPEX

—

Payback (years)

—

Formula: annualGross = kWh/day * 365 * locations * margin * utilization
annualNet = annualGross - (opex/location/year * locations)
paybackYears = totalCapex / annualNet