Feedback wanted on price calculator draft

Str1d3r · 03-12-2009, 06:41 AM

I just put together a price/payment calculator to help me make up my mind on getting a 328i v. 335i and ED v. USA delivery. Attached is a jpeg shot of the Excel page for the 328i. I'd appreciate any feedback on costs and calculations. You can unzip the Excel in the Financing forum (sorry about double post, but I'm sure some people won't open zipped files). Thanks in advance.

methodtim · 03-12-2009, 06:47 AM

No attachment. Post fail.

Zirenz2006 · 03-12-2009, 07:05 AM

Have you driven a 328 and a 335? I would think if you had the decision would be very simple. I'd take a less optioned 335 vs a more optioned 328 if I wanted to stay within a certain budget.

Str1d3r · 03-12-2009, 10:19 AM

Quote:

Originally Posted by methodtim

No attachment. Post fail.

Here you go.

Str1d3r · 03-12-2009, 10:23 AM

Quote:

Originally Posted by Zirenz2006

Have you driven a 328 and a 335? I would think if you had the decision would be very simple. I'd take a less optioned 335 vs a more optioned 328 if I wanted to stay within a certain budget.

I have driven both and liked them both immensely. The 335i is stupid fast, but the 328i is no slouch either. Since I don't go to the track (at least yet) the 328i will easily exceed my daily driver needs, but for only a few dollars more...and this worksheet will hopefully help me make the decision.

Hoothout · 03-12-2009, 10:25 AM

i would do euro delivery on a 335

krote345 · 03-12-2009, 10:27 AM

I assume you are buying and not leasing correct? That was the deal breaker for me on the 335. The money factor is MUCH better on the 328i lease.

ToadHollow · 03-12-2009, 10:31 AM

Quote:

Originally Posted by PaCman328

i would do euro delivery on a 335

+1

I will definitely be doing this with any future purchase ......

mike-y · 03-12-2009, 10:31 AM

it's $7,000 dollars between the two cars they way you have them configured. Is that worth it to you? We are not buying the car - you are, so you have to make that decision. you can lose a few options on the 335 to bring the difference down, but it all comes down to what price you feel comfortable with.

Str1d3r · 03-12-2009, 11:31 AM

Quote:

Originally Posted by mike-y

it's $7,000 dollars between the two cars they way you have them configured. Is that worth it to you? We are not buying the car - you are, so you have to make that decision. you can lose a few options on the 335 to bring the difference down, but it all comes down to what price you feel comfortable with.

I'm actually asking for feedback on the pricing worksheet. The numbers, what to tax and what not to, etc. Do they look ok? Am I missing anything?

methodtim · 03-12-2009, 12:28 PM

Quote:

Originally Posted by Str1d3r

I just put together a price/payment calculator to help me make up my mind on getting a 328i v. 335i and ED v. USA delivery. Attached is a jpeg shot of the Excel page for the 328i. I'd appreciate any feedback on costs and calculations. You can unzip the Excel in the Financing forum (sorry about double post, but I'm sure some people won't open zipped files). Thanks in advance.

Quote:

Originally Posted by Str1d3r

Here you go.

Quote:

Originally Posted by Str1d3r

I'm actually asking for feedback on the pricing worksheet. The numbers, what to tax and what not to, etc. Do they look ok? Am I missing anything?

Dude, you still fail and here's why. You said that you were attaching a screenshot of some Excel pricing sheet you created, yet your second post has a zip file. You're totally right, I'm not opening a zip file (much less an Excel file, but a jpeg, sure) from a complete stranger.

Speaking in general, though, you should take your final pricing and add 10% to it, which will get you close to the final price, which includes TTL, MACO, etc. If you are fortunate enough to live in a state without sales tax, then this doesn't apply. Good luck.

smallseafishie · 03-12-2009, 01:11 PM

I did EuroDelivery on my 335i.

No regrets.

I knew i'd regret the 328i if I had gotten it.

DELTA BMW · 03-12-2009, 01:20 PM

FAIL!

STE92VE · 03-12-2009, 02:26 PM

Quote:

Originally Posted by Str1d3r

I just put together a price/payment calculator

This has been done already and you're taking credit for something that you asked about the other day....
http://www.e90post.com/forums/showpo...&postcount=445
....and was created by an administrator of this forum.
http://www.e90post.com/forums/showpo...90&postcount=1

I recommend immediate & permanent banishment....

DELTA BMW · 03-12-2009, 02:27 PM

Quote:

Originally Posted by STE92VE

This has been done already and you're taking credit for something that you asked about the other day....
http://www.e90post.com/forums/showpo...&postcount=445
....and was created by an administrator of this forum.
http://www.e90post.com/forums/showpo...90&postcount=1

I recommend immediate & permanent banishment....

adr1974 · 03-12-2009, 02:33 PM

One comment on the spreadsheet has to do with how you calulate the selected options (cells G5 and G6). The way you designed the spreadsheet, you have to zero out the price for the options you do not choose, which is fine, if you can remember all of the invoice prices. You should add a third colum next to the invoice column, and just put an 'X' in a cell next to an option you choose. Then in cells G5 and G6 you'd run a sumif. Just my $.02.

Str1d3r · 03-12-2009, 04:06 PM

Quote:

Originally Posted by STE92VE

This has been done already and you're taking credit for something that you asked about the other day....
http://www.e90post.com/forums/showpo...&postcount=445
....and was created by an administrator of this forum.
http://www.e90post.com/forums/showpo...90&postcount=1

I recommend immediate & permanent banishment....

Puhleez. Although he's right about the original source. My apology to the creator if offense taken. Just trying to use the information shared here to get into a BMW.

Str1d3r · 03-12-2009, 04:08 PM

Quote:

Originally Posted by adr1974

One comment on the spreadsheet has to do with how you calulate the selected options (cells G5 and G6). The way you designed the spreadsheet, you have to zero out the price for the options you do not choose, which is fine, if you can remember all of the invoice prices. You should add a third colum next to the invoice column, and just put an 'X' in a cell next to an option you choose. Then in cells G5 and G6 you'd run a sumif. Just my $.02.

Thanks. MACO and other fees like that are taxed?

methodtim · 03-12-2009, 04:16 PM

Quote:

Originally Posted by Str1d3r

Thanks. MACO and other fees like that are taxed?

They are added to the final sale price, which is taxed as a whole.

STE92VE · 03-12-2009, 06:18 PM

Quote:

Originally Posted by Str1d3r

Puhleez. Although he's right about the original source. My apology to the creator if offense taken. Just trying to use the information shared here to get into a BMW.

Glad you edited your original post....

03-12-2009, 06:41 AM	#1
Str1d3r New Member 0 Rep 11 Posts Drives: VW Join Date: Mar 2009 Location: USA iTrader: (0)	Feedback wanted on price calculator draft I just put together a price/payment calculator to help me make up my mind on getting a 328i v. 335i and ED v. USA delivery. Attached is a jpeg shot of the Excel page for the 328i. I'd appreciate any feedback on costs and calculations. You can unzip the Excel in the Financing forum (sorry about double post, but I'm sure some people won't open zipped files). Thanks in advance.
	Appreciate 0 Tweet Quote

03-12-2009, 06:47 AM	#2
methodtim Brigadier General 374 Rep 3,883 Posts Drives: Audi RS Q8 Join Date: Mar 2007 Location: Darkness there, and nothing more iTrader: (0) Garage List 2021 Audi RS Q8 [0.00] 2021 BMW X3 M40i [0.00] 2017 Toyota Tacoma [0.00]	No attachment. Post fail. __________________
	Appreciate 0 Quote

03-12-2009, 07:05 AM	#3
Zirenz2006 Brigadier General 1542 Rep 4,558 Posts Drives: G80 M3 Comp IOMG Join Date: Aug 2006 Location: US - NE iTrader: (0)	Have you driven a 328 and a 335? I would think if you had the decision would be very simple. I'd take a less optioned 335 vs a more optioned 328 if I wanted to stay within a certain budget.
	Appreciate 0 Quote

03-12-2009, 10:25 AM	#6
Hoothout Colonel 59 Rep 2,799 Posts Drives: 2008 BMW E92 328i Join Date: May 2008 Location: Brentwood, TN iTrader: (0) Garage List 2008 e92 328i [0.00]	i would do euro delivery on a 335 __________________ 2008 SG E92 328i iDrive,Premium Pkg,Sport Pkg,Cold Weather pkg,Black Dakota Leather,GP Thunder 8500k cornering,drl,and foglights, ,Blacked Out Grills,Painted Reflectors,Shadowline Emblems,Hardwired Beltronics V-995, AFE Intake, Muffler Delete, Berger tune
	Appreciate 0 Quote

03-12-2009, 10:27 AM	#7
krote345 Second Lieutenant 28 Rep 230 Posts Drives: '08 e90 328i Join Date: Feb 2008 Location: Northern NJ iTrader: (0) Garage List 2008 E90 [0.00]	I assume you are buying and not leasing correct? That was the deal breaker for me on the 335. The money factor is MUCH better on the 328i lease. __________________ Jet Black, 6MT, CW Pkg, PS, iPod, Style 189 Wheels
	Appreciate 0 Quote

03-12-2009, 10:31 AM	#9
mike-y just another bmw douche bag 195 Rep 3,640 Posts Drives: 1.9L of fury Join Date: Nov 2008 Location: Los Angeles, CA iTrader: (4)	it's $7,000 dollars between the two cars they way you have them configured. Is that worth it to you? We are not buying the car - you are, so you have to make that decision. you can lose a few options on the 335 to bring the difference down, but it all comes down to what price you feel comfortable with.
	Appreciate 0 Quote

03-12-2009, 01:11 PM	#12
smallseafishie Colonel 110 Rep 2,017 Posts Drives: AW 07 e92 335i + AW 11 X5 35d Join Date: Jun 2007 Location: Atlanta GA iTrader: (13) Garage List 2007 E92 335i [0.00]	I did EuroDelivery on my 335i. No regrets. I knew i'd regret the 328i if I had gotten it.
	Appreciate 0 Quote

03-12-2009, 01:20 PM	#13
DELTA BMW Banned 24 Rep 511 Posts Drives: BMW Join Date: Feb 2009 Location: Pluto iTrader: (0)	FAIL!
	Appreciate 0 Quote

03-12-2009, 02:33 PM	#16
adr1974 Lieutenant 128 Rep 415 Posts Drives: 2021 X5 xDrive 40i Join Date: Jun 2008 Location: Maryland iTrader: (0)	One comment on the spreadsheet has to do with how you calulate the selected options (cells G5 and G6). The way you designed the spreadsheet, you have to zero out the price for the options you do not choose, which is fine, if you can remember all of the invoice prices. You should add a third colum next to the invoice column, and just put an 'X' in a cell next to an option you choose. Then in cells G5 and G6 you'd run a sumif. Just my $.02.
	Appreciate 0 Quote