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
  #1  
Old 05-06-2004, 02:46 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,195
Mein Auto: E92 M3 Cp
Pen and Pencil Lease Payment Calculation

Pencil-and-paper worksheet.
Attached Files
File Type: pdf Lease Worksheet.pdf (123.7 KB, 2929 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
Advertisement
  #2  
Old 08-07-2004, 09:52 PM
BayAreaBMWFan BayAreaBMWFan is offline
Back in California
Location: San Francisco Bay Area
 
Join Date: Aug 2004
Posts: 3,251
Mein Auto: '12 328 Vert; '09 Odyssey
Question Sales Tax on Interest

Since the lease worksheet breaks out the depreciation vs financing, why do dealers charge state sales tax on the interest portion (determined by the MF)?
Reply With Quote
  #3  
Old 08-07-2004, 11:04 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,195
Mein Auto: E92 M3 Cp
Quote:
Originally Posted by BayAreaBMWFan
Since the lease worksheet breaks out the depreciation vs financing, why do dealers charge state sales tax on the interest portion (determined by the MF)?
Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.
Reply With Quote
  #4  
Old 08-20-2004, 10:09 AM
SARAFIL's Avatar
SARAFIL SARAFIL is offline
I know a thing or two...
Location: Boston, MA
 
Join Date: Feb 2003
Posts: 7,401
Mein Auto: '11 BMW 335xi
Quote:
Originally Posted by Jon Shafer
Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.
Gas Guzzler tax is also an "option" (albeit a mandatory one) added into the final MSRP, and not listed seperately as a tax, so you pay tax on that too...

You'll also pay tax on the acqusition fee upfront (or as part of the payment of you capitalize the fee), and tax on any fees at the end of the lease. This is not BMWFS's doing, though... they're just complying with tax laws put in front of them.
Reply With Quote
  #5  
Old 08-27-2004, 04:51 AM
hector hector is offline
Officially Welcomed to the 'Fest
Location: virgo supercluster
 
Join Date: Jul 2003
Posts: 491
Mein Auto: '08 128i cpe ac/pw/ps/abs
Thumbs down

Quote:
Originally Posted by Jon Shafer
Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.

actually jon, that was at least triple taxation, assuming that one had already paid income tax on the money used to purchase the car
Reply With Quote
  #6  
Old 08-31-2004, 09:35 AM
RocklinX3 RocklinX3 is offline
Registered User
Location: Sacramento,CA
 
Join Date: Aug 2004
Posts: 1
Mein Auto: Dodge P/U
Residualizable options handbook

Quote:
Originally Posted by Jon Shafer
Pencil-and-paper worksheet.
In the worksheet (section 2B) for the residualizable options it mentions a handbook. Any chance you have the handbook also?
Reply With Quote
  #7  
Old 09-08-2004, 03:34 PM
webguy330i webguy330i is offline
Head-In-Sand Dumbass
Location: San Jose, CA (silicon valley area)
 
Join Date: Jan 2002
Posts: 2,193
Mein Auto: BBY Evo VIII
Would anyone find benefit in having this be 'interactive' with form fields and the like? I might put one together.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #8  
Old 09-08-2004, 03:55 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,195
Mein Auto: E92 M3 Cp
Quote:
Originally Posted by webguy330i
Would anyone find benefit in having this be 'interactive' with form fields and the like? I might put one together.
Yes!!!!

Please do it!!!!


:-)))
Reply With Quote
  #9  
Old 09-09-2004, 11:41 AM
webguy330i webguy330i is offline
Head-In-Sand Dumbass
Location: San Jose, CA (silicon valley area)
 
Join Date: Jan 2002
Posts: 2,193
Mein Auto: BBY Evo VIII
Quote:
Originally Posted by Jon Shafer
Yes!!!!

Please do it!!!!


:-)))
Ask and ye shall receive! It's not *exactly* the same though... different fields, different names...

I made it an excel doc, might make an HTML version later for compatibility. Can you check it over and let me know if you see any discrepencies or problems?

Right-click, save as...

http://images.330i.net/media/lease_calculator.xls
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #10  
Old 09-09-2004, 11:45 AM
webguy330i webguy330i is offline
Head-In-Sand Dumbass
Location: San Jose, CA (silicon valley area)
 
Join Date: Jan 2002
Posts: 2,193
Mein Auto: BBY Evo VIII
Oh and some notes:

- yes this is a reincarnation of the old skewl XLS doc I once found a long long time ago on roadfly
- you only need to change the numbers at the top under the "Adjust these..." section
- you can now account for paying tax up front or monthly, paying acquisition up front or monthly, and paying excess mileage charges up front/monthly/at termination
- I tested it quite a bit but I could have missed something. Everything seems to line up with the general leasing formulas and quotes I've seen
- YMMV
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12

Last edited by webguy330i; 09-10-2004 at 01:42 AM.
Reply With Quote
  #11  
Old 09-02-2007, 07:15 AM
TooManyIDs TooManyIDs is offline
Registered User
Location: Plano, Texas
 
Join Date: Jan 2004
Posts: 93
Mein Auto: 2011 Cayman S
Quote:
Originally Posted by webguy330i View Post
Thanks
__________________
Al
2011 Cayman S
PCA, BMWCCA, NCRS
Motorsport Ranch
Eagles Canyon Raceway
Reply With Quote
  #12  
Old 10-10-2004, 05:02 PM
Pete Largo Pete Largo is offline
Registered User
Location: Texas
 
Join Date: Oct 2004
Posts: 22
Mein Auto: n/a
Quote:
Originally Posted by JonS
Pencil-and-paper worksheet.
Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?
Reply With Quote
  #13  
Old 10-10-2004, 05:05 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,195
Mein Auto: E92 M3 Cp
Quote:
Originally Posted by Pete Largo
Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?
Unfortunately, such a handbook is no longer published per se, but
has been replaced by e-bulletins only found on the BMWFS Infobahn
for retail centers...
Reply With Quote
  #14  
Old 10-11-2004, 04:09 PM
SARAFIL's Avatar
SARAFIL SARAFIL is offline
I know a thing or two...
Location: Boston, MA
 
Join Date: Feb 2003
Posts: 7,401
Mein Auto: '11 BMW 335xi
Quote:
Originally Posted by Pete Largo
Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?
I've got a hard copy of the Handbook that dates back to 2001 that I keep around for "quick reference", and it's 83 pages--- not a small file that I could easily "post" here. Otherwise, like Jon says, the info is available in the form of many bulletins/.pdf's on BMWFS Infobahn, the website for BMW dealers. You need to work for a dealer and have appropriate authorization to get access to it, it's not just available to anyone.
Reply With Quote
  #15  
Old 10-11-2004, 05:04 PM
Pete Largo Pete Largo is offline
Registered User
Location: Texas
 
Join Date: Oct 2004
Posts: 22
Mein Auto: n/a
Oh well, I tried
Reply With Quote
  #16  
Old 10-06-2005, 08:58 PM
turpiwa's Avatar
turpiwa turpiwa is offline
Officially Welcomed to the 'Fest
Location: Perth for now
 
Join Date: Jun 2005
Posts: 1,651
Send a message via Yahoo to turpiwa
Mein Auto: E93 M3 Convertible
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.

Quote:
Originally Posted by wajiheffendi
Hi. I just checked out your lease spreadsheet, it's great but it doesn't take into account the tax calculation for states like Texas, where the entire vehicle's purchase price is taxed regardless if you are leasing or buying...any chance you could add it or give me a non-password protected version so I could make the change myself....?

thanks!
-wajih
__________________

ED 2009 (5/2) E90 335i, 6MT - Le Mans Blue, Burl, ZPP(Blk Lthr), M-Sports, ZCW, Active Steer, Nav, shades, PDC, ipod, Sirius, CA, Smartphone
ED 2005 (11/18) E90 330i, 6MT - Monaco, Burl, ZPP(Blk Lthr), ZSP, ZCW, Active Cruise & Steer, Nav, shades, PDC, Sirius, CA
MY ED 2005 WRITEUP
EUROPEAN DELIVERY PICTURES (albums are in reverse order - sorry). NO NEED TO SIGN IN -beware - there's lots
Reply With Quote
  #17  
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
  #18  
Old 04-14-2006, 02:50 PM
Chicago Jenny Chicago Jenny is offline
Registered User
Location: Chicago
 
Join Date: Sep 2005
Posts: 44
Mein Auto: Chicago
Has the calculator been upgraded anywhere to reflect states where you get bent over with sales tax on the full purchase price of the car?
Reply With Quote
  #19  
Old 04-14-2006, 04:07 PM
Ågent99's Avatar
Ågent99 Ågent99 is online now
Moderator, 5-Series
Location: Bay Area, CA
 
Join Date: Jan 2002
Posts: 5,930
Mein Auto: Trek 6500 MTB
I believe this is true for the state of New York?? Just click the NY button.
__________________
2001 530i/5 (E39), Topaz Blue/Stone Green/Black (118k miles) *very rare interior/exterior color combo*
2005 545i/SMG (E60), ED Order, Titanium Grey/Grey (lease over)
2015 335i, ED Order Summer 2015
Reply With Quote
  #20  
Old 04-17-2006, 02:27 PM
stiffy1's Avatar
stiffy1 stiffy1 is offline
You puked ON Dean Wormer
Location: Toronto-ish
 
Join Date: Aug 2005
Posts: 211
Mein Auto: '06 525i / '02 MB SL500
I've got a very simple excel spreadhseet for calculating lease costs - can someone advise on how I can upload it? Trying to attach as an image doesn't work.
__________________
1999 Z3 2.3 - SOLD
2006 525i - Leased/returned
2002 M-B SL500
2008 M-B E3004M
I guess I'm all out of BMW's.....for now....
Reply With Quote
  #21  
Old 04-17-2006, 04:35 PM
Ågent99's Avatar
Ågent99 Ågent99 is online now
Moderator, 5-Series
Location: Bay Area, CA
 
Join Date: Jan 2002
Posts: 5,930
Mein Auto: Trek 6500 MTB
Quote:
Originally Posted by stiffy1
I've got a very simple excel spreadhseet for calculating lease costs - can someone advise on how I can upload it? Trying to attach as an image doesn't work.
You can't upload it directly to 'Fest...it isn't one of the sanctioned files. You need to upload to some other public server and provide us the link to that.
__________________
2001 530i/5 (E39), Topaz Blue/Stone Green/Black (118k miles) *very rare interior/exterior color combo*
2005 545i/SMG (E60), ED Order, Titanium Grey/Grey (lease over)
2015 335i, ED Order Summer 2015
Reply With Quote
  #22  
Old 04-18-2006, 12:04 PM
stiffy1's Avatar
stiffy1 stiffy1 is offline
You puked ON Dean Wormer
Location: Toronto-ish
 
Join Date: Aug 2005
Posts: 211
Mein Auto: '06 525i / '02 MB SL500
Give this a try. I took a picture of the spreadsheet, and added text boxes (colored in flesh tone) to provide the formula. Excel has the ability to compute lease payments, and I just added the other info. In Ontario, taxes are added to the lease payment, after everything else is calculated. I suppose this will require entering all the info into a spreadsheet, but it makes for an quick and accurate calculator. Good luck.
Attached Thumbnails
Click image for larger version

Name:	lease calc.GIF
Views:	680
Size:	16.1 KB
ID:	73774  
__________________
1999 Z3 2.3 - SOLD
2006 525i - Leased/returned
2002 M-B SL500
2008 M-B E3004M
I guess I'm all out of BMW's.....for now....

Last edited by stiffy1; 04-18-2006 at 12:09 PM.
Reply With Quote
  #23  
Old 04-18-2006, 01:17 PM
BayAreaBMWFan BayAreaBMWFan is offline
Back in California
Location: San Francisco Bay Area
 
Join Date: Aug 2004
Posts: 3,251
Mein Auto: '12 328 Vert; '09 Odyssey
Quote:
Originally Posted by stiffy1
Give this a try. I took a picture of the spreadsheet, and added text boxes (colored in flesh tone) to provide the formula. Excel has the ability to compute lease payments, and I just added the other info. In Ontario, taxes are added to the lease payment, after everything else is calculated. I suppose this will require entering all the info into a spreadsheet, but it makes for an quick and accurate calculator. Good luck.
Can you change the name of the file to something sanctioned like a .jpg and then ask folks to save it as a .xls.
__________________
2012 328Ci Black/Black ZPP
2011 528 Black/Black Retired ZPP ZP2 BMW Apps
2005 330Ci SparkGraphite/Gray Retired ZHP, Step, Nav, Xenon, Heated Seats, PDC
2007 X3 3.0si AlpiWhite/Tobacco ED Retired Step, ZSP, ZPP, ZCW, PDC, Nav, Xenon, Privacy Glass, Servotronic, Cargo Net
2002 745Li Slate Green Metallic/Beige Retired; Perfect baby-hauler
2006 525 TiAg/Black Retired
2004 3.0 Z4 Black/Black/Black SMG Retired
2003 525iA TiAg/Gray Retired;King of all Bimmers, the E39
Reply With Quote
  #24  
Old 04-18-2006, 01:56 PM
stiffy1's Avatar
stiffy1 stiffy1 is offline
You puked ON Dean Wormer
Location: Toronto-ish
 
Join Date: Aug 2005
Posts: 211
Mein Auto: '06 525i / '02 MB SL500
Here it is as a .jpg. Try to save it as an .xls file though I don't think that'll work. If not, I'd be glad to email it as an excel file to anyone interested.
Attached Thumbnails
Click image for larger version

Name:	lease calc1.JPG
Views:	511
Size:	67.3 KB
ID:	73779  
__________________
1999 Z3 2.3 - SOLD
2006 525i - Leased/returned
2002 M-B SL500
2008 M-B E3004M
I guess I'm all out of BMW's.....for now....
Reply With Quote
  #25  
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
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 03:57 PM.


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