This page publishes the formulas, conventions, scenario multipliers and sources behind the EV Charging ROI Calculator (engine v2.2.0), so every number on the dashboard can be traced and challenged. The engine is unit-tested, including golden tests against the reference franchise case; independent review by a project-finance and a tax professional is recommended before large commitments.
Conventions
- Money: INR, decimal arithmetic (no binary floats in schedules), banker's rounding to paise.
- Rates are percentages; annualization is effective: (1 + monthly)¹² − 1.
- Cash-flow timing: month 0 is the investment; flows land at month-end; terminal items land in the final month.
- Escalations compound annually (year index = ⌊(month − 1) ÷ 12⌋).
- Delivered-energy utilization = delivered kWh ÷ (rated site kW × available hours). Available hours already include uptime.
Demand & energy
delivered kWh = rated kW × chargers × hours/day × days/mo × uptime × utilization grid kWh = delivered ÷ (1 − losses) + auxiliary kWh sessions = delivered ÷ kWh per session
Ownership model
blended price = retail × (1 − fleet share) + fleet price × fleet share
net revenue = delivered × blended price × (1 − commissions% − land share%)
electricity = grid × energy charge × (1 + duty%) + fixed charges + demand charge × kVA (structured mode)
= grid × landed tariff (flat mode)
EBITDA = net revenue − electricity − variable opex − fixed opex (incl. land rent / opportunity cost, post-warranty step-up)
project FCF = EBITDA − unlevered tax ± dated items (replacement, expected subsidy, ITC, deposits)
equity FCF = EBITDA − interest − principal − levered tax ± dated items
tax = WDV depreciation per asset-class line (per-line rate override, else global), net of ITC, with loss carry-forward
CFADS = EBITDA − cash taxes − replacement capex (subsidy/ITC treated as restricted and excluded;
working-capital movements are not modelled)
CFADS DSCR = CFADS ÷ (interest + principal) — the lender measure driving bankability verdicts
EBITDA DSCR = EBITDA ÷ (interest + principal) — the broad measure, shown for reference
residual value = residual % × cash cost of residual-ELIGIBLE physical assets only (soft costs excluded)
LCOC = PV(capex + all operating costs + tax) ÷ PV(delivered kWh)
break-even util = (fixed costs + fixed electricity + aux cost) ÷ (full-utilization kWh × margin/kWh)
— quoted both without and with monthly debt service (EMI)Franchise model
One of two payout waterfalls is selected explicitly — they are never combined:
A) MAX waterfall: payout = MAX(minimum guarantee, distributable cash × investor share) B) Guarantee + excess: payout = minimum guarantee + MAX(units − threshold, 0) × excess rate guarantee top-up (franchisor obligation) = MAX(guarantee − entitlement⁺, 0) contractual terminal = buyback base × buyback % (base: ex-GST / incl-GST / fixed — always explicit) risk-adjusted terminal = contractual × recovery % total ROI = net profit ÷ investment paid; MOIC = total received ÷ invested (never called ROI) full obligation coverage = station operating cash ÷ (all investor payouts + terminal)
Three return views, never conflated:
Contractual: every promised rupee is paid on time
Credit-adjusted: each future flow × survival(month), survival = (1 − monthly hazard)^month,
monthly hazard = 1 − (1 − annual default probability)^(1/12);
the terminal is floored at MIN(secured amount, contractual terminal) when
hard security (deposit / escrow / bank guarantee) is entered
After-tax: monthly income × (1 − tax rate); terminal treated as capital return (verify with tax adviser)
Real IRR: (1 + nominal IRR) ÷ (1 + inflation) − 1Scenario multipliers
Scenarios re-run the full engine on adjusted inputs — they never scale final outputs. The exact multipliers:
| Scenario | Demand | Price | Energy cost | Fixed opex | Capex | Uptime | Buyback recovery |
|---|---|---|---|---|---|---|---|
| Stress | ×0.55 | ×0.9 | ×1.1 | ×1.1 | ×1.15 | ×0.93 | ×0.5 |
| Conservative | ×0.8 | ×0.95 | ×1.05 | ×1.05 | ×1.05 | ×0.97 | ×1 |
| Base | ×1 | ×1 | ×1 | ×1 | ×1 | ×1 | ×1 |
| Strong site | ×1.3 | ×1.05 | ×1 | ×0.98 | ×1 | ×1 | ×1 |
Model checks
Checks are grouped into input validity (failures block all results), arithmetic reconciliation, operating viability, investor attractiveness (NPV vs your hurdle, IRR, payback source) and bankability (DSCR, obligation coverage). Reconciliation passing never implies the investment is attractive.
Assumption sources
- Ministry of Power — Guidelines for Installation and Operation of EV Charging Infrastructure (2024) [verified]
Published 2024-09-17 · effective 2024-09-17–2028-03-31 · India (central framework; state tariff orders override). PCS supply tariff capped at Average Cost of Supply (ACoS) until 31 Mar 2028. Illustrative solar-hour tariff 0.7×ACoS, non-solar 1.3×ACoS. Service charge ceilings ₹3/₹4 per kWh (AC, solar/non-solar) and ₹11/₹13 per kWh (DC, solar/non-solar). Public-land revenue share reference ₹1/kWh. - Illustrative national ACoS reference (~₹7/kWh) [estimated]
Published 2024-09-17 · effective 2024-09-17 · India (illustrative; use the applicable DISCOM tariff order). Actual ACoS varies by state/DISCOM (~₹6–9/kWh). The state tariff order selected by the user must override this. - TGERC FY 2026–27 Tariff Schedule — LT-IX EV charging stations [verified]
Published 2026-03-30 · effective 2026-04-01–2027-03-31 · Telangana. LT-IX EV charging energy charge ₹6/kWh. The model's electricity-tariff input should be the LANDED cost per grid kWh (energy charge + fixed/demand charges + duty), which is typically above the bare energy charge — enter your DISCOM bill's effective rate. - Site-type utilization benchmarks (internal advisory estimates) [estimated]
Published 2026-07-25 · effective 2026-07-25 · India (South India advisory experience). Urban 15%, highway 12%, mall 18%, office 20%, fuel station 15%, fleet depot 35%, bus/truck hub 40%, destination 10% — internal advisory estimates, NOT measured industry data. Validate against local operating stations before relying on them. - Reference franchise acceptance case (320 kW cluster DC) [user_supplied]
Published 2026-07-25 · effective 2026-07-25 · India. ₹38,00,000 ex-GST + 5% GST; 60-month term; ₹57,000/month minimum guarantee; 22,800 kWh/month threshold; ₹2.60/kWh excess-unit rate; 50% buyback after 5 years; maintenance included.
Known limitations
- Utilization-method demand only (no session-level or hourly ToD modelling yet).
- Single charger type per calculation; no gun-level power sharing.
- No Monte Carlo; risk is handled through scenarios, sensitivity and the credit-adjusted view.
- Site-type utilization benchmarks are internal advisory estimates, not measured industry data.
- GST/ITC and depreciation treatments are simplified — confirm with a chartered accountant.
Version history
- v2.2.0 (2026-08-03)
Investment Committee Edition: CFADS-based DSCR (EBITDA − cash taxes − replacement capex; subsidy/ITC excluded as restricted) now drives bankability checks and verdicts, with the EBITDA measure retained as a labelled secondary; assumption-verification checklist gating an 'indicative result' banner (land terms, GST/ITC, DISCOM estimate, charger quote, debt term sheet, replacement reserve); MoP 2024 DC service-charge ceiling check on the implied service component (₹11 solar / ₹13 non-solar); per-line depreciation-rate overrides by asset class and residual value restricted to eligible physical assets; exports carry CFADS schedules, provenance and the methodology URL; canonical/Open Graph/Twitter metadata and FinanceApplication structured data. - v2.1.0 (2026-08-03)
Composite headline verdict (weakest link drives the sentence) with sticky summary; tariff provenance states (estimated / preset-provisional / user-verified) with verification guardrails; automatic double-counting warnings (rent, deposits) and explicit field-exclusion help; per-line depreciable flags (deposits/working capital excluded from the asset block); 'unsecured counterparty promise at 100% recovery' warning; staged monthly capex/debt drawdowns with paid vs capitalized IDC (capitalized IDC raises EMI and the depreciable base); demand confidence band; 5-step Advanced flow. - v2.0.0 (2026-08-03)
Structured DISCOM tariff build-up (sourced Telangana LT-IX preset), land models (lease / revenue share / owned incl. opportunity cost), fleet–retail blended pricing, gateway/platform commissions, construction period, loan processing fee, probability-weighted dated subsidy, major-replacement capex, post-warranty opex step-up, per-line capex GST with ITC receipt, refundable deposits. Franchise: activation and settlement delays, credit-adjusted returns (annual default probability, security floor), investor tax view, inflation-adjusted IRR. - v1.1.0 (2026-08-03)
External-review fixes: blocking input validation, categorized checks (input / reconciliation / viability / investor / bankability), decision-verdict panel, scenario what-changed disclosure, contractual vs risk-adjusted terminal split, full obligation coverage, income-only payback, per-break-even session figures. - v1.0.0 (2026-08-03)
Initial release: ownership and franchise models on one decimal-arithmetic engine, golden-tested against the 320 kW reference franchise case.