Selling and Buying a Car in Louisville

For the last week I’ve been doing a lot of Car Analyses.  Some of it was trying to figure out how to judge one car over another;  another was visiting my history of cars, and determining satisfaction, and pinpointing my motives.  This is what I’ve figured out;  I’ll start with the most useful first:

My Experiences with Places to Sell or Buy a Car in Louisville

CarMax Will usually buy at the bottom end of KBB trade in value, unless <= 50k, then gives a decent price Will sell at above KBB Value.  *

* = better quality cars than we’ve bought anywhere else.

Cottage Car Sales Cottage Car Sales Better buy value than CarMax Sells at below KBB Value usually (but small inventory and some quirks)
Sam Swope Honda World image Best value for the Honda that we sold them Haven’t bought one from them myself. 

Disclaimer:  commentary above is based on 1 statistical sample in some cases and may not be significant.

In the end, we got $2000 more for our 2008 Honda Accord Coupe from Sam Swope Honda World than we would have at either Cottage or CarMax.  Terry Smith there was very professional, courteous, and prompt; no pressure of any kind; I would definitely do business with him again.

Evaluating the Worth of a Car To Me

When I was in the throes of trying to make a decision between a X and a Y, I needed some way to evaluate the cars.  Here are the tools that I found:

UsedAutoGraph.com
image
Mileage vs Sales Price
Active Listings vs Active Auctions
Overall value decline
How long does the car last
Popularity
http://www.edmunds.com/honda/civic/2010/reliability.html
image
Its somewhat buried in the Edmunds website, and really i should give a link to identifix, however, look at that URL.  I could very quickly look up any make/model/year and find years to avoid.
http://autos.jdpower.com/research/Honda/Civic/2010/ratings.htm
image
Another awesome URL, gave a quick overview of the quality of the car. 
Car Max Inventory Pictures of cars.
Mileage.
Feature availability.

I also used a formula like this:

  • Consider a 2010 Honda Civic EX for $16k with 42k Miles on it.
  • According to UsedAutoGraph, it holds its value well (should not die) till 100k, probably even viable to 200k.   Knowing myself, I’ll find a reason to upgrade, so lets say 150k miles instead.   Approx end sale price then is $5K.
  • So I would get 108k miles for approx $11k, yielding around 10 cents a mile from the purchase price.
  • at MPG of 25/36, I would get about 30mpg out of it, at $3.50/gallon yields  3.50/30 = 11 cents per mile gas price.
  • So the car would be about 21 cents per mile, for me.

I did this same analysis for the cars we had owned till now.  I always thought that the Honda Pilot that we bought was a complete gas hog.. averaging 15 mpg..  however, the sale price vs the buy price made it BETTER than the Ford Focus that we also had.  I would not have thought that.   (Then again, the Focus had an encounter with a Deer which dropped its resale considerably)

Picking through CarMax Inventories

We pretty much knew we were going to buy the next car through CarMax, or at least use a CarMax car as the baseline to compare against.  My general approach was:

  • Use them for test drives to figure out which car we want (year differences, trim level differences, lie down in the trunk of the car, etc)
  • Assume that we will NOT be buying the car from the local (Louisville) CarMax
    • This freed me from the necessity to make the decision NOW.
  • Search their inventory for the right mileage, color, options nationwide.  We could also look at the CarFax history (for free) and see where the car used to live (avoiding Florida due to Salt damage).
  • Spend $99-$299 and arrange a transfer of the vehicle to Louisville.
    • At this point, the car is locked in as mine.   But it might take a day to three weeks to execute.
    • This gives me time to reflect and really decide if this is the car for me.
    • Good thing, because that Ford Escape that I ordered.. ended up having second thoughts and choosing not to buy it.
    • To CarMax’s benefit – I cancelled the order fast enough, they had not loaded it on the truck, so they gave my money back (they didn’t have to).  (Well, i was transferring a different car, so they moved it to the second transfer).
  • The car hasn’t arrived yet; I’m in that reflecting place.   So I can’t say what happens next; but it will probably involve test driving, and then buying this car.

Filtering CarMax Inventories

They have a LOT of cars, with a LOT of options.  Here’s how I tackled that, in an Excel Spreadsheet:

Initial search:  No filter, just the make/model/year range, sorted by price, and or mileage.  Pull the first 10 into the spreadsheet.  Get a baseline, the corners of the grid. This is the least / most amount of money I would spend on that car type.   Chart it.   Bubble chart using a function to show age by bubble size.

Successive Searches:  I narrow it down by features, getting more and more selective.  I pull each of those into the spreadsheet, but as a different series.   I layer the series so that the more specific ones drown out the less specific ones.

Result:

image

Using this approach, I could easily see that if I wanted X set of options, the lowest miles for the price was at Y, but if I added Z option to it, then that drove the price up by Y2.      Ie, how much car am I willing to spend on.  Note that I inverted circle sizes, so that newer cars were bigger circles. 

imageNote that while filtering in CarMax, I really like how they show numbers next to features.  This helps me figure out what are “standard” options and/or are packaged with each other.  In this screenshot example,  (106) is standard across everything, while the Satellite Radio Ready is a much more selective.    I got pretty good at it, being able to choose 3-4 options that narrowed down the car to exactly what I was looking for.

Summary

Its been a crazy week.   Its been a fun research process.   In the end, I have a car on order that I cannot wait to get my hands on.   I even made a picture of it my desktop background. 

I hope some of these tools are useful to you in your future.     Enjoy! 

Tagged with: , , ,
Posted in Vehicles

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories
Tags
.net 3d 3d-printing 4k abc15 algorithms ames android anonymous types asp.net audio editing aws backup basecamp beatunes biorhythm bittorrent blender blog boston marathon bpm c# caffeine campfire candycrush car carmax charity chiropractor cities-skylines clog clone codelouisville codepalousa coding coffee collaboration color run ComputerElbow ComputerVision configuration consulting cooking crash course crashplan crestwood cycling dabda dan dapper DataSet ddl diabetes dictation dotnetcore dotnetmud downtown e-cycling elite excel exercise expiration facebook feature-branching firefall flipflops Flow FL Studio focus food forecastle fortresscraft franklinplanner gadgets game-design games git github google docs google maps gopro gps grandpa greenshot hack half marathon headless health heart rate hiren ignew integration testing interop inventory ios ipad itunes javascript jobs karma kdf keyboards keys kittens lamont laptop lavalamp lego life lifehack linq linqtotwitter linux los angeles louisville mandelbulber massage therapy mastery-teaching maths merge metformin Minecraft miniature modeling monitor mud muhammad ali institute music mvc mycartracks netfabb nexus10 node nostalgia nutrition nwipe oldham county grand slam opal openjscad openscad owin pacedj paper mockup pepakura performance photoscan politics pomodoro postgresql powershell premiere prius process product-management project-management qa resharper review rmi roman road 5k RSI rubiks running samsung 700t sandals schedule scooter scribblelive selenium service shapeways sleep slic3r sneakersync snot software software-engineering solidoodle soylent spacegame speaking sql sqlite SSDT SSIS standing state-machine stayfocusd stonehearth sunset tablet teaching team teamcity teamtreehouse terraform testing tfs time timelapse torque touch tracks trs80 Tuple tutor twitter ubuntu unit testing utilities video video editing visual studio vscode vsvim warp stabilizer windows 8 windows home server wordpress wpf xml
Archives
%d bloggers like this: