BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read
BMW M2 Forum > Pricing / Ordering / European Delivery / PCD > BMW Select Excel Payment Calculator

Post Reply
 
Thread Tools Search this Thread
      03-24-2016, 12:14 AM   #1
paradoxical3
Lieutenant Colonel
1008
Rep
1,563
Posts

Drives: BMW
Join Date: Mar 2012
Location: USA

iTrader: (6)

BMW Select Excel Payment Calculator

Seeing as how it's pretty annoying to figure out what payments are via BMW Select financing, I went ahead and took a stab at making an excel calculator. This should make it much easier, but I would appreciate having someone double check my formulas. I believe they are correct though and I have worked it backwards to verify. This calculator really shows how much the 2.99% apr sucks compared to the .99%...it's a solid $65 monthly difference.

https://dl.dropboxusercontent.com/u/...alculator.xlsx
Appreciate 0
      03-25-2016, 08:21 AM   #2
M3 Adjuster
Banned
Albania
7905
Rep
11,785
Posts

Drives: 1M, X1 M Sport, E46 325ic
Join Date: Mar 2008
Location: Dallas, Tx

iTrader: (0)

Quote:
Originally Posted by paradoxical3
Seeing as how it's pretty annoying to figure out what payments are via BMW Select financing, I went ahead and took a stab at making an excel calculator. This should make it much easier, but I would appreciate having someone double check my formulas. I believe they are correct though and I have worked it backwards to verify. This calculator really shows how much the 2.99% apr sucks compared to the .99%...it's a solid $65 monthly difference.

https://dl.dropboxusercontent.com/u/...alculator.xlsx
2.99 is a horrible rate.

You could use 3.99 to make it even look worse.

I mean seriously.....

@1M Tex and I were just talking two days ago and he found a 1.49 rate for 60 months and I know I can get 1.99 for 84 months ...
Appreciate 0
      03-28-2016, 06:40 PM   #3
ACZakka325i
Colonel
ACZakka325i's Avatar
276
Rep
2,008
Posts

Drives: 2 stroke
Join Date: Jul 2005
Location: CT

iTrader: (2)

Quote:
Originally Posted by M3 Adjuster View Post
2.99 is a horrible rate.

You could use 3.99 to make it even look worse.

I mean seriously.....

@1M Tex and I were just talking two days ago and he found a 1.49 rate for 60 months and I know I can get 1.99 for 84 months ...
I think 2.99 is conservative and fairly middle-of-the-road. I think most with excellent credit can find 1.99.

84mo car loan?
__________________
(Waitlist): #1 M2CSL
(Current): 2016 F15 X5 3.5xdrive - 2010 997.2 C4S Coupe
(Past): 2016 F30 340xi M-Sport -2013 535i xdrive
2008 E92 M3 - 2006 E90 325i
2002 E46 325xi - 1991 E30 325i
Appreciate 0
      03-28-2016, 07:00 PM   #4
M3 Adjuster
Banned
Albania
7905
Rep
11,785
Posts

Drives: 1M, X1 M Sport, E46 325ic
Join Date: Mar 2008
Location: Dallas, Tx

iTrader: (0)

Quote:
Originally Posted by ACZakka325i
Quote:
Originally Posted by M3 Adjuster View Post
2.99 is a horrible rate.

You could use 3.99 to make it even look worse.

I mean seriously.....

@1M Tex and I were just talking two days ago and he found a 1.49 rate for 60 months and I know I can get 1.99 for 84 months ...
I think 2.99 is conservative and fairly middle-of-the-road. I think most with excellent credit can find 1.99.

84mo car loan?
Nothjng wrong with making the required minimum payment as low as possible.

One can always pay it off sooner by paying more than the minimum or by making additional payments.

And who cares if it's 108 months when the interest rate is 1.99 percent lol... Darn near free money.
Appreciate 0
      03-29-2016, 10:24 AM   #5
paradoxical3
Lieutenant Colonel
1008
Rep
1,563
Posts

Drives: BMW
Join Date: Mar 2012
Location: USA

iTrader: (6)

84 month loan makes a ton of sense on the M2 if you get a good APR and put down a large down payment to ensure you are not upside down, since the lease rates are so terrible.
Appreciate 1
      03-29-2016, 10:35 AM   #6
confusion
Captain
confusion's Avatar
United_States
601
Rep
836
Posts

Drives: 2016 M2
Join Date: Dec 2007
Location: Austin, TX

iTrader: (0)

Quote:
Originally Posted by paradoxical3 View Post
84 month loan makes a ton of sense on the M2 if you get a good APR and put down a large down payment to ensure you are not upside down, since the lease rates are so terrible.
Putting a large deposit down makes no sense when financing can be had for under 2%. Going upside down will largely depend on the resale value of the car while it is in limited supply. I would be willing to bet that the depreciation curve of the car will actually float above the loan balance for the duration of the loan even with an extended term like 84 months.
Appreciate 0
      03-29-2016, 10:37 AM   #7
dmk08
Gone Fishin’
dmk08's Avatar
United_States
7315
Rep
12,125
Posts

Drives: Walks
Join Date: Jul 2012
Location: Atlanta

iTrader: (19)

Quote:
Originally Posted by confusion View Post
Putting a large deposit down makes no sense when financing can be had for under 2%. Going upside down will largely depend on the resale value of the car while it is in limited supply. I would be willing to bet that the depreciation curve of the car will actually float above the loan balance for the duration of the loan even with an extended term like 84 months.
Yeah not sure why you would put a large chunk of cash down on Select if you can get the .9 rate. Or is that only for M3/M4?
Appreciate 0
      03-29-2016, 11:11 AM   #8
F87LUV
Lieutenant General
F87LUV's Avatar
United_States
3688
Rep
15,081
Posts

Drives: '16 M2, '23 GT4
Join Date: May 2007
Location: NJ

iTrader: (4)

Garage List
2023 Porsche GT4  [5.00]
2016 BMW M2  [8.66]
Quote:
Originally Posted by dmk08
Quote:
Originally Posted by confusion View Post
Putting a large deposit down makes no sense when financing can be had for under 2%. Going upside down will largely depend on the resale value of the car while it is in limited supply. I would be willing to bet that the depreciation curve of the car will actually float above the loan balance for the duration of the loan even with an extended term like 84 months.
Yeah not sure why you would put a large chunk of cash down on Select if you can get the .9 rate. Or is that only for M3/M4?
Rate is 2.99 or if you go to my dealer it's supposedly 3.99%.

Penfed is using a 50% residual with a 2.49 apr.
__________________
IG: Trackinheels
Appreciate 0
      03-29-2016, 11:19 AM   #9
dmk08
Gone Fishin’
dmk08's Avatar
United_States
7315
Rep
12,125
Posts

Drives: Walks
Join Date: Jul 2012
Location: Atlanta

iTrader: (19)

Quote:
Originally Posted by ZGirl07 View Post
Rate is 2.99 or if you go to my dealer it's supposedly 3.99%.

Penfed is using a 50% residual with a 2.49 apr.
Ahh that sucks. I got my new M4 ZCP locked in at .9 w/ BMWFS
Appreciate 0
      03-29-2016, 11:36 AM   #10
F87LUV
Lieutenant General
F87LUV's Avatar
United_States
3688
Rep
15,081
Posts

Drives: '16 M2, '23 GT4
Join Date: May 2007
Location: NJ

iTrader: (4)

Garage List
2023 Porsche GT4  [5.00]
2016 BMW M2  [8.66]
Quote:
Originally Posted by dmk08
Quote:
Originally Posted by ZGirl07 View Post
Rate is 2.99 or if you go to my dealer it's supposedly 3.99%.

Penfed is using a 50% residual with a 2.49 apr.
Ahh that sucks. I got my new M4 ZCP locked in at .9 w/ BMWFS
It definitely does suck. BMW is doing its very best at getting everyone to give up on the M2 and move up into an M3/4. . My dealer was shocked when I didn't accept 3.99%. Sorry guy, i wasn't born yesterday and I have elite credit- please.
__________________
IG: Trackinheels
Appreciate 1
      03-29-2016, 12:06 PM   #11
paradoxical3
Lieutenant Colonel
1008
Rep
1,563
Posts

Drives: BMW
Join Date: Mar 2012
Location: USA

iTrader: (6)

Yeah if the rate was .99 I would put zero down.
Appreciate 0
      03-29-2016, 12:43 PM   #12
clubsport
First Lieutenant
204
Rep
365
Posts

Drives: LBB
Join Date: Jan 2008
Location: Sunny West Coast

iTrader: (0)

Quote:
Originally Posted by ZGirl07 View Post
Rate is 2.99 or if you go to my dealer it's supposedly 3.99%.

Penfed is using a 50% residual with a 2.49 apr.

I have called Penfed numerous times to get a 'payment saver' rate. They say the car is too new. I get the 1.99 for 48/60 and 2.74 for longer.

April rates from BMWNA might be different/better. March rates were useless since there was no release.

Last edited by clubsport; 03-29-2016 at 12:44 PM.. Reason: added text
Appreciate 0
      03-29-2016, 12:47 PM   #13
F87LUV
Lieutenant General
F87LUV's Avatar
United_States
3688
Rep
15,081
Posts

Drives: '16 M2, '23 GT4
Join Date: May 2007
Location: NJ

iTrader: (4)

Garage List
2023 Porsche GT4  [5.00]
2016 BMW M2  [8.66]
Quote:
Originally Posted by clubsport
Quote:
Originally Posted by ZGirl07 View Post
Rate is 2.99 or if you go to my dealer it's supposedly 3.99%.

Penfed is using a 50% residual with a 2.49 apr.

I have called Penfed numerous times to get a 'payment saver' rate. They say the car is too new. I get the 1.99 for 48/60 and 2.74 for longer.

April rates from BMWNA might be different/better. March rates were useless since there was no release.
Do you have your VIN? Apply online, add the vin and add the car as an M3. Call them after its processed and tell them it's an M2. Not M235 or M3 (theyll ask you if it's either). The app will go to a senior loan officer and they'll determine the value. If you're not taking delivery 4/16 then just wait. I wanted everything done so whenever the dealer is allowed to give me the car, I can walk in and it's a done deal. If April really is better, I'll change my financing then but it's doubtful. As of now, penfed using a 50% residual and a 2.49% rate. Take my word for it.
__________________
IG: Trackinheels
Appreciate 1
      03-29-2016, 02:04 PM   #14
M3 Adjuster
Banned
Albania
7905
Rep
11,785
Posts

Drives: 1M, X1 M Sport, E46 325ic
Join Date: Mar 2008
Location: Dallas, Tx

iTrader: (0)

Quote:
Originally Posted by paradoxical3
Yeah if the rate was .99 I would put zero down.
With 1.49 or 1.99 loan rates out there , the best thing is to put down what you want to.


Those that are the type that don't want a payment and know they will love it can throw a chunk down.


Those that Want to " lease " an M2 or if you want to " lease to own " then use the owners choice or just. finance it with as long as terms as possible and then plan to sell it in 2-4 years.

If you are really smart you'll use a credit union and not a bank...

As an M car it's clearly going to have good resale value. As a highly Desired car , it will likely have excellent resale value.
Appreciate 0
      07-05-2019, 09:50 AM   #15
phoenixbmwlife
Brigadier General
phoenixbmwlife's Avatar
United_States
1912
Rep
4,128
Posts

Drives: M235i & G30 540i
Join Date: Mar 2007
Location: Boynton Beach

iTrader: (0)

Garage List
2014 BMW/M235i  [0.00]
Quote:
Originally Posted by paradoxical3 View Post
Seeing as how it's pretty annoying to figure out what payments are via BMW Select financing, I went ahead and took a stab at making an excel calculator. This should make it much easier, but I would appreciate having someone double check my formulas. I believe they are correct though and I have worked it backwards to verify. This calculator really shows how much the 2.99% apr sucks compared to the .99%...it's a solid $65 monthly difference.

https://dl.dropboxusercontent.com/u/...alculator.xlsx
Anyway you can get this uploaded again? I'd really like to get this select excel calculator. The link is broken but yeah 3 years will do that.
__________________
Lack of money is not the problem. It is merely a symptom of what's going on inside of you! - T Harv Eker

Follow me on Insta

https://www.instagram.com/bmwm_life_/
https://www.instagram.com/autogiftua/
https://www.instagram.com/phoenixbmwlife/
Appreciate 0
      07-05-2019, 01:18 PM   #16
Bimmer28312
Major
Bimmer28312's Avatar
United_States
341
Rep
1,122
Posts

Drives: BMW N55 335xi
Join Date: Oct 2013
Location: United States

iTrader: (0)

Interested as well
Appreciate 0
      05-26-2021, 02:59 PM   #17
fryrice
Enlisted Member
United_States
14
Rep
34
Posts

Drives: M2c
Join Date: Jul 2017
Location: Boston, MA

iTrader: (0)

I guess OP is no longer updating the calc? I would like to run my numbers against it to see if my dealer is F-ing with me
Appreciate 0
      05-26-2021, 05:51 PM   #18
SilverDust
Private
SilverDust's Avatar
35
Rep
95
Posts

Drives: Waiting on an SO F87 6MT
Join Date: Sep 2015
Location: Nashville, TN

iTrader: (0)

Here is a basic calculator I made... Its not exactly right but its close enough
Attached Files
File Type: zip balloon.xlsx 2.zip (13.6 KB, 116 views)
Appreciate 0
      05-26-2021, 05:52 PM   #19
SilverDust
Private
SilverDust's Avatar
35
Rep
95
Posts

Drives: Waiting on an SO F87 6MT
Join Date: Sep 2015
Location: Nashville, TN

iTrader: (0)

Btw - I think you snagged the allocation my dealer was trying to get for me. Congrats!
Appreciate 0
Post 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 01:30 AM.




m2
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