Financial Modelling & Valuation
The Complete Excel Financial Modelling Course
Welcome to the most comprehensive Financial Modelling program available online. Where we'll go through everything you'll need step-by-step and follow along via excel work sheets. Embark on a virtual work experience program and experience the day-to-day of an Investment Banking Analyst and Associate
Your Instructor
The team of 13 Investment Bankers from elite bulge bracket bank to specialist Mergers and Acquisition Boutique bank. A combine deal experience spanning well above $3bn+ within technology, Financial, Consumer Brand, Healthcare and commercial real estate.
Course Curriculum
The three financial statements
Available in
days
days
after you enroll
-
Start02-01-Overview (9:17)
-
StartApple Report
-
Start02-02-Income Statement Trends (15:19)
-
Start02-03-Income Statement Projections (15:47)
-
Start02-04-Balance Sheet Trends (12:40)
-
Start02-05-Balance Sheet Projections (12:37)
-
Start02-06-Cash Flow Projections (20:16)
-
Start02-07-Linking Statements (14:20)
-
Start02-08-Amortization (7:42)
-
Start02-09-Interest (13:00)
-
Start02-10-Deferred Taxes (17:04)
-
Start02-11-Fixing Balance Sheet Problems Part 1 (8:02)
-
Start02-12-Fixing Balance Sheet Problems Part 2 (10:32)
-
Start02-13-Fixing Balance Sheet Problems Part 3 (10:55)
-
Start02-14-Fixing Balance Sheet Problems Part 4 (12:44)
-
StartModel Worksheet Download (19:00)
Equity Value & Enterprise Value
Available in
days
days
after you enroll
-
Start03-01-Equity Market Capitalization (9:23)
-
Start03-02-Options Overview (6:25)
-
Start03-03-Treasury Stock Method (12:49)
-
Start03-04-TSM Exercise (5:07)
-
Start03-05-Convertible Bonds (12:12)
-
Start03-06-Enterprise Value vs Equity Value (8:37)
-
Start03-07-Calculating EV (11:24)
-
Start03-08-EV Advance (17:41)
-
Start03-09-Key Metrics (16:08)
-
Start03-10-Valuation Multiples (15:31)
-
Start03-11-EV vs Equity Value Multiples (12:15)
-
Start03-12-Interview Questions (14:52)
-
StartABC MODEL
Valuation Comps
Available in
days
days
after you enroll
-
StartHPQ-CS
-
Start04-01-Valuation Overview (10:12)
-
Start04-02-Selecting Public Company Comps (7:15)
-
Start04-03-Public Comps Finding Data EV Calculations (14:41)
-
Start04-04-Public Comps Finding Data Income Statement Calculations (12:25)
-
Start04-05-Public Comps Operating Data (17:16)
-
Start04-06-Public Comps Valuation Multiples (11:22)
-
Start04-07-Largest Technology Deals (9:17)
-
Start04-08-Transaction Comps Multiples (12:37)