The importance of history name tradition and reputation
The rise of investment banking services
What is the difference between commercial and investment banking?
Why do universal banks have a competitive advantage?
Intrinsic conflicts of interest and the role of Chinese walls
Three of the most important IPOs in history
Capital markets – raising equity and debt capital
Advisory – M&A and Restructuring services
Trading and Brokerage – trading with financial securities
Asset management – the ability to use money to make more money
Why would a company want to go public?
Who are the investors in an IPO?
Coming up with a share price
Technical details of IPO pricing
What does an IPO timetable look like?
The IPO syndicate – members and responsibilities
Fee distribution among investment banks
Post-IPO stabilization: Definition of long/short position
Post-IPO stabilization: Applying the Greenshoe option
Greenshoe explained – Practical example
Other ways to place equity capital – SEOs and private placements
Facebook's IPO - Case study
Course Challenge #1 - IPO
The four different types of bonds
The mechanics of a bond offering. Process description
What is securitization and why can it be useful?
Securitization - explained
Asset-backed securities: An example of securitization
Loan syndication – a preferred instrument for most banks nowadays
Course challenge #2 - Debt offerings
Why acquire another company?
Describing the typical deal lifecycles and buyer companies
The three types of M&A processes
Valuation of target companies
Payment options in M&A deals
Financial vs. Corporate buyers
Course challenge #3 - M&A
How much is a company worth for an investor?
The two variables that drive a firm’s value
The mechanism of Unlevered cash flow calculation
Introducing a discount factor – Weighted average cost of capital
Calculating a firm's cost of debt
Calculating a firm’s cost of equity
How to find the beta for an unlisted firm?
Estimating a company’s future cash flows
The two stages of a DCF model
Discounting cash flows and terminal value
Calculating enterprise and equity value
What is a financial model?
Why use a financial model?
Inefficient financial modeling practices
Efficient financial modeling practices
Different types of financial models we can build
The right level of detail we should use when building a 5 or 10-year model
The right way to approach the forecasting exercise
Building complete financial models
Forecasting Balance sheet items (1/2)
Forecasting Balance sheet items (2/2)
Building flexible financial models in Excel
Modeling other items: Other revenues and Cogs
Modeling other items: Operating expenses and D&A
Modeling Other Items: Interest expenses Extraordinary items and Taxes
How to forecast Balance Sheet items - the clear and practical way
A key concept for finance practitioners - the "Days" methodology
How to use "Days" to project the future development of BS items
Forecasting Property plant & equipment Other assets and Other liabilities
Excel best practices! Create a good-looking and clean output sheet in your model
Putting what we learned into practice - Populating the P&L sheet
How to create a clean output Balance Sheet in your Financial Model
Completing the output BS sheet for the historical period
Learn how to calculate Unlevered free cash flows
Important! Reconcile UFCF to Net cash flow
A very useful lesson! Cash flow calculation
Arriving to actual Net cash flow figures and performing a check with cash
A fast and effective way to modify multiple cell references in Excel
Organizing external inputs in a 'Drivers' sheet
The input data we will work with
Forecasting Tesla's expected deliveries
Comparing delivery figures with the ones of industry peers
Estimating an average selling price of Tesla vehicles
Calculating automotive revenue
Peer comparison: Gross profit %
Calculating automotive gross profit
Calculating automotive cost of sales
Forecasting 'energy' and 'services' revenue
Calculating 'energy' and 'services' gross profit and cost of sales
Forecasting operating expenses
Building a fixed asset roll forward: estimating Capex
Building a fixed asset roll forward: D&A schedule
Peer comparison: D&A as a percentage of revenues
Producing a clean P&L output sheet
Fill in the P&L output sheet
Calculating investments in working capital
Forecasting Unlevered free cash flow
Forecasting other liabilities
Completing Unlevered free cash flow
Modeling Tesla's financing needs in the forecast period
Bridging Unlevered Free cash flow to Net cash flow
Balancing the Balance sheet
Estimating Weighted average cost of capital (WACC)
Performing Discounted cash flow valuation (DCF)
Calculating enterprise value equity value and price per share
What are valuation multiples and why we use them?
What types of valuation multiples are there?
Trading vs transaction valuation multiples
Main principles of multiples valuation
Comparison of earnings multiples (P/E vs EV/EBITDA)
Introduction to the exercise
High-level assessment of peer companies
Assessment of P&L data - comparable companies
How to adjust EBIT - theoretical framework
How to adjust EV - theoretical framework
How to adjust EBIT - practical example - Volkswagen
How to adjust EV - practical example - Volkswagen
Conclusion of the practical exercise
Introduction to the model we will build
Establishing the maximum amount of debt that can be used in the transaction
Financial sponsors’ perspective
Forecasting financials until EBIT
The optimal debt structure
Estimating cash flows and debt payments
Completing the model for the period 2018-2021
Calculating Enterprise value and IRR
Performing sensitivity analysis
Introduction to LBO Modeling exercise
Key drivers in the LBO model
Constructing the Profit and Loss header
Analyzing historical Profit and Loss figures
Valuing the Target company
Estimating transaction fees
Sources and uses of funds
Shaping the Balance sheet at transaction
Integrating assumptions into the Drivers sheet
Building a Fixed asset roll forward schedule
Forecasting financials using the Drivers sheet
Completing the Profit and Loss statement (up to EBITDA)
Filling in the Balance sheet at transaction sheet
Add financials to the Balance sheet
Projecting Fixed asset roll forward
Developing a Debt schedule
Creating a Fixed asset amortization schedule
Designing the Financing sheet
Building an Equity schedule
Finalizing the Financing Cash Flow
Modeling the Revolver facility (first part)
Completing the Profit and Loss statement
Modeling the Revolver facility (second part)
Balancing the Balance sheet
Exit valuation and IRR comparison