LEARN FINANCIAL MODELLING IN EXCEL
3 Statements: Income Statement, Cash Flow and Balance Sheet | DCF Model | LBO Model

GET AN ADVANTAGE OVER OTHER CANDIDATES AND PREPARE FOR YOUR INTERVIEW!

3 Statements Financial Modelling

Income Statement: revenue build-up and variable costs, fixed costs, EBITDA, interest, taxes and net income

Cash Flow Statement: operating cash flow, investing cash flow and financing cash flow

Balance Sheet: cash, net working capital, PP&E, financial debt and equity

DCF Financial Modelling

Cash Flow Projections: from EBIT to unlevered Free Cash Flow

Beta Calculation: comparable companies analysis, Hamada formula

CAPM & WACC: return on equity based on the capital asset pricing model, interest, tax shield

Enterprise Value: terminal value computation (perpetual growth rate, discounted cash flows)

LBO Financial Modelling

Assumptions: input for revenue, costs, leverage, interests etc.

Sources and Uses: funding amount, fees, acquisition value

Income Statement: operating model for LBO structure

Cash Flow Statement: operating cash flow, investing cash flow and debt repayment

Debt Schedule: leverage structure, debt repayment and interests

Return Analysis: IRR and MoM computation

24 videos with excel walk through (3h course),
content tailor made for you by Investment Bankers
Special price of €49 - limited time only!

We have a 100% customer satisfaction guarantee

If you are unhappy with the course for whatever reason you can request a 100% refund within 7 days