This guy is a genius. I have attended paid course of Financial modelling where many industry experts have taught this FM. But the way you have done it is really good and done it with simplicity and easy to understand. It is really very helpful for me.
Thank you so much bringing this video, the content is exceptional as always. Requesting the following: 1. A quick video on 3 Statement Model as firms love sending them as assignment after interviews. (eagerly waiting) 2. Video on LBO and Merger Models. 3. A video on Investment decks and teasers. I've created a few but learning from you is always a pleasure. Loving the content :) Keep up the good work !!
Loved the content sir!! But i have a question that - While determining under or over valuation, If Comparison from any 1 Comparable Factor lets say EV/Revenue comes out to be Overvalued and other are undervalued , then What to ccnsider Whether its overvalued or undervalued? Should we consider the factor more reliable as per industry trend ?
Can you please explain why you considered median of the comps to determine implicit share value and not the average? What is the purpose of calculating 25 percentile, 75 percentile and high/ low if we are not using them for determining the implicit share price of Cipla ?
Good Learning, am also preparing notes side by side. Why Implied Market Value for P/E ratio is calculated as "median * Net Income" and why we did not use this formula for Implied EV for P/E?
Is industry wise revenue model provided in the training? for example instead of deriving the revenue on growth rates, how can we derive coming up the revenue number with industry metrics? for example for hospitality, Revenue = Average room rate x No of rooms adjusted for organic and inorganic growth taking into consideration price growth and volume growth?????? OR REVPAR
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
Bhai when EBITDA or EBITDA margin is not given in screener then go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
Sir jo bhi sikhaya hai ....usko thoda aur depth mai sikha dete toh :) ......like ratio, beta, intrinsic growth, terminal value......sbkuch...duaaa lagegi meere jese gareeb ki excel toh seekh hee rhe hai aap ki meherbani se bs, theoritical knowledge bhi mil jaati toh bhla ho jaata :) god bless you
Refer CA Atul agarwal sfm revision lectures for CA Final. Most of the concepts are covered in depth and even 1st time viewing will help in understanding concepts.
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
Hi guys, want to understand whether Equity value is simply market capitalisation or Equity share capital plus Reserves, so which equity value should we consider while calculating cost of equity
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
Sir i couldn't find EBITDA and EBITDA margin for peer comps of Asian paints including Asian paints how should I calculate to find values of EBITDA ?????
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
1. Try using EV/Ebitda & reverse calculate 2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation 3. Take the EBIDTA of 10 companies 1 by 1
The session is really good and unexpected to be honest and really appriciate your efforts Can you please make video on ANOVA Table and Capital IQ eager to learn that
Bhaiya the format we uploaded on screener and when we are downloading financial odf other company the figures are not matching because there are different expenses for different company. I have checked for most of the the companies the actual figures are deviating from the calculated figures in excel. and if these figurese deviate how can we calculate the FCFF Correctly. You can cross check the same. Examble we have made trhe historical FS sheet of Tata motors and after uploading the same on screener and downloading different companies financial in excel we are getting different figures.
Hello parth, just one major doubt . why did you calculated Implied equity value of PE by multiplying , multipe and net income. i didnt understand that. as to get equity value we dont use it.
Because the other two formulas have EV in their Numerator, But P/E has Price as Numerator. And since P/E has EPS (net Income) in its Denominator, we multiply Net income and the multiple to get the Market Value and adjust it back to get EV.
This guy is a genius. I have attended paid course of Financial modelling where many industry experts have taught this FM. But the way you have done it is really good and done it with simplicity and easy to understand. It is really very helpful for me.
Thank you so much bringing this video, the content is exceptional as always. Requesting the following:
1. A quick video on 3 Statement Model as firms love sending them as assignment after interviews. (eagerly waiting)
2. Video on LBO and Merger Models.
3. A video on Investment decks and teasers. I've created a few but learning from you is always a pleasure.
Loving the content :) Keep up the good work !!
Har bar video complete hone ke baad, ek hi chiz nikalti hai "Maza aa gaya"❤❤
Parth Bhaiyya, I highly appreciate your efforts from the bottom of my heart !! Thanx a lot
3 din se daily aapke channel pr visit kr rha tha is video k liye
Thank you Sir ❤️
Bell notification on karlo
Thanks Parth Sir for uploading..I was waiting since morning to get this video 😅
love you sir for continuing this series!!♥️♥️
Taught financial modelling in a wonderful manner
Sir we are very lucky to learn professional modelling. ❤
Premium content " A Big Salute To You " @Parth Sir
Loved the content sir!! But i have a question that - While determining under or over valuation, If Comparison from any 1 Comparable Factor lets say EV/Revenue comes out to be Overvalued and other are undervalued , then What to ccnsider Whether its overvalued or undervalued?
Should we consider the factor more reliable as per industry trend ?
Sir respect apke liye hr vedio ke bd or bd jati h 🫡❤️
Pov. me to these videos and Parth Sir Ek hi Dil h Kitni Bar Jeetoge Sir
now after seeing your financial modelling series learned how to make a financial model Keep it Up sir 👍👍
#Question Why didn't I find EBITDA on the Screener website's filter option?
have u found the solution forit?
Try using EV/Ebitda & reverse calculate
try ebitd
@@varad15 EV/(EV/EBITDA) will give u EBITDA
Hi, would like to learn about industry analysis from you. Thank you for the amazing content
Thank you so much for Financial modelling video that too for Free
Great content.....explained very clearly....thank you sir...
very informative and easy to grab... thank you for your devotion
Tysm for this kind of quality videos
I learned alot with all your videos. i want new videos of startup valuation .
Can you please explain why you considered median of the comps to determine implicit share value and not the average? What is the purpose of calculating 25 percentile, 75 percentile and high/ low if we are not using them for determining the implicit share price of Cipla ?
Thanku so much for these amazing series
Good Learning, am also preparing notes side by side. Why Implied Market Value for P/E ratio is calculated as "median * Net Income" and why we did not use this formula for Implied EV for P/E?
same question
Top Notch Content!!!
Waiting for your video sir ❤
First like 👍
First view
So nice of you
Sir mene puri pichle videos dekhi hai ,bhot kuch sikhne mila muje,......sir ek question tha ki estimation me BS,IS,CF bhi estimate kiya jata hai na?
Thank you sir, for such a valuable course
Is industry wise revenue model provided in the training? for example instead of deriving the revenue on growth rates, how can we derive coming up the revenue number with industry metrics? for example for hospitality, Revenue = Average room rate x No of rooms adjusted for organic and inorganic growth taking into consideration price growth and volume growth?????? OR REVPAR
Sir in my screener EBITDA Margins filter is not available
Same
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
There is no ebitda margins can we take eve
bitda
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
Loved the session ❤
Sir, I have been trying to add EBITDA Margin in screener, but only EVEBITDA is showing, please suggest what should i do?
Thats not possible, screener works same for everyone.
In your case fetch EVEBITDA and EV
Then fetch EBITDA by division
@@thevaluationschool Yes she is right i got the same issue but i use EBIT and Add dep at that
next time i will use your short trick
@@govindgoel369 pls explain in detail.. I'm also facing the same issue.. how to fetch it explain me if u understood....Is it EV/EVEBITDA= EBITDA ?
@@Healthyfitdiet EV/ EV/EBITDA= EBITDA
@@govindgoel369 thank you
Great work 🎉
WHILE SELECTING COLUMNS. IF EBITDA MARGIN AND EBITDA ARE NOT GIVEN AND EVEBITDA IS THERE SO CAN WE CONSIDER THAT?
Take the EBIDTA of 10 companies 1 by 1
EVEBITDA= Enterprise value ÷ EBITDA
Bhai when EBITDA or EBITDA margin is not given in screener then go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
Bro we can take opm
Try using EV/Ebitda & reverse calculate
Sir jo bhi sikhaya hai ....usko thoda aur depth mai sikha dete toh :) ......like ratio, beta, intrinsic growth, terminal value......sbkuch...duaaa lagegi meere jese gareeb ki excel toh seekh hee rhe hai aap ki meherbani se bs, theoritical knowledge bhi mil jaati toh bhla ho jaata :) god bless you
Refer CA Atul agarwal sfm revision lectures for CA Final. Most of the concepts are covered in depth and even 1st time viewing will help in understanding concepts.
@@parthshah7048thank you sir aap personal account se bhi response de rahe ho students ke liye
Great Session Sir.
hello sir EBITDA Margins are not available in screener so is it okay if i take EV/EBITDA and multiply it by EV
Sir can you explain the logic for going in reverse order for calculating EV through P/E multiple
Great learning session, I missed the technical analysis workshop please if possible can it done again??
Hats off to you Sir ❤
EBITDA or EBITDA margin is not available in screener edit column section where to get it?
what did u do?
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
thankyu so much guruji
Sir, out of these values which Implied value per share should we considered while comparing with current share price? Can you please explain?
Ye session chlata rho
Huma Lbo and m&A bnana bhi sikhata hoon 😄
Has screener stopped giving their free services? Like I cant export any data to excel
Sir please make videos on more depth topics. Everready for new learnings
Sir i am doing relative valuation of Mining/Minerals company, but on screener there is no EBITDA Margins?
Give me a solution related to it
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
wonderfull class
Hi guys, want to understand whether Equity value is simply market capitalisation or Equity share capital plus Reserves, so which equity value should we consider while calculating cost of equity
Equity Share capital + Reserves = shareholders fund
Commandable job Sir
Is there any difference between equity value and market capitalisation?
Sir LBO model kaise banate uspe videos bana do...
Ty sir for this..very helpful
Parth Now I am not able to get EBITDA margin columns in screener , what should I take Instead . please Reply on my comment.
Exactly !! stuck here . Please reply if possible
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
Gzb❤❤
Love you sir. Please make more videos
Thanks for the video...
Sir i couldn't find EBITDA and EBITDA margin for peer comps of Asian paints including Asian paints how should I calculate to find values of EBITDA ?????
it will be by name EBITD
You can also edit and add your own ratios in screener
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
EBITDA Margins ratio is not there in screener. What do I do?
1. Try using EV/Ebitda & reverse calculate
2. go in trendlyne and you can get EBITDA values for individual companies which you can put in EBITDA coloumn for comparable company valuation
3. Take the EBIDTA of 10 companies 1 by 1
@@bboyvishal Thanks
@@bboyvishal I reverse calculated EBITDA margin by finding out EBITDA.
Ty sir loved it
Mujhe debt schedule kese karte hai wo dekhna tha aur dep schedule also if you don't mine.
Sir please. Debt schedule par video banayiye na
Please make a video on valuation ratios
Sir screener pe EBITDA Margin nahi show ho raha hai Pls help
Sir, Which Muntiple to use and When?
The session is really good and unexpected to be honest and really appriciate your efforts
Can you please make video on
ANOVA Table and Capital IQ eager to learn that
Bhaiya the format we uploaded on screener and when we are downloading financial odf other company the figures are not matching because there are different expenses for different company. I have checked for most of the the companies the actual figures are deviating from the calculated figures in excel. and if these figurese deviate how can we calculate the FCFF Correctly. You can cross check the same. Examble we have made trhe historical FS sheet of Tata motors and after uploading the same on screener and downloading different companies financial in excel we are getting different figures.
22:27 tere saath shri raghunath toh kis baat ki chinta
Good content!
Bauth maza aaya
thank uu🤩😍😍
Thanks a lot
Sir now even Screener Has made it a premium service can you please tell any other Website?
Thank You
Helpful
Thank you Sir!!
Content is 🧡
Can't we do automation in this relative valuation ?
thankyou sir
sir Mujhe check karwana hai apna model
Can anyone tell what i have ti do in ticker
Why do we multiply it by Median?, Why not with Average?
Hello parth, just one major doubt . why did you calculated Implied equity value of PE by multiplying , multipe and net income. i didnt understand that. as to get equity value we dont use it.
Because the other two formulas have EV in their Numerator, But P/E has Price as Numerator. And since P/E has EPS (net Income) in its Denominator, we multiply Net income and the multiple to get the Market Value and adjust it back to get EV.
How to get the valuation school course?
Great
Can any finance student can get job by knowing this skills from this video?
Do it for learning buddy, job should never be the main reason for learning. It depends upon how you execute it.
hey parth isnt P/E = CURRENT MARKET PRICE / EPS?
NVM it gives the same answer
Sir LBO model please
Proforma model
I am watching this video in June 2024 and Cipla's current price is 1560 😂, made the model and now it shows overvalued.
Sir aap toh copy krte ho kenji ko😂
❤️
Thank you so much sir..
great