Exit Waterfall Calcs

permalink: false

version: 3.3
links:
product: Cap Table & Exit Waterfall Tool
link: /cap-table/

• On Exit Waterfall, introduced a new model settings at the top, to set the formula structure in a few situations. Basically, some aspects of the Exit Waterfall create circulars that can be difficult for Excel and Google Sheets to calculate correctly (yes, spreadsheet programs have limitations, especially when it comes to circular references). By default, the model uses simpler formulas unless the more advanced options are required, for example for pari-passu or for down rounds (introduced in the previous version), in which cases the model turns on the more complicated formulas. Hopefully this makes it better for a wider range of people to use without issue, and still keeps the more advanced functionality for those that need it.