Learn Financial Modelling - Step by Step - Session 6 | Forecasting
ฝัง
- เผยแพร่เมื่อ 8 ก.พ. 2025
- #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.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
Please mention is the comments which all concepts you want to learn in the future.🙏
Case study analysis. dCF, revenue models etc.....
Any finance related topic that help us in future
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.
And please make video on Industries analysis
@@kajalnayak1365 sir r u linked in
You donot have any clue , how many blessings you are getting by providing these videos for free, may god bless you.
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
1.21 hours mein 1 second ke liye aisa nahi laga, TH-cam dekh rha hu... aisa lg rha jaise f2f class chal rhi ho... Amazing, Sir @The valuation school
You are making me fall in love with financial modelling
Sir I'm a MBA finance student. I am the type of topper whose marks in all the subjects were A but mostly B and C in maths. I still don't know how I managed to pass my accounts and economics paper. Its so embarassing. I'm not good with numbers. But I'm very confident when it comes to communication and public interactions. Given my hold on statistics I was so unsure and scared that this is yet another field which will not suit me. But thankfully your playlist was the first one which showed up in my search. After 6 sessions I feel so proud of myself that I'm able to do these things on excel. I'm learning new things little by little and gaining confidence again. The student inside me is now fully awake.
Thank you sir :)
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 !!!!!!
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
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.
This guy is a pure soul legend , he teaches so well and made the valuations so easy , Hatsoff man❤️
I have no words to express that how helpful these sessions are ! Sir you are great !
Sir aapne aaj proved kardiya ki aap sahi me aannd kumar hai . Sir apke jitna in depth maine MBA me bhi nahi sikha jo aaj me yaha sikh raha hue . Sir hats of to you . Ye mere 7 th day with your FM series
YES PLEASE MAKE SERIES ON FUNDAMENTAL AND TECHNICAL ANALYSIS ... AND HOW TO USE SCREENER AND OTHER FINANCIAL APPS OR SITES..
Hello Sir, I'm Jay Thakre, Final Year Student of B.Com
I am feeling so much grateful to you sir for this life changing sessions for me. And the deepest explanation you have given to such a complex topics that even a commerce undergrad student can understand these topics in the most easiest way... my words are not even enough to thank your invaluable mentorship...
Still THANK YOU VERY MUCH PARTH SIR..!!
I am also following you and The Valuation School on LinkedIn, Instagram and WhatsApp and my Finance understanding has also been increasing every single day...
May God fulfills all of your wishes..
haven't seen a more comprehensive series on modelling....appreciate your sincere effort.
42:00 - Problems in using AM & GM.
51:24 - Forecasting using Regression
Sir, I am switching my Career to Finance, it had been 10 days. Started with NISM Course, just to get understanding. I was also one of those who fear a lot from the Name of Financial Modelling. I thought why not to just watch your videos so that I can atleast overcome my fear. But u explain the concept so lucent that I fall in love with your videos. And after reading various genuine comments it got reinforced. Means a lot. Thankyou Sir.
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 !! 🙏
theory is most imp before the practical and you do very well sir i understand all the thinks you teach. thankyou sir.
Thank you for sharing such a valuable content for free. Respect +1000
The Most humble Persons on youtube are the ones who do not run ads on their channel
Sir, the video is not slow at all and the depth of knowledge you give is commendable. Thank you very much for the time and effort you put into providing us with such valuable material. Also, please make videos about fundamental analysis. Thank you!
So nice of you
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!
sir your videos or rather your teaching does not need feedback. All the videos are gems that can not be priced.
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 ❤🔥🔥
maine aj tak is tarah se follow kisi ko nahi kiya,apane bola to maine fatafat jake like kiya ye sab apaka asar hai😊
Amazing session sir !! It is very rare to see mentor like you who release the video without achieving the pre-decided goal (10k family) but I'm pretty much sure that this channel gonna hit in millions very soon. Thank you for your efforts sir.
If possible can you do a small session on various finance concepts like valuation, risk free rate etc. Like Damodaran Sir have done but in your own method/understanding. It will help alot to explore finance concepts.
Hahaha, thanks!
Best Course for Financial Modelling.
Sir, please do make a video on "How to make an equity research report".
Yes sir please do this
Yeah😢
Please
I agree, sir plzz make it
This is the absolute best learning experience ive ever had in my 16 years of education.
sir i am watching your financial modelling series one by one ..thanku sr from bottom of heart.
sir have completed 5th session. its amazing. your teaching style is very good. thank you so much sir
Never I have watched any course so consistently.
Thank you Sir
The way you teach financial modelling is fantastic sir
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
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.
Fell in love with excel and modelling through you.
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 .
Thank U sir. I have seen Many videos for FM But no one can teach like U, and I understood Real FINANCE MODELING By watching only your YT Sessions. We all Know Its Not easy Things to explain on Virtual mode But Still What you are doing is a hats off to you. Thanks a lot sir.❤🙏
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!!
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.
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 !
🙏
How can someone be this genuine.
Hats off Sir!!
I'll always look upto you.
Just wanted to say thankyou.
@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
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😊
It's a great place to learn things which are not at all provided anywhere. You are genius sir ❤️❤️ Sending you lots of love for helping us learn extraordinary things.
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
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. ❤❤❤❤❤❤
I have not seen such a detailed teaching of Financial Modelling. God bless you 🙌.
Currently watching this session. Previous 6 session were amazing and I brushed up all my degree Financial Management concepts through this playlist. Thank you so much, Parth Sir!
You are such an amazing teacher🙌
I never thought that Financial modelling would be this much easier but after watching your videos everything seems so simple.
good
Sir, you're getting countless blessings from the people who want to learn but can't afford.
What a coincidence 😄
The best video on financial modelling till now. Its doesn't have any comparison. Its such a interesting that I completed 6 classes with in 2 days. Thank You sir. Actually I have a lots of interest in this field. But I never got a proper guidance on that. It is help me a lot. I just completed the MF series. It is Just fab.
It's a Great Session sir, whatever we have learned in financial model forecasting is nothing but one-sided, there are many ways to do forecasting and there are few more techniques to do it. I will definitely apply these techniques too with my financial model learnings. Thanks for sharing such a valuable & useful information with us sir.
I learned financial modelling from somewhere else but after watching your video I felt that this was much better.
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.
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
Big salute and love from Pakistan for providing such a wonderful resource free of cost in the erra where there is no free lunch thanks a lot
Thank you so much sir for putting such valuable content for free in yt... Never thought that I would learn financial modelling for free and that too in such detail🙏🙏
So nice of you
the depth of knowledge associated with each action and topic >>>>> Thank You so much Sir !!
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 🙏🙏
I don't have words to have you like mentor.
Your work is really appreciable & I know some time Money doesn't matter but I really want to support you that's why I am sending your channel to every person who have really beneficial for them. Please Sir ap bhi or ki tarah Gayab Mt hojana
Great work!! no doubt!!
You can start with
First like how u have done expalning path way to choose a career.
Also would love if u can come with a series which explains a taking a career and the required things for that role in details
Eg- i want to become a analyst
So i need to know fundamental analysis
But in fundamental exactly which things to learn that are used in the industry and also which can benefit i am not doing a job but for my self learning
Technical analysis in details for that .. What to learn etc etc
And then which other courses can be done if i cannot afford CFA or other high cost courses
sir, you are the best the great the legendary and the only one who is adding vLUE TO US STUDENTS HATTS OFF TO YOU SIR
Your videos are really helpful, weather people like the videos or not doesn't matter but you are really getting blessings from all of us for providing this free knowledge.
Added to watch later when you where started this series, now i am watching, totally worth it of my time spending on your lectures.
Best source for learning Financial Modelling.
Hi Sir,
Recently i got introduced to your TH-cam channel and i really want to thank you for your knowledge talents , your videos are really helpful in gaining insights.
Parth Sir, words will fall short describing how thankful me and all others who are watching these lectures to you !!💯
The series, the entire channel, knowledge, enriched content in a simple and understandbale way you are sharing with us on this platform is really worthwhile for me. Obviously, money is a factor, i saw the courses charging over ₹80k and you are doing this totally free and especially whole heartedly and with humbleness. Greatful to you !!❤
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
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.
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.☺🙌
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
LOVE FROM PAKISTAN THE WAY YOU ARE TEACHING IS FABULOUS ""THANKS"
I did a paid course and they used weighted average and i knew it was to be done by regression but didn't know how and now thanks to you
One of the clear and smooth Financial Modeling concepts I learned. Thank you to the Valuation School for the detailed classes
i am watching your video. i am really grateful to have a teacher like you.
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.
Literally one of the best mentors!!!!!!
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
The depth of the knowledge you are imparting is commendable respected sir.
So nice of you
Simply Excellent, the knowledge executed is above par but the intent & approach is even above that - please accept whole-hearted thanks for all your efforts - I haven't been able to do much practice, promise you I will
Keep learning ❤️
Each topic you are explaining is an effortless way to understand for me. Thank You so much, Sir
Amazing Forecasting ever seen in excel. Thanku Sir for your efforts.
Your video is very informative and knowledgeable. I was really want to learn finance modeling and I got your yt channel to learn finance modeling.
Sir, I would say only one thing. Thank you so much .
And I wish you endless happiness and success ❤❤❤❤❤❤❤
Respect for you is just getting bigger & bigger so so so much glad that I came to channel like your, so much love, support and good wishes for your❤, & Thank you so much
The best teacher in youtube i ever seen
Thanks a lot sir for this financial modeling session....I saw your posts on linkedin and then I reached your Yt videos....and yes you are saviour of many students who wants to pursue the carrer in investment banking.
Jai neebkarori baba ram ram🙏
Dear sir thanks for giving us such a wonderful practical experience. Ihtasham ACMA here from Pakistan.
Sir, day by day enjoying the class and getting the automated reports gives next level confidence! Thank you so much!
Appka teaching style acha hai.. Bich bich mai app entertain bhi karte ho... Overall thank you for such a wonderful free master class.. I hope app aur zada details mai hmlogo ko sikhoge..
Parth just covered session 6 of financial modelling.
The regression is explained so well.
Kindly start the CFA series too .
Sir, you are so good, I am so mad that I have invested 1 lakh to learn modeling, I learn so easily with you thank you so much for all the sessions. I hope you can teach us how to clear the interview round also.
First thing sir i love your video ur teaching style language everything is amazing and secondly pls start the fundamental analysis series i really want to learn.thanks for everything...
I am Chartered Accountant and MBA. Parth excellent work
the master of modelling you are sir
i don't have words i just only think to say you thank you so much sir for such video and I will promise you I will see your all videos 🙏🙏🙏🙏🙏
Sir I love you genuinely sir I hate financial modelling but because of you I am liking it :):):)
58:05 sorry sir mene apke bolne pe bhi video like ni kiya but is point pe me khud or rok hi ni payi or comment krne se you are best really thank you so much sir....
Bro... This is exceptional❤❤❤
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