How Do I Calculate Monthly Lease Payments?

golic

Kevin-

Your email is set to private. Click on my name and send me an email and I will forward it to you.

G

jenzar

Hi
Can you send me this spreadsheet?
Thank you very much:)
Jenny

Kirstie_H

Jenzar,
you need to edit your profile & make your email address public. It will only be available to registered members.

jenzar

Hi - I've made my email address public.

jenzar

Hi - Can you send me this spreadsheet?
I'd greatly appreciate it.
Thanks
Jen

iceyhotj

Hi Golic,
I'm also interested in getting a copy of the excel spreadsheet. I'm thinking about leasing a Saturn Vue and want to be as prepared as possible. Any help, tips or advice would be greatly appreciated.
Thanks!
J
P.S. Can I just click on your name and send you an e-mail directly so you can respond with the excel sheet?

golic

yes you can.

My tips would be to read the Saturn Vue prices paid forum to get an idea of the current market price for the vehicle. Then use edmunds TMV feature to see how that compares to your properly equipped vehicle.

I would also email car_man and ask him to provide you with the current residual and money factor for the term (months) and miles (12k or 15K) you are seeking.

That is how I would start.

Kirstie_H

correction: don't email car_man. Post in the Saturn Vue lease forum. Hosts can't possibly help everyone individually by email!

pcp33

can you please email the spread sheet. thanks

richz

How do I figure the gas guzzler tax into my lease payment calculation? Do I pay the full gas guzzler tax or does it get figured into the residual value? I have read in some places that it depends on the bank whether it is included in the residual value or not. Is this true? If it is, do you know the case for Mercedes Benz financial services?

Thanks.

golic

pcp, click on my name and send me an email. I don't know what your email address is.

tidester

Lenders will not residualize the gas guzzler tax, i.e. the tax will not be part of the vehicle's residual value. "To figure the tax, multiply the partial payment by the tax rate in effect at the time of the payment." (IRS)

tidester, host
SUVs and Smart Shopper

richz

I'm not sure how that IRS stipulation clears up anything, but I'd like to report that you are wrong. I have confirmed with both BMWFS and MBFS that the gas guzzler tax is residualized by them, and it is indeed up to the lender. Unfortunately, there is a lot of "authoritative" misinformation on this topic which is why it was so hard to find an answer.

grandtotal

I have confirmed with both BMWFS and MBFS that the gas guzzler tax is residualized by them

Interesting, if I were a lender I would not residualize gas guzzler tax. I don't see the point because it's residual value tends towards zero very rapidly after you drive the car off the lot. I guess you do what you have to do to keep selling cars.

kyfdx

They can adjust for it on the other end of the equation.. Just lower the residual percentage to hit the same number...

It's probably just to simplify things for the dealerships.... Since the tax is on the Monroney sticker, they don't have to do any adjustments..

regards,
kyfdx
visiting host

tidester

I have confirmed with both BMWFS and MBFS that the gas guzzler tax is residualized

Confirmed? Where? Got a link?

I suspect the GGT was subtracted from the total sticker prices (i.e. it was not residualized) as this reference (item #19) suggests.

tidester, host
SUVs and Smart Shopper

richz

I confirmed with multiple dealers and in one case I calculated the lease payment myself with the assumption that the GGT would be residualized and my payment calculation matched to the dollar with the dealer's quote. Furthermore, Tarry, who runs the website you linked to, told me that it is indeed lender dependent.

tidester

Well, great! Glad we got that settled.

tidester, host
SUVs and Smart Shopper

jstlookin

I know its been a while since you posted this, but would you mind e-mailing me your spreadhseet?

Thanks golic!

golic

I would if I had your email!!!

Send me an email to my user name @carspace.com and I will get you that spread sheet.

Or click on my user name and hit the email..

dovster10

Hi Golic,

Can you pls email your excel grid? would love to use in my leasing process.

Thx!!

bestforlast

Please send me your spreadsheet at:
bestforlast@hotmail.com
Thanks

rierrat306

Golic,

Can you please email me your Excel spreadsheet?

Thanks

rierrat306

Can you please supply the password to unprotect the sheet?

For example, my dealer gave me the residual $ value, not the factor, so I wanted to make appropriate changes to your spreadsheet.

Thanks,

Jim Bannon

dintym

Car_Man can you please send me that spread sheet for leasing cars. I really would like to know how I can get the best lease because we are retired couple and do not want to leave anything on the table.

Thanks,
Tom

moore12334@aol.com

JohnRussell

Lexus is running a Golden Opportunity Sales Event for a 2009 Lexus ES350. Listed below is the ad that includes key information pertaining to the lease BUT it does not provide the money factor.

I have called multiple Lexus dealers and get the run around when I ask for the money factor. One said .00020 and another said .00040 is being used in this lease.

Given this lease promotion description is there a way to calculate the money factor on my own? Looks to me like all of the key details are included in the ad to calculate cap reduction and residual but I just can't get any lease calulator to give me the money factor that Lexus is using in the ad.

If you know how to do this please let me know the math you used.

I realize that the $389 monthly payment does not include sales tax, document fee, title, etc..

All I want to be able to do is run this basic lease promotion through the Edmunds Lease Calculator in order to come up with the $389 lease payment. Then I can add sales tax, etc, etc....

Here is the Lexus Lease ad:

"2009 ES 350 Lease Offer.

$389mo 36 mos. $3889 due at signing"

The ad footnote goes on to say:

"Offer based upon MSRP of $37,710 including delivery, processing, and handling. 36 monthly payments total $14,011. 12,000 miles per year. Lease end purchase option $18,478"

darkhelmet82

golic can you send me the spreadsheet as well. i tried to email you but i was unsuccessful, it says you only accept emails through here.. im not sure how to do that... thanks

neneloco

can I have the spreadsheet aswell....

djm222 at hotmail.com

lousax357

car man,
can i get a copy of the excel spreedsheet on how to calculate a good lease
thanks lousax357

lousax357

hi car man i would like a copy of your spreadsheet on
calculating lease pymt's.
thanks
lousax357

Kirstie_H

The spreadsheet was prepared by member "golic," rather than car_man. I have not seen that member around for awhile, though he may be lurking.

drinkvino

Hey car man; would you kindly send me that sheet? thanks

tidester

Please refer to the posting just prior to your previous one.

tidester, host
SUVs and Smart Shopper

terrywallin

Hi

I would appreciate you sending me a copy of your EXCEL spreadsheet. If I decide to lease, it would be the first time. The most difficult variable for me to handle is the "residual value". Any advice on how to determine what the dealers are using?

Thanks.

Canarsietj

kesny5

Looking to lease a 2010 GMC Acadia--would you mind sending over a copy of your spreadsheet?

Thanks!

Kevin

jwilliams2

Residuals are set by the manufacturer (or leasing company). They are really not "variable" in that the dealer can not change them, although they do differ from Mfg. to Mfg, and model to model.

british_rover

He hasn't posted here in months not sure if he is around anymore.

ortho1

Hi Golic,

Will you please send me this spreadsheet to help calculate my lease payment? Thanks.

ortho1

will you please email your spreadsheet? thanks.

Kirstie_H

again, as british_rover just pointed out, golic hasn't been around for quite some time, so posting a message here asking him to email you probably isn't going to help.

susiejd

Hey Golic - if you could email me your spreadsheet, that would be great! Thank you!

ajreid

I'd love to get a copy of your excel spreadsheet. I'm going to the dealer on Saturday, 12/26/09.

Happy Holidays!

ffxjack

I too would like that spreadsheet. I understand that Golic may no longer be on the boards. If anyone has it, can you please email me a copy ASAP since I'm trying to get something done by Jan 4th?

My email is "ffxjack at yahoo dot com"
Thanks!

psanders

On an identical car, would the money factor be the same no matter where you leased it from?
How about the residual value--no difference from region to region or state to state?

Thanks.

daisy26

How do I get you an email to get a copy of the excel spreadsheet?