Waterfall analysis models how exit proceeds are distributed across investors and security holders based on the liquidation preferences, participation rights, and seniority structures attached to each security. For venture capital and private equity firms, it is a core tool for exit planning, valuation, and LP reporting. It is also one of the most time-consuming financial modeling exercises a VC finance team performs, not because the math is intractable, but because assembling the right inputs is.

The firms that run waterfall analysis most efficiently are not necessarily those with the best spreadsheet templates. They are the firms with centralized, structured investment data that makes it possible to retrieve complete financing terms instantly, keep models current as portfolios evolve, and connect waterfall outputs directly to the broader reporting workflow.

Why waterfall analysis is painful without centralized data

Most of the operational friction in waterfall analysis comes from data assembly, not modeling. Before a waterfall model can be built, a finance team needs information like the liquidation multiple, participation type, participation cap, and seniority structure for every preferred share class in a portfolio company. That information typically lives across documents and spreadsheets maintained by different team members.

The result is a process that starts with a data hunt before any modeling begins. Waterfall spreadsheets built from manually assembled inputs go stale when a new financing round closes or terms are amended, requiring a rebuild every time. Analysis across a range of exit valuations multiplies the workload further. When results need to be communicated to LPs or portfolio company management, translating a spreadsheet into a clear explanation is an additional step on top of everything else.

How Standard Metrics centralizes the data waterfall analysis requires, storing liquidation preferences and participation rights

Standard Metrics stores liquidation preferences and participation rights at the security level, capturing the fields required to build a complete waterfall model: liquidation multiple, participation type (non-participating, fully participating, or capped participating), participation cap, and seniority (tiered or pari passu). These terms live alongside investment records, round data, share counts, and ownership percentages in a single governed data model.

Because financing terms are stored in a structured, machine-readable format rather than free-text notes or attached documents, they are immediately queryable. When a new financing round closes, terms are updated in one place and flow through automatically to any analysis that draws on them. There is no spreadsheet to rebuild, no version to reconcile, and no risk that a waterfall model is running on last year’s terms.

This centralization is the prerequisite for everything else. Clean, governed financing terms in a single system is what makes it possible to move directly from a question to an analysis, rather than spending the first hour of every waterfall exercise locating and assembling inputs.

Running waterfall analysis with Standard Metrics

Standard Metrics provides two paths for running waterfall analysis on top of centralized investment data: the in-app AI Analyst and the hosted MCP server for LLM clients like Claude and Codex. Both draw on the same governed financing terms and investment records, so the choice comes down to workflow preference rather than data quality.

Using the AI Analyst to run waterfall analysis

The AI Analyst is Standard Metrics’ built-in conversational analysis tool, accessible directly within the platform. For teams that want to run waterfall analysis without leaving their portfolio monitoring workflow, the AI Analyst is the fastest path. Because it already has access to the firm’s complete investment data, liquidation preferences, and financing terms, there is no setup required. A finance user can ask a waterfall question directly and receive a structured response grounded in live data.

Example: “Model the waterfall distribution for [Company] at a $75M exit. Show proceeds by share class and flag conversion thresholds.”

Example: “Run the waterfall at exit valuations of $25M, $50M, $75M, $100M, and $150M and show how proceeds shift across preferred and common shareholders at each scenario.”

Example: “Write a plain-language explanation of how proceeds would be distributed at a $75M exit, suitable for sharing with the portfolio company’s management team.”

Using the MCP server and LLMs to build waterfalls

For teams that prefer to work in Claude or Codex or want to combine Standard Metrics data with context from other connected tools — meeting notes, CRM data, fund accounting records — Standard Metrics’ hosted MCP server provides a direct connection. Claude or Codex can query live liquidation preference and investment data from Standard Metrics and use it to construct waterfall models, run scenarios, and generate output within a single conversation. The MCP path is particularly useful for multi-data-source or output workflows.

Example: “Pull the liquidation preferences and financing terms for [Company] from Standard Metrics and model the waterfall at a $75M exit.”

For teams that need waterfall output in a structured spreadsheet, Standard Metrics’ Excel Add-In provides a direct path from analysis to a shareable, formatted model. Rather than copying Claude’s output manually into a spreadsheet, users can pull Standard Metrics data directly into Excel and use Claude to build the waterfall structure on top of it — producing a fully formatted workbook ready for LP reporting, board presentations, or further scenario modeling without a separate formatting step.

Building with Claude and Standard Metrics’ Excel add-in means you can have Claude build the model once and then have it connected to live data. Need to refresh it for a new company? Just change the name. Need to refresh with new investments and exit scenarios? All scenarios are easy to manage with connected data.

Both approaches replace the manual data assembly step with a direct query against centralized, current data — producing waterfall analysis that is always consistent with the rest of the firm’s investment records.

Common mistakes in VC waterfall analysis

Using incomplete or outdated financing terms. Missing a participation cap or misclassifying a seniority tier produces materially incorrect distribution outputs. Centralizing financing terms in a governed system eliminates this risk.

Ignoring conversion thresholds. The economically significant question in many exits is not just how liquidation preferences are distributed but at what valuation preferred shareholders convert to common. Models that skip this step misstate investor economics at higher exit valuations.

Modeling only one exit scenario. A single waterfall output at one price gives an incomplete picture. Scenario analysis across a range of valuations is necessary to understand where the meaningful inflection points are.

Keeping waterfall models in a standalone spreadsheet. A spreadsheet disconnected from live investment data goes stale every time a new round closes or terms change. Connecting waterfall analysis to a centralized data source means models stay current without manual maintenance.

FAQ

What is waterfall analysis in venture capital?

Waterfall analysis models how exit proceeds are distributed across investors and security holders based on the liquidation preferences, participation rights, and seniority structures attached to each security class. It determines how much each investor receives at a given exit valuation and at what price preferred shareholders would convert to common.

Why is waterfall analysis difficult for VC and PE firms?

The modeling itself is straightforward, but assembling the correct inputs is not. Liquidation multiples, participation rights, and seniority structures are typically scattered across legal documents, deal memos, and spreadsheets. Gathering and verifying those terms before any modeling begins is where most of the time goes.

What data does Standard Metrics store to support waterfall analysis?

Standard Metrics stores liquidation multiple, participation type (non-participating, fully participating, or capped participating), participation cap, and seniority (tiered or pari passu) for each preferred share class, alongside investment records, share counts, round data, and ownership percentages in a single governed data model.

What is a liquidation preference and why does it matter for waterfall analysis?

A liquidation preference is a contractual right that entitles preferred shareholders to receive a defined amount — typically a multiple of their original investment — before common shareholders receive any proceeds in an exit. Liquidation preferences, combined with participation rights and seniority structures, determine the shape of the waterfall and are the primary driver of how proceeds are distributed at different exit valuations.

How does centralized data improve waterfall accuracy?

When financing terms are stored in a governed system rather than across separate spreadsheets and documents, waterfall models always draw on current, verified inputs. There is no risk of running analysis on outdated terms from a prior round, and any update to the underlying data flows through automatically to subsequent analyses.

Final takeaway

Waterfall analysis is only as reliable as the financing terms it is built on. Firms that centralize liquidation preferences, participation rights, and seniority structures in a governed system like Standard Metrics eliminate the data assembly work that makes waterfall modeling slow and error-prone. With Standard Metrics’ hosted MCP server and Claude, that centralized data becomes the foundation for a conversational waterfall workflow — from data retrieval to scenario modeling to LP-ready output — that replaces hours of manual spreadsheet work with a few targeted prompts.

If you’re interested in streamlined waterfall analysis, reach out directly via the form fill below to discuss what is possible.