1. Model 3 is coming. Get your Model 3 Owners Club apparel today!


    Dismiss Notice

My Model 3 Finance Calculator/for general use

Discussion in 'Reserving, Ordering, Production, Delivery' started by JWardell, Aug 9, 2017.

More threads by JWardell
  1. JWardell

    Top-Contributor
    Expand Collapse

    Joined:
    May 9, 2016
    Messages:
    867
    Likes Received:
    638
    Trophy Points:
    93
    Gender:
    Male
    City & State/Province:
    Boston
    Tesla Owner:
    Reservation
    Country:
    Country
    #1 JWardell, Aug 9, 2017
    Last edited: Aug 11, 2017
    Edit due to new thread:

    Google spreadsheet to estimate Model 3 costs and payments by @LookUp
    Code:
    https://docs.google.com/spreadsheets/d/1-Yvl42yfPuBpqjlK73cbOlmw2waoGozFIKwYfY4DBws/edit?usp=sharing

    @LookUp this is awesome! I did a lot of this on a napkin a week ago and ended up just as confused. The spreadsheet makes it really easy to toggle values and see what the end result is!

    But why are on earth are you spending $75 on oil changes every month?!?
     
    • Like Like x 2
  2. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country

    Thanks! I am factoring $75 a month on oil because I am very picky with my sports car :) I take it to a performance shop where it sits next to maseratis and porches, and get synthetic. So it averages out to 25-75 a month depending on how many miles I put on it!
     
  3. JWardell

    Top-Contributor
    Expand Collapse

    Joined:
    May 9, 2016
    Messages:
    867
    Likes Received:
    638
    Trophy Points:
    93
    Gender:
    Male
    City & State/Province:
    Boston
    Tesla Owner:
    Reservation
    Country:
    Country
    @LookUp if you do plan on updating the spreadsheet for general use I would ask that you add the necessary lines for sales tax..I tend to ignore its existence, but 6.25% can add up here!
     
    • Like Like x 1
  4. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country
    It is complete! The original link should hopefully work, and I believe I did the math right (sales tax applying to full purchase price of car). Let me know what you think!
     
    • Love it! Love it! x 1
  5. JWardell

    Top-Contributor
    Expand Collapse

    Joined:
    May 9, 2016
    Messages:
    867
    Likes Received:
    638
    Trophy Points:
    93
    Gender:
    Male
    City & State/Province:
    Boston
    Tesla Owner:
    Reservation
    Country:
    Country
    Awesome work again! You may want to post this in the more general Ordering forum so more folks can see it (or maybe mods should just move the thread)
     
    • Like Like x 1
  6. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country
    To add to the list, I present my Model 3 Finance calculator.

    I'm a bit of a spreadsheet nerd, and I'm excited about the Model 3 so I bide my time doing stuff like this.
    Code:
    https://docs.google.com/spreadsheets/d/1-Yvl42yfPuBpqjlK73cbOlmw2waoGozFIKwYfY4DBws/edit?usp=sharing
    To use this, get a Google Docs account if you don't have one already. Sign in to your account. Then, go to the File Menu (in google docs, not on your browser) and select "Make a Copy". You'll see a copy in your own google docs account that you can fill in, and modify if you like.

    I like it because I like to see multiple scenarios at multiple APR and loan periods at once. I like typing in what I'm comfortable with as far as monthly payment, and then seeing where that stacks up in terms of loan terms and total interest paid.

    I didn't use any proprietary code or include any private information. If you want to use this for your own state/country, and modify it, and post it up for use by others, I really don't care about getting credit.

    I commented each option using literature from the press release, even though we probably all know it by heart by now.
     
    • Like Like x 1
    • Informative Informative x 1
  7. SoFlaModel3

    Impatiently Waiting
    Moderator M3OC Supporting Member
    Expand Collapse

    Joined:
    Apr 15, 2017
    Messages:
    3,356
    Likes Received:
    1,588
    Trophy Points:
    113
    Gender:
    Male
    City & State/Province:
    South Florida
    Tesla Owner:
    Reservation
    Country:
    Country
    Great of you to put this together for people!

    One note for you. The destination charge on Model 3 is $1,000, not $1,500.
     
    • Agree Agree x 1
  8. Ip Man

    Active Member
    Expand Collapse

    Joined:
    Jan 7, 2017
    Messages:
    122
    Likes Received:
    27
    Trophy Points:
    28
    Gender:
    Male
    City & State/Province:
    CT
    Country:
    Country
    what about a basic one for those of us who pay cash for the car. We've had 4 yrs to save up for it.
    I'll be paying cash for 2 of them. What about dual motors and such?
    I see 49k+1500 wheels+sales tax+state fees+delivery 1000.
    So about 55k for my first one.
    Second one will be about 75k-maxed out-all options-hopefully no lux tax.
     
  9. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country
    It was for the (local to calif?) employee who screenshotted their config. But, I'm padding it for those of us who are out of state.
     
  10. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country
    4 years saving 140k in cash? Nicely done, richie rich! :D

    As far as I know, there's no solid info on dual motors or other interiors. When there is, I'll be sure to update!

    As to other fees you can add those in after you've made a copy.
     
    • Funny Funny x 1
  11. SoFlaModel3

    Impatiently Waiting
    Moderator M3OC Supporting Member
    Expand Collapse

    Joined:
    Apr 15, 2017
    Messages:
    3,356
    Likes Received:
    1,588
    Trophy Points:
    113
    Gender:
    Male
    City & State/Province:
    South Florida
    Tesla Owner:
    Reservation
    Country:
    Country
    I "think" the price is the price is the price regardless of where the car is picked up in the US!
     
    • Agree Agree x 2
    • Like Like x 1
  12. MelindaV

    ☰ > 3
    Moderator
    Expand Collapse

    Joined:
    Apr 2, 2016
    Messages:
    3,631
    Likes Received:
    2,568
    Trophy Points:
    113
    Gender:
    Female
    City & State/Province:
    Vancouver, WA
    Tesla Owner:
    Reservation
    Country:
    Country
    don't give too much credit to 007, he is known as the site's fabulist
     
    • Agree Agree x 4
    • Like Like x 1
  13. LookUp

    Member
    Expand Collapse

    Joined:
    Apr 16, 2017
    Messages:
    20
    Likes Received:
    9
    Trophy Points:
    3
    City & State/Province:
    Portland, OR
    Country:
    Country
    #13 LookUp, Sep 18, 2017
    Last edited: Sep 18, 2017
    I've cleaned up the calculator quite a bit. This is to figure out FINANCING scenarios, and I've left out post-purchase factors such as tax credits, etc.

    Use this calculator to figure out ideal Loan Terms based on your budget & wants with the car.

    Ideally, you should be able to afford the full-term financing on the car, even if you don't get a tax credit, or receive only partial credit. Protect yourself by being wise with your budget!

    Code:
    https://docs.google.com/spreadsheets/d/1-Yvl42yfPuBpqjlK73cbOlmw2waoGozFIKwYfY4DBws/edit?usp=sharing
     
    • Like Like x 1
    • Agree Agree x 1
    • Love it! Love it! x 1

Share This Page

Model 3 Owners Club © 2017. All rights reserved.
Model 3 Owners Club (M3OC) is an enthusiast club and is not affiliated with Tesla Motors or the Tesla Motors Club Forum (TMC).
All Tesla logos are trademarks or registered trademarks of Tesla Motors.