What you’ll learn
Make games with Python.
Create basic line and scatter plots with Matplotlib 1.5.
Customise our graphs with visuals, a title, labels, text and a legend.
Recognize types of visualization: histograms, pie charts, and box and whisker plots.
“The Cap Table
Basic Share Distribution
Structure and Share Price Calcs
Adding in the Option Pool
Valuation Checks
What if There is a Convertible Note?
Formula Review
Methods of Convertible Note Conversion
Observations on Conversion Methods
Valuation Cap Calculations
Adding Logic to the Cap Table
Calculation Check
Formula Review
Eccentricities of Convertible Notes
How to Add a Series A
Series A Share Price
Fully Diluted Percentages
How to Manipulate Hard Coded Cells
Pre-Money and Post-Money
How to Add a Series B
Refining Option Pool Calcs
Fixing Errors
What if Investors Follow On?
Alternate Way to Calculate Convertible Note
Formula Review
Cap Table Section Outro
“Waterfall Analysis
What is a Waterfall Analysis
Setting Up the Waterfall Analysis
External References
Series B Waterfall
Additional Analysis of the Series B Waterfall
Series A Waterfall
Series Seed Waterfall
Common and Options Waterfall
Proceeds by Share Class
Proceeds by Entity
“Anti-Dilution Provisions
No Dilution Provisions Series Seed
Full Ratchet Dilution Series Seed
How Does a Down Round Affect Full Ratchet Provisions?
Weighted Average Series Seed + A
Additional Info on Using Solver
Weighted Average Series B
How to Connect Anti Dilution Provisions to Cap Table and Waterfall
Course Outro