E90Post
 


GTB Performance
 
BMW 3-Series (E90 E92) Forum > BMW E90/E92/E93 3-series General Forums > Regional Forums > Canada > Lease calculator/Residual Values



Reply
 
Thread Tools Search this Thread
      09-04-2010, 07:15 PM   #1
PBureno
Private First Class
 
Drives: BMW
Join Date: Sep 2007
Location: Earth

Posts: 178
iTrader: (0)

Lease calculator/Residual Values

Does anyone have a method/Excel to calculate lease payments(since lease % usually changes every season and right now its at 3.9%) and what's the current 2010 and 2011 E90/E92 335i's residual value?

Does anyone know?

ThxThx
PBureno is offline  
0
Reply With Quote
      09-04-2010, 08:49 PM   #2
w2
Private First Class
 
Drives: 335i coupe
Join Date: Apr 2008
Location: Ottawa, Canada

Posts: 143
iTrader: (0)

I don't have an Excel version, but the formula is (relatively) straightforward:

N = total negotiated price, before taxes, but including all other fees and extras.

C = capitalization cost reduction (e.g. 0 if you are putting $0 down)

P = net price = N - C

R = residual value at the end of lease (vehicle MSRP * residual percentage, regardless of the actual negotiated price, and not including any taxes, freight and PDI, or extras, so for example, on a 335i sedan with metallic paint, a 52% residual is $52,200 * .52 = $27,144)

T = lease term in months (e.g. 36)

M = money factor (APR / 24, so 3.9% = 0.039 / 24 = 0.001625)

D = monthly depreciation cost: =(P - R) / T

F = financing charge =(P + R) * M

P = monthly payment = D + F

P does not include taxes (multiply by 1 + tax rate to get total monthly payment. E.g., in Ontario, Pt = P * 1.13)


Also worth noting is your average monthly cost:

((Pt * F) + C) / F

And total cost over the lease period:

(Pt * F) + C

Not counting any lease turn-in fees or costs for excess wear and tear, replacement tires, etc.

That should be correct, though my brain is not exactly in math mode tonight.
w2 is offline   Canada
0
Reply With Quote
      09-04-2010, 11:21 PM   #3
2kaccordocoupe
Colonel
 
2kaccordocoupe's Avatar
 
Drives: 2009 335i E92 Coupe
Join Date: Nov 2008
Location: GTA

Posts: 2,721
iTrader: (2)

Garage List
2009 e92 335i  [0.00]
^ That pretty much sums it up.
You can also google lease calculators and plug in your values.
__________________
2009 335i E92 Coupe
Manual/Navigation/Executive/Audiophile/Sport/19s
Alpine White/Coral Red Dakota
2kaccordocoupe is offline   Canada
0
Reply With Quote
      09-05-2010, 08:06 PM   #4
Laguna3
E90 NOOB
 
Drives: N55 E92 Msport
Join Date: Jun 2010
Location: 905

Posts: 261
iTrader: (0)

BMW Canada Website has this option after you build your own.
Laguna3 is offline   Canada
0
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
Forum Jump


All times are GMT -5. The time now is 05:20 AM.




e90post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST