How I compared/normalized used 370Z when I shopped, hope this is helpful to you

coffeebob

Just wanted to share this ...

After getting the mileage/asking price/options from cars.com, autotrader.com, craigslist, I
put them down in a spreadsheet. But
it is hard to see which one is a better deal without some index.
So I just assumed I would keep the car until 160k miles (my last car had 173k, and
the previous car had 195k), and used the cost per mile as an index

Below is the spreadsheet I used. Last column is this index.
e.g. the 2011 silver one with no options at all had 0.219, no brainer, not going to pick it.
e.g. the 2012 white one with 9123 miles has the lowest index, but I would not pay $25099 for it
because a loaded 2011 with only 6000 more miles is a better value.

I hope this will be helpful to you.

year miles price
2012 370z 9123 25099 M white nav 0.166
2010 370z 8293 25998 A red sprt 0.171
2011 370z 21831 23998 A white sprt/SOLD 0.174
2010 370z 15070 25500 M silver sprt/nav/heat/bose/SOLD 0.176
2011 370z 15540 26892 A grey sprt/nav/heat/leather/bose 0.186
2009 370z 39999 22995 M yellow sprt 0.192
2010 370z 22000 26500 A grey sprt 0.192
2009 370z 62832 18882 A silver sprt 0.194
2010 370z 45321 23900 A grey - 0.208
2009 370z 31264 26990 M red Nismo 0.210
2009 370z 38438 25482 M grey wheel/heat/alarm 0.210
2009 370z 52175 22990 M black sprt 0.213
2010 370z 58018 21900 A blue sprt/84m_100k 0.215
2011 370z 45810 24973 A silver - 0.219
2010 370z 44192 25692 A grey sprt/nav/heat/leather/bose 0.222
2010 370z 44192 25693 A silver sprt 0.222