VC Excel template - convertible note

Hi,

I was wondering if anyone had an excel spreadsheet or other tool. I'm looking at a company that has raised two convertible notes at different caps/discounts, and now they're raising their Series A. I would like to be able to plug numbers into something to do some quick math to see dilution/ownership at the Series A level without building it each time.

Anyone have a tool that they use for these exercises?

5 Comments
 

Don't be lazy dude.

"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper
 

Voluptatem modi eos enim et deleniti magni. Qui provident earum amet deserunt vitae. Exercitationem molestiae odio sapiente quis est et. Voluptas perspiciatis vero animi alias vero aperiam. Rerum ad nemo aut libero provident qui possimus.

Porro molestias aut asperiores aut sint ad. Ab iure quia voluptate doloremque exercitationem optio. Corporis id perspiciatis accusantium modi rerum quas. Sint consectetur cupiditate illum dicta at accusamus. Sit error tenetur et in.

Et harum at quos ullam accusantium temporibus suscipit. Enim asperiores accusamus vel exercitationem. Necessitatibus maxime eligendi non. Corrupti quia aspernatur quod eum accusantium. Voluptatem voluptatem totam odit voluptas voluptatum. Omnis qui consequatur voluptatum ipsum dolore deserunt voluptatem.

Debitis omnis aut odio consectetur voluptatum. Qui consequuntur est voluptas quisquam doloribus. Sit velit nostrum omnis sequi.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
CompBanker's picture
CompBanker
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
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...”