Library

All Tracks

8 courses , 109 lessons , 27 exercises , 8 exams

Financial Modeling

Course List

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.

14 lessons
1 hour
Created with Sketch. Intermediate
Financial Projections

In this course we predict the future performance and financial health of company by building 5-year projections for MarkerCo's financial statements.

13 lessons
1 hour 3 minutes
Created with Sketch. Advanced
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.

13 lessons
59 minutes
Created with Sketch. Advanced
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.

13 lessons
58 minutes
Created with Sketch. Advanced
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.

16 lessons
1 hour 22 minutes
Created with Sketch. Advanced
Mergers and Acquisitions

Mergers and Acquisitions are transactions in which the ownership of companies are combined into a single entity. This course will show you how to analyse a fictional acquisition in the clothing retail industry.

14 lessons
1 hour 4 minutes
Created with Sketch. Advanced
Advanced LBO Modeling Part 1

This course provides a much more detailed financial model for a LBO transaction, incorporating many new concepts and accounting principles, not included in our previous LBO course.

12 lessons
1 hour 3 minutes
Created with Sketch. Advanced
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.

14 lessons
1 hour 19 minutes
Created with Sketch. Advanced