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