Npv Investment Calculator Excel Template - Free Download
4.7,
4060
votes
Please vote for this template if it helps you.
Gas vs. CNG GAS TRUCK CNG TRUCK
Discount Rate : 1.00% 1.00%
Tire/brake cost every 3 yrs 2,000$ 2,000.00$
Annual rise in fuel cost 10.00% 10.00%
Years owned before resale : 7 7
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)$
NET PRESENT VALUE (NPV)
Vehicle Cost+Fuel+Maint : 36,430$ 35,279$
CNG truck savings: 1,151$
This demonstrates a viable investment scenario for a CNG pickup truck
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).
NET PRESENT VALUE CALCULATOR
source: garfieldcleanenergy.org
