Excel Cap Table with Waterfall for Start-Ups
  • Excel Cap Table with Waterfall for Start-Ups
Originally published: 09/01/2017 13:06
Last version published: 20/01/2017 18:01
Publication number: ELQ-44526-2
View all versions & Certificate
certified

Excel Cap Table with Waterfall for Start-Ups

Model for pre-funded start-ups showing pre-money and post-money financing.

capexcel workbookfinancingstart-upstabletemplateventure capital

Description
This sample cap table is aimed at pre-funded start ups, where financing can be layered in, to give both pre-money and post-money values. It is a simple but not perfect model, however it does very well in most situations.

The yellow boxes are meant to be filled up by the user, and the green boxes provide a nicer double check on post-money calculations.

It is advised that you focus on the cell formulas, which are simple, but critical to two key aspects:
1) understanding of how the cap table works
2) how valuable the cap table can be when it comes to understanding your stock holdings.

- Professor Zach Shulman

This business tool includes
1 excel file

Prof. Zach Shulman offers you this business tool for free!

download for free

Discuss

Further information

Doesn't apply when accurate values are needed.

Reviews

  • No review yet!

Any questions on Excel Cap Table With Waterfall For Start-Ups?

The user community and author are here to help. Go ahead!

please wait...