Configure and price your M3 (spreadsheet)

swamp2 · 01-14-2008, 02:46 AM

Using this handy spreadsheet you can simply check the options you want, your states sales tax rate and the spreadsheet does the rest; options price subtotal, sales tax, gas guzzler tax, total vehicle out the door, etc. Finally there is a matrix of down payment amounts (not visible in the screen grab) and loan rates to help you figure out payments. These are also configurable.

Please feel free to correct or ammend and repost. I did this fairly quickly based off of a much older revision with all EU options.

Disclaimer: The options prices herein are estimates, but are likely quite close to the prices that will be announced. Please refer to the other threads herein to discuss or debate those prices or the rationale behind those estimates.

Enjoy.

Simple1 · 01-14-2008, 04:28 AM

thx alot

drvai · 01-14-2008, 05:31 AM

I think that are anticipating too much as for the option and GG price.
Let's wait and see until they release the complete price spec. You may be surprised.

RandyB · 01-14-2008, 06:37 AM

Very nice. Thanks swamp!

Gadgetman · 01-14-2008, 07:11 AM

You've forgot 752 Enhanced Premium Sound.

Thanks a bunch for building the M3 Calculator.

Regards,

SS32 · 01-14-2008, 08:37 AM

Good stuff, thanks man.

the_stranger · 01-14-2008, 09:38 AM

Nicely done. But on what basis did you do this?

GregW / Oregon · 01-14-2008, 09:58 AM

Quote:

Originally Posted by swamp2

Please feel free to correct or ammend and repost. I did this fairly quickly based off of a much older revision with all EU options.

Thanks--one correction: The GGT cannot be $1,900, unless you were just using that as an average. The increments are $1,000, $1,300, $1,700, $2,100.... I'm guessing it will stay at $1,300, like the E46, but I guess we'll see soon.

Dinan540 · 01-14-2008, 10:17 AM

Great estimate ....thanks!

Keto · 01-14-2008, 10:33 AM

Swamp,

I DEMAND IMMEDIATE EDITS USING THE OPTIONS POSTED BY EPACY

j/k,

edited it myself.

swamp2 · 01-14-2008, 11:14 AM

Quote:

Originally Posted by Keto

Swamp,

I DEMAND IMMEDIATE EDITS USING THE OPTIONS POSTED BY EPACY

j/k,

edited it myself.

It would be great to update as per all comments and repost. I guess if you don't I will (eventually).

EDIT: OK, made all the corrections and lowered M-DCT by a bit since most options are coming in under consensus values. Another big win here folks! SS attached.

GregW / Oregon · 01-14-2008, 11:49 AM

Quote:

Originally Posted by swamp2

It would be great to update as per all comments and repost. I guess if you don't I will (eventually).

EDIT: OK, made all the corrections and lowered M-DCT by a bit since most options are coming in under consensus values. Another big win here folks! SS attached.

One more big correction -- The base price is $56,500. The price you listed includes destination!

lucid · 01-14-2008, 12:03 PM

Quote:

Originally Posted by GregW / Oregon

One more big correction -- The base price is $56,500. The price you listed includes destination!

I compeletely missed this as well! That's great news--after the fact!

swamp2 · 01-14-2008, 12:04 PM

Quote:

Originally Posted by GregW / Oregon

One more big correction -- The base price is $56,500. The price you listed includes destination!

Already corrected in the revision!

Epacy · 01-14-2008, 12:09 PM

ZPP is $1900.

GregW / Oregon · 01-14-2008, 12:29 PM

Quote:

Originally Posted by Epacy

ZPP is $1900.

And optional trims are probably $300 without it.

Epacy · 01-14-2008, 01:50 PM

Also, I think extended leather with ZPP needs to be added.

dillon733 · 01-14-2008, 02:40 PM

DCT?????
Is this price a fact or an estimate?

gadget · 01-14-2008, 02:45 PM

Quote:

Originally Posted by dillon733

DCT?????
Is this price a fact or an estimate?

Estimate- Official Specs, Price and launch date for the M-DCT haven't been released yet. This information will probably be released in the comming weeks- no later than March.

lucid · 01-14-2008, 03:08 PM

There is a rumor floating around that M-DCT press release will be on Jan 20th. Not sure if that includes pricing or not.

Yonkers · 01-14-2008, 03:25 PM

I have edited the spreadsheet so that if you have ZPP checked then Extended Leather (NDXY) will only cost $1100. If you don't have ZPP checked then it costs $2000.
To do this just change cell F3 of the spreadsheet to read
=IF(AND(A3="x",A24="x"),1100,IF(A3="x",E3,0))

Hope that helps.

swamp2 · 01-14-2008, 07:44 PM

Quote:

Originally Posted by Yonkers

I have edited the spreadsheet so that if you have ZPP checked then Extended Leather (NDXY) will only cost $1100. If you don't have ZPP checked then it costs $2000.
To do this just change cell F3 of the spreadsheet to read
=IF(AND(A3="x",A24="x"),1100,IF(A3="x",E3,0))

Hope that helps.

Nice. I was going to include all of this logic but there are more "if thens" than this one. Either way post it up with all of the other corrections as well. We'll all appreciate it. Just zip and attach. Cheers.

01-14-2008, 04:28 AM	#2
Simple1 Major 134 Rep 1,060 Posts Drives: G05 X5 40i M Sport Join Date: Mar 2005 Location: Earth iTrader: (1)	thx alot __________________ G05 X40M Sport F80 M3 Euro Delivered = Gone too Soon e90 335i debadged = Gone but not forgotten
	Appreciate 0 Quote

01-14-2008, 05:31 AM	#3
drvai Major 135 Rep 1,274 Posts Drives: E92 M3 AW Join Date: Dec 2007 Location: FL iTrader: (0)	I think that are anticipating too much as for the option and GG price. Let's wait and see until they release the complete price spec. You may be surprised.
	Appreciate 0 Quote

01-14-2008, 06:37 AM	#4
RandyB Lieutenant Colonel 20 Rep 1,504 Posts Drives: '03 330i, '09 M3 Coupe Join Date: Feb 2007 Location: Texas iTrader: (0)	Very nice. Thanks swamp!
	Appreciate 0 Quote

01-14-2008, 07:11 AM	#5
Gadgetman Captain Darren 12 Rep 157 Posts Drives: Canadian Regional Jet 900 Join Date: Oct 2007 Location: KJAX/KDFW iTrader: (0)	You've forgot 752 Enhanced Premium Sound. Thanks a bunch for building the M3 Calculator. Regards, __________________ 2015 Porsche GT3 (sold) 2008 Porsche C4S (sold) 2008 BMW E60 M5 Space Gray (sold) 2005 BMW E46 M3 TiAg (sold)
	Appreciate 0 Quote

01-14-2008, 08:37 AM	#6
SS32 Major 156 Rep 1,430 Posts Drives: 2008 M3 Join Date: May 2007 Location: Raleigh, NC iTrader: (0)	Good stuff, thanks man. __________________ V1 DIY - Blinder M45 DIY - Exhaust Cutouts - Removed Clutch Pedal Spring DIY - Fiamm Air Horns
	Appreciate 0 Quote

01-14-2008, 09:38 AM	#7
the_stranger Captain 37 Rep 926 Posts Drives: e92 M3 6MT Join Date: Aug 2007 Location: India iTrader: (1) Garage List 2009 BMW M3 Coupe [0.00]	Nicely done. But on what basis did you do this? __________________ 2008 e92 M3 6MT AW/BLACK (SOLD) 2009 e92 M3 6MT AW/FR
	Appreciate 0 Quote

01-14-2008, 10:17 AM	#9
Dinan540 Bimmer Geek 7 Rep 33 Posts Drives: Supercharged 540i & 08 M3 Join Date: Jan 2008 Location: Buckeye State iTrader: (0)	Great estimate ....thanks!
	Appreciate 0 Quote

01-14-2008, 10:33 AM	#10
Keto Lieutenant Colonel 73 Rep 1,603 Posts Drives: F80 M3 Join Date: Jul 2007 Location: WHO DAT NATION iTrader: (1) Garage List 2015 BMW M3 [10.00]	Swamp, I DEMAND IMMEDIATE EDITS USING THE OPTIONS POSTED BY EPACY j/k, edited it myself.
	Appreciate 0 Quote

01-14-2008, 12:09 PM	#15
Epacy Reincarnated 245 Rep 4,227 Posts Drives: 02 Maxima SE Join Date: Mar 2007 Location: IL iTrader: (0) Garage List 2008 M3 [0.00]	ZPP is $1900. __________________ Pearl Bliss
	Appreciate 0 Quote

01-14-2008, 01:50 PM	#17
Epacy Reincarnated 245 Rep 4,227 Posts Drives: 02 Maxima SE Join Date: Mar 2007 Location: IL iTrader: (0) Garage List 2008 M3 [0.00]	Also, I think extended leather with ZPP needs to be added. __________________ Pearl Bliss
	Appreciate 0 Quote

01-14-2008, 02:40 PM	#18
dillon733 Major 96 Rep 1,196 Posts Drives: Jet Black e92 M3 Join Date: Oct 2007 Location: new york iTrader: (3)	DCT????? Is this price a fact or an estimate?
	Appreciate 0 Quote

01-14-2008, 03:08 PM	#20
lucid Major General 374 Rep 8,033 Posts Drives: E30 M3; Expedition Join Date: Apr 2007 Location: USA iTrader: (0)	There is a rumor floating around that M-DCT press release will be on Jan 20th. Not sure if that includes pricing or not.
	Appreciate 0 Quote

01-14-2008, 03:25 PM	#21
Yonkers Second Lieutenant 8 Rep 218 Posts Drives: 2006 BMW M5 Join Date: Dec 2007 Location: Houston, TX iTrader: (0)	I have edited the spreadsheet so that if you have ZPP checked then Extended Leather (NDXY) will only cost $1100. If you don't have ZPP checked then it costs $2000. To do this just change cell F3 of the spreadsheet to read =IF(AND(A3="x",A24="x"),1100,IF(A3="x",E3,0)) Hope that helps.
	Appreciate 0 Quote