Tesla loan comparison spreadsheet - auto updates hourly

[T3slaMecca]

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

 

[hotony13]

Wow this is an awesome resource. Thanks a lot Khoa!

 

[hurjio]

This is great!

 

[SoCalGuy]

How are you pulling the Lighstream rates? The ones in the spreadsheet seem much lower than the ones on Lightstreams website.

 

[lairdb]

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.

 

[T3slaMecca]

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.

 

[T3slaMecca]

@lairdb also most people are interested in decreasing their monthly payments, so usually longer terms are better for most, but not for everyone.

 

[T3slaMecca]

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.

Can you tell me which? I'll get it fixed.

 

[C141medic]

Please add my CU.
ABCO FCU: Vehicle Loans and Services

 

[iaonbb]

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.

 

[Mtrack]

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.

 

[Chips]

Oh yes this is awesome.
Can you add Launch Federal Credit Union?

 

[Ingham]

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

So helpful - thank you!

 

[T3slaMecca]

@C141medic I've added ABCO, thank you such great rates!

Is this actually being scraped, or does it depend on humans? (Or Mechanical Turks?)

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!!

 

[ebmcs03]

@lairdb also most people are interested in decreasing their monthly payments, so usually longer terms are better for most, but not for everyone.

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.

 

[T3slaMecca]

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.

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.

 

[ebmcs03]

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.

Ya. But I don’t think most people are like that.

 

[Fusion]

Pretty cool. Thanks for sharing.

 

[voip-ninja]

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.

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.

 

[voip-ninja]

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.

Please let me know where I can get a guaranteed 8% return on my investments so I can move some of them there.