Financial Modeling Fundamentals: Excel & Forecasting

Financial Modeling Fundamentals

Learn how to build dynamic financial models in Excel using real-world techniques. Master forecasting, three-statement integration, scenario analysis, and best practices to create structured, reliable models for business and financial decision-making.

Interested in this course? Email us at [email protected]

Course curriculum

1. Segment 00 - Reading : Welcome to the Course: Course Overview
2. Segment 01: Intro Video to Course
3. Segment 02: Module Introduction
4. Segment 03: Inputs, Calculations, Outputs: The Golden Rule
5. Segment 04: Layout, Labeling, and Color-Coding Standards
6. Segment 05: Navigating and Designing for User-Friendliness
1. Segment 06: Absolute vs. Relative References
2. Segment 07: Lookup Functions: INDEX/MATCH vs. VLOOKUP
3. Segment 08: Error-Checking with IFERROR and Conditional Logic
1. Segment 09: Creating an Assumptions Dashboard
2. Segment 10: Tracking Model Changes and Version Control
3. Segment 11: Sourcing Data and Referencing External Inputs
4. Segment 12 - Reading : Modeling in Excel and Its Importance
5. Segment 13 - Hands-on-Learning : Building a Clean, Structured Financial Model Template
6. Segment 14 - Quiz : Model Documentation and Auditability
1. Segment 15: Module Introduction
2. Segment 16: Top-Down vs. Bottom-Up Forecasting
3. Segment 17: Unit Economics and Pricing Strategies
4. Segment 18: Market Size, Growth Rates, and Penetration Scenarios
1. Segment 19: Fixed vs. Variable Costs
2. Segment 20: Operating Leverage and Break-Even Analysis
3. Segment 21: Driver-Based Cost Allocation
1. Segment 22: Maintenance vs. Growth Capex
2. Segment 23: Modeling Depreciation and Asset Schedules
3. Segment 24: Forecasting Working Capital (DSO, DPO, Inventory Turns)
4. Segment 25 - Reading : 7 Financial Forecasting Methods to Predict Business Performance
5. Segment 26 - Hands-On-Learning: Forecasting Revenues, Costs, and Working Capital Drivers
6. Segment 27 - Quiz : Operating Model Forecasting
1. Segment 28: Module Introduction
2. Segment 29: Connecting Income Statement and Balance Sheet
3. Segment 30: Automating the Cash Flow Statement
4. Segment 31: Handling Circular References and Iterative Calculations
1. Segment 32: Calculating Operating and Free Cash Flow
2. Segment 33: Building a Debt Schedule with Interest Expense
3. Segment 34: Modeling Equity Raises and Dilution
1. Segment 35: Setting Up Sensitivity Tables (Data Tables)
2. Segment 36: Scenario Planning and Toggle Controls
3. Segment 37: Validating and Stress-Testing Your Model
4. Segment 38 - Reading : Scenario Analysis: Definition, Process, and Benefits
5. Segment 39 - Hands-On-Learning: Integrating the Income Statement, Balance Sheet, and Cash Flow
6. Segment 41 - Project : Designing and Building a Dynamic Three-Statement Financial Model
7. Segment 42 - Quiz : Scenario and Sensitivity Analysis
8. Segment 43: Course Wrap-Up

About this course

Free
43 lessons
2.5 hours of video content

Discover your potential, starting today

Enroll today

Financial Modeling Fundamentals

Course curriculum

Module 1 : Model Structure and Layout

Module 2 : Formula Design and Dynamic Functions

Module 3 : Model Documentation and Auditability

Module 4 : Revenue Forecasting Techniques

Module 5 : Cost and SG&A Forecasting

Module 6 : Working Capital Forecasting

Module 7 : Linking the Three Financial Statements

Module 8 : Cash Flow Derivation and Validation Checks

Module 9: Scenario and Sensitivity Analysis

About this course

Discover your potential, starting today