Upskill in financial modelling with in-depth courses on essential topics, from financial statements to advanced leveraged buyouts.
Financial Modeling Essentials
Learn how to analyze financial statements, build financial projections and perform complex company valuation - all in Excel!
1. Introduction to Financial Statements
Understanding financial statements is a critical skill for all management executives. This course provides a brief overview of the 3 financial statements and how to perform some financial analysis in Excel.
2. Financial Projections
In this course, we predict the future performance and financial health of a company by building 5-year projections for MarkerCo's financial statements.
3. Performing Your First Company Valuation
This course will show you how to estimate a company’s value using several valuation techniques. The key company valuation concepts are covered, such as enterprise and equity value, capital asset pricing model and terminal value.
4. Leveraged Buyouts
Debt structures are very common in financial modeling and are required learning for analysts. In this course, I'll show you how a private equity firm uses different forms of debt to purchase MarkerCo in a leveraged buyout.
Advanced Financial Modeling
Learn how to build a variety of financial models that cover a variety of different business use-cases, from a fast-growing startup raising venture capital to a large company merging with a smaller rival.
1. Modeling startup investments
Valuation models for fast-growth, early-stage companies require a different approach to established, stable businesses. We’ll value a fictional startup, TrackerTime, which is seeking investment from a venture capitalist.
2. Mergers and Acquisitions
Mergers and Acquisitions are transactions in which the ownership of companies is combined into a single entity. This course will show you how to analyze a fictional acquisition in the clothing retail industry.
3. Advanced LBO Modeling Part 1
This course provides a much more detailed financial model for an LBO transaction, incorporating many new concepts and accounting principles, not included in our previous LBO course.
4. Advanced LBO Modeling Part 2
In this course, we learn how to adjust our financial statement projections, due to the acquisition of the company. In addition, we perform a series of analyses to generate a recommendation for Dealer-Partners on the proposed deal.