|
|
01-14-2008, 02:46 AM | #1 |
Lieutenant General
609
Rep 10,407
Posts |
Configure and price your M3 (spreadsheet)
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. |
01-14-2008, 07:11 AM | #5 |
Captain Darren
12
Rep 157
Posts |
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
|
01-14-2008, 08:37 AM | #6 |
Major
156
Rep 1,430
Posts |
Good stuff, thanks man.
__________________
|
Appreciate
0
|
01-14-2008, 09:38 AM | #7 |
Captain
37
Rep 926
Posts
Drives: e92 M3 6MT
Join Date: Aug 2007
Location: India
|
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
|
01-14-2008, 09:58 AM | #8 |
Commander-In-Chief
2119
Rep 8,919
Posts
Drives: 2023 M2 Coupe, 2020 GLE 450
Join Date: Nov 2005
Location: Lake Oswego, OR
|
GGT
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.
__________________
Greg Lake Oswego, Oregon, USA 2023 M2 Coupe - Brooklyn Grey/Cognac/CF, 6MT; 2020 MB GLE 450 |
Appreciate
0
|
01-14-2008, 10:33 AM | #10 |
Lieutenant Colonel
73
Rep 1,603
Posts
Drives: F80 M3
Join Date: Jul 2007
Location: WHO DAT NATION
|
Swamp,
I DEMAND IMMEDIATE EDITS USING THE OPTIONS POSTED BY EPACY j/k, edited it myself. |
Appreciate
0
|
01-14-2008, 11:14 AM | #11 | |
Lieutenant General
609
Rep 10,407
Posts |
Quote:
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. |
|
Appreciate
0
|
01-14-2008, 11:49 AM | #12 |
Commander-In-Chief
2119
Rep 8,919
Posts
Drives: 2023 M2 Coupe, 2020 GLE 450
Join Date: Nov 2005
Location: Lake Oswego, OR
|
Pricing
One more big correction -- The base price is $56,500. The price you listed includes destination!
__________________
Greg Lake Oswego, Oregon, USA 2023 M2 Coupe - Brooklyn Grey/Cognac/CF, 6MT; 2020 MB GLE 450 |
Appreciate
0
|
01-14-2008, 12:03 PM | #13 |
Major General
374
Rep 8,033
Posts |
|
Appreciate
0
|
01-14-2008, 12:04 PM | #14 |
Lieutenant General
609
Rep 10,407
Posts |
|
Appreciate
0
|
01-14-2008, 12:09 PM | #15 |
Reincarnated
245
Rep 4,227
Posts |
ZPP is $1900.
__________________
|
Appreciate
0
|
01-14-2008, 12:29 PM | #16 |
Commander-In-Chief
2119
Rep 8,919
Posts
Drives: 2023 M2 Coupe, 2020 GLE 450
Join Date: Nov 2005
Location: Lake Oswego, OR
|
Spreadsheet corrections
__________________
Greg Lake Oswego, Oregon, USA 2023 M2 Coupe - Brooklyn Grey/Cognac/CF, 6MT; 2020 MB GLE 450 |
Appreciate
0
|
01-14-2008, 01:50 PM | #17 |
Reincarnated
245
Rep 4,227
Posts |
Also, I think extended leather with ZPP needs to be added.
__________________
|
Appreciate
0
|
01-14-2008, 02:45 PM | #19 |
Major
108
Rep 1,161
Posts |
|
Appreciate
0
|
01-14-2008, 03:25 PM | #21 |
Second Lieutenant
8
Rep 218
Posts |
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
|
01-14-2008, 07:44 PM | #22 | |
Lieutenant General
609
Rep 10,407
Posts |
Quote:
|
|
Appreciate
0
|
Post Reply |
Bookmarks |
|
|