Hybrid Car – More Fun with Less Gas

Speadsheet To Evaluate Car Choice?

register ::  Login Password  :: Lost Password?
please rate
this thread
Posted by (PeteCresswell) on August 24, 2008, 12:06 pm
 
Given that I have car "A", which is driven so-and-so many miles
per year and gets X mpg with gas at $Y per gallon and I'm
thinking about getting rid of car "A" - for $Z to buy car "B"
which gets so-and-so many MPG and costs such-and-so....  

I'd think there must be hundreds of spreadsheets out there - or
even web pages - that would show the break-even point for such a
changeover.

Anybody know of none?
--
PeteCresswell

Posted by Pete C. on August 25, 2008, 9:11 am
 

"(PeteCresswell)" wrote:

There is at least one trade in payback calculator thing on the
Edmunds.com site. It indicates if I were to trade my 11 mpg truck for an
Escape hybrid I'd start saving money in 54 years, since I don't drive a
whole lot.

Posted by Balanced View on August 25, 2008, 10:02 am
 Pete C. wrote:

Why do you guys use a worst case scenario all the time? Who says you
have to buy a brand new Escape?
Trade sideways to a similar vehicle to yours that gets better mileage,
that's what I did, traded a 23 mpg four
door sedan for a five year newer 37 mpg four door sedan.

Our daily drive now averages about140 miles a week, and with the newer
car I'm now burning 3.8 gallons of
gas as opposed to 6.08 gallons. At four bucks a gallon that would be a
saving of  $9.12 a week or 474.24 a
year. I'm driving about half the national average, an average driver
would save almost $1000.00 a year.

Posted by (PeteCresswell) on August 25, 2008, 4:06 pm
 Per Balanced View:

Good point.

Having said that...

I ran the Edmunds thingie against a proposed 2007 Honda Odyssey -
selling my '98 Suburban 4wd, which I've been figuring on nursing
along until at least 250k (it's got almost 170 on it now).

Edmunds' break even period was 204 months at 1,000 miles per
month with gasoline at $4.25/gallon

Applying my limited arithmetic skills, it seems like the payback
period competes closely with - or even exceeds the life of the
replacement vehicle....

Assuming a 2007 Oddssey would have at least 50k on it at trade
time, that would be a quarter million miles on the odo before it
broke even.

OTOH, running it against a 2007 Honda Element, the BE falls to
150,000 miles... but still that seems tb pushing it....

With a new Element, BEP is about 180,000 miles.


"Limited arithmetic skills" bc I suspect I'm missing a few things
here  - like some sort of allowance for the ultimate life in
miles of the Suburban.

Any accountants out there?
--
PeteCresswell

Posted by Vaughn Simon on August 25, 2008, 5:14 pm
 

   Here is where your judgment skills come in, not just arithmetic.  Keeping the
Suburban for 200+ months is probably not a practical option.  At some point,
increasing maintenance cost, decreasing parts availability, and decreasing
reliability need to be considered.  Unfortunately, only one of those three items
can be fit into a spreadsheet.

  At the end of the day it is still a judgement call, not just a math excercise.


--
Vaughn


Nothing personal, but if you are posting through Google Groups I may not receive
your message.  Google refuses to control the flood of spam messages originating
in their system, so on any given day I may or may not have Google blocked.  Try
a real NNTP server & news reader program and you will never go back.  All you
need is access to an NNTP server (AKA "news server") and a news reader program.
You probably already have a news reader program in your computer (Hint: Outlook
Express).   Assuming that your Usenet needs are modest, use
http://news.aioe.org/  for free and/or http://www.teranews.com/  for a one-time
$3.95 setup fee.

Will poofread for food.







This Thread
Bookmark this thread:
 
 
 
 
 
 
  •  
  • Subject
  • Author
  • Date