hello sir i have small doubt that is sales growth of year 2013 was not available but you have link 2014 sales growth in the column of 2013 may i know why please reply @valuationschool
08:55 You are calculated EBT growth in place of EBIT growth. Kindly check. 43:13 Inventory Turnover should be calculated as COGS/Inventory, not sales ( I know sir is taking rough no. at some places but here both COGS and Inventory are given) . . . . . . . . Dated :- 24 Aug 2023
Sir i have started studying financial modelling from your videos and the way you teach is just best. I really like the way in which you are teaching to do stuff
Sir I'm very grateful to have you sir 🤗 when you say "nalayako" then I feel like my mentor is teaching me very seriously. And you are a very humble person I hope God will succeed you and bless you with your wants and everything.
Hey Parth, thanks for your time and efforts!! 1. While calculating inventory T/O- we have considered Sales, while usually we consider COGS. 2. In the FM , why are we preparing data for last 10 years, any particular reason. In practical cases, we dont get data for more than 2 FY from clients for private companies.
i think what you taught us we have already learned it in our MBA corporate finance but even after doing 2 years of full time MBA i was not confident enough to craft a model like this but after learning for free here im confident enough to craft a model anytime anywhere at any circumstances. hence thank yoo
Thank you, sir, I am a charted financial analyst with almost 9 years in fund management but after your mentoring, I just feel like I have plenty to learn, really amazing and professional way of working. Hats off.
I was trying to figure out how we adjusted for the LTM the entire time, something I found hard to accept XD and finally it got rectified at 33:32. Huge shoutout to the work that has been put in, I have watched all your previous videos and it had a lot of learning for me. Thanks!
Hello sir, love your efforts One thing I'd like to point out, where you plotted the operating income as % of sales(17:13) , you have taken operating income in the sense of operating profit which I find wrong In this data we don't have any non operating incomes (other incomes) and only revenue source is the sales. Still I think operating income should not be confused with operating profit❤❤
Hello sir, I have started studying financial modelling from your youtube videos. I really thankful to you teaching us financial modelling in a very professional way in free of cost. Thank you very much sir. I hope like this courses you will teach more other professional courses that help in career building
52:42 Sir median would get affected cuz it is a positional average and by adding one blank cell u are adding one element i.ee 0 to it so the actual median should be 8.10% but it is coming out to be 3.76% as per the video. Thanks a lot sir for posting such great content!!
Thank you Brother. I am a civil engineer working as a TEV consultant in a financial firm. i Liked & Subscribed to ur channel and trying to learn FM. Keep it up bro . Thanks
Great Job Sir, Thanks for Creating Free Financial Modelling Course for us that can't afford so much costly courses like this. This is Moreover worthy than those which are paid.
Sir Thanks a ton. U r a true mentor. I'm from a non-finance background and i was having difficulty in understanding ROCE, and u actually explained it again...Seems like u r sitting the mind of us😅. Lots of Love❤
Isn't inventory turnover ratio, COGS/Average inventory. In the CFA curriculum also, COGS is taken. I know it's a turnover ratio so Sales/Revenue must be considered, but the formula says otherwise. P.S Thanks a lot for these videos Parth Sir, really appreciate your efforts. 👍
Thank you so much Parth sir, You have abled your worthy students to learn and strive to be better without any excuses related to cost or accessibility. I for one am deeply grateful to you and your efforts will definitely help me have huge impact on my career. Someday i hope i can give out to the society like you do.
Again the session was good. One correction i wanted to point out is that for calculating creditors turnover and inventory turnover you have taken sales whereas purchases should have been taken or if that is not available then COGS was an alternative option.
44:25 Negative Cash Conversion Cycle doesn't mean it is shortfall. It means Inventory is sold before you even have to pay for creditors which is good thing for a company. Otherwise, great session sir!
One of best channel for the get knowledge about financial modelling and finance filed and sir the classes are really very much awesome and i was looking for the learning the financial modelling but the course fees were very high more then 15,000 and 30,000 because of it i was not able to learn the financial modelling Thankkkk you soooo much sir for helping people for gaining the knowledge about the finance filed and financial modelling the video's are very much awesome and easy to understand i wish you get more and more reach and get lot of success in your life Sir☺
I love your content Parth. All your sessions are really useful for learning how to build a financial model. I can feel that your efforts to teach are genuine & sincere & because of that we are getting more insights. SO THANK YOU FOR THAT! Keep up. Take care
Sir I'm from Pakistan Really appreciate your efforts Please upload videos regarding financial planning and analysis !!! If it's a paid course, even then I'm interested in your paid course regarding this . Kindly consider this request
Good Evening Sir I have watched these videos on series .it is very easy and very helpful for any student.at last thankyou for your support and support ❤
Thank you so much sir for making step by step videos i am scared about this financial modeling. Now I have confidence in this 😊 Thank you so much sir 🙏
Thankyou so much sir .. this entire series is really insightful and helpful... your teaching style is just amazing... We all are really greatful to have you as a teacher... once again thankyou so much parth sir ..❤
Very well designed training programme....people would pay through their nose for training which is aired free keep up the good work...Parth sir you rock
Really like the way you teach, too informative , itna sikh ke bhot level up lag rha hai, and bhich bhich me daanth bhi diya karo, to ham line me rehte hai. Thank you sir
Hi Parth Sir, Absolutely loved the way you teach us and enjoy each and every video watched. However, I have some doubts relating to this session which I mentioned below 1. While learning the ratio analysis in CA IPCC we prefer average concepts like average debtor for Debtor turnover ratio, average inventory for Inventory turnover ratio, etc and 2. For calculating inventory turnover ratio or creditor turnover ratio we prefer COGS more than sales in classes The question is do we follow the same concept in financial modeling or not?
@Thevaluationschool Sir, you have caused some confusion in Explaining about advisable dividend distribution. You have said both the things that: It's advisable to distribute the dividend when ROCE>WACC, also you've said that when ROCE
Amazing.. loved it ❤i enjoyed watching and doing it by myself 😍 What i did is i started video on my mobile phone kept it in landscape mode near laptop and did the practice side by side on my laptop .. Try it 😀
a way your are teaching its outstanding. free you are proving this course means alot sir for us. thank you very much for this and please one more request you have great command on excel please teach basic and advance excel as well.
Amazing videos, i have been in this industry for past 3 years but still i am getting to learn a lot of things. Very helpful, looking forward to more such videos.
at 12:51, I feel there is mistake, the linking is kinda wrong, the march-22 column is actually the LTM column. EDIT - actually is rectified at 33:36 by sir
Dear Partha Sir, These videos are really nice and easy to understand, I have experience in Accounting and i am a non CA guy, having 14 years of experience in Accounts Receivable and Revenue Assurance and data reconciliation. Now i have lost my job. I am preparing watching your videos and after i look in to these videos i am getting confidence that i will get a job again. But I have one doubt sir that these videos are more relating to IB. Could you please make some videos which can help to learn budgeting and forecasting which can help us to get in to FP&A Job Profile sir. If possible i would request you sir to make it it will be really help a lot to us.👋👋👋
Thank you Sir for teaching this skill, it is the most easiest series of financial modelling which can be understood by a 12th class also Hats off to you Sir✨✨
One more thing I would like to ask you have not mentioned why mean and medians are used in ratio analysis, if it is possible can you please revert it back with a positive response Thank you
Thank you so much sir for creating such a mind-blowing series and thank you for saving my money . Your dedication to spreading knowledge is truly commendable, and it's making a positive impact on so many of us who are eager to learn. Keep up the fantastic work, and please know that your efforts are genuinely valued and appreciated!"
Happy to learn from your videos.Parth sir I'm very impressed by your teaching style. It is very clear and perfect for the bcom stream students as i m, thank you so much sir hope you will bring more videos on M&A,valuation,LBO,IPO etc.🙏🙏🙏
Thanks.Home work done with tata steel. Just have a suggesting. While making video try to use shortcut if u use cursor so we even start touching the mouse with that subconsciously.
Just 1 feedback, I think like me, a large number of people here are from an Engineering background and working in the Financial dept. of some company. We may not know many of formulas that are being discussed here, but we are willing to learn. So if you can give a little bit of background and could tell any additional topics is that are necessary, then it would be a great help.
Apologies for the heavy voice and weird sounds in between. I was sick with heavy cold while recording this session.
Sir you’re literally a gem for CA freshers and other candidates. Hope you get well soon!
we are thankfull to you sir , such level of dedication hats off to you sir
Voice is matching with content, it should be like this not to get bored ❤❤❤
but still very clear, appealing and convincing 😊
hello sir i have small doubt that is sales growth of year 2013 was not available but you have link 2014 sales growth in the column of 2013 may i know why please reply @valuationschool
08:55 You are calculated EBT growth in place of EBIT growth. Kindly check.
43:13 Inventory Turnover should be calculated as COGS/Inventory, not sales
( I know sir is taking rough no. at some places but here both COGS and Inventory are given)
.
.
.
.
.
.
.
.
Dated :- 24 Aug 2023
Bro my consern is also same if you get answer from sir please share solution to me 🙏
Yes
Have you got the solution??
Creditor Turnover Ratio is also incorrect
@@007keyboard-warrioryes
Sir i have started studying financial modelling from your videos and the way you teach is just best. I really like the way in which you are teaching to do stuff
Sir I'm very grateful to have you sir 🤗 when you say "nalayako" then I feel like my mentor is teaching me very seriously. And you are a very humble person I hope God will succeed you and bless you with your wants and everything.
Sharma j i bhi yaad a Jaye hai 😂
Why u teach us wrong formula of DS, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
@@sarthakkumar3243 useless people have not done something great,have not heard something greatand therfore don't speak great for others
What else can we say..its really a blessing to get mentored by you. Thank you sir.
Thank you so much for saving my 45K and bringing such good quality content. Totally hooked to this series. Thanks Again!
Hey Parth, thanks for your time and efforts!!
1. While calculating inventory T/O- we have considered Sales, while usually we consider COGS.
2. In the FM , why are we preparing data for last 10 years, any particular reason. In practical cases, we dont get data for more than 2 FY from clients for private companies.
i think what you taught us we have already learned it in our MBA corporate finance but even after doing 2 years of full time MBA i was not confident enough to craft a model like this but after learning for free here im confident enough to craft a model anytime anywhere at any circumstances.
hence thank yoo
Seriously i am watching all your videos, the way you are describing all the things in the financial modelling is just awesome
Can u please tell me whether excel sheet provided by sir enabling you to edit (I'm unable to type anything in that sheets)
Thank you, sir, I am a charted financial analyst with almost 9 years in fund management but after your mentoring, I just feel like I have plenty to learn, really amazing and professional way of working. Hats off.
I started learning this skill and I must say that I am thankful for this course. Hope to see more in future related to other skill.
I was trying to figure out how we adjusted for the LTM the entire time, something I found hard to accept XD and finally it got rectified at 33:32. Huge shoutout to the work that has been put in, I have watched all your previous videos and it had a lot of learning for me. Thanks!
SAME ahhahaha
Hello sir, love your efforts
One thing I'd like to point out, where you plotted the operating income as % of sales(17:13) , you have taken operating income in the sense of operating profit which I find wrong
In this data we don't have any non operating incomes (other incomes) and only revenue source is the sales.
Still I think operating income should not be confused with operating profit❤❤
Brilliant Session. Recommend this to everyone. He teaches from basics and gradually moves to advanced.
I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
Hello sir, I have started studying financial modelling from your youtube videos. I really thankful to you teaching us financial modelling in a very professional way in free of cost. Thank you very much sir.
I hope like this courses you will teach more other professional courses that help in career building
52:42 Sir median would get affected cuz it is a positional average and by adding one blank cell u are adding one element i.ee 0 to it so the actual median should be 8.10% but it is coming out to be 3.76% as per the video. Thanks a lot sir for posting such great content!!
Thank you Brother. I am a civil engineer working as a TEV consultant in a financial firm. i Liked & Subscribed to ur channel and trying to learn FM. Keep it up bro . Thanks
Absolutely Phenomenal, loved the teaching style & content making it very simple & easy to learn FM
Best mentor for financial modeling ever.
Thank you so much sir.
I am working on my project and your videos are helping me a lot.
Always grateful for the abundance of knowledge but the initiative to provide such high value study at no cost, is commendable. Truly inspired!🙏
Great Job Sir,
Thanks for Creating Free Financial Modelling Course for us that can't afford so much costly courses like this.
This is Moreover worthy than those which are paid.
Sir Thanks a ton. U r a true mentor. I'm from a non-finance background and i was having difficulty in understanding ROCE, and u actually explained it again...Seems like u r sitting the mind of us😅. Lots of Love❤
you have one student from Canada too....thanks for the financial modelling series
What a session! Thank you so much Parth sir! Your commitment to take this session even though you were not well and with such clarity is amazing.
Thanks a ton
Why u teach us wrong formula of DS, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
Isn't inventory turnover ratio, COGS/Average inventory. In the CFA curriculum also, COGS is taken. I know it's a turnover ratio so Sales/Revenue must be considered, but the formula says otherwise.
P.S Thanks a lot for these videos Parth Sir, really appreciate your efforts. 👍
Also creditor turnover ratio is purchases/payables not sales/payables
Thank you so much Parth sir, You have abled your worthy students to learn and strive to be better without any excuses related to cost or accessibility. I for one am deeply grateful to you and your efforts will definitely help me have huge impact on my career. Someday i hope i can give out to the society like you do.
Again the session was good. One correction i wanted to point out is that for calculating creditors turnover and inventory turnover you have taken sales whereas purchases should have been taken or if that is not available then COGS was an alternative option.
Agree with you
yes this is correct
Yeah I wanted to ask the same question
44:25 Negative Cash Conversion Cycle doesn't mean it is shortfall. It means Inventory is sold before you even have to pay for creditors which is good thing for a company. Otherwise, great session sir!
was thinking the same
One of best channel for the get knowledge about financial modelling and finance filed and sir the classes are really very much awesome and i was looking for the learning the financial modelling but the course fees were very high more then 15,000 and 30,000 because of it i was not able to learn the financial modelling Thankkkk you soooo much sir for helping people for gaining the knowledge about the finance filed and financial modelling the video's are very much awesome and easy to understand i wish you get more and more reach and get lot of success in your life Sir☺
Thank you for all your efforts! Best Series of Financial Modelling i have ever watched
I love your content Parth. All your sessions are really useful for learning how to build a financial model. I can feel that your efforts to teach are genuine & sincere & because of that we are getting more insights. SO THANK YOU FOR THAT! Keep up. Take care
Happy to hear that!
Why u teach us wrong formula of DSO, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
Great Channel for Finance The valuation School
Sir really enjoyed in learning this session. Thank you so much for making career of many peoples.
Sir I'm from Pakistan
Really appreciate your efforts
Please upload videos regarding financial planning and analysis !!!
If it's a paid course, even then I'm interested in your paid course regarding this .
Kindly consider this request
Sir you are doing a great work and we are so grateful to have a teacher like you.
It's my pleasure
Sir , The way you teach is awesome and you do it the way that any fresher can simply understand , Thank you so much for your efforts
Thank you Parth Verma Sir for this valuable course.
Looking forward for more videos like this.
Please keep bringing up value adding courses like this.
thanku more vedios about investment banking
Thankyou Sir, for this beautiful content
I am Glad to part of this journey
Good Evening Sir
I have watched these videos on series .it is very easy and very helpful for any student.at last thankyou for your support and support ❤
these videos are gonna break records soon....mark my words !
Thank you so much sir for making step by step videos i am scared about this financial modeling. Now I have confidence in this 😊
Thank you so much sir 🙏
Thankyou so much sir .. this entire series is really insightful and helpful... your teaching style is just amazing... We all are really greatful to have you as a teacher... once again thankyou so much parth sir ..❤
Thanks, Dear Path Sir, it helps me to understand new techniques of learning finance through Excel
Very well designed training programme....people would pay through their nose for training which is aired free keep up the good work...Parth sir you rock
Why u teach us wrong formula of DSO, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
you are doing best job for those who are no affordable from market, fantastic class, love you sir❣❣❣❣❣❣❣❣
Brother you're doing a great job, we need such content on the internet. hats off
Really like the way you teach, too informative , itna sikh ke bhot level up lag rha hai, and bhich bhich me daanth bhi diya karo, to ham line me rehte hai. Thank you sir
Great videos - Which you can get the knowledge of Financial Modelling
Masterclass on Financial Modelling. All fears busted .Tones if Respect for you Parth Sir
It’s great that you are sharing your wisdom with us
The sessions are superb
Thanks for creating all videos, I have downloaded all and keep listening and practicing in my free time..
Hi Parth Sir,
Absolutely loved the way you teach us and enjoy each and every video watched. However, I have some doubts relating to this session which I mentioned below
1. While learning the ratio analysis in CA IPCC we prefer average concepts like average debtor for Debtor turnover ratio, average inventory for Inventory turnover ratio, etc and
2. For calculating inventory turnover ratio or creditor turnover ratio we prefer COGS more than sales in classes
The question is do we follow the same concept in financial modeling or not?
same doubt
Yes, I know, But will show you in upcoming videos why u should deviate from what is being taught to us in academics
@Thevaluationschool Sir, you have caused some confusion in Explaining about advisable dividend distribution. You have said both the things that: It's advisable to distribute the dividend when ROCE>WACC, also you've said that when ROCE
roce>wacc to dist div
Amazing.. loved it ❤i enjoyed watching and doing it by myself 😍
What i did is i started video on my mobile phone kept it in landscape mode near laptop and did the practice side by side on my laptop .. Try it 😀
a way your are teaching its outstanding. free you are proving this course means alot sir for us. thank you very much for this and please one more request you have great command on excel please teach basic and advance excel as well.
how can your videos be this intresting, despite a boring subject as fm, kudos
Brother, you're doing a great job. hats off, we need more productive content like this online 👍
Thank you for your knowledge sir even the paid courses are not worth in comparison to your videos. Thank you so much
Absolutely loved your content which is way practical not leaving scratch. Thanks sir.
Why u teach us wrong formula of DSO, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
your videos are of great help to me in preparing my projects thank u for bringing such great content 🙌
Amazing videos, i have been in this industry for past 3 years but still i am getting to learn a lot of things. Very helpful, looking forward to more such videos.
Happy to help!
Sir, great session. I am watching your videos and performing the same and getting addictive towards learning.
Sir, thank you for creating such a great content. I love the way you teach with ease is just fabulous.
this will be the most useful videos providing quality content and must for all the finance enthusiat
keep growing sir
haths off to you
grateful for the session. new learnings. well explained.
You are such an amazing expert
one of the best Education Channel till now for me. pure knowledge content.
Glad you think so!
@@thevaluationschool Sir thankyou for this series. looking forward for more finance related content.
Only one word- "BEST"
Seriously the best course ever!!!!!!!!!
at 12:51, I feel there is mistake, the linking is kinda wrong, the march-22 column is actually the LTM column. EDIT - actually is rectified at 33:36 by sir
I appreciate all of your hard work 😊😊. Your videos are really empathetic.
Dear Partha Sir, These videos are really nice and easy to understand, I have experience in Accounting and i am a non CA guy, having 14 years of experience in Accounts Receivable and Revenue Assurance and data reconciliation. Now i have lost my job. I am preparing watching your videos and after i look in to these videos i am getting confidence that i will get a job again. But I have one doubt sir that these videos are more relating to IB. Could you please make some videos which can help to learn budgeting and forecasting which can help us to get in to FP&A Job Profile sir.
If possible i would request you sir to make it it will be really help a lot to us.👋👋👋
Sir i Appreciate your Efforts. Pls Never Stop.
Thank you Sir for teaching this skill, it is the most easiest series of financial modelling which can be understood by a 12th class also
Hats off to you Sir✨✨
One more thing I would like to ask you have not mentioned why mean and medians are used in ratio analysis, if it is possible can you please revert it back with a positive response
Thank you
Thank you so much sir for creating such a mind-blowing series and thank you for saving my money . Your dedication to spreading knowledge is truly commendable, and it's making a positive impact on so many of us who are eager to learn. Keep up the fantastic work, and please know that your efforts are genuinely valued and appreciated!"
I am getting impeccable knowledge from u r ERC and this modelling series thanks a lot sir 🙏🙏🙏
Happy to learn from your videos.Parth sir I'm very impressed by your teaching style. It is very clear and perfect for the bcom stream students as i m, thank you so much sir hope you will bring more videos on M&A,valuation,LBO,IPO etc.🙏🙏🙏
Why u teach us wrong formula of DSO, DIO and DPO , if u don't want to teach us right thing then why u opened this channel
Amazing lessor. learning so much from your classes
Great Teaching, learning a lot in simplified manner! Thanks a lot!
very convenient financial modelling course sessions & value added...
BEST PLAYLIST EVER!!!!
he is doing gods work
really appreciated
Thank you Parth for the learnings.
"Jai AAP samjhdar ho aap paisa nhi de rhe financial modeling shikhne ke" so cute bhai 👏🏼 and thank so much ❤️👏🏼
Hello Sir,
This content is really helpful.
I appreciate the efforts and initiative that you have taken.Thanks again🙏
08:55 You are calculated EBT growth in place of EBIT growth kindly check
Thanks.Home work done with tata steel.
Just have a suggesting. While making video try to use shortcut if u use cursor so we even start touching the mouse with that subconsciously.
Ab to maza aa raha hai ye karne me. Thank you very much!!
One of the best Playlists.
Thankyou so much sir, this was really amazing session. Very grateful for your help.
Very clear Explanation.Thank you sir...Great Job!
Hi Parth, The videos are extremely professionally curated and are really helpful, thanks once again
Great work sir 👍 I request you to please come with such more videos thanks for sharing it free of cost
Just 1 feedback, I think like me, a large number of people here are from an Engineering background and working in the Financial dept. of some company. We may not know many of formulas that are being discussed here, but we are willing to learn. So if you can give a little bit of background and could tell any additional topics is that are necessary, then it would be a great help.
Thank you sir. Great session. Learnt a lot
U have way to go Sir with your selfless service . Thanks a million🙏
i type every word and make sheet with you
Thankyou once again
your efforts are really appreciable