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

#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 - [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

[@simervirdi1915]

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

[@abhinavchoubey9665]

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

[@annavyas123]

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

[@thevaluationschool]

Glad to hear that

[@faraximranist5435]

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.

[@yolopug3889]

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

[@harshparekh16]

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

[@vedikakhamayacha7659]

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

[@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.

[@navneetmukherjee9592]

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

[@abubakersiddqe4618]

lessi?

[@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 😃)

[@vineettejwani3120]

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

[@chetanmali23998]

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

[@tanjirashaikh7220]

Grateful to have a mentor like you ❤️

[@CARahulAhewal]

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

[@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.

[@user-qc6mg7fy5w]

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

[@rishabshorey7651]

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!!

[@vanshajrai5346]

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]

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❤

[@amanrena5084]

i like your confidence Man , you are always sure what people want about.

[@rockybhagat]

Remarkable explanation. Wonderful. Thanks Parth. Awesome stuff.

[@aarushisingh7143]

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

[@fariasohail791]

So grateful to have you ❤. May God bless you

[@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.

[@ShutterDiary-yg5yc]

Amazing amazing and amazing looking forward to more sessions 😍

[@crypstock2612]

As always, thank you Sir!

[@deepakkohli8543]

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

[@surabhibajaj4057]

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

[@vaishnavichanna6548]

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

[@meghamohnot150]

Every video of yours is so informative.

[@taranshsharma4289]

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

[@suniljain774]

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

[@AbdulRahman-kn5zw]

Thank you sir for such a valuable and insightful sessions!

[@kartiksahani6109]

Thanks for this usefull information.

[@harishkumars5578]

I appreciate your knowledge, you can rule market with knowldge, but more important than knowledge is personality and how try to communicate with people. Please keep control over your tone and words you grow beyond skyies .... Thanks

[@amaanahmadansari13]

Thanks for doing this for all of us.

[@SFW7]

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 :)

[@akshay6280]

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

[@ajayanant1459]

Sir, Thankyou very much for teaching us.

[@utpalamkadkol4195]

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

[@amitsingh-be6me]

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

[@gauravvarshney1646]

Thank you sir for sharing your knowledge 📈🙏❤️

[@parshvsutaria4589]

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

[@financewise5304]

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

[@yashrajdubey4443]

thankyou sir for this video🥰

[@ashishagrawal5658]

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

[@thevaluationschool]

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

[@lalitmohansharma468]

Sir, Great efforts keep growing.

[@muhamamdhuzaifa4763]

very informative .. i am taking all your sessions

[@alishahnawaz1199]

Amazing videos of Finance Than you sir i m from karachi

[@pratikshakhande2077]

Amazing series! Wishing you endless success Sir:)

[@sachinprajapati6069]

Amazing sir

[@anmoljagetiya9031]

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

[@sarthaktiwari976]

very informative video sir looking forward to learn like this!

[@chetanmali23998]

Sir your efforts like 💯💯💯💯💯

[@Vinayworks666]

Thankyou for the session ❤❤

[@ritikaaggarwal6075]

Amazing!!!

[@vaibhavbaj-yj4lz]

Next level learnings...

[@aarushisingh7143]

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

[@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).❣

[@humanocean5790]

Guruji thanks...❤

[@allabouthuskies.9213]

I am really thank you sir❤

[@taxbazaar7364]

Thanks a lot parth

[@adityadubey9565]

amazing session!

[@mohitbaheti9609]

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?

[@Nexus26688]

Thank You

[@RMKserve]

Brave man ❤

[@RohitKamath]

Terminal Value for this channel is non existent 🤩

[@thevaluationschool]

Wow, thanks!😅🤣

[@pranjulgupta9250]

thanks a lot sir

[@syedmurtazahussain690]

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

[@arunavdikshit1905]

thanks bhaiya

[@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]

True

[@angeleneonslow3029]

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

[@thevaluationschool]

My pleasure 😊

[@deepakjangra171]

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

[@vasulbatra6971]

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

[@sparklesssss]

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

[@user-zq9sx6bu5j]

dcf baap - parth. thank you sir

[@gopikrishnanvb408]

thankuuu 😇🥰 🤩

[@govindgoel2442]

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

[@thevaluationschool]

So happy to see this Govind!

[@vikashmaurya5185]

thanks sir

[@harshitmathur6697]

Finance Guru🙇‍♂🙇‍♂

[@chipstead7919]

Sir for us this is more valuable than Gold😇

[@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.

[@pushparaj4567]

Superb class

[@khushalbansal3397]

Doing Superb Work Parth!! Kudos !! Amazing Learning

[@thevaluationschool]

Thanks a ton

[@ai.divyanshu]

Amazing videos Parth. Looking forward for more.

[@thevaluationschool]

More to come!

[@yashrajput7212]

Luv u sir 💓

[@rohitdixit4000]

VERY GOOD VIDEO SIR

[@muditmohan3627]

Thank you for your efforts.

[@thevaluationschool]

Always welcome

[@darshan753]

Jabardast 💯💯💯💯

[@vjrocks6801]

maza aa gaya sir

[@Kausar-2.0]

Congratulations o15K Followers

[@seekingalpha_]

india ka damodaran❤

[@kaiaragorn4102]

Sir, We will always remember you.

[@harshagarwal2163]

please bring a video on full financial analysis also

[@profha2]

Brilliant. Do you do your own bookkeeping? I'm 🤔 of doing it for myself.

[@ayushibajaj9438]

we will add this in the work previously done for "Tata Motars" ?

[@anshugupta6878]

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

[@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

[@SurajSingh-qs2lp]

sir please make one video on valuation of Revenue buildup