Cost calculator tool ng fleets

NATURAL GAS TRUCK COST CALCULATOR

v3 (June 22, 2012)

INPUTS

OUTPUTS

FLEET CHARACTERISTICS

SIMPLE PAYBACK

Number of Diesel Trucks to be Replaced with CNG Planned Lifetime of Trucks (years) Average Daily Mileage per Truck (miles per day) Average Annual Usage per Truck (days used per year) Average Fuel Economy of Diesel Truck (miles per diesel gallon) Average Fuel Economy of Natural Gas Truck (miles per diesel gallon equivalent)

100 (1) 10 90 300 5,00 4,50 (2)

VEHICLE AND FUEL COST Initial Capital Cost of Conventional Truck Initial Capital Cost of Natural Gas Truck Fuel Cost for Diesel ($/gallon) Source for Natural Gas Cost Use CNG COST User Entered Natural Gas Cost ($/diesel gallon equivalent) Natural Gas Cost for Calculations ($/diesel gallon equivalent)

Simple Payback of Natural Gas Incremental Costs Without Incentives (years) Simple Payback of Natural Gas Incremental Cost With Incentives (years)

4,8 3,9

LIFE CYCLE COST $75.000 $125.000 $4,00 (3)

tab price for onsite fueling

$29.100.000

Total Life Cycle Cost of Natural Gas Trucks (No Incentives) Life Cycle Cost Differential (No Incentives)

$23.787.632 -$5.312.368 (8)

Total Life Cycle Cost of Natural Gas Trucks (With Incentives) Life Cycle Cost Differential (With Incentives)

$22.787.632 -$6.312.368 (8)

$2,00 (3) $1,88 (4) (5)

INCENTIVES FOR CNG VEHICLES Federal Purchase Incentive (per vehicle) New York State Purchase Incentive (per vehicle) Other Purchase Incentives (per vehicle)

Total Life Cycle Cost of Diesel Trucks

$0 $0 $10.000 NOTES

FUELING STATION OPTIONS (FOR ONSITE, OWNED STATIONS)

Station costs part of CNG price (6) No 1 (7) $1.520.000 (7) 1 $750.000

Include purchase of stations in payback calculations?

Stations needed to serve this fleet of natural gas trucks based on fueling needs Total estimated cost per station based on natural gas truck fueling needs User-entered number of stations User-entered station cost (per station) Which station costs should be used in calculation?

Use the costs estimated Number of stations to be constructed Average cost per station

by the tool

0 $0

INCENTIVES FOR CNG STATIONS Federal Incentive (per station) New York State Incentive (per station) Other Incentives (per station)

(1) Green cells are user-editable input fields.

(2) If CNG fuel economy is not known, assume 10-25% lower fuel economy than diesel truck (3) Price estimates can be obtained from www.afdc.energy.gov/afdc/price_report.html (4) See tab CNG COSTS for source of CNG pricing.

(5) To convert $/gasoline gallon equivalent to $/diesel gallon equivalent, multiply GGE price by 1.11 (6) If the calculation uses the CNG price built up from components on the CNG COST tab, the calculator will automatically zero out the station costs in these cells, since the CNG COST price already includes station cost amortization.

(7) Estimate based on "Business Case for Compressed Natural Gas in Municipal Fleets", NREL 2010 (8) For life cycle cost differentials, cost savings for the project are highlighted in green, while instances of cost increases for CNG are highlighted in red

$0 $0 $50.000

NATURAL GAS TRUCK COST CALCULATOR

v3 (June 22, 2012)

NATURAL GAS PRICE CALCULATOR FOR ONSITE CNG STATION The information below illustrates the buildup of CNG pump prices from various components - this information is of use to fleets building their own infrastructure.

Fleets purchasing fuel from an external public or private station can enter the price that station offers as an alternative to this calculation.

CHOICE OF MANUAL ENTRY OF CNG PRICE Use Calculated Fuel Price? (Yes/No) Enter fuel price from retail or private station (in $/diesel gallon equivalent) Fuel price to use for calculations COMPONENTS OF CNG COST (1) Gas Commodity Price of wellhead gas ($/million BTU) (2) Price of wellhead gas ($/GGE) Transportation to meter ($/GGE) (2) Electric Compression Costs Fleet cost for electricity ($ per kWh) Cost to compress natural gas ($/GGE) Maintenance and Repair of Station Maintenance and repair costs ($/GGE) Amortization of Station Equipment Cost to amortize station equipment ($/GGE) Federal and State Taxes (if applicable) Federal Tax ($/gge) State Tax ($/gge) Total Fuel Cost Gas Commodity Compression Maintenance Equipment Amortization Taxes Total ($/GGE) Total ($/DGE)

2 $2,00 From input page

http://www.afdc.energy.gov/afdc/price_report.html

$1,88

$2,39 (Henry Hub price, available daily at http://www.eia.gov/dnav/ng/ng_pri_fut_s1_d.htm) $0,30 $0,20 (ranges from $.20 to $.40 per GGE) $0,10 (ranges from $.04 to $.30 per kWh) $0,10 assumes 1 kWh electricity to compress 1 GGE $0,50 (ranges from $.30 to $.75 per GGE) $0,60 (calculated by total cost of station divided by throughput over lifetime of station, range of $.35-$.65) $0,18 $0,00 (CNG exempt from NY state excise tax until September 1, 2012, after which it would be $.44) $0,50 $0,10 $0,50 $0,60 $0,18 $1,88 $2,09 (assumes conversion of 124,800 BTU per GGE and 138,700 BTU per DGE)

NOTES (1) Natural gas price buildup logic and ranges are from NGVAmerica, "The Compelling Case for NGVs in Public and Private Fleets", 2012 (2) Price of wellhead gas and transportation to meter may be in $ per therm: to convert to $/million BTU, multiply $/therm by 10

NATURAL GAS TRUCK COST CALCULATOR User-entered CNG price from a public station or fuel agreement

ASSUMPTIONS AND ADDITIONAL NOTES

1/ Cost calculations in the calculator do not account for the time value of money - it is recommended that the user consu a financial advisor or his/her company's accounting/finance department before committing to a natural gas program to conduct more complex financial modeling. The intent of the calculator is to provide an initial decision making tool.

2/ For cases where a fleet will build its own refueling station, this calculator assumes the station asset will need to be com amortized over the lifetime of the fleet vehicles using it.

3/ For cases where a fleet will build its own refueling station, operations and maintenance costs for the station are assum accounted for in the price of the natural gas as delivered to the vehicle.

4/ Vehicle maintenance costs for diesel and natural gas vehicles are assumed to be equivalent on a per-mile basis: some indicate that natural gas vehicles may have a maintenance cost benefit that would improve the financial performance of the project.

5/ Vehicle resale is not accounted for in this analysis.

6/ Life cycle costs included in this analysis include vehicle capital costs, refueling station capital costs (where applicable vehicle operational costs (fuel costs).

v3 (June 22, 2012)

is recommended that the user consult committing to a natural gas program ovide an initial decision making tool. es the station asset will need to be completely

enance costs for the station are assumed to be

equivalent on a per-mile basis: some studies d improve the financial performance

ation capital costs (where applicable), and

Drop-down Box Input CNG Price Choice User-entered CNG price from a public station or fuel agreement Use CNG COST tab price for onsite fueling Station Costs Included?

Yes No Which station costs included?

Use the station costs I entered Use the costs estimated by the tool

Result 2

2

2