Returns Analysis

Private equity deal evaluation uses IRR and MOIC sensitivity tables to model returns by varying entry and exit multiples, leverage, growth rates, and hold periods. This process outputs an Excel workbook with assumptions and returns calculations for investment committee presentations.

A two-way sensitivity matrix for private equity returns models IRR and MOIC by varying two deal assumptions simultaneously, such as entry multiple and exit multiple. This generates a comprehensive matrix table suitable for stress-testing deal sizing and investment committee exhibits.

Yes, PE deal sizing and scenario analysis can generate Excel workbook outputs containing assumptions, returns calculations, 2-way sensitivity matrices, and 3 scenario analysis tables to comprehensively evaluate private equity deal returns.

To stress-test leverage and growth assumptions for a PE deal, model IRR and MOIC across various scenarios by varying entry and exit multiples, leverage, growth rates, and hold periods to produce sensitivity tables for deal evaluation.

This returns analysis approach for modeling IRR and MOIC sensitivity tables requires no external dependencies, operating via standalone scripts to generate Excel formatted outputs for private equity deal evaluation.

Scenario analysis tables for investment committee presentations are needed when evaluating private equity deals to summarize IRR and MOIC returns across multiple leverage, growth, hold period, and entry and exit multiple assumptions in a structured Excel format.