Learn Financial Modelling - Step by Step - Session 5 | Ratio Analysis
ฝัง
- เผยแพร่เมื่อ 21 ม.ค. 2023
- In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in FINANCIAL MODELLING as BEGINNER. It covers Ratio Analysis in detail. I will guide you on how to plot different ratios using financial statements.
Like our previous session in FULL COURSE on FINANCIAL MODELLING for BEGINNERS, it also breakdown everything in STEP BY STEP manner using LIVE PROJECT or EXERCISE file so you can PRACTICE it while watching this session (link below).
FINANCIAL MODELLING in EXCEL is a crucial SKILL one must learn in order to make a CAREER in INVESTMENT BANKING, EQUITY RESEARCH, VALUATION, and other CORE FINANCE ROLES.
By the end of this course, you will have a STRONG FOUNDATION in FINANCIAL MODELLING and be able to confidently CREATE FINANCIAL MODELS IN EXCEL to support decision-making in your professional life.
Start your journey towards becoming a FINANCIAL MODELLING EXPERT now!
You can connect with Parth Sir on Linkedin -
📥DOWNLOAD the EXERCISE FILES - drive.google.com/drive/u/0/fo...
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp Channel (TVS Mentoring) - whatsapp.com/channel/0029VaLf...
📌SUBSCRIBE NEWSLETTER - cutt.ly/gw2ozQbj
--------------------------
👉JOIN:
🔥REGISTRATION LINKEDIN COHORT : cutt.ly/ieeOXuwl
🔥REGISTRATION EQUITY RESEARCH COHORT Latest Batch: cutt.ly/4wSDnDLA
📛 Please refer to this video for all the Details of the Cohort:
• Equity Research cohort... !
✅ For queries, please reach to us on our Instagram handle: / thevaluationschool or DM us on WhatsApp - +91 9302017656
👉Register here for our latest Advanced Valuations and Financial Modelling Cohort
🔥 AVFM LIVE - cutt.ly/rwXYEN2A
🔥 AVFM RECORDED - cutt.ly/VwXYW7Xp
--------------------------
✅ You can Connect with Parth Sir on Linkedin - linkedin.openinapp.co/097ag
✅Follow The Valuation School page on Linkedin - / thevaluationschool
✅Join our Instagram handle - / thevaluationschool
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
Thank you so much for saving my 45K and bringing such good quality content. Totally hooked to this series. Thanks Again!
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
What else can we say..its really a blessing to get mentored by you. Thank you sir.
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
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 m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
Always grateful for the abundance of knowledge but the initiative to provide such high value study at no cost, is commendable. Truly inspired!🙏
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.
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.
Sir your session are amazing I believe upto the completion of this series I would be adding up to value to my existing skills 🙏🙏🙏marking this as the best series to learn from those who want to start their career from scratch to master financial modelling ✅👌
Thank you for all your efforts! Best Series of Financial Modelling i have ever watched
Brilliant Session. Recommend this to everyone. He teaches from basics and gradually moves to advanced.
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☺
Sir you are doing a great work and we are so grateful to have a teacher like you.🙏🙏🙏 Thank you
U have way to go Sir with your selfless service . Thanks a million🙏
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
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)
I am getting impeccable knowledge from u r ERC and this modelling series thanks a lot sir 🙏🙏🙏
Thanks for creating all videos, I have downloaded all and keep listening and practicing in my free time..
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 ..❤
What a great session 🔥
Really you made it so easy for us.
Thank you parth sir🙏🏻
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 Channel for Finance The valuation School
Hi Parth, The videos are extremely professionally curated and are really helpful, thanks once again
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
very convenient financial modelling course sessions & value added...
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❤
Sir, thank you for creating such a great content. I love the way you teach with ease is just fabulous.
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 Sir, for this beautiful content
I am Glad to part of this journey
Top notch content deserves a big thumbs up 👍🏻
Mazza aagya!!
What a pro. All the techniques are so useful.
Great work sir 👍 I request you to please come with such more videos thanks for sharing it free of cost
thanks for providing such quality content and educating ur viewers. keep up the good work
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!
Brother you're doing a great job, we need such content on the internet. hats off
It's an amazing video sir your teaching is unbelievable and each point you explain literally amazing 🤩❤
Seriously the best course ever!!!!!!!!!
One of the best Playlists.
Sir i Appreciate your Efforts. Pls Never Stop.
Sir, great session. I am watching your videos and performing the same and getting addictive towards learning.
he is doing gods work
really appreciated
Masterclass on Financial Modelling. All fears busted .Tones if Respect for you Parth Sir
Great Teaching, learning a lot in simplified manner! Thanks a lot!
Thanks, Dear Path Sir, it helps me to understand new techniques of learning finance through Excel
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.
Brother, you're doing a great job. hats off, we need more productive content like this online 👍
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
You are truly delivering value here sir!! Thank you so much❤
Sir you are doing a great work and we are so grateful to have a teacher like you.
It's my pleasure
You are blessed to shared this knowledge.
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 ❤
you have taught me so much! thank you for your videos
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
I appreciate all of your hard work 😊😊. Your videos are really empathetic.
Very clear Explanation.Thank you sir...Great Job!
Great session sir.....keep posting such type of content and videos🤩
these videos are gonna break records soon....mark my words !
you have one student from Canada too....thanks for the financial modelling series
BEST PLAYLIST EVER!!!!
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
Thankyou so much sir, this was really amazing session. Very grateful for your help.
Very insightful sir. I have one suggestion sir if possible make YT shorts on drawing conclusion about the company from each session like from ratios that we have calculated today or 3 statement model we have created in last video. I personally think it will be really helpful.
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
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
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.
Loved The Course, loved your small jokes and acts, the way you teach, Hey Excel😁
Get well soon 🙂
And this session and last session was really amazing.
I will send the exercise filed to LinkedIn 😊
Thank you once again.
And last please tell me any vacancies in the field of Financial Modelling.
Thank you for the session and get well son Parth !!
Learning a lot from your videos thank you
Indeed Full of Knowledge
your are the real teacher sir 🙏🙏
Thanks man for the effort. Loads of appreciation
No doubt, it was a great session Sir.
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.
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
@@siddharthjagwaniyes
amazing video, thank you sir really appreciate your efforts!
Take good care of your health sir, you are our Financial Asset, looking forward for the next session
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
IT WAS AWSOME .... WATING FOR MORE INFORMATIVE SESSIONS
awasome. thanks for the good work
Hello sir, thank you very much for the wonderful sessions. From the first video to this video, I learned a lot of things.
I would like to know what should be included in my practical that I have done if I wish to apply for the role of financial analyst.
Thankyou for teaching financial modeling
Thank you for great amount of information!
Thank you sir thank you so much you are the great youtuber 😊 lage rahiye or banate rahiye bas hamari duaa e lete rahiye sirji 🙏🙏 thanks
These videos are really coherent and making it topic wise is really recommendable. I am appreciating your efforts to teach finance modelling in very simple and deliberate way. I subscribed your channel to become of your educational and learning platform. Thank you
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
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
Man doing god"s work for us
Only one word- "BEST"
Sir itna amazing video hai, I just love this
Simply ULTIMATE ❤
Superbb Sir,
absolutely loved the video sir, you deserve a million subs.
Amazing lecture!
you have done a great job.
Great playlist 🎉
Stupendous Session
Thanks Sir for giving us such knowledge ❤
Hats off for this great work
Thank you so so so much sir. Your work is awesome and perfect