Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling for Entrepreneurs 401: Build Your Own Financial Model
Chapter 1 - Course Introduction and Overview
Welcome to Financial Modeling for Entrepreneurs 401: Build Your Own Financial Model (7:11)
Chapter 2 - Steps in Building a Financial Model
2a. Key Principles, Accuracy vs Complexity (6:52)
2b. The 10 Steps in Building a Financial Model Spreadsheet (5:34)
Reference Sheet: 10 Steps in Building a Financial Model Spreadsheet
Quiz on Steps in Building a Financial Model
Answers to Quiz on Steps in Building a Financial Model
Chapter 3 - Market Research and Data Collection
3a. The Target Market (11:28)
Reference Sheet: Market & Industry Analysis Tools
3b. Online Search Basics (6:22)
Reference Guide: Online Search Basics
3c. Where to Find Market Information (15:30)
Reference Guide: Data Sources
3d. How to Estimate Market Size (10:08)
Reference Guide: How to Estimate Total Addressable Market (TAM)
3e. How to Do Sales Projections I - Price (8:53)
3f. How to Do Sales Projections II - Volume (10:19)
Reference Sheet: Sales Projections Methodologies
3g. How to Estimate COGS, Capital and Other Expenses I (11:06)
Checklist: Expenses
3h. How to Estimate COGS, Capital and Other Expenses II (11:38)
Reference Guide: Cost Estimation Methodologies
Quiz on Market Research and Data Collection
Answers to Quiz on Market Research and Data Collection
Chapter 4 - Build Your Own Financial Model
4a. Financial Models at 3 Levels of Detail (4:35)
Reference Guide: 3 Levels of Financial Model Detail
4b. Build Your Own Fin Model 1 - Order of Magnitude (33:44)
Example Spreadsheet: Order of Magnitude Financial Model
4c. Build Your Own Fin Model 2 - Basic Financial Model (59:07)
Example Spreadsheet: Basic 5-Year Financial Model
Spreadsheet Template: Full Financial Model
4d. Build Your Own Fin Model 3 - Full Financial Model (43:46)
Example Spreadsheet: Full Financial Model
Course Evaluation Questionnaire
Reference Sheet: 10 Steps in Building a Financial Model Spreadsheet
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock