Ultimate Toolkit for Private Equity Investment Analysis
Calculate Internal Rate of Return for your investment cash flows
Quick leveraged buyout analysis with entry/exit multiples
Quick valuation using multiple methods
Calculate key fund performance indicators
Calculate LP/GP distribution waterfall with catch-up provisions
Model debt structure with multiple tranches and amortization
Analyze IRR sensitivity to key variables
Discounted Cash Flow analysis with terminal value
Value company based on trading multiples of comparable firms
Export all calculations and results to Excel format
The Internal Rate of Return (IRR) calculator uses Newton-Raphson method to find the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. This is the most widely used metric in private equity to measure investment performance. The calculator accepts multiple cash flows at different dates, automatically sorting them chronologically and calculating both IRR and Multiple on Invested Capital (MOIC).
The Leveraged Buyout (LBO) model simulates a typical private equity acquisition structure. It calculates how much equity is required based on the debt-to-equity ratio, projects EBITDA growth over the holding period, and determines the expected returns based on exit multiples. The model assumes partial debt paydown during the holding period and calculates both MOIC and IRR for the equity investment.
This module provides quick valuations using industry-specific multiples for Revenue, EBITDA, and P/E ratios. The multiples are automatically adjusted based on the company's growth rate, with higher growth companies receiving premium multiples. The calculator includes pre-set multiples for various industries including Software/SaaS, Healthcare, Manufacturing, Retail, Business Services, and Fintech.
Calculates key fund-level metrics used by Limited Partners (LPs) to evaluate fund performance. DPI (Distributed to Paid-In) shows cash returned relative to invested capital. RVPI (Remaining Value to Paid-In) indicates unrealized value. TVPI (Total Value to Paid-In) combines both realized and unrealized returns. The calculator also estimates carried interest based on profit distribution.
Models the typical private equity distribution waterfall between Limited Partners (LPs) and General Partners (GPs). The calculator follows the standard structure: (1) Return of LP capital, (2) Preferred return to LPs, (3) GP catch-up to receive their carry percentage of profits already distributed, and (4) Remaining profits split according to the carry agreement. This ensures LPs receive their preferred return before GPs participate in profits.
Creates a comprehensive debt amortization schedule with multiple tranches including senior and mezzanine debt. The model accounts for different interest rates, PIK (Payment-In-Kind) interest that compounds rather than being paid in cash, and mandatory amortization based on available cash flow. It tracks debt-to-EBITDA ratios over time, helping assess covenant compliance and refinancing needs.
Performs scenario analysis showing how changes in key variables affect investment returns. The calculator can analyze sensitivity to exit multiples, revenue growth rates, EBITDA margins, and leverage ratios. This helps identify which factors have the greatest impact on returns and understand the risk profile of an investment under different scenarios.
The Discounted Cash Flow model projects future free cash flows and discounts them to present value using the Weighted Average Cost of Capital (WACC). The model uses different growth rates for near-term and mid-term projections, calculates terminal value using the perpetuity growth method, and accounts for taxes and capital expenditures. This provides an intrinsic value based on the company's cash-generating ability rather than market multiples.
Values a company based on how similar public companies are trading in the market. The calculator allows input of multiple comparable companies with their trading multiples (EV/Revenue, EV/EBITDA, P/E), calculates median multiples to reduce the impact of outliers, and applies these multiples to the target company's metrics. This market-based approach provides a reality check against intrinsic valuation methods.
Exports all calculations and results to a formatted Excel file for further analysis and presentation. The export includes all input parameters, detailed calculations, sensitivity tables, and formatted results. This allows for easy integration with existing models, creation of investment committee presentations, and archival of analysis for future reference.