|
|
|
2010 2011 BMW 5 Series Forum F10 535i lease payment calculator |
|
Post Reply |
|
Thread Tools | Search this Thread |
09-15-2010, 07:39 PM | #1 |
New Member
3
Rep 8
Posts |
535i lease payment calculator
Hi all. I'm new to this forum but have found a bunch of useful information and thought I'd give back. Using the wholesale pricing sheet, I created the attached spreadsheet to help you calculate your monthly lease payments for a 2011 535i. All you need to do is select the options/packages you want in the first column (by changing the 0 to a 1), and then the invoice and MSRP totals at the bottom will change accordingly. The options you select will be indicated in red bold text. Note that if you select a package, it will highlight the included options in red bold, but will only add the price of the package (not the individual options). There are two options at the bottom for determining the final lease payment, one that marks up x percent from the invoice price and one that discounts y percent from the MSRP (depending on how you're negotiating your deal). You also need to select the proper base rate (or MF), residual (my dealer quoted me 62%), and tax. I'm sure there are ways to improve this, but since I put the work into it, I thought I'd share with the group. Let me know if there are any questions I can answer about using the sheet, but I'm pretty new to this, so more substantive questions about the ins and outs of the leasing process are probably better directed at more-informed members.
|
09-16-2010, 07:38 AM | #2 |
Occasionally frequent poster
3000
Rep 2,744
Posts |
Very nice. I'll have to take your word for the accuracy of the interest calculation, as it seems too simple to me. Although it appears to generate similar results from the calculators that I've seen on the Internet, so you probably got it right. It appears that you omitted the $750 (I think) fee for the privilege of getting a lease from BMWFS, at least for those of us in the USA.
Thanks for sharing! Michael
__________________
Current inventory:
F22 & G05 Cadillac CT5-V Blackwing w/3 pedals Past: E24,E28(3),E34,E36,E37,E38(2),E39(4),E46,E89,E92 (obviously),F01,F06,F10,F30,F87,G12,G30(2),G82(2) |
Appreciate
0
|
01-16-2011, 11:52 AM | #4 |
New Member
2
Rep 8
Posts |
I have tried downloading the zip file above (I have windows 7) but it says the contents are empty. Does anyone have a valid copy or mind emailing it to me at sethfl at hotmail (dotcom). Or if this is not an option, where can I find accurate invoice pricing. Thx
|
Appreciate
0
|
Post Reply |
Bookmarks |
|
|