View Single Post
      07-01-2014, 12:10 AM   #41
E90potentialbuyer
Captain
E90potentialbuyer's Avatar
United_States
165
Rep
798
Posts

Drives: 2015 M5 / 2009 335i xDrive
Join Date: Jan 2013
Location: NYC

iTrader: (0)

Figured I would post my pricing and payment calculator. Feel free to download it, and unzip the excel file to edit. Just update the fields in yellow background. Of course, you will need Microsoft Excel 2007 or newer on your PC / Mac.

it has all the options for the M5 (except the frozen paint schemes) that you can chose from a drop down. You can select which options you want, and it will configure your car, estimate your tax, and your monthly payment. It ONLY works for financing. I have never leased the car and don't intend to, so did not build that in. Feel free to edit and post if someone does that. It also accounts for your trade-in and tax credit from trade-in (you don't pay tax on value of trade-in if you apply it towards your purchase in certain states, NJ including)

You can also plug in the discount for each option, and calculate the discounted price of the car. Feel free to tweak your discount numbers based on your own estimate / knowledge. Sheet will create pricing for both 2014 and 2015 for list and discounted, as well as monthly payments. have fun!
Attached Files
File Type: zip BMW_M5_Price Pmt Estimator Upload.zip (35.5 KB, 601 views)
Appreciate 0