Tom Nash patreon

TSLA DCF - for Patreons

🕑 Added 2021-01-08 21:51:51 +0000 UTC

Comments

Cz Foo

Hi Tom, Love your DCF. How do we calculate NWC for tesla for example.. or any other companies. I have it tough getting the same numbers as you ?

William D Edwards

Love how you can make this so clear. An average of 70% upside. Def a buy man! Love what you do for this dumb money guy. So much smarter after watching u. Peace brother from another mother!

Könnyű Mátyás

I am interested as well.. 😅

Patrick T

I can automate it for you, using alphadvantage api. I just don't have a lot of time. It will require 2-3weeks of work. UI, backend, unit tests, etc...

Kartik Aiyer

Hey Tom... thanks a lot for this analysis. I'm a noob and have a question that I'm hoping you can help with. In the Tesla EBITDA calculation why do you multiply the $4B by 2 ? I'm trying to learn a bit of about DCF and practice looking up the numbers in the financials reported on seeking alpha. I looked at the EBITDA reported in the 12 months upto Sep2020 section (TTM by quarter dropdown) and it stated 4.019 B which is close to what I see in your spreadsheet. I really appreciate any time you put into this question and any feedback you may have.

Anson Cheung

@eugene to get the latest "current price" on a google spreadsheet, you can use this formula: =GOOGLEFINANCE("TICKER_SYMBOL", "price") eg. DraftKings =GOOGLEFINANCE("DKNG", "price") Hope it helps :)

Naoufel Bennani Smires

Great analysis Tom! Would love to see your analysis of Enphase, doing very well and great potential for solar energy.

Eugene Lee, CFA

This is great, Tom! Curious, are you using any automatic feed or API for your financial data? I mainly copy manually from 10Qs and Yahoo, but wanted to speed up my process.