BMW M3 Forum (E90 E92)

BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read


Go Back   M3Post - BMW M3 Forum > M3 (E90 / E92 / E93) > New and Preowned M3 Pricing, Ordering, Tracking / European Delivery / Dealer Reviews
 
VF Engineering
Post Reply
 
Thread Tools Search this Thread
      07-17-2012, 10:30 PM   #1
overdose
Private
 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

Posts: 68
iTrader: (0)

Post 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
overdose is offline   United_States
0
Reply With Quote
      07-17-2012, 11:55 PM   #2
dmurray14
The Stig
 
dmurray14's Avatar
 
Drives: Quickly
Join Date: Apr 2005
Location: US

Posts: 1,230
iTrader: (1)

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
__________________
dmurray14 is offline   United_States
0
Reply With Quote
      07-18-2012, 12:19 AM   #3
dagolfpro
Lieutenant Colonel
 
dagolfpro's Avatar
 
Drives: 2011 E90 M3
Join Date: Sep 2011
Location: SF Bay Area, CA

Posts: 1,562
iTrader: (5)

OD, love the data.
__________________
2011 E90 AW | DCT | ZCP | ZCV | ZCW | ZP2 | Prem Sound | Moonroof | BMW Apps |
ACM Exhaust Mod | M Perf Steering Wheel | Tint | Lux | Painted Reflectors | Hardwired V1 | KW V3 | Volshlag CP | Brembo BBK | 18" Volks TE37SL Pressed Graphite | Yokohama AD08 | Schroth 4 Point Harness | I swear I'm done, no more mods...
dagolfpro is online now   Taiwan
0
Reply With Quote
      07-18-2012, 12:44 AM   #4
DEV M3
Private
 
Drives: Evo X MR
Join Date: May 2012
Location: Houston, TX

Posts: 57
iTrader: (0)

Great data! I'd like to see how the prices change over time... Like what were 08's going for a few years ago vs now... And project those prices into the future
DEV M3 is offline   United_States
0
Reply With Quote
      07-18-2012, 01:50 AM   #5
Xtopherus
Enlisted Member
 
Drives: 2013 E92 M3
Join Date: May 2012
Location: Silicon Valley, CA

Posts: 49
iTrader: (0)

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.
Xtopherus is offline   United_States
0
Reply With Quote
      07-19-2012, 09:15 AM   #6
///Machine
Second Lieutenant
 
///Machine's Avatar
 
Drives: '13 E92 M3 / '11 X5d
Join Date: Apr 2012
Location: CT

Posts: 247
iTrader: (0)

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.
///Machine is offline   United_States
0
Reply With Quote
      07-19-2012, 09:34 AM   #7
trendy26
First Lieutenant
 
Drives: 2013 E92 M3
Join Date: Nov 2008
Location: Florida

Posts: 356
iTrader: (0)

Great Analysis! Out of curiousity, what do you do for a living?
trendy26 is offline  
0
Reply With Quote
      07-19-2012, 12:11 PM   #8
overdose
Private
 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

Posts: 68
iTrader: (0)

Quote:
Originally Posted by dmurray14 View Post
I'd be curious to see it split out by model year - mostly cause I'm interested to see how they hold their value.
Quote:
Originally Posted by DEV M3 View Post
I'd like to see how the prices change over time... Like what were 08's going for a few years ago vs now...
Ask and you shall receive! As you may have guessed from the image below, the data is a little choppy so I'd take the downward trend with a super fine grain of salt (and also because they are averages). But if you really need a hard data point I'd look only at MY2008 since that is 64% of all observations.

__________________
2013 BMW E92 M3
2009 Lexus IS250
overdose is offline   United_States
0
Reply With Quote
      07-19-2012, 12:24 PM   #9
overdose
Private
 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

Posts: 68
iTrader: (0)

Thank you for all the props so far - I hope you guys enjoy it as much as I loved analyzing it!

Quote:
Originally Posted by Xtopherus View Post
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.
Yes, that would be very interesting and if there's enough demand for it maybe we'll do it despite the inherent difficulties.

Quote:
Originally Posted by ///Machine View Post
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?
Very good question but no I did not - R2 was 0.374. In spite of this, I shared it anyways because the model predicted nearly 40% of the prices using just two variables so I thought that was "good enough" for a non-scientific study.

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?

Quote:
Originally Posted by trendy26 View Post
Out of curiousity, what do you do for a living?
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
overdose is offline   United_States
0
Reply With Quote
      07-19-2012, 12:35 PM   #10
SamS
Brigadier General
 
SamS's Avatar
 
Drives: 2013 ActiveHybrid 3
Join Date: Jul 2010
Location: Dallas, TX

Posts: 4,463
iTrader: (0)

Incredible work!!
SamS is offline  
0
Reply With Quote
      07-19-2012, 12:51 PM   #11
Z K
Lieutenant Colonel
 
Z K's Avatar
 
Drives: E90 M3
Join Date: Jul 2011
Location: San Francisco

Posts: 1,893
iTrader: (3)

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.
Z K is offline   United_States
0
Reply With Quote
      07-19-2012, 08:49 PM   #12
dmurray14
The Stig
 
dmurray14's Avatar
 
Drives: Quickly
Join Date: Apr 2005
Location: US

Posts: 1,230
iTrader: (1)

Quote:
Originally Posted by overdose View Post
Ask and you shall receive! As you may have guessed from the image below, the data is a little choppy so I'd take the downward trend with a super fine grain of salt (and also because they are averages). But if you really need a hard data point I'd look only at MY2008 since that is 64% of all observations.

Awesome! Thank you!!
__________________
dmurray14 is offline   United_States
0
Reply With Quote
      07-19-2012, 10:52 PM   #13
PrimoM3
Chemofski
 
PrimoM3's Avatar
 
Drives: '13 X5M
Join Date: Feb 2008
Location: West Coast, U.S.

Posts: 1,290
iTrader: (0)

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
PrimoM3 is offline   United_States
0
Reply With Quote
      07-20-2012, 02:11 AM   #14
Lay-Z M3
Private First Class
 
Drives: ASPP 135i Cab, E90 M3, Mk6 GTI
Join Date: Apr 2010
Location: Was Eastside, then Westside, now Eastside again!!

Posts: 170
iTrader: (0)

Quote:
Originally Posted by overdose View Post

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
Well I'm convinced (esp as you are based in San Fran), that you are Pete (really based on Paul DePodesta) who created the record breaking 20 straight winning team for GM Billy Beane at the Oakland A's 10 years ago!!! lol

You are our Moneyball!!!
Lay-Z M3 is offline   Canada
0
Reply With Quote
      07-21-2012, 07:31 PM   #15
m3buckeye
will bring some beers
 
m3buckeye's Avatar
 
Drives: C63 AMG, e93, Yukon XL
Join Date: Jul 2012
Location: Kali

Posts: 93
iTrader: (0)

Nice work, son.
m3buckeye is offline   United_States
0
Reply With Quote
      07-22-2012, 07:28 PM   #16
chrisjrobi
New Member
 
Drives: 99 Honda Prelude
Join Date: Jun 2012
Location: Hattiesburg MS

Posts: 5
iTrader: (0)

nice work. Thanks for putting this up.
chrisjrobi is offline  
0
Reply With Quote
      07-23-2012, 01:39 PM   #17
cmpe
New Member
 
Drives: N/A
Join Date: Jul 2012
Location: USA

Posts: 17
iTrader: (0)

Thanks for this.

Can you share the spreadsheet as well?
cmpe is offline  
0
Reply With Quote
      07-23-2012, 08:03 PM   #18
overdose
Private
 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

Posts: 68
iTrader: (0)

Quote:
Originally Posted by Lay-Z M3 View Post
Well I'm convinced (esp as you are based in San Fran), that you are Pete (really based on Paul DePodesta) who created the record breaking 20 straight winning team for GM Billy Beane at the Oakland A's 10 years ago!!! lol

You are our Moneyball!!!
LOL - thank you for the compliment but that might be an over statement.


Quote:
Originally Posted by cmpe View Post
Thanks for this.

Can you share the spreadsheet as well?
Absolutely - PM me your email and I'll forward you the raw data.
__________________
2013 BMW E92 M3
2009 Lexus IS250
overdose is offline   United_States
0
Reply With Quote
      07-23-2012, 08:13 PM   #19
overdose
Private
 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

Posts: 68
iTrader: (0)

Just wanted to share with everyone a recent exchange I had with a fellow M3post member...this was about one week ago.

Quote:
trex858: Really cool study you compiled! I am looking at buying a used 2009 and was wondering if you can run the numbers for me? 2009, Space gray, DCT, 37k miles.

overdose: Thanks for your PM and comment! I'd be glad to run the numbers but I'm obligated to let you know that the sample set for MY2009 is very small - only 35. Again, take it with a grain of salt and use it as a benchmark.

That being said, the equation for your specific request is...
Y = -0.2706x + 56024 with a standard error of 4409.

That means your M3 with 37k miles would estimate to around $46,012. A really good deal would be at $41,603 and a very expensive one would be $50,421 or higher.

trex858: Awesome, thank you. The dealer wants $46,998 and $42,000 is exactly what i want to pay for it so from what i can see your numbers are on target based on the current market.
__________________
2013 BMW E92 M3
2009 Lexus IS250
overdose is offline   United_States
0
Reply With Quote
      07-24-2012, 12:52 AM   #20
jonbig12
New Member
 
Drives: 09 370z
Join Date: Jul 2012
Location: Denver, CO

Posts: 13
iTrader: (0)

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.
jonbig12 is offline  
0
Reply With Quote
      07-25-2012, 04:09 PM   #21
dreamspeed
Captain
 
dreamspeed's Avatar
 
Drives: 6MT
Join Date: Jul 2012
Location: Los Angeles

Posts: 933
iTrader: (0)

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.
dreamspeed is offline   United_States
0
Reply With Quote
      07-26-2012, 06:30 PM   #22
mdosu
Banned
 
Drives: Double Vanos'd Civic-M3
Join Date: Oct 2009
Location: San Francisco

Posts: 8,517
iTrader: (6)

sticky this!

thanks, you need to somehow normalize option costs
mdosu is offline   No_Country
0
Reply With Quote
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 12:26 AM.




m3post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST