Fleet Electrification Business Case Template: The CFO-Ready Framework

The average UK fleet manager spends 40+ hours building their electrification business case from scratch. Most of that time goes into hunting for the right numbers: What does a workplace charger cost installed? What tax reliefs are available this year? What does the 4-year TCO actually look like once you factor in BiK, NIC, VED and maintenance?

We built this template so you do not have to start from a blank spreadsheet. It is an Excel workbook with six sections, pre-built formulas and UK-specific defaults for 2025/26. Fill in your fleet data, adjust the assumptions, and you have a board-ready document in an afternoon instead of a month.

🔗 Download the Fleet Business Case Template — free, with email registration.

Why most fleet business cases fail at board level

Before walking through the template, it is worth understanding why so many electrification proposals get sent back. Based on feedback from fleet managers who use EVDC's tools, the three most common reasons are:

The numbers only cover fuel savings. A business case that says "we will save £X on diesel" misses half the picture. Boards want to see the full Total Cost of Ownership: capital cost, residual value, maintenance, insurance, taxation, charging infrastructure and incentives. The template forces you to capture all of these.

The risks are not quantified. Saying "residual values may fall" is not a risk register. Boards need to see the probability, the financial impact, and your mitigation plan. Section 6 of the template provides this structure.

There is no timeline. A compelling financial case with no implementation plan is an academic exercise. The template includes a milestone tracker so the board can see exactly when decisions need to be made, when infrastructure goes live, and when vehicles arrive.

Section 1: Fleet baseline

The first sheet captures where your fleet stands today. This is the foundation that every subsequent calculation builds on.

What to fill in:

The template asks for your current fleet composition: number of vehicles by type (car, van, HGV), average age, annual mileage per vehicle, current fuel type, and monthly fuel spend. It also captures maintenance costs, insurance premiums, downtime days per vehicle per year, and current CO2 emissions.

Why this matters: If you cannot quantify your current cost base, you cannot quantify the savings. The most persuasive business cases show the delta between today’s cost and tomorrow’s cost, not just the absolute numbers for EVs.

Fleet move: Pull your fuel card data for the last 12 months. It is the single most accurate source for mileage and fuel spend, and it takes 10 minutes to export from most fleet management platforms.

Section 2: TCO projection

This is the core financial model. The template projects Total Cost of Ownership over a 4-year horizon for both your current ICE fleet and the proposed EV replacement.

What the formulas calculate:

The TCO model covers seven cost categories: vehicle capital cost (net of grants), charging or fuelling cost, maintenance, insurance, taxation (BiK, employer NIC, VED including the Expensive Car Supplement), infrastructure CAPEX (amortised over the asset life), and residual value offset.

Default assumptions are pre-filled for UK 2025/26: electricity at 27.69p/kWh (Ofgem Q1 2026 cap), diesel at 145p/litre (RAC average), maintenance savings of 30% for EVs versus ICE, and the HMRC BiK trajectory from 3% to 9%.

The model runs three mileage scenarios (10,000, 20,000 and 30,000 miles per year) so the board can see how savings scale with usage. Higher-mileage fleets see faster payback because fuel savings dominate.

Fleet move: The single most impactful input is your electricity price. If you can negotiate a dedicated EV tariff with your energy supplier — or charge overnight on an Economy 7 rate — your TCO drops by 15-25% versus the Ofgem cap assumption.

🔗 For the full methodology behind these calculations, see our TCO Methodology page.

Section 3: Tax and incentive capture

This section is where most business cases leave money on the table. Our research shows that UK fleet managers routinely miss two or three incentives that could save £50,000+ across a 50-vehicle deployment.

What the template captures:

A checklist of every applicable UK incentive with current values pre-filled:

The Electric Car Grant at £3,750 (Band 1, highest sustainability score) and £1,500 (Band 2, vehicles under £37,000). The Plug-in Van Grant at £2,500 for small vans up to £5,000 for large vans. The Workplace Charging Scheme covering 75% of chargepoint costs up to £350 per socket (maximum 40 sockets per site). The Depot Charging Scheme covering 75% of chargepoint and civil costs up to £1 million per applicant. 100% First Year Allowance on both vehicles and charging infrastructure, saving corporation tax at 25% on the full purchase price. And the BiK advantage, where a zero-emission company car at 3% BiK saves the employer 15% NIC on the difference versus a 37% diesel.

The incentives most often missed:

The 100% FYA on charging infrastructure is claimed by fewer than half of eligible businesses. The Depot Charging Scheme is frequently confused with the Workplace Charging Scheme — they are separate pots of funding and you can claim both. And the Access SCR rule change (implemented April 2023) means demand customers no longer pay for DNO grid upgrades, eliminating a cost that many fleet operators still budget at £5,000-£100,000.

Fleet move: Run through this checklist with your finance team before submitting your business case. One missed incentive can be the difference between a positive and negative NPV.

🔗 For detailed eligibility criteria on every incentive, see our UK EV Fleet Grants & Incentives Guide.

Section 4: Charging infrastructure CAPEX

Infrastructure is the most variable cost in a fleet electrification project. The template provides realistic UK installation cost ranges so you can build a defensible budget.

Pre-filled cost ranges (2025/26 UK averages):

Grid connection: If your site requires a three-phase upgrade for 22kW chargers, budget £4,500-£6,000. For larger installations, check with your DNO early — the Access SCR rules (in effect since April 2023) mean demand customers no longer pay for network reinforcement, which could eliminate costs previously estimated at £5,000-£100,000+.

The template calculates the total infrastructure budget based on the number and type of chargers you specify, applies the relevant grants automatically, and amortises the net cost over 7 years (typical charger asset life).

Fleet move: Start your DNO engagement at least 12 months before you need chargers operational. Grid connection is the single biggest timeline risk in any fleet electrification project.

Section 5: Timeline and milestones

The template includes a Gantt-style milestone tracker for a phased deployment. The default timeline assumes a 50-vehicle fleet transitioning over 24-36 months.

Key milestones:

The critical path items are grid connection and charger procurement. Equipment lead times can exceed 12 months for DC rapid chargers. If your DNO application takes 16 weeks and your charger delivery takes 12 months, those two items alone set your minimum timeline at 18 months before the first vehicle can plug in.

Fleet move: Order your charging infrastructure before your vehicles. A car can wait in a car park; a charger cannot be installed overnight.

Section 6: Risk register

Every board will ask "what could go wrong?" The template provides a structured risk register with pre-populated risks rated by likelihood and impact.

Pre-populated risks include:

Residual value uncertainty. EV residual values have stabilised since the 2024 correction, but a 50-vehicle fleet carries meaningful exposure. Mitigation: use operating leases to transfer residual risk to the lessor, or factor in a 10% downside sensitivity in your TCO model.

BiK rate trajectory. Rates are confirmed through 2029/30 (3% rising to 9%), but post-2030 rates are unknown. Mitigation: model the confirmed trajectory only, and note that even at 9% the EV advantage over ICE (37%) remains substantial.

Grid capacity constraints. Not all sites can support 50 chargers without reinforcement. Mitigation: engage your DNO in month 1, and consider phased charger deployment aligned to vehicle deliveries.

Driver adoption resistance. Range anxiety and charging unfamiliarity remain barriers. Mitigation: start with a 5-10 vehicle pilot, collect driver feedback, and use success stories in internal communications.

Vehicle supply delays. ZEV Mandate supply constraints and production scheduling can delay delivery. Mitigation: order 6+ months ahead and maintain a buffer of ICE vehicles during transition.

Technology obsolescence. Battery chemistry and charging standards continue to evolve. Mitigation: lease rather than purchase to limit exposure, and specify CCS2/NACS-compatible chargers.

Each risk in the template has a likelihood score (1-5), impact score (1-5), a combined risk rating, and a mitigation column. The board can see at a glance which risks are material and how you plan to manage them.

🔗 For a deep dive on residual value risk and insurance implications, see our Fleet EV Residual Values & Leasing Risk Guide.

How to use the template

The template is designed to be completed in this order:

• [ ] Start with Section 1 (Fleet Baseline) — this takes 30 minutes if you have your fuel card data ready

• [ ] Fill Section 2 (TCO Projection) — adjust the blue-highlighted assumptions to match your fleet, then let the formulas calculate

• [ ] Run through Section 3 (Tax & Incentives) — tick every incentive you are eligible for and the template totals the savings

• [ ] Estimate Section 4 (Charging CAPEX) — use the pre-filled ranges or input quotes from your charger supplier

• [ ] Set Section 5 (Timeline) — adjust milestones to your organisation's procurement and approval cycles

• [ ] Review Section 6 (Risk Register) — add any site-specific risks and assign mitigation owners

  Total time: 2-4 hours for a first draft, versus 40+ hours from scratch.

Let us fill it in for you

If you would rather have the numbers verified with real market data, vehicle-specific pricing and site-specific charging analysis, that is exactly what the Fleet Audit Express delivers. We take your fleet data, run it through EVDC's model with live pricing from our 101-vehicle database, and deliver a CFO-ready report within 10 days.

🔗 Fleet Audit Express — from £990 for fleets up to 50 vehicles.

The template gets you 80% of the way. The audit gets you the remaining 20% that makes the difference at board level: verified vehicle recommendations, site-specific charging plans, and a financial model your CFO will trust.

🔗 For the full fleet savings picture including fuel, maintenance and route-to-zero planning, try the Fleet-Savings Calculator.

Sources

• Workplace Charging Scheme: gov.uk/workplace-charging-scheme

• Depot Charging Scheme: gov.uk/government/publications/depot-charging-scheme

• 100% First Year Allowance: gov.uk/capital-allowances

• Electric Car Grant: gov.uk/plug-in-car-van-grants

• BiK rates confirmed to 2029/30: gov.uk/government/publications/company-car-benefit-in-kind-rates

• Ofgem energy price cap Q1 2026: ofgem.gov.uk/check-if-energy-price-cap-affects-you

• Access SCR grid connection rules: ofgem.gov.uk/publications/access-scr