Earn your certification as a Financial Modeling & Valuation Analyst (FMVA)®. Register today!

Best Financial Modeling Courses

The 7 most popular Excel modeling courses

Most Popular Financial Modeling Courses

If you want to learn how to build an Excel model from scratch, you’ve come to the right place.  CFI has an extensive library of tutorials, lessons, and training to teach you how to build advanced Excel models. This guide outlines the most popular and best financial modeling courses offered as part of the FMVA™ certification program.

 

List of the Best Financial Modeling Courses

Below is a detailed description of each of the courses, ranked from beginner to advacned. CFI has 25+ courses designed to help transform anyone into a world-class financial analyst.

 

#1 Building a Financial Model in Excel

The courses teaches of the foundations and is designed for beginners.

Learning objectives:

  • Link the three financial statements using formulas and calculations in Excel
  • Build a financial forecast based off assumptions – use drivers to create an income statement, balance sheet, and cash flow statement
  • Learn important formulas and functions required to build a dynamic model

 

Image: Building a Financial Model in Excel

 

#2 Business Valuation Modeling

This course builds on the three statement model and teaches students how to build a discounted cash flow (DCF) model from scratch.

Learning objectives:

  • Comparable company analysis – calculating trading multiples for public compaines
  • Precedent transactions – analyzing past M&A transactions to value a company
  • DCF modeling – how to calculate the intrinsic value of a business based on its intrinsic value

 

Image: Business Valuation Fundamentals Course

 

#3 Sensitivity Analysis

This is one of the best financial modeling courses and teaches students to layer on a sensitivity analysis as well as scenarios onto a DCF model.

Learning objectives:

  • Create three discrete scenarios – a base case, an upside case, and a downside case
  • Build a scenario chooser and “live case” – use Excel’s CHOOSE function
  • Perform direct and indirect sensitivity analysis

 

Image: Sensitivity Analysis Course

 

#4 Mergers and Acquisitions Financial Model

This is an advanced financial modeling course that teaches analysts how to model a merger or acquisitions.

Learning objectives:

  • Build the assumptions: takeover premium, synergies, sources/uses of cash
  • Create a pro forma model that combines two businesses into one consolidated company
  • Perform accretion/dilution analysis of key per share metrics like Earnings Per Share (EPS)
  • Assess the impact on the share price of the M&A transaction for the acquirer

 

Image: Mergers and Acquisitions M&A course

 

#5 Leveraged Buyout Financial Model

This advanced course will teach analysts how to build a Leveraged Buyout (LBO) model from scratch.

Learning objectives:

  • Build a traditional DCF model for the target company
  • Layer on a high degree of leverage and several tranches of debt
  • Make key transaction assumptions such as debt/EBITDA, interest rates, covenants, etc
  • Asses the Internal Rate of Return (IRR) by investor type

 

Image: LBO Model Course

 

#6 Real Estate Financial Model

This industry-specific financial modeling course is designed to teach users how the economics of real estate development project works.

Learning objectives:

  • Learn how to value a property based on Cap Rate and Net Operating Income (NOI)
  • Build a development cash flow model including land acquisition, construction, and sales
  • Build a cash flow and IRR waterfall by investor type for GPs and LPs
  • Create a development pro forma and one page summary

 

Image: Real Estate Financial Modeling Course

 

#7 eCommerce Financial Model

This is a very popular financial modeling course for anyone considering starting their own online business or who works for an eCommerce company.

Learning objectives:

  • Setup all the necessary assumptions and drivers for the eCommerce business
  • Model the three financial statements into the future
  • Calculate important customer metrics and unit economics
  • Value the business and create output charts and graphs

 

Image: Startup e-commerce Financial Modeling Course

 

Financial Modeling Courses in the FMVA™ Program

These courses progress from beginner to advanced and are recommended to be taken in the order laid out above. If you are considering enrolling in the full Financial Modeling and Valuation Analyst Program (FMVA)™ you will also be required to complete other classes that cover critical skills for becoming a world-class financial analyst.

Additional topics include:

  • Accounting
  • Financial subjects (behavior finance, financial math)
  • Presentations and pitchbooks
  • Data visualization, charts and graphs
  • Corporate strategy

The modern financial analyst requires more than just technical Excel skills and should be able to perform comprehensive analysis that beautiful presentations and considers the overall strategy of the business and industry being analyzed.

 

Additional Resources

Thank you for reading this guide and list of CFI’s best financial modeling courses. To continue advancing your career as a world-class financial analyst these additional resources will be helpful:

  • Types of financial models
  • Analysis of financial statements
  • Valuation methods
  • Free Excel modeling templates

Financial Modeling Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)® by completing CFI’s online financial modeling classes!