Learn Financial Modelling - Step by Step - Session 5 | Ratio Analysis

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 - [phone]
👉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

[@thevaluationschool]

Apologies for the heavy voice and weird sounds in between. I was sick with heavy cold while recording this session.

[@Akshayyy281]

Sir you’re literally a gem for CA freshers and other candidates. Hope you get well soon!

[@user-tj5kx1kd7g]

we are thankfull to you sir , such level of dedication hats off to you sir

[@makhaleqhussain5153]

Voice is matching with content, it should be like this not to get bored ❤❤❤

[@subhashpareya4866]

but still very clear, appealing and convincing 😊

[@HarshSharma-rp1go]

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

[@kirtiverma7255]

Thank you so much for saving my 45K and bringing such good quality content. Totally hooked to this series. Thanks Again!

[@RohitSKumar-re7kh]

What else can we say..its really a blessing to get mentored by you. Thank you sir.

[@justavi31]

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

[@chaitanyahatwar6517]

Bro my consern is also same if you get answer from sir please share solution to me 🙏

[@rutikshrawankar7086]

Yes

[@adwaitgosavi6959]

Have you got the solution??

[@siddharthjagwani]

Creditor Turnover Ratio is also incorrect

[@keshavgoel7206]

​@@siddharthjagwaniyes

[@user-su3pb1dw2b]

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

[@aashnashah4585]

Always grateful for the abundance of knowledge but the initiative to provide such high value study at no cost, is commendable. Truly inspired!🙏

[@oyenaru]

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.

[@user-fi7ws8vv2i]

Thank you for all your efforts! Best Series of Financial Modelling i have ever watched

[@Indianmatrix75]

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

[@muralidandu8993]

I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..

[@ashutoshdubey4720]

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.

[@UnnatiNarsaria-jm3iu]

Brilliant Session. Recommend this to everyone. He teaches from basics and gradually moves to advanced.

[@jaideepmodi]

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.

[@13Dipesh]

Sir you are doing a great work and we are so grateful to have a teacher like you.🙏🙏🙏 Thank you

[@kadivendianudeepsai6775]

I am getting impeccable knowledge from u r ERC and this modelling series thanks a lot sir 🙏🙏🙏

[@andedayu7470]

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 ✅👌

[@zeeshanakhtar8908]

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.

[@Ananya-os1vi]

your efforts are really appreciable

[@selfexplore.408]

U have way to go Sir with your selfless service . Thanks a million🙏

[@prabirbanerjee3780]

Seriously i am watching all your videos, the way you are describing all the things in the financial modelling is just awesome

[@aastha23200]

Can u please tell me whether excel sheet provided by sir enabling you to edit (I'm unable to type anything in that sheets)

[@anantdubey7555]

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

[@TejeswarReddy01]

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

[@babitamodi7316]

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 ..❤

[@kandukurisaibharathkumar7765]

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☺

[@spidycounts3165]

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❤

[@MuhammadMubeen-wv8og]

Brother, you're doing a great job. hats off, we need more productive content like this online 👍

[@-ck4dc]

Thanks for creating all videos, I have downloaded all and keep listening and practicing in my free time..

[@divyangtandon7206]

One of the best Playlists.

[@karanmehta7880]

you have taught me so much! thank you for your videos

[@alishahnawaz1199]

Great Channel for Finance The valuation School

[@rishabshorey7651]

Sir, thank you for creating such a great content. I love the way you teach with ease is just fabulous.

[@dhruvshah3523]

Seriously the best course ever!!!!!!!!!

[@sakshisrivastava6894]

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 🙏

[@jahankhan7238]

Thanks, Dear Path Sir, it helps me to understand new techniques of learning finance through Excel

[@kundanthakur5604]

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.

[@ayushgoel4517]

Sharma j i bhi yaad a Jaye hai 😂

[@sarthakkumar3243]

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

[@subratbiswal3667]

he is doing gods work really appreciated

[@harsh_206]

You are truly delivering value here sir!! Thank you so much❤

[@MuhammadMubeen-wv8og]

Brother you're doing a great job, we need such content on the internet. hats off

[@MaheshSingh-lh4zs]

Great Teaching, learning a lot in simplified manner! Thanks a lot!

[@Kukkibuzz]

I appreciate all of your hard work 😊😊. Your videos are really empathetic.

[@abhishekyadav-kv4ne]

Hi Parth, The videos are extremely professionally curated and are really helpful, thanks once again

[@rajchhabra2948]

very convenient financial modelling course sessions & value added...

[@sumxixt]

What a great session 🔥 Really you made it so easy for us. Thank you parth sir🙏🏻

[@manjeetmarathi]

What a pro. All the techniques are so useful.

[@vikasarsid1299]

You are blessed to shared this knowledge.

[@badrishpai9141]

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.

[@aakashkrishna3729]

BEST PLAYLIST EVER!!!!

[@ace_gourav]

sir, you are a GOOD PERSON.

[@user-fk4ik8cy3p]

Sir i Appreciate your Efforts. Pls Never Stop.

[@SahilSharma-gw3lu]

Simply ULTIMATE ❤

[@vedantpatil3471]

loved the session

[@sachinprajapati6069]

Very vary thanku sir 🎉🎉🎉this made me as a game changer

[@shakeijaz9200]

Very clear Explanation.Thank you sir...Great Job!

[@rv5724]

Thankyou for teaching financial modeling

[@AshutoshSingh-rk9qg]

you have done a great job.

[@rajshukla9633]

"Jai AAP samjhdar ho aap paisa nhi de rhe financial modeling shikhne ke" so cute bhai 👏🏼 and thank so much ❤️👏🏼

[@divyachola3332]

Thank you for great amount of information!

[@afifaikram7303]

Amazing lessor. learning so much from your classes

[@casartaj5229]

It's an amazing video sir your teaching is unbelievable and each point you explain literally amazing 🤩❤

[@kruthikabr1548]

Thankyou so much sir, this was really amazing session. Very grateful for your help.

[@sanyamjain7749]

Thankyou Sir, for this beautiful content I am Glad to part of this journey

[@deepakbansal9286]

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 ❤

[@shubhamchhalani9978]

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

[@waqarfarooqui3206]

Thanks man for the effort. Loads of appreciation

[@vidushi4065]

amazing video, thank you sir really appreciate your efforts!

[@tredexits2696]

Thank you so so so much sir. Your work is awesome and perfect

[@kratikvijay]

Top notch content deserves a big thumbs up 👍🏻 Mazza aagya!!

[@user-md6rb1mi7j]

Indeed Full of Knowledge

[@gopalaggarwal005]

Sir, great session. I am watching your videos and performing the same and getting addictive towards learning.

[@positivity6939]

Great work sir 👍 I request you to please come with such more videos thanks for sharing it free of cost

[@yashbajaj2095]

Great playlist 🎉

[@muazebhussain5154]

Learning a lot from your videos thank you

[@kartiksahani6109]

thanks for this amazing video and it is really worth it.

[@mandarnaswale9853]

your are the real teacher sir 🙏🙏

[@honeybee6978]

Great video as always!

[@ManishKumar-dp2lo]

thanks for providing such quality content and educating ur viewers. keep up the good work

[@qutubmalak5662]

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.

[@nirjharchandak9659]

Very useful series 💯

[@amitchoudhary30]

@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

[@harsheetprajwal2014]

Only one word- "BEST"

[@sajidhameed2657]

awasome. thanks for the good work

[@uttamverma765]

Thanks Sir for giving us such knowledge ❤

[@daveblue1234]

Awesome...Just Awesome

[@mick_mickyplays7860]

how can your videos be this intresting, despite a boring subject as fm, kudos

[@pritamsharma9413]

Masterclass on Financial Modelling. All fears busted .Tones if Respect for you Parth Sir

[@ravigupta-hq4hk]

great learning.

[@sharmilabattula6789]

Thank you so much sir for the great sessions. ❤

[@tusharchandak5552]

you are a legit person valuable learning

[@simran7761]

these videos are gonna break records soon....mark my words !

[@addictedhs7043]

Hats off for this great work

[@aniketdhawan2881]

Thank you so much sir for providing this wonderful session

[@chandnidhanwani9951]

Thank you so much Sir for putting so much effort ☺️

[@DigiDynasty-pn1lc]

just saw you...thankyou brother!

[@adityadubey9565]

Amazing lecture!

[@harshilwadhwani236]

GREAT FOR LEARNING

[@jigarjain2535]

Sir it's a great session

[@vjrocks6801]

Sir itna amazing video hai, I just love this

[@shubhangikhanna2068]

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.

[@thevaluationschool]

Happy to help!

[@kunalmaru7404]

Very good video

[@anilshirsat3925]

Thanks sir, very helpful