VAT, refund and sourcenet: €1.31/L
sources
Inflation & cost of capital — diesel +4.0% · elec +2.0% · OPEX +2.0% · WACC 8.0%
Vehicle & energy assumptions — diesel 30 L/100km · electric 1.10 kWh/km at wheel · diesel truck €120k
Mileage by zone & toll settings — home zone
How to read
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Diesel € | Electric € | Δ € | Δ % | ||
| 1 | CAPEX | 9.60 | 19.03 | +9.43 | +98% |
| 1a | └ Trucks | 9.60 | 15.84 | +6.24 | +65% |
| 1b | └ Charging infra (turnkey, all-in) | — | 4.56 | +4.56 | — |
| 2 | OPEX (total) | 53.73 | 25.00 | −28.73 | −53% |
| 2a | └ Energy | 21.99 | 13.55 | −8.44 | −38% |
| └ of which charging losses | — | 0.98 | +0.98 | 8% | |
| 2b | └ Tolls | 16.02 | 2.13 | −13.89 | −87% |
| 2c | └ Maintenance | 12.08 | 6.24 | −5.84 | −48% |
| 2d | └ Other (insurance, AdBlue) | 3.64 | 3.08 | −0.56 | −15% |
| 3 | TCO | 63.33 | 44.03 | −19.30 | −30% |
| 3a | └ TCO / year | 9.05 | 6.29 | −2.76 | −30% |
| 4 | ROI total CAPEX | — | 19.3019.03 | — | 101% |
| 5 | ROI delta CAPEX | — | — | 19.309.43 | 205% |
From total cost of ownership to investment case
The TCO advantage above is not just a saving — expressed as a yearly cashflow it becomes an investment with an MIRR (modified internal rate of return) and an NPV you can hold next to any other use of the capital. The same euros, in the language a bank or CFO uses.
How to read
| Year | Diesel cost | Electric cost | Saving | Cumulative |
|---|
How to read
| Year | Yearly savingnet Δ cashflow | Today's-value factordiscount factor | In today's moneydiscounted | Value built upcumulative NPV | Return / yr so farrunning MIRR | Savings grown vs money in= total multiple; the left column annualises it |
|---|
How the final multiple is built — savings grown to year 7 (→ the €21.40M numerator)
How to read
How to read
| Option | Invested | Growth % | Gross value | Withdrawn | Remainder | Net result | Depleted |
|---|
How to read
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Investment | Yield/yr | Risk | End year 7 |
Every number, every formula, every substitution — explained.
Below is the complete derivation behind the tables above. Every value substitutes the parameters you selected and recalculates live. Each step also says, in words, which numbers are being added to or subtracted from which.
Input parameters & fixed assumptions
tap to view & edit
Boxed values are editable here — the whole case recalculates live. Plain values are derived: they follow the parameter panel, the zone split or the charging system, and change there.
Maintenance is not scaled linearly — it uses real cumulative figures per period (diesel €95k/€151k/€240k for 5/7/10 yr; electric per the selected scenario). Diesel maintenance rises steeply in later years, so a 10-year truck costs far more than 2× a 5-year truck. Sources: ICCT (EU tractor-trailers), ATRI/Fleetio (escalation with age), TNO (BEV ~30-50% lower). Ld, Lwheel and P0 mirror the sliders in the parameter panel; Md, Fd and Fe are editable here directly.
Diesel vs Electric fleet TCO
TCO savings & ROI
Per truck
Cashflow year by year
How the cashflow table is filled in. Year 0 is the extra money the electric fleet costs to buy. After that, every year counts on its own: that year's saving, a truck subsidy in year 1 and a charger subsidy in years 2 to 4 if you set them, and the resale value in the last year.
Investment benchmark (compound interest)
Each passive alternative is compounded annually on the same capital over the contract length. The fleet line is ranked by its MIRR — the compound annual rate implied by the yearly cashflows — so the comparison with a compounded index (MSCI World, S&P 500) is a fair like-for-like.
Mathematical caveats & honest limitations
- Now investment-grade: cashflows are built year-by-year in nominal euros with inflation, then assessed with MIRR and NPV — so the fleet MIRR is directly comparable to a compounded index return (MSCI World ~7.5%/yr nominal).
- MIRR is a fair compound rate: the fleet's annual return comes from the modified internal rate of return — it compounds the yearly savings at your cost of capital rather than at the project's own (high) rate, so it can be placed next to a compounded index return (e.g. MSCI World ~7.5%/yr) on a genuine like-for-like basis.
- Inflation assumptions are yours to set: diesel typically rises faster than electricity (the EU carbon price on road fuels starts in 2028). Defaults: diesel +3%/yr, electricity +2%/yr, general OPEX +2%/yr. Maintenance also escalates with vehicle age (geometric profile) on top of inflation.
- Index returns are nominal, gross: MSCI World/S&P 500 figures are long-run historical nominal averages before tax and fees; past performance is not a guarantee. The fleet MIRR is also nominal and pre-tax, so the comparison is like-for-like, but neither is risk-free.
- Belgian operator only: diesel refund, home tolls and subsidies are Belgian. Foreign kilometres are charged at each zone's own rate, thirteen zones in all.
- Maintenance per literature: diesel €95k/€151k/€240k (5/7/10 yr); electric set as a fraction of diesel via the scenario selector — best case 30%, TNO (NL) 50%, central 55%, ICCT (EU) 70%, conservative 80%. Battery replacement is not modeled.
- Not financial advice: a real bank case would also model financing structure, tax (investeringsaftrek), battery degradation, and residual-value risk explicitly.
Save, share or switch the whole scenario
Pick a starting point, then fine-tune any slider above. Export your exact settings as a file, or load one back.