Lease Calculator Available

DavE90 · 01-04-2006, 09:48 AM

I have an excell lease calculation formula if anybody is interested....

abc · 01-04-2006, 04:22 PM

i would be, but would i know how to use it?

wolke9 · 01-06-2006, 11:54 AM

Quote:

Originally Posted by DavE90

I have an excell lease calculation formula if anybody is interested....

I'm interested. . .can you post a link or send it?

schuyler · 01-06-2006, 12:08 PM

DavE90 can you please share with us? You can just attach the excel file to your reply. Thanks.

DavE90 · 01-06-2006, 06:38 PM

I just sent it to Jason. He'll post it.

BuckStop · 01-07-2006, 11:09 AM

Here's another one that I've found very easy to use. Just remember to put the decimal point in the right place when inputting money factor.

http://www.leaseguide.com/calc.htm

SteveMD · 01-07-2006, 12:23 PM

Quote:

Originally Posted by BuckStop

Here's another one that I've found very easy to use. Just remember to put the decimal point in the right place when inputting money factor.

http://www.leaseguide.com/calc.htm

Yup that's nice and easy.

Jason · 01-08-2006, 09:15 AM

Quote:

Originally Posted by DavE90

I just sent it to Jason. He'll post it.

Here's DavE90's lease calculator (excel)

E90 Lease Calculator Here

wolke9 · 01-08-2006, 07:36 PM

Quote:

Originally Posted by Jason

Here's DavE90's lease calculator (excel)

E90 Lease Calculator Here

DavE90,

Thanks for the calculator. Did you lease your vehicle using this calculator and how accurate was it??

DavE90 · 01-08-2006, 10:39 PM

The only number difficult to get is the bank acquisition fee, but I know is around $600, using those numbers my formula was right on the money within a few dollars !!!

DoubleL · 02-19-2006, 08:55 AM

Hi DavE90,

Thanks for the excel file, it has finally helped me understand the leasing formulas. As an accountant I am constantly using excel for everything so I took the liberty to modify your file to help me even further. I don't know how to post file links but here is a picture of my handywork. Can you please check it over and make sure it is correct. I live in PA and we have a 9% lease tax rate. I also found the posted MF, residual numbers for February on this site. This site has helped me enormously already.

My setup is ...

2006 330xi
Jet Black
Premium
Automatic
Sport
Heated Front Seats
Satellite Radio Prep
Destination ($695)

MSRP = $44,145
Invoice = 40,465

Figures from Edmunds.com and include dest fee.

The dealership I visited is Daniels BMW in Allentown PA. What a great looking new dealership building they have. The service are is huge and immaculate and the number of used and new cars on the lot was more than I expected. Anyway I think I am getting a littled ripped off on the MF and I am trying to negotiate another $1,000 off the cap cost. Here's the file snapshot ...

Edit made for fletcher969 post below. Thanks man accountants are well known for mistakes !

fletcher969 · 02-19-2006, 10:37 AM

DoubleL...correct me if I'm wrong (and I'm no accountant), but when you figure the value of line 1c (Estimated Dealer Cost), shouldn't you also add the Destination Charge since the dealership is charged the destination for shipping, etc., and said cost is simply passed along to the consumer? I realize for lease calculation the Destination Charge isn't added to the MSRP figure, but isn't it when estimating the dealer's costs?

SignHere · 04-25-2006, 02:43 PM

FYI, the lease and balloon (Owner's Choice) calculators on the BMW USA website are accurate to the penny.

BMW LEASE CALCUALTOR

And it is easy to use as well, just remember that the tt&l is not included. To figure a lease with zero down, just plan on putting the First Payment, Refundable Security Deposit and tt&l down in cash. Or add all that to the selling price and walk in sign here (

)and make your 2nd payment 30 days later.

TENCHI · 05-14-2006, 11:01 AM

I just wanted to say thanks to Dave90 and others who were so kind enough to give us these lease calculators and the ability to negotiate our deals.

I just bought a 2006 330i with ZSP, ZPP, ZCP Step for $545 a month. $1400 out of pocket. Because of the calculators I was able to manipulate the numbers so I could get to the payment I wanted and essentially bought the car for $400 over invoice.

thanks again guys!

01-04-2006, 09:48 AM	#1
DavE90 Bimmer Fan & S FL Realtor 22 Rep 129 Posts Drives: 2006 330i Join Date: Jan 2006 Location: Miami, FL iTrader: (0)	Lease Calculator Available I have an excell lease calculation formula if anybody is interested.... __________________ Miami Homes E90 330i Jet Black, Terra Leather, Comfort Access, Premium and Sport Packages
	Appreciate 0 Tweet Quote

01-04-2006, 04:22 PM	#2
abc Captain 27 Rep 772 Posts Drives: 325 Join Date: May 2005 Location: NYC iTrader: (0)	i would be, but would i know how to use it?
	Appreciate 0 Quote

01-06-2006, 12:08 PM	#4
schuyler Enlisted Member 21 Rep 36 Posts Drives: 323i Join Date: Mar 2005 Location: Miami iTrader: (0)	DavE90 can you please share with us? You can just attach the excel file to your reply. Thanks. __________________ - Soon to be 325i -
	Appreciate 0 Quote

01-06-2006, 06:38 PM	#5
DavE90 Bimmer Fan & S FL Realtor 22 Rep 129 Posts Drives: 2006 330i Join Date: Jan 2006 Location: Miami, FL iTrader: (0)	I just sent it to Jason. He'll post it. __________________ Miami Homes E90 330i Jet Black, Terra Leather, Comfort Access, Premium and Sport Packages
	Appreciate 0 Quote

01-07-2006, 11:09 AM	#6
BuckStop New Member 0 Rep 5 Posts Drives: E90 330i Join Date: Dec 2005 Location: Los Gatos, California iTrader: (0)	Here's another one that I've found very easy to use. Just remember to put the decimal point in the right place when inputting money factor. http://www.leaseguide.com/calc.htm
	Appreciate 0 Quote

01-08-2006, 10:39 PM	#10
DavE90 Bimmer Fan & S FL Realtor 22 Rep 129 Posts Drives: 2006 330i Join Date: Jan 2006 Location: Miami, FL iTrader: (0)	The only number difficult to get is the bank acquisition fee, but I know is around $600, using those numbers my formula was right on the money within a few dollars !!! __________________ Miami Homes E90 330i Jet Black, Terra Leather, Comfort Access, Premium and Sport Packages
	Appreciate 0 Quote

02-19-2006, 08:55 AM	#11
DoubleL Enlisted Member 0 Rep 41 Posts Drives: 2006 330xi Join Date: Feb 2006 Location: Kempton PA iTrader: (0)	Hi DavE90, Thanks for the excel file, it has finally helped me understand the leasing formulas. As an accountant I am constantly using excel for everything so I took the liberty to modify your file to help me even further. I don't know how to post file links but here is a picture of my handywork. Can you please check it over and make sure it is correct. I live in PA and we have a 9% lease tax rate. I also found the posted MF, residual numbers for February on this site. This site has helped me enormously already. My setup is ... 2006 330xi Jet Black Premium Automatic Sport Heated Front Seats Satellite Radio Prep Destination ($695) MSRP = $44,145 Invoice = 40,465 Figures from Edmunds.com and include dest fee. The dealership I visited is Daniels BMW in Allentown PA. What a great looking new dealership building they have. The service are is huge and immaculate and the number of used and new cars on the lot was more than I expected. Anyway I think I am getting a littled ripped off on the MF and I am trying to negotiate another $1,000 off the cap cost. Here's the file snapshot ... Edit made for fletcher969 post below. Thanks man accountants are well known for mistakes ! Last edited by DoubleL; 02-19-2006 at 10:58 AM..
	Appreciate 0 Quote

02-19-2006, 10:37 AM	#12
fletcher969 Dad: "Can't never did nothing" 8 Rep 319 Posts Drives: '96 Camaro Join Date: Nov 2005 Location: Chicago, IL iTrader: (0)	DoubleL...correct me if I'm wrong (and I'm no accountant), but when you figure the value of line 1c (Estimated Dealer Cost), shouldn't you also add the Destination Charge since the dealership is charged the destination for shipping, etc., and said cost is simply passed along to the consumer? I realize for lease calculation the Destination Charge isn't added to the MSRP figure, but isn't it when estimating the dealer's costs? __________________ 2006 330i: SG/Blk-Blk-Burl/6MT/ZSP/Heated seats/Sat prep 01-26-2006: Ordered Vehicle 02-01-2006: Production Start 02-06-2006: Production End 02-09-2006: Arrived at POExit 02-13-2006: Transit - Don Juan 03-01-2006: Unloaded in Charleston 03-02-2006: VPC 03-06-2006: Arrived at dealership 03-08-2006: Took delivery
	Appreciate 0 Quote

04-25-2006, 02:43 PM	#13
SignHere Supreme Omnipotent Bobohead 2 Rep 30 Posts Drives: Different BMW's every day! Join Date: Apr 2006 Location: Austin TX iTrader: (0)	FYI, the lease and balloon (Owner's Choice) calculators on the BMW USA website are accurate to the penny. BMW LEASE CALCUALTOR And it is easy to use as well, just remember that the tt&l is not included. To figure a lease with zero down, just plan on putting the First Payment, Refundable Security Deposit and tt&l down in cash. Or add all that to the selling price and walk in sign here ( )and make your 2nd payment 30 days later. __________________ Currently seeking time off for good behavior.
	Appreciate 0 Quote

05-14-2006, 11:01 AM	#14
TENCHI Lieutenant 53 Rep 552 Posts Drives: '19 G12, '17 E300 Join Date: Feb 2006 Location: Seattle iTrader: (0)	I just wanted to say thanks to Dave90 and others who were so kind enough to give us these lease calculators and the ability to negotiate our deals. I just bought a 2006 330i with ZSP, ZPP, ZCP Step for $545 a month. $1400 out of pocket. Because of the calculators I was able to manipulate the numbers so I could get to the payment I wanted and essentially bought the car for $400 over invoice. thanks again guys! __________________
	Appreciate 0 Quote