Unlike most charging models available online, this one is built around European project reality: capex-percentage grant schemes, per-kWh tariffs net of VAT, and EU-typical hardware, installation and grid-connection costs — with three charger classes (AC 22 kW, DC 50 kW, DC 150 kW) modelled independently through a 60-month calculation engine.

WHAT THE MODEL IS FOR

You are planning an EV charging site and someone — a bank, an investor, a landlord, a grant committee, or you — needs credible numbers. Enter your charger mix, supplier quotes, energy contract and tariffs, and read a complete investment case: monthly P&L for 5 years, debt schedule, NPV, project IRR, equity IRR, payback period, breakeven month and a sensitivity map.

WHAT IS INSIDE

– 5-year, 60-month calculation engine: monthly P&L down to net income

– Three charger classes modelled independently: any mix, any counts — from one AC wallbox to a multi-DC hub

– EU grant and subsidy logic: enter your national scheme’s percentage of capex; financing and depreciation adjust automatically

– Full debt schedule: monthly annuity amortization with any loan-to-cost, interest rate and term

– Tax with loss carryforward: early losses correctly offset later profits

– Scenario engine: Base, Upside and Downside with editable multipliers on utilization, tariffs, electricity cost and opex

– Returns analysis: NPV, unlevered project IRR, levered equity IRR, payback period

– Sensitivity matrix: steady-state annual EBITDA across utilization and tariff variations

– KPI dashboard with charts: revenue, EBITDA, breakeven month, equity required

– Utilization ramp-up logic, because no site opens at full load

HOW TO WORK WITH IT

All inputs sit on one Assumptions sheet as colour-coded cells (blue text on yellow fill). Setup takes about 20 minutes with the included illustrated User Guide and FAQ. The default case is a realistic mid-size EU site (4x AC 22 kW, 2x DC 50 kW, 1x DC 150 kW) so you see how the model behaves before entering your own quotes. Every formula is visible and editable. No macros anywhere in the file, so nothing gets blocked by corporate IT. Runs in Excel 2016 or newer, Excel for Mac, Excel Online and LibreOffice.

WHY THIS TEMPLATE

It was built by an industry professional working in the EV charging supply chain, not adapted from a generic template. The cost defaults, grant treatment and utilization logic reflect how European charging projects are actually financed and operated. The 5-year horizon deliberately carries no terminal value, so NPV and IRR read conservative — exactly the posture lenders respond to.

WHO IT IS FOR

Charge point operators, electrical installers preparing client proposals, site owners in retail, parking and hospitality, fleet managers evaluating depot charging, consultants building business plans, and grant applicants who need bank-credible numbers.

The free PDF preview shows every sheet, the modelling logic and real output figures from the default case. All v1.x updates are free to buyers.

You must log in to submit a review.