0:20 financial modeling is a cornerstone skillset for financial analyst. decision making , project finance, corporate transaction, and other corporate finance transactions. 1:20 Excel tricks and tips: use go-to special function to locate hard-codes or formulas. 1:50 Financial modeling best practices: 3:40 building the forecast: Top-down analysis: TAM, total addressable market. Bottom-up analysis: Regression analysis: relationship between revenue and other factors. Year-over-year growth rate: basic 6:00 further analysis: DCF analysis, M&A analysis, Capital raising, LBO analysis, sensitivity analysis.
I have a confusion and that is, are we going to learn financial modeling in the course of Financial Analysis /Analyst or we have to take separate coursesband certification to learn this? And is financial modeling is different from this I mean we don't cover financial modeling in Financial Analysis/Analyst? I hope you understand what I am asking. Kindly guide me :))
Hi Joshua, All of our free and premium courses come with certificates. To earn a CFI certificate a candidate must: -Enroll in any certificate level course -Download the included Excel files -Complete all of the video-based chapters -Complete the exercises in your downloaded Excel files -Pass all of the final assessments with an 80% grade (you can always retake the final assessments) Make sure that all of the sections in the course are marked with green checkmarks by clicking the green "Next" button on the bottom right-hand corner of the screen. You can access your course certificate from the completion email, or under My Account > Certificates. If you have completed all FMVA® Program requirements (9 core courses & 3 electives), you can request your FMVA® certificate to be emailed to you by filling out the "Submit MY FMVA® Application" form under "My FMVA" on your dashboard. You can also order FMVA® certificates in the mail by completing the order form: corporatefinanceinstitute.com/certifications/order-physical-certificate-printing/ Please read all instructions before submitting the form.
This is one of the best channels on the subject that I came upon, additionally it's free. Thank you
You're very welcome! We are glad to hear that you found the resources useful!
Your content is great and hugely helpful in preparation for the start of my valuation and modeling analyst career in a Big4 company. Thanks!
You're very welcome! We are glad to hear that you found the resources helpful!
Excellent guide to the very essentials of FM! Keep up the good work and the videos flowing! Cheers
We are really glad to hear that you enjoyed the video!
0:20 financial modeling is a cornerstone skillset for financial analyst.
decision making , project finance, corporate transaction, and other corporate finance transactions.
1:20 Excel tricks and tips:
use go-to special function to locate hard-codes or formulas.
1:50 Financial modeling best practices:
3:40 building the forecast:
Top-down analysis: TAM, total addressable market.
Bottom-up analysis:
Regression analysis: relationship between revenue and other factors.
Year-over-year growth rate: basic
6:00 further analysis:
DCF analysis, M&A analysis, Capital raising, LBO analysis, sensitivity analysis.
I have a confusion and that is, are we going to learn financial modeling in the course of Financial Analysis /Analyst or we have to take separate coursesband certification to learn this?
And is financial modeling is different from this I mean we don't cover financial modeling in Financial Analysis/Analyst?
I hope you understand what I am asking. Kindly guide me :))
You are amazing guide!!! Please keep going!
Thank you so much Nguyen! We are glad to hear that you enjoyed the video!
Best ever...!!!!
We are glad to hear you found the resources helpful!
great!!
Can the certificate be received via post?
Hi Joshua,
All of our free and premium courses come with certificates. To earn a CFI certificate a candidate must:
-Enroll in any certificate level course
-Download the included Excel files
-Complete all of the video-based chapters
-Complete the exercises in your downloaded Excel files
-Pass all of the final assessments with an 80% grade (you can always retake the final assessments)
Make sure that all of the sections in the course are marked with green checkmarks by clicking the green "Next" button on the bottom right-hand corner of the screen. You can access your course certificate from the completion email, or under My Account > Certificates.
If you have completed all FMVA® Program requirements (9 core courses & 3 electives), you can request your FMVA® certificate to be emailed to you by filling out the "Submit MY FMVA® Application" form under "My FMVA" on your dashboard.
You can also order FMVA® certificates in the mail by completing the order form: corporatefinanceinstitute.com/certifications/order-physical-certificate-printing/ Please read all instructions before submitting the form.
Corporate Finance Institute How long would it take approximately to do all the 12 courses and then receive the Certificate?
X look up is better than index & match
Thanks,
You're welcome!