MOIC Calculator Excel Template
MOIC Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate MOIC, realized/unrealized multiples, total gain, and implied CAGR for private equity investments. Editable Excel with live formulas.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate private equity returns instantly with this MOIC Calculator Excel template. Whether you're evaluating a single deal or preparing LP reporting, this spreadsheet computes Multiple on Invested Capital, realized and unrealized multiples, total gain/loss, and implied CAGR from your inputs.
What You Can Calculate
Enter your investment details and the template automatically calculates:
- MOIC (Multiple on Invested Capital) - Total value generated per dollar invested, the core PE return metric
- Realized Multiple - Cash already returned divided by invested capital (analogous to DPI at fund level)
- Unrealized Multiple - Current NAV divided by invested capital (analogous to RVPI)
- Total Gain/(Loss) - Dollar profit or loss on the investment
- Implied CAGR - Annualized return approximation for quick IRR comparison
Required Inputs
The template needs four values:
- Invested Capital - Total equity capital deployed across all tranches
- Distributions Received - Cash returned to investors to date
- Residual Value (NAV) - Current fair value of unrealized holdings
- Holding Period - Years from first investment to measurement date
Methodology
MOIC is calculated as (Distributions + Residual Value) / Invested Capital. The Implied CAGR uses the formula MOIC^(1/Years) - 1, which approximates annualized returns assuming single start and end dates. For deals with multiple cash flows at different times, use a full IRR calculation for precise annualized returns.
Assumptions & Limitations
- Results are gross of management fees, carried interest, and fund expenses
- All inputs are equity values net of debt
- Residual value is taken at face value with no illiquidity discount
- Implied CAGR treats all capital as deployed on day one
- Models one deal in isolation - fund-level returns require aggregation
Frequently Asked Questions
This template models one deal at a time. To track multiple investments, copy the Calculator sheet for each deal. You can create a summary sheet that aggregates the individual MOIC values, but note that fund-level TVPI requires capital-weighting across deals.
This template calculates gross deal-level MOIC before fees. Fund quarterly reports show net returns after management fees, carried interest, and expenses. Converting between gross and net requires detailed fee calculations that vary by fund structure. Use this template to understand gross deal economics; consult your fund administrator for net LP returns.
Yes. Enter total cumulative invested capital across all tranches in the Invested Capital cell. The template does not track individual round timing, so the Implied CAGR treats all capital as deployed at the start date. For precise timing, use an IRR model.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
