Need some help with a lease offer

tyler9595 · 02-22-2010, 11:14 AM

I'm trying to do a deal with a dealer and I am HOPING someone here can check my numbers.

I am trying to calculate the 36mo lease, 15k mi/yr. e90 335i; BSM paint; ZSP; ZPP; ZCW; Nav; 6FL; HD radio; Sirius; Rear shades; step trans;heated steering wheel (?)

Please see pdf of my spreadsheet in the next post. Please let me know if my calc of depreciation and interest, etc. is right.

tyler9595 · 02-22-2010, 11:19 AM

Here's my spreadsheet...

2010 335i lease.pdf

kgb1637 · 02-22-2010, 12:12 PM

Your numbers are spot on based on 7% sales tax and no down payment. Doesn't sound too bad to me but $1,500.00 over invoice is a little much, try to get it to $500.00 to $1,000.00 over for a better deal

Dmitriy@AUTOcouture · 02-22-2010, 01:01 PM

Everything looks pretty much accurate for the exception of the following:

1. MACO (Training Fee + Advertising Fee) = $480, not $180.
2. Confirm with the dealer that this is a car that has the pre January pricing... If it isn't then bump up the Delivery fee by $50 to $875, the MSRP to $40,600, and the Invoice to $37,350

tyler9595 · 02-22-2010, 01:48 PM

Thanks a ton kgb and Dmitriy! I wanted to make sure my numbers weren't bogus...I'm going to talk to the CA this afternoon and I want to be prepared.

CA told me he wouldnt do the deal using the "buy rate" but he would work with me. I hope my base rate is close. I couldnt find the buy rate for Feb...so .00200 was a total guess on my part. Thoughts?

kgb1637 · 02-22-2010, 02:17 PM

I am unsure of the current rates which will be up to your CA to communicate to you. You obviously have the understanding of what you need to calculate the lease so when you talk to your CA, make sure he gives you the residual, the price used to calculate the residual, MF, and the Cap cost. Good luck!

Dmitriy@AUTOcouture · 02-22-2010, 02:43 PM

Quote:

Originally Posted by tyler9595

Thanks a ton kgb and Dmitriy! I wanted to make sure my numbers weren't bogus...I'm going to talk to the CA this afternoon and I want to be prepared.

CA told me he wouldnt do the deal using the "buy rate" but he would work with me. I hope my base rate is close. I couldnt find the buy rate for Feb...so .00200 was a total guess on my part. Thoughts?

The MF is .00180. After you come back from the dealer, PM or email me his offer. I'll beat it

tyler9595 · 02-27-2010, 04:56 AM

Thanks again for your help.

I picked up the car yesterday. See sig for details. I worked the PPK and PE into the lease...hopefully that will be installed this coming week. I'll try to post up some pics when the weather clears here...

DefBringer · 02-27-2010, 03:44 PM

Quote:

Originally Posted by tyler9595

Thanks again for your help.

I picked up the car yesterday. See sig for details. I worked the PPK and PE into the lease...hopefully that will be installed this coming week. I'll try to post up some pics when the weather clears here...

Tyler, could you let us know what you ended up paying per month for the car in your PDF? Were you far off your estimates?

tyler9595 · 02-27-2010, 10:21 PM

My numbers were very close except I didnt account for the lease acquisition fee.

Ctsou · 03-04-2010, 09:57 PM

Hi Tyler, could you explain how you came up with the residual amount, depreciation and interest calculations? I'm trying to copy your spreadsheet to figure out my lease too but I'm new to this. Thanks!

02-22-2010, 11:14 AM	#1
tyler9595 Captain 48 Rep 723 Posts Drives: Boring Join Date: Nov 2006 Location: Indianapolis, IN iTrader: (1)	Need some help with a lease offer I'm trying to do a deal with a dealer and I am HOPING someone here can check my numbers. I am trying to calculate the 36mo lease, 15k mi/yr. e90 335i; BSM paint; ZSP; ZPP; ZCW; Nav; 6FL; HD radio; Sirius; Rear shades; step trans;heated steering wheel (?) Please see pdf of my spreadsheet in the next post. Please let me know if my calc of depreciation and interest, etc. is right. Last edited by tyler9595; 02-22-2010 at 11:47 AM..
	Appreciate 0 Tweet Quote

02-22-2010, 11:19 AM	#2
tyler9595 Captain 48 Rep 723 Posts Drives: Boring Join Date: Nov 2006 Location: Indianapolis, IN iTrader: (1)	Here's my spreadsheet... 2010 335i lease.pdf Last edited by tyler9595; 02-22-2010 at 11:47 AM..
	Appreciate 0 Quote

02-22-2010, 12:12 PM	#3
kgb1637 Lieutenant Colonel 21 Rep 1,519 Posts Drives: RS5 Join Date: Sep 2008 Location: Baltimore, MD iTrader: (0)	Your numbers are spot on based on 7% sales tax and no down payment. Doesn't sound too bad to me but $1,500.00 over invoice is a little much, try to get it to $500.00 to $1,000.00 over for a better deal __________________ Retired - '08 E90 335i Sparkling Graphite/Gray Dakota Leather, ZSP, ZCW, ZPP, Navi, ipod, Sat
	Appreciate 0 Quote

02-22-2010, 01:01 PM	#4
Dmitriy@AUTOcouture Major 219 Rep 1,133 Posts Drives: carefully Join Date: Dec 2006 Location: NYC iTrader: (3)	Everything looks pretty much accurate for the exception of the following: 1. MACO (Training Fee + Advertising Fee) = $480, not $180. 2. Confirm with the dealer that this is a car that has the pre January pricing... If it isn't then bump up the Delivery fee by $50 to $875, the MSRP to $40,600, and the Invoice to $37,350
	Appreciate 0 Quote

02-22-2010, 01:48 PM	#5
tyler9595 Captain 48 Rep 723 Posts Drives: Boring Join Date: Nov 2006 Location: Indianapolis, IN iTrader: (1)	Thanks a ton kgb and Dmitriy! I wanted to make sure my numbers weren't bogus...I'm going to talk to the CA this afternoon and I want to be prepared. CA told me he wouldnt do the deal using the "buy rate" but he would work with me. I hope my base rate is close. I couldnt find the buy rate for Feb...so .00200 was a total guess on my part. Thoughts?
	Appreciate 0 Quote

02-22-2010, 02:17 PM	#6
kgb1637 Lieutenant Colonel 21 Rep 1,519 Posts Drives: RS5 Join Date: Sep 2008 Location: Baltimore, MD iTrader: (0)	I am unsure of the current rates which will be up to your CA to communicate to you. You obviously have the understanding of what you need to calculate the lease so when you talk to your CA, make sure he gives you the residual, the price used to calculate the residual, MF, and the Cap cost. Good luck! __________________ Retired - '08 E90 335i Sparkling Graphite/Gray Dakota Leather, ZSP, ZCW, ZPP, Navi, ipod, Sat
	Appreciate 0 Quote

02-27-2010, 04:56 AM	#8
tyler9595 Captain 48 Rep 723 Posts Drives: Boring Join Date: Nov 2006 Location: Indianapolis, IN iTrader: (1)	Thanks again for your help. I picked up the car yesterday. See sig for details. I worked the PPK and PE into the lease...hopefully that will be installed this coming week. I'll try to post up some pics when the weather clears here... __________________ Previous - 2015 M4 - ZEC, M DCT, ZLP, Adaptive M Suspension, HK Audio Previous - 2015 X3 xDrive35i - BSM, ZPP, ZCW, Nav, HK Audio Previous - 2013 135is (N55) - Carbon Black, ZPP, ZTP, DCT, HK audio, heated seats Previous - 2010 e90 335i (N54) - BSM, 6AT, ZSP, ZPP, ZCW, Hi-Fi, Nav, BMW PPK & PE, Dinan S2 Previous - 2007 e90 335i (N54) - BSM, 6AT, ZSP, ZPP, ZCW, Hi-Fi Last edited by tyler9595; 02-27-2010 at 04:57 AM.. Reason: typo
	Appreciate 0 Quote

02-27-2010, 10:21 PM	#10
tyler9595 Captain 48 Rep 723 Posts Drives: Boring Join Date: Nov 2006 Location: Indianapolis, IN iTrader: (1)	My numbers were very close except I didnt account for the lease acquisition fee. __________________ Previous - 2015 M4 - ZEC, M DCT, ZLP, Adaptive M Suspension, HK Audio Previous - 2015 X3 xDrive35i - BSM, ZPP, ZCW, Nav, HK Audio Previous - 2013 135is (N55) - Carbon Black, ZPP, ZTP, DCT, HK audio, heated seats Previous - 2010 e90 335i (N54) - BSM, 6AT, ZSP, ZPP, ZCW, Hi-Fi, Nav, BMW PPK & PE, Dinan S2 Previous - 2007 e90 335i (N54) - BSM, 6AT, ZSP, ZPP, ZCW, Hi-Fi
	Appreciate 0 Quote

03-04-2010, 09:57 PM	#11
Ctsou New Member 4 Rep 19 Posts Drives: 2007 BMW 335i Join Date: Jan 2010 Location: Irvine, CA iTrader: (0)	Hi Tyler, could you explain how you came up with the residual amount, depreciation and interest calculations? I'm trying to copy your spreadsheet to figure out my lease too but I'm new to this. Thanks!
	Appreciate 0 Quote