Dupont Analysis Modelling | Learn Financial Modeling | Step by Step | Session 19
Вставка
- Опубліковано 20 сер 2024
- In this FULL COURSE session on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know about DUPONT ANALYSIS in FINANCIAL MODELLING as a BEGINNER. It covers everything end to end. By the end of these sessions, you will feel confident about performing DUPONT ANALYSIS modeling independently without any help.
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).
Download Template- drive.google.c...
📌SUBSCRIBE NEWSLETTER - cutt.ly/gw2ozQbj
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp channel (TVS Mentoring) - whatsapp.com/c...
--------------------------
👉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.openi...
✅Follow The Valuation School page on Linkedin - / thevaluationschool
✅Join our Instagram handle - / thevaluationschool
In the era, where people are making a hefty amount of money by selling shitty courses in the name of Financial modelling. And here you are giving it for free and the best part is the content and way of teaching is way better than 99% of instructor out there. Hats off to you sir ❤
Parth Sir, a few months back, I couldn't have imagined that I would be able to perform a DuPont Analysis so easily. Not just this series, but your NISM 13 Research Analyst series has also been a tremendous help on my journey. I've completed 11 chapters so far and I'll drop another comment as soon as I pass the exam. All kudos to you for motivating me and making me believe in myself. Thank you, Parth Sir!
What's unique about Parth sir is that he keeps the session so interactive that it never feels like we are watching a recorded video... and the quality of the content, as usual, is never compromised.....worth every second😄😄
So you are telling these are not recorded classes? 😲😲
Sir you are Financial Modelling God for us Finance aspirants !!! Ur content is crazy crazy good!!! 2 hours feels like 2 mins when u teach us!! I really wish and I am sure u will get 1Million+ subscribers very soon! Hats off to u Sir u are giving such invaluable content to us totally free of cost thanks a lot !!!❤
Seriously, this was one of the best sessions. I really enjoyed creating the report. The part I enjoyed the most was creating a ROE and ROA summary. These 2 Hours were worth it.
Very wonderful report making technique sir ❤❤✨✨🌟Thank you so much sir 🙏For this types of content.........................................
I feel blessed that I clicked on one of the videos to learn NISM series of Equity Research of Parth Sir
Then I got to know about Equity Research Cohort
The Valuation School is an institution in itself
Learning each day 🙏🏻🙏🏻🙏🏻
Thank you Parth Sir and the team.
All your videos has been very very helpful up until now . Truly a work of art sharing all this knowledge for free and so detailed 🌟
Please pin this comment as it saves so much time.
Although many individuals are already good at formatting charts, I am sharing this information to help those who may find it helpful.
While formatting charts, it is not necessary to do it manually for each individual chart, as we can replicate it all.
Step 1: Perform the desired formatting for one chart, such as fill coloring, font size, and font type.
Step 2: Simply copy and paste the chart.
Step 3: Click on the bars of the bar chart, then go to the "Chart Design" section, which will appear on the ribbon upon clicking the bars.
Step 4: After clicking "Chart Design," you will find the "Select Data" option. Click on it.
Step 5: A dialogue box will pop up after clicking "Select Data." At the top, locate "Chart Data Range" and remove any previous references in the chart data range.
Step 6: To add the years reference, drag it on with the mouse, then press and hold the "Ctrl key" while adding data such as net profit, etc. Finally, press enter.
Step 7: If necessary, format the "number" to "percentage" accordingly.
Thank you very much for providing such excellent content, Parth Sir. We genuinely appreciate the dedication and time you are investing in delivering such high-quality content.
You deserve a long and fulfilling life so you can continue sharing your valuable service with the world. I want to express my heartfelt gratitude for the incredible content you create on UA-cam. Please keep up the amazing work. Sending you lots of love!
You are a true legend sir who is providing the best value at free of cost
Sir your way of explanation is one of the best. I think you can easily make us understand any difficult topic of fin such as Option and future, fixed income security etc. Sir
Please start a series on Options
sir really appreciate to your effort for making this video for us at free of cost with great fun and adding value to finance field. i can say that after watching this video my interest towards finance background increase and i started this video at 12.10 a.m. at night and now it's 1.57 a.m. i can say that this 2 hrs was really worth it! want again another video from your side in future that can aspire finance student to learn valuable concept with fun.
We all know that "Thank you" would never be enough for your hard work Sir❤
thanks for teaching formatting, it's looks really professional 🤟
Top notch content sir, your dedication is a source of motivation for many
Thankyou sir for making such a wonderful video for the fellow students. thankyou very much
Watching this again for NISM - RA Exam
Respect for your Efforts Increased !
Thank You Sir 💥
Highly satisfied, "PARTH GURU" ... Awaiting for advanced level modeling video series
Very Well Presented and explained
The way you educate is amazing it will be great if you create a Series of financial ratio Analysis and basic terms of financial accounting for non finance background people.
This is really osm video sir I learn a lots of things about financial modelling from this series of videos. Thanks a lot parth verma
Do change in list of stocks
1. Change ITC BSE code.
2. Add avenue supermarket right above ITC
3. The BSE code of Avenue supermarket is 540376 and NSE is DMART.
INDUSTRY is Trading.
finally was waiting for this for so long plz do one for equity research plz parth sir
Sirji abhi tak ka kaam pasand aaya aisehi aage banate rehna video ❤ content accha hai aapka bhot sikhne milta hai, giving you my time it's the most valuable thing i did😊
This is a gem of a content, thank you sir for this
Isse kehte h yrr content, top notch content ❤❤.
This whole playlist is just amazing!
always enjoy and take something new with me from your session, all the best for the future sir
Thanks a lot Sir! seriously learning so much amazing things from you on daily basis.
Sir, really this video is awesome. Because Graphically representation is more attractive. 🥰🥰
Thank You So Much Sir for the financial model series.🙌
Thank you so much for such a great and easy explanation it's great learning from you as usual. Thank you sir
Can’t thank you enough for this quality content ❤
Top notch content sir, your dedication is way above us.
This lecture was insane
Thank you sir, for the easy and amazing explanation of each and every topic.
Very nice video thanku sir sharing this with us
I really Enjoy your Videos and it are really informative
Thank you sir for teaching this model❤❤
Top class, out of the world ❤
Much Awaited video !!
Amazing content as always. Thank you so much.
very inspiring sir
parth sir bahut maza aa raha hai
Both matched 28:00
Great Sir. I really enjoyed this session.
Great session 🙌
Great Session! ❤❤
Superb content bhai ..Thanks for giving this knowledge
Thank u for your Time and knowledge ❤✨
Boss !! Maza aaya 😊
One of your best video sir
Thank you so much sir
Please upload a video with all the financial calculations in the company required to know the financial position of the company... also M&A, DCF, IT many more
Sir could it be possible to start a Equity Research Cohort for exclusively those who are not from commerce or Finance background?
You and your teaching style - just "PERFECTO"
Worth every second..!!!!
Sir thanks for this awesome lecture,
Also a minor correction I would like to make that the word "concatenate" is pronounced as CONCA-TEE-NATE
Eagerly Waited
Thank You Sir
amazing content
Lovely ❤
Thank You
quality content
Thank you for this amazing content.
Super excited
Amazing
So helpful maja aya sir
amazing content and beautiful explanation
Thank you for this lec.
Sir please can you make videos in English it will help to South people
maja aa gaya sir...
Hi sir
Make a video on how to prepare a report after modeling
great
Amazing content ❤
For Asset T/o ratio - avg Total Asset is taken. So, I have a qn, why didn't we took only the Closing Asset as the asset are capex and the exp is not incurred evenly throught the year?
dil garden garden hojata hay qasam say
thank uuuu😇🥰😍
how to add HEX in excel as it doesn't show as option in more colours?
Very Interesting Learning
Highly satisfied 💯💯💯💯
Qualtiy Videos. You have ended the Myth of certificates. Change for the good.
sir bhot maja aaya but time be bhot jada laga😁
Sharma ji asa message mt kro varna verma ji naraz ho jayenga 😶
NICE
Shaandar video
Bohot achha laga
if possible, can you please make a video explaining more about the ratios specifically the equity multiplier
Sir mza aa gya
Sir is Equity research cohort is available in recorded form ? As everyone cannt get place in restricted numbers ...
@TheValuationSchool, sir how did you get the list of stocks? Do we also need to download it as part of the exercise? When we are doing the exercise, should we copy-paste the list of stocks from the completed file?
Sir mene jab chart bnaya to mere usme 2 bar graph ban gaya ek year ka or ek revenue ka or y axis m 1,2,3,4 likha agya, to usko kese change kare??
Sir my normal calculation of ROA is different from ROA DuPont Equation. Why is that so?
Maza AAYA
Bhai kam sha kam 1 millon views hona chahiye tha abhi tak kya content ha wow ,i liked the video and subscribed too
#NOW IT'S YOUR TURN 🦸👊
Can anyone help me with concatanete formula I m not able to access that
Hats off
sir from where i can learn excel like you do in your videos ?
Hi sir..I managed to download the template thanks
Sir please tell...I am a bcom hons graduate and wants to move ahead into Finance field...By watching your all playlists of financial modelling ...Which type of project can I make for my resume ?
maza aya