This is the last year for the S2000. There are rumours suggesting that by 2008, there will be a similar S2000 convertible replacement but others are suggesting that in 2009, Honda will produce a Prelude replacement. I guess we'll just have to wait until 2008/09.
The 2007 Honda S2000 US website: http://automobiles.honda.com/models/model_overview.asp?ModelName=S2000