Nissan 370Z Forum - View Single Post - How I compared/normalized used 370Z when I shopped, hope this is helpful to you

coffeebob · 02-17-2014, 03:47 PM

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

02-17-2014, 03:47 PM	#1 (permalink)
coffeebob Base Member Join Date: Feb 2014 Location: coffeeland Posts: 42 Drives: coffee grinder Rep Power: 12	How I compared/normalized used 370Z when I shopped, hope this is helpful to you 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