Master WACC Modelling | DCF Modelling | Session - 8 | Investment Banking
ฝัง
- เผยแพร่เมื่อ 18 ธ.ค. 2024
- 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 -cutt.ly/h3svQpU
📛 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
Learning this in 2024! Splendid and Marvelous pedagogy by Parth Sir.👌
words and comment are not enough to describe your efforts.
You are a person with a big heart providing useful resources for free
God is blessed on us Rishabh!
I m speechless, before watching your channel I watched 2 days workshop across different channels. And your content is best and the best part is freely available for everyone.
I love session and The thing is easily percivable by your mentoring peculiarity.
Your genuine concern to make sure each and every viewer understand the concept without worrying about total views is truly heartwarming!
Have watched content from many TH-camrs but none of them are as selfless as you.
Keep up the good work!
Parth, your sessions are pretty good and I eagerly wait for them, because I do hands-on based on the learnings of the session.
No valuation session in the last 12 days, I hope your commitment for this series has not gone down 🤞.
yes sir !
God Bless You, sir. Love from Bangladesh.
Parth Bhai love from Pakistan. I love your videos and learned alot.
I'm Altaf Shaikh, Lots of Prayers and Love and a Hugeeeeee Huuuggggeeeee Respect to Parth Sir💜🤍 Really loving all the sessions and Really Really Appreciating your way of teaching and Guidence. Huge Respect🫀
Thank You so much sir for teaching us with such selflessness .❤❤🙏
Mr. Parth, You should try Alt + h + k instead of multiple Alt + h + 9
Bhayya, vo tho accounting format pe chale jaate hai na!!!!
Thank you so much sir for such valuable content!!!
I have been following your videos since day one and have learned a lot from them. Thank you for creating a new session on the DCF model when we requested it. However, we would appreciate it if you could increase the frequency of your videos.
My pleasure!
thak - thak = thak thak , tabaahi video
Thank You Parth Sir for your mentorship, Highly Appreciated!
Liked your video. Just one suggestion is to keep your video and presentation board screen separate and not overlapping. Because of this some part of the video screen sharing content is not visible during the video. Create a separate area for that. Thanks
feels like learning a lot new since session1... Thankyou sir
Great Lecture Sir ,just Loved It ♥️
Thank you sir, your video is really helpful!
Sir please make a video on cash inflow and outflow of a model related with property summary.
Very Valuable Video.🤩🤩🤩🤩🤩🤩🤩🤩
Yes sir, You are a true mentor.
=Sum(Thank you, God Bless you sir)
Thank you so much Sir for such a wonderful session.
Sir plz upload again after 24 min+ coz u are seating infront
Thank you so much once again sir
I can Surely say that jo ap sikha rahe ho n wo kai log paise deke bhi nhi sikha payenge
so very very big thanks for you
keep shining sir and keep mentoring us
1 point or sir
from last 2 months job chorke baitha hu isle ki mujhe mera passion flow karna h wo ye h ki financial modeller ya equity research report prepare karna and all the things. but dikkat ye h ki 2 month se job nhi paise nhi bs ek room me padh rahe h self demotivation bhi ata h ki kya kr raha h job karta fr sath me padhta but nhi ho paya or un sb ko soch soch ke demotivate hotaa rahta hu koi solution h to bata n sir
Teaching style 💯💯💯❤️❤️❤️
It was perfect every last bit of it.
Best channel❤❤❤
Thanks for the amazing information.
This guy literally deserves to get his face printed on every rupees note replacing that bald headed spec guy😂😂........ you are a god sir🙏🙏🙏
🙏🙏🙏🙏.so Informative class
26:02 leverred beta should be greater than unleverred beta
27:23 1.51 ka leverred beta hoga sir
Just loved this...❤❤
Excellent 👌👌 knowledge
Just loved this!!
Apka bhut sukriya maharaj ❤
Amazing Session..!!
Please keep your video on the top right corner so that we can see what is done in the sheet
Love the session😍
Which session has the data file of 10 companies?
Done with the 8th session. Do I need to learn DCF valuation too for this series?
IF U HAVE TIME U CAN GO THROUGHT IT IT WILL HELP U ALOT
I have one query
In starting session we started to work on "Tata Motars" so whatever you are teaching now how we will insert that for "Tata Motars" plus I am watching this series in may 2024 so probably some of the data would have been changes over a period of time so how to deal with that.
Great❤
I learned a lot of from you sir, i am very thankful to you, when we get next session?
Wednesday!
I like that kadak motivation
Sir I have a confusion you have taken market cap of company as total equity in starting . In this we will not take equity capital plus reserve calculation .
can anyone provide me the link of all these DCF valuation notes .. Thank in advance.
please sir more video on Financial modelling
Why levered beta is taken as 1 for all peer coms?
Request you give a data file. Workings we will do. Plz help us with only file.
Can you please join all the work in a single sheet... It's like step by step from start to end
Great sir ❤️
Hello Sir,
Please share the working sheets as in Google Drive, the sheets are not downloading.
Please share..it will be really helpful.
Do we need to remember the format and all the tables you create in it like Cost of debt, WACC, Capital structure etc?
That the Great Session😎
Thanks sirji alot
sir when i calculate unlevered beta for Hindustan Unilever is value 0.77 ? why
thankuuuu 😇🥰😍
Sir ...is it all over full course of financial model ???
Or something remains ??
kindly share shortcut for mac number if possible.nonetheless content provided by you is excellent quality
Sir i have a doubt regarding the unlevered beta. You said it's lesser than levered beta but shouldn't it be higher because we can arrive at levered only if we remove debtors cash flow details and interest
For finding cost of equity shouldn't we have to take the unlevered beta?
No
HATS OFF
Sir yeh 2 excel files locked hain unable to download pls. open it.
In the Valuation for the Company. If the tax rate is not the same in each year, then the WACC is also not the same in each year, is it?
It may affect Kd
hello sir, the excel sheet isn't visible
Sir how did you calculate the pre tax cost of debt? As I can see in the file that you have shared it shows( 69 ÷ 710) where 69 is int.expense of avenue supermart of 2020. & 710 is total debt. My question is how did we come to this conclusion of taking int. Expense of 2020 and not of any other year? Please answer sir.
Thank you
BRO IT IS JUST NUMBERS HE TOOK
PLS SEE THE NEXT SESSION OF WACC FOR ACTUAL VALUES
Sir thank you so much for this lecture. I also want to learn Valuation as well so if not on youtube where Can I purchase your course?
Hi Akshay, pls get in touch on LinkedIn
Sir assa lag raha hai apki shakl dekh ke padh raha hu isse accha to excel hi nhi dikhate apne adhe se jyada ane chare ke peeche excel dikhaya hai 😅
How to calculate total debt from Balance sheet?
Sir thoda ye beta aur other financial terms me problem ho raha h kyoki Aaj Tak kabhi ye sune nahi h
Hum bcom ke first year me h toh abhi ye sab terms aaya nahi h
Iske pehle Tak ka sab samaj aa gaya par yaha problem ho raha h kuch palle nahi pad raha
Aap bataye kya kare 🙏🏻
hlo sir, can you please share the exercise sheet again of this session?
Thank You
How to get total equity
sir please tell how many lectures of FM are remaining?
Sir,
where I can find next sessions which continues financial modelling series after sessions 6, which further will continue with like peer analysis and common-size statement.
I was like at the end of sessions 6 and was curious to find next steps .
It was basics of financial modelling. Uploaded with an idea to vanish fear of Modeling among students... Pls start watching DCF modelling... The video on common size statement and peer analysis will be coming this week.
@@thevaluationschool Thank you Sir.
Why you delete one video(WACC PART-2)sir?
It will be re-uploaded tomorrow
great
Great
Hi Mr. Parth, I registered for ur zoom session on CFA scholarship but unfortunately held up with other work. Is there any proforma for d successful application? Wud be very much obliged if u cud share one or at least d zoom session link if recorded! 🙏
He will upload session on scholarship
Yes tomorrow
phir Bina kisi 'deri' ke shuru karte hain...
12:15 ke pass
Aap ki khasi bhi thak se nikalti hai
Thak thak 😂
16:14 haa sir mai jaa raha hu udemy pe par kaun sa course karna hai o please bata do ( cute wale emoji)
Only One session a week?
Coming on Wednesday!
@@thevaluationschool Please Take more sessions in a week!
Sir First 🤣
Hahaha... you got it
9:26
14:33
❤️❤️
sir apka face jo hai usae thora chota karo bohot chize ap jo likhteh woh chup jatah hai apke face ke piche
❤️
shortcuts for supercripting
¹ - Alt+0185
² - Alt+0178
³ - Alt+0179
Rationale for the Target Debt??
I m speechless, before watching your channel I watched 2 days workshop across different channels. And your content is best and the best part is freely available for everyone.
Thanks for the amazing information...