Learning Center
Plans & pricing Sign in
Sign Out

Roi Calculator Spreadsheet - PDF


Roi Calculator Spreadsheet document sample

More Info
  • pg 1
									Geothermal ROI Calculator Spreadsheet for Home Heating. Free Download of Excel File Based on DOE He

If you are seeking payback, geothermal heat pumps are a losing proposition.  As much as I am
fascinated by the possibility of geothermal (ground source) and air-source heat pumps to save
energy and reduce our dependence on foreign oil, I can’t recommend geothermal for anyone
other than an eco hobbyist – and one with a big checkbook (see end of article for a free
download of our Geothermal Payback ROI calculator spreadsheet).

The installation cost of a retrofit of conventional forced air heating and cooling with geothermal
heating is made up of three major elements: ground/water loop to source and sink heat,
compressor and air handler, and labor and markup.  The ground loop is most often a series of
wells holes drilled to accommodate a refrigerant line set which is buried in a special heat
conducting concrete.  The drilling of the wells and installation of the refrigerant lines is where
the big cost disadvantage of geothermal is found: this can account for as much as 50 percent of
the cost of the total installation depending on site conditions and the heating load for the home.

When you consider replacing (retrofitting) an existing heating and cooling system with
geothermal, you also have to factor in the remaining life of the system that is in place.  You, as
the homeowner, are accelerating an investment in your home that comes with opportunity cost. 
What else could you do with the money that you are sinking into your new, high-efficiency
heating and cooling system?

For new construction, the case is somewhat better, as the compressor and air handler are only
marginally more expensive than a traditional a/c setup with an oil- or gas-fired boiler to provide
heat.  But you still have that $15,000 to $30,000 marginal cost for the ground loop to make up
with energy savings, and it can take a very long time indeed.

 The HomeESP Geothermal ROI Calculator Spreadsheet is intended to compare the cost of
geothermal to conventional heating systems.  It offers two ROI scenarios, for oil and gas
heating, together the most common forms of central heat.  You can modify the spreadsheet as
needed to conform to your specific situation.  We based the HomeESP Geothermal ROI
Calculator Spreadsheet on the US Department of Energy’s “Heating Fuel Comparison
Calculator” also known as heatcalc_Vsn-C_1-08.xls which has embedded within it many
informative links about energy efficiency, energy price sources and much more. 

If you're still interested in geothermal heating and cooling, and want a free estimate from a
qualified, pre-screened pro, please visit our contractor locator green home improvement
 section                                       .

We hope this helps you to make an informed decision about geothermal heating, and also
welcome any feedback from readers and HomeESP Members.


To top