|
||||||
|
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. |
![]() |
|
Thread Tools | Display Modes |
#26
|
|||
|
|||
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?
|
Sponsored Links | ||
Advertisement | ||
|
#27
|
||||
|
||||
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.
__________________
|
#29
|
|||
|
|||
Quick question!
I am having problems matching this with my dealer lease info. Does your calculations include monthly tax? Thanks and very useful |
#30
|
|||
|
|||
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! |
#31
|
||||
|
||||
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?
__________________
|
#32
|
|||
|
|||
Thanks! I figured that was the case but wasn't able to find enough info on it.
|
#33
|
||||
|
||||
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? |
#34
|
|||
|
|||
![]() ![]() ![]() 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 ![]() |
#35
|
||||
|
||||
Quote:
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
__________________
|
#36
|
||||
|
||||
Quote:
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.
__________________
|
#37
|
|||
|
|||
Hi guys! I got an offer for a 4series with 8k off msrp. What you guys think about it?
|
#38
|
||||
|
||||
Quote:
What does the spreadsheet say for your negotiating margin after you put in all the other numbers?
__________________
|
#39
|
||||
|
||||
Quote:
My negotiating margin was $1470.77 and I got $1576.45 off. Not bad! Last edited by Beowulf65; 04-04-2015 at 11:59 AM. |
#40
|
||||
|
||||
Excellent - sounds like you walked away with a deal right at dealer invoice. Well done!
__________________
|
#41
|
||||
|
||||
Deleted - double post
__________________
|
#42
|
||||
|
||||
Quote:
![]() |
#43
|
|||
|
|||
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! |
#44
|
||||
|
||||
Quote:
Use the spreadsheet - that's what its for. What is your negotiating margin?
__________________
|
#45
|
||||
|
||||
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.
![]() ![]()
__________________
|
#46
|
||||
|
||||
Quote:
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?
__________________
|
#47
|
||||
|
||||
Quote:
__________________
|
#48
|
||||
|
||||
Quote:
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.
__________________
Last edited by dwlink; 04-08-2015 at 06:04 PM. |
#49
|
||||
|
||||
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 07:22 PM. |
#50
|
||||
|
||||
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?
__________________
|
![]() |
See More Related BMW Stories |
|
Forum Navigation | |||||||
|
Today's Posts Search |
Thread Tools | |
Display Modes | |
|
|