DCF Excel Modelling | Step by Step - Session 7

DCF Excel Modelling | Step by Step - Session 7 | Investment Banking

Рет қаралды 117,306

Жыл бұрын

#dcfmodel #financialmodeling #investmentbanking
In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in DCF FINANCIAL MODELLING as BEGINNER. It covers everything end to end. By the end of these sessions, you will feel confident about performing DCF modeling on your own 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).
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!
📥 DOWNLOAD the EXERCISE FILES -drive.google.com/drive/folder...
📛 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

Пікірлер: 181

@simervirdi1915 Жыл бұрын

I can see you following Damodaran Sir's footsteps. Thank You Parth for sharing your valuable knowledge! :)

@abhinavchoubey9665 4 ай бұрын

You donot have any clue , how many blessings you are getting by providing these videos for free, may god bless you.

@faraximranist5435 6 ай бұрын

I have never seen a teacher like you. You are indeed a Mentor but I will consider you as a Teacher as well. If you start teaching CFA. I will definitely be the first student to opt for your session classes. I need the teacher like you who can built my basics strong in such topic. Please if you can start explaining more in depth of every finance elements involved.

@annavyas123 Жыл бұрын

I don't want these sessions to end as I am enjoying it so much. Thank you sir

@thevaluationschool Жыл бұрын

Glad to hear that

@yolopug3889 3 ай бұрын

at this point, I'm liking each video before even watching it. WHAT A GEM THIS GUY!

@SFW7 11 күн бұрын

Sir, I really appreciate your teaching. I think you said this by mistake but allow me to correct it. Beta is a measure of systematic risk because it captures the sensitivity of a stock's returns to the returns of the market as a whole. You mistakenly said that it's a measure of unsystematic risk (38:58). Likewise, the well-diversified marginal investor is seeking to manage and optimize their exposure to systematic risk while minimizing or eliminating unsystematic risk. You said the opposite, perhaps mistakenly. Please forgive me for bring this up and I am absolutely in awe of your generous teaching! Please keep going! p.s. if you read this, please also make a video course on Merger modelling :)

@harshparekh16 11 ай бұрын

I'm genuinely so grateful that you're giving out such quality content, in a structured manner for absolutely free. Thank you so much Sir

@linelogic1699 Жыл бұрын

Don't know how I did not come across such a good video on DCF all this long. Well explained in simple terms - even a engineer like me with non-finance background could understand it well. Hope to use this for my stocks valuation.

@vedikakhamayacha7659 Жыл бұрын

Cannot describe your efforts and excellent teaching in words. Infinite value additional to our knowledge ✨✨✨

@tanjirashaikh7220 Жыл бұрын

Grateful to have a mentor like you ❤️

@mihirranjan3440 Жыл бұрын

Finally, done with the 7th session and session was amazing as usual. Got to learn a lot and was always confused with COE thanks for clearing it in so short.

@ckhokhar30 Жыл бұрын

Thank you for explaining the cost of equity so fully. Never came across any such simple yet effective approach. (I paused the video and writing this comment, you can imagine my excitement of understanding things so easily 😃)

@chetanmali23998 Жыл бұрын

The quality of this video is truly on the other level.🔥🔥🔥

@user-qc6mg7fy5w Жыл бұрын

I am so thankful i found you.. you are my GURU

@vineettejwani3120 4 ай бұрын

best modelling sessions one can see with complete understanding of each concepts.

@navneetmukherjee9592 7 ай бұрын

I never seen such a natural educator - huge knowledge, unparallel confidence..... Tusi great ho Sir

@abubakersiddqe4618 6 ай бұрын

lessi?

@vanshajrai5346 3 ай бұрын

Sir, you are actually teaching the practical thing which is not at all taught in B-schools as well. Thanks for all the videos.

@rohitgupta3434 8 күн бұрын

Aisa lag raha tha ki ghar meh apne bhaiya se padh raha hu🙏🏻🙌🏻 really enjoyed.. thank you so much, I was literally pissed off from finding a good video to learn.. but here it is❤

@rockybhagat Жыл бұрын

Remarkable explanation. Wonderful. Thanks Parth. Awesome stuff.

@haritikachhatwal8275 Жыл бұрын

Absolutely amazing sessions . I am enjoying every moment of it. Since I am teaching for very long time I wanted such videos that provide industry academia experience to the students pursuing finance . Your videos are absolutely amazing concepts explained intricately in detail . Commendable efforts from you. Hats off to you Parth Sir.

@fariasohail791 9 ай бұрын

So grateful to have you ❤. May God bless you

@ShutterDiary-yg5yc Жыл бұрын

Amazing amazing and amazing looking forward to more sessions 😍

@rishabshorey7651 5 ай бұрын

Respected sir, I wanted to take my time out and write this by saying: thank you wholeheartedly for investing your valuable time in making these videos for all of us who want to make investment banking our career. I am glad to have found you as my mentor on this platform. Over the past videos I have watched, and learned a lot from you, and will still learn under your guidance and indulge in self-learning too. Highly respect you for the great work, and excited to grow and learn more with you!!

@CARahulAhewal 2 ай бұрын

Sir, Your videos are really helpful even after 1 year. You are really blessing for us. Thanks you for your efforts. God bless you.

@aarushisingh7143 11 ай бұрын

Thank You So much Sir .. We are blessed that You teach us this important skill for free 🙏🙌❤

@kunalhota206 Жыл бұрын

This effort is remarkable. Really enjoying the sessions. If you could start a new series where how one can understand the business model of any company would be really helpful. Thanks for this treasure of knowledge.

@surabhibajaj4057 4 ай бұрын

Great sessions! Watching them in chronological order as you said :D

@taranshsharma4289 5 ай бұрын

Sir, I am enjoying the sessions. As you said in lecture 13, I am here again to watch the sessions.

@crypstock2612 Жыл бұрын

As always, thank you Sir!

@meghamohnot150 9 ай бұрын

Every video of yours is so informative.

@AbdulRahman-kn5zw 9 ай бұрын

Thank you sir for such a valuable and insightful sessions!

@pratikshakhande2077 3 күн бұрын

Amazing series! Wishing you endless success Sir:)

@gauravvarshney1646 Жыл бұрын

Thank you sir for sharing your knowledge 📈🙏❤️

@akshay6280 6 ай бұрын

Guys videos like ker diya kero, sir itne efforts dal rhe h humare liye

@amaanahmadansari13 Жыл бұрын

Thanks for doing this for all of us.

@ajayanant1459 Жыл бұрын

Sir, Thankyou very much for teaching us.

@suniljain774 5 ай бұрын

Fantastic stuff . You have made learning so easy and interesting. This is like AMRITVURSHA for non finance persons like me.

@ashishagrawal5658 10 ай бұрын

Congratulations Parth, some how it popped in my KZfaq suggestion, good to see a school friend doing so good

@thevaluationschool 10 ай бұрын

Thank you so much Ashish. Let’s meet soon!

@utpalamkadkol4195 4 ай бұрын

I am greatfull to you Parth sir. 🙏thank you so much.

@lalitmohansharma468 Жыл бұрын

Sir, Great efforts keep growing.

@kartiksahani6109 3 ай бұрын

Thanks for this usefull information.

@financewise5304 8 ай бұрын

Always thanks a ton sir I am continuing this series Commendable learrning sir

@chetanmali23998 Жыл бұрын

Sir your efforts like 💯💯💯💯💯

@muhamamdhuzaifa4763 9 ай бұрын

very informative .. i am taking all your sessions

@parshvsutaria4589 4 ай бұрын

Thank you so much sir for sharing such valuable content!!

@vaishnavichanna6548 2 ай бұрын

Thankyou so much sir for sharing such knowledge for free, people like can afford to get such knowledge and that to very informative 🙏🏻

@aarushisingh7143 11 ай бұрын

I wish that THE VALUATION SCHOOL will grow that level that everyone will know about it. 😊

@deepakkohli8543 Ай бұрын

Thank you for for this valuable series, I am watching this in May 2024. It is very helpful to me.

@sarthaktiwari976 9 ай бұрын

very informative video sir looking forward to learn like this!

@alishahnawaz1199 10 ай бұрын

Amazing videos of Finance Than you sir i m from karachi

@vaibhavbaj-yj4lz Жыл бұрын

Next level learnings...

@amitsingh-be6me Ай бұрын

thanks for making such a valuable video, i learned a lot from this video.

@Vinayworks666 3 ай бұрын

Thankyou for the session ❤❤

@MotivationsHub. Жыл бұрын

ustad-e-Mohtaram loads of love to you for this valuable series. would love to earn everything from you ( Jo jo ata hy sab sikhadein hamein).❣

@adityadubey9565 Жыл бұрын

amazing session!

@mohitbaheti9609 3 ай бұрын

I am gratefull that I came across this YT channel and followed you sir. This playlist has helped me gain my financial knowledge immensely. I bought a valuation course some time back but this playlist is worth more than that. Thank you sir.

@Ritu.03 Ай бұрын

Bought his course or some other's?

@anmoljagetiya9031 10 ай бұрын

These Sessions are Real Gems for Finance Students ! Thankyou Parth Sir :)

@syedmurtazahussain690 9 ай бұрын

Sir Please make a similar kind of series on Fundamental and technical analysis of stocks. Love and support from Pakistan.

@vasulbatra6971 2 ай бұрын

sir pehle aakar video like krta hoon, fir shuru krta pdhna

@allabouthuskies.9213 10 ай бұрын

I am really thank you sir❤

@ritikaaggarwal6075 2 ай бұрын

Amazing!!!

@sparklesssss 4 ай бұрын

I wish all this in English for full explanation. Just by looking at videos I could say these are so well explained in details

@harshitmathur6697 4 ай бұрын

Finance Guru🙇‍♂🙇‍♂

@RohitKamath 9 ай бұрын

Terminal Value for this channel is non existent 🤩

@thevaluationschool 9 ай бұрын

Wow, thanks!😅🤣

@angeleneonslow3029 Жыл бұрын

Thanks a lot for sharing! Soo happy to watch ur video and improve my professional skill ! God bless you

@thevaluationschool Жыл бұрын

My pleasure 😊

@humanocean5790 5 ай бұрын

Guruji thanks...❤

@deepakjangra171 4 ай бұрын

sir Beta is measure of Systematic risk right ? you mentioned it as unsystematic. Need clarification. Thanks !!

@yashrajdubey4443 19 күн бұрын

thankyou sir for this video🥰

@user-zq9sx6bu5j 5 ай бұрын

dcf baap - parth. thank you sir

@taxbazaar7364 5 ай бұрын

Thanks a lot parth

@chipstead7919 Жыл бұрын

Sir for us this is more valuable than Gold😇

@shubhamdilawari7 Жыл бұрын

Sir i think mistake hui hai, Beta is a measure of systematic risk. Unsystematic risk is diversified and investors are rewarded for taking systematic risk.

@shiwangijivrajika6744 2 ай бұрын

True

@seekingalpha_ Жыл бұрын

india ka damodaran❤

@ai.divyanshu Жыл бұрын

Amazing videos Parth. Looking forward for more.

@thevaluationschool Жыл бұрын

More to come!

@Marketvani Ай бұрын

38:58 When you are saying FIIs need reward for unsystematic risk. Unsystematic risk is already mitigated by Diversification. And there is no mitigation for systematic risk.

@RMKserve Ай бұрын

Brave man ❤

@khushalbansal3397 Жыл бұрын

Doing Superb Work Parth!! Kudos !! Amazing Learning

@thevaluationschool Жыл бұрын

Thanks a ton

@darshan753 Ай бұрын

Jabardast 💯💯💯💯

@pranjulgupta9250 Жыл бұрын

thanks a lot sir

@yashrajput7212 10 ай бұрын

Luv u sir 💓

@Nexus26688 3 ай бұрын

Thank You

@muditmohan3627 Жыл бұрын

Thank you for your efforts.

@thevaluationschool Жыл бұрын

Always welcome

@pushparaj4567 11 ай бұрын

Superb class

@kaiaragorn4102 Жыл бұрын

Sir, We will always remember you.

@rohitdixit4000 10 ай бұрын

VERY GOOD VIDEO SIR

@gopikrishnanvb408 10 ай бұрын

thankuuu 😇🥰 🤩

@vjrocks6801 11 ай бұрын

maza aa gaya sir

@Kausar-2.0 Жыл бұрын

Congratulations o15K Followers

@navneetmukherjee9592 7 ай бұрын

Sir one request to your goodself - I have done my masters in Mathematics. To enhance my knowledge in stock market I started learning basics of finance (or, accounting) - I saw 1st and 2nd videos of your financial modelling series and watched 3rd but gone over my head . I was very excited to complete the series but my knowledge is not permittting me. Please, please advice me to break the shakle and empower me to learn from YOU. Thanks once again sir for your classes

@arunavdikshit1905 4 ай бұрын

thanks bhaiya

@anshugupta6878 7 ай бұрын

Great work by You sir. I have some doubts in it. I think systematic risk means economy wide risk which is non diversifiable and unsystematic risk means company specific risk. FIIs, DIIs wants systematic risk premium rather than unsystematic risk premium. So I guess beta represents systematic risk. Kindly Clarify it sir

@vikashmaurya5185 Жыл бұрын

thanks sir

@harshagarwal2163 Жыл бұрын

please bring a video on full financial analysis also

@kapildayma6361 Жыл бұрын

Suddenly i felt like I am classroom, learning to be a analyst 😅 thanks a lot sir parth for your unimaginable effort...

@thevaluationschool Жыл бұрын

So nice of you

@govindgoel2442 Жыл бұрын

Time Stamp 45:17 1 - ✅ 2 -✅ 3-will done 4-Going process

@thevaluationschool Жыл бұрын

So happy to see this Govind!

@tanmayvarshney9200 6 ай бұрын

Who says that arjun can't find lord Krishna in this kalyug. This teacher is like my dream teacher.😢😢😍😍

@debopamghosh9739 Жыл бұрын

Sir please make e detail video on Beta....we use to consider beta from return perspective. it will be better if you explain ta risk point of view that is use d practically

@NabeelKhan-tl7cq 5 ай бұрын

Hi parth sir, this course is a real gem for everybody who wants to excel in finance thanks for making this course so interesting.. in this vid you told that this course is not to become a financial modeller a bit confused about it please can you give me a straight path of what skill i will have after the completion of this course?

@manishchoudhary857 11 күн бұрын

Same question.