Pen and Pencil Lease Payment Calculation

What about the Acquision Fee, $625 as of Aug 24, 2007 for BMW FS?

It's in the spreadsheet under Inception Fee/Acquisition fee, if I correctly interpreted your question.

Originally Posted by webguy330i

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

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

Thanks

where is the link to v 1.04? I see it described, but no link. thanks.

Awesome job on the lease spreadsheet. Used it during lease negotiation over weekend. I actually had the spreadsheet open on my laptop on the CAs desk during the negotiation and was able to use it to reach fair agreement with dealer tweaking the deal parameters while ensuring there was fair profit in it for dealer and good value in deal for myself.

First time I left a car negotiation without feeling I'd been raped.

Nice job!

When you calculate a lease, do you always use full MSRP for the residual calculation regardless of what you actually pay for the car?

yes including delivery

Originally Posted by joelk01

yes including delivery

Thank you

We're going to sign our lease in the next week or two and so I am filling up my lease spreadsheet so I can compare numbers with my CA.

Had a couple of questions I need some help on:

1. How is the Security Deposit amount calculated? ...is it just the monthly payment rounded up to the nearest 50?

2. Is the "LRFS Assignment Fee" the same as the "acquisition fee"? If so, it looks like it is part of the LRFS is part of the Cap Cost in the BMWFS worksheet but doesn't seem to be accounted for in the excel spreadsheet that some have posted.

Appreciate the help.

wow this is the best tool ever. I am so prepared when I'm going in to pick up my car and do all the paper work today. TY so much bimmerfest.

Could someone spot a light for me please? In the lease calculation spreadsheet, there is an option to either roll the sales tax to the monthly payment or pay it upfront with some saving.

Are we really allow to do so? I am trying to nail the lease here in California and the dealer here told me it is not doable.

Any thoughts?

Really apprieciate for any inputs!

Thanks a lot!

i-SpY

Originally Posted by iSpY

Could someone spot a light for me please? In the lease calculation spreadsheet, there is an option to either roll the sales tax to the monthly payment or pay it upfront with some saving.

Are we really allow to do so? I am trying to nail the lease here in California and the dealer here told me it is not doable.
i-SpY

In CA the tax is based on the monthly payment, paid monthly. No other option.

The first sheet does not update when I configure the car on page 2. I have it saved as an Excel spreadsheet, any suggestions?

can someone post the spreadsheet again please? I cant seem to find it in this thread.
THANKS
- M

Try this: http://www.leaseguide.com/calc.htm
It also explains a lot about leasing.

Here it is:

Example Calculation Using the Leasing Formula
So now that we've looked at the formula, let's see how it actually works.

Let's assume you've decided on 3-year (36 month term) lease of a Toyota Camry XLE that has a sticker price of $24,600 (MSRP).

You've managed to negotiate the price down to $23,000 (Cap Cost). You decide not to make a down payment, but you have a trade-in worth $5000. Your Net Cap Cost is therefore $23,000 - $5000 = $18,000.

Now, the dealer tells you (because you asked) that the Money Factor is .00375 (.00375 x 2400 = 9.0%) and the Residual Percentage is 60% of MSRP. So your Residual amount, in dollars, is .60 x $24,600 = $14,760.

Now let's do the math:
Depreciation Fee = ( $18,000 – $14,760 ) ÷ 36 = $90.00
Finance Fee = ( $18,000 + $14,760 ) × .00375 = $122.85
-
Monthly Lease Payment = $90.00 + $122.85 = $212.85 (sales tax not included)

Lease calculator is fantastic :-) Thank you!

just wanted to check - for a 328i, $1000 over invoice, 74% residual, 167 money factor - i calculate something like 442/month no money down or MSD before taxes, but they are quoting me 483/month including taxes - if what i read here is correct - is use tax on cap cost + residual? i.e. 5% * ($35000ish plus $27000ish)? wow....

still, i can't seem to figure out the difference of $40/month given the same numbers....is tax really $40/month for $442/month payment?

PS this is the state of Massachusetts...

Just a comment on how sales tax is applied up front rather than as monthly/use tax in VA and MD (not DC). After struggling with numerous calculators found online, including the earlier one in this thread, I found they do not properly calculate taxes, even if you select NY. When using the sheet that Jon posted and punching into my own very simple calculator it came out almost exactly as the dealer has been quoting me.

When rolling in tax in this state it gets added to the selling price to make up the gross cap cost.

Hi,

I went to a dealer and asked to lease a 335i with European delivery. These are the options.

Premium package
Ipod and usb
sport package
cold weather
paddle shifters
navigation
comfort access
auto transmission

No money down 36month/36000 miles. 71/2% tax rate rolled in. He quoted me a a price of $798 a month. I thought this was high. What do you think?
MSRP was $50,350

Thanks,

Jack

yeah that is high, find another dealer.

Hi all, can someone tell me what "Residualizable Options" are? I have been struggling with this in trying to calculate my lease payment. In calculating MSRP, do you include options?

Originally Posted by bears2424

Hi all, can someone tell me what "Residualizable Options" are? I have been struggling with this in trying to calculate my lease payment. In calculating MSRP, do you include options?

It depends on whether you are looking at BMWFS or a bank lease. Most residuals are based on the MSRP that is on the Window Sticker from the manufacturer.

I know that the sales tax is charged up front to the lessor in texas on the entire amount of the lease. In the case of a transfer of lease during the tem of the lease, assuming the transferee is a resident of Texas, is there another tax charge at that point? What other fees would there be other than the $450 BMWFS or whatever the bank charges?

Thanks!
Jayzee9

I'm coming up with a higher monthly payment (using this xls sheet) than what the dealer quoted. Any thoughts?