|
|
07-17-2012, 10:30 PM | #1 |
Private
4
Rep 74
Posts |
Used E9x M3 Price Modeling ('08-'12)
For the past couple months I've been looking to buy an E92 M3 (new or used). I quickly found there was no single resource people could consult for E9x prices. Since I work in a data intensive field I thought it'd be fun to create a very crude formula to help members see how their offers compared with those before them.
My objective for this thread is to help other members make a smart purchasing decision for a USED E9x M3 with a simple equation. Also, at the very end of this post I'll share some interesting insights about M3post.com users that I found. ABOUT THE DATA There is a total of 166 data points and they're all pulled from this post...how much did you pay for your used m3? The first purchasing date goes back to December 2008 and the most recent in July 2012. I collected model years, model type, transmission type, miles at time of purchase, exterior color and of course price. Even a small survey like this can get pretty complicated so for the sake of simplicity I excluded a bunch of variables (options/packages, negotiation skills of the individual, location of purchase, taxes, etc). I also excluded people who couldn't follow directions (new cars, older models, no transmission listed, etc). Also, for those who posted Canadian dollars I converted them to USD on 7/16/2012 without adjusting for inflation or historical currency exchange rates. Lastly, it's important to note this was a voluntary submission from M3post members so it may not represent the entire pricing population. THE EQUATION If you remember basic algebra then this should be pretty simple for you. Here's the pricing equation with x being the number of miles on the car: ESTIMATED PRICE = -0.3001x + 54146 Thus, an M3 with 20,000 miles on it would be priced at approximately $48,144. And since the standard error is 5472, a very lucky person could pay as low as $42,672. On the other hand, someone who doesn't care about negotiating (or lives in an area with a higher standard of living...or it includes all the possible packages...or etc) could pay as much as $53,616. Of course, if you don't want to do the math you can just look it up in the image below. To those who purchased and didn't participate in the discussion...does the equation work out? All that being said and done, I'd like to point out that the M3post community is what makes this forum thrive. If you have a question about the price of your specific offer, go ahead and ask - don't be afraid! This formula is far from being gospel as it doesn't account for a TON of other factors. INTERESTING TIDBITS In my opinion, this is the best part as it gives a glimpse into the M3post community. Without further ado, out of 166 members who bought a used E9x M3... Model Year 2008 = 64% 2009 = 21% 2010 = 6% 2011 = 9% Model Type E90 = 38% E92 = 51% E93 = 11% Transmission Type 6MT = 52% DCT = 48% Exterior Color No Color Specified = 27% Alpine White = 20% Jerez Black = 17% Jet Black = 10% Space Gray = 7% Interlagos Blue = 5% Silverstone = 4% Melbourne Red = 4% Sparkling Graphite = 4% Dakar Yellow = 1% LeMans Blue = 1% I'll let you make your own conclusions on what this says about our members haha. ACKNOWLEDGEMENTS Thank you to the 166 members who posted their purchasing information over the past 2 years. This survey obviously would not exist if it weren't for you all. FINAL THOUGHTS I love doing this sort of geeky stuff so if you'd like to see another one on a larger scale that includes options, packages and whatever else just let me know (granted there is enough demand). Finally, if you want me to narrow down an equation for super specific options (2008, E92 AW, 6MT, 12k miles) then just PM me.
__________________
2013 BMW E92 M3
2009 Lexus IS250 |
07-17-2012, 11:55 PM | #2 |
The Stig
31
Rep 1,232
Posts |
Nice! I'd be curious to see it split out by model year - mostly cause I'm interested to see how they hold their value. Next up, calculate the impact the release of the e92 had on the last model year of the e46 m3s
__________________
|
Appreciate
0
|
07-18-2012, 12:19 AM | #3 |
Colonel
248
Rep 2,271
Posts |
OD, love the data.
__________________
2011.75 E90 AW | DCT | ZCP | ZCV | ZCW | ZP2 | Prem Sound | Moonroof | BMW Apps |
Mods List: Evolve Exhaust | M Perf Steering Wheel | Tint | Lux | Hardwired V1 | KW V3 | Volshlag CP | Brembo BBK | BBS FI | Yokohama AD08 R| Schroth 4 Point Harness | Challenge GT Diffuser | OEM GTS Wing| GTS Lip| I lied earlier, I wasn't done with mod, but I swear, I'm done now, no more mods... |
Appreciate
0
|
07-18-2012, 01:50 AM | #5 |
Enlisted Member
3
Rep 49
Posts |
Nicely done! It would be interesting to add a third dimension to the regression (age), but that appears to make things a lot more difficult and it's difficult to reliably collect from the available data anyway.
It is rather interesting to note that each mile takes 30¢ off the value of the vehicle. |
Appreciate
0
|
07-19-2012, 09:15 AM | #6 |
Second Lieutenant
11
Rep 260
Posts |
Great work!! I'll be in the market for an M3 in 2013 (used or new TBD) and this is very insughtful. I probably will have to scan through all the pages in that thread anyways - focused on year, body style, options, etc. But this is a great start.
Out of curiosity, did you get a significant R2? When you include the other variables, does the R2 improves significantly? On the more detailed analysis did you look at E90/92/93 separately? I would definitely be interested in the results of the more detailed analysis. Should I pm you or you plan on posting some time? I wish this thread gets much more views, because it really deserves. |
Appreciate
0
|
07-19-2012, 12:11 PM | #8 | ||
Private
4
Rep 74
Posts |
Quote:
Quote:
__________________
2013 BMW E92 M3
2009 Lexus IS250 |
||
Appreciate
0
|
07-19-2012, 12:24 PM | #9 | ||
Private
4
Rep 74
Posts |
Thank you for all the props so far - I hope you guys enjoy it as much as I loved analyzing it!
Quote:
Quote:
RE: Detailed analysis - I definitely plan on posting more over time depending on the demand. Also, since the data set is so small I can only slice and dice it so many ways. Was there something you were interested in? I work in the Interactive Marketing department for Macys.com. I attempt to find trends in our data and see how users behave on our website to make them buy more stuff
__________________
2013 BMW E92 M3
2009 Lexus IS250 |
||
Appreciate
0
|
07-19-2012, 12:51 PM | #11 |
Major General
1889
Rep 5,506
Posts |
So based on your findings can you predict what the price of the car will fall to over time? I assume the delta in pricing will decrease as the car gets over eventually settling on a plateau as the car gets older.
|
Appreciate
0
|
07-19-2012, 08:49 PM | #12 | |
The Stig
31
Rep 1,232
Posts |
Quote:
__________________
|
|
Appreciate
0
|
07-19-2012, 10:52 PM | #13 |
Chemofski
54
Rep 1,295
Posts |
Check out the big brain on Brad... Nice work though, seriously.
__________________
'13 Individual Frozen Brilliant White ///M3 Coupe
Ordered 2/15/12 | Euro Delivery on 9/21/12 | U.S. Redelivery on 12/6/12 | Motor Dead on 7/15/13 '13 Space Gray/Mugello Red X5///M Pavement Punisher | Snow Muncher | Family and Board Hauler | Roadtripper |
Appreciate
0
|
07-20-2012, 02:11 AM | #14 | |
Private First Class
16
Rep 179
Posts
Drives: ASPP 135i Cab, E90 M3, M235i
Join Date: Apr 2010
Location: Was Eastside, then Westside, now Eastside again!!
|
Quote:
You are our Moneyball!!! |
|
Appreciate
0
|
07-23-2012, 08:03 PM | #18 | |
Private
4
Rep 74
Posts |
Quote:
Absolutely - PM me your email and I'll forward you the raw data.
__________________
2013 BMW E92 M3
2009 Lexus IS250 |
|
Appreciate
0
|
07-23-2012, 08:13 PM | #19 | |
Private
4
Rep 74
Posts |
Just wanted to share with everyone a recent exchange I had with a fellow M3post member...this was about one week ago.
Quote:
__________________
2013 BMW E92 M3
2009 Lexus IS250 |
|
Appreciate
0
|
07-24-2012, 12:52 AM | #20 |
New Member
0
Rep 13
Posts |
I've been lurking for a while and had to register when I saw this just to say thanks! No more "Is this a good deal" threads for me. I was considering doing something similar, but would never have been able to do this good of a job. Kudos.
|
Appreciate
0
|
07-25-2012, 04:09 PM | #21 |
Lieutenant Colonel
262
Rep 1,616
Posts |
Nice work! And it's probably too much work but any chance on seeing this data split by location? I'm looking into buying a used E92 soon and would be interested in seeing the average cost in the Los Angeles area. Or if a nearby state has substantially lower costs it might be worth it to check it out.
|
Appreciate
0
|
Post Reply |
Bookmarks |
|
|