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,212
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, 2916 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
Ads by Google
  #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,212
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: Northeast USA
 
Join Date: Feb 2003
Posts: 7,400
Mein Auto: '13 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,212
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-09-2004, 01:50 PM
SARAFIL's Avatar
SARAFIL SARAFIL is offline
I know a thing or two...
Location: Northeast USA
 
Join Date: Feb 2003
Posts: 7,400
Mein Auto: '13 BMW 335xi
Quote:
Originally Posted by webguy330i
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 get output of payments with and without tax
- your down payment includes the acquisition fee (it is NOT calc'd into the monthly via the adjusted cap cost)
- 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
If you want to roll the acquisition fee in to the lease, you can delete it from the top, and add it to the capititalized cost section below.

Also, you could throw in a "high-mileage" lease adjustment if you wanted to. Mileage penalties at lease end are 20 cents for all models but the 7, and 25 cents for the 7. Upfront, the adjustment to the residual is 15 cents and 20 cents, respectively. If you buy extra miles above 15,000 per year, you can pay the lower price upfront, and if you don't use those miles, BMWFS will refund you for them at lease end.

Last edited by SARAFIL; 09-09-2004 at 02:05 PM.
Reply With Quote
  #12  
Old 09-09-2004, 02:03 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
All very good points thanks Sarafil. I'll make some alterations! I wasn't sure how the residual was affected by mileage paid up front, hence the post-lease cost calc.

But otherwise you think everything shakes out mathematically?
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #13  
Old 09-09-2004, 07:23 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
Hey Sarafil, et al.-

I updated the spreadsheet. Tell me what you think! See the link above.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #14  
Old 09-09-2004, 07:23 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
I'm also going to add in a little section comparing prepaid vs. monthly vs. postpaid excess mileage costs.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #15  
Old 09-10-2004, 11:32 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
v1.02 changes:

- updated residual percentage to reflect MSRP not cap cost
- added proper protection so you can't really mess anything up

I'm taking feature requests folks!

Download here:

http://images.330i.net/media/lease_calculator.xls

NOTE: if you get a message about macros being disabled, go to Tools > Macro > Security... and set the security level to "Medium". Then close Excel and re-open the spreadsheet file, and select "Enable Macros". That way the thing will be able to do the calculations required.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12

Last edited by webguy330i; 09-10-2004 at 01:24 PM.
Reply With Quote
  #16  
Old 09-11-2004, 08:19 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
v1.03:

- added separate sheet for car configuration (lease calc. uses discounted msrp from that page as cap cost; uses msrp from that page as msrp)
- formatted lease calc sheet a bit
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #17  
Old 09-13-2004, 04:19 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
v1.04 updated:

- locked down cells you cannot edit, so now you can only select those cells that are changeable
- added additional option fields to car config sheet
- some 'behind the scenes' coding changes using named ranges, etc. (I'm still learning this excel stuff)
- colorized changeable cells
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #18  
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
  #19  
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,212
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
  #20  
Old 10-11-2004, 04:09 PM
SARAFIL's Avatar
SARAFIL SARAFIL is offline
I know a thing or two...
Location: Northeast USA
 
Join Date: Feb 2003
Posts: 7,400
Mein Auto: '13 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
  #21  
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
  #22  
Old 03-07-2005, 02:27 PM
02330iSP 02330iSP is offline
Registered User
Location: Mpls
 
Join Date: Jan 2004
Posts: 44
Mein Auto: 2008 335i
Webguy, I d/led the spreadsheet and it's quite nice. However, I think there's a small problem with it--the popup help for the residual says to multiple the negotiated price by the residual percentage; I'm pretty certain that residuals are calculated against MSRP not negotiated price. Looking at the original PDF that Jon posted seems to corroborate that theory.

I'm not in the business, so I may be mistaken, but I thought I'd point it out and see what people thought. Thanks for the spreadsheet--it's really easy to work with!
Reply With Quote
  #23  
Old 03-07-2005, 02:37 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
Quote:
Originally Posted by 02330iSP
Webguy, I d/led the spreadsheet and it's quite nice. However, I think there's a small problem with it--the popup help for the residual says to multiple the negotiated price by the residual percentage; I'm pretty certain that residuals are calculated against MSRP not negotiated price. Looking at the original PDF that Jon posted seems to corroborate that theory.

I'm not in the business, so I may be mistaken, but I thought I'd point it out and see what people thought. Thanks for the spreadsheet--it's really easy to work with!
Hey man thanks for that catch! Since that cell is a dollar amount only, it doesn't affect the calculations, only the comment box itself. So I updated it and re-uploaded.

Thanks again, glad it could help out.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
Reply With Quote
  #24  
Old 03-10-2005, 09:27 PM
glennmcgee glennmcgee is offline
Registered User
Location: KCMO
 
Join Date: Mar 2005
Posts: 20
Mein Auto: 2011 X5 xDrive 35d
ok i know i must be stupid but...

when i load this [really cool] xls file it puts up this thing called "microsoft visual basic" and says Runtime Error 57121 Can't Exit design mode because Control 'mileage_upfront' can not be created

eh?
Reply With Quote
  #25  
Old 03-11-2005, 08:53 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 glennmcgee
when i load this [really cool] xls file it puts up this thing called "microsoft visual basic" and says Runtime Error 57121 Can't Exit design mode because Control 'mileage_upfront' can not be created

eh?
Hmm, not sure about that one. Are you opening it in your web browser or in excel?

Open Excel and go to Tools > Options > Security

Click on Macro Security

What option is chosen? It should be at "medium" which will cause it to ask you if you want to enable or disable macros upon opening a spreadsheet which contains macros.
__________________
2006 GG Evo IX GSR
got acronyms?
"Bbbzzzzzst and all that..." - rost12
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 04:11 AM.


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