Welcome to Bimmerfest -- The #1 Online Community for BMW related information! Please enjoy the discussion forums below and share your experiences with the 200,000 current, new and past BMW owners. The forums are broken out by car model and into other special interest sections such as BMW European Delivery and a special forum to voice your questions to the many BMW dealers on the site to assist our members!

Please follow the links below to help get you started!

Go Back   Bimmerfest - BMW Forums > The Best of Bimmerfest! > Ask-A-Dealer

Ask-A-Dealer
Talk to our team of BMW Client Advisors. Get all of your buying/financing/leasing questions answered here!

Reply
 
Thread Tools Display Modes
  #51  
Old 07-12-2006, 03:27 PM
knmol knmol is offline
Registered User
Location: Twin Cities, MN
 
Join Date: Jul 2006
Posts: 14
Mein Auto: Soon to be X3
Lease Payment Calc for European Delivery

Here's another variation on an Excel spreadsheet to help calculate the lease payment. Would love feedback if anyone has questions or sees any errors, etc. This one is based on ED, though you can use it for US if you zero out the .0003 markup on the MF and use the proper invoice numbers.

It's named as a pdf file since I can't upload Excel - just save it and rename it as an .xls file before you open it and it should work.
Attached Files
File Type: pdf bmwEDcalcs.pdf (33.0 KB, 1028 views)
Reply With Quote
  #52  
Old 07-17-2006, 11:40 AM
wco81 wco81 is offline
Registered User
Location: SF Bay Area
 
Join Date: Sep 2005
Posts: 48
Mein Auto: Acura
The ED spreadsheet has some potential.

But I'm confused by some of the values already in there, like the base ED invoice price. Is that suppose to reflect the actual price or just some sample numbers?

Likewise, the prices for the options seem to be off. Like Premium Package would be $2000 or $2640, depending on whether it's a 330i or a 325i.

Also, not all options are listed. Didn't see Comfort Access or the Rear Power Shade.

One thing which might be nice is to be able to enter a sales tax rate and have it calculate that within the monthly payment and the driveoff costs.
Reply With Quote
  #53  
Old 07-17-2006, 06:32 PM
knmol knmol is offline
Registered User
Location: Twin Cities, MN
 
Join Date: Jul 2006
Posts: 14
Mein Auto: Soon to be X3
The values already entered, as it says in the notes in the upper right corner, were for a 2006 X3.

I have now updated the sheet so that it's easier to enter your specific options and their prices (which can be found elsewhere in Bimmerfest, usually a sticky in the section for your model). I wanted to set up the sales tax as a calculation, but there are two problems - one is that different states tax differently (some on entire cap cost, others on payments, etc.) and the other is that I wasn't able to figure out what our tax (MN) was based on (I forgot to ask when we went back to the dealer - hopefully that wasn't a place where they would mess around and hide profit for the dealer!)

I've attached the updated sheet. It would be nice if there was a listing of how each state calculates tax, so people could easily enter their taxes into this sheet.

Thanks for your comments/suggestions. Let me know if there is anything else that could be improved.

BTW, my husband and I used this on our laptop as we sat in the sales manager's office making our final deal on Saturday (yay! ) - it was really helpful to be able to run numbers ourselves right there in the office and clearly see what kind of deal we were negotiating. We pick up our X3 in Munich on August 18th!
Attached Files
File Type: pdf bmwEDcalcs.pdf (33.5 KB, 698 views)
Reply With Quote
  #54  
Old 07-25-2006, 12:53 PM
Greg220's Avatar
Greg220 Greg220 is offline
---------
Location: WA
 
Join Date: Mar 2005
Posts: 449
Mein Auto: E90
This is the best ED lease calculation tool I have seen so far, thank you for sharing it!

I have only two questions:

- what exactly does cell A39 mean ["Difference in MF - $ amt over 24 mos (if used .00007 multiplier)] and why is it a negative number if dealer's MF markup is 0?

- cell D20 ("Total Paid at Signing") includes the 1st lease payment (D19). However cell D8 says "Total of Lease Pmts (not incl. 1st pmt, nor 2nd that BMW pays)". So, if BMW pays the 1st and 2nd payments, why is it included in D19 and D20?

Last edited by Greg220; 07-25-2006 at 11:36 PM.
Reply With Quote
  #55  
Old 07-27-2006, 02:56 PM
EvilM3 EvilM3 is offline
Officially Welcomed to the 'Fest
Location: Long Island, NY
 
Join Date: Jul 2002
Posts: 28
Mein Auto: 2002 BMW M3 Topaz/Grey
Quote:
Originally Posted by turpiwa
How accurate is the lease calculator posted here - the numbers I'm getting back rom the dealer is significantly different than being plugged into the tool - no offense to the great work done - just if someone who has the knowledge to do a manual comparison it would be great.
Wait - the posting below must be the issue.

I am getting different numbers aswell. The dealer is always higher. I've checked the car against ordering guide and I am getting the Z4 3.0si at invoice with prem, sport, HSeats, Xenon, and Nav. I am rolling the taxes and fees into the monthly payments and the dealer is quoting me $566 a month while the calculator is showing $538.
Reply With Quote
  #56  
Old 07-30-2006, 02:56 PM
knmol knmol is offline
Registered User
Location: Twin Cities, MN
 
Join Date: Jul 2006
Posts: 14
Mein Auto: Soon to be X3
Quote:
Originally Posted by Greg220
This is the best ED lease calculation tool I have seen so far, thank you for sharing it!

I have only two questions:

- what exactly does cell A39 mean ["Difference in MF - $ amt over 24 mos (if used .00007 multiplier)] and why is it a negative number if dealer's MF markup is 0?

- cell D20 ("Total Paid at Signing") includes the 1st lease payment (D19). However cell D8 says "Total of Lease Pmts (not incl. 1st pmt, nor 2nd that BMW pays)". So, if BMW pays the 1st and 2nd payments, why is it included in D19 and D20?
Glad you are finding it helpful!

Re: A39 - that was a cell I had added because our dealer insisted that we only get .00005 per extra deposit, rather than .00007, so in our calcs we were looking at the money we would lose by getting only .00005 off instead of .00007 as dealer profit. (Basically, with 7 MSD's and nothing for dealer profit, we were getting an MF of .00176, so I took the difference between that and what the dealer was offering to figure out dealer profit.) I have updated the sheet by removing that cell and inserting cell A38 to show the $ profit resulting from the dealer markup of MF (just nominal $ over the length of the lease). Let me know if that helps and/or makes sense to do it that way.

Re: D20 - Looks like my wording was confusing. For D7, I meant that it did not include the first payment that you paid at signing, nor the second payment that you will not pay at all b/c BMW pays it. The first payment is included in D8 so I wanted to be clear I had not included it in D7 and therefore double counted it. And the second payment is not included in either one since you don't pay it at all. I updated the sheet to slightly change the wording in D7. Hope that helps!

I'll try to keep checking in here to see if there are any other issues.

To turpiwa and EvilM3 - not sure if you are refering to my spreadsheet, but if you are --
I recommend taking the spreadsheet with you on a laptop and getting the dealer to account for every single number that goes into it. That is what I did, and how I got this spreadsheet to where it is - when I was done going over each number with the finance person, she and I had exactly the same numbers input and were getting the exact same numbers on the back end. (She was using the BMWFS system, so it should be the same everywhere.) Also double check how taxes are handled - I did this lease in Minnesota, which requires the dealer to pay the taxes up front, though many people spread it out in the payments (we chose to pay it up front). Assuming you know how taxes are handled by your dealer, and you have the right calculation for taxes, everything else in this spreadsheet should give you the same numbers the dealer has, assuming they are telling you everything.
Attached Files
File Type: pdf bmwEDcalcs_as_of_07-30-06.pdf (33.0 KB, 783 views)
Reply With Quote
  #57  
Old 07-30-2006, 08:08 PM
EvilM3 EvilM3 is offline
Officially Welcomed to the 'Fest
Location: Long Island, NY
 
Join Date: Jul 2002
Posts: 28
Mein Auto: 2002 BMW M3 Topaz/Grey
Quote:
Originally Posted by knmol


To turpiwa and EvilM3 - not sure if you are refering to my spreadsheet, but if you are --
I recommend taking the spreadsheet with you on a laptop and getting the dealer to account for every single number that goes into it. That is what I did, and how I got this spreadsheet to where it is - when I was done going over each number with the finance person, she and I had exactly the same numbers input and were getting the exact same numbers on the back end. (She was using the BMWFS system, so it should be the same everywhere.) Also double check how taxes are handled - I did this lease in Minnesota, which requires the dealer to pay the taxes up front, though many people spread it out in the payments (we chose to pay it up front). Assuming you know how taxes are handled by your dealer, and you have the right calculation for taxes, everything else in this spreadsheet should give you the same numbers the dealer has, assuming they are telling you everything.
I was actually referring the to spreadsheet that was posted before yours but I will give yours a try. THanks.
Reply With Quote
  #58  
Old 07-31-2006, 08:02 PM
Greg220's Avatar
Greg220 Greg220 is offline
---------
Location: WA
 
Join Date: Mar 2005
Posts: 449
Mein Auto: E90
Quote:
Originally Posted by knmol
Re: A39 - that was a cell I had added because our dealer insisted that we only get .00005 per extra deposit (...)
Thank you for the clarification! It's very helpful and answers all my questions!
Reply With Quote
  #59  
Old 09-02-2006, 03:30 PM
SwampDaddy SwampDaddy is offline
Officially Welcomed to the 'Fest
Location: Houston, TX
 
Join Date: Jun 2006
Posts: 294
Mein Auto: 2011 335is (for sale)
Hey, thanks for sharing such a tool and for putting so much work into it.

Okay, I have a problem, I tried to change the "Amt Over ED Invoice" cell A16 (before noticing the directions) and got an error (#NAME?).

Have you documented all of the rules and calculations that this document is suppose to perform? I would like to better understand it.

BTW: can you upload this document as a zip archive?

Thanks,

Robert
Reply With Quote
  #60  
Old 09-03-2006, 02:31 AM
SwampDaddy SwampDaddy is offline
Officially Welcomed to the 'Fest
Location: Houston, TX
 
Join Date: Jun 2006
Posts: 294
Mein Auto: 2011 335is (for sale)
Smile HELP! I need help with lease calculations!!!

I'm trying to get a good handle on a previous Texas-based lease deal so that I can apply that knowledge to a 335 (ED) deal that I will negotiate this month.

The previous deal (X3) has the following numbers from the lease agreement that I'd like to be able to plug into a spreadsheet or be able to compute via pencil and paper. Yet, my efforts so far do not yield the same numbers that the BMW dealer generated originally or the corrected numbers that BMWFS provided.

Please show me how to calculate such a lease--THANKS!

---------------------------------------
Trade Val. 6000.00
Due at Signing 8500.00
Monthly Payment 447.11 (Later changed to 437.38 via BMWFS).
Cont. Tot. Pmts. 17,457.25 (Later changed to 17,057.82 via BMWFS).
Disposition Fee 350.00
Cont. Total Pmts 23340.18 (total of all payments at lease end...)

Cap. Cost Red. 5370.84
Sec. Deposit 2500.00
Title Fees 34.00
License Fees 98.05
Doc. Fee 50.00

Gross Cap Cost. 43,482.13 (39,842 (Agreed Val.) + Other stuff)
Adj. Cap. Cost 38,111.29
Residual Val. 26,744.25 (should be 65%)
Depreciation, etc. 11,367.04
Rent Charge 6070.25 (Later changed to 5,690.78 via BMWFS).
Tot. Base M. Pmts. 17,437.29
Lease Term 39 Months

Agreed Value 39,842.00
Sales Tax 2115.13 (Remember this is TEXAS--So calc. accordingly)
MBP Contract 700.00 (Mechanical Breakdown Protection, err wheel thingy)
Aquisition Fee 825.00
Total 43,482.13
---------------------------------------

BTW: the MF should be .0024 or .0028.

I will attempt to attach my current Excel SS efforts... Please change the file ending from ".pdf" to ".zip".

Anyway, Many thanks!!!

Robert
Attached Files
File Type: pdf Lease_WS_RJB.pdf (10.3 KB, 521 views)
Reply With Quote
  #61  
Old 09-10-2006, 12:31 PM
jd101 jd101 is offline
Officially Welcomed to the 'Fest
Location: Bay Area
 
Join Date: Aug 2006
Posts: 106
Mein Auto: 2010 535xiT; '97 A4
Quote:
Originally Posted by knmol View Post

I've attached the updated sheet. It would be nice if there was a listing of how each state calculates tax, so people could easily enter their taxes into this sheet.
This is a really helpful spreadsheet and I'm using it to figure out my lease for an ED 2007 X3.

One question: How should I determine the "State Taxes" amount for California (cell D19 in your spreadsheet)? Is it simply the tax rate times the Total Monthly Lease Payment times the number of months? I don't think the entire tax payment is due at the time of signing in California. So, should I zero out the number in D19 and simply add the monthly tax to the monthly lease payment?
Reply With Quote
  #62  
Old 09-10-2006, 07:01 PM
simpsmk simpsmk is offline
335i ED 12/18/07
Location: Louisiana
 
Join Date: Sep 2006
Posts: 44
Mein Auto: R1200C
knmol - I have attempted to download the BMW EDcalcs file and am having some difficulty opening it. I am using Adobe Acrobat Reader ver 7.0 and am getting an error message that say's it is either an unsupported file format or the file is corrupted - it suggested it could be related to the file having been an attachment in an email and not decoded properly. Do you have any suggestions on how I could resolve the problem? I will be ordering a Euro Delivery 335i tomorrow and would really love to have your worksheet to run through the lease / finance numbers.

Also, does anyone have the latest Euro Delivery Dealer Invoice numbers for the 335i? The latest I've seen were from July and I understand they have since been revised.

Thanks in advance for the help.

Mike
Reply With Quote
  #63  
Old 09-11-2006, 08:46 AM
Luka Luka is offline
Registered User
Location: CT
 
Join Date: Aug 2006
Posts: 75
Mein Auto: '09 328i, '11 535i
Unable to unprotect the sheets.
Reply With Quote
  #64  
Old 09-13-2006, 07:03 PM
knmol knmol is offline
Registered User
Location: Twin Cities, MN
 
Join Date: Jul 2006
Posts: 14
Mein Auto: Soon to be X3
Quote:
Originally Posted by robertbroussard View Post
Hey, thanks for sharing such a tool and for putting so much work into it.

Okay, I have a problem, I tried to change the "Amt Over ED Invoice" cell A16 (before noticing the directions) and got an error (#NAME?).

Have you documented all of the rules and calculations that this document is suppose to perform? I would like to better understand it.

BTW: can you upload this document as a zip archive?

Thanks,

Robert

Sorry so slow to respond.

If you still want help: The problem you are having is because of cell A40, which uses the function MROUND to round the payment up to the nearest $50. If you get that #NAME? error it's because you need to load the Analysis ToolPak add-in.

Here is how (copied from Excel help):
--On the Tools menu, click Add-Ins.
--In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
--If necessary, follow the instructions in the setup program.

Hope that helps! I can't attach it as a zip - that file extension is not allowed. But it doesn't seem necessary - the file is only 33k - very small.

Quote:
Originally Posted by jd101 View Post
This is a really helpful spreadsheet and I'm using it to figure out my lease for an ED 2007 X3.

One question: How should I determine the "State Taxes" amount for California (cell D19 in your spreadsheet)? Is it simply the tax rate times the Total Monthly Lease Payment times the number of months? I don't think the entire tax payment is due at the time of signing in California. So, should I zero out the number in D19 and simply add the monthly tax to the monthly lease payment?
Yes, that is how I would do it. You could insert a line between 6 and 7 so that you could add the tax payment in there if you know the calculation to determine taxes - that way if you changed something that affected taxes (like the total negotiated cost, etc.) it would change the tax accordingly. We are in Minnesota and never figured out exactly how the taxes were calculated, but we chose to pay them up front so we didn't have to worry that our estimate of taxes would muck up the payment amount.

Quote:
Originally Posted by simpsmk View Post
knmol - I have attempted to download the BMW EDcalcs file and am having some difficulty opening it. I am using Adobe Acrobat Reader ver 7.0 and am getting an error message that say's it is either an unsupported file format or the file is corrupted - it suggested it could be related to the file having been an attachment in an email and not decoded properly. Do you have any suggestions on how I could resolve the problem? I will be ordering a Euro Delivery 335i tomorrow and would really love to have your worksheet to run through the lease / finance numbers.
You have to rename the file to an xls file rather than a pdf, and then open it in Excel rather than in Acrobat. It's not really a pdf file, but the site won't let me upload an xls file so I changed it to pdf. It appears that others have gotten it to work by changing the "pdf" to "xls". Hope that helps!
Reply With Quote
  #65  
Old 09-13-2006, 07:31 PM
Luka Luka is offline
Registered User
Location: CT
 
Join Date: Aug 2006
Posts: 75
Mein Auto: '09 328i, '11 535i
Thanks!
Great tool!
Reply With Quote
  #66  
Old 09-19-2006, 11:17 PM
schley's Avatar
schley schley is offline
This is the Cubs year)
Location: Saudi Arabia (no I'm not kidding)
 
Join Date: May 2005
Posts: 4,001
Mein Auto: camel
I'm so pissed.... frickin leaseguide.com has been consistently screwing up anything I give it. I'm pretty patient and I know it has it's bugs from time to time, but tonight it is royally screwed up. I guess I finally got what people had been talking about, when it screws them. I have used it consistenly for 6 months now and really no problems majorly... but the last couple days... big time.
__________________
2006 Z4 3.0si -pickup 9/23/06- turned in 8/2/08, titanium silver, black leather, aluminum, step, premium, sport, heated seats
2006 330i e90 ED -Sold 10/23/06
BMWCCA # 350430
Reply With Quote
  #67  
Old 09-19-2006, 11:35 PM
SwampDaddy SwampDaddy is offline
Officially Welcomed to the 'Fest
Location: Houston, TX
 
Join Date: Jun 2006
Posts: 294
Mein Auto: 2011 335is (for sale)
Cool

Quote:
Originally Posted by schley View Post
I'm so pissed.... frickin leaseguide.com has been consistently screwing up anything I give it. I'm pretty patient and I know it has it's bugs from time to time, but tonight it is royally screwed up. I guess I finally got what people had been talking about, when it screws them. I have used it consistenly for 6 months now and really no problems majorly... but the last couple days... big time.
Jeff, we should probably rely on a solid spreadsheet or database that we fully understand and that could run without a connection to the net.

Also, if I remember correctly, the tool you are referring to is very restrictive... you cannot easily edit information after the fact--ouch!

FWIW,

Robert
Reply With Quote
  #68  
Old 09-20-2006, 06:33 PM
schley's Avatar
schley schley is offline
This is the Cubs year)
Location: Saudi Arabia (no I'm not kidding)
 
Join Date: May 2005
Posts: 4,001
Mein Auto: camel
New Online Lease Calculator

http://www.autoleaseadvisers.com/cal...ubmit=Continue

After getting pissed off with leaseguide lease calculator I tried using everyone's excel calculator and either didn't work for me or wasn't user friendly enough for me. I went on a crusade to find an online lease calculator I could use that is reliable. Here it is..... works very well so far as I know today after a thorough testing. Use it or don't use it, doesn't matter to me but I'm just glad to be able to dump the leaseguide calc.
__________________
2006 Z4 3.0si -pickup 9/23/06- turned in 8/2/08, titanium silver, black leather, aluminum, step, premium, sport, heated seats
2006 330i e90 ED -Sold 10/23/06
BMWCCA # 350430
Reply With Quote
  #69  
Old 09-20-2006, 06:51 PM
rmcneight rmcneight is offline
Registered User
Location: Florida
 
Join Date: Sep 2006
Posts: 4
Mein Auto: BMW 545i
Jon,

Where can I find the 2007 E63 6 series pricing. I saw you posted it for the 3 and 5 series but not the 6. Also, do you know if in 2007 an ED 650cic is in or out of dealer allocation. I saw an old said that it was considered part of their allocation. Is that still the case and where can I find dealers who will negotiate an ED 6 series from European wholesale>

Thanks for your help, Rick
Reply With Quote
  #70  
Old 09-23-2006, 10:41 AM
Noobified Noobified is offline
Registered User
Location: California
 
Join Date: Sep 2006
Posts: 25
Mein Auto: 2006 Z4 M Coupe
Hi webguy330i, sales tax should be added onto the down payment amount and reflected on the 'due at signing' field, correct?

Last edited by Noobified; 09-23-2006 at 11:00 AM.
Reply With Quote
  #71  
Old 10-06-2006, 10:00 AM
VoyagerDude VoyagerDude is offline
Officially Welcomed to the 'Fest
Location: Calgary AB
 
Join Date: Aug 2006
Posts: 112
Mein Auto: 05 Duc 749S
Does anyone have the formulas for the Single-Payment Lease?
__________________

07 BMW 335i e90 (sp.graph, limon dakota, prem, sport, navi, BT phone, alarm)
05 Ducati 749S
02 MB C230K - sold
Reply With Quote
  #72  
Old 11-29-2006, 04:27 PM
simplemind's Avatar
simplemind simplemind is offline
Officially Welcomed to the 'Fest
Location: Austin
 
Join Date: Oct 2006
Posts: 169
Mein Auto: Lamborghini Murciélago
Unlock code

Anyone have the excel unlock code?
Thanks,
J
Reply With Quote
  #73  
Old 07-30-2007, 12:02 PM
ronzer ronzer is offline
Officially Welcomed to the 'Fest
Location: San Francicso
 
Join Date: Oct 2002
Posts: 16
Send a message via ICQ to ronzer Send a message via Yahoo to ronzer
Mein Auto: 2008 335i Sedan
I took the Excel spreadsheet and made some updates:
Replaced MROUND with CEILING (doesn't require the Analysis ToolPak)
Added support for Tax Rate as monthly payments are taxed in CA.
Added some Money Factory/Interest Rate conversions.

I filled it out for a 2007 335i at which I'm looking.

Again, rename .pdf to .xls to avoid the attachment restrictions.
Attached Files
File Type: pdf bmwEDcalcs335i.pdf (28.5 KB, 710 views)
Reply With Quote
  #74  
Old 07-30-2007, 02:37 PM
pepiny2k pepiny2k is offline
Registered User
Location: Miami FL
 
Join Date: Sep 2006
Posts: 30
Mein Auto: 2009 528
Thanks Ronzer...nice spreadsheet. Is the Use Tax something for California only?. I live in Flirida and I had not heard of it before. Thanks!
Reply With Quote
  #75  
Old 07-30-2007, 07:48 PM
LeaseCompare's Avatar
LeaseCompare LeaseCompare is offline
Instant Lease Quotes
Location: Cincinnati, OH
 
Join Date: Mar 2005
Posts: 556
Send a message via AIM to LeaseCompare
Mein Auto: M3 Convertible
Quote:
Originally Posted by pepiny2k View Post
Is the Use Tax something for California only?. I live in Flirida and I had not heard of it before.
Same as sales tax, which is how Florida works.
Reply With Quote
Reply

Bookmarks


Forum Navigation
Go Back   Bimmerfest - BMW Forums > The Best of Bimmerfest! > Ask-A-Dealer
Today's Posts Search
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
One time lease payment...... BMW29 Ask-A-Dealer 11 08-01-2005 05:15 PM
One time lease payment on a 2005 325i...... BMW29 Ask-A-Dealer 11 03-22-2005 05:45 PM
Leasing vs Buying - What am I missing? Coop33 3 Series / 4 Series 46 09-13-2003 05:41 PM
Joined the Club! kyleschultz 3 Series / 4 Series 26 06-03-2003 01:11 PM


All times are GMT -7. The time now is 08:42 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
© 2001-2011 performanceIX, Inc. All Rights Reserved .: guidelines .:. privacy .:. terms