Fundamentals of
Financial Modeling
Dr. Al Kamienski, MBA, PhD
Professor of Finance, North Park University, Chicago
A free 17-video series teaching you how to build a complete financial model from scratch. Learn to construct assumptions, build financial statements, create dashboards, and analyze business scenarios using a real case study.
Start Learning
17 Video Lessons
Structured across 4 modules, from foundations through dashboard analysis. Each video builds on the last.
Real Case Study
Build a financial model for Brilliant Beginnings LLC. Download the Excel template and follow along step by step.
Searchable Transcripts
Every video has a full transcript with timestamps. Search across all videos to find exactly what you need.
Course Structure
Foundations
Videos 1-3
Introduction, setup, and case study overview
Building Assumptions
Videos 4-7
Developing the key drivers of your financial model
Financial Statements
Videos 8-11
Income statement, balance sheet, and cash flows
Dashboard & Analysis
Videos 12-17
Building dashboards, walkthrough, and conclusions