TSLA DCF - for Patreons
Added 2021-01-08 21:51:51 +0000 UTCHey everyone, here is the TSLA DCF for you to play with and see what you get. Mind you I used a MASSIVE 10% long term growth, that means more than global GDP lol! fee free to apply your case and see what you get.
Comments
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 ?
Cz Foo
2021-06-28 07:24:51 +0000 UTCLove 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!
William D Edwards
2021-01-14 03:08:44 +0000 UTCI am interested as well.. π
KΓΆnnyΕ± MΓ‘tyΓ‘s
2021-01-13 20:24:19 +0000 UTCI 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...
Patrick T
2021-01-11 07:33:43 +0000 UTCHey 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.
Kartik Aiyer
2021-01-11 00:43:49 +0000 UTC@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 :)
Anson Cheung
2021-01-10 22:51:40 +0000 UTCGreat analysis Tom! Would love to see your analysis of Enphase, doing very well and great potential for solar energy.
Naoufel Bennani Smires
2021-01-10 14:43:33 +0000 UTCThis 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.
Eugene Lee, CFA
2021-01-09 14:45:39 +0000 UTCTom, do you think Tesla will do another stock split in 2021?
Grady Massey Jr
2021-01-09 10:59:34 +0000 UTCSo buy, sell or hold Tom?
Armin Bajric
2021-01-09 06:46:15 +0000 UTCYou do some amazing work Tom. π
David Bart
2021-01-09 00:38:21 +0000 UTCAppreciated that man!! Keep it up
Bruno PΓ©rez
2021-01-09 00:22:24 +0000 UTCHey, don't sleep on TSLA ...
Generico Fakero
2021-01-08 22:11:05 +0000 UTCthe 12% discount rate covers that risk.
Generico Fakero
2021-01-08 22:10:43 +0000 UTCWhat happens when the interest rates go up in 2024 (it has to at some point)?
Swadhin Nanda
2021-01-08 21:55:11 +0000 UTCGood Grief
Avalon
2021-01-08 21:52:53 +0000 UTC
