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

Excel Cap Table with Waterfall for Start-Ups

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

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 Best Practice includes
1 excel file

Prof. Zach Shulman offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Doesn't apply when accurate values are needed.


  • Rate this Downloadable Tool

    Write a review

  • Lisa Lakin(last updated: 21/10/2019 16:27)
  • Manoel Alberto(last updated: 08/04/2019 04:33)
  • Tịnh Vũ(last updated: 07/12/2018 07:44)
  • SamIam(last updated: 27/06/2018 15:04)
  • DanAA(last updated: 13/06/2018 15:18)


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

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

4.8 / 5 (5 votes)

please wait...