E90Post
 


 
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
5
Rep
178
Posts

 
Drives: BMW
Join Date: Sep 2007
Location: Earth

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
Appreciate 0
      09-04-2010, 08:49 PM   #2
w2
Private First Class
Canada
1
Rep
143
Posts

 
Drives: 335i coupe
Join Date: Apr 2008
Location: Ottawa, Canada

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.
Appreciate 0
      09-04-2010, 11:21 PM   #3
2kaccordocoupe
Colonel
2kaccordocoupe's Avatar
Canada
31
Rep
2,721
Posts

 
Drives: 2009 335i E92 Coupe
Join Date: Nov 2008
Location: GTA

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
Appreciate 0
      09-05-2010, 08:06 PM   #4
Laguna3
E90 NOOB
Canada
4
Rep
260
Posts

 
Drives: N55 E92 Msport
Join Date: Jun 2010
Location: 905

iTrader: (0)

BMW Canada Website has this option after you build your own.
Appreciate 0
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 02:38 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