In celebration of the 2018 CFI Financial Modeling Competition and World Championships, we released this financial modeling time-lapse video of a financial model being built in under 2 minutes! We hope you enjoy watching this Excel model being built, set to the music of Les Toreadors. You can register for the competition at https://financialmodeling.org.
Financial Modeling Time-Lapse FAQ
Q: How long did the model take to build in real life?
A: Georges Bizet – “Les Toreadors” from Carmen Suite No. 1
Q: Who is the person building the model?
A: Tim VipondTim VipondTim Vipond is the Chief Executive Officer at the Corporate Finance Institue, a leading global provider of online financial analyst training & certifications. Lifelong learning is no longer optional. Modern financial analysts require a well-rounded skill set that takes time to acquire: theory, application, intuition
Q: What is the CFI Financial Modeling Competition?
A: An annual event to compete to be the best in the world and showcase your skills.
Thank you for checking out this time-lapse video, we hope you enjoyed it! To learn more and advance your career as a world-class financial analystFMVA™ CertificationThe Financial Modeling & Valueation Analyst (FMVA)™ accreditation is a global standard for financial analysts that covers finance, accounting, financial modeling, valuation, budgeting, forecasting, presentations, and strategy. , please check out the additional resources below:
Types of Financial ModelsTypes of Financial ModelsThe most common types of financial models include: 3 statement model, DCF model, M&A model, LBO model, budget model. Discover the top 10 types of Excel models in this detailed guide, including images and examples of each. Financial modeling is performed for many reasons including to value a business, raise money
Valuation MethodsValuation MethodsWhen valuing a company as a going concern there are three main valuation methods used: DCF analysis, comparable companies, and precedent transactions. These methods of valuation are used in investment banking, equity research, private equity, corporate development, mergers & acquisitions, leveraged buyouts and finance
XIRR vs IRRXIRR vs IRRWhy use XIRR vs IRR. XIRR assigns specific dates to each individual cash flow making it more accurate than IRR when building a financial model in Excel. The Internal Rate of Return is the discount rate which sets the Net Present Value of all future cash flow of an investment to zero. Use XIRR over IRR
Sensitivity Analysis GuideWhat is Sensitivity Analysis?Sensitivity Analysis is a tool used in financial modeling to analyze how the different values for a set of independent variables affect a dependent variable under certain specific conditions. Sensitivity Analysis is performed in Excel to asses risks, measure potential outcomes, and plan for an uncertain future
Financial Modeling Certification
Become a certified Financial Modeling and Valuation Analyst (FMVA)®FMVA™ CertificationThe Financial Modeling & Valueation Analyst (FMVA)™ accreditation is a global standard for financial analysts that covers finance, accounting, financial modeling, valuation, budgeting, forecasting, presentations, and strategy. by completing CFI’s online financial modeling classes!
