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.c...
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp Channel (TVS Mentoring) - whatsapp.com/c...
📌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.openi...
✅Follow The Valuation School page on Linkedin - / thevaluationschool
✅Join our Instagram handle - / thevaluationschool

[@sushmitajoshi1208]

Hi Parth, Amazing amazing lecture with practical approach. I have actually read Ashwath Damodaran's book of valuation, and that was great with getting a grip on fundamentals but it didn't make me confident on developing a model myself. You have done what he couldn't!! Thankyou for this gem.

[@abhinavchoubey9665]

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

[@simervirdi1915]

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

[@ayushrathore3208]

are you talking about aswath damodaran sir?

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

[@navneetmukherjee9592]

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

[@abubakersiddqe4618]

lessi?

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

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

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

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

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

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

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

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

[@deepakkohli8543]

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

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

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

[@amanrena5084]

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

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

[@vineettejwani3120]

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

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

[@vaishnavichanna6548]

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

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

[@akshay6280]

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

[@taranshsharma4289]

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

[@RohitKamath]

Terminal Value for this channel is non existent 🤩

[@thevaluationschool]

Wow, thanks!😅🤣

[@suniljain774]

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

[@kartiksahani6109]

Thanks for this usefull information.

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

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

[@govindgoel2442]

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

[@thevaluationschool]

So happy to see this Govind!

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

[@aarushisingh7143]

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

[@ShutterDiary-yg5yc]

Amazing amazing and amazing looking forward to more sessions 😍

[@chetanmali23998]

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

[@aarushisingh7143]

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

[@user-qc6mg7fy5w]

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

[@tanjirashaikh7220]

Grateful to have a mentor like you ❤️

[@rockybhagat]

Remarkable explanation. Wonderful. Thanks Parth. Awesome stuff.

[@syedmurtazahussain690]

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

[@financewise5304]

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

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

[@fariasohail791]

So grateful to have you ❤. May God bless you

[@alishahnawaz1199]

Amazing videos of Finance Than you sir i m from karachi

[@sachinprajapati6069]

Amazing sir

[@tanzeemmallick9602]

sir it was really very easy ,can u make video on all basic terminology used in financial analyst and modeling and all related to this background

[@surabhibajaj4057]

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

[@yashrajdubey4443]

thankyou sir for this video🥰

[@PK-pg2gd]

I CANNOT THANK YOU ENOUGH

[@pratikshakhande2077]

Amazing series! Wishing you endless success Sir:)

[@deepakjangra171]

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

[@AbdulRahman-kn5zw]

Thank you sir for such a valuable and insightful sessions!

[@utpalamkadkol4195]

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

[@parshvsutaria4589]

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

[@meghamohnot150]

Every video of yours is so informative.

[@RMKserve]

Brave man ❤

[@muhamamdhuzaifa4763]

very informative .. i am taking all your sessions

[@angeleneonslow3029]

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

[@thevaluationschool]

My pleasure 😊

[@sarthaktiwari976]

very informative video sir looking forward to learn like this!

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

[@ai.divyanshu]

Amazing videos Parth. Looking forward for more.

[@thevaluationschool]

More to come!

[@vasulbatra6971]

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

[@khushalbansal3397]

Doing Superb Work Parth!! Kudos !! Amazing Learning

[@thevaluationschool]

Thanks a ton

[@ajayanant1459]

Sir, Thankyou very much for teaching us.

[@anmoljagetiya9031]

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

[@navneetmukherjee9592]

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

[@NabeelKhan-tl7cq]

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]

Same question.

[@chetanmali23998]

Sir your efforts like 💯💯💯💯💯

[@chipstead7919]

Sir for us this is more valuable than Gold😇

[@vaibhavbaj-yj4lz]

Next level learnings...

[@amaanahmadansari13]

Thanks for doing this for all of us.

[@gauravvarshney1646]

Thank you sir for sharing your knowledge 📈🙏❤️

[@user-zq9sx6bu5j]

dcf baap - parth. thank you sir

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

[@lalitmohansharma468]

Sir, Great efforts keep growing.

[@crypstock2612]

As always, thank you Sir!

[@Vinayworks666]

Thankyou for the session ❤❤

[@ritikaaggarwal6075]

Amazing!!!

[@kritibhansali5944]

🎉🎉🎉

[@harshitmathur6697]

Finance Guru🙇‍♂🙇‍♂

[@muditmohan3627]

Thank you for your efforts.

[@thevaluationschool]

Always welcome

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

[@seekingalpha_]

india ka damodaran❤

[@adityadubey9565]

amazing session!

[@allabouthuskies.9213]

I am really thank you sir❤

[@polestar5897]

❤❤❤❤❤❤

[@architpawar6745]

💯

[@humanocean5790]

Guruji thanks...❤

[@poonamkaushik4866]

❤❤

[@adorable_writes]

Congratulations for 100k subscribers

[@thevaluationschool]

Thank you so much 😀

[@tanmayvarshney9200]

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

[@taxbazaar7364]

Thanks a lot parth

[@pushparaj4567]

Superb class

[@rohitdixit4000]

VERY GOOD VIDEO SIR

[@Nexus26688]

Thank You

[@vjrocks6801]

maza aa gaya sir

[@pranjulgupta9250]

thanks a lot sir

[@suneelpuchakatla]

Explanation nyc, But complete delivered in english it is useful to all some of them not understand hindi well....