⬇ Download the Excel for FREE ⬇ ► www.wallstreetprep.com/access/chipotle-dcf-model/ ► Sign up to get emails notifications for my streams and when the excel models are available: forms.gle/jMUPmnSp5pvC9sQb6 🖥Wall Street Prep - Hedge Fund Investing Certification🖥 ► Use code RARELIQUID to get $300 OFF! ► secure.enroll.wharton.wallstreetprep.com/referral/DSczdzDz/s2yqD1GUkwps4u5h
Hi...Thank you so much for this amazing content. Can you please guide me on where you get the historical and forecasted financial Statements from? Also, can you please make a video on how to make projected financial statements?
can't unless you pay up for something like factset or capiq. u may be able to get some cheaper options but they likely won't be super reliable. or if there are other sources i'm just not aware of them
Ben - what is your end game with all of this? Purely to teach finance in a creative way? Or do you want to get back into the game so to speak at some point?
have different side products that i'm pretty excited about but for the next few years i still have a lot of content ideas. ideally never want to work in the corporate world again
the year end at the top of the DCF model, is that the fiscal year end or the calendar year end? does it affect the valuation if the fiscal year end isnt 31 dec?
That’s one of the challenges with the DCF. You have to make assumptions. There are no right or wrong assumptions. You have to be able to logically prove the reason behind you assumptions. In a high level DCF, you can go with what analysts think revenue will be. This information can be found on Yahoo finance, if you don’t have access to equity research platforms. When I project numbers into the future, I use medians instead of averages. Medians take into account outliers. Some people prefer averages. You can use what works with your assumptions and model. I hope this helps.
⬇ Download the Excel for FREE ⬇
► www.wallstreetprep.com/access/chipotle-dcf-model/
► Sign up to get emails notifications for my streams and when the excel models are available: forms.gle/jMUPmnSp5pvC9sQb6
🖥Wall Street Prep - Hedge Fund Investing Certification🖥
► Use code RARELIQUID to get $300 OFF!
► secure.enroll.wharton.wallstreetprep.com/referral/DSczdzDz/s2yqD1GUkwps4u5h
Literraly the best way that i practices and learn financial modeling during my Master's years.
The best way in your experience is to watch someone else build out a model like this? What is the alternative way of learning? Through textbooks?
Can you do a dcf model where you show your keyboard as well? I’m trying to practice the shortcuts that can help with time a lot. Thanks so much
100%
Agreed
Likewise
will do
⏱Timestamps⏱
0:00 - Introduction
7:44 - Chipotle Situation Overview
9:00 - Trading Comps
13:00 - DCF Starts
15:57 - Income Statement
27:40 - Cash Flow Items
34:20 - Projecting Free Cash Flow
54:58 - Mid-Year Convention
57:30 - Calculating Diluted Shares
1:13:05 - WACC
1:16:50 - Present Value of Free Cash Flow
1:19:43 - Terminal Value
1:22:25 - Implied Share Price
1:35:49 - Price Discussion
1:38:37 - Sensitivity Table
A question here, why is the CapEx at Cash Flow Item positive, whereas the data is negative?
Hi...Thank you so much for this amazing content. Can you please guide me on where you get the historical and forecasted financial Statements from? Also, can you please make a video on how to make projected financial statements?
Oof I was worried that my DCF was seriously wrong, but happy to see that our implied share price is pretty similar (lots of downside)
Please we need a video about the shortcuts
He has already done that in the description
Yo I love the videos but I have a question. How can I find the street estimates so I can make my own models? It’ll be a great help bro.
can't unless you pay up for something like factset or capiq. u may be able to get some cheaper options but they likely won't be super reliable. or if there are other sources i'm just not aware of them
Thank you for the DCF! I'm waiting for the link so I can get historical numbers and estimates and build the model.
updated!
Hi Ben! Amazing video. Question question as to how did you pick the Base (Street) revenue forecasts? Is there an independent source for it?
Ben - what is your end game with all of this? Purely to teach finance in a creative way? Or do you want to get back into the game so to speak at some point?
have different side products that i'm pretty excited about but for the next few years i still have a lot of content ideas. ideally never want to work in the corporate world again
@rareliquid That implied share price is very low. Did you add the sum of the PV of all FCF anywhere to determine the EV?
Yeah I think he knows to include stage 1 and 2 lol
Hello, can we also donwload the comparison sheet with different restaurants?
If you ever built a model for companies with their main operations in Europe, what terminal growth rate did you use for the base case?
Hey Ben, could you do a DCF of MELI?
bon apetit, ben!
Where did pull the forecast and statements from?
the year end at the top of the DCF model, is that the fiscal year end or the calendar year end? does it affect the valuation if the fiscal year end isnt 31 dec?
Hey, could you do a DCF about SMCI?
Why is EBIAT = Revenue - EBIT? I noticed you did that one calculation to find EBIAT towards the end but I still can't get it. Please help :)
Agreed, struggling here as well. I thought EBIAT should = EBIT - Taxes which is what what he had originally
Never mind he caught it
@@Daniel.P.Cole10 haha yea, commented too soon :)
Hey, are online degrees given equal reputation and status, while applying for mba?
how do i forecast revenue and stuff??
Would be interested in this as well
That’s one of the challenges with the DCF. You have to make assumptions. There are no right or wrong assumptions. You have to be able to logically prove the reason behind you assumptions. In a high level DCF, you can go with what analysts think revenue will be. This information can be found on Yahoo finance, if you don’t have access to equity research platforms. When I project numbers into the future, I use medians instead of averages. Medians take into account outliers. Some people prefer averages. You can use what works with your assumptions and model. I hope this helps.
where to Download the Excel?
in the description
It says link coming soon
@@ksrini74he said that a year ago 😂😂
You can download the earlier model from the previous Live videos descriptions
Williams Ronald Hernandez Sarah Gonzalez Margaret