NVIDIA DCF Valuation Model Built From Scratch | FREE EXCEL INCLUDED (2023)

⬇️ Download the NVIDIA DCF Excel for FREE ⬇️

🖥️Wall Street Prep🖥️
► Use code RARELIQUID for 20% OFF on any course!

🚀Sign up for my courses🚀

🎥Related Videos🎥

⏱Timestamps⏱
0:00 - Agenda
4:55 - Wall Street Prep
7:05 - Income Statement & Cash Flow Line Items
48:15 - Build DCF
1:31:30 - WACC
1:41:30 - Calculating Implied Share Price
2:03:15 - Price Discussion

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

📱Interact With Me📱

🧑‍🎓Career Resources👩‍🎓

🔎Disclaimer🔎
All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase.

#nvidia #nvda #stocks #dcf

[rareliquid]

⬇ Download the NVIDIA DCF Excel for FREE ⬇

🖥Wall Street Prep🖥
► Use code RARELIQUID for 20% OFF on any course!

🚀Sign up for my courses🚀

[palmetto.]

I haven’t done a DCF in like two years now lol, watching this is nostalgic and traumatizing all at once 💀

[jobinchavez]

Hey Ben, really amazing content - appreciate you putting these out for free, and they're incredibly helpful. Any chance you'd be willing to do a formatting / shortcuts video sometime when you get a chance, please? Trying to get better and faster at my DCFs and would love to get some more exposure to the quick keys & formatting tools you're using. Thanks!

[yashchoudhary]

we need more of these streams ben! these are amazing great work buddy!!

[novemberchopin]

Keep these educational videos coming! Really appreciate the time you took.

[ivangostev]

Hi Ben, thanks so much for your amazing video! Have a couple of questions about estimations:
1. What's approach to use for estimates if there is no data on a company on Factset or no access to this platform?
2. Does DCF model fit for a new business unit of a company completely without historicals? What source for data to use in this case?

[rambouhh]

its crazy that its 9 months later and the annualized revenue for Q1 2024 is already 104 million. What this model had for 2028 revenue will likely be the revenue in 2024

[robertthomassian]

Hi Ben. Congrats on graduating Wharton and good luck with your future ventures with Rare Liquid!

I just used this to model to value my mom’s business so cheers🎉!
😘

[MrOmertemiz]

First of all, thank you for the video, It is amazing. For the revenue 2014, 11/12 of the revenue should come from the amount as of 25-Jan-15 and 1/12 should come from the figre as of 26-Jan-14. Formula is =(11/12)*IS!C9+(1/12)*IS!B9. There is nothing belongs to 2014 in the report as of 31-Jan-16. Same for the EBIT. Am I right?

[johnweak-cl]

when calculating WACC, what year should you get the debt and equity value to get the proportion? year 1 of forecasts? or last year of actual FS?

[darrelldas]

A video I was eagerly waiting for. Thank you so much for this video. I was making projections on nvidia. And you cleared it.♥️

[barryaherne]

Like a slice of nostalgia from the olden days 😀

[ashishbhasin]

Hi, you have used levered beta, you are valuing equity so ideally you should calculate unlevered beta

[jakefrep]

I think you calendarized in the wrong direction. Should have been 1/12 of the 1/31/14 column plus 11/12 of the 1/31/15 column.

[juancassinerio]

Amazing video !!!
Where did you get the Financial Stements Data From???

[alessandrogiovati]

how do you justify the high rate of growth of revenues and ebit?
thank you so much, very useful

[daviddirethucus]

Hi, in the 00:40:45 when you said converting "Change in NWC" be positive, why should we do this step? and why we only give the minus sign to the first part of the equation: ? Thanks.

[maherhoussami]

What service do you use to obtain the financials for any company like you did in the stream?

[Foldengold]

is there any update on when the DCF model download is ready? Cheers from denmark

[tracywang]

Thanks for sharing!

Got a question here, in 1:54:09 if we were standing at Sep 2023, but you assumed the whole 2023 cash would come in in the coming 0.14 year? Shouldn't we just discount 2023Q4 cash?

I think you have to do the yearfrac of revenue and then do the discount?