Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Valuation and Finance Course
1. Introduction and Course Overview
Course Introduction (0:50)
Course Material Download
Support FAQ
2. Excel
Introduction to Excel (0:24)
Excel Quick Access Toolbar (3:10)
Excel Formatting Rules (5:47)
Excel Custom Formatting (4:57)
Anchoring (12:45)
Index / Match (9:31)
Index / Match Example (14:56)
3. Accounting Principles and Liquidity Forecast
Introduction to Accounting Principles and Liquidity Forecast (0:34)
Income Statement (9:46)
Non-Cash Expenses (3:01)
EBITDA (2:29)
Cash Flow Statement (6:09)
Cash Flow Statement Detail (7:33)
Free Cash Flow (3:00)
Balance Sheet (5:39)
Balance Sheet Flowchart (2:30)
Balance Sheet (Assets) (4:36)
Balance Sheet (Liabilities) (4:06)
Balance Sheet (Equity) (1:48)
Net Working Capital (6:24)
Troubleshooting a Balance Sheet (7:17)
Basis Points (4:16)
Compound Annual Growth Rate (CAGR) (5:04)
4. Financial Modeling Tests
Introduction to Financial Modeling Tests (0:42)
Financial Model Level 1 (12:00)
Financial Model Level 2 (17:28)
Financial Model Level 3 (14:15)
Financial Model Level 4 (16:31)
Financial Model Level 5 (14:46)
5. Discounted Cash Flow Valuation Analysis
Introduction to Discounted Cash Flow Valuation Analysis (0:28)
Valuation (5:55)
Asset Risk (1:55)
Time Value of Money / Discount Rate (7:45)
The Discounted Cash Flow Analysis (4:00)
Terminal Value (9:44)
DCF Example #2 (3:32)
DCF Example #3 (7:01)
Weighted Average Cost of Capital (3:55)
WACC Example #1 (2:53)
Equity and Debt as Capital Sources (6:53)
WACC Example #2 (5:49)
Capital Asset Pricing Model (4:58)
Beta (4:55)
WACC Inputs (3:49)
Tax Shield (4:45)
WACC Example #3 (4:17)
Enterprise Value (Part 1) (9:16)
Enterprise Value (Part 2) (7:10)
Treasury Stock Method (6:53)
Data Table (8:03)
Data Table Tips (3:45)
DCF Example #4 (4:38)
DCF Example #5 (11:34)
6. Comparable Companies Valuation Analysis
Introduction to Comparable Companies Valuation Analysis (0:25)
What is a Valuation Multiple? (6:58)
Apples to Apples (3:14)
Enterprise Value vs. Equity Value Multiples (2:46)
Determining Comparable Companies (8:52)
Standardizing Comps Data (2:47)
Valuation Metrics (6:54)
Comps Example #1 (Facebook / Meta) (24:51)
Benchmarking Financial Information (2:35)
How to Imply the Valuation of a Company (6:54)
Next Twelve Months vs. Last Twelve Months (1:57)
What Drives Multiples? (2:03)
Comps Example #2 (Private Company) (10:31)
Pros and Cons of Comps Analysis (2:59)
Exponential Relationships in Multiples (1:54)
7. The Stock Pitch Presentation
Introduction to the Stock Pitch Presentation (0:28)
PowerPoint Basics (8:33)
What's in a Good Company? (5:32)
Value vs. Growth Investing Philosophies (2:28)
Where to get Stock Pitch Ideas (3:24)
How to Screen for Stocks (5:04)
Stock Screen Example (Part 1) (4:02)
Stock Screen Example (Part 2) (14:37)
Selecting a Stock (7:16)
Public Information Book (PIB) (6:09)
Executive Summary and Company Overview (7:13)
Business Model (7:45)
Industry Analysis (4:18)
Creating Graphs for a Stock Pitch (18:34)
Overview of Financial Forecast and Model (5:40)
Spreading a Company's Financials (15:25)
Forecasting a Company's Financials (6:40)
Bookings and Revenue Build (5:50)
Updating a Company's Financials (10:39)
Analyzing Cost Structure (3:23)
Tax Analysis (4:30)
Stock Pitch DCF Analysis (7:00)
Analysis at Various Prices (5:45)
Stock Pitch Comps Analysis (4:38)
Football Field Analysis (11:25)
Risks and Catalysts (7:05)
8. Course Conclusion
Course Conclusion (0:21)
Valuation and Finance Certificate (1:38)
Refer a Friend to Get My PE and IB Resumes
Referral Instructions
Give Peak Frameworks a Shout Out
Shout Out and Valuation Course Survey
Excel Custom Formatting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock