Learn Financial Modelling - Step by Step - Session 2
HTML-код
- Опубликовано: 8 сен 2024
- 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.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
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 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 😊
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.
I want to learn financial modeling can you suggest me things - I want to learn finance from scratch
Bhai jab wo khud is youtuber ki tareef kr ra h to wy don't u watch his videos
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
This is undoubtedly the finest financial modeling course. Thank you immensely, sir. Your efforts are greatly appreciated . Sending heartfelt gratitude and admiration from Pakistan
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
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.
made it to 2nd video. This guy deserves all the love for the effort he has given and respect for providing it for free.
Just seeing this video I learned many things which I didn't learn even after since few years.
You gave us broad idea of what exactly real world requires. Thank you😊
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?
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
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
I am a corporate banker with multiple degrees like M.B.A., M.A. (Economics), Law and different banking courses with 35 years experience in banking. I found that your way of teaching is professional and easily understandable. Thank you and best regards.
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
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
I already had an interest in using Excel, but after watching your videos, that enthusiasm has increased even more. Perfect, thanks for sharing.
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!!
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 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.
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
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
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
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
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
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 🥲
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
aap kitne amazing teacher ho .. mujhe pehle pta hota toh mai aap se hi course kharidti ..... hats off sir for teaching style
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
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
Sir mene 4 din m ye class finish ki magar 100% CLR .... Supb... Har concept bahot basic s ache s smajme aaya .... Maza aagya 🎉... Thank you sir ji..
More than your skills, I really like your attitude....Like "Jaana hai to chale Jao video chorke". Great learning boss thanks.❤
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
hands down the best FInancial modelling videos on and off youtube. Really a big thanks for such videos.
Just for the sake of money, good infrastructure, and collabing with Top MNCs many online institutes (won't take name) have degraded the quality of provided education. In the name of placements, big MNCs students like us have been misleaded most often. Because nowadays people believe on them who charge more for such courses for the sake of deliverables. Yes we will pay such amount but the question is are these institutes providing us that level of faculties, education, and skill?
I am so grateful I landed up to this series. ❤ Free series with loads of values
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!
THANKYOU SO MUCH FOR THIS! I've completed paid courses but this comes closest to practical use and thorough understanding, as a Valuation Associate.
Dear Parth, Your Teaching absolutely easy to digest and memories in simple way. Great things to have with no cost. Great Service. Thanks
I will be keeping aside an amount every month from my savings .
I would like to Offer (like we offer to god) this to you for the honesty , effort and Passion you put in your teaching .
You deserve respect of highest honour
India lacks mentors and faculties like you
Sir, the way you are teaching FM with the seriousness, efforts is truly remarkable
I'm in 12 and have paid around 17800 for financial modelling classes but still haven't understood anything but these videos are really helping me out ❤ thanks broooo❤
Itna koi kisi ke liye kese kar sakta hai bhai. Iska matlab ye hai ki aap humse selfless love karteho. Thank you very much sir. Me bhatka hua hu apne career ko lekar please meri help kariye sir. Pehli bar kahi time invest karke itna seekha hai maine. truly remarkable. 🙏
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.
Hi sir,
It was a great learning experience to learn from your videos.
Just one small improvement in one formulae from my end.
For calculating Annual data, as told by you, we should use Combination of Date and year formulae. However, there is some limitation in that formulae. If we'll use Financial year data and we want the end of the year then this formulae won't work.
I had put some other formulae which will resolve the purpose. Attaching the same for your reference.
=IF($C$50
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
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 ❤❤😊
I bought a shitty book of Financial Modelling for 1500... finished it half realizing that i cant do it if i dont know excel and now i am here... TO Complete this session it took me the whole day(Today).. but it was worth every second... loved it.... U taught everything from the basics sir... Now with practice i can do modelling with excel in my command... best part is i get to learn modelling as well as Excel too. Thanks U So much sir.❤
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.
Great ❤ एक नंबर सर.पैसे देऊन जे शिकायला मिळणार नाही ते तुम्ही इथे फ्री मध्ये देत आहात. Salute. THANK YOU ❤️
Day 1: Done with session 1 and session 2 (till 1:11:00) , Will continue tomorrow for Sesion 3 and 4.
Its a Gold content for finance professional like us.
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
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.
Indian instructors are awesome. You have been doing a great job. This is helping a lot
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 .
Hats off sir, I had paid 27000 for the course and not get the value as you are providing..... U r great sir thanks
It's my pleasure
I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
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!
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
@@thevaluationschool hey sir, these keys are not gonna work for macbook, i am using macbook for excel.
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🙏
Seriously bro ,you have very sound knowledge of everything you teach. Thanks a lot for such vibrant session .
This is the best series of financial modelling , I have been searching. I came through linked in. Thank you sir.
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
I'm gonna follow this series till the end of it thanks for giving us this valuable course,that too for free
really appreciate how you deep dive into smaller concepts too. A-lot of my excel queries got resolved thanks to this vid!
Can you please tell me how to work on his excel sheet because we don't have access we can view only.
Please let me know..
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..
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 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🫡🫡
You have an attention to detail like me, hence I am just loving this course.
Glad you enjoy it!
I'm glad that I discovered this channel and i got suchha a knowledge that is more worthy not bcz its free bcz, parth sir us just sharing practical knowledge as well.unlike other classes and institute is not even telling there students but sir is just providing sucha values for free of cost and spending time justt to make a person financial understanding ease❤
Hatts off to you sir🙌
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.
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! 💯❤❤
Sir,i really like this part, Telling info if disable/enable what will happen, such clarity is gems to us.
This is my first ever RUclips video where I was patient enough to sit through the end! Such a great lecture.
Thankyou so much for the course :)
To be honest... This is one of the best video regarding Financial Modelling on internet till now
I will definitely going to subscribe you..❤
1st thing after watching this video is I subscribed
2nd thing I am eager to watch all the videos of financial modelling by you ❤
Paid for a financial modelling course via Wallstreet School! Such scamsters, I did not learn anything at all and got scammed. These videos are more helpful than the entire course 🤣
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.
This class is brilliant. Your skills are uncomparable sir. Thanks for sharing this knowledge in simple words ❤❤
Hi sir, to change the font colour of cells containing formula automatically, we can select the data > Press f5 > Special > Formulas > then pick a colour and excel will automatically change the colour of all cells in that table which contains a formula! :)
Amazing Session Sir.. Thank you so much Sir..
Sir please make videos for FINANCIAL ANALYST COURSE...
Hello sir... Thank you so much for this outstanding free course on financial modeling on your channel. From mastering Excel skills to understanding complex financial concepts, you provided detailed tutorials that are incredibly valuable for anyone interested in financial analysis. It's rare to find such high-quality content offered for free... this will gonna be a life changing experience for me in financial modeling 📊💡 #FinancialModeling #ExcelSkills #FreeCourse once again thank you so much
Thank you very much for such a great session. ❤❤ 🙇♂️🙇♂️Gratitude
Lectures was so good and knowledgable in practical sense . Thank you sir.🥰😍🤩 gem of financial modelling.
Awesome series, very well explained keeping in mind for beginners of excel also. Brilliant Work Mr Perfectionist.
The best learning experience with the best teacher ever seen...
I dont have words. I really enjoyed your teaching. Thanks from heart.
It was an absolutely phenomenal experience to watch this video & gained a lot of insights about excel & financial modelling. I am keen to move ahead in this upskilling series, truly appreciate you efforts for delivering this amazing content that too at free of cost. Thankslot👏💯❤
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. ❤
Hi everyone. I'm from Pakistan. Really these videos are amazing. It covers everything.
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!
Just a remark that you can add shortcut keys used in the corner of each video as sometimes you go with the flow and since some are learning from scratch they're not much used to with the shortcuts you used. There's a software for it also I suppose so you don't have to add each shortcut manually.
This is pure GOLD!!! Thank you for your efforts❤❤❤
I have started learning from these classes..
I am planning to join the wallstreet school.. But I am also learning from your video... Is this series cover the complete financial modelling ??
Hi Parth. This is Syed Arslan from Pakistan. Truly a mind blowing session. It was just like a game to me playing with short keys and references. Love your work and your dedication to your work. Looking forward for more courses with the same energy and dedication like power BI etc. Thank you!😍
Another one from Pakistan, Your teaching method is so good, that i can learn in one take, thank you so much for this huge contribution.
Great work!!! your way of teaching is outstanding. You are truly a gem.
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❤️
to use f4, f5 on laptop, use it in combination with fn key. it will work
Done with this (twice), will move on to 3rd tomorrow. Thankyou.
Sir Just came across your channel through linkedin watching this at 2 am. (recently qualified CA). This is so Interesting!!
Welcome aboard!
Superb sir, I don't even understand fm ever but the way you teach amezing, thanks sir 😢