EV Fleet · Excel template
Free EV vs ICE Cost Comparison Worksheet
A side-by-side total-cost worksheet for an electric versus a comparable combustion vehicle — purchase, energy, maintenance, and incentives — built on your own charging and duty-cycle data.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- Purchase price and any EV-specific incentive or rebate, entered separately so the pre- and post-incentive comparison are both visible
- An energy-cost section using your own observed cost-per-mile from the EV Charging Log, not a national average
- A maintenance-cost comparison reflecting the items an EV genuinely skips — oil changes, exhaust, most brake wear via regenerative braking
- A residual-value assumption field, flagged as the most uncertain line in the whole comparison
- A total-cost-per-mile output for both vehicles over a stated holding period
How to use it
- 1
Enter purchase price for both vehicles first, and any EV incentive as its own line — the comparison changes meaningfully depending on whether you view it pre- or post-incentive.
- 2
Pull energy cost per mile from your own EV Charging Log rather than a published average; your depot electricity rate and charging mix (Level 2 versus DC fast) usually differs from any generic figure.
- 3
List maintenance line by line for the combustion vehicle and mark which ones the EV genuinely avoids — this is usually the category people underestimate on both sides.
- 4
Set a residual-value assumption for each vehicle over your holding period, and treat it explicitly as the most uncertain input rather than presenting it as fact.
- 5
Compute total cost per mile for both vehicles over the same period and mileage, and re-run the worksheet as real data replaces early assumptions.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
EV vs ICE Cost Comparison Worksheet
Fuel prices, electricity rates, incentives, and residual values change and vary by location. This worksheet is a framework for your own numbers, not a published comparison — rebuild it with current figures for your fleet before relying on the output.
| Cost Category | EV | Comparable ICE | Basis / Source |
|---|---|---|---|
| Purchase price (pre-incentive) | $58,000 | $46,000 | Vendor quote |
| EV incentive | -$7,500 | — | Current federal/state program |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
Show both, because they answer different questions — pre-incentive is the honest capital outlay, post-incentive is the actual cash impact for a purchase made now. Presenting only one hides a real part of the decision, especially since incentive programs can change or expire, which makes the pre-incentive figure the more stable long-term comparison.
From your own EV Charging Log rather than a published national average, because your actual cost per mile depends on your depot electricity rate, the mix of overnight Level 2 versus more expensive public DC-fast charging, and your route profile. A generic figure can be meaningfully off from what your fleet actually pays in either direction.
Because used-EV resale values have moved more than used-ICE values in recent years, driven by battery-health uncertainty, incentive changes, and rapid model-year improvements affecting older vehicles more than a comparable combustion vehicle. Treat the residual assumption as a sensitivity input you re-check periodically, not a fixed number you set once and forget.
No — this worksheet is a cost comparison only. Route length against range, charging time against duty cycle, and cold-weather range loss are operational-fit questions that belong with the EV Range Observation Log, not this cost sheet. A vehicle can win on total cost per mile and still be the wrong fit for a specific route.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.