Learn Financial Modelling | Step by Step - Session 13| DCF| Investment Banking

Рет қаралды 52,311

Жыл бұрын

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...
📌SUBSCRIBE NEWSLETTER - cutt.ly/gw2ozQbj
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp Channel (TVS Mentoring) - whatsapp.com/channel/0029VaLf...
--------------------------
👉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

Пікірлер: 275

@muditmaheshwari4511 11 ай бұрын

Sir, in calculation of Terminal Value, in numerator, we should take terminal growth factor rather than Expected Growth rate??

@thevaluationschool 11 ай бұрын

Yes, it’s my bad😀

@mihirranjan3440 11 ай бұрын

@@thevaluationschool Sir, for NTPC I'm getting an Reinvestment of 115% but in sheet it's 184 what to do?

@muhammadhammad7088 10 ай бұрын

how do we get terminal growth factor bro?

@sanyajain 9 ай бұрын

we have to take terminal or expected growth rate?

@vikashpandey1935 2 ай бұрын

what is terminal growth factor??? please help

@VaradTamhankar77 Күн бұрын

Watched each & every video till here & will continue to do that further but just wanted to Thank you for teaching so many difficult things with ease, sharing your valuable knowledge with us & helping us grow in our career. Wish that I had found this channel little earlier but its always better late than never.

@groundking6461 Жыл бұрын

This financial modelling series didn't only saved me thousands of Rs. but also got me a job in M&A front office at a global boutique IB firm. Thanks from the bottom of my heart.❣

@thevaluationschool Жыл бұрын

Wowww, so happy to see you grow!

@RohanKumar-lx5fi Жыл бұрын

hey @Groundking is there any other vacancy ? i also want to join

@addictedhs7043 9 ай бұрын

In which firm you got the job

@shreyashagarwal1914 3 ай бұрын

Can you recommend me and help me if there is any job vacancy??

@dakshuttamchandani2621 2 ай бұрын

How did you got this job bro? and what other courses have you done?

@RealfitnesswithAditya 5 күн бұрын

very well appreciated. No bullshit only knowledgeable content. Great work

@karansharda2072 Жыл бұрын

Go for the advance financial modelling❤

@MollsPolls 9 ай бұрын

Learning from your FM series has been so fun. And good reminder from your side to practice making the whole model from scratch, definitely going to do that before learning further. Thank you for your efforts.

@SamarthPandya Жыл бұрын

Sir, u are awesome and we are grateful that we found you. The level of content, the style of teaching, the personal touch that you are creating- everything is just awesome. Love to see more and deep content on this channel in the future.

@shikhatIIM 11 ай бұрын

You are doing a great job, and the quality of learning you provide is truly appreciated. Thankyou.

@geetalohia3042 Жыл бұрын

Yess sir we all viewers want you to explain the complicated yet useful excel functions.

@eashwars6660 Ай бұрын

Just binged watched and worked along you the whole way!, Thanks a lot for explaining everything so wonderfully. Now will get back to making DCF for more companies!!

@kirtiverma7255 Жыл бұрын

Hello Sir, thank you for explaining the DCF in such an uncomplicated manner. I was going through the previous videos and noticed that you’ve explained fragments of important data but a quick video on a basic three statement model would be helpful in summing up all the formatting, conventions and the forecasting method as well. Requesting you to create a Short video on 3 statement model of TAMO with schedules included.

@sheetalmaurya9518 Жыл бұрын

Hello @parth, I got to know about your channel through one of my connections. So no worries word of mouth is spreading...truly amazing and detailed videos I would definitely recommend this to my students...

@s.m.hassan3887 10 ай бұрын

bro thats gold stuff, even in my office no one give a damn help in any one feature of FM, but u helped alot to overcome fear, From Pakistan

@user-fd3jl6tx9m 7 ай бұрын

thank you so much brother for such beneficial videos. I have been watched your videos for the one month and learning a lot of things along with financial modelling. please start teaching advance financial modelling.

@rohankumarpanchal2482 3 ай бұрын

Parth Sir, Your videos is adding more value to my life than anything. Thank you very much

@lakshaychhabra9972 Жыл бұрын

Thank you sir for adding such immense value to our lives!! really grateful to you! Thank you so much

@bhaskarbaruah433 9 ай бұрын

As mentioned in the famous movie " Three Idiots", you have explained everything in Simple Bhasha and have made FM look very simple and lucid.

@aditya9854 Жыл бұрын

Great video sir. Very smoothly explained. Will love to see complicated excel functions in coming videos. Thank you so much.

@princeeagrawal1553 Жыл бұрын

Thank you for the valuable insights on financial modeling! Your videos have been incredibly helpful in expanding my knowledge and improving my skills. Keep up the great work! Waiitng for your videos on Advance Financial Modeling.

@bhumichaubey Жыл бұрын

thanks a lot sir for this playlist..... you are an amazing mentor ... I am literally a fan of yours.

@sabyasachipanda_ximb7717 9 ай бұрын

Thanks for your High quality content. Please go ahead and share your lectures on advance modelling. Thanks a lot for your efforts, highly appreciated!

@Financequick 10 ай бұрын

Go for advanced financial modelling......hatts off to you sir for your commendable style of teaching..... i never came across a teacher like you for this particular topic financial modelling......you are amazing

@anu7192 Жыл бұрын

Sir your teaching is really next level. Please start advance financial modeling. It will be really helpful for us

@umeshdhole3666 Жыл бұрын

Thank you So Much Sir Finally Learn DFC Modelling you Are my Mentor, Love you Sir .

@prasad_create2687 8 ай бұрын

Thanks Parth. I really appreciate you uploading all the videos for financial modeling and making the content really understandable and easy to apply and I also appreciate the small concepts that you take in between the sessions to make the terminologies understanding easier thanks for making this series for all of us💛💛

@mohitrajani1325 6 ай бұрын

The series has been great till now, and I appreciate your hard work, and yes I'm ready to join your advanced concepts as your series has been adding value to me from the day I started watching your videos. Also registered for the LinkedIn cohort of the January 2024 batch, very excited to see you live.

@swatibhamboria158 10 ай бұрын

Hello Sir, first of all, thank you so much for bringing us such fine and informative content. It took me almost a month to go through your videos on Financial Modelling till this session.. I can already say there has been so much value addition.. I have learnt so much from you.. I am a CA Final student.. and have studied about WACC and FCFF in Strategic Financial Management but had almost zero idea how does this work in real life.. was always intrigued with finance and want to be a part of core finance world and now I can feel that happening.. with your support and guidance.. Will be starting with making my own DCF models from this weekend.. Forever grateful for your teachings :)

@CAKANNU 11 ай бұрын

Parth Sir firstly hands down to your teaching style and yes yes yes I'm interested in Advance Financial Modelling

@schooloffinance7372 4 ай бұрын

Sir app hum logo ke liye bahut bahut..Value addition ker rahe hai.. So thank you so much sir 😊😊

@bobbyninan7743 Ай бұрын

Sir, thank you for enhancing my knowledge and interest in financial modelling. Your teachings on financial modelling has been one of the best things I could ask for as a Finance Enthusiast.

@pawanyadav1577 5 ай бұрын

These video series give me motivation to keep learning and sir you really help me in keeping my finance knowledge intact thank you.

@user-ns6wq5ed9u 8 ай бұрын

Hi Parth, Thank you for sharing this knowledge, I love watching your videos and learning about Financial Modelling

@Utsav8097 Ай бұрын

I have been religiously following all the videos from the Financial Modelling playlist. Thank you so much Parth Sir for bringing out such quality lessons, I try to do everything alongside the video and I have gained a lot of confidence through your lessons.However, I will still continue to practice this and learn from the next videos in the playlist but I am extremely grateful to have found your content on KZfaq, you are doing a great job, thank you so much for providing value in the lives of so many students like myself.

@prxbhxt_t Жыл бұрын

Parth Bhaiyya, Atlast done with the basics of FM today with this conclusion of WACC!! Support from Mumbai

@hariomram7191 17 күн бұрын

Thank you for making this amazing playlist. Learning a lot of financial concepts in simplest way.

@kunalvasita2570 7 ай бұрын

its superb way of teaching the complicated DCF financial modelling in easy way .. i really like the way you teach and explain the concept too. Appreciate if you can provide most advance way of Financial modelling too .

@vanshdeval 10 ай бұрын

You are great Sir and Advance Financial Modelling series will be very helpful. Thanks

@harsh_206 3 ай бұрын

13 sessions down the line & its still engaging, You are delivering very valuable content to us!! Thanku so much Parth Sir❤

@sahusatyam045 2 ай бұрын

SIR your seesions are gem. please keep uploading this amazing content . Thank You.

@daninirav Жыл бұрын

Thank You So Much... Great videos and will do that for one company what you taught till this time & Big yes for Advance financial modelling as well as Complex formula in Excel sessions ! Thanks in Advance !

@shreyanshsingh2831 Ай бұрын

you really deserve all the appreciation, have watched all the thirteen sessions till now and I appreciate all the hardwork you put into these videos sir. Your hardwork motivates me to work hard too Thanksalot sir, you really are an inspiration

@madhavlohia6671 Жыл бұрын

I am more than ever eager to learn from you about financial modelling

@subratbiswal3667 Жыл бұрын

hands down for the efforts you're putting in for the learners 🙌🙌

@RohitKamath 10 ай бұрын

The content you provide is absolutely phenomenal. More power to you, Sir. >>>

@anandraisardar2406 3 ай бұрын

excellent video,i being engineer without any commerce background but you explained concepts very lucidly.

@shubhampawar585 15 күн бұрын

sir i love your videos of financial modeling and i love the way you explain the concepts

@investinsight01 Жыл бұрын

adv financial modelling will be more interesting and thanks for teaching us by such a passion.

@namankaushik1008 21 күн бұрын

Thank you sir for such great series of financial modelling and now I will be going to post my first financial model on LinkedIn and will surely tag you sir.

@user-bg2dl2wn3g 10 ай бұрын

BEST VALUATION SERIES I HAVE EVER SEEN

@lataagarwal3830 Жыл бұрын

Thanks for the beautiful session. Waiting for more such videos.

@taranshsharma4289 6 ай бұрын

Daily I am watching your lecture. I joined this channel when we have 65k Subscribers. I am observing that daily 1k followers got increased. This is just because you are teaching very well. Thank you so much for the valuable knowledge sharing.

@James-ms9lh Жыл бұрын

Thank you for this video sir Yes sir Please Start the complicated excel functions and the financial modeling too.

@madhavlohia6671 Жыл бұрын

Yes,i want you to explain the complicated yet useful functions of excel.

@vaibhavkanojiya001 3 ай бұрын

SIR u really have added the value in my skillset Thanks for ur all efforts

@gaddipatisrikanth1177 10 ай бұрын

iam a non finance candidate where i learned more about financial modelling from this playlist iam so amazed its available for free .You definetly added value towards my learning and an great mentor sir!!!! Wanna join your advanced financial modelling cohert also 🙏🤝🙂🙂🙂

@nipashah6378 8 ай бұрын

Thank you very much sir for this free series. I am loving this series

@user-gc8mp7nc9t 11 ай бұрын

very informative, thank you for your efforts and hard work to make our life easier

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

I hope this Comment finds you well. I wanted to take a moment to express my gratitude for your exceptional guidance and mentorship in financial modeling. Each of your videos has been incredibly insightful and has added valuable knowledge to my skill set. I greatly appreciate the effort and dedication you put into creating such informative content. Your teaching style is clear and concise, making complex concepts easy to understand and apply. I have learned so much from you, and I am eager to continue expanding my knowledge under your mentorship. I encourage you to continue producing these insightful videos, and I look forward to seeing more advanced modeling techniques in the future. Your expertise and guidance are invaluable to me and countless others in the field. BTW, I'm watching you from across the border in Pakistan. #Pakistan #GilgitBaltistan

@ektapandey125 10 ай бұрын

Thank you for such great Initiative, informative videos and the amount of effort you put in to all your videos is commendable. I'M a CMA student from India, i keep learning new things of our zone and beyond that and You as a mentor has helped us to gain Skill and built a good knowledge in the finance horizon.Would love to see more of such content specifically if it's on Stock market for a newbie graduates,my sister is interested at it would recommend her if you will come up with stock market classes for as an Investor and Trader as well.

@yashrajput7212 11 ай бұрын

Many times thank you sir from the depth of my heart, lots of love ❤

@kharasdipesh Жыл бұрын

Hell Yeaah..!!! Loved to gain more knowledge and understanding of Advanced Financial Modellings, valuations and Excel Bag of tricks and complex formulas from you

@AdityaAdy Жыл бұрын

Yes sir please start advance FM and thank you so much these wonderful session 🙏🏻

@rising_individuals 11 ай бұрын

Yes i will be joining advanced financial modelling.

@muazebhussain5154 Жыл бұрын

Thank your for such good FM videos and yes want to learn more advance FM

@abhishekmali7894 9 күн бұрын

Thank you. Waiting for the Advanced Financial Modeling sessions.

@wizzyplays8364 Жыл бұрын

Thanks a lot sir for teaching this in such a simple way loved ur teaching style

@litgoluofficial3077 10 ай бұрын

Thank you sir you have made me fearless about financial modelling

@Rajvlogs4401 4 ай бұрын

I really loved these content I am not lieing i have shown my work to the Mba Finance teacher and he shocked and started asking kaha se kara hai then I go for the one and only the valuation school ❤❤

@kundanthakur5604 Жыл бұрын

M exactly vo krne wala hu qki apne jaisa bola m kuch formulas bhool chuka hu abhi Maine usko note pad pr likh kr rakh luga and tq so much sir aap Dil ki baate bol dete ho kbhi kbhi 😅😅

@divyan407 6 ай бұрын

Thanks for adding value in my life...

@ManishKumar-dp2lo Жыл бұрын

Waiitng for your videos on Advance Financial Modeling.

@mehranahmad5294 9 ай бұрын

Thank you so much Sir. You really added value in my life.

@AdityaUnlimited_ Ай бұрын

Thank you soo much sir for providing such quality content

@kartiksahani6109 3 ай бұрын

Thanks for the videos,I Really Appreciate your efforts

@Puneet684 11 ай бұрын

Love you sir for the mind-blowing lessons❤

@taranshsharma4289 7 ай бұрын

Sir ap jitna batao mujhe utna kam hai... :) Thank You So Much Bhaiya.

@amitsingh-be6me Ай бұрын

thanks for making such a valuable videos

@satyendrakumarsharma3801 2 ай бұрын

thankyou so much guruji and app bhot mehnat krhy h ,

@bharatdubey8738 Жыл бұрын

We Appreciate ur effort sir. If u are good at something then absolutely do it for free❤

@badrishpai9141 4 ай бұрын

Thank you Parth Verma Sir for this valuable course. Looking forward for more videos like this. Please keep bringing up value adding courses like this. 32:30 I want to study Advance Financial Modelling from you.

@lakshaychhabra9972 Жыл бұрын

Yes sir pls go with advance financial modelling ❤️❤️❤️❤️

@mathiaslobo7390 Жыл бұрын

Your video was excellent as usual...please make a video on complex Excel formulas

@rajbhalshinge5170 Жыл бұрын

For me personally sir i cant express how you kill my fear for financial model i used to afraid and used to think karo ki na karu sikhna its for difficult and i buy a Course of Fm And they used to teach like Fear or badha diya but thanks to you sir ... Thank you so much

@dharmikvaghasiya423 3 ай бұрын

It is very insghtful video series

@Pancake3399 Жыл бұрын

really i like your vedio. although i am from bangladesh. your vedio very helpful for new learner for me

@sandhya1356 6 ай бұрын

Yes sir Pls start advance modelling classes ❤😊

@huzaifadhorajiwala734 5 ай бұрын

very valuable content....its basically a college...

@rajuvalmiki5672 Жыл бұрын

@Parth Sir 1. Make a video on Most useful Excel Formula In Finance Industry 2. Also make video on Advance Financial Modelling You are just amazing sir ( 🙏 )

@a1classes102 9 ай бұрын

Thank you sir for the valuable learnings❤❤❤❤

@chetanmali23998 Жыл бұрын

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

@thevaluationschool Жыл бұрын

Glad you think so!

@aryantiwari8547 Жыл бұрын

Yes sir please start advanced financial modelling 🥳

@sauravkhandelwal4686 Жыл бұрын

HI Parth Sir, Thank you so much for this amazing series. It would be very helpful if you can explain how to interpret the reinvestment rate and expected growth rate in the India sector data sheet you have attached with this lecture. I understand that the dataset is from Ashwath sir's website but still confused about the two data points.

@parthbhatt1226 Жыл бұрын

Yess Sir we want you to teach hard things in leyman terms❤️

@sumitkumarsingh6982 Жыл бұрын

Thankyou so much must awaited!

@soumyaranjanmohanty3 11 ай бұрын

Hi, why we dint add back depreciation in EBIT(1-Tax) while calculating FCFF?

@karansharda2072 Жыл бұрын

By far the best one

@sanjaymondal3412 Жыл бұрын

Sir, you are no less than a GOD!!!!! or I should say G.O.A.T

@architpawar6745 Ай бұрын

Thankyou so much sir of the knowledge

@sarthakverma7132 Жыл бұрын

Yes sir start with advance financial modelling and excel advance formula.

@navneetmukherjee9592 7 ай бұрын

Sir, please - one video to sum up all at a go and give logical explanations (like, why did we take EBIT (1-T)*(1-Reinvestment Rate)...). It's really tough to find words to show gratitude - you are 'UNIQUE'