Pen and Pencil Lease Payment Calculation

Pencil-and-paper worksheet.

Since the lease worksheet breaks out the depreciation vs financing, why do dealers charge state sales tax on the interest portion (determined by the MF)?

Originally Posted by BayAreaBMWFan

Since the lease worksheet breaks out the depreciation vs financing, why do dealers charge state sales tax on the interest portion (determined by the MF)?

Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.

Originally Posted by Jon Shafer

Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.

Gas Guzzler tax is also an "option" (albeit a mandatory one) added into the final MSRP, and not listed seperately as a tax, so you pay tax on that too...

You'll also pay tax on the acqusition fee upfront (or as part of the payment of you capitalize the fee), and tax on any fees at the end of the lease. This is not BMWFS's doing, though... they're just complying with tax laws put in front of them.

Originally Posted by Jon Shafer

Yes, the rent charge is applied to the cap cost plus the residual.

Use tax is applied to the sum of those two figures.

Tax is also applied at maturity to any excess mileage.

Back when we had luxury tax (remember that?) in some states you
had sales tax charged on top of capitalized (financed) luxury tax...

That was double taxation.

actually jon, that was at least triple taxation, assuming that one had already paid income tax on the money used to purchase the car

Originally Posted by Jon Shafer

Pencil-and-paper worksheet.

In the worksheet (section 2B) for the residualizable options it mentions a handbook. Any chance you have the handbook also?

Would anyone find benefit in having this be 'interactive' with form fields and the like? I might put one together.

Originally Posted by webguy330i

Would anyone find benefit in having this be 'interactive' with form fields and the like? I might put one together.

Yes!!!!

Please do it!!!!


:-)))

Originally Posted by Jon Shafer

Yes!!!!

Please do it!!!!


:-)))

Ask and ye shall receive! It's not *exactly* the same though... different fields, different names...

I made it an excel doc, might make an HTML version later for compatibility. Can you check it over and let me know if you see any discrepencies or problems?

Right-click, save as...

http://images.330i.net/media/lease_calculator.xls

Oh and some notes:

- yes this is a reincarnation of the old skewl XLS doc I once found a long long time ago on roadfly
- you only need to change the numbers at the top under the "Adjust these..." section
- you can now account for paying tax up front or monthly, paying acquisition up front or monthly, and paying excess mileage charges up front/monthly/at termination
- I tested it quite a bit but I could have missed something. Everything seems to line up with the general leasing formulas and quotes I've seen
- YMMV

Originally Posted by webguy330i

....
Right-click, save as...

http://images.330i.net/media/lease_calculator.xls

Thanks

Originally Posted by JonS

Pencil-and-paper worksheet.

Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?

Originally Posted by Pete Largo

Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?

Unfortunately, such a handbook is no longer published per se, but
has been replaced by e-bulletins only found on the BMWFS Infobahn
for retail centers...

Originally Posted by Pete Largo

Thanks for the worksheet!

Can you post a copy of the 'Handbook' that the worksheet refers to by any chance?

I've got a hard copy of the Handbook that dates back to 2001 that I keep around for "quick reference", and it's 83 pages--- not a small file that I could easily "post" here. Otherwise, like Jon says, the info is available in the form of many bulletins/.pdf's on BMWFS Infobahn, the website for BMW dealers. You need to work for a dealer and have appropriate authorization to get access to it, it's not just available to anyone.

Oh well, I tried

How accurate is the lease calculator posted here - the numbers I'm getting back rom the dealer is significantly different than being plugged into the tool - no offense to the great work done - just if someone who has the knowledge to do a manual comparison it would be great.
Wait - the posting below must be the issue.

Originally Posted by wajiheffendi

Hi. I just checked out your lease spreadsheet, it's great but it doesn't take into account the tax calculation for states like Texas, where the entire vehicle's purchase price is taxed regardless if you are leasing or buying...any chance you could add it or give me a non-password protected version so I could make the change myself....?

thanks!
-wajih

Originally Posted by turpiwa

How accurate is the lease calculator posted here - the numbers I'm getting back rom the dealer is significantly different than being plugged into the tool - no offense to the great work done - just if someone who has the knowledge to do a manual comparison it would be great.
Wait - the posting below must be the issue.

I am getting different numbers aswell. The dealer is always higher. I've checked the car against ordering guide and I am getting the Z4 3.0si at invoice with prem, sport, HSeats, Xenon, and Nav. I am rolling the taxes and fees into the monthly payments and the dealer is quoting me $566 a month while the calculator is showing $538.

Has the calculator been upgraded anywhere to reflect states where you get bent over with sales tax on the full purchase price of the car?

I believe this is true for the state of New York?? Just click the NY button.

I've got a very simple excel spreadhseet for calculating lease costs - can someone advise on how I can upload it? Trying to attach as an image doesn't work.

Originally Posted by stiffy1

I've got a very simple excel spreadhseet for calculating lease costs - can someone advise on how I can upload it? Trying to attach as an image doesn't work.

You can't upload it directly to 'Fest...it isn't one of the sanctioned files. You need to upload to some other public server and provide us the link to that.

Give this a try. I took a picture of the spreadsheet, and added text boxes (colored in flesh tone) to provide the formula. Excel has the ability to compute lease payments, and I just added the other info. In Ontario, taxes are added to the lease payment, after everything else is calculated. I suppose this will require entering all the info into a spreadsheet, but it makes for an quick and accurate calculator. Good luck.

Originally Posted by stiffy1

Give this a try. I took a picture of the spreadsheet, and added text boxes (colored in flesh tone) to provide the formula. Excel has the ability to compute lease payments, and I just added the other info. In Ontario, taxes are added to the lease payment, after everything else is calculated. I suppose this will require entering all the info into a spreadsheet, but it makes for an quick and accurate calculator. Good luck.

Can you change the name of the file to something sanctioned like a .jpg and then ask folks to save it as a .xls.

Here it is as a .jpg. Try to save it as an .xls file though I don't think that'll work. If not, I'd be glad to email it as an excel file to anyone interested.

The ED spreadsheet has some potential.

But I'm confused by some of the values already in there, like the base ED invoice price. Is that suppose to reflect the actual price or just some sample numbers?

Likewise, the prices for the options seem to be off. Like Premium Package would be $2000 or $2640, depending on whether it's a 330i or a 325i.

Also, not all options are listed. Didn't see Comfort Access or the Rear Power Shade.

One thing which might be nice is to be able to enter a sales tax rate and have it calculate that within the monthly payment and the driveoff costs.