Skip to content
The Financial Modeller
Build free
Energy retail and services

EV charging network financial model, built free.

A three-statement Excel model for an EV charging network operator, built from your own figures and checked to balance.

  • Free account
  • No card
  • Usually ready within the hour

We use generative AI in parts of our process, so mistakes can occur. Every model should be checked by a person before it is relied on. Read more

The business

Builds and operates public fast-charging, destination and fleet-depot chargers, earning a price per kWh plus session, idle and subscription fees above electricity and demand charges, as utilisation ramps with electric vehicle adoption.

See the sampleHow the model works

In short

  • 01

    Three linked statements

    Income statement, balance sheet and cash flow, linked in every period.

  • 02

    Valued and tested

    Discounted cash flow, with scenarios on the key drivers.

  • 03

    Monthly to annual

    Monthly, quarterly, half-yearly or annual periods, for up to 30 years.

  • 04

    Checked every period

    A Checks sheet shows the balance sheet balances and the cash reconciles.

The sample

The sample, as Excel draws it.

Built by the same system and checks as yours, on illustrative figures: every sheet as Excel draws it, or live.

Annual · 10 years · Low detail
EV charging network sample model.xlsx
The Summary sheet of the sample EV charging network model

Illustrative figures: the sample describes no real business. The live preview shows values; your model’s Excel file has every formula.

How it works

How the model works for an EV charging network.

  1. How it earns revenue3 formulas
    Charging revenue · All charging sites
    Charging revenueEnergy delivered to vehiclesPrice per kWh
    Charging revenue · All charging sites
    Energy delivered to vehiclesPlugs in the cohort when completefrom charging site register and rolloutShare of the cohort in operation over the periodfrom charging site register and rolloutDays in periodThroughput per plug per day
    Oil, gas and LNG sales · Oil and gas asset 1
    Oil, gas and LNG salesOil, condensate and NGL salesGas sales
  2. What drives its costs3 formulas
    Electricity cost · All charging sites
    Electricity costElectricity drawn from the gridAll-in tariff
    Site operating costs · All charging sites
    Site operating costsMaintenance and warrantySoftware, network and communicationsPayment processingSite host rent
    Royalties and resource taxes · Oil and gas asset 1
    RoyaltiesWellhead valueRoyalty rate
  3. What it invests in3 formulas
    Charger capex and depreciation · All charging sites
    Charger and site capexChargers installedGrid connection and civil works
    Charger capex and depreciation · All charging sites
    Charger depreciationDepreciation of the opening book valueDepreciation of chargers added
    Charger capex and depreciation · All charging sites
    Charging assets net book valueClosing book value of live sitesBook value of chargers added (closing)
  4. How it is funded3 formulas
    Debt
    Closing balanceOpening balanceDrawdownsRepayments
    Debt
    Interest expenseOpening balanceAll-in interest rateshare of the year
    Equity raising
    Equity raisedEquity raised (net of costs)Equity from an offer, milestone funding, conversions and creditor shares
  5. How profit becomes cash3 formulas
    Working capital
    Trade receivablesRevenuefrom statementsDebtor daysDays in period
    Working capital
    InventoryDirect costs (positive)from statementsInventory daysDays in period
    Working capital
    Trade payablesCash operating costs (positive)from statementsCreditor daysDays in period
What it covers

24 parts, each one tested.

Every part is a tested building block with its own checks: yours is put together from the ones your business needs.

  • CPI forecastCPI glide path
  • Operating expensesFixed plus variable operating expenses
  • Corporate costsFixed cost base indexed to CPI
  • Working capitalDays-based working capital
  • Income taxCorporate rate with tax losses
  • DebtSingle debt facility
  • Equity raisingScheduled equity raisings
  • Discounted cash flow valuationDCF on free cash flow to the firm
  • Energy and utility KPIsUpstream unit metricsThe ratios investors and lenders use to judge energy and utility businesses.
  • Key-metric summaryLast-twelve-month and run-rate metrics
  • Discount rate (WACC)CAPM at target gearing
  • Burn and runwayRunway to the forecast cash-out date
  • Exchange rate (US dollar)Flat exchange rate
  • Charging site register and rolloutRollout by annual cohortThe plugs, power rating and commissioning timing every other part of the model builds on.
  • Charging revenuekWh per plug per day × priceEnergy delivered to vehicles and the revenue from it, plus session, idle, subscription and fleet fees.
  • Electricity costAll-in tariff per kWhThe cost of electricity delivered to vehicles, including network demand charges.
  • Site operating costsCost per charger plus host rentMaintenance, software, payments and site host costs.
  • Charger capex and depreciationInstalled cost per plug by charger classChargers, grid connections and civil works, grants received, replacements and depreciation.
  • Field and project registerInterest, reserves and book valueWorking interest, reserves and carrying value of each field or LNG project.
  • ProductionExponential declineOil, gas and LNG volumes produced each period (net to the company's interest).
  • Oil, gas and LNG salesBenchmark × differential by productRealised prices × volumes for oil, condensate, gas and LNG.
  • Royalties and resource taxesRoyalty on wellhead valueGovernment and private royalties, production sharing and petroleum resource taxes.
  • Production costsCost per boeLifting, processing, transport and liquefaction costs.
  • Capex, depletion and explorationUnits-of-production depletionDevelopment and sustaining capex, exploration spend, and depletion of oil and gas properties.
Key numbers

The numbers it tracks.

  1. 01sites and plugs
  2. 02utilisation (kWh per plug per day)
  3. 03revenue and margin per kWh
  4. 04site EBITDA
  5. 05capex per plug net of grants
  6. 06payback
Used for

What it is used for.

Also used for
  • Scenarios and sensitivities
Related models

More in energy retail and services.

Every energy and utilities model

Looking for an EV charging network financial model template? Ours arrives built for your business, with your figures in it.

See a finished model, sheet by sheet

The sample is built on illustrative figures and describes no real business. Models are calculations prepared from the information you provide. They are not financial advice and must be independently verified. See our terms.