Joined
·
11 Posts
I've spent the last several days doing a ton of research on Porsche and the 911 and Cayman. After a bunch of test drives, I've decided on a CPO 2017 or 2018 Cayman or Cayman S. (If you're interested in the backstory, it's detailed in this monster thread here: rennlist. com/forums/991/1102984-question-from-a-person-new-to-porsche-5.html
I've identified 6 cars all of which I'd be happy in. They vary a bit in options and pricing, but I am indifferent to the variation in the options and I can afford any of them, so at this point I just want whichever one I'll get the best deal on. My plan is to come up with offers prices for each and then email each dealer with the offer and see what they respond with. To come up with offer prices, I tried to make a pricing model using the depreciation data for Cayman 718s I could find through googling. I was hoping some of the experts on this board could check out my spreadsheet below to let me know if the offer prices I calculated seem reasonable? My model takes MSRP, then assuming 2019 is the current model year, applies a 1 yr residual of 81% (assuming 10,000 miles driven) for 2018 and a 2 yr residual of 69% (assuming 20,000 miles driven) for 2017. I then adjust at 22cents per mile, for the variance of actual miles on the car vs the model assumptions of 10k mile driven for 2018 and 20k miles driven for 2017, adding or subtracting to estimated value, and then subtract an additional $3k for negotiation room to arrive at my offer price for each car. Do these assumptions make sense and do my offers seem reasonable? Just wanted to check with you guys as I'm ready to start submitting these offers by email to the dealers that I've already contacted for all of these cars. Thanks!
docs.google .com/spreadsheets/d/1wC-EgO-nsO-QY1KMFD4GTQ-sVQulUcBzR54vPaYqqVc/edit?usp=sharing
PS (My post count doesn't allow sending links, so I broke up the above urls into 2, just remove the space between .com and the previous bit to get them to work.)
I've identified 6 cars all of which I'd be happy in. They vary a bit in options and pricing, but I am indifferent to the variation in the options and I can afford any of them, so at this point I just want whichever one I'll get the best deal on. My plan is to come up with offers prices for each and then email each dealer with the offer and see what they respond with. To come up with offer prices, I tried to make a pricing model using the depreciation data for Cayman 718s I could find through googling. I was hoping some of the experts on this board could check out my spreadsheet below to let me know if the offer prices I calculated seem reasonable? My model takes MSRP, then assuming 2019 is the current model year, applies a 1 yr residual of 81% (assuming 10,000 miles driven) for 2018 and a 2 yr residual of 69% (assuming 20,000 miles driven) for 2017. I then adjust at 22cents per mile, for the variance of actual miles on the car vs the model assumptions of 10k mile driven for 2018 and 20k miles driven for 2017, adding or subtracting to estimated value, and then subtract an additional $3k for negotiation room to arrive at my offer price for each car. Do these assumptions make sense and do my offers seem reasonable? Just wanted to check with you guys as I'm ready to start submitting these offers by email to the dealers that I've already contacted for all of these cars. Thanks!
docs.google .com/spreadsheets/d/1wC-EgO-nsO-QY1KMFD4GTQ-sVQulUcBzR54vPaYqqVc/edit?usp=sharing
PS (My post count doesn't allow sending links, so I broke up the above urls into 2, just remove the space between .com and the previous bit to get them to work.)