Learn Financial Modelling - Step by Step - Session 6 | Forecasting

  Рет қаралды 134,470

The Valuation School

The Valuation School

Жыл бұрын

#financialmodeling #valuation #financialmodelling
In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in FINANCIAL MODELLING as BEGINNER. It covers Sales Forecasting in detail. I will guide you on how to automate forecasting using historical financial statements.
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 - +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

Пікірлер: 722
@thevaluationschool
@thevaluationschool Жыл бұрын
Please mention is the comments which all concepts you want to learn in the future.🙏
@kajalnayak1365
@kajalnayak1365 Жыл бұрын
Case study analysis. dCF, revenue models etc.....
@___oggy___2787
@___oggy___2787 Жыл бұрын
Any finance related topic that help us in future
@mayankmakkar9610
@mayankmakkar9610 Жыл бұрын
Thanks for the amazing session. Would love a video on the bond market with deep conceptual knowledge with examples and resources after this series. I mean real life scenarios which help us to develop more domain knowledge about it.
@vinayakhalapeti
@vinayakhalapeti Жыл бұрын
And please make video on Industries analysis
@manralsachin7748
@manralsachin7748 Жыл бұрын
@@kajalnayak1365 sir r u linked in
@lakshaygairola6158
@lakshaygairola6158 11 ай бұрын
You donot have any clue , how many blessings you are getting by providing these videos for free, may god bless you.
@rohitgupta3434
@rohitgupta3434 23 күн бұрын
Seriously bro, I was tired but could not find any worthy video on youtube..he is a pure gem, felt like bhaiya se ghar meh padh raha hu
@allenanthony429
@allenanthony429 25 күн бұрын
Sir i casually searched financial modeling on you tube the the first video that popped up was yours. and Iam so glad that it was your video. your financial modeling course is more worth than any other paid financial modeling course on any other platform. your doing a great job thank you so much
@kajaltiwari7044
@kajaltiwari7044 Жыл бұрын
I can't thank you enough sir. Without you financial modelling couldn't have been easier. Looking forward to more resourceful sessions ahead. Keep spreading healthy education to you're youtube family.
@madhuraj9810
@madhuraj9810 Жыл бұрын
haven't seen a more comprehensive series on modelling....appreciate your sincere effort.
@Miureoo
@Miureoo Ай бұрын
the quality is something that even MBA schools don't teach, thank you for your service can't wait for it to break millions of view record soon
@adityasurve3076
@adityasurve3076 8 ай бұрын
This guy is a pure soul legend , he teaches so well and made the valuations so easy , Hatsoff man❤️
@UPTRADE754
@UPTRADE754 Ай бұрын
Sir mere pass koi word nahi Hai forecasting model banane ke liye mujhe 1 din Pura lag gaya dusre ke reference se dekh dekh kar banane me or apke is video se 1hour me Pura forecasting model Sikh Gaya me really thank you sir .
@bgmworld4038
@bgmworld4038 13 күн бұрын
Best course to lift the concepts of Financial modeling at most practical manner. Bas thoda price kam kardho sir, although i know comparatively low he hai par just a request so that students like us can afford it
@AsthaRathod
@AsthaRathod 2 күн бұрын
Thank you so much for this amazing playlist. Blessings
@sruthikakarlapudi5774
@sruthikakarlapudi5774 2 ай бұрын
@thevaluationschool Im so blessed that i have came across your channel. I did fmva course twice and not from both the cources i got such depth knowledge. Trust me these formulas i dont even think about anyone who will guide in such detail. As i remember during my second course for which i had paid a hude amount but even after that we hadnt got the clarity im always confused about forecasting as we were taught to use historical average but i was never satisfied with the forecast but today im sure this will change. Thank you so much. Keep growing and keep sharing knowledge. May god bless you
@vishnumeghwal5431
@vishnumeghwal5431 15 күн бұрын
Best financial modeling class
@manishmaninair2196
@manishmaninair2196 8 ай бұрын
I have not seen such a detailed teaching of Financial Modelling. God bless you 🙌.
@shlokwadhwani8159
@shlokwadhwani8159 6 ай бұрын
This is the absolute best learning experience ive ever had in my 16 years of education.
@anoushka632
@anoushka632 Жыл бұрын
Thank you so much for teaching these concepts so well! I have done my masters in finance and nobody has taught this as good as you. THANK YOU SO MUCH
@dhairyagheewala3658
@dhairyagheewala3658 11 ай бұрын
One of the clear and smooth Financial Modeling concepts I learned. Thank you to the Valuation School for the detailed classes
@yashkukreja9538
@yashkukreja9538 10 ай бұрын
How can someone be this genuine. Hats off Sir!! I'll always look upto you. Just wanted to say thankyou.
@sarfarazmondal83
@sarfarazmondal83 8 ай бұрын
Sir, your leadership and guidance have been truly inspiring. Your wisdom and dedication serve as a great example to all of us. Thank you for your invaluable mentorship.
@amlanmishra9644
@amlanmishra9644 5 ай бұрын
This is the real goldmine, no one will share it on any platform. thank you for bringing this forward. I have prepared the data and also I am very sure that my data will never disappoint you. thank you again.
@chunkivibes_70
@chunkivibes_70 23 күн бұрын
Successfully completed this session. Thank You.
@iftheqarmohammed7143
@iftheqarmohammed7143 11 ай бұрын
I believe this one series of yours is 100 times more valuable than my whole graduation. I really appreciate your patience and passion for teaching. I kindly request you to keep teaching us the same way. I will remember you as my first financial modelling teacher for my whole life. lots of love from Hyderabad❤
@yashswimanek7584
@yashswimanek7584 2 ай бұрын
YES PLEASE MAKE SERIES ON FUNDAMENTAL AND TECHNICAL ANALYSIS ... AND HOW TO USE SCREENER AND OTHER FINANCIAL APPS OR SITES..
@sanjaymondal3412
@sanjaymondal3412 Жыл бұрын
The Finance guru of mine! sir doing a job in equity research and still learning more new things from your video. Your content is a phenomenon !!!!!!
@rajatbaddi3133
@rajatbaddi3133 5 ай бұрын
Parth Sir you are just amazing! I have been watching all your lectures on financial modelling since beginning and not a single piece of learning I am not clear about till now. Huge thanks to you sir, hats off to your dedication for teaching us voluntarily. This has been a great help and my FM learning journey is going on without any difficulties all because of you.☺🙌
@prashantchapagai6294
@prashantchapagai6294 Жыл бұрын
Sir, I kindly request that you provide some videos on DCF that cover beta analysis, revenue model, WACC, and stock price analysis etc . I ask for these videos because your step-by-step approach provides great deep learning opportunities for all of us. Thank you Sir!
@KaraokeMastery
@KaraokeMastery 7 ай бұрын
Literally, sir you've won the hearts of Accounting and finance students. Literally, I think the first ever course in which i never felt bored. I'm commenting while traveling, and watched your this video in bus. Love form Pakistan
@taranshsharma4289
@taranshsharma4289 7 ай бұрын
Thank you for sharing such a valuable content for free. Respect +1000
@architpawar6745
@architpawar6745 Ай бұрын
The way you teach financial modelling is fantastic sir
@MoheenMeer4367
@MoheenMeer4367 8 ай бұрын
Hello sir, I feel blessed that I come on this channel and learn financial modeling with you,I watched every videos of financial modelling without being bored, on every video I feel like "chalo aaj kuch Naya seekhne ko milega"thankyou very much for being here and guide us😊
@harsheetprajwal2014
@harsheetprajwal2014 7 ай бұрын
Literally one of the best mentors!!!!!!
@ParthMore276
@ParthMore276 10 ай бұрын
the depth of knowledge associated with each action and topic >>>>> Thank You so much Sir !!
@vickynagar4001
@vickynagar4001 Жыл бұрын
Hi Parth, I have done MBA in Marketing and wanted to learn about financial modeling. After searching on youtube I am glad to know about your channel. Thank you so much for making this kind of in-detail analytical video.
@waqasiqbal1652
@waqasiqbal1652 Жыл бұрын
It was amazing watching this whole process and learning side by side.
@nishantpardeshi2979
@nishantpardeshi2979 7 ай бұрын
This series is extremely helpful! Thanks a lot!!
@akshaymaheshwari8981
@akshaymaheshwari8981 Жыл бұрын
You made forecasting look so easy! Thanks much for the efforts and for giving us new and interesting material in every video. Stay blessed.
@AbhishekJain-py7vf
@AbhishekJain-py7vf Жыл бұрын
Sir, thank you so much for uploading. An engineer switching career to finance is getting benefitted from your videos to secure a job in finance....huge thanks.❤️
@muralidandu8993
@muralidandu8993 Жыл бұрын
I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
@user-ie2os3fj9r
@user-ie2os3fj9r 9 ай бұрын
Sir blessed to have you.
@epharsum
@epharsum Жыл бұрын
As we all know this type of course are so expensive....... And u provide such important and valuable knowledge to us without fees......... It means alot sir 🙏🙏
@sharmilabattula6789
@sharmilabattula6789 7 ай бұрын
Each topic you are explaining is an effortless way to understand for me. Thank You so much, Sir
@SrivasKashmeerye
@SrivasKashmeerye 11 ай бұрын
Thankyou sir. I love your teaching style
@13Dipesh
@13Dipesh 10 күн бұрын
Thanks You Sir....God Bless you
@justavi31
@justavi31 10 ай бұрын
Absolutely Remarkable. I am highly embraced with the video.
@Puneet684
@Puneet684 11 ай бұрын
Love you sir for the mind-blowing content.
@nishaa30
@nishaa30 2 ай бұрын
🙌thankful to you more and more
@vaibhavbaj-yj4lz
@vaibhavbaj-yj4lz Жыл бұрын
Going lecture by lecture..... Precious Learnings!!!!!
@NiftyNavik
@NiftyNavik 3 ай бұрын
1.21 hours mein 1 second ke liye aisa nahi laga, KZbin dekh rha hu... aisa lg rha jaise f2f class chal rhi ho... Amazing, Sir @The valuation school
@akashgoyal5344
@akashgoyal5344 Жыл бұрын
you are not a teacher You are a MENTOR , INSPIRATION , GURU for all of us. I can't express in words how much we all are love you sir. keep rocking ❤‍🔥🔥
@jaideepganguly6311
@jaideepganguly6311 6 ай бұрын
58:56 Guruji!! Apne sewak ka pranaam sweekaar karo!!!❤❤ Loving every bit of ur training. You are seriously my top most earnings of this year!!
@vivekharishkini4037
@vivekharishkini4037 6 ай бұрын
Sir, day by day enjoying the class and getting the automated reports gives next level confidence! Thank you so much!
@madhurikambli2167
@madhurikambli2167 Жыл бұрын
Sir I don't know what words to thank you because I myself studied financial modeling in the institute but even with 30,000 they don't teach with as much effort as you, you work very hard and Teaching by dedication, after completing the course in the institute, I was very tensed that nothing was coming, after spending so much money, but after watching your video, my fear completely disappeared, You are very blessed as many people will learn from this video
@vishalmalviya2789
@vishalmalviya2789 8 ай бұрын
sir have completed 5th session. its amazing. your teaching style is very good. thank you so much sir
@SarjeraoKokare
@SarjeraoKokare 2 ай бұрын
maine aj tak is tarah se follow kisi ko nahi kiya,apane bola to maine fatafat jake like kiya ye sab apaka asar hai😊
@electussan1076
@electussan1076 5 ай бұрын
Wow, that's great! Thanks, Man for providing us this type of important tutorial!
@aryanraj8111
@aryanraj8111 11 ай бұрын
You're great Man! Thanks for this forecasting video!!!
@ayushchaturvedi7111
@ayushchaturvedi7111 9 ай бұрын
Hello Sir! I am from science background and now I'm learning finance in my masters. You made it so simple, that I didn't get stuck at any point of time till now in your videos. Really appreciate it.
@adityasoni702
@adityasoni702 Жыл бұрын
i am watching your video. i am really grateful to have a teacher like you.
@digvijaysingh761
@digvijaysingh761 11 күн бұрын
I learned financial modelling from somewhere else but after watching your video I felt that this was much better.
@priyankakothari7099
@priyankakothari7099 Ай бұрын
Great Session, Thank you Sir!
@laxmirawat9662
@laxmirawat9662 11 ай бұрын
sir i am watching your financial modelling series one by one ..thanku sr from bottom of heart.
@user-amrinbanushaikh
@user-amrinbanushaikh 4 ай бұрын
Yes sir start a serial of fundamental analysis 😊
@priyanshugupta9895
@priyanshugupta9895 11 ай бұрын
I am really grateful to Parth Sir. Thanks for uploading this master help.
@vikasarsid1299
@vikasarsid1299 5 ай бұрын
You are blessed, thank you!
@nishantparsadbcpc2014
@nishantparsadbcpc2014 Ай бұрын
Your honesty for the teaching is absolutely amazing 👏❤.....As a CFA student i was relating each and everything that you were mentioning...thankyou for this amazing session
@ashagre18
@ashagre18 10 ай бұрын
Thank you for sharing it
@mandarmitra007
@mandarmitra007 Жыл бұрын
Best clarification on Regression I heard till date! 🥰
@Vinayworks666
@Vinayworks666 4 ай бұрын
Love the session ❤❤
@user-uf6ie6ci5l
@user-uf6ie6ci5l 5 ай бұрын
No words to express, thank you ...
@AmanKumar-td9cv
@AmanKumar-td9cv Ай бұрын
Thankyou for this series:)
@harshit1355
@harshit1355 7 ай бұрын
For simplicity of dividend distribution concept there r parameters which Walter and Gordon suggested on paying dividend or not which determines the price of share. Wherein r>ke (0 dividend), r
@paritoshdixit8437
@paritoshdixit8437 11 ай бұрын
thank you sir, the series is amazing.
@harshjain2468
@harshjain2468 Жыл бұрын
Another brilliant session Sir.Thank you so much !
@ajizshaikh6406
@ajizshaikh6406 9 ай бұрын
Great sir the way you teach is the best and unique
@adarshoffl2469
@adarshoffl2469 Жыл бұрын
Thank you for this video
@tanishqtaparia3229
@tanishqtaparia3229 5 ай бұрын
sir your videos or rather your teaching does not need feedback. All the videos are gems that can not be priced.
@shreyagawande4756
@shreyagawande4756 Жыл бұрын
Sir, I understood 3 ways of forecasting. Thank you🙏
@cafinal205
@cafinal205 5 ай бұрын
Thank you so much sir, You have truly enriched my skills and helped me to look at financial modeling as "interesting"
@mehranahmad5294
@mehranahmad5294 9 ай бұрын
Thanks so much Sir for such a great session. I am really very thankful.
@devanshshah2822
@devanshshah2822 Ай бұрын
Bhai kegend ho aap, love the end part!!
@djdipak8693
@djdipak8693 3 ай бұрын
Great learning🎉
@RupaliMaurya2606
@RupaliMaurya2606 Жыл бұрын
Really grateful for having an amazing content or knowledge shared by you, Thank you sir hats off🙏
@RahulVerma-tq8yo
@RahulVerma-tq8yo Ай бұрын
Very well explained 👏
@sushobhitgarg7311
@sushobhitgarg7311 8 ай бұрын
Realistic and Practical teachings sir :)
@ToytasticFantastic-ll9cp
@ToytasticFantastic-ll9cp 23 күн бұрын
Great Work, very helpful.
@deekshagupta8290
@deekshagupta8290 Жыл бұрын
Thank you for this valuable Video😃
@UnnatiNarsaria-jm3iu
@UnnatiNarsaria-jm3iu 3 ай бұрын
Excellent video. Must watch to learn Financial Modeling
@ailaraghuram9712
@ailaraghuram9712 2 ай бұрын
Your lectures are excellent ❤
@vivekdutta1010
@vivekdutta1010 3 ай бұрын
Hello sir, I was part of the SEP 2023 Equity Research batch, having seen many students did forecasting in their reports, and i didn't know how to do forecasting at that time, felt it should be there on my report, so finally aaj jitna aapne btaya, utna to sikh gya hu. Thank You ! 🙏
@QuotesOcean24
@QuotesOcean24 8 ай бұрын
Amazing Session Sir... Thank you so much for such amazing knowledge and your guidance...
@ceo.yashvardhan
@ceo.yashvardhan Жыл бұрын
Sir please keep going 👏✨!!! This series is helping me a lot. This KZbin channel is a goldmine for Finance students. 🔥💫
@financewise5304
@financewise5304 8 ай бұрын
Thank you sir for constant efforts
@vanshajrai5346
@vanshajrai5346 5 ай бұрын
Crazy learning experience!
@khushiverma3714
@khushiverma3714 Жыл бұрын
great session covid me clgs bnd hone se pura touch chla gya tha finance se kafi vedioes try kri but most of them was for marketing n some was very complex but aftr getting to yur channel u made it soo easy PURA REVISION HO GYA EK TRH SE still very greatful ese hi guidence and session provide krte rhiye please rukna nhi THANK YOU SO MUCH
@tushtichakraborty4149
@tushtichakraborty4149 4 ай бұрын
....MY MIND IS BLOWN THIS IS SOOOOOOOOOOO GOOOOOOOOOOD
@subhamchowdhury6296
@subhamchowdhury6296 4 ай бұрын
i'm an MBA student with a non-commerce background. your video is helping me so much. all my classmates watch your channel. thank you sir.
@mayankpradhan5308
@mayankpradhan5308 Жыл бұрын
Sir, I've never seen a mentor like you in my entire life. You are truly a gem!! As of now, I've spent more than 1 Lakh in learning financial modeling but never felt confident even after completing those courses. But now just because of your efforts and teaching it's getting easier for me. Thanks, A Lot Guru Ji !! 🙏
@anshumanrana9469
@anshumanrana9469 11 ай бұрын
i loved it seriously i watch each and every vedio of this financial model
@sandeepshukla6657
@sandeepshukla6657 10 ай бұрын
Sir thank you, I had purchased high price financial Modeling course, but I don't get any thing but Now I get the real legend. ❤❤❤❤❤❤
@DigvijaySharma574
@DigvijaySharma574 11 ай бұрын
Great video ,thanks sir
@kruthikabr1548
@kruthikabr1548 7 ай бұрын
Thankyou sir for another amazing session.
DCF Excel Modelling | Step by Step - Session 7  | Investment Banking
49:03
The Valuation School
Рет қаралды 122 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 19 МЛН
路飞被小孩吓到了#海贼王#路飞
00:41
路飞与唐舞桐
Рет қаралды 68 МЛН
Learn Financial Modelling - Step by Step - Session 5 | Ratio Analysis
57:57
The Valuation School
Рет қаралды 136 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 381 М.
Build a Dynamic 3 Statement Financial Model From Scratch
32:26
Kenji Explains
Рет қаралды 1 МЛН
Learn Financial Modelling - Step by Step
41:11
The Valuation School
Рет қаралды 992 М.
10 Private Equity Terms Explained In Basic English
13:20
Afzal Hussein
Рет қаралды 38 М.
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 19 МЛН