Trying to estimate how many S2000s remain
#11
Another tactic to try may be to take the UK registration numbers, which show S2000 road registrations yearly, and extrapolate its total sales vs latest registrations to US total sales. Still lots of assumptions, but it is another way to get a number to compare..
Peak was 8,529 registrations in 2009, and 7,247 in 2016, or ~84%. That would put just over ~56k S2000s still on the road in NA, but no accounting for stock, rebuilt, etc...
https://www.howmanyleft.co.uk/browse/honda/honda_s2000
Peak was 8,529 registrations in 2009, and 7,247 in 2016, or ~84%. That would put just over ~56k S2000s still on the road in NA, but no accounting for stock, rebuilt, etc...
https://www.howmanyleft.co.uk/browse/honda/honda_s2000
#12
I would totally do that if I had a house with a garage. Isn't feasible in an apartment.
#13
I got a little higher estimate, approx 41k. Thanks to the posters who noted 1) totaled doesn't mean off the road 2) We should model year by year, eg. the 2009 models weren't on the road in 2000.
Question: Can a car be totaled multiple times? Say a car is totaled, then gets branded rebuilt and then gets into another major accident? The model assumes a car can only be totaled once.
Its been a long time since this finance major built a model. Whaddya think?
Clean title S2000s Remaining in the USA
Question: Can a car be totaled multiple times? Say a car is totaled, then gets branded rebuilt and then gets into another major accident? The model assumes a car can only be totaled once.
Its been a long time since this finance major built a model. Whaddya think?
Clean title S2000s Remaining in the USA
#14
I tried to do a model like that and went blind! The loss is 3.47% of the remaining cars every year. That reflected in your spreadsheet? (My quick model was wrong in this respect.)
Probably some exotic Excel function that will do this but I only use about 3.47% of what Excel is capable of.
-- Chuck
Probably some exotic Excel function that will do this but I only use about 3.47% of what Excel is capable of.
-- Chuck
#15
I tried to do a model like that and went blind! The loss is 3.47% of the remaining cars every year. That reflected in your spreadsheet? (My quick model was wrong in this respect.)
Probably some exotic Excel function that will do this but I only use about 3.47% of what Excel is capable of.
-- Chuck
Probably some exotic Excel function that will do this but I only use about 3.47% of what Excel is capable of.
-- Chuck
It is 3.47% of the remaining cars each year. I'm just curious if a car can be totaled twice. The model assumes they can't.
Last edited by ChiHonda; 05-04-2017 at 08:53 AM.
#16
I got a little higher estimate, approx 41k. Thanks to the posters who noted 1) totaled doesn't mean off the road 2) We should model year by year, eg. the 2009 models weren't on the road in 2000.
Question: Can a car be totaled multiple times? Say a car is totaled, then gets branded rebuilt and then gets into another major accident? The model assumes a car can only be totaled once.
Its been a long time since this finance major built a model. Whaddya think?
Clean title S2000s Remaining in the USA
Question: Can a car be totaled multiple times? Say a car is totaled, then gets branded rebuilt and then gets into another major accident? The model assumes a car can only be totaled once.
Its been a long time since this finance major built a model. Whaddya think?
Clean title S2000s Remaining in the USA
The following users liked this post:
ChiHonda (05-04-2017)
#17
I can shed some light...
According to Experian National VIO (vehicles in operation) as of the close of Q4 2016, 52,178 S2000s are still registered with the DMV. So more than people are estimating here.
I'm not an expert, but i think this number may exclude vehicles that are PNO (planned non-op) as Experian's website says their VIO is "a collection of all cars and light trucks that are currently registered on the road." Either way it's either with or without PNO, which is probably a negligible number anyway.
From close of Q2 2016 to close of Q4 2016, we lost 725 cars.
The most staggering statistic? there's only 14 2009 CR registered! (535 2008 CR)
Q1 2017 numbers should be out shortly so i can update if you'd like.
EDIT: Disclaimer: This data, although an industry standard tool, is not perfect. For example, i just looked up 1998 Integra Type R and it shows zero are registered...which i don't believe since i've seen a few of them roaming around SoCal...hmm...
According to Experian National VIO (vehicles in operation) as of the close of Q4 2016, 52,178 S2000s are still registered with the DMV. So more than people are estimating here.
I'm not an expert, but i think this number may exclude vehicles that are PNO (planned non-op) as Experian's website says their VIO is "a collection of all cars and light trucks that are currently registered on the road." Either way it's either with or without PNO, which is probably a negligible number anyway.
From close of Q2 2016 to close of Q4 2016, we lost 725 cars.
The most staggering statistic? there's only 14 2009 CR registered! (535 2008 CR)
Q1 2017 numbers should be out shortly so i can update if you'd like.
EDIT: Disclaimer: This data, although an industry standard tool, is not perfect. For example, i just looked up 1998 Integra Type R and it shows zero are registered...which i don't believe since i've seen a few of them roaming around SoCal...hmm...
The following users liked this post:
NNY S2k (05-04-2017)
#19
Q4 2016
Vehicle Count Model Year Sub Model
6,763 2000Base
7,324 2001Base
7,587 2002Base
6,061 2003Base
5,936 2004Base
7,084 2005Base
4,786 2006Base
4,126 2007Base
1,692 2008Base
530 2008CR
275 2009Base
14 2009CR
52,178 Total
Vehicle Count Model Year Sub Model
6,763 2000Base
7,324 2001Base
7,587 2002Base
6,061 2003Base
5,936 2004Base
7,084 2005Base
4,786 2006Base
4,126 2007Base
1,692 2008Base
530 2008CR
275 2009Base
14 2009CR
52,178 Total