E90Post
 


TNT Racewerks
 
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
Second Lieutenant
22
Rep
235
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
Brigadier General
2kaccordocoupe's Avatar
Canada
1270
Rep
4,703
Posts

Drives: Former ///M Driver
Join Date: Nov 2008
Location: The 6ix

iTrader: (2)

^ That pretty much sums it up.
You can also google lease calculators and plug in your values.
Appreciate 0
      09-05-2010, 08:06 PM   #4
Laguna3
Second Lieutenant
Canada
20
Rep
266
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



All times are GMT -5. The time now is 12:28 AM.




e90post
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
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