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

Thread Tools Search this Thread
      09-04-2010, 07:15 PM   #1
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?

PBureno is offline  
Reply With Quote
      09-04-2010, 08:49 PM   #2
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
Reply With Quote
      09-04-2010, 11:21 PM   #3
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
Alpine White/Coral Red Dakota
2kaccordocoupe is offline   Canada
Reply With Quote
      09-05-2010, 08:06 PM   #4
Drives: N55 E92 Msport
Join Date: Jun 2010
Location: 905

Posts: 260
iTrader: (0)

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


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 07:35 PM.

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