Financial Modeling for Startups & Small Businesses
4.3 (238 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,126 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Modeling for Startups & Small Businesses to your Wishlist.

Add to Wishlist

Financial Modeling for Startups & Small Businesses

Learn the best practices for building practical financial models for your startup or business.
4.3 (238 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,126 students enrolled
Last updated 8/2017
English
English [Auto-generated]
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11.5 hours on-demand video
  • 1 Article
  • 75 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build financial models for their startup businesses
  • Model user growth
  • Model revenue
  • Model expenses
  • Model attrition
  • Model various different business models, from tech to brick & mortar
  • Use best practices for financial modeling
View Curriculum
Requirements
  • Have access to Microsoft Excel 2011 or Newer
Description

Reasons why you should create a financial model for your startup or small business.  A good financial model can help you:

  1. Test your assumptions and verify key drivers of your business
  2. Compare and contrast different business choices, like pricing models
  3. Calculate the ACTUAL amount of capital you need to startup
  4. Calculate your burn rate
  5. Model out your user growth 
  6. Model out your expenses
  7. Be more prepared talking to potential investors
  8. And loads more.

Building a financial model isn't just a vanity exercise. When done right, it could help you better understand your business, whether it's a startup or an existing business you're growing.

But it's not easy and there is a right way and a wrong way to go about it.

Even if you have little to no finance background, if you're going to be starting or running a business, this is a skill you need to have.

But financial modeling requires the right tools and the right approach.

We're going to show you how to do that with a wide variety of examples and exercises.  But we'll also be teaching general best practices that will help you, no matter what you'll be building your financial models for in the future.

Why learn from us?

By signing up with us, you will be learning from two highly rated instructors that have a combined student count of over 120,000 students and 8,000 review! 

Check out our profiles and see that we take care of your students and deliver the goods.

Evan has extensive startup experience and previously worked as a venture capitalist, where he evaluated 100's of startups that trying to convince him to invest in them.

Symon also has startup experience in both tech and brick & mortar businesses. Previously he built tons of models while working in mergers and acquisitions as well as in private equity.  And he's helped dozens of startups build financial models across a dozen different business models and industries.  

Together, we pull directly from our experience and put it in this course--in fact, two of the case studies use the ACTUAL financial models used to raise funding.  The other case studies are inspired by well known startups you're sure to recognize.

How is this different from Symon's Intro to Financial Modeling Course?

The Intro to Financial Modeling course taught by Symon He and Brandon Young is an introductory course on financial modeling that presents a general overview covering the topic and is more relevant to those who wish to explore finance as a career option or those who want to understand financial modeling in a corporate context.

This course is all about financial modeling for startup businesses so it's more geared towards entrepreneurs or small business owners who want to better understand the key drivers of a new or growing business.

There is almost zero overlap.  Even though both courses introduce a lemonade stand as an example, those examples and models are quite different as they serve very different purposes.  

What if I don't have any finance or Excel background?

No worries! This course isn't an Excel or Finance course, although you will learn a bit of both.  We focus more on the rationale and the logic of modeling specifically for startups or growing businesses, so you can take what you learn to other spreadsheet tools.  

But it will take practice.  You won't get better just watching the videos.  That's why have lots of practice exercises and sample models for you to learn from.

What will I be able to do after I take your course?

After taking our course, you will be:

  • Able to confidently build financial models for your startup or new business from scratch
  • Able to apply the best financial modeling practices and techniques
  • Able to read and understand other financial models by looking at lots of practice models and case studies
  • Able to leverage financial modeling to help you make smarter choices about your business.
  • Able to learn a new skill set that you can take with you for any and every business venture you take up in the future.

Why lemonade stand example?

Because learning how to model on its own is tough enough but learning it while also having to learn a new business model makes it even harder. 

But, even with a simple business model such as a lemonade stand, you'll be surprised by how complex and sophisticated the analysis could become. 

And since this is all about modeling for startups and new businesses, this example is different from the one in the Intro to Financial Modeling course.  

Tell me again why I should take your course?

You have absolutely ZERO risk.

Udemy gives you a solid as an oak tree 30-day money back guarantee.  

So if you've read this far, we welcome you to join us inside.

Who is the target audience?
  • Someone who wants to start a new business
  • Someone who wants to understand how to create a financial model for a startup business
  • Someone who wants to leverage financial modeling to make better business decisions
  • Someone who wants to better analyze business opportunities
  • Someone interested in doing a startup and plan on raising VC funding
  • Someone interested in starting a brick & mortar business
Students Who Viewed This Course Also Viewed
Curriculum For This Course
79 Lectures
11:30:01
+
Introduction
2 Lectures 03:22

$23,123 in free stuff + access to our Slack group
00:08
+
Jumpstart
9 Lectures 01:47:30

Before we dive into the example, we want to just briefly explain why we chose to do a lemonade stand and what you'll be able to learn from it.

Preview 06:20

Every cup of lemonade you make costs you money to make. We'll break it down into it's separate components here before we look at the larger business. Part 1 of 2

Preview 08:41

Every cup of lemonade you make costs you money to make. We'll break it down into it's separate components here before we look at the larger business. Part 2 of 2

Jumpstart Part 1: Unit economics (2)
04:55

When we model, we don't just start modeling aimlessly.  We model to solve a question.  In this example, we'll look at how we could easily determine a proper selling price as well as our labor costs.

Jumpstart Part 2: Calculating the labor cost & selling price
05:38

Jumpstart Part 3: Single product, single location
22:55

You did well and now your customers are asking you for a strawberry lemonade.  You think you could make even more money by adding that option so let's see how we could adjust our model to account for a premium add-on.

Jumpstart Part 4: Strawberry premium
15:28

Jumpstart Part 5: Multiple Locations
20:53

Whew! Bet you didn't think you could learn so much just from a lemonade stand business did you?  

Jumpstart: Summary
02:59

Q&A: Section 2
19:41
+
Before you build your model
3 Lectures 22:57

Among the most important things to do BEFORE you start building your model is to first decide what question(s) you're trying to answer.  

What questions are you trying to answer?
03:01

A few more thoughts before we get into the best practices for building financial models.  Always create a road map for yourself. 

Map it out & Caveat on modeling
03:30

Q&A: Section 3
16:26
+
Modeling best practices
7 Lectures 48:19

Always have a goal in mind of what you'd like your financial model to be able to do for you BEFORE you start building it.  Have an end in mind.

Always start with the end in mind
06:13

Why taking more steps in building out your model to make things clear is better than being clever with your financial models. 

Clear over clever
04:53

As they say, "garbage in garbage out".  It's the same when it comes to building financial models.  To make sure you don't look silly in front of investors or business partners, make sure to do sanity checks on your models.

Always do sanity checks
05:53

Building financial models is a lot like building with legos--you do it one piece at a time.  Trying to do too much too early or at the same time will not only make it much harder to build your financial model, but it'll introduce more errors.

Start small & simple
02:10

Define Constraints
01:21

Utilize Google!
01:38

Quiz to review the best practices we covered.

Modeling best practices quiz
3 questions

Q&A: Section 4
26:11
+
Case study: YouWorks Co-Working Space (part 1)
2 Lectures 26:32

Enough with all the talk, let's get back to building financial models.  In this lecture, we'll do a sanity check for a co-working business called "YouWorks".

Introduction to YouWorks, our first case study - Sanity check
13:42

Alright, now that we have a good idea of what we want to build out, let's see how we can build out the revenue model for our YouWorks business.

YouWorks - Modeling revenue
12:50
+
Modeling growth
7 Lectures 01:01:47
User segmentation and the difference between users & customers
07:07

But there are many ways to segment users or customers.  We revisit our YouWorks example and explore several possibilities for segmenting our users. 

User segmentation: YouWorks example
07:46

For some business models that either has pricing that depends on their customer's usage or has costs associated to their customer's usage, it is important to be able to segment the customers based on their usage profiles.  We look at an example and a demonstration of how to do that here.

Usage segmentation
12:16

If you're having trouble conceptualizing how your revenue model would work in your financial model, one way that helps is to visualize a funnel that users of customers have to go through through in order go from initial contact all the way to sales.  

Think in terms of funnels
07:31

Some more thoughts on funnels. 

Follow up on funnels
04:51

There's a common way and a better way to model growth.  We'll explore both in this lecture. 

Modeling growth rate
04:59

As much as you fantasize about it, your business won't retain 100% of its customers.  It will lose some customers due to attrition (or churn in the SaaS world).  In this lecture, we look at various ways to model this out. 

Modeling attrition
17:17

Quiz to review the main take ways when it comes to modeling user growth

Modeling growth quiz
4 questions
+
Modeling revenue
8 Lectures 01:30:53
Free, but ad-based
22:27

In this lecture, we'll explore the Affiliate Business Model and build out a model that you can use to build on top off if you're exploring a similar business model. 

Affiliate model
11:54

In this lecture, we'll explore the Freemium Business Model and build out a model that you can use to build on top off if you're exploring a similar business model. 

Freemium model
12:25

Subscription model
06:59

Pay per use
12:57

Free product, pay for service
08:39

Tiered pricing
06:26

Base plus features pricing
09:06
+
Modeling startup costs & expenses
6 Lectures 49:48

We've looked at enough revenue examples, now let's dive into the other side.  Not being able to accurately access your startup costs and expenses is a lot more costly than if you're off on the revenue side.  Running out of cash is the number 1 way for a business to fail.  So let's dive in on how we can better understand startup costs and expenses. 

Startup costs & operating expenses
06:51

Regardless of what your business does, you probably need people to do things.  In this lecture, we'll go over an example and show you some techniques for modeling out both headcount and labor related expenses. 

Headcount & labor
12:30

Chances are you'll have other overhead expenses for your business like rent and other office related expenses.  Some might depend on your headcount and others might just have it's own schedule for growth.  We look at how to handle both in your financial model here.

Modeling rent & office needs
09:52

In this lecture, we'll look at expenses that tend to vary depending on the number of customers or users you have and how you can factor that into your financial model. 

Modeling hosting expenses
12:54

No matter how much you plan, there will always be some unexpected bumps along the way.  That is why you should always build in some contingency (or margin for error) in your financial models.  Let's see how we can easily do that.

Adding contingency
05:12

Modeling startup costs & expenses quiz
3 questions

Putting it all together
02:29
+
Case study #1: Standard Assembly programming bootcamp
5 Lectures 28:57
Standard Assembly - Overview
03:21

Standard Assembly - Model overview & Startup costs
07:05

Standard Assembly - Modeling Revenue
08:06

Standard Assembly - Modeling expenses
07:07

Standard Assembly - Summary
03:18
+
Case Study #2: YouWorks Co-Working Space (part 2)
5 Lectures 18:25
Getting re-acquainted with YouWorks
02:06

YouWorks - Startup Costs
04:40

You Works - Modeling Revenue
02:54

YouWorks - Modeling Expenses
03:49

YouWorks - Summary
04:56
5 More Sections
About the Instructor
Evan Kimbrell
4.5 Average rating
10,980 Reviews
140,583 Students
16 Courses
Founder of Sprintkick | Ex-VC | Ex-startup founder

Hi, I'm Evan Kimbrell. Thanks for checking out my course.

Currently, I'm the Founder and Director of Sprintkick, a full-service, referral-based digital agency based out of San Francisco. Over the past four years I've overseen the development and launch of over 100 web and mobile apps. Clients range from two-man bootstrapping startups to multibillion dollar Fortune 100s like Wal-Mart, Dick's Sporting Goods, and GNC.

Prior to Sprintkick I worked as a VC for a new firm called Juvo Capital, based out of L.A. I spearheaded the firm's expansion into Silicon Valley and into the Consumer Web tech category.

In the long long ago, I was a co-founder for an educational software startup called ScholarPRO that raised a ton of money and then spectacularly blew up (in the bad way). Before it exploded like the Death Star, I went through five tech incubators (yes, five): Tech Stars, Excelerate Labs, MassChallenge, Babson Venture Program, and Sparkseed.

I'm an avid Airbnb host for the Fisherman's Wharf district of San Francisco. My space has the #1 search ranking for my area, has hosted over 200+ people, and is currently booking out 18 months in advance. I've helped multiple hosts get their properties listed and their prices per night maximized. Results range from an extra +50% in price for established hosts and +400% for brand new hosts.

Hope you enjoy my courses!

Symon He
4.5 Average rating
2,255 Reviews
43,136 Students
10 Courses
Stanford MBA | Real Estate & Startup Guy | LearnAirbnb.com

Hey, thanks for checking out my courses.  

I am a real estate consultant and startup advisor based out of Los Angeles CA.

I currently help startup founders and small business entrepreneurs build financial models and projections for their businesses and private real estate investors with their acquisitions analysis and deal structuring.  Please message me directly for consulting inquiries.

Previously, I was Head of Marketing Analytics at the Panda Restaurant Group after first serving as a senior financial analyst leading real estate and new store underwriting efforts. 

Prior to that, I worked on over $400M in commercial real estate investments at a private equity real estate fund.  Before that, I worked as a manager in the global M&A unit for a Fortune 80 company. 

I am also a cofounder of LearnAirbnb, a consultancy and research group specializing in the home-sharing economy.  

I graduated Magna Cum Laude in Computer Engineering and Economics from UC Irvine and hold an MBA from Stanford University.