Top 10 Financial Modeling Skills
ฝัง
- เผยแพร่เมื่อ 7 ส.ค. 2024
- This video outlines the top 10 most important financial modeling skills required to be a world-class financial analyst. Financial modeling is the art of building a dynamic tool (an Excel model) that can be used to evaluate investment opportunities, mergers & acquisitions (M&A), capital raising, or to assess a company’s historical and forecasted financial performance.
Click here to learn more about this topic: corporatefinanceinstitute.com...
Interested in CFI's FMVA® certification program? Click here to find more information: corporatefinanceinstitute.com...
![[ไฮไลต์] รอบชิงชนะเลิศ "เทนนิส พาณิภัค" ไทย vs จีน Guo Qing เทควันโดหญิง 49kg | โอลิมปิก 2024](http://i.ytimg.com/vi/xgvTIdE8j3U/mqdefault.jpg)
Top 10 Financial Modeling Skills
1. Accounting Skills
2. Excel Skills
3. Linking the Three Financial Statements
4. Forecasting Skills
5. Problem Solving Skill
6. Attention to Details
7. Simplification of complex information
8. Design Skills
9. Presentation Skills
10. Details vs High Level Strategy
A channel to explain the fmva certificate
th-cam.com/channels/NrwPi14gdOzsl9fA8ITFCQ.html
You guys are amazing. Glad I found you.
That was helpful. You guys produce very attractive and helpful videos, I can't wait to see your next videos.
Thanks 😊
your voice soothed my apprehensive state of brain stressed from searching for the best financial modeling education sites. gracias mucho
Very informative, now just to find some time to watch all your other videos :)
Thank you for this precious advice.
Very insightful. Thankyou!
It was insightful, tnks for the great job!
Thanks for this video,just completed my FMVA course with CFI and they have very knowledgeable instructors
Can you please tell me how much time you devoted to complete the course?
Thanks!
Important topic & useful
Amazing!
Brilliant stuff
Perfect
Hi guys, thanks a lot for your lessons. As a young man from Africa having great passion and interest in finance, i would really appreciate you being my mentor
Thanks
I owe you a lot!
Useful
What about the #6? Attention to detail is really difficult to apply in a full blown multiple sheet financial models. If anyone here have any tips, im all ears
Accounting , Excel, problem solving desingn skills
1) accounting skills
(Need accounting skills to understand (financial statements, dissect Financial statement and build financial statements )
a)Matching principles
b) accruals
c) revenue recognition
d)non cash items (depreciation and amortization)
2) Excel skills
(Understand Keyboard shortcuts and formula function )
3) Liniking three financial statements
Income statement
Balance sheet
Cash flow statement
4) Forecasting skills
(Future performance of companies in Ms Excel)
Science (Regression analysis)
Arts (Management skills
Culture of business)
5) problem solving skills
(Thinking logically organised manner)
Analytics ,soft skills, presentation
6) Attention to details
Number formula function keep track all of them.
7) simplify complex information
Simplicity is ultimate sofistication
8)Design skills
It's more of Arts than science.
Model should be
Easy on eyes
Clean formatting
Beautiful graphs
Look professional
9) presentation skills
Effective presentation to client.
10) Details vs high level strategy
Low level details
+
High level strategy
Are these skills developed in business school?
Anyone recommend the course?
I want more than a 6 minute video.
Top 10 Financial Modeling Skills
1. Accounting Skills
2. Excel Skills
3. Linking the Three Financial Statements
4. Forecasting Skills
5. Problem Solving Skill
6. Attention to Details
7. Simplification of complex information
8. Design Skills
9. Presentation Skills
10. Details vs High Level Strategy
-- -- -- -- --
0:15 dynamic tool (excel model) that can be used to evaluate investment opportunities, M&A, capital raising, assess a company's historical & forecast.
0:50 accounting skills: 1. matching principle, 2. accruals, 3. revenue recognition, 4. non-cash items such as depreciation & amortization
1:10 interpret and understand the financial statement.
1:30 know all main function and keyboard shortcuts
2:30 forecasting skills: science to use only regression analysis, but art to use qualitative factors.
2:45 problem solving skills: think logically and very organized manner.
Where do I start to learn these skills?
Did you learn this yet?
You can go to the corporate finance institute website, but you have to pay for it. The result is a certification from the four main ones offered, and could lead to a career in finance
Use PBI
Pls fix #REF
Why Excel and not R?
Excel is used in traditional finance but R, Python, and SAS are used in quantitative finance. Quant finance also is more statistically and mathematically driven which is why the choice of software changes. I actually have an entire channel dedicated to quant finance.
🙏 Thanks 🙏
What is the Channels name; would you kindly link me
Please?
Why Excel if there Piwer BI: much better graphs, a lot faster.
I'm pretty sure you are not a real user of either, or you wouldn't say that.
Excel? There are far more powerful mathmatical tools available in 2019. If the principle is "advanced use of mathematical and modelling tools" then i am with you. If you are literally hyping excel as the industry standard for financial modelling and charting you are missing a very large space of helpful and powerful tools.
Can you recommend which are the better, more industry standard tools?
@@neelgowariker475 It really sepends on what you are doing. Python and its myriad of libraries has some very useful tools but are not very user friendly (requires coding and knowledge of the language) but is open source, usually well documented, and has a large community of support. Many financial institutions still use SAS for its logging and auditable code but is $$$$. Tableau has gained a much larger following in the last 10 years as well and is still free for personal use (i believe). I am not saying there is no place for excel. I use it everyday, there are just other more advanced tools out there now.
Thanks man. I think I'll go with Tableau. Python just seems tough. Anyway, I'm not much of a coder.