Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Financial Modeling for Startups & Small Businesses
Rating: 4.6 out of 5(120 ratings)
425 students

Financial Modeling for Startups & Small Businesses

Learn the best practices for building practical financial models and forecasts for your startup business.
Last updated 11/2020
English

What you'll learn

  • Forecast customer growth by channel
  • Build an Income Statement
  • Build a Balance Sheet
  • Build a Statement of Cash Flows
  • How all 3 statements are connected
  • Basic Excel Functions and Formulas
  • How to structure and present a financial model

Course content

2 sections7 lectures2h 9m total length
  • Introduction & Modeling Customer Growth24:45

    In this section, we will go through setting up your financial model and building out a forecast for acquiring customers. This will include formatting the model and setting a structure for building out the rest of your forecast.

  • Creating a Revenue Forecast14:54

    Now that we have the outline of the model complete and we know how we are getting our customers, we will work on translating these customers into revenue by building out our revenue formula.

  • Creating an Expense Budget18:30

    Understanding your expenses is crucial for the cashflow of your company. In this section, we create a full budget including forecasting key hires and creating expense forecasts for a variety of operational items.

  • Creating Assumptions around your Balance Sheet28:12

    Revenue does not equal cash collected, and there are plenty of transactions that happen outside of the income statement that can have a large impact on cash. Account for this in this video where we dive into the drivers of the balance sheet.

Requirements

  • Access to Google Sheets

Description

Co-Founder and COO of Forecastr (Techstars 2020) breaks down how to build a financial model from scratch in this 7 part lecture.


In this course, we start with a totally blank excel sheet. This is unlike other financial modeling courses that start with a template - by starting from scratch, we guarantee that you will have a deeper level of understanding for how financial modeling works, and have more freedom to customize your projections for your own business.


At the end of this course, you will have a full 3 statement financial model (Income Statement, Balance Sheet, Statement of Cash Flows) forecasted monthly and formatted attractively. We focus heavily on showing you the calculation logic so that you will be able to tailor your model to your specific needs. 


Why build a financial model?? Lots of reasons - but specifically a financial model will: 


1.) Help you raise money for your business  

Investors speak the language of finance - and a financial model is a great communication tool for investors. Presenting a model will inspire confidence that you'll be a good fiduciary of their investment, and that you are a competent operator that knows their metrics! 


2.) Help you run your business better

A financial model is a mathematical simulation of your business. Once the simulation is build, there are endless questions that you can "ask it". What happens if you raise prices? Hire more people? Raise money? A good financial model is the closest thing a founder has to a "crystal ball" 

Who this course is for:

  • Startup Founders
  • MBA Students
  • Finance Students
  • Investors