VC case modelling help ! Cap table

Hi I’m a public equities intern trying to break into VC/GE (yes I know… it’s unorthodox & everyone tells me it’s heavily gatekept).

I’ve done the pnl / op build but I’m completely lost for the cap table, can a kind soul help me? Willing to pay for your time!

Promise I’m an ego-less hardworking kid.. so hard to get real cap table reps in a self-learnt style.

2 Comments
 

Breaking into VC/GE from public equities is indeed a unique path, but it's not impossible! Based on the most helpful WSO content, here’s how you can approach cap table modeling and get the reps you need:

1. Understand the Basics of Cap Tables

  • A cap table (capitalization table) is essentially a breakdown of a company's ownership structure. It includes details about equity ownership, types of shares (common, preferred), and any convertible securities like options or warrants.
  • Key components to focus on:
    • Pre-money valuation: The company's valuation before new investment.
    • Post-money valuation: Valuation after the investment.
    • Ownership percentages: How equity is distributed among founders, investors, and employees.
    • Dilution: Impact of new funding rounds on existing shareholders.

2. Learn Through Structured Training

  • If you're struggling to self-learn, consider structured resources. The Venture Capital Bootcamp offered by WSO is a great option. It covers:
    • Cap table modeling.
    • Term sheets.
    • ARR (Annual Recurring Revenue) and cohort analysis.
  • The Venture Capital Master Package is another comprehensive resource, combining VC modeling, Excel, and PowerPoint skills.

3. Practice with Realistic Scenarios

  • Start with simple scenarios:
    • A single funding round with one investor.
    • Add complexity by introducing multiple funding rounds, convertible notes, and employee stock option pools (ESOPs).
  • Use Excel to build your cap table. Focus on formulas to calculate ownership percentages, dilution, and post-money valuations.

4. Seek Feedback and Mentorship

  • If you're willing to pay for guidance, consider reaching out to professionals or mentors in the VC space. Platforms like WSO often have experienced members who can provide one-on-one coaching.
  • Alternatively, join VC-focused communities or forums to connect with others who can share insights or resources.

5. Get Hands-On Experience

  • Offer to assist startups or early-stage companies with their financial modeling. Even unpaid work can give you valuable exposure to real-world cap table scenarios.

6. Resources to Explore

  • WSO Venture Capital Bootcamp: A 4-hour intensive course on cap table modeling and term sheets.
  • WSO Venture Capital Master Package: Includes three courses tailored for VC modeling and analysis.

By combining structured learning with hands-on practice, you'll build the skills and confidence needed to excel in VC cap table modeling. Keep pushing forward—your willingness to learn and adapt will set you apart!

Sources: https://www.wallstreetoasis.com/forum/investment-banking/how-to-prepare-for-restructuring-technical-questions?customgpt=1, Structuring and Flow in an M&A Model, please help me!I want to start a company ^-^, Can someone please explain this to me?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Est aut in dolores non magnam ut sint. Quo non ut eligendi quis. Aliquam consequatur ea fugiat molestiae omnis reiciendis dolor. Placeat debitis dolor delectus tempore. Numquam qui et omnis.

Aspernatur laboriosam non sapiente qui. Ipsum architecto sapiente dolorem provident qui.

Voluptas qui molestias repellendus et. Eveniet labore cupiditate eos laudantium ratione. Quos cum eos nemo in autem. Reiciendis id incidunt incidunt voluptas vel in incidunt. Eaque possimus vitae praesentium qui molestiae qui. Ut qui quo voluptatem est.

Amet commodi eaque qui corrupti. Labore esse possimus animi quaerat esse. Porro voluptatem aut nemo voluptatem atque voluptas. Non quasi voluptas ut dolorem eum numquam. Qui et numquam nam facilis velit.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (72) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”