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
  #101  
Old 02-09-2008, 02:56 AM
Taktix1 Taktix1 is offline
Registered User
Location: Wash DC/NoVa
 
Join Date: Oct 2007
Posts: 17
Mein Auto: Infiniti G35 Coupe
I was using a lease calculator at leaseguide.com and these are the numbers it spit out:

335xi Coupe
MSRP 50700
Neg. Price: 48000 (just guessing, includes all fees but not tax)
58% Residual
.00196 MF (lowest possible including 7 MSDs)
36 months
5% tax

Total came out to 701.63


Seems pretty high, am I doing something wrong?
Reply With Quote
  #102  
Old 02-22-2008, 11:30 PM
oghowie oghowie is offline
Officially Welcomed to the 'Fest
Location: SoCal
 
Join Date: Feb 2006
Posts: 131
Mein Auto: Alpine White '08 535i
Seems correct. Advertised lease payments are always low because a down payment is being paid. I assume you aren't putting any money down and that you are paying the bank/acquisition fee at signing? That may be why the payments seem higher than you are used to seeing.
Reply With Quote
  #103  
Old 04-03-2008, 06:40 AM
1985mb's Avatar
1985mb 1985mb is offline
N54
Location: Tri-state area
 
Join Date: Apr 2008
Posts: 3,414
Mein Auto: E60 535i M-sport
Quote:
Originally Posted by schley View Post
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.
I compared this to what Ronzer posted in post #73.

By zeroing out the ED markup on the MF (and using US MSRP/invoice numbers), I can get the same results.

1 thing to note is that the ALA calculator automatically rolls the Acq fee into the adjusted cap cost.

Ronzer's one allows one to play around with options and is a bit more transparent
Reply With Quote
  #104  
Old 04-28-2008, 10:32 AM
528iDC 528iDC is offline
Registered User
Location: Virginia
 
Join Date: Mar 2008
Posts: 86
Mein Auto: 535i
Are there any lease calculators that determine the monthly payment amount by rolling in state taxes? Trying to find one that will work for leasing a car in Virginia, since unlike other states, Virginia doesn't charge a "use tax" but instead charges a 3% rate of the negotiated purchase price of the vehicle. It looks like most calculators just compute the "use tax."
Reply With Quote
  #105  
Old 05-07-2008, 08:33 AM
53 TURK 53 TURK is offline
Officially Welcomed to the 'Fest
Location: NY/NJ
 
Join Date: Feb 2008
Posts: 146
Mein Auto: '13 X5 & '14 435Xdrive
ok now, i will need some help,
let's say the msrp is 52070 and the invoice price is 48500. If you say 1000 over invoice, does that mean the cap cost will be 49500, including the dmv, paperwork, maco, etc... ?and on top of this there is tax depenend on the state you live in of course. Am I wrong? Please let me know. Thanks to you all.
Reply With Quote
  #106  
Old 05-07-2008, 08:20 PM
FastMarkA FastMarkA is online now
Officially Welcomed to the 'Fest
Location: Chicago
 
Join Date: Apr 2008
Posts: 1,448
Mein Auto: 2011 535xi
I'm doing my lease calcs, and have a question about the depreciation. I'm using this formula:

Cap Cost (Adj Cap (Selling Price + Doc + Process + Tax - Cap Rdxn) + Acq Fee)
Depreciation (Cap Cost - Residual)

Question is...when I use "Cap Cost" for computing the Depreciation, should aquisition fee be included or removed?

TIA.
Reply With Quote
  #107  
Old 07-06-2008, 04:05 PM
ponchim ponchim is offline
Registered User
Location: Washington, DC
 
Join Date: Jul 2008
Posts: 1
Mein Auto: VW Jetta
Quote:
Originally Posted by webguy330i View Post
You got it.

Glad some people are finding this thing useful!!
Webguy-

Can you please email me the password as well? I'm trying to use the spreadsheet on a Mac and can't get the worksheet values (MSRP, negotiated price) to flow over to the lease calc sheet. If I can hard-code those values I can proceed with the calc. Email to mponchione@hotmail.com.

Thanks in advance. Great and useful tool, btw.
Reply With Quote
  #108  
Old 10-07-2008, 06:35 PM
enigma135 enigma135 is offline
Registered User
Location: Bethesda, MD
 
Join Date: Oct 2008
Posts: 82
Mein Auto: 99 CLK320 Cab
Hey i'm thinking of taking ED and leasing a 135 convertible going off the invoice pricing the car has come out to $43,990 (Premium, Sport, CA, PDC, NAV, Hi-Fi, iPod, Metallic Paint, Smartphone, Heated Seats, and Delivery and Handling) When i sat with a CA and he worked out payments on a 135 MSRP of $45,545 (selling price of $42,945 + 6% tax ($2576.70) + BMWFS Assignment 825.00 + tag and registration $270.00 + Cash Down Payment $2685.00. Making the total Capitalized Cost $43,931.70. Residual Value $31,881.50. 24 month Lease. Monthly Lease Charge .00295 ($223.65). Monthly depreciation $502.09 Monthly Payment of $725.74 with $3,410.74 due on delivery. Does that seem legit? Seems as though people are paying less per month on similar priced leases. Sorry for the novel post but am admittedly a noob when it comes to leasing, before i get completely flamed i have been reading up on it. Just hoping for some of your insights, since every lease option my CA has worked out has been right around $700 a month with 3-4K due on delivery.
Reply With Quote
  #109  
Old 10-07-2008, 08:30 PM
mclaren's Avatar
mclaren mclaren is offline
Chairman of the Bored
Location: Central Florida
 
Join Date: Jan 2005
Posts: 3,066
Mein Auto: 2013 650i Coupe
What you call BMWFS Assignment $825 is the lease acquisition fee. It was $625 but may be $725 now ( I heard it was being raised Oct 1 ) so they marked it up $100 or $200. The Money factor is .00285 so they marked it up .0001. These are reasonable. The residual is 73% so if MSRP is $43,990 the residual should be exactly $32,112.70. So if you make 0 down payment, pay the tax $2576.70 and $270 and 1st month of $709.57 = $3,556.27 drive off and $709.57 per month. There is one problem and that is the security deposit. Unless you're a returning BMWFS customer you either have to pay a security deposit or a .00015 adder to the money factor. If you are a returning customer then it makes sense but then they marked up the money factor more because of the owner loyalty program. So the key is DON'T PUT A DOWN PAYMENT, do it like I outlined. I can't say if it is a fair deal because this particular car may be in demand but they are making about $2250 on the car, $100 or $200 on the lease acquisition fee, and a few 100 on the money factor markup. So the deal is strong money for the dealer and they structured it wrong. BTW, these numbers are for a 15k miles per year lease.
__________________

2012 328i Coupe
2013 650i Coupe ( retired for Porsche 911 )
Reply With Quote
  #110  
Old 10-08-2008, 10:19 PM
enigma135 enigma135 is offline
Registered User
Location: Bethesda, MD
 
Join Date: Oct 2008
Posts: 82
Mein Auto: 99 CLK320 Cab
Thanks for your help mclaren
Reply With Quote
  #111  
Old 10-31-2008, 03:04 PM
BigMoneyWasted BigMoneyWasted is offline
2008 Z43.0i
Location: Columbus Ohio
 
Join Date: Oct 2008
Posts: 75
Mein Auto: 2008 Z4
password

Anyone have the password to the lease calculation spreadsheet? It does not accept any numbers under Excel 2007, just prompts me to unlock the sheet. Tx.
Reply With Quote
  #112  
Old 02-22-2009, 10:46 AM
gizmoboy gizmoboy is offline
Registered User
Location: Southlake, TX
 
Join Date: Feb 2009
Posts: 21
Mein Auto: M35
Quote:
Originally Posted by BigMoneyWasted View Post
Anyone have the password to the lease calculation spreadsheet? It does not accept any numbers under Excel 2007, just prompts me to unlock the sheet. Tx.
Ditto.
Reply With Quote
  #113  
Old 05-15-2009, 01:42 PM
xtac xtac is offline
Registered User
Location: long island
 
Join Date: Jan 2009
Posts: 31
Mein Auto: 01 330ci
what's the password =/
Reply With Quote
  #114  
Old 06-10-2009, 08:18 AM
BlueC BlueC is offline
Officially Welcomed to the 'Fest
Location: MN
 
Join Date: Jan 2007
Posts: 2,235
Mein Auto: '09 335i
Quote:
Originally Posted by xtac View Post
what's the password =/
Enable macros. Then you should be able to enter the info.
__________________
Reply With Quote
  #115  
Old 08-02-2009, 04:36 PM
asaseaban's Avatar
asaseaban asaseaban is offline
Y ask y? Ask y not!
Location: DMV
 
Join Date: Aug 2005
Posts: 576
Mein Auto: F02
See these link for more helpful and detail lease information and calculation
http://www.bimmerfest.com/forums/att...4&d=1249255376

http://www.bimmerfest.com/forums/att...5&d=1249255376
__________________
_______________
2000 740iL Space Gray - Sold
2003 745Li Titanium Silver - Sold
2009 750Li Mineral White - Sold
2009 750Li Titanium Silver
2011 xDrive35d Vermilion Red - Sold
2012 xDrive35d Vermilion Red
Reply With Quote
  #116  
Old 02-15-2010, 08:23 PM
ooati ooati is offline
Registered User
Location: Bowie, MD, USA
 
Join Date: Feb 2010
Posts: 8
Mein Auto: 2010 535i
Passwords to webguy330i's spreadsheet are as follows:
sheet password: 2b3b3b7b1b3b5
book password: 3b7b5b1b3b1b7
Reply With Quote
  #117  
Old 10-29-2011, 04:20 PM
Jon Shafer's Avatar
Jon Shafer Jon Shafer is offline
Admin Owner Enthusiast
Bimmerfest Founder
Location: Santa Barbara
 
Join Date: Dec 2001
Posts: 14,212
Mein Auto: E92 M3 Cp
Back to the future. Here's there worksheet again.
Attached Files
File Type: pdf Lease Worksheet.pdf (123.7 KB, 472 views)
__________________
Order your new BMW Today! BMW SANTA BARBARA jshafer@sbautogroup.com


Serving the BMW Online Community Since 1995 The BIMMERFEST "Internet Special"
Reply With Quote
  #118  
Old 10-29-2011, 08:24 PM
01Byte's Avatar
01Byte 01Byte is offline
Pastafarian Extraordinair
Location: Phila, Pa
 
Join Date: Jun 2003
Posts: 2,342
Mein Auto: 335d
That paper guide is sooo yesterday.

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

Just plug in the numbers and enjoy the ride.
__________________
May we be blessed by His noodly appendage and His almighty sauciness.
Reply With Quote
  #119  
Old 10-29-2011, 09:31 PM
Jon Shafer's Avatar
Jon Shafer Jon Shafer is offline
Admin Owner Enthusiast
Bimmerfest Founder
Location: Santa Barbara
 
Join Date: Dec 2001
Posts: 14,212
Mein Auto: E92 M3 Cp
Quote:
Originally Posted by Arkady View Post
That paper guide is sooo yesterday.

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

Just plug in the numbers and enjoy the ride.

You missed the point of it! Some people like to do it. The old fashioned way.

What would happen if the computer crashed?

I've sent customers home in new cars, leases mind you, by candle light during power outages...


TRY IT. IT CAN BE FUN!!! IT WILL ALSO STIMULATE YOUR NEO-CORTEX...
__________________
Order your new BMW Today! BMW SANTA BARBARA jshafer@sbautogroup.com


Serving the BMW Online Community Since 1995 The BIMMERFEST "Internet Special"
Reply With Quote
  #120  
Old 02-22-2012, 04:11 AM
chrischeung chrischeung is offline
Officially Welcomed to the 'Fest
Location: Dallas, TX
 
Join Date: Sep 2002
Posts: 7,230
Mein Auto: 2012 ActiveHybrid 7 SWB
Quote:
Originally Posted by Jon Shafer View Post
You missed the point of it! Some people like to do it. The old fashioned way.

What would happen if the computer crashed?

I've sent customers home in new cars, leases mind you, by candle light during power outages...


TRY IT. IT CAN BE FUN!!! IT WILL ALSO STIMULATE YOUR NEO-CORTEX...
I personally like it. I've used it a few times. You can fax it in advance to the finance person. They immediately know you understand all about leasing, and any opportunity for manipulation on either side goes away. It's easier to prove the accuracy of the pen and paper sheet than the XLS. It also teaches you the relationships between MF, cap cost, residual and depreciation and how each of those affect the payment. I still have the LRFS version somewhere.
__________________
2012 ActiveHybrid 750i ED

3/12 ED 7 - thread ID 610350
1/11 ED 6 - thread ID 5767556&postcount=175
4/10 ED 5 - thread ID 453501
5/08 ED 4 - thread ID 290679
3/07 ED 3 - thread ID 201013
3/06 ED 2 - thread ID 136454

Last edited by chrischeung; 02-22-2012 at 04:13 AM.
Reply With Quote
  #121  
Old 02-22-2012, 08:20 AM
Jon Shafer's Avatar
Jon Shafer Jon Shafer is offline
Admin Owner Enthusiast
Bimmerfest Founder
Location: Santa Barbara
 
Join Date: Dec 2001
Posts: 14,212
Mein Auto: E92 M3 Cp
Quote:
Originally Posted by chrischeung View Post
I personally like it. I've used it a few times. You can fax it in advance to the finance person. They immediately know you understand all about leasing, and any opportunity for manipulation on either side goes away. It's easier to prove the accuracy of the pen and paper sheet than the XLS. It also teaches you the relationships between MF, cap cost, residual and depreciation and how each of those affect the payment. I still have the LRFS version somewhere.
Exactly!!!




In today's dealerships (and buying population) there is total reliance on websites/apps to estimate payments. It feels really good sometimes to be able to wrap one's brain completely around a lease. Kinda like doing a long division or a quadratic equation just for fun...

Seriously, you are so right about it's effects on one's ability to conceptualize how the different variables of a lease payment inter-play...
__________________
Order your new BMW Today! BMW SANTA BARBARA jshafer@sbautogroup.com


Serving the BMW Online Community Since 1995 The BIMMERFEST "Internet Special"
Reply With Quote
  #122  
Old 05-03-2012, 06:10 PM
boi222 boi222 is offline
Registered User
Location: NYC
 
Join Date: May 2007
Posts: 89
Mein Auto: '12 M3 Coupe
.

Last edited by boi222; 05-24-2012 at 09:36 PM.
Reply With Quote
  #123  
Old 05-04-2012, 06:21 PM
CeEl CeEl is offline
Registered User
Location: Chicago
 
Join Date: Jan 2012
Posts: 46
Mein Auto: not a Z4 just yet
Probably something with the taxes ... are you sure you pay taxes upfront in your state and not added to the lease payment?

Also, the sale price is low ... does this include the $2500 option credit? Are you sure the dealer didn't just deduct the 1000 from the "real" sales price? If you remove the $1000 from the equation, you are almost at what the dealer quoted for monthly payment.
Reply With Quote
  #124  
Old 05-04-2012, 08:07 PM
boi222 boi222 is offline
Registered User
Location: NYC
 
Join Date: May 2007
Posts: 89
Mein Auto: '12 M3 Coupe
.

Last edited by boi222; 05-24-2012 at 09:37 PM.
Reply With Quote
  #125  
Old 11-07-2012, 01:11 PM
jbailey895 jbailey895 is offline
Officially Welcomed to the 'Fest
Location: San Diego, CA
 
Join Date: Dec 2009
Posts: 343
Mein Auto: 335i
Back in 2010 I had an XLS spreadsheet that listed MSRP and invoice for all current packages, allowed you to input MF's, MSD's etc, and spit out the fees and Mo'ly payment based on all current prices. Was an awesome program to get right to the nitty-gritty, but my sheet has all the info for the '10 prices, any chance someone could send me something similar for '13 models?

Thanx,
Joel
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 05:07 PM.


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