DCF Model Spreadsheet (Academy) - TSLA DCF
Added 2023-06-27 09:55:32 +0000 UTCDear Academy members,
I want you to start practicing building your own DCF models and not using a pre maid model for a while, until you get comfortable doing it from scratch.
Attached to this post is a DCF practice excel model. Fill in the green boxes, and let the grey boxes to populate based on your data points.
Your assignment is simple: run a DCF model on TESLA using the model and the WACC calculator I gave you earlier.
I want each of you to post their DCF value below in the comments for Tesla. Don't be afraid of being wrong, its a safe space.
Tom
Comments
Hi Tom, where do you get projected EBITDA for years 2024 and forward? Do you just use some rate of growth for it? Could you elaborate, please? Edit: Also, could you please elaborate on "Capital expenditures"? What does it include?
Sergei Voitenko
2023-07-20 23:27:15 +0000 UTC
