Go Back   EcoModder Forum > EcoModding > General Efficiency Discussion
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 11-06-2009, 02:49 PM   #1 (permalink)
EcoModding Lurker
 
Join Date: Jul 2009
Location: London UK
Posts: 88

VW GOLF - '96 Volkwagen Golf MK3 GL
TEAM VW AUDI Group
90 day: 50.21 mpg (US)

Commute scoot - '95 Suzuki AE50 Style
Last 3: 70.4 mpg (US)

The German - '99 Mercedes W202 C200 Classic
90 day: 27.65 mpg (US)
Thanks: 0
Thanked 9 Times in 7 Posts
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...

Attached Files
File Type: xls mod costs calc UK.xls (16.0 KB, 93 views)
File Type: xls mod costs calc US.xls (16.0 KB, 115 views)
__________________






Will you recoup money spent on mods in fuel saved? see my spreadsheets here
  Reply With Quote
The Following 2 Users Say Thank You to sallen For This Useful Post:
mcrews (11-14-2009), pgfpro (11-06-2009)
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 11-06-2009, 03:18 PM   #2 (permalink)
In Lean Burn Mode
 
pgfpro's Avatar
 
Join Date: Apr 2009
Location: Pacific NW
Posts: 1,528

MisFit Talon - '91 Eagle Talon TSi
Team Turbocharged!
90 day: 39.03 mpg (US)

Warlock - '71 Chevy Camaro

Fe Eclipse - '97 Mitsubishi Eclipse GS
Thanks: 1,243
Thanked 581 Times in 373 Posts
Thanks

It looks like my mods will take 5 years to pay off. But of course I'm not done spending money
__________________
Pressure Gradient Force
The Positive Side of the Number Line

  Reply With Quote
Old 11-13-2009, 10:19 PM   #3 (permalink)
EcoModding Apprentice
 
tim3058's Avatar
 
Join Date: Sep 2009
Location: Northeast
Posts: 147

Silver Bullet - '86 Chevy Camaro Z28
90 day: 19.74 mpg (US)

New Blue - '96 Chevrolet Camaro Z28
90 day: 20.46 mpg (US)

Diesel - '96 Chevrolet Tahoe LS
Last 3: 13.56 mpg (US)

Tahoe #2 - '95 Chevrolet Tahoe LS
90 day: 13.05 mpg (US)

SuperDuty - '08 Ford F-350 dually Lariat
90 day: 9.34 mpg (US)

Fundai - '09 Hyundai Elantra
90 day: 26.45 mpg (US)

HRV - '17 Honda HRV LX
90 day: 31.39 mpg (US)
Thanks: 7
Thanked 18 Times in 12 Posts
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
__________________


  Reply With Quote
Old 11-21-2009, 05:52 PM   #4 (permalink)
Left Lane Ecodriver
 
RobertSmalls's Avatar
 
Join Date: Aug 2008
Location: Buffalo, NY, USA
Posts: 2,257

Prius C - '12 Toyota Prius C
Thanks: 79
Thanked 286 Times in 199 Posts
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.
  Reply With Quote
Old 02-20-2010, 11:12 AM   #5 (permalink)
EcoModding Lurker
 
Join Date: Jul 2009
Location: London UK
Posts: 88

VW GOLF - '96 Volkwagen Golf MK3 GL
TEAM VW AUDI Group
90 day: 50.21 mpg (US)

Commute scoot - '95 Suzuki AE50 Style
Last 3: 70.4 mpg (US)

The German - '99 Mercedes W202 C200 Classic
90 day: 27.65 mpg (US)
Thanks: 0
Thanked 9 Times in 7 Posts
US Spreadsheet amended

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

Attached Files
File Type: xls mod costs calc US.xls (15.5 KB, 49 views)
__________________






Will you recoup money spent on mods in fuel saved? see my spreadsheets here
  Reply With Quote
Reply  Post New Thread


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Discussion on tire efficiency Ernie Rogers General Efficiency Discussion 69 12-27-2014 01:17 PM
NASA sponsored competition rewards efficiency mods in private aircraft MetroMPG General Efficiency Discussion 0 08-13-2008 10:35 AM
Getting more efficiency out of a ZX2. Small list of mods and driving tips for it. koihoshi EcoModding Central 9 07-20-2008 04:26 AM
Juggling Cost of Mods with Payback Period 2003protege Aerodynamics 10 06-15-2008 05:32 PM



Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com