Efficiency Mods Cost / Benefit Spreadsheet
 

Hi there,

For every prospective mod I make I wonder if it makes sense financially as well as environmentally. So... I came up with a way to see how long your hard earned cash invested in an ecomod takes to be recouped in fuel saved.

I've made up a couple of spreadsheets that are unlocked (open source / creative commons type affair) that you are all free to mess with they are UK/US calculators based on cost of efficiency mod. The sheet tells you how many years it will take to recoup the cost in fuel saved.

As long as you don't change any of the yellow cells all should be good...

If i've made any mistakes let me know.... Incase you were wondering the "default" setting is a calculation for adding an intercooler to my TD Golf.

Enjoy...

Thanks:thumbup:

It looks like my mods will take 5 years to pay off. But of course I'm not done spending money;)

Thanks a lot for the spreadsheets Sallen, very handy. I've already spent more on the Civic than I ever dreamed to, but by your spreadsheet it will still recoup in 1 year... thanks again

Cost/benefit analyses are a favorite of mine. But as the saying goes, garbage in -> garbage out. In other words, you should only use your analysis as a basis for judgement if you captured all the variables that should go in to your decisionmaking.

Ecomodding saves gas money, reduces wear on the car, and it entertains me. It also reduces fossil fuel consumption and CO2 emissions. An ecomodded car can be a conversation-starter, with social and environmental benefits. All of these things add value, and if you look only at the gas you save, you're missing a big part of the benefit.

You can capture the fuel and its CO2 / sustainability impact in this spreadsheet by using a higher fuel price than you pay. I like to add $3/us gal to the price of fuel in spreadsheets like these, but YMMV.

You use a payback period method here. That's okay, but remember that money you put into investments, savings, stocks, and bonds also has a payback period. If the payback period is longer than about 8 years, the mod does not pay. Also, if the payback period is longer than the service life of the mod or car, the mod does not pay.

When Ecomodding is a hobby or a sport, it's fine to make mods that don't quite pay for themselves, as long as you enjoy installing them and driving around with them.

US Spreadsheet amended
 

Hi guys, thre was a typo in the US sheet so here it is again... functionality is the same though.