I kept the end point constant at 10 years. So it was:
* Option 1: Buy a new car, keep 10, and sell
* Option 2: Buy a 3 year old car, keep 7, and sell
* Option 3: Buy a 5 year old car, keep 5, and sell
* Option 4: Buy a 7 year old car, keep 3, and sell
At the time I was shopping, the car I wanted had really high resale. So option 1 was coming out CHEAPER per year than option 2. (new price / 10 compared to used_price / 7). Options 3 and 4 were cheaper, but not by a ton. But then the thing I thought about was:
* With option 1, the car I am driving is an average of 5 years old
* with option 3, the car I am driving is an average of 7.5 years old
* With option 4, the car I am driving is an average of 8.5 years old
So that pushed me to go for option 1. No regrets so far, my car just passed his 7th birthday. Not 100% sure I will sell at 10, but a strong possibility.
I think the simple math of "new car = always bad unless you are rich" is wrong. "new car every 3 years trading in = always bad", sure. But throw in dealer incentives and financing, and the new vs used debate can be less black and white.