LESSON 0 · INTRODUCTION TO MODELLING IN EXCEL

• Key principles: Main pillars of a good Excel file
• Visuals: The art of crafting easy to follow Excel sheets
• Robustness: Learning how to build a bulletproof workbook
• Tricks and tools: Small tips that will make your life easier

LESSON 1 · INTRODUCTION TO STARTUP FINANCE

• What is a startup? Definition of the scope of this lesson and the entire course
• The Lean Startup method: Most accepted method of how to run a startup
• Unit economics: Startups’ most important quantitative concept
• Financials: Brief definition and how they look like in a startup
• Case study: Unit economics at Uber

LESSON 2 · SAAS

• What is a SaaS? Definition of the scope of this lesson and trends
• SaaS KPIs: All specific vocabulary, metrics and benchmarks
• Cohort analysis: Deepdive in a crucial analysis for all startups and SaaS in particular
• Case study: SaaS KPIs analysis and forecast at Graphext

LESSON 3 · PLATFORMS, MARKETPLACE, ECOMMERCE

• Definitions: What we mean with each concept
• Marketplace concepts and KPIs: All specific vocabulary, metrics and benchmarks in marketplaces and platforms
• Ecommerce concepts and KPIs: All specific vocabulary, metrics and benchmarks
• Case study: Marketplace analysis at Ontruck

LESSON 4 · OTHER BUSINESS MODELS

• Fintech: Analysis on startups depending on financial assets
• Data monetization: Models based on user databases
• Other business models: The other of the other business models
• Case study: Fintech and data sale models at Lenme

LESSON 6 · FUNDING ALTERNATIVES

• Traditional alternatives: Public, banks, venture debt
• Revenue-based funding: New players with innovative and digital models
• Basics on private funding: Private funding as a funding alternative
• Case study: Financing decision at Geoblink

LESSON 7 · FUNDING ROUNDS I

• Key concepts: Basics on how a capital increase works
• Accounting and cap table: What matters; how much each shareholder has
• Types and valuations: Different stages and valuation methods
• Case study: Simplified cap table evolution of Colvin

LESSON 8 · FUNDING ROUNDS II

• ESOP/Phantom shares: Keys on incentive plans for employees
• SAFEs/Convertible notes: Reasoning and clauses of loans convertible to equity
• More stuff: Secondaries, syndication, taxes, share classes, media for equity…
• Case study: ACME’s almost real cap table evolution

LESSON 9 · STARTUP GOVERNANCE

• Governance structure: Administration and players in decision making
• Legal documents: From bylaws to SHA
• Shareholders agreement clauses: Deep dive on investment, control, protection and exit clauses
• Case study: Negotiating a term sheet at Build38

LESSON 10 · INTRODUCTION TO VENTURE CAPITAL

• What is Venture Capital? Definition, history, evolution in different geographies, etc.
• How does Venture Capital work? Structure, internal organization, returns, etc.
• KPIs in Venture Capital: Key metrics to compare and use as benchmarks
• Case study: VC fund modeling at eCapital

THEORY

• Pre-read: Introductory materials (news, documents, book chapters…) related to each topic
• Theory videos: Recorded sessions explaining all relevant concepts
• Slides: Theory in “slides” format to follow recorded videos and complete the practical case

PRACTICE

• Case statement: Practical cases based on real companies and situations. A statement and a supporting excel will be provided for case resolution
• Case solution: A supporting data solution for students to use as reference
• Live video class: After discussing the case in a live class, the video will be uploaded for students to watch as many times as they want