Excel Cap Table with Waterfall for Start-Ups

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