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

Подписаться 314 тыс.

Просмотров 152 тыс.

50% 1

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

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 205

@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 5 месяцев назад

True

@simervirdi1915 Год назад

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

@ayushrathore3208 2 месяца назад

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

@deepakjangra171 7 месяцев назад

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

@abhinavchoubey9665 7 месяцев назад

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

@faraximranist5435 9 месяцев назад

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.

@s.m.hassan3887 Год назад

yr parth pls bar bar like subscribe ka lecture ky beech me na bola kro momentum toot jata ha

@SFW7 3 месяца назад

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

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

@ashishagrawal5658 Год назад

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

@thevaluationschool Год назад

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

@vedikakhamayacha7659 Год назад

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

@govindgoel2442 Год назад

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

@thevaluationschool Год назад

So happy to see this Govind!

@HemlataVerma-c6l 8 месяцев назад

Sir ko subscribe karte hoYe from ABHAY VERMA

@yolopug3889 6 месяцев назад

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

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

@tsuki_arts 26 дней назад

sir, I need some advice on whether I should go for CFA. like is there any requirement for us to do that to be known as financial analysts I have talked to my sister she is in the 2nd level and currently working at Goldman Sachs she said well, nobody asks for cfas they need employees who know financial modelling, dcf, some software. CFA does not teach you these things .

@celiafedeandada2771 15 дней назад

Johnson Maria Hernandez Betty Thompson Jessica

@Investingmonk Месяц назад

Sir I am not having finance background but want to make career in it so which course of yours you will recommend equity research or valuation and fin modelling ? And which one will help me to get a financial market job

@Ritu.03 4 месяца назад

One doubt sir, if they are diversified, they don't have any unsystematic risk, right? Since the goal of diversification is to eliminate unsystematic risk.

@thiyagarajangandhi6466 3 месяца назад

They demand only the return for assuming systematic risk

@thiyagarajangandhi6466 3 месяца назад

Aka undiversifable risk

@Ritu.03 3 месяца назад

@@thiyagarajangandhi6466 that's what I said

@surajdasila8030 25 дней назад

No words to admire the efforts you have put in making dcf modelling +financial modelling videos hats off.

@ArthurHubbard-z9x 19 дней назад

Gonzalez Laura Johnson Ruth Young Thomas

@ayushibajaj9438 4 месяца назад

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

@johnbiknobarrington1403 9 дней назад

Miller Shirley Harris Helen Young James

@angelinadavidson5802 16 дней назад

Anderson Charles Harris Paul Williams Laura

@shashwatsrivastav6203 3 месяца назад

Sir aap pls CFA L1 ki batch shuru krdo

@Marketvani 4 месяца назад

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.

@vasulbatra6971 5 месяцев назад

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

@KristyAerts 20 дней назад

Harris Jose Garcia Nancy Hernandez Laura

@yashujhamtani5994 3 месяца назад

Sir of possible please attach a certificate regarding the course as it may help in cv

@lisboaprince4513 29 дней назад

Hi Parth- just started watching and the knowledge you are sharing cannot be measured in any vaulation model because you are getting blessings from millions. ❤

@lisboaprince4513 29 дней назад

Sir- when is the equity class for analysts starting for next batch? want to join u from ireland. i will be ur first international student 😀

@sarikasathe1450 2 месяца назад

Sir can you tell me about the dcf series in order whats that

@shivanshshukla5883 Год назад

Sir ye beginner level hi kafi courses ke advanced se acha hai

@thevaluationschool Год назад

Keep learning Shivansh!

@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

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

@organoindia 6 месяцев назад

How we can take little help to prepare our financial projection

@punitjoshi8707 Год назад

sir, this is DCF modelling session 1, I can't find session 2, is there any session 2 or am I missing on something?

@thevaluationschool Год назад

There is, refer next vid in Playlist

@rockybhagat Год назад

Remarkable explanation. Wonderful. Thanks Parth. Awesome stuff.

@anshugupta6878 10 месяцев назад

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

@nishaa30 5 месяцев назад

Sir financial analyst pr video laiye🙌

@shiwangijivrajika6744 5 месяцев назад

sir, Beta is the measure of Systematic risk.

@deepanshuyadav8252 3 месяца назад

Please start advanced modelling

@kartiksahani6109 6 месяцев назад

Thanks for this usefull information.

@khushiverma3714 Год назад

telegram link please

@umanggupta537 3 месяца назад

Is there a video on TVM concepts

@yashjain6847 4 месяца назад

I have one confusion, I read some articles on Google which show Beta as a Systematic risk. But Parth sir told that Beta is an unsystematic risk. Could you please solve my confusion?

@rahilchoudhury6630 6 дней назад

24 Fintech Ltd ⭐ L1 🐲

@alpeshgupta5117 8 месяцев назад

sir apke videos nahi series he hai and episodes

@ishu9359 Год назад

Sir 🙏🙏🙏 100 videos dekhe aj regret hua Appko bahut late find kiya I'm really sorry for that 😥 But from now onwards no need to see any other mentor ❤

@taranshsharma4289 8 месяцев назад

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

@navneetmukherjee9592 10 месяцев назад

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

@harishkumars5578 2 месяца назад

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

@ramsankar1638 10 месяцев назад

Hi sir, You are saying Beta is the measure of unsystematic risk why? Could Explain that

@rishabshorey7651 8 месяцев назад

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

@mayurnarang8126 17 дней назад

🫀

@tanmayvarshney9200 9 месяцев назад

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

@akshay6280 9 месяцев назад

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

@deepakkohli8543 4 месяца назад

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

@PK-pg2gd 2 месяца назад

I CANNOT THANK YOU ENOUGH

@vaishnavichanna6548 5 месяцев назад

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

@shrutishah1507 Год назад

Sir, Approx how many sessions are still left to be covered? Actually I'm applying for job interviews so I wanted to mention this skill in my resume.

@thevaluationschool Год назад

This an ongoing thing... I don't create boundaries as it restrict my thinking and knowledge delivery to students. Rome doesn't build it a day.

@vaibhavpandey7398 2 месяца назад

Par me to 35 years ka hu 😅

@poonamkaushik4866 3 месяца назад

❤❤

@polestar5897 6 месяцев назад

❤❤❤❤❤❤

@architpawar6745 4 месяца назад

💯

@suneelpuchakatla Год назад

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

@Sahilchaudhary1910 Год назад

38:55 terminology understood but error while speaking i guess- beta is systematic*

@aartidurgapal7904 6 месяцев назад

❤❤

@adorable_writes 9 месяцев назад

Congratulations for 100k subscribers

@thevaluationschool 9 месяцев назад

Thank you so much 😀

@ShutterDiary-yg5yc Год назад

Amazing amazing and amazing looking forward to more sessions 😍

@raghvendragupta9242 10 месяцев назад

Sir With all due respect there is one Mistake Beta is the measure of Systematic risk i.e. risk w.r.t market. Unsystematic risk is company-specific risk.

@nehashukla1216 Год назад

amazing sir remarkable effort and explanation. but please don’t say kya kachra le kr aaye ho this quite insulting to others teacher like you only

@suniljain774 8 месяцев назад

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

@khushalbansal3397 Год назад

Doing Superb Work Parth!! Kudos !! Amazing Learning

@thevaluationschool Год назад

Thanks a ton

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

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

@navneetmukherjee9592 10 месяцев назад

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

@Hooodie123 9 месяцев назад

lessi?

@chethanlobo915 Год назад

Hi Sir, Just wanted to know. If this is DCF Excel Modelling then which modelling was the previous class of forecasting?

@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

@syedmurtazahussain690 Год назад

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

@sparklesssss 7 месяцев назад

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

@pratikshakhande2077 3 месяца назад

Amazing series! Wishing you endless success 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

@parshvsutaria4589 8 месяцев назад

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

@amanrena5084 3 месяца назад

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

@financewise5304 11 месяцев назад

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

@ai.divyanshu Год назад

Amazing videos Parth. Looking forward for more.

@thevaluationschool Год назад

More to come!

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

@aarushisingh7143 Год назад

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

@profha2 Год назад

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

@mick_mickyplays7860 3 месяца назад

sir data ka source bata do

@pn8462 Год назад

sir ad is coming 😢

@CARahulAhewal 6 месяцев назад

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

@alishahnawaz1199 Год назад

Amazing videos of Finance Than you sir i m from karachi

@SurajSingh-qs2lp 9 месяцев назад

sir please make one video on valuation of Revenue buildup

@surabhibajaj4057 7 месяцев назад

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

@utpalamkadkol4195 8 месяцев назад

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

@yashrajdubey4443 3 месяца назад

thankyou sir for this video🥰

@Kausar-2.0 Год назад

Congratulations o15K Followers

@manishal.6513 Месяц назад

I've been watching these sessions with full dedication and the way you teach is great.. I tried some other financial modeling courses but to my vain didn't understand a thing what function they were using, why and what shortcuts were used. You started with the most basic excel functions which was really great and all this for free... hat's off to you Parth sir keep doing these vidoes I love it really insightful

@VishArt-sm7ov 29 дней назад

I've recently got to know about this playlist and the way Sir explains make us forecasting more easy. Hat's off Parth Sir...... and I also share this playlist in my friends circle to get them also benefit

@SuperDheeraj1989 Год назад

Hello Sir, may I know the technology you are using for writing? Actually I'm also into teaching and I'm confused between some tabs. Highly appreciate your time.

@thevaluationschool Год назад

Wacom