Entrepreneurial & Startup Financial Modeling Labs

Hands on experience modeling SaaS & Product financials from basic unit economics all the way to five year models.

Ratings: 4.71 / 5.00




Description

WELCOME TO ENTREPRENEURIAL & STARTUP FINANCIAL MODELING LABS & TWO AMAZING LABS!

These two labs are meant to be HANDS ON.  And, they were designed so that you can work on the associated Google Sheet or Excel file while you are taking the course.  Step by step we'll build financials from the most basic unit economics all the way to fairly complex five year financial models (also called proformas or forecasts). One of our objectives from this course is to introduce a lot of fun financial concepts into the course along the way.  So, that by the end of the course you'll have a very good handle on this world and HOPEFULLY you'll feel comfortable tackling your small business or startup financials.

What you'll LEARN at a glance.

  • Goals, Revenue Models, Pricing, Growth Channels, Customer Acquisition Costs (CAC), Lifetime Value (LTV), the LTV:CAC Ratio, One Year Financial Model & Seed Funding.

  • Historicals, Sales Targets, Customer Success Team, COGS, Product Roadmap, Growth Revisited, Foundational Expenses & Decision Modeling.

  • Small Quantity Costing, Gross Margin Analysis, Break Even Analysis

  • Business at Scale, Growth Channels, Labor Expenses & Cash Flow

  • Contribution Margin, Economics of Scale, Revenue Analysis & Decision Modeling

  • Building A Full 5 Year Financial Model & Presenting It!

OUR LABS

Lemonade, Inc - Lemonade, Inc. is a classic financial modeling exercise using something we can all relate to, a Lemonade Stand!  This lemonade stand grows from a one stand, one summer experiment all the way to a multinational powerhouse in the beverage and apparel space.  This lab explores what I'll call a "traditional" model where we have fairly clear revenue, associated costs and then profit.  This lab is easier to comprehend than the SaaSy, Inc. lab which we'll introduce next. If you are VERY new to finance, this is the one to start with and its also why we listed it first.

SaaSy, Inc - SaaSy, Inc is all about subscriptions models.  These types of business models have become VERY popular not just with software but with everything because recurring revenue is the best kind of revenue.  Although we'll use software for this particular financial modeling exercise, you can use this lab to conceptualize ANY business that will use a recurring revenue model, more commonly called a subscription model. SaaSy, Inc is a software company that is looking to help people simplify how they stand up eCommerce websites.  Similar to the Lemonade, Inc. lab, we'll start small and build all the way to a full five year financial model.  And, we'll hit as many fun topics along the way.

What You Will Learn!

  • Startup financial modeling for entrepreneurs, founders and business owners.
  • Building financials from scratch and evolving them into full blown financial models.
  • Understanding the difference between traditional financial models and subscription models.
  • A hands on tutorial building financials in Google Sheets or Microsoft Excel.
  • Learn to set goals, build revenue models, set pricing and model growth channels
  • Master customer acquisition costs (CAC), Lifetime Value (LTV), the LTV:CAC Ratio
  • Small Quantity Costing, Gross Margin Analysis, Break Even Analysis
  • Contribution Margin, Economics of Scale, Revenue Analysis & Decision Modeling

Who Should Attend!

  • Founders - Founders of startups and small businesses.
  • Entrepreneurs - Who are building high growth businesses and want to raise money.
  • Business Professionals - Who want to tackle finance and accounting.
  • Small Business Owners - People running small businesses who need a better understand of finance and accounting.
  • Students - Anyone who wants to learn this discipline.