Last version published: 16/05/2026 18:18
Publication number: ELQ-63906-4
View all versions & Certificate
NAV based TVPI, MOIC & IRR
NAV based TVPI, MOIC & IRR model in Excel.
Further information
The NAV-based TVPI, MOIC & IRR Excel model is designed to help investors, fund managers, and analysts evaluate investment performance using Net Asset Value (NAV) as a central metric. Its primary objective is to provide a transparent, flexible, and Excel-native framework for calculating key performance indicators—Total Value to Paid-In (TVPI), Multiple on Invested Capital (MOIC), and Internal Rate of Return (IRR)—based on actual capital flows and NAV updates.
This tool enables users to input detailed transaction data, including capital calls, distributions, expenses, and NAV valuations, and automatically computes the impact of each on overall fund performance. It supports periodic performance snapshots and helps track the evolution of investment value over time.
The model is particularly useful for:
Standardizing performance reporting across NAV-based investment structures
Enhancing transparency in fund valuation and investor communication
Supporting strategic decision-making, including reinvestment and exit planning
Benchmarking fund performance against industry standards
By focusing on NAV rather than share-based valuation, this best practice tool is ideal for environments where NAV is regularly updated and used as a reference for fund health and return analysis.
This NAV-based TVPI, MOIC & IRR Excel model is best suited for investment environments where Net Asset Value (NAV) is regularly updated and used as a core metric for performance evaluation. It applies most effectively in the following conditions:
Private equity and venture capital funds that report NAV periodically and require transparent performance tracking.
Investment structures with multiple capital calls and distributions, where cash flows are spread across time and need to be analyzed in relation to NAV.
Funds that do not use share-based valuation, but instead rely on NAV to assess portfolio value and investor returns.
Scenarios requiring calculation of IRR, MOIC, and TVPI based on actual capital flows and NAV inputs.
Internal reporting and investor communication where clarity and consistency in performance metrics are essential.
Strategic planning and benchmarking across portfolios or fund vintages using standardized NAV-based metrics.
This tool is ideal for fund managers, analysts, and institutional investors seeking a reliable, Excel-native framework to evaluate investment outcomes and optimize decision-making based on NAV-driven insights.
This NAV-based TVPI, MOIC & IRR Excel model is designed for investment structures that rely on Net Asset Value (NAV) as a central performance metric. However, it may not apply ideally in the following conditions:
Share-based investment structures: If your fund tracks ownership through shares or units rather than NAV, a share-based model may be more appropriate.
Real-time trading environments: This tool is built for periodic performance analysis, not for live portfolio monitoring or high-frequency trading.
Single-event investments: For one-time capital deployments with no ongoing cash flows or NAV updates, simpler models may be more efficient.
Highly complex fund structures: Funds with tiered carry, waterfall distributions, or multi-layered instruments may require more advanced modeling than this tool provides.
Non-financial asset tracking: The model is not designed for valuing physical assets like real estate, commodities, or collectibles unless they are part of a NAV-reporting fund.
In these cases, users may need to adapt the model or use specialized software tailored to their specific investment structure or reporting requirements.
