NPV Investment Calculator Excel Template
NPV Investment Calculator Excel Template
NPV Investment Calculator Excel Template
Y Cashflow Y Cashflow
Vehicle Cost 0 $ 20,000 0 $ 30,000
Fuel cost in first year 1 $ 3,000 1 $ 2,000
Fuel+increase 2 $ 3,300 2 $ 2,200
Fuel+increase+Tires Brakes 3 $ 5,630 3 $ 4,420
Fuel+increase 4 $ 3,993 4 $ 2,662
Fuel+increase 5 $ 4,392 5 $ 2,928
Fuel+increase+Tires Brakes 6 $ 6,832 6 $ 5,221
Income from vehicle sale 7 $ (10,000) 7 $ (14,000)
Note: Higher NPV means that the vehicle costs more to own over time.
You may edit cells in green to customize this analysis for your fleet
Note: This example assumes a truck that gets 10 MPG traveling 10,000 miles/yr
This example also assumes $3/gal for gasoline ($3000/year in the first year)
and $2/gal for CNG ($2000/year in the first year).