I updated the numbers in June and moved the whole process to excel, but I never did get around to posting it, so now seems like a good time! The market has cooled a bit, so some of these values from Hagerty strike me as a little high, but I will be consistent and rely on the Hagerty numbers for this experiment. Personally, I think that the 2016 numbers in general are a bit more accurate for values right now than the 2017 numbers, but I tend to be a bit conservative.
Moving to excel also allows me to make a pretty graph
[TABLE="width: 431"]
<tbody>[TR]
[TD="colspan: 5, align: center"]Condition[/TD]
[/TR]
[TR]
[TD]MY 1991[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD] $ 60,000[/TD]
[TD] $ 42,400[/TD]
[TD] $ 33,100[/TD]
[TD] $ 24,500[/TD]
[/TR]
[TR]
[TD="align: right"]
2016[/TD]
[TD]
$ 77,100[/TD]
[TD]
$ 49,900[/TD]
[TD]
$ 37,600[/TD]
[TD]
$ 28,500[/TD]
[/TR]
[TR]
[TD="align: right"]
2017[/TD]
[TD]
$ 98,700[/TD]
[TD]
$ 62,300[/TD]
[TD]
$ 44,600[/TD]
[TD]
$ 32,000[/TD]
[/TR]
[TR]
[TD="align: right"]2020[/TD]
[TD] $ 85,000[/TD]
[TD] $ 65,000[/TD]
[TD] $ 40,000[/TD]
[TD] $ 30,000[/TD]
[/TR]
[TR]
[TD="align: right"]2025[/TD]
[TD] $ 115,000[/TD]
[TD] $ 95,000[/TD]
[TD] $ 50,000[/TD]
[TD] $ 40,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5, align: center"]Condition[/TD]
[/TR]
[TR]
[TD]MY 1995[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD] $ 66,800[/TD]
[TD] $ 50,800[/TD]
[TD] $ 44,500[/TD]
[TD] $ 33,500[/TD]
[/TR]
[TR]
[TD="align: right"]
2016[/TD]
[TD]
$ 71,400[/TD]
[TD]
$ 54,400[/TD]
[TD]
$ 46,100[/TD]
[TD]
$ 36,600[/TD]
[/TR]
[TR]
[TD="align: right"]
2017[/TD]
[TD]
$ 91,100[/TD]
[TD]
$ 67,900[/TD]
[TD]
$ 54,700[/TD]
[TD]
$ 41,100[/TD]
[/TR]
[TR]
[TD="align: right"]2020[/TD]
[TD] $ 68,000[/TD]
[TD] $ 62,000[/TD]
[TD] $ 46,000[/TD]
[TD] $ 42,000[/TD]
[/TR]
[TR]
[TD="align: right"]2025[/TD]
[TD] $ 85,000[/TD]
[TD] $ 68,000[/TD]
[TD] $ 50,000[/TD]
[TD] $ 40,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5, align: center"]Condition[/TD]
[/TR]
[TR]
[TD]MY 2001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD] $ 74,800[/TD]
[TD] $ 63,600[/TD]
[TD] $ 53,900[/TD]
[TD] $ 47,300[/TD]
[/TR]
[TR]
[TD="align: right"]
2016[/TD]
[TD]
$ 89,500[/TD]
[TD]
$ 77,300[/TD]
[TD]
$ 61,900[/TD]
[TD]
$ 48,500[/TD]
[/TR]
[TR]
[TD="align: right"]
2017[/TD]
[TD]
$ 112,000[/TD]
[TD]
$ 85,600[/TD]
[TD]
$ 69,200[/TD]
[TD]
$ 50,900[/TD]
[/TR]
[TR]
[TD="align: right"]2020[/TD]
[TD] $ 95,000[/TD]
[TD] $ 80,000[/TD]
[TD] $ 58,000[/TD]
[TD] $ 48,000[/TD]
[/TR]
[TR]
[TD="align: right"]2025[/TD]
[TD] $ 110,000[/TD]
[TD] $ 85,000[/TD]
[TD] $ 62,000[/TD]
[TD] $ 58,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5, align: center"]Condition[/TD]
[/TR]
[TR]
[TD]MY 2005[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]2015[/TD]
[TD] $ 84,800[/TD]
[TD] $ 73,500[/TD]
[TD] $ 64,600[/TD]
[TD] $ 61,000[/TD]
[/TR]
[TR]
[TD="align: right"]
2016[/TD]
[TD]
$ 96,400[/TD]
[TD]
$ 79,500[/TD]
[TD]
$ 69,200[/TD]
[TD]
$ 61,700[/TD]
[/TR]
[TR]
[TD="align: right"]
2017[/TD]
[TD]
$ 124,000[/TD]
[TD]
$ 99,300[/TD]
[TD]
$ 82,100[/TD]
[TD]
$ 63,000[/TD]
[/TR]
[TR]
[TD="align: right"]2020[/TD]
[TD] $ 125,000[/TD]
[TD] $ 100,000[/TD]
[TD] $ 80,000[/TD]
[TD] $ 70,000[/TD]
[/TR]
[TR]
[TD="align: right"]2025[/TD]
[TD] $ 150,000[/TD]
[TD] $ 110,000[/TD]
[TD] $ 90,000[/TD]
[TD] $ 72,000[/TD]
[/TR]
</tbody>[/TABLE]