Financial Modelling for Startups - Online course

SKU 00158
$99.00
In stock
1
Product Details

Special 48 hour sale. $99 for the next 96 hours.

If you missed the $39 pre-order sale, buy it now before it gets bumped up to $159.

About the Course

What are the most common uses of financial models at work? How do models focused on growth and scale differ from models focused on risk and strategy? Do we need complex models or simple models? How do we validate assumptions? How much does model design matter?

This course is designed to help you understand the need for financial modelling, the various components of a revenue model and the use of the model to define and evaluate strategy. It explains the importance of unit economics, some methods used and mistakes made when modelling market size and the underlying mindset necessary for building these models.

It walks through a detailed step by step process to build financial models (income statement, balance sheet & cash flow statement), and calibrates them to the market, reviews common mistakes made and demonstrates how these may be corrected.

The models we build are only as good as the questions we ask. The course therefore focuses on asking and answering the right questions. Do we need to build a model to manage and plan for growth or debt servicing? Launch roadmap or capital requirements? Scale, turnaround or downside protection? For validating assumptions or pricing product offering?

The course illustrates how downside risk is factored into the model and how the model is tested for alternative assumptions and strategies. It explains how the model may be structured and results interpreted to answer questions posed by various stakeholders (lenders, owners & shareholders) and how to assess whether business are over or undervalued.

We use three case studies to explain the concepts and work with multiple approaches to designing models.

  1. Maya’s Closet: Builds a financial model for growth and capital allocation for startups and founders. The case study looks at a growing startup’s capital needs and the decisions the founders need to make to pick one or more growth strategies.
  2. MedAngle: Reinforces and revises unit economics concepts
  3. GEMS: Builds a financial model for credit analysis and financial forecasting. The GEMS Education case study looks at the GEMS school system debt load in the midst of the Covid-19 related slow down in UAE to evaluate the capacity of the group to raise more debt.

Learning Objectives

After taking this course you will be able to:

  • Recognize the benefits of building a financial model in EXCEL
  • Understand how to ask the right questions for effective model building
  • Appreciate the mindset needed to build effective models
  • Identify drivers and trends that influence model assumptions & variables
  • Build financial statements with a specific view towards free cash flows, risk and downside exposure
  • Recognize mistakes made in building models & correct balancing errors
  • Calibrate the model to historical trends and market prices
  • Assess how to refine models for identified weaknesses
  • Evaluate model results and recommend actions
  • Link economic models to business models and analyse the interaction of the two
  • Factor in downside risk to prepare for adverse events
  • Evaluate different strategies and test their impact on margins and values
  • Review relationships and transactions from an analytics lens
  • Analyse the sensitivity of key performance and business metrics to changes in economic and business cycles
  • Assess the appropriateness of a business’ enterprise value using valuation multiples

Course Details
LevelIntermediate
PrerequisitesThis course requires some background and exposure to EXCEL. All participants would need EXCEL professional installed.
Target AudienceThe intended audience are founders, product managers, financial analysts, credit analysts, relationship managers and consultants responsible for building growth, valuation and debt servicing models for clients.
Advance Preparation None
Minimum Browser Requirements

This site is best viewed in Google Chrome, Firefox or Safari. Please note we do not support Internet Explorer.

For a better audio experience, please use headphones.
Course Guide This course consists of three modules and 11 lessons:

Module 1
  • Lesson 1 - Introduction
  • Lesson 2 - Maya’s Closet
  • Lesson 3 - Modelling growth in the middle of a pandemic
  • Lesson 4 - Simple P&L
  • Lesson 5 - Balance Sheet & Change in Cash Flow Position
  • Lesson 6 – Takeaways/ Dos & Don’ts

Module 2

  • Lesson 1 – MedAngle Case Study

Module 3

  • Lesson 1 - GEMS
  • Lesson 2 – Complex Models – GEMS – Modelling the financial statements
  • Lesson 3 – Scenario Analysis for GEMS
  • Lesson 4 – Takeaways/ Dos & Donts

Course AvailabilityOnline subscription is for a 60 day period only. This content will not be available after the period ends.
Save this product for later