Financial Modeling with Excel

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.

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

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.

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.

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.

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.

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.

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.