2010 2011 BMW 5 Series Forum F10
BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read
 

2010 2011 BMW 5 Series Forum F10 BMW 5-Series (F10) Forums F10 Pricing, Ordering, and Tracking (and European Delivery) My 550i USA Pricing and Leasing Worksheet
Post Reply
 
Thread Tools Search this Thread
      04-21-2010, 08:52 AM   #1
SleepTight
Second Lieutenant
SleepTight's Avatar
United_States
33
Rep
287
Posts

Drives: 2013 BMW M5
Join Date: Dec 2009
Location: Long Island, New York

iTrader: (0)

My 550i USA Pricing and Leasing Worksheet

I have an Excel spreadsheet that I created for my own personal use in computing 550i pricing and leasing. The file is attached in zipped format.

My sources of information for the spreadsheet are postings on this forum with a special shout out to Warden and Pharding for providing us with the "crown jewels" of BMWNA pricing and leasing information. As usual, I assume 2%-3% over invoice as the best possible deal you can get on a brand new BMW model like the F10. I also had to estimate gas guzzler tax since that's still to be determined.

I haven't locked any of the cells so if you spot a mistake, please feel free to correct it and post the corrected spreadsheet back up.

The spreadsheet uses the New York method of computing sales tax on a lease (tax on total lease payments plus cap cost reduction) so use caution when computing sales tax in another state.

It should go without saying that you use this spreadsheet at your own risk and that I'm not responsible for any errors in either information presented or mathematical formulas.

Have fun.
Attached Files
File Type: zip 2011 BMW 550i Pricing and Leasing Worksheet.zip (9.1 KB, 528 views)
Appreciate 0
      04-26-2010, 09:40 PM   #2
SleepTight
Second Lieutenant
SleepTight's Avatar
United_States
33
Rep
287
Posts

Drives: 2013 BMW M5
Join Date: Dec 2009
Location: Long Island, New York

iTrader: (0)

211 views and not a single comment! Does it work? Is everybody happy with it?
Appreciate 0
      05-02-2010, 11:43 AM   #3
Tim2189
Russian in a Bimmer
Tim2189's Avatar
United_States
565
Rep
5,619
Posts

Drives: X5 M50i
Join Date: Jul 2008
Location: Brooklyn NY

iTrader: (3)

thanksss
do you have the prices for 535?
__________________
2013 X6 - retired
2015 X6 - retired
2015 435GC - retired
2018 X5 40e - retired
2020 X5 M50i - Current
Appreciate 0
      05-06-2010, 06:46 AM   #4
pharding
Major
307
Rep
1,128
Posts

Drives: 23 Audi Q4 e-tron + 14 X3 28i
Join Date: Mar 2005
Location: Chicago

iTrader: (0)

For whatever the zip files will not unzip with either of 2 dominant zip software.
__________________
23 Audi Q4 e-tron; 23 i4 M50 on order
14 X3
Retired: 20 Tesla Model 3 LR AWD; 17 540i x; 14 550i Euro Del; 11 550i Euro Del; 08 550i Euro Del; 06 330i Euro Del; 04 545i Euro Del; 01 530i Euro Del
Appreciate 0
      05-07-2010, 08:22 AM   #5
stevenross
General
stevenross's Avatar
37
Rep
431
Posts

Drives: a ride
Join Date: Oct 2009
Location: NYC - Bayside

iTrader: (1)

Garage List
2011 BMW M3  [10.00]
2008 BMW X5 3.Slow  [0.00]
Quote:
Originally Posted by pharding View Post
For whatever the zip files will not unzip with either of 2 dominant zip software.
+1
Appreciate 0
      05-07-2010, 08:41 AM   #6
SleepTight
Second Lieutenant
SleepTight's Avatar
United_States
33
Rep
287
Posts

Drives: 2013 BMW M5
Join Date: Dec 2009
Location: Long Island, New York

iTrader: (0)

Hmmm, something about the upload process is causing the file to become courrupted let me work on it.

Edit You can download it here:

http://www.scribd.com/doc/31051834/2...sing-Worksheet

Last edited by SleepTight; 05-07-2010 at 03:30 PM..
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 07:43 PM.




5post
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