[Brett]

I make no promises... but this should help determine the cost and monthly payment of your new E92 (and estimate the cost for E93's).

Enjoy,
-Brett

PS:
If you are curious about the BMWCCA Discount, make sure to check out:
http://www.bmwcca.org

Feel free to use my membership for reference if you join:
Name: Brett Flury
ID: 362586

It does require 1-year of membership to get the discount.

EDIT: PLEASE SEE NEW THREAD FOR ATTACHMENT
http://www.e90post.com/forums/showth...455#post347455

[335I talian Stallion NJ]

Originally Posted by Brett

I make no promises... but this should help determine the cost and monthly payment of your new E92 (and estimate the cost for E93's).

Enjoy,
-Brett

PS:
If you are curious about the BMWCCA Discount, make sure to check out:
http://www.bmwcca.org

Feel free to use my membership for reference if you join:
Name: Brett Flury
ID: 362586

It does require 1-year of membership to get the discount.

Awesome job! But I don't see auto tranny listed?

[Brett]

Originally Posted by 335I talian Stallion NJ

Awesome job! But I don't see auto tranny listed?

Thanks...

Updated to add Automatic Transmission, and make Leather Standard for Convertibles. Attached at top.

-Brett

[ToddPhilly]

Brett. Nice job and thanks!

FYI: The PMT function automatically calculates the monthly payment given a PV, FV, interest rate, and term.

[Brett]

Originally Posted by ToddPhilly

Brett. Nice job and thanks!

FYI: The PMT function automatically calculates the monthly payment given a PV, FV, interest rate, and term.

Thanks, I knew there was a function, but was too lazy to look it up, plus my trust in MS is lacking .

Anyway, I am glad to see people checking it out. Please let me know if you find any bugs... plus assuming I can get ahold of Wholesale pricing I will try to incorporate that into the calculator.

-Brett

[MoreCowbell]

Nice job on the spreadsheet. Is destination included?

Looks like a lease won't bring us under 700 months any time soon.

[Minimaul]

cool, thanks!

[Jch330]

how would you calculate a lease?

[Straz M3]

This is a finance calculator right, not a lease calculator correct??

[Brett]

Originally Posted by Straz 335

This is a finance calculator right, not a lease calculator correct??

I am not sure of the math behind the lease, I am sure if someone can explain it briefly, I might be able to add it.

I did update it to have destination charge / taxes. But I am going to hold off uploading it, for a few other fixes.

-Brett

[MoreCowbell]

Originally Posted by Brett

I am not sure of the math behind the lease, I am sure if someone can explain it briefly, I might be able to add it.

I did update it to have destination charge / taxes. But I am going to hold off uploading it, for a few other fixes.

-Brett

There are multiple lease calulcators out there. Problem is, we don't have the MF's or residuals to back the estimates up...

[Squawks]

Brett - nice job! Can you please add the wholesale pricing as well? It's already up in the "official E92 pricing" thread. Garnered from Bimmerfest, apparently.

[MoreCowbell]

Originally Posted by Squawks

Brett - nice job! Can you please add the wholesale pricing as well? It's already up in the "official E92 pricing" thread. Garnered from Bimmerfest, apparently.

Invoice won't matter for several months...

[Squawks]

Gluck - really?! Damn!

EDIT: brett - use this for your monthly payment cell...more accurate; same formula used by Bankrate: =PMT(D9/12,D8,D12)

[MoreCowbell]

Originally Posted by Squawks

Gluck - really?! Damn!

Squawks, maybe i'm wrong...but I don't see "1000 over invoice" happening for several months, until there is a good supply around. No?

[antidentite]

Excellent job on the calculator!

Invoice is important to me since I'm going to try to work up from that, not down from MSRP. I may be crazy, but it's worth a shot.

[Squawks]

Originally Posted by gluck75

Squawks, maybe i'm wrong...but I don't see "1000 over invoice" happening for several months, until there is a good supply around. No?

Gluck - sounds right to me. I been out of the loop upon E90's official debut so perhaps the E90 went through the same phase of strict MSRP pricing. This makes Eurodelivery more feasible especially if one desires to land one of these new models quickly!

[Brett]

Originally Posted by Squawks

Also, brett - your "loan value" equation is incorrect. I'm too lazy to search for the formula but what you have inputted isn't correct, thus making the monthly payments higher than it really is.

How is the formula incorrect? I used:

Principal * (1 + Percentage) ^ (Months / 12)

Also, thanks for all the comments guys! I will be updating it tonight to have invoice pricing and I'll see if I can't figure out a way to determine lease payments.

-Brett

[Squawks]

Brett - I edited my post above. It is incorrect. Use this formula instead for calculating your monthly payment: =PMT(D9/12,D8,D12)

Brett - upon looking again at your loan value equation it is indeed correct. Not sure why the monthly payment is off a little, however.

EDIT: You can confirm with Bankrate's calculator - Bankrate will agree with the PMT formula.

[Brett]

Originally Posted by Squawks

Brett - upon looking again at your loan value equation it is indeed correct. Not sure why the monthly payment is off a little, however.

Nah, there was a minor issue. I fixed it so that it agrees with BankRate. Good news is it lowers your payment

So updates:
Slightly Lower Payments
Taxes and Destination Considered in Monthly Payment

-Brett

[335I talian Stallion NJ]

Originally Posted by Brett

Nah, there was a minor issue. I fixed it so that it agrees with BankRate. Good news is it lowers your payment

So updates:
Slightly Lower Payments
Taxes and Destination Considered in Monthly Payment

-Brett

Lookin good Brett... one more thing I noticed... need to add the cost for paddles!

[Pretender]

Configured mine based on invoice + 1000 = $50K, include:
Premium
Sport
Steptronic + paddle shifter
PDC
CA
Power rear sunshade
I-drive with navi.
Space grey metallic
Corel Red interior
Aluminium trim