| 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% |
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.
| Year | Diesel cost | Electric cost | Saving | Cumulative |
|---|
| 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 |
|---|
| Option | Invested | Growth % | Gross value | Withdrawn | Remainder | Net result | Depleted |
|---|
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Investment | Yield/yr | Risk | End year 7 |
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.
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.
The annual cashflow uses a realistic growing OPEX-saving curve (savings increase over time as diesel maintenance escalates), not a flat line. Subsidies land in years 2-4; residual value lands in the final year.
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.
Pick a starting point, then fine-tune any slider above. Export your exact settings as a file, or load one back.