Modeling startup investments
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Introducing the TrackerTime Case
Introducing the TrackerTime Case
In this lesson, we are introduced to TrackerTime. A fast-growing startup seeking a $20m investment from the Ventura Venture Capitalist firm. We also learn about the economics of venture capital investment and how it differs from previous models we have viewed.
New Topics in this Course
New Topics in this Course
This course incorporates new model features such as foreign exchange calculations, minority stakes and liquidation preferences. In this lesson, I describe each of these new features in detail.
Revenue Projections for TrackerTime
Revenue Projections for TrackerTime
TrackerTime sells two products, one to consumers and one to businesses. In this lesson, we learn how to project revenue for both products, over a 5-year timeframe.
COGS and Operating Expense Projections
COGS and Operating Expense Projections
In this lesson, we project TrackerTime's operating costs, examining in detail the reasoning behind our future assumptions of R&D expenses and other such costs.
Sales and Marketing Expense Projections
Sales and Marketing Expense Projections
In this lesson, we project sales and marketing expenses for both new & existing customers, and for both TrackerTime's products.
Depreciation and Amortization Projections
Depreciation and Amortization Projections
Startups typically have very little Depreciation and Amortization because they don't need factories or retail stores. However, we still need to project this expense, which we will learn how to do in this lesson.
Projecting the Balance Sheet Part 1
Projecting the Balance Sheet Part 1
In this lesson, we enter a series of assumptions for each line-item in the balance sheet, that will form the basis of our balance sheet projection.
Projecting the Balance Sheet Part 2
Projecting the Balance Sheet Part 2
In this lesson, we project the future assets and liabilities for TrackerTime, over the next 5 years.
Projecting our Statement of Cashflows
Projecting our Statement of Cashflows
Drawing from line-items in the income statement and balance sheet, in this lesson, we project the Statement of Cashflows for TrackerTime.
Completing our 3 Statement Projections
Completing our 3 Statement Projections
In this lesson, we complete our Statement of Cashflows projection and ensure that our Balance Sheet projection is balanced!
Testing our Logic
Testing our Logic
Even if your balance sheet is balanced, it's critical to still test your model's logic, to ensure no mistakes have been made.
Insights from Projections
Insights from Projections
In this lesson, we reveal some initial insights from the financial model we have built for TrackerTime.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
