Pen and Pencil Lease Payment Calculation

I was using a lease calculator at leaseguide.com and these are the numbers it spit out:

335xi Coupe
MSRP 50700
Neg. Price: 48000 (just guessing, includes all fees but not tax)
58% Residual
.00196 MF (lowest possible including 7 MSDs)
36 months
5% tax

Total came out to 701.63


Seems pretty high, am I doing something wrong?

Seems correct. Advertised lease payments are always low because a down payment is being paid. I assume you aren't putting any money down and that you are paying the bank/acquisition fee at signing? That may be why the payments seem higher than you are used to seeing.

Originally Posted by schley

http://www.autoleaseadvisers.com/cal...ubmit=Continue

After getting pissed off with leaseguide lease calculator I tried using everyone's excel calculator and either didn't work for me or wasn't user friendly enough for me. I went on a crusade to find an online lease calculator I could use that is reliable. Here it is..... works very well so far as I know today after a thorough testing. Use it or don't use it, doesn't matter to me but I'm just glad to be able to dump the leaseguide calc.

I compared this to what Ronzer posted in post #73.

By zeroing out the ED markup on the MF (and using US MSRP/invoice numbers), I can get the same results.

1 thing to note is that the ALA calculator automatically rolls the Acq fee into the adjusted cap cost.

Ronzer's one allows one to play around with options and is a bit more transparent

Are there any lease calculators that determine the monthly payment amount by rolling in state taxes? Trying to find one that will work for leasing a car in Virginia, since unlike other states, Virginia doesn't charge a "use tax" but instead charges a 3% rate of the negotiated purchase price of the vehicle. It looks like most calculators just compute the "use tax."

ok now, i will need some help,
let's say the msrp is 52070 and the invoice price is 48500. If you say 1000 over invoice, does that mean the cap cost will be 49500, including the dmv, paperwork, maco, etc... ?and on top of this there is tax depenend on the state you live in of course. Am I wrong? Please let me know. Thanks to you all.

I'm doing my lease calcs, and have a question about the depreciation. I'm using this formula:

Cap Cost (Adj Cap (Selling Price + Doc + Process + Tax - Cap Rdxn) + Acq Fee)
Depreciation (Cap Cost - Residual)

Question is...when I use "Cap Cost" for computing the Depreciation, should aquisition fee be included or removed?

TIA.

Originally Posted by webguy330i

You got it.

Glad some people are finding this thing useful!!

Webguy-

Can you please email me the password as well? I'm trying to use the spreadsheet on a Mac and can't get the worksheet values (MSRP, negotiated price) to flow over to the lease calc sheet. If I can hard-code those values I can proceed with the calc. Email to mponchione@hotmail.com.

Thanks in advance. Great and useful tool, btw.

Hey i'm thinking of taking ED and leasing a 135 convertible going off the invoice pricing the car has come out to $43,990 (Premium, Sport, CA, PDC, NAV, Hi-Fi, iPod, Metallic Paint, Smartphone, Heated Seats, and Delivery and Handling) When i sat with a CA and he worked out payments on a 135 MSRP of $45,545 (selling price of $42,945 + 6% tax ($2576.70) + BMWFS Assignment 825.00 + tag and registration $270.00 + Cash Down Payment $2685.00. Making the total Capitalized Cost $43,931.70. Residual Value $31,881.50. 24 month Lease. Monthly Lease Charge .00295 ($223.65). Monthly depreciation $502.09 Monthly Payment of $725.74 with $3,410.74 due on delivery. Does that seem legit? Seems as though people are paying less per month on similar priced leases. Sorry for the novel post but am admittedly a noob when it comes to leasing, before i get completely flamed i have been reading up on it. Just hoping for some of your insights, since every lease option my CA has worked out has been right around $700 a month with 3-4K due on delivery.

What you call BMWFS Assignment $825 is the lease acquisition fee. It was $625 but may be $725 now ( I heard it was being raised Oct 1 ) so they marked it up $100 or $200. The Money factor is .00285 so they marked it up .0001. These are reasonable. The residual is 73% so if MSRP is $43,990 the residual should be exactly $32,112.70. So if you make 0 down payment, pay the tax $2576.70 and $270 and 1st month of $709.57 = $3,556.27 drive off and $709.57 per month. There is one problem and that is the security deposit. Unless you're a returning BMWFS customer you either have to pay a security deposit or a .00015 adder to the money factor. If you are a returning customer then it makes sense but then they marked up the money factor more because of the owner loyalty program. So the key is DON'T PUT A DOWN PAYMENT, do it like I outlined. I can't say if it is a fair deal because this particular car may be in demand but they are making about $2250 on the car, $100 or $200 on the lease acquisition fee, and a few 100 on the money factor markup. So the deal is strong money for the dealer and they structured it wrong. BTW, these numbers are for a 15k miles per year lease.

Thanks for your help mclaren

Anyone have the password to the lease calculation spreadsheet? It does not accept any numbers under Excel 2007, just prompts me to unlock the sheet. Tx.

Originally Posted by BigMoneyWasted

Anyone have the password to the lease calculation spreadsheet? It does not accept any numbers under Excel 2007, just prompts me to unlock the sheet. Tx.

Ditto.

what's the password =/

Originally Posted by xtac

what's the password =/

Enable macros. Then you should be able to enter the info.

See these link for more helpful and detail lease information and calculation
http://www.bimmerfest.com/forums/att...4&d=1249255376

http://www.bimmerfest.com/forums/att...5&d=1249255376

Passwords to webguy330i's spreadsheet are as follows:
sheet password: 2b3b3b7b1b3b5
book password: 3b7b5b1b3b1b7

Back to the future. Here's there worksheet again.

That paper guide is sooo yesterday.

http://www.leaseguide.com/calc.htm

Just plug in the numbers and enjoy the ride.

Originally Posted by Arkady

That paper guide is sooo yesterday.

http://www.leaseguide.com/calc.htm

Just plug in the numbers and enjoy the ride.

You missed the point of it! Some people like to do it. The old fashioned way.

What would happen if the computer crashed?

I've sent customers home in new cars, leases mind you, by candle light during power outages...


TRY IT. IT CAN BE FUN!!! IT WILL ALSO STIMULATE YOUR NEO-CORTEX...

Originally Posted by Jon Shafer

You missed the point of it! Some people like to do it. The old fashioned way.

What would happen if the computer crashed?

I've sent customers home in new cars, leases mind you, by candle light during power outages...


TRY IT. IT CAN BE FUN!!! IT WILL ALSO STIMULATE YOUR NEO-CORTEX...

I personally like it. I've used it a few times. You can fax it in advance to the finance person. They immediately know you understand all about leasing, and any opportunity for manipulation on either side goes away. It's easier to prove the accuracy of the pen and paper sheet than the XLS. It also teaches you the relationships between MF, cap cost, residual and depreciation and how each of those affect the payment. I still have the LRFS version somewhere.

Originally Posted by chrischeung

I personally like it. I've used it a few times. You can fax it in advance to the finance person. They immediately know you understand all about leasing, and any opportunity for manipulation on either side goes away. It's easier to prove the accuracy of the pen and paper sheet than the XLS. It also teaches you the relationships between MF, cap cost, residual and depreciation and how each of those affect the payment. I still have the LRFS version somewhere.

Exactly!!!




In today's dealerships (and buying population) there is total reliance on websites/apps to estimate payments. It feels really good sometimes to be able to wrap one's brain completely around a lease. Kinda like doing a long division or a quadratic equation just for fun...

Seriously, you are so right about it's effects on one's ability to conceptualize how the different variables of a lease payment inter-play...

.

Probably something with the taxes ... are you sure you pay taxes upfront in your state and not added to the lease payment?

Also, the sale price is low ... does this include the $2500 option credit? Are you sure the dealer didn't just deduct the 1000 from the "real" sales price? If you remove the $1000 from the equation, you are almost at what the dealer quoted for monthly payment.

.

Back in 2010 I had an XLS spreadsheet that listed MSRP and invoice for all current packages, allowed you to input MF's, MSD's etc, and spit out the fees and Mo'ly payment based on all current prices. Was an awesome program to get right to the nitty-gritty, but my sheet has all the info for the '10 prices, any chance someone could send me something similar for '13 models?

Thanx,
Joel