Learn Financial Modelling - Step by Step - Session 2
ฝัง
- เผยแพร่เมื่อ 2 ม.ค. 2023
- Financial modelling is a crucial skill for professionals in finance, business, and accounting. It involves building a mathematical representation of a financial decision-making situation, in order to forecast the consequences of different courses of action.
In this course, you will learn how to build financial models from scratch, using Microsoft Excel. We will start with the basics, such as setting up a balance sheet and income statement and then move on to more advanced topics, such as discounted cash flow analysis and sensitivity analysis.
Throughout the course, you will work on real-world examples and case studies, so you can apply the concepts you learn to your own financial modelling projects.
By the end of this course, you will have a strong foundation in financial modelling and be able to confidently create financial models 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
00:04 Understanding Excel settings and functions for Financial Modeling
02:17 Learn how to optimize Excel for financial modeling
07:07 Learn about financial modeling in Excel and how to optimize your calculations and save time
09:33 Automate data table updates and use automatic calculation for efficient financial modeling.
14:44 Learn how to use the analysis tool pack in Excel for regression analysis.
18:03 Learn how to set up the analysis tool pack in Excel.
22:30 Learn how to format cells and columns in Excel
25:32 Learn Financial Modelling step-by-step
30:23 Formatting numbers in Financial Modelling
32:25 Understanding the conventions of color coding in financial modeling.
37:56 Learn how to audit and format cells in a financial model
39:55 Learn to avoid hardcoding numbers in financial modelling
45:51 Learn to group and organize data in financial modelling
48:44 Highlight the gross profit and add a border
52:33 Understanding the process of changing and checking formulas in financial modelling.
54:58 Understanding and implementing partial anchoring in revenue calculation.
1:01:29 Understanding and implementing financial modelling techniques
1:04:03 Immediate results from 5% with 100% impact.
1:09:48 Learn about custom formatting and applying it to numbers.
1:12:55 Hard coding and absolute anchoring are important in financial modelling.
1:17:40 The start date for this year is 15th August.
1:20:25 Learn about casting analysis and how to link cells in financial modelling
1:25:57 Min function is used to find the smallest number in a sequence
1:28:48 Learn how to express the condition 'if less than' in financial modeling
1:35:36 Learn Financial Modelling - Step by Step - Session 2
I have attend paid classes also but this one is truly remarkable
from which institute you have attended class of FM??
@@twinklegehijaIMS Pro school
I am BBA final yr student currently in 6th sem. I am planning to pursue MBA this yr. So should I complete this course now or in future. Pls guide.
@@poojamishra2990 if you targeting top college.. Than you can give entrance exam(CAT, CMAT, NMAT, XAT, SNAP, CET,) to pursue MBA.. OR if you want to go average college which is in noida gurgaon ... Than you can take direct admission in college... What you want to do?? Than I can suggest perfect solution for you..
@@twinklegehija I am not asking any guidance for MBA . I want guidance for this Financial Modeling course. Should I complete this course now or not?
I paid 40- 45K (and lets not talk about how much they asked for placements) for this course that too for online classes and seriously i would like to thank you that these classes are far more good, knowledgeable and detail oriented. Superb sir, thank you so much. 😇
Are you talking about wallstreet school ?
I think u r talking about Wall Street school ryt??
I was also thinking to take up the course from wallstreet do you recommend me to take up the course is it even worth the money you're paying for?
@@jatinchoudhary2450 nope, not at all
@@jatinchoudhary2450 I took online classes so …. If you’re getting offline then I don’t know but anyways they’ll be charging a lot for getting placed and placement without them is not kind of impossible
You are really a gem. I'm a qualified finance and corporate laws professional with multiple qualifications with over 20 yrs industry exposure across a wide spectrum of sectors. However, I found that you are my guru in teaching me the financial analysis the way I wanted. Although, I have read several good books on financial management including damodaran's valuation and IM Pandyes's Financial Management but I was good only on theoretical and conceptual aspect and as I had no exposure in valuation despite being an active share market player. What the raw things I knew on valuation on that basis, I considered my self an expert trader and investor and lost my big fortunes in 2008 global meltdown. Your remarkable knowledge, experience and teaching style is distinct and unique. After loosing almost all of my big earnings, I believe that I can do something now with your guidance. There are rarest of rare who do it as a social work. I'm inspired by you. I wish that you shine like a glittering star as a master guru of financial analysis and valuation. My good wishes for your successful life. Thank you very much.
This is undoubtedly the finest financial modeling course. Thank you immensely, sir. Your efforts are greatly appreciated . Sending heartfelt gratitude and admiration from Pakistan
I would like to express my sincerest gratitude for providing the FM Series. Your hard work and dedication to creating such a valuable resource are greatly appreciated. I am truly grateful for the effort that you have put into making it available for free, as it has been incredibly helpful to me and many others.
Once again, thank you for your generosity and for sharing your knowledge and expertise through the FM Series.
I'm just in love with your way of teaching. Can't remember when I was so much concentrated. Thank you for existing and enriching our lifes.
I am a CA Intermediate Student and getting this top notch understanding of excel.
Even though I may forget the shortcuts and formulas.But main point is I am getting the purpose of those functions.
Discovered a gem for me.
Thank You so much.Will keep practising until I get into articleship.
same learning it, while expecting to become a finalist😅
I have just completed MY CA foundation can i do financial modelling cours ???
I was ca inter student now it's finalist lol😂 it's Great for us to learn fm 😊
Quality of content and knowledge of FM is to the next level, even other paid courses for FM are not able to provide so much information in dept .Thank you so much Parth Sir .
The best learning experience with the best teacher ever seen...
doing it for the very first times. doing it simultaneously on another window. for a newbie, one can learn easily from this video. but it requires patience.this is really amazing. thanks a lot for providing this
This is a very detailed and fabulous FM series . I don't think that Any other FM course can beat this one. ThaFor providing this amazing Series free of cost ❤🙏
what the prerequisite for this course
This is my first ever TH-cam video where I was patient enough to sit through the end! Such a great lecture.
Thankyou so much for the course :)
I have been using excel for more than 3 years professionally and i am just amazed at how much i learned so much more about an application i thought i had high proficiency in, thank you Mr Verma
I can't believe you make it this simple. Thank you so much for providing such a premium lecture for free. Its really helping me and people like me. Once again thank you so much SIR
Your passion for education and commitment to open knowledge are truly inspiring. Your ability to break down complex subjects into understandable concepts is invaluable to new learners, and I wholeheartedly agree that taking the time to truly understand concepts is essential for long-term retention
I am beginner trying to learn financial modelling. So far, I loved the excel shortcuts that you taught. I used these shortcuts in my Statistics exam. Made my work so much easier. Thank you.
Dear Parth, Your Teaching absolutely easy to digest and memories in simple way. Great things to have with no cost. Great Service. Thanks
I already had an interest in using Excel, but after watching your videos, that enthusiasm has increased even more. Perfect, thanks for sharing.
Truly appreciate your hard work Parth Verma Sir. Your videos are incredibly knowledgeable and helpful.
I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
I truly appreciate your efforts, dedication and hardworking by providing such a great course on FM for free. Thank you for your helping heart and thought
Thanks very much Parth for such a inquisitive session and for free of cost.
We all owe you big time.
The way you explain. it's really easy for me to understand financial modelling. i have watched lots of videos but never seen like yours.I want to learn financial modelling and i think i have reached to right place. you emphasized on practicing for building modelling. really going to be helpful. it's said that the more you practice ,the more you learn. by the thanks a ton to uplaoad such valuable knowledge.
Excellent content - love the dedication to detail. Thanks for sharing with the world!
Came here after seeing your linkdin post about financial modelling . You are really working hard and providing this course free of cost. Hats off to you sir.
It's my pleasure
Time Stamps
0:00 - Introduction
2:18 - Optimizing Excel for Financial Modelling
9:51 - Iterative Calculation Settings
18:36 - Basic Financial Modelling Conventions
28:22 - Formatting Standards for financial modelling
34:43 - Basic Forcast Plotting
46:30 - Grouping/Ungrouping Cells
49:30 - Bordering Cells
52:12 - Check Formatting Errors in Financial Model
54:06 - Common Size Statement
56:10 - Partial & Absolute Anchoring
1:00:06 - Change Analysis Statement
1:04:25 - Dynamic Titles & Headings
1:08:17 - Conditional Formatting
1:11:33 - Time Period Functions (Monthly & Annual)
1:17:10 - Year Fraction Function
1:23:10 - Weighted Average Calculations
1:25:22 - Min & Max Functions
1:25:51 - Small & large Function
1:28:47 - Optimizing IF Statement
1:35:50 - Error Checking using IF
1:37:44 - Get in touch with Parth Sir
Sir Thnku so much for you intiative.
Sir jrurat hi nhi thi iski kyuki kch bhi skip nhi krna h kisi ne bhi and thank you so much for all the effort you made for us
Sir I have doubts can i get your what's app number doubts in time period
Hey im not getting the sheet link
While plotting on the income statement why do add 1 within the bracket?
aap kitne amazing teacher ho .. mujhe pehle pta hota toh mai aap se hi course kharidti ..... hats off sir for teaching style
SIR.......i appreciate your hard work...and i really like the way you delivered the lectures of FM.. before this I watched a lot of videos but the content you have provided here is spot on I want to thank you for this wonderfull sessions..
Thank so much sir , i m cs final student and now days i m doing my training in mechant banker, you video give me knowledge of finance and also i practice in my office with valuation department seniors
hello sir! watching your video after seeing the linkedin post. it’s extremely helpful and way way better than the online courses available where they don’t even bother to teach the concepts in depth. thank you for sharing this!!
hands down the best FInancial modelling videos on and off youtube. Really a big thanks for such videos.
What you have done is absolutely brilliant and beneficial . I am a MBA graduate from Bangladesh. I really appreciate your learning methodology. And will be better if you add English subtitle!
I am from Pakistan and I loved this content like anything. It's truly remarkable that such content is available for people like us who cannot pay the high fees or do not know where to start. I plan on completing the entire series.
God Speed to you Parth Verma.
welcome to INDIA
The session was very informative, indeed. All the required intricacies which are very important when creating a Financial model were explained in a very subtle way. Thank you for taking out the time to record the session will be waiting for the upcoming videos.
I see this again today after 1 month, now i understand all this clearly but yes need some practice.
Thankyou so much sir for this playlist, very helpful! 💯❤❤
I'm gonna follow this series till the end of it thanks for giving us this valuable course,that too for free
Hats off to your efforts and dedication. Thank you for such providing such quality content to student for free of cost. Kudos
Till now best skill programme or course to be specific i have came across happy to watch and learn something new keep up the good work despite being a qualified CA and CFA level 3 candidate know much of theory and can relate and understand to but the practical part its just to the point and your efforts really helps a lot specially for the coming aspirants..cheers!! Hoping more frequent video and do plan for LBO valuations and M&A valuations even it will be paid course i am happy to join and enroll but do consider the same...
+1
I am new here. Being biased for all, you will definitely learn what’s not being taught in the customary courses. Thank you so much, Sir!
This is the best series of financial modelling , I have been searching. I came through linked in. Thank you sir.
I'm from Nepal and after a rigorous search I found your video worth it.
Im a BBA student graduate, hope it is going to be Worth!!
Just came across this playlist. It is amazing and detailed. Thank you so much.
Seriously bro ,you have very sound knowledge of everything you teach. Thanks a lot for such vibrant session .
Hi Parth, Thankyou for such a wonderful session, I have started today and I'm really liking your course content and that too you are charging no cost for this. I had paid 60k for 6 months course, that time my salary was only 15k per month, but my learnings are limited till now. After watching your 2 sessions today I realized that your content is adding value to my knowledge and I thank the person who referred me your course. My moto is to switch mu current job and with the present learnings I'm unable to clear the interview due to limited scope and that's why watching your videos. Thanking you again, Keep going brother, Love you and your content❤️
That's like a real tutorial ❤️, Respect to your dedication.
Sir salute h aapko ...itna dept me to koi BHI nhi btata ki "esa kyo krna h , or nhi krna to kyo nhi krna "
Great sir
Thank you
As someone who has worked in Big 4 Audit and have created work papers with excel. I absolutely love financial modeling. Parth, you are an amazing instructor. Thank you.
Bro just a question is financial modelling doable for a commerce student without maths I am a bcom grad will start mba this yr.I am good at acc and not that good at maths so will financial modelling be ezy
Making an IMPACT!
God bless you and your team.
Thank you Parth!
I am interning at Investment Banking and was asked to learn Financial Modelling on my own, but you're helping me alot. Thanks alot and more power to you!
In which company r u interning
Can u share tips to find imtership in ib
No words to express how much thankfull i m for this session.........the way u teach is amazing........kudos to ur hard work..........thank u so much for providing such valuable session free of cost.......Respect🙏
thank you so much for providing us the small insights in preparing financial modeling. Sometimes such small insights become a great catch in the working life.
Sir,i really like this part, Telling info if disable/enable what will happen, such clarity is gems to us.
Awesome series, very well explained keeping in mind for beginners of excel also. Brilliant Work Mr Perfectionist.
Wonder full sir, the efforts you put in this is awesome.
Even the paid teachers don't teach near by this level.
I dont have words. I really enjoyed your teaching. Thanks from heart.
I had purchased financial modelling course from udemy. The structure was not so good. This is far better and more knowledgeable. I promise to do as you say in the lectures and learn financial modelling to the best. Thank you Parth Verma Sir.
This is pure GOLD!!! Thank you for your efforts❤❤❤
This is the best course I have ever had on excel. Thank you!
You really worked hard Parth.
Will definitely follow you, thankyou!
Thank you so much for your sincere teaching, means a lot for us!
THANKYOU SO MUCH FOR THIS! I've completed paid courses but this comes closest to practical use and thorough understanding, as a Valuation Associate.
Please continue this type of series its really very helpful
Thank you so much for teaching these valuable and most imp thing for free of cost. 👍🏻
Superb session. Everything in crisp and to the core
Hardly see such dedication to teach....... Thank you so much sir.
The details with which you have thought us is just amazing sir
Hey Parth , you are doing an excellent job. This entire series seems very very helpful to me. May God bless you. There is one request from my side, once this course is completed then please make a video on how to work as a freelance financial modellor specially for those CA ACCA students who are pursuing their mandatory articleship, in order to support themselves financially.
Thanks again :)
Yee
+1
Loved the style of teaching and the dedication with which minutest of the concepts were taught! Rare to find such good and honest free resources now days!
Glad it was helpful!
@@thevaluationschool hello sir can i get your number because i paid for the modeling classes and learn very little so need to clear and grasp the concept plzz sir you video is good that why i ping you
I'm from andhrapradesh .please do explanation in english completely. it can understand clearly for everyone. By your linkedin post i came to know this course.
@@mrkuldeepshowstopper india don't have any national language.
Not everyone understand English
You shld understand hindi it is our national language.@kristampreethika8121
@@AdityaRajput-oh3sj Dude , i dont want this comment setion to be toxic , But let me know u the fact that there is no national language of our country , hindi and english being official languages are used to communicate any official notices by govt to the public . And not everyone is familiar with hindi ,she is just requesting Parth sir .
Corporate world doesnt prefer hindi . Its just Parth sirs decision to make videos in hindi as it may help this knowledge to reach vast audience and be helpful to them .
@@AdityaRajput-oh3sjitna aagyan 🥲
Thank you Parth for teaching in most easiest way 😊
Found your YT channel from LinkedIn
Seriously the Best the best!! It shows your 101% effort sir! Thanks a lot! ❤❤❤❤
1st thing after watching this video is I subscribed
2nd thing I am eager to watch all the videos of financial modelling by you ❤
Hey Parth. Thanks for sharing such helpful content on financial modelling. Can you please confirm if there is any specific version of excel required for this or if I can continue using Excel 2010?
The amazing way to teach financial Modelling dis is d first online class in which we can understand each and everything so lightly amazing d way u r teaching. Highly remarkable ❤❤😊
Apke jaise mentoring nahi milega Bhai sachme you are the great person parth Verma I like it MBA college mei Bhi financial modelling Ashi wali nahi shikhaya brother you are great Ashi log help kar parth sir love from Mumbai sir ❤❤❤❤
Sir, What a great knowledgeable lecture it was. Thanks for the best information. I was looking for this type of knowledge from last pas 3 months . Thank a lot sir
Amazing video, you are the only one who teach financial modeling for unpaid in such good manner which paid doesn't teach.
Happy to help
The clarity and depth of the content is truly amazing. 📈📊 Every concept was explained so precisely that even complex topics felt logical and approachable. I hav'nt seen the whole course yet but something drew me to talk about the content 1st. Thank you for your dedication to providing high quality educational content. Looking forward to more rewarding classes! 💯 and it’s.
Would love to know if there is any opportunity to work in a Live Project or Internship.
What an amazing teacher you're 👏 hat's off to your teaching skills
Dear Parth, No doubt very informative and very good teaching style.
THANK YOU SO MUCH PARTH SIR.. YOUR EXPLANATION IS MIND BLOWING... HATS OF 🙏🙏
Great ❤ एक नंबर सर.पैसे देऊन जे शिकायला मिळणार नाही ते तुम्ही इथे फ्री मध्ये देत आहात. Salute. THANK YOU ❤️
Lectures was so good and knowledgable in practical sense . Thank you sir.🥰😍🤩 gem of financial modelling.
To be honest... This is one of the best video regarding Financial Modelling on internet till now
I will definitely going to subscribe you..❤
Did everything as instructed.Thank you so Much learnt alot from this lecture.Looking forward to Watch other sessions.Great Job
Bhaiya the way you are teaching I am a fan of yours now. Lots of respect for you bhaiya. Thanks for giving each and every detail of everything. ❤
Sir ji bohot hi tagda padhate ho yaar aap, matlab itne log jo paisa lekar nhi padhate vo quality provide karna har kisi k bas ki baat nahi hai...Salute hai bhai aapko🫡🫡
honestly speaking I have completed one FM course from one channel but sir I want to thank you for your playlist which has helped me to crack my interview ..............thank you very much, sir
Hello
no one teach excel like this as u teach each and every formatting of excel and it's so helpful and needy for finance students bcz we know the formulas but we always lack in presentation and this video ups our skills on excel.
I have started learning from these classes..
I love your teaching style&teaching method
awsome sir ... your teaching is really generous ... you are really honest teacher
I have paid 47,000 for Financial Modelling and valuation but I am honest this one is far better and I am getting a better understanding.
the wall street school
Power pack knowledge session, Parth hats off to your commitment
Glad you find it useful Vineet.
Sir Very very Thankful to you for giving your Best efforts and much more valuable time.
My all friends watch your Videos.
I am feeling good to find the top Best channel on TH-cam for Financial Modelling.
This course is a GOLD MINE!! Thanks Parth Sir
Awesome Parth. These sessions are very helpful.
This class is brilliant. Your skills are uncomparable sir. Thanks for sharing this knowledge in simple words ❤❤
Superb video sir, apne jis hisab se step by step itni clarity se btaya h amazing. I saw full video and i learnt many things. Before thia i already attended few workshops for this but that was also not much clear.
Thank you Sir!
It's really a valuable thing that you are teaching free of cost ask me how much I struggled for those small things which sir is teaching free of cost where other by taking fees also they don't. Humanity is still alive. Thank you sir to improve our nation we need person's like you... Once again thank you sir...
Sir m not able to enter the month it's coming 44078 if I enter the EO Formula sir can you help please