European Delivery Lease Calculator and my first BMW! - BMW 3-Series Forum (F30 / F32)

pelfbmw · 12-29-2012, 01:14 AM

Hi All,

I have been lurking here forever and have finally decided I want to go through with a European Delivery Lease of a 335i M-Sport with 15k miles/year & 39mo terms.

Can someone validate my methodology/calculations here? I am happy to make this spreadsheet available to anyone, but want to make sure it's correct before posting a link.

F30Alpine · 01-10-2013, 11:45 AM

dont think you should pay the .00030 MF mark up, its not a requirement

kobechrome · 01-10-2013, 12:21 PM

Looks good to me. Tax is high in CA.

pelfbmw · 01-10-2013, 12:24 PM

Quote:

Originally Posted by F30Alpine

dont think you should pay the .00030 MF mark up, its not a requirement

I thought it was an automatic requirement for ED. Thanks for clarifying.

buildbright · 01-10-2013, 12:30 PM

Quote:

Originally Posted by pelfbmw

I thought it was an automatic requirement for ED. Thanks for clarifying.

It is a requirement.

bmrm396 · 01-10-2013, 01:35 PM

i dunno that seems a little high, plug those numbers into bmwconfig.com and see what you come up with. i cant beleive youd have a $574/mo payment on an ED and max MSD's ... somethin seems wack, especially w a sale price of 43...

Although right off the bat im not sure about the 39mo/15k per yr residual or MF. So maybe thats why it looks high to me.

If you do the same deal w 36mo and dont even add MSDs w tax your payment is around $485 according to bmwconfig.

MF = .0016 Res = 62 and all your other figures the same. so like i said, i think sometings wrong

Park2670 · 01-10-2013, 02:34 PM

Thats a great worksheet. Good work!

marseille82 · 01-10-2013, 02:38 PM

Quote:

Originally Posted by pelfbmw

I thought it was an automatic requirement for ED. Thanks for clarifying.

It is a requirement for ED. That's how BMWFS pay for your 2nd payment while the car is in transit.

chrisv_335EBII · 01-10-2013, 03:49 PM

O.o
You calculated your depreciation incorrectly. It is not US MSPRP-RESIDUAL. It is Net Cap Cost - Residual.

Your base payment is actually $384.19

Grats! I just saved you a lot of money.

You calculations above does not include Act Fee, Registration, Title, Tags or Documentation Fee.

F30Alpine · 01-10-2013, 04:02 PM

Quote:

Originally Posted by buildbright

It is a requirement.

only a dealer will tell you its a requirement because they dont have any back end money on ED cars. The majority of meat in the deal on ED cars is whatever they mark up, in this case $500 and they managed to get more by bumping another .00030 MF.

chrisv_335EBII · 01-10-2013, 04:16 PM

Quote:

Originally Posted by F30Alpine

only a dealer will tell you its a requirement because they dont have any back end money on ED cars. The majority of meat in the deal on ED cars is whatever they mark up, in this case $500 and they managed to get more by bumping another .00030 MF.

The buyrate from BMW on ED cars is .00030 higher than on US cars. This is not from the dealership.

F30Alpine · 01-10-2013, 04:24 PM

Quote:

Originally Posted by chrisv_335EBII

The buyrate from BMW on ED cars is .00030 higher than on US cars. This is not from the dealership.

Ok im not going to argue over this, you must know this better than i do.

bmrm396 · 01-10-2013, 08:57 PM

yes and its the same for lease too

buildbright · 01-10-2013, 09:09 PM

Quote:

Originally Posted by F30Alpine

only a dealer will tell you its a requirement because they dont have any back end money on ED cars. The majority of meat in the deal on ED cars is whatever they mark up, in this case $500 and they managed to get more by bumping another .00030 MF.

This is through BMW financial. Has nothing to do with the dealer. It is bumped because BMW covers your second payment. Get financed through another financial institution you will not have to pay for it.

ssedha · 02-13-2013, 11:08 AM

A bump, but I couldn't yield the same Interest Portion of your payment using your same formula. According to your formula, it is (Cap Cost + Residual) * MF
In this case, (43895 + 32206) * .00111 = $84.47. Am I missing something?

E92Carrera · 02-16-2013, 03:27 PM

Quote:

Originally Posted by ssedha

A bump, but I couldn't yield the same Interest Portion of your payment using your same formula. According to your formula, it is (Cap Cost + Residual) * MF
In this case, (43895 + 32206) * .00111 = $84.47. Am I missing something?

You're correct, OP's is mis-calculated.

And chrisv_335EBII got the correct monthly payment. So if the OP sees this, just saved a lot of money lol

12-29-2012, 01:14 AM	#1
pelfbmw Registered Drives: None Join Date: Apr 2011 Location: Bay Area, CA Posts: 4 iTrader: (0)	European Delivery Lease Calculator and my first BMW! Hi All, I have been lurking here forever and have finally decided I want to go through with a European Delivery Lease of a 335i M-Sport with 15k miles/year & 39mo terms. Can someone validate my methodology/calculations here? I am happy to make this spreadsheet available to anyone, but want to make sure it's correct before posting a link. Last edited by pelfbmw; 12-29-2012 at 02:20 AM.
	Tweet

01-10-2013, 11:45 AM	#2
F30Alpine Yes, I have the BMW Programs Drives: Alpine3 Join Date: Dec 2012 Location: United States Posts: 67 iTrader: (0)	dont think you should pay the .00030 MF mark up, its not a requirement __________________ E82 Blue Water/Oyster RIP thanks 2 sandy F30 Alpine/Venetian Motorstorm Apocalypse PS3 3D Game SEALED NEW!

01-10-2013, 12:21 PM	#3
kobechrome Captain Drives: 2013 F30 335xi Join Date: Dec 2005 Location: Ashburn, VA Posts: 697 iTrader: (0) Garage List 2013 BMW 335xi Sport [0.00] 2013 Lexus RX 350 [0.00] 2006 BMW 325i [0.00]	Looks good to me. Tax is high in CA. __________________

01-10-2013, 01:35 PM	#6
bmrm396 Major Drives: '08 335i Sedan 6MT Join Date: Sep 2008 Location: sD, CA Posts: 1,144 iTrader: (2)	i dunno that seems a little high, plug those numbers into bmwconfig.com and see what you come up with. i cant beleive youd have a $574/mo payment on an ED and max MSD's ... somethin seems wack, especially w a sale price of 43... Although right off the bat im not sure about the 39mo/15k per yr residual or MF. So maybe thats why it looks high to me. If you do the same deal w 36mo and dont even add MSDs w tax your payment is around $485 according to bmwconfig. MF = .0016 Res = 62 and all your other figures the same. so like i said, i think sometings wrong __________________ Formerly addicted to e46fanatics Last edited by bmrm396; 01-10-2013 at 01:41 PM.

01-10-2013, 02:34 PM	#7
Park2670 Lieutenant General Drives: 2011 335d Join Date: Jan 2006 Location: UTAH Posts: 17,950 iTrader: (5)	Thats a great worksheet. Good work! __________________ Utah Chat Thread 2011 335d ///M-Sport

01-10-2013, 03:49 PM	#9
chrisv_335EBII Private First Class Drives: 335i 6sp EBII Join Date: Oct 2012 Location: Maryland Posts: 191 iTrader: (0)	O.o You calculated your depreciation incorrectly. It is not US MSPRP-RESIDUAL. It is Net Cap Cost - Residual. Your base payment is actually $384.19 Grats! I just saved you a lot of money. You calculations above does not include Act Fee, Registration, Title, Tags or Documentation Fee.

01-10-2013, 08:57 PM	#13
bmrm396 Major Drives: '08 335i Sedan 6MT Join Date: Sep 2008 Location: sD, CA Posts: 1,144 iTrader: (2)	yes and its the same for lease too __________________ Formerly addicted to e46fanatics

02-13-2013, 11:08 AM	#15
ssedha Private First Class Drives: 11' 135i Join Date: May 2011 Location: Ohio Posts: 181 iTrader: (0)	A bump, but I couldn't yield the same Interest Portion of your payment using your same formula. According to your formula, it is (Cap Cost + Residual) * MF In this case, (43895 + 32206) * .00111 = $84.47. Am I missing something?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search