View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] uberyes@gmail.com is offline
external usenet poster
 
Posts: 4
Default Way beyond me: Calculate ROI of home energy improvements... while also taking into account increases in energy prices

Hi,

I want to make an ROI energy improvements calculator.

I've got this far:

-----------------------

Improvement Cost Saving per year
Cavity wall 750 150
Roof insulation 500 175

Total 1250 325

ROI: 3.8 years

-----------------------

So far, so embarrassinly simple.

However, I'd like to add a bit more...

-----------------------
Probable yearly energy price increase: 12%
Actual savings:
Actual ROI:
-----------------------

Any thoughts?



Many thanks,

Uberyes