Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling for Startups & Small Businesses
Introduction
Course overview (6:06)
Jumpstart
Modeling a lemonade stand (5:58)
Jumpstart Part 1: Unit economics (1) (8:41)
Jumpstart Part 1: Unit economics (2) (4:55)
Jumpstart Part 2: Calculating the labor cost & selling price (5:38)
Jumpstart Part 3: Single product, single location (22:55)
Jumpstart Part 4: Strawberry premium (15:28)
Jumpstart Part 5: Multiple Locations (20:53)
Jumpstart: Summary (2:59)
Q&A: Section 2 (19:41)
Before you build your model
What questions are you trying to answer? (3:01)
Map it out & Caveat on modeling (3:30)
Q&A: Section 3 (16:26)
Modeling best practices
Always start with the end in mind (6:13)
Clear over clever (4:53)
Always do sanity checks (5:53)
Start small & simple (2:10)
Define constraints (1:21)
Utilize Google! (1:38)
Q&A: Section 4 (26:10)
Case study: YouWorks Co-Working Space (part 1)
Introduction to YouWorks, our first case study - Sanity check (13:20)
YouWorks - Modeling revenue (12:49)
Modeling growth
User segmentation and the difference between users & customers (7:07)
User segmentation: YouWorks example (7:46)
Usage segmentation (12:16)
Think in terms of funnels (7:31)
Follow up on funnels (4:51)
Modeling growth rate (4:58)
Modeling attrition (17:17)
Modeling revenue
Free, but ad-based (22:27)
Affiliate model (11:54)
Freemium model (12:24)
Subscription model (6:59)
Pay per use (12:56)
Free product, pay for service (8:39)
Tiered pricing (6:26)
Base plus features pricing (9:06)
Modeling startup costs & expenses
Startup costs & operating expenses (6:51)
Headcount & labor (12:30)
Modeling rent & office needs (9:52)
Modeling hosting expenses (12:32)
Adding contingency (5:12)
Putting it all together (2:29)
Case study #1: Standard Assembly programming bootcamp
Standard Assembly - Overview (3:21)
Standard Assembly - Model overview & Startup costs (7:05)
Standard Assembly - Modeling revenue (8:06)
Standard Assembly - Modeling expenses (7:07)
Standard Assembly - Summary (3:18)
Case Study #2: YouWorks Co-Working Space (part 2)
Getting re-acquainted with YouWorks (2:06)
YouWorks - Startup costs (4:40)
You Works - Modeling revenue (2:53)
YouWorks - Modeling expenses (3:49)
YouWorks - Summary (4:55)
Case Study #3: Fancy Bread, mobile app for renting offices
Fancy Bread - Overview (2:36)
Fancy Bread - Model overview & Startup costs (4:08)
Fancy Bread - Modeling revenue (12:50)
Fancy Bread - Modeling expenses (9:39)
Fancy Bread - Summary (3:43)
Case Study #4: ScholarPRO & its inevitable doom
ScholarPRO - Introduction (10:09)
ScholarPRO - Assumptions & data part 1 (18:49)
ScholarPRO - Assumptions & data part 2 (19:38)
ScholarPRO - Income statement & expenses (21:55)
ScholarPRO - Graphs, simple revenue, & scenarios (7:47)
Case study #5: Tee Lounge, a brick and mortar business
Tee Lounge - Overview (3:19)
Tee Lounge - Model overview & Startup costs (12:43)
Tee Lounge - Modeling revenue (6:25)
Tee Lounge - Modeling expenses (5:54)
Tee Lounge - Summary (4:48)
Case Study #6: SaaSForce SaaS Startup
SaasForce - Overview (3:50)
SaaSForce - Model overview & Single salesperson economics (18:17)
SaaSForce - Modeling revenue (8:16)
SaaSForce - Modeling expenses (7:14)
SaaSForce - Summary (3:29)
Case Study #7: "Smoked Chili" Fast Casual Mexican Restaurant
Smoked Chili - Overview (2:26)
Smoked Chili - Model overview & Menu economics (18:42)
Smoked Chili - Modeling revenue (8:57)
Smoked Chili - Modeling expenses (11:46)
Smoked Chili - Summary (3:32)
ScholarPRO - Assumptions & data part 2
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock