What is a Financial model?

Financial modeling and valuation in Excel 2016: DCF, LBO, and Multiples

A step-by-step guide to Company Valuation

Why value a company? (1:36)
How much is a company worth for an investor? (3:12)
The two variables that drive a firm’s value (1:57)
The mechanism of Unlevered Cash Flow Calculation (4:33)
Introducing a discount factor – Weighted Average Cost of Capital (3:58)
Calculating a firm's cost of debt (0:55)
Calculating a firm’s cost of equity (4:41)
Estimating a company’s future cash flows (2:31)
The two stages of a DCF model (2:24)
Discounting cash flows and terminal value (1:44)
Calculating Enterprise and Equity value (1:10)

Financial Modeling fundamentals

What is a Financial model? (2:02)
Why use a Financial model? (2:34)
Inefficient financial modeling practices (5:49)
Efficient financial modeling practices (4:58)
Different types of financial models we can build (4:42)
The right level of detail we should use when building a 5 or 10-year model (2:34)
The right way to approach the forecasting exercise (2:51)
Building complete financial models (2:15)
Forecasting P&L items (5:58)
Forecasting Balance sheet items (1/2) (2:34)
Forecasting Balance sheet items (2/2) (5:07)

DCF Valuation - Introduction

DCF Valuation - Forecasting of key P&L items

Modeling the top line (3:39)
This Is how you can build flexible financial models in Excel (2:12)
Modeling other items: Other revenues and Cogs (3:46)
Modeling other items: Operating expenses and D&A (2:33)
Modeling Other Items: Interest expenses, Extraordinary items and Taxes (2:28)

DCF Valuation - Forecasting of key Balance Sheet items

How to forecast Balance Sheet items - The practical and easy to understand way (0:43)
A key concept for finance practitioners - the "Days" methodology (1:35)
Learn how to calculate "Days" (1:30)
How to use "Days" to project the future development of BS items (2:23)
Forecasting Property Plant & Equipment, Other assets and Other liabilities (2:27)

DCF Valuation - Creating clean output sheets

Excel best practices! Create a good-looking and clean output sheet in your model (2:36)
Applying what we learned in practice - Populating the P&L sheet (2:14)
This is how you can create a clean output Balance Sheet in your Financial Model (1:49)
Completing the output BS sheet for the historical period (3:41)

DCF Valuation - Calculating Unlevered Cash Flows and Net Cash Flow

Learn how to calculate Unlevered Free Cash Flows (3:05)
Important! Reconcile UFCF to Net Cash Flow (1:55)
A very useful lesson! Cash flow calculation (6:01)
Arriving to actual Net Cash Flow figures and performing a check with Cash (3:56)
The fast and effective way to modify multiple cell references in Excel (3:52)

DCF Valuation - Calculating Present Value of Cash Flows in the forecast period

Introducing Weighted Average Cost of Capital (WACC) and perpetuity growth rate (1:56)
Learn how to find the present value of future Cash Flows in Financial Models (2:50)

DCF Valuation - Calculating Continuing Value,Enterprise Value and Equity Value

DCF Valuation - Additional analyses accompanying the Financial Model

Relative valuation – triangulating DCF results with multiples

Why do we use multiples? (3:51)
What types of multiples are there? (2:37)
Finding the right comparable companies (1:43)
The most widely used multiples (3:28)
Best practices that ensure accurate calculation of multiples (2:02)

A guide to Leveraged Buyouts

What is an LBO? (2:05)
The phases of an LBO process (1:44)
When is an LBO a feasible option? (3:23)
Making money in an LBO (3:53)
Who are the lenders in an LBO? (3:58)

LBO Valuation - Building a Leveraged Buyout model from scratch

Introduction to the model we will build (5:04)
Establishing the maximum amount of debt that can be used in the transaction (4:16)
Financial sponsors’ perspective (2:27)
Forecasting financials until EBIT (5:17)
The optimal debt structure
Estimating cash flows and debt payments
Completing the model for the period 2018-2021 (4:17)
Calculating Enterprise Value and IRR (5:01)
Performing sensitivity analysis (4:02)

Lesson content locked

If you're already enrolled, you'll need to login.