TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker and becoming a Supporting Member. For more info: Support TMC

Tesla loan comparison spreadsheet - auto updates hourly

Discussion in 'Model 3' started by T3slaMecca, Sep 5, 2018.

Tags:
  1. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    Hi everyone,

    This community has helped me tremendously on my Model 3 ownership journey and I thought I'd give back with this spreadsheet.

    This spreadsheet pulls rates directly from the credit union's website hourly, so you're always getting the latest rates, because as you know, they change quite often these days!

    The loan comparison google spreadsheet: Tesla Loan Comparison Spreadsheet - Auto Update Rates

    How to use the spreadsheet youtube (best viewed in 1080p): Tesla Loan Comparison Spreadsheet - Updates Hourly

    Let me know if there's anything I can do to make the spreadsheet easier to use.

    For now, this spreadsheet only contains US credit unions but if you know of great rates in other countries, let me know and I'll add it.

    My mission is to help anyone who's interested in buying a Tesla or EVs -- let's all help each other out!

    Blessings,
    Khoa
     
    • Helpful x 27
    • Like x 7
    • Love x 4
    • Informative x 1
  2. hotony13

    hotony13 Member

    Joined:
    Aug 20, 2018
    Messages:
    84
    Location:
    San Jose
    Wow this is an awesome resource. Thanks a lot Khoa!
     
  3. hurjio

    hurjio Member

    Joined:
    Feb 3, 2018
    Messages:
    102
    Location:
    Southern California
    This is great!
     
  4. SoCalGuy

    SoCalGuy Active Member

    Joined:
    Apr 22, 2012
    Messages:
    1,228
    Location:
    So Cal & New York, NY
    How are you pulling the Lighstream rates? The ones in the spreadsheet seem much lower than the ones on Lightstreams website.
     
  5. lairdb

    lairdb Member

    Joined:
    Mar 26, 2018
    Messages:
    239
    Location:
    California
    Why are shorter loan terms all graded worse (on the color scale) in columns C,D,E? Perhaps color scale should apply only within loan term?

    No 24 or 36 terms?

    Is this actually being scraped, or does it depend on humans? (Or Mechanical Turks?) Some of the rates do not seem consistent with what's visible online.
     
  6. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    You're welcome guys!

    @SoCalGuy since lightstream beats the lowest rates by .1%, I've just made the cell fetch the lowest rate and subtract it by .1%.

    @lairdb would 24/36 terms help you? I can get them added.
     
  7. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    @lairdb also most people are interested in decreasing their monthly payments, so usually longer terms are better for most, but not for everyone.
     
  8. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    Can you tell me which? I'll get it fixed.
     
  9. C141medic

    C141medic Supporting Member

    Joined:
    Apr 9, 2016
    Messages:
    772
    Location:
    New Jersey
  10. iaonbb

    iaonbb Member

    Joined:
    Jul 21, 2018
    Messages:
    30
    Location:
    Mile High
    Fantastic work! you should also add alliant credit union. Spoke with an awesome dude there named Brandon who said he's done hundreds of Tesla's and is very familiar working with the delivery specialists. Made me feel very comfortable about the entire process.
     
  11. Mtrack

    Mtrack Member

    Joined:
    Jul 24, 2018
    Messages:
    13
    Location:
    San Diego
    Wow. This is impressive. Thank you. Too bad I didn’t have this sooner. I’m taking delivery of my P3D+ this Saturday. Too little time in my opinion to reapply for a lower rate. Using LightStream to beat the local credit union. I can’t complain since I’m at 2.10% for 60mos.
     
  12. Chips

    Chips Member

    Joined:
    Dec 7, 2016
    Messages:
    89
    Location:
    Merritt Island FLA
    Oh yes this is awesome.
    Can you add Launch Federal Credit Union?
     
  13. Ingham

    Ingham Member

    Joined:
    Aug 1, 2018
    Messages:
    36
    Location:
    44255
    So helpful - thank you!
     
  14. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    @C141medic I've added ABCO, thank you such great rates!

    It's actually be scraped.

    @Chips Thanks, I'll add it later today after I get home

    @Mtrack 2.10% is really good and congrats on P3D!

    @Ingham you're welcome!!
     
    • Like x 1
  15. ebmcs03

    ebmcs03 Active Member

    Joined:
    Dec 22, 2017
    Messages:
    1,592
    Location:
    So Cal
    That’s terrible... people should look at how to pay as little interest as possible rather than looking at monthly payments only.
    No wonder “everyone” in America is in debt.
     
    • Like x 3
  16. T3slaMecca

    T3slaMecca Member

    Joined:
    Aug 1, 2018
    Messages:
    135
    Location:
    California
    Sometimes it may not be, because some people rather have more cash on hand to invest which can have better returns versus paying 2.5% APR. So if you have 50k that you can invest with that has 8% annual returns, it may be better to have 50k to invest so you effectively earn 5.5% rather than 0%.

    But paying off the loan also gives you peace of mind and guarantees you're not in debt if you become unemployed so.. it could be personal preference and both approaches are okay given the right context I believe.
     
    • Like x 4
  17. ebmcs03

    ebmcs03 Active Member

    Joined:
    Dec 22, 2017
    Messages:
    1,592
    Location:
    So Cal

    Ya. But I don’t think most people are like that.
     
    • Like x 1
  18. Fusion

    Fusion Member

    Joined:
    Apr 13, 2016
    Messages:
    590
    Location:
    San Francisco
    Pretty cool. Thanks for sharing.
     
  19. voip-ninja

    voip-ninja Give me some sugar baby

    Joined:
    Mar 15, 2012
    Messages:
    3,090
    Location:
    Colorado
    I actually don't recommend you assume LS will beat all other rates by .1%, it is pretty hit or miss, the only way for sure to get them to do rate beat is to get full documented approval (not pre-approval) from the other bank in writing (with their letterhead and offer details) and then mail or fax it to them.

    They have really tightened up their criteria for matching other loans... for example a few people gave up on them matching Allegacy since Allegacy would not provide enough documented proof of loan rate for LS to act on.
     
  20. voip-ninja

    voip-ninja Give me some sugar baby

    Joined:
    Mar 15, 2012
    Messages:
    3,090
    Location:
    Colorado
    Please let me know where I can get a guaranteed 8% return on my investments so I can move some of them there.
     
    • Like x 2
    • Funny x 1

Share This Page

  • About Us

    Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.
  • Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


    SUPPORT TMC