Ultimate Venture Capital Guide - Terms, Excel, Cap Tables

Focused View

Moritz Miersch

2:50:11

88 View

1. Introduction

1. Introduction.mp4

02:29

2. Section 2 Term sheets and important concepts

1. Summary.mp4

00:46

2. What is a term sheet.mp4

04:08

3. Term sheet structure.mp4

01:41

4. Investment, primary, secondary, Pre- & Post-money valuation.mp4

04:02

5. Liquidation preference, participating & non-participating, seniority.mp4

11:38

6. Dividends, rate, cumulative, non cumulative.mp4

00:57

7. Anti dilution protection, down rounds, weighted average, full ratchet.mp4

02:58

8. Drag along, tag along.mp4

03:34

9. Voting & Information rights.mp4

03:07

10. Employee share options, ESOP, Incentivation.mp4

03:17

11. Founder vesting, vesting period, cliff.mp4

01:54

12. Representations & Warranties.mp4

01:11

13. Non-compete, non-solicitation.mp4

01:00

14. Due dilligence, timeline, cost cover.mp4

01:24

15. Conditions precedent.mp4

00:57

16. Governing law, juricdiction, dispute resolution.mp4

00:29

17. Confidentiality.mp4

01:01

18. Signing & closing.mp4

00:33

19.1 Term sheet template.docx

19.2 Term sheet template.pdf

19. Outro.mp4

01:00

3. Excel basics for financial modelling

1. Intro & overview.mp4

02:59

2. Basic Excel settings.mp4

05:15

3. Basic Excel Settings interim summary.mp4

01:06

4. Why you should use shortcuts.mp4

01:10

5. Initiating short cuts with ALT.mp4

02:47

6. Basic CTRL short cuts.mp4

07:45

7. Other important short cuts.mp4

02:48

8. Functions and formulars.mp4

07:02

9. Format menu.mp4

00:26

10. Quick summary.mp4

00:18

11. How to use formatting.mp4

10:38

12. Custom formats and codes.mp4

03:50

13.1 Excel basics and format codes.xlsx

13. Outro.mp4

00:19

4. Cap tables and ownership calculations

1. Intro & overview.mp4

03:15

2. Purpose and views of the cap table.mp4

01:48

3. Initial cap table example.mp4

05:08

4. Example - raising a seed round.mp4

03:05

5. Seed round example - valuation, PPS, primary.mp4

10:31

6. Seed round example - adding the first investors, additional shareholders.mp4

02:22

7. Series A example - raising additional capital, adding new share classes.mp4

12:41

8. Series A example - liquidation preference and wrap up.mp4

03:52

9. Series B example.mp4

04:43

10. Series B example - secondary and discounts.mp4

11:43

11. Series B example- Employee share option pool (ESOP).mp4

03:04

12. Series B example - putting everything together I.mp4

07:30

13. Series B example- Putting everything together II.mp4

02:09

14. Fully diluted vs not fully diluted view.mp4

02:22

15.1 Cap table calculations.xlsx

15. Outro & summary.mp4

01:29

Description

Learn about venture capital terms and term sheets, setting up Excel for financial modelling, and cap table calculations

What You'll Learn?

Start to become a great Venture Capital and Growth Equity investor, investment banker, founder, or transaction lawyer
Learn about important Venture Capital and Growth Equity concepts, including, share classes, structures, voting rights, valuations, ownership, and much more
Learn about term sheets, how to use and structure them and the relevant investment terms contained within (such as valuation, primary, secondary and many more)
Learn how to handle Excel like a pro for financial modelling (set-up, shortcuts, formatting)
Learn why cap tables are important and how to use them correctly
Learn to build a cap table from scratch
Learn to model different investment rounds from inception over Series A/B/C

Who is this for?

Investment bankers and analysts starting their carreer

Investment Fund Analysts and Associates

Start-up founders looking to learn about their business’s ownership development across investment rounds

CFOs looking learn about modelling of ownership structures and investment rounds

Lawyers looking to help their clients in a transaction

Everybody who wants to know more about a company’s' ownership and its development

What You Need to Know?

NO Excel or finance experience needed

More details

Description
In this course you will learn all the important concepts related to venture capital and growth equity terms, term sheets, setting up Excel for financial modelling, as well as around cap tables and ownership calculations.
The course helps investors, investment bankers, analysts and associates, founders, CFOs, and transaction lawyers to become knowledgeable in these core concepts and enable them to set the foundation to model them professionally. After completing the course, you have a firm understanding of the venture capital/growth equity terms and will be able to start modelling your first transactions and their impact on the shareholder base.
I will give you all the material and templates you need to start modelling the impact of also more complicated investments on the ownership structure of any business.

Course structure:
We will start by discussing term sheets and the terms contained within to get a common understanding of the basics. We will cover topics such as pre- and post- money valuations, primary and secondary investments, and most other relevant terms. After this first part, you will be able to draft your own term sheets (I will also provide you with a draft template).
We will then begin to prepare you to put those concepts into practice and will set-up your Excel together for financial modelling. We will cover the most important aspects from core Excel settings, over formulars and shortcuts, to formatting and best practices so you have the basics to start crafting professional financial models.
We then continue to operationalize the first and second part of the course by looking into practical examples of cap tables. We cover the purpose of cap tables and what they can help you with as well as why you need to be well versed when it comes to ownership/shareholding calculations.
Then we will jointly build a cap table from scratch. We start building your skill set with a simple example of a cap table at the inception of a company. Using this example, we enhance your understanding by adding different complications from a Seed round to a Series C investment round so you get a firm grasp on the most important mechanics and enable you to model your own investment rounds.
We will then wrap up the course together and I will give you all the material you need to get to modelling and drafting term sheets yourself.
If you have any questions about or beyond the course, I would be delighted to answer them!
Who this course is for:
Investment bankers and analysts starting their carreer
Investment Fund Analysts and Associates
Start-up founders looking to learn about their businessâ€™s ownership development across investment rounds
CFOs looking learn about modelling of ownership structures and investment rounds
Lawyers looking to help their clients in a transaction
Everybody who wants to know more about a companyâ€™s' ownership and its development

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Moritz Miersch

Instructor's Courses

Hello!I am an investment professional with a focus on technology investments in the growth equity space.Over the course of my career, I have deployed hundreds of millions USDs in various companies.I have led and accompanied processes across different investment stages ranging from Series A rounds to exits and have been part of the value creation lifecycle by serving on the companies’ boards.Through my transaction experience, I was able to develop a state-of-the-art toolbox for everything investment and value creation related - which I would be delighted to teach you!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.