🖥Wall Street Prep🖥 ► Use code RARELIQUID for 20% OFF on any course! ► gv142.isrefer.com/go/rliquid/rareliquid/ 💧rareliquid💧 ► Buy my Excel DCF models: rareliquidcareers.com/models ► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA ► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8 ► How to research crypto: forms.gle/fvzTKu13pBgPnBMA9
You should have a graphic keyboard on the video that indicate which key you press on the keyboard at any given time while working in Excel. It could be helpful for your audience (for me at least) to understand what shortcuts to use and when. This will also take away the need for you to explain all the shortcuts. Other than that these videos are great and super helpful. Keep up the good work/content!
Thanks again Ben. Really insightful video once again - keep it up! You talked about how the DCF's you made at JP Morgan was insanely detailed - would it be possible for you just to show us one example (not doing one)? Could ofc just be a fictive company, but just so we could get an idea of what you did there and what other people are doing. Thanks!
39:59 Hey Ben, where are you getting these EBIT figures from? I have downloaded the historicals from Salesforce Interactive Analyst Center and its totally different from what you are putting. Infact there is a little bit difference in every line item you are putting.
How did you get that EBIT, when im calculating it, I get different numbers and yahoo finance has different numbers compared to yours, actually all your numbers for sales and cogs or completely different than yahoo and mine for previous years
Thanks for sharing this, Ben. As a digital nomad working for RUclips and other platforms, would you mind making an analysis (in US dollars currency) of different countries taxes? And where would be the best options to stablish.
hi Ben, i understand that it is extremely time consuming, but could I request that you do one for square - it would be interesting to see how DCF plays out for an extremely strong growth stock!
It really doesn’t matter what company Ben models. To fully utilise a DCF (a very sensitive method of valuation), you should be using his videos to learn how to create a DCF and then constructing your own. But you need to do full revenue breakdown and potentially costs also, so you have a full understanding of the company. Ben is not doing this and by watching his videos you’re not gaining any insight into the company for an investment. No hate to you Ben by the way I love your videos.
@@helstonshedgefund5181 hi there, thank you for your advice! i have in fact done a DCF on Square, aka Block referencing to Ben’s DCF videos. the reason I requested for it is because Square is an extremely complicated company to conduct DCF on - take a look at their financials; bouncing between profitability and making losses QoQ and YoY, with very inconsistent numbers within all 3 of their financial statements. (Ben, thus far, has only modeled for profitable, and relatively “blue-chip-ish” type of companies) as such, i wanted to understand how Ben would tackle a DCF on Square, utilising his Investment Banking knowledge and experience. it is undeniably much simpler to do a DCF on matured companies! hope that clarifies any misunderstanding :)
Got yelled at by my gov teacher today because I was making a DCF on Msft while she was lecturing. Weirdest reaction ever. Anyways, stonks come first! Thanks for the vid, Ben
I met Expert Fred Williams last year for the first time at a conference in new york city, i invested €24,000 and traded in one month making close to €200,000..
If you hadn't said anything, I wouldn't have noticed that you had a new microphone. You still sound very low. but your content is still great *thumpsUp*
I have also been trading with him, the profits are secured and over a 100% return on your investment directly sent to your wallet. I made up to $15,000 in 2Months trading with him.
After watching so many youtube tutorial videos about trading I was still making losses until Mr Hillary Mark started managing my investments now I make $6,567 weekly. God bless Mr Hillary he's been a blessing to my family.
Trading investment is a safer and surest way to make more money now because I have made up to $121,700 recently from investment trading and management.
🖥Wall Street Prep🖥
► Use code RARELIQUID for 20% OFF on any course!
► gv142.isrefer.com/go/rliquid/rareliquid/
💧rareliquid💧
► Buy my Excel DCF models: rareliquidcareers.com/models
► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA
► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8
► How to research crypto: forms.gle/fvzTKu13pBgPnBMA9
how can I download the completed spreadsheet
You should have a graphic keyboard on the video that indicate which key you press on the keyboard at any given time while working in Excel. It could be helpful for your audience (for me at least) to understand what shortcuts to use and when. This will also take away the need for you to explain all the shortcuts. Other than that these videos are great and super helpful. Keep up the good work/content!
will work to add this!
Man’s is literally attending Wharton and he’s like ya I have a few hours to break down this company to the molecular level. 😂
Top G.
loolll im doin ma best
⏱Timestamps⏱
0:00 - Introduction
0:30 - Agenda
1:49 - Salesforce Situation Overview
5:15 - Wall Street Prep
7:12 - Revenue Build
37:14 - Historical Financials and Estimates
50:10 - Building the DCF
1:17:25 - WACC Calculation
1:23:34 - Mid-Year Convention
1:26:53 - Implied Share Price
1:29:33 - Price Discussion
Thanks again Ben. Really insightful video once again - keep it up! You talked about how the DCF's you made at JP Morgan was insanely detailed - would it be possible for you just to show us one example (not doing one)? Could ofc just be a fictive company, but just so we could get an idea of what you did there and what other people are doing. Thanks!
39:59 Hey Ben, where are you getting these EBIT figures from? I have downloaded the historicals from Salesforce Interactive Analyst Center and its totally different from what you are putting. Infact there is a little bit difference in every line item you are putting.
How did you get that EBIT, when im calculating it, I get different numbers and yahoo finance has different numbers compared to yours, actually all your numbers for sales and cogs or completely different than yahoo and mine for previous years
Thanks for sharing this, Ben. As a digital nomad working for RUclips and other platforms, would you mind making an analysis (in US dollars currency) of different countries taxes? And where would be the best options to stablish.
hi Ben, i understand that it is extremely time consuming, but could I request that you do one for square - it would be interesting to see how DCF plays out for an extremely strong growth stock!
will keep it in mind for its next earnings!
It really doesn’t matter what company Ben models. To fully utilise a DCF (a very sensitive method of valuation), you should be using his videos to learn how to create a DCF and then constructing your own. But you need to do full revenue breakdown and potentially costs also, so you have a full understanding of the company. Ben is not doing this and by watching his videos you’re not gaining any insight into the company for an investment. No hate to you Ben by the way I love your videos.
@@helstonshedgefund5181 hi there, thank you for your advice! i have in fact done a DCF on Square, aka Block referencing to Ben’s DCF videos. the reason I requested for it is because Square is an extremely complicated company to conduct DCF on - take a look at their financials; bouncing between profitability and making losses QoQ and YoY, with very inconsistent numbers within all 3 of their financial statements. (Ben, thus far, has only modeled for profitable, and relatively “blue-chip-ish” type of companies) as such, i wanted to understand how Ben would tackle a DCF on Square, utilising his Investment Banking knowledge and experience. it is undeniably much simpler to do a DCF on matured companies! hope that clarifies any misunderstanding :)
Got yelled at by my gov teacher today because I was making a DCF on Msft while she was lecturing. Weirdest reaction ever. Anyways, stonks come first! Thanks for the vid, Ben
Great work as always. Could you do a valuation for financial service companies - bank and non-bank? Thanks!
It would be great if you can build a three statement model from scratch, or a full DCF live (even if it takes a few days).
Bro. Love you series
Ben, can you show us an "insanely detailed model"?
my tesla and apple dcf videos are a bit more detailed but i don't have access to the more detailed ones i built before
Thanks for the video, however, how do forecast the business metrics such as RPO?
I'm done sitting tight for the award advance since i acquire $23,000 every 12 days from my investment.
How? I would really appreciate if you show me how to go about it. Please can you list the platforms ?
After I came across bitcoin trading platform of Mr Fred Williams my financial life has totally changed.
Same here, I earn $13,000 a week. GOD bless Fred, he has been a blessing to
my family.,
I started with just 4,000 dollars now earning upto 17,000 dollars WEEKLY
I met Expert Fred Williams last year for the first time at a conference in new york city, i invested €24,000 and traded in one month making close to €200,000..
What source are you using for the financial statements? Also do you have a template available for salesforce?
How about a REIT? I think most common is NAV model
This is great!! But could someone give me a hint of where to get those financial statements in Excel?? Thanks!!
Great vid! Could you do Nike please :) Will be interesting to hear your thoughts
will keep it in mind! i'd like to know as well
Could you add IRR to the DCFs and also how you can back into a target based on a set rate of return hurdle (I.e20% irr)
If you hadn't said anything, I wouldn't have noticed that you had a new microphone. You still sound very low.
but your content is still great *thumpsUp*
Hi from Italy, Are u doing a DCF on Meta after H1?
Can you please build a DCF model for construction company?
The revenue from 10k does not match your historical data, is there something else I’m missing ?
Hi ben, where do you find all these numbers to work with?
Hey Ben! I'm really curious about your desk setup! I saw you were finished with your new place(I follow your insta)
will be making a video about this soon!
Your content is amazing! Please, could u do a Valuation for M&A or IPO company? Appreciate it!
If you please, can I have a blank Excel sheet so that we can walk with you step by step
YESS!
Despite the economic downturn, I'm so happy 😊. I have been earning $6,000 returns from my $13,500 investment every 13 days
I have also been trading with him, the profits are secured and over a 100% return on your investment directly sent to your wallet. I made up to $15,000 in 2Months trading with him.
After watching so many youtube tutorial videos about trading I was still making losses until Mr Hillary Mark started managing my investments now I make $6,567 weekly. God bless Mr Hillary he's been a blessing to my family.
Trading investment is a safer and surest way to make more money now because I have made up to $121,700 recently from investment trading and management.
With an initial investment of $5,400 I made up to $11, 700 in just a week's trading with him, Mr Hillary strategies are mind blowing.
Please how do I get a professional I don't know anyone, to bother you but do you have any that I could work with?
@ Sr. Liquid, your channel is being inundated with spammers masquerading as you.