The ultimate check your BMW 3 Series F30 deal thread - Page 2 - Bimmerfest - BMW Forums



Welcome to Bimmerfest -- The #1 Online Community for BMW related information! Please enjoy the discussion forums below and share your experiences with the 200,000 current, new and past BMW owners. The forums are broken out by car model and into other special interest sections such as BMW European Delivery and a special forum to voice your questions to the many BMW dealers on the site to assist our members!

Please follow the links below to help get you started!

Go Back   Bimmerfest - BMW Forums > BMW Model Discussions > 3 Series & 4 Series > F30 / F31 / F32 / F33 / F34 / F36 (2012 - current)

F30 / F31 / F32 / F33 / F34 / F36 (2012 - current)
The sixth generation BMW 3 Series Sedan F30/F31/F34 and the first first generation 4 Series Coupe F32/F33/F36. Get the latest 3 and 4 series pricing from our ordering and pricing guide sticky thread.

Reply
 
Thread Tools
  #26  
Old 03-10-2015, 06:49 PM
bobbydigital bobbydigital is offline
Officially Welcomed to the 'Fest
Location: Seattle, WA
 
Join Date: Jul 2005
Posts: 153
Mein Auto: 2004 Z4 3.0i
Etiquette question: Should I use this thread to get input on my specific lease offer from the dealer, or start my own unique thread cross-linking back to this thread for the xls?
Reply With Quote
  #27  
Old 03-10-2015, 07:15 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Great question - I think it actually may be best to start you own thread and reference this one if you need to even though I wanted to create this to somewhat reduce the volume of "rate my deal" threads.

Problem is that if this thread grows to be pages long, its going to become more difficult to navigate for useful information, though I'll just keep editing the first post with updates to keep it relevant given any important changes to BMW's leasing/financing policies.

So perhaps the spreadsheet provides a means of giving you some basic numbers and the ability to see how those numbers vary with different payment options. This way you can direct your new thread so that its focused more on the payment alternatives you prefer best that you want opinions on.
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #28  
Old 03-10-2015, 07:17 PM
bobbydigital bobbydigital is offline
Officially Welcomed to the 'Fest
Location: Seattle, WA
 
Join Date: Jul 2005
Posts: 153
Mein Auto: 2004 Z4 3.0i
Awesome. Just did that and cross linked back here.

Last edited by bobbydigital; 03-10-2015 at 07:20 PM.
Reply With Quote
  #29  
Old 03-14-2015, 06:52 AM
dfj1bmw dfj1bmw is offline
Registered User
 
Join Date: Nov 2014
Posts: 8
Mein Auto:
Quick question!
I am having problems matching this with my dealer lease info.
Does your calculations include monthly tax?
Thanks and very useful
Reply With Quote
  #30  
Old 03-17-2015, 08:47 AM
Dallasbimmer86 Dallasbimmer86 is offline
Registered User
 
Join Date: Mar 2015
Posts: 4
Mein Auto:
I've searched threads and have not found much info on Vehicle Inventory Tax.

Should I be charged this fee even though I am ordering my vehicle? The dealer is charging $93.40.

Thanks for this spreadsheet!
Reply With Quote
  #31  
Old 03-17-2015, 10:53 AM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
No - the dealer should be eating that fee for not moving their inventory quick enough. Not your fault they cant sell cars so why should you bear the cost?
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #32  
Old 03-17-2015, 10:55 AM
Dallasbimmer86 Dallasbimmer86 is offline
Registered User
 
Join Date: Mar 2015
Posts: 4
Mein Auto:
Thanks! I figured that was the case but wasn't able to find enough info on it.
Reply With Quote
  #33  
Old 03-29-2015, 11:34 AM
Beowulf65's Avatar
Beowulf65 Beowulf65 is offline
Officially Welcomed to the 'Fest
Location: Canada
 
Join Date: Mar 2015
Posts: 844
Mein Auto: 435i xDrive Gran Coupé
Many thanks for this spreadsheet! Two questions:

1. No values show up for 5C - Monthly Payment, Total Interest Paid or Total Cash Out. The fields show "#VALUE!" I cannot edit the fields to input values without a password...or should the spreadsheet be calculating these values?

2. With respect to "Potential Negotiating Margin"...if one receives this amount of discount, has the dealer sold the vehicle for cost?
Reply With Quote
  #34  
Old 03-29-2015, 07:25 PM
Archivist Archivist is offline
Registered User
Location: Colorado
 
Join Date: Dec 2004
Posts: 16
Mein Auto: 2004 X3 2.5 BlueWater
Thumbs up Great Job

Thank YOU Thank YOU Very well done and truly timely as I attempt to "run" numbers for a new 428 convertible!

Is there a simple way of putting in part of the Tax up front? My county insists on collecting the Tax for any Lease at the outset, maybe even for a purchase, but the City & State collect it monthly.

Also entering in the base cost plus options less delivery fee (BMW) does not seem to allow for any negotiations as to discounts that might be offered. I noted a $ 1000 regardless of the price (several different examples) but have received perhaps ~ 6% discount offers from MSRP and also have USAA options.

Thanks again for great work, really took my calcs to a whole new level !
Reply With Quote
  #35  
Old 03-29-2015, 10:14 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by Beowulf65 View Post
Many thanks for this spreadsheet! Two questions:

1. No values show up for 5C - Monthly Payment, Total Interest Paid or Total Cash Out. The fields show "#VALUE!" I cannot edit the fields to input values without a password...or should the spreadsheet be calculating these values?

2. With respect to "Potential Negotiating Margin"...if one receives this amount of discount, has the dealer sold the vehicle for cost?
Negotiating margin is basically the combination of 3 things:

1. The amount you are explicitly paying in excess of dealer cost.
2. Paperwork fees in excess of $200
3. The sum of all interest you would accrue on a lease if the car is leased at a MF higher than BMW's base money factor (changed monthly)

As for the #VALUE issues, something must not be entered correctly. Email me your spreadsheet and I'll take a look
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #36  
Old 03-29-2015, 10:18 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by Archivist View Post
Thank YOU Thank YOU Very well done and truly timely as I attempt to "run" numbers for a new 428 convertible!

Is there a simple way of putting in part of the Tax up front? My county insists on collecting the Tax for any Lease at the outset, maybe even for a purchase, but the City & State collect it monthly.

Also entering in the base cost plus options less delivery fee (BMW) does not seem to allow for any negotiations as to discounts that might be offered. I noted a $ 1000 regardless of the price (several different examples) but have received perhaps ~ 6% discount offers from MSRP and also have USAA options.

Thanks again for great work, really took my calcs to a whole new level !
Unfortunately, I didn't put in any provisions to split the tax into different payment forms. However, what you could do is add in the amount of tax collected up front into the paperwork fees while neglecting the impact it has to the negotiating margin as the tax is non-negotiable.

Just make sure you have the option set so that paperwork fees are not taxed so that you don't double book keep that portion of the overall taxes.
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #37  
Old 03-31-2015, 01:50 PM
335iskokie 335iskokie is offline
Registered User
Location: skokie
 
Join Date: Jun 2008
Posts: 32
Mein Auto: 335i
Hi guys! I got an offer for a 4series with 8k off msrp. What you guys think about it?
Reply With Quote
  #38  
Old 03-31-2015, 02:56 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by 335iskokie View Post
Hi guys! I got an offer for a 4series with 8k off msrp. What you guys think about it?

What does the spreadsheet say for your negotiating margin after you put in all the other numbers?
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #39  
Old 04-04-2015, 10:55 AM
Beowulf65's Avatar
Beowulf65 Beowulf65 is offline
Officially Welcomed to the 'Fest
Location: Canada
 
Join Date: Mar 2015
Posts: 844
Mein Auto: 435i xDrive Gran Coupé
Quote:
Originally Posted by dwlink View Post
Negotiating margin is basically the combination of 3 things:

1. The amount you are explicitly paying in excess of dealer cost.
2. Paperwork fees in excess of $200
3. The sum of all interest you would accrue on a lease if the car is leased at a MF higher than BMW's base money factor (changed monthly)

As for the #VALUE issues, something must not be entered correctly. Email me your spreadsheet and I'll take a look
Thanks dwlink: I reopened the spreadsheet and reentered data and this time the actual values for finance charges worked fine.

My negotiating margin was $1470.77 and I got $1576.45 off. Not bad!

Last edited by Beowulf65; 04-04-2015 at 10:59 AM.
Reply With Quote
  #40  
Old 04-05-2015, 05:28 AM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by Beowulf65 View Post
Thanks dwlink: I reopened the spreadsheet and reentered data and this time the actual values for finance charges worked fine.

My negotiating margin was $1470.77 and I got $1576.45 off. Not bad!
Excellent - sounds like you walked away with a deal right at dealer invoice. Well done!
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #41  
Old 04-05-2015, 05:35 AM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Deleted - double post
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #42  
Old 04-05-2015, 08:04 AM
Beowulf65's Avatar
Beowulf65 Beowulf65 is offline
Officially Welcomed to the 'Fest
Location: Canada
 
Join Date: Mar 2015
Posts: 844
Mein Auto: 435i xDrive Gran Coupé
Quote:
Originally Posted by dwlink View Post
Excellent - sounds like you walked away with a deal right at dealer invoice. Well done!
Thanks...now if my wife and I can just stand the wait until it arrives...
Reply With Quote
  #43  
Old 04-07-2015, 05:12 PM
335iskokie 335iskokie is offline
Registered User
Location: skokie
 
Join Date: Jun 2008
Posts: 32
Mein Auto: 335i
Hey guys! Can you kindly check out the offer I got from a dealer.
335i
36 months
$61,235 MSRP
$58,235 selling price
7 multiple security deposits .00081 MF
8.25% monthly
$690 a month
Thanks!
Reply With Quote
  #44  
Old 04-08-2015, 12:06 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by 335iskokie View Post
Hey guys! Can you kindly check out the offer I got from a dealer.
335i
36 months
$61,235 MSRP
$58,235 selling price
7 multiple security deposits .00081 MF
8.25% monthly
$690 a month
Thanks!

Use the spreadsheet - that's what its for. What is your negotiating margin?
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #45  
Old 04-08-2015, 01:05 PM
Mykatie's Avatar
Mykatie Mykatie is offline
2015 328x
Location: New York
 
Join Date: Aug 2012
Posts: 1,424
Mein Auto: 2015 BMW 328i xdrive seda
I just NEED to say once again GREAT JOB! I wish I could buy you a drink. I have never used excel in my life. I am not great with numbers. I read your instructions and it worked perfect on the first attempt. Looks like I did well also, I have a $44.50 negotiating margin.
__________________
Reply With Quote
  #46  
Old 04-08-2015, 02:50 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by Mykatie View Post
I just NEED to say once again GREAT JOB! I wish I could buy you a drink. I have never used excel in my life. I am not great with numbers. I read your instructions and it worked perfect on the first attempt. Looks like I did well also, I have a $44.50 negotiating margin.

Thank you - glad to hear you were able to put it to good use.

Mind sharing your sales numbers as a validation point for my negotiating margin calcs?
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)
Reply With Quote
  #47  
Old 04-08-2015, 03:26 PM
Mykatie's Avatar
Mykatie Mykatie is offline
2015 328x
Location: New York
 
Join Date: Aug 2012
Posts: 1,424
Mein Auto: 2015 BMW 328i xdrive seda
Quote:
Originally Posted by dwlink View Post
thank you - glad to hear you were able to put it to good use.

Mind sharing your sales numbers as a validation point for my negotiating margin calcs?
Click image for larger version

Name:	ExcelBMW1.jpg
Views:	722
Size:	155.5 KB
ID:	502631
__________________
Reply With Quote
  #48  
Old 04-08-2015, 05:01 PM
dwlink's Avatar
dwlink dwlink is offline
Officially Welcomed to the 'Fest
Location: St. Louis
 
Join Date: May 2007
Posts: 2,594
Mein Auto: 435i Gran Coupe
Quote:
Originally Posted by Mykatie View Post
FYI you'll save approximately $360 over the life of the lease if you allocate your $1000 down to 2 extra security deposits instead. This does assume, however, that you'll get your full SD back. This is about a 11% annual return which if you factor in taxes makes it more like a 13-14% annual return - that rivals many well performing equity indices.

While the algebraic proof is incredibly ugly when taking into account all the variables used in the spreadsheet, it does work out that given the typical range of leasing figures, total cash spent on the lease is minimized by allocating money first towards security deposits, then any remaining towards a down payment.

However, not included in that math is risk. Should you return the car with substantial damage (very unlikely), BMW will already have a good chunk of your money in their pockets if you max out your SDs. In the end you'd likely be on the hook for it anyways so I guess you could argue its a moot point.
__________________

2015 BMW 435i GC MSport (ED Sept 29, 2014)
2004 BMW 530i (retired)

Last edited by dwlink; 04-08-2015 at 05:04 PM.
Reply With Quote
  #49  
Old 04-08-2015, 05:13 PM
Mykatie's Avatar
Mykatie Mykatie is offline
2015 328x
Location: New York
 
Join Date: Aug 2012
Posts: 1,424
Mein Auto: 2015 BMW 328i xdrive seda
The $1000 is from the UDE autocross event. The dealer said the $1,000 credit for attending the event will be applied to the cap cost reduction. The spread sheet allows me to assure that I am paying what I sb when the figures popped in the cells. As far as getting what I think will be a fair price I will use Edmunds and or similar. Tried to work out figures that needed a different sales tax rate and the cell is now locked. It is requesting a password to change that cell.
__________________

Last edited by Mykatie; 04-08-2015 at 06:22 PM.
Reply With Quote
  #50  
Old 04-10-2015, 08:14 PM
Mykatie's Avatar
Mykatie Mykatie is offline
2015 328x
Location: New York
 
Join Date: Aug 2012
Posts: 1,424
Mein Auto: 2015 BMW 328i xdrive seda
Tried to work out figures that needed a different sales tax rate and the cell is now locked. It is requesting a password to change that cell. Anyone else get that issue?
__________________
Reply With Quote
Reply

See More Related BMW Stories


Forum Navigation
Go Back   Bimmerfest - BMW Forums > BMW Model Discussions > 3 Series & 4 Series > F30 / F31 / F32 / F33 / F34 / F36 (2012 - current)
Today's Posts Search
Thread Tools

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 On



Forum Jump


All times are GMT -7. The time now is 01:07 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
© 2001-2015 performanceIX, Inc. All Rights Reserved .: guidelines .:. privacy .:. terms