Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Financial Modelling Course + Virtual Work Experience
Introduction
Introduction
Contact Us
Excel Mastery
Overview (8:14)
Using the keyboard (6:00)
Excel settings (5:09)
Basic excel shortcuts & navigations (10:38)
Basic formatting (5:57)
Referencing cells in worksheet (6:24)
Referencing cells in workbook (1:13)
Freezing & Splitting Pans (5:32)
Editing Cells (3:27)
Inserting Rows & Columns (7:51)
Paste Special (7:04)
Essential Control Shortcuts (2:05)
Cell Name (4:32)
Anchoring Cells (5:48)
Worksheet (0:43)
Grouping (4:37)
Auditing Cells (4:15)
Center Alignment (2:54)
Go To Special (1:45)
Essential Accounting
Income Statement (37:01)
Balance Sheet Asset Side (31:28)
03-Balance Sheet Liability & Shareholder Equity (45:20)
04-Cash flow Statement (40:38)
05-Linking The Three Financial Statement (30:39)
06-Practice Model Overview (10:49)
07-Walk-through of Fin-Statement (5:43)
08-Depreciation (6:40)
09-Inventory Change Cash vs Debt (8:56)
10-Inventory LIFO vs FIFO (15:42)
11-Accrued Expense (8:56)
12-Accrued Revenue (6:12)
13-Deferred Income Taxes (7:44)
14-Dividend
15-Issue Repurchase shares (11:32)
16-Raising & Paying off Debt (6:47)
17-Equity, Debt Bailout (9:32)
18-Goodwill Impairment (6:05)
19-Writing Down Debt (7:23)
20-iPhone Factories Debt Part-1 (5:59)
21-iPhone Factories Debt Part-2 (8:03)
22-iPhone Factories Debt Part-3 (10:56)
23-Making iPhones Part-1 (3:40)
24-Making iPhones Part-2 (6:48)
The three financial statements
02-01-Overview (9:17)
Apple Report
02-02-Income Statement Trends (15:19)
02-03-Income Statement Projections (15:47)
02-04-Balance Sheet Trends (12:40)
02-05-Balance Sheet Projections (12:37)
02-06-Cash Flow Projections (20:16)
02-07-Linking Statements (14:20)
02-08-Amortization (7:42)
02-09-Interest (13:00)
02-10-Deferred Taxes (17:04)
02-11-Fixing Balance Sheet Problems Part 1 (8:02)
02-12-Fixing Balance Sheet Problems Part 2 (10:32)
02-13-Fixing Balance Sheet Problems Part 3 (10:55)
02-14-Fixing Balance Sheet Problems Part 4 (12:44)
Model Worksheet Download (19:00)
Equity Value & Enterprise Value
03-01-Equity Market Capitalization (9:23)
03-02-Options Overview (6:25)
03-03-Treasury Stock Method (12:49)
03-04-TSM Exercise (5:07)
03-05-Convertible Bonds (12:12)
03-06-Enterprise Value vs Equity Value (8:37)
03-07-Calculating EV (11:24)
03-08-EV Advance (17:41)
03-09-Key Metrics (16:08)
03-10-Valuation Multiples (15:31)
03-11-EV vs Equity Value Multiples (12:15)
03-12-Interview Questions (14:52)
ABC MODEL
Valuation Comps
HPQ-CS
04-01-Valuation Overview (10:12)
04-02-Selecting Public Company Comps (7:15)
04-03-Public Comps Finding Data EV Calculations (14:41)
04-04-Public Comps Finding Data Income Statement Calculations (12:25)
04-05-Public Comps Operating Data (17:16)
04-06-Public Comps Valuation Multiples (11:22)
04-07-Largest Technology Deals (9:17)
04-08-Transaction Comps Multiples (12:37)
Financial Modelling (DCF)
05-01-Overview Assumptions (6:37)
05-02-Projecting Cash Flows (12:54)
05-03-Discounting Cash Flows (6:35)
05-04-Mid Year Discount (5:12)
05-05-Terminal Value Multiples (6:54)
05-06-Terminal Value Gordon Growth (9:07)
05-07-Share Price Sensitivity Tables (14:48)
05-08-Walk Through DCF (3:28)
05-09-Interview Questions (11:27)
05-10-WACC Overview Assumptions (12:45)
05-11-Unlevered Beta (17:53)
05-12-Calculating Our Beta (6:28)
05-13-Cost of Equity WACC (7:27)
05-14-Interview Questions (15:15)
Interview Questions Work Sheet Download
Interpreting Results
06-01-Linking Methodologies (23:21)
06-02-Football Field (8:21)
06-03-Interview-Questions (14:28)
Mergers & Acquisition
07-01-Overview (11:55)
07-02-Transaction Assumptions (13:03)
07-03-Buyer & Seller IS (12:42)
07-04-Combining IS (12:38)
07-05-Accretion & Dilution (6:23)
07-06-Revenue Synergy (14:02)
07-07-Expense Synergy (11:01)
07-08-Good Will (16:05)
07-09-Calculating Goodwill - Intangibles & DTL (23:28)
07-10-Adjusting the BS (9:08)
07-11-Adjusting the IS (10:45)
07-12-Sensitivity Tables (16:10)
07-13-Model Walkthrough (4:37)
07-14-Interview Questions (22:08)
Introductory LBO modelling
Overview (0:42)
Introduction to LBOs (10:10)
Working through Dell LBO part 1 (6:40)
Working through Dell LBO part 2 (6:14)
LBO Candidates (6:01)
Economics of LBOs (14:39)
Equity Capital Structure (4:33)
Debt Capital Structure (5:10)
Term Loans (2:05)
Term Loans Part 2 (4:36)
Bonds (4:25)
Covenant & Mezz Financing Part 1 (3:16)
Covenant & Mezz Financing Part 2 (4:30)
Virtual Work Experience Program
01-JAZZ Pharma Case Study (14:42)
02-Biotech Pharma Business Model (16:17)
03-Xyrem Revenue Projections model (31:12)
04-Erwinaze & Defitelio Revenue Projections (33:46)
05-Pipeline Drugs & Other Revenue (24:18)
06-Expense IS-BS-CFS Assumptions (45:58)
07-Linking-Statements (36:24)
08-Selecting Public Comps (22:01)
09-Market Data Figures for Public Comps (54:18)
10-Historical Matrices & Multiples (32:55)
11-Forward Metrics & Multiples (13:13)
12-Public Comps Interpretation (20:12)
13-Selecting Precedent Transactions (11:22)
14-Precedent Transactions Calculations (4:00)
15-Precedent Transactions Interpretation (13:39)
16-DCF Analysis (12:51)
17-Setting Up The DCF (20:27)
18-Mid Year Discount Period (9:12)
19-Terminal Value Calculations (25:30)
20-Weighted Average Cost of capital Calculations (WACC) - Cost of Debt (10:07)
21-WACC - Cost of Equity Calculations (19:52)
22-Finishing WACC (10:42)
23-Share Price Sensitivity Analysis (24:55)
24-Football Field Set Up (14:50)
25-Valuation & Interpretation (20:59)
26-Pitch-Book & BOD Presentation (48:24)
05-Linking The Three Financial Statement
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock