Edmunds dealer partner, Bayway Leasing, is now offering transparent lease deals via these forums. Click here to see May lease deals!
Options

How Do I Calculate Monthly Lease Payments?

124»

Comments

  • Options
    golicgolic Member Posts: 714
    Kevin-

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

    G
  • Options
    jenzarjenzar Member Posts: 3
    Hi
    Can you send me this spreadsheet?
    Thank you very much:)
    Jenny
  • Options
    Kirstie_HKirstie_H Administrator Posts: 11,149
    Jenzar,
    you need to edit your profile & make your email address public. It will only be available to registered members.

    MODERATOR /ADMINISTRATOR
    Need help navigating? kirstie_h@edmunds.com - or send a private message by clicking on my name.
    Share your vehicle reviews

  • Options
    jenzarjenzar Member Posts: 3
    Hi - I've made my email address public.
  • Options
    jenzarjenzar Member Posts: 3
    Hi - Can you send me this spreadsheet?
    I'd greatly appreciate it.
    Thanks
    Jen
  • Options
    iceyhotjiceyhotj Member Posts: 30
    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?
  • Options
    golicgolic Member Posts: 714
    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.
  • Options
    Kirstie_HKirstie_H Administrator Posts: 11,149
    correction: don't email car_man. Post in the Saturn Vue lease forum. Hosts can't possibly help everyone individually by email!

    MODERATOR /ADMINISTRATOR
    Need help navigating? kirstie_h@edmunds.com - or send a private message by clicking on my name.
    Share your vehicle reviews

  • Options
    pcp33pcp33 Member Posts: 6
    can you please email the spread sheet. thanks
  • Options
    richzrichz Member Posts: 160
    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.
  • Options
    golicgolic Member Posts: 714
    pcp, click on my name and send me an email. I don't know what your email address is.
  • Options
    tidestertidester Member Posts: 10,059
    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
  • Options
    richzrichz Member Posts: 160
    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.
  • Options
    grandtotalgrandtotal Member Posts: 1,207
    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.
  • Options
    kyfdxkyfdx Moderator Posts: 238,949
    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

    Edmunds Price Checker
    Edmunds Lease Calculator
    Did you get a good deal? Be sure to come back and share!

    Edmunds Moderator

  • Options
    tidestertidester Member Posts: 10,059
    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
  • Options
    richzrichz Member Posts: 160
    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.
  • Options
    tidestertidester Member Posts: 10,059
    Well, great! Glad we got that settled. :)

    tidester, host
    SUVs and Smart Shopper
  • Options
    jstlookinjstlookin Member Posts: 9
    I know its been a while since you posted this, but would you mind e-mailing me your spreadhseet?

    Thanks golic!
  • Options
    golicgolic Member Posts: 714
    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..
  • Options
    dovster10dovster10 Member Posts: 1
    Hi Golic,

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

    Thx!!
  • Options
    bestforlastbestforlast Member Posts: 1
    Please send me your spreadsheet at:
    bestforlast@hotmail.com
    Thanks
  • Options
    rierrat306rierrat306 Member Posts: 2
    Golic,

    Can you please email me your Excel spreadsheet?

    Thanks
  • Options
    rierrat306rierrat306 Member Posts: 2
    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
  • Options
    dintymdintym Member Posts: 1
    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
  • Options
    JohnRussellJohnRussell Member Posts: 5
    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"
  • Options
    darkhelmet82darkhelmet82 Member Posts: 4
    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
  • Options
    neneloconeneloco Member Posts: 2
    can I have the spreadsheet aswell....

    djm222 at hotmail.com
  • Options
    lousax357lousax357 Member Posts: 3
    car man,
    can i get a copy of the excel spreedsheet on how to calculate a good lease
    thanks lousax357
  • Options
    lousax357lousax357 Member Posts: 3
    hi car man i would like a copy of your spreadsheet on
    calculating lease pymt's.
    thanks
    lousax357
  • Options
    Kirstie_HKirstie_H Administrator Posts: 11,149
    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.

    MODERATOR /ADMINISTRATOR
    Need help navigating? kirstie_h@edmunds.com - or send a private message by clicking on my name.
    Share your vehicle reviews

  • Options
    drinkvinodrinkvino Member Posts: 1
    Hey car man; would you kindly send me that sheet? thanks
  • Options
    tidestertidester Member Posts: 10,059
    Please refer to the posting just prior to your previous one. :)

    tidester, host
    SUVs and Smart Shopper
  • Options
    terrywallinterrywallin Member Posts: 1
    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
  • Options
    kesny5kesny5 Member Posts: 1
    Looking to lease a 2010 GMC Acadia--would you mind sending over a copy of your spreadsheet?

    Thanks!

    Kevin
  • Options
    jwilliams2jwilliams2 Member Posts: 910
    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.
  • Options
    british_roverbritish_rover Member Posts: 8,502
    He hasn't posted here in months not sure if he is around anymore.
  • Options
    ortho1ortho1 Member Posts: 4
    Hi Golic,

    Will you please send me this spreadsheet to help calculate my lease payment? Thanks.
  • Options
    ortho1ortho1 Member Posts: 4
    will you please email your spreadsheet? thanks.
  • Options
    Kirstie_HKirstie_H Administrator Posts: 11,149
    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.

    MODERATOR /ADMINISTRATOR
    Need help navigating? kirstie_h@edmunds.com - or send a private message by clicking on my name.
    Share your vehicle reviews

  • Options
    susiejdsusiejd Member Posts: 1
    Hey Golic - if you could email me your spreadsheet, that would be great! Thank you!
  • Options
    ajreidajreid Member Posts: 8
    I'd love to get a copy of your excel spreadsheet. I'm going to the dealer on Saturday, 12/26/09.

    Happy Holidays!
  • Options
    ffxjackffxjack Member Posts: 47
    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!
  • Options
    psanderspsanders Member Posts: 13
    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.
  • Options
    daisy26daisy26 Member Posts: 1
    How do I get you an email to get a copy of the excel spreadsheet?
This discussion has been closed.