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
 
GetBMWParts
Post Reply
 
Thread Tools Search this Thread
      07-17-2012, 10:30 PM   #1
overdose
Private
United_States
1
Rep
73
Posts

 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

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
Appreciate 0
      07-17-2012, 11:55 PM   #2
dmurray14
The Stig
dmurray14's Avatar
United_States
18
Rep
1,232
Posts

 
Drives: Quickly
Join Date: Apr 2005
Location: US

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
__________________
Appreciate 0
      07-18-2012, 12:19 AM   #3
dagolfpro
Lieutenant Colonel
dagolfpro's Avatar
Taiwan
30
Rep
1,911
Posts

 
Drives: 2011 E90 M3
Join Date: Sep 2011
Location: SF Bay Area, CA

iTrader: (9)

OD, love the data.
__________________
2011 E90 AW | DCT | ZCP | ZCV | ZCW | ZP2 | Prem Sound | Moonroof | BMW Apps |
Evolve Exhaust | 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 | Challenge GT Diffuser | I lied earlier, I wasn't done with mod, but I swear, I'm done now, no more mods...
Appreciate 0
      07-18-2012, 12:44 AM   #4
DEV M3
Private
United_States
0
Rep
57
Posts

 
Drives: Evo X MR
Join Date: May 2012
Location: Houston, TX

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
Appreciate 0
      07-18-2012, 01:50 AM   #5
Xtopherus
Enlisted Member
United_States
0
Rep
49
Posts

 
Drives: 2013 E92 M3
Join Date: May 2012
Location: Silicon Valley, CA

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.
Appreciate 0
      07-19-2012, 09:15 AM   #6
///Machine
Second Lieutenant
///Machine's Avatar
United_States
4
Rep
247
Posts

 
Drives: '13 E92 M3 / '11 X5d
Join Date: Apr 2012
Location: CT

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.
Appreciate 0
      07-19-2012, 09:34 AM   #7
trendy26
First Lieutenant
11
Rep
364
Posts

 
Drives: 2013 E92 M3
Join Date: Nov 2008
Location: Florida

iTrader: (0)

Great Analysis! Out of curiousity, what do you do for a living?
Appreciate 0
      07-19-2012, 12:11 PM   #8
overdose
Private
United_States
1
Rep
73
Posts

 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

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
Appreciate 0
      07-19-2012, 12:24 PM   #9
overdose
Private
United_States
1
Rep
73
Posts

 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

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
Appreciate 0
      07-19-2012, 12:35 PM   #10
SamS
Brigadier General
SamS's Avatar
61
Rep
4,574
Posts

 
Drives: 2013 ActiveHybrid 3
Join Date: Jul 2010
Location: Dallas, TX

iTrader: (0)

Incredible work!!
Appreciate 0
      07-19-2012, 12:51 PM   #11
Z K
Colonel
Z K's Avatar
United_States
26
Rep
2,173
Posts

 
Drives: E90 M3, MK6 GLI
Join Date: Jul 2011
Location: San Francisco

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.
Appreciate 0
      07-19-2012, 08:49 PM   #12
dmurray14
The Stig
dmurray14's Avatar
United_States
18
Rep
1,232
Posts

 
Drives: Quickly
Join Date: Apr 2005
Location: US

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!!
__________________
Appreciate 0
      07-19-2012, 10:52 PM   #13
PrimoM3
Chemofski
PrimoM3's Avatar
United_States
19
Rep
1,294
Posts

 
Drives: '13 X5M
Join Date: Feb 2008
Location: West Coast, U.S.

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
Appreciate 0
      07-20-2012, 02:11 AM   #14
Lay-Z M3
Private First Class
Canada
4
Rep
171
Posts

 
Drives: ASPP 135i Cab, E90 M3, Mk6 GTI
Join Date: Apr 2010
Location: Was Eastside, then Westside, now Eastside again!!

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!!!
Appreciate 0
      07-21-2012, 07:31 PM   #15
m3buckeye
will bring some beers
m3buckeye's Avatar
United_States
1
Rep
102
Posts

 
Drives: C63 AMG, e93, Yukon XL
Join Date: Jul 2012
Location: Kali

iTrader: (0)

Nice work, son.
Appreciate 0
      07-22-2012, 07:28 PM   #16
chrisjrobi
New Member
0
Rep
5
Posts

 
Drives: 99 Honda Prelude
Join Date: Jun 2012
Location: Hattiesburg MS

iTrader: (0)

nice work. Thanks for putting this up.
Appreciate 0
      07-23-2012, 01:39 PM   #17
cmpe
New Member
0
Rep
17
Posts

 
Drives: N/A
Join Date: Jul 2012
Location: USA

iTrader: (0)

Thanks for this.

Can you share the spreadsheet as well?
Appreciate 0
      07-23-2012, 08:03 PM   #18
overdose
Private
United_States
1
Rep
73
Posts

 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

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
Appreciate 0
      07-23-2012, 08:13 PM   #19
overdose
Private
United_States
1
Rep
73
Posts

 
Drives: 2013 E92 M3
Join Date: Jul 2012
Location: San Francisco, CA

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
Appreciate 0
      07-24-2012, 12:52 AM   #20
jonbig12
New Member
0
Rep
13
Posts

 
Drives: 09 370z
Join Date: Jul 2012
Location: Denver, CO

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.
Appreciate 0
      07-25-2012, 04:09 PM   #21
dreamspeed
Major
dreamspeed's Avatar
United_States
13
Rep
1,092
Posts

 
Drives: 6MT
Join Date: Jul 2012
Location: Los Angeles

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.
Appreciate 0
      07-26-2012, 06:30 PM   #22
mdosu
Banned
No_Country
117
Rep
8,517
Posts

 
Drives: Double Vanos'd Civic-M3
Join Date: Oct 2009
Location: San Francisco

iTrader: (6)

sticky this!

thanks, you need to somehow normalize option costs
Appreciate 0
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 08:14 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