A Step-by-Step Guide to Calculating Your True Angel Investment Returns
Most angel investors do not know their actual portfolio returns. They have a rough sense, usually anchored to their best or worst performing investment, but the precise number remains uncalculated. This is partly because the math is genuinely more complex than it appears and partly because the data required is scattered across documents, emails, and spreadsheets.
Calculating accurate returns is not a vanity exercise. It is the foundation for every meaningful portfolio decision: whether to continue investing, how to adjust your strategy, where to deploy follow-on capital, and how your angel investing compares to other uses of your capital.
The Four Core Metrics
1. MOIC (Multiple on Invested Capital)
The most straightforward metric. MOIC measures total value relative to total capital deployed.
Formula: MOIC = (Current Value + Distributions) / Total Amount Invested
For a single investment:
- You invested $50,000
- Current estimated value: $200,000
- No distributions yet
- MOIC = $200,000 / $50,000 = 4.0x
For a portfolio: Sum the numerator and denominator across all investments.
- Total invested: $500,000
- Total current value: $1,200,000
- Total distributions received: $100,000
- Portfolio MOIC = ($1,200,000 + $100,000) / $500,000 = 2.6x
2. IRR (Internal Rate of Return)
IRR measures the annualized rate of return that equates the present value of all cash flows to zero. It accounts for the timing and size of every cash movement.
Calculation method: Use the XIRR function, which takes paired date-amount inputs:
- Negative amounts for investments (cash out)
- Positive amounts for distributions and current value (cash in)
Example cash flows:
- Jan 2023: -$50,000 (initial investment)
- Jun 2024: -$25,000 (follow-on)
- Feb 2026: +$300,000 (current estimated value)
- XIRR result: approximately 68% IRR
The XIRR function requires at least one negative and one positive cash flow, and the dates must be precise. Approximating dates by more than a few weeks can meaningfully shift the result.
3. ROI (Return on Investment)
ROI is the simplest percentage return calculation.
Formula: ROI = (Current Value + Distributions - Total Invested) / Total Invested x 100
Using the portfolio example above: ROI = ($1,200,000 + $100,000 - $500,000) / $500,000 x 100 = 160%
ROI does not account for time, so a 160 percent return over 2 years is very different from 160 percent over 10 years.
4. Annualized Return
Annualized return converts total ROI into an equivalent annual rate.
Formula: Annualized Return = (Current Value / Amount Invested) ^ (1 / years) - 1
This gives you a rate that is directly comparable to other annual return benchmarks like the S&P 500.
Handling Complex Scenarios
Follow-On Investments
Follow-on investments are the most common source of calculation errors. When you invest additional capital in the same company, your total cost basis increases and your average entry price changes.
Correct approach:
- Track each cash flow separately with its date and amount
- Total invested = sum of all investments in the company
- MOIC = current value / total invested (not just the initial investment)
- For IRR, include each follow-on as a separate cash flow with its exact date
Common mistake: Calculating MOIC based only on the initial investment amount, ignoring follow-on capital. This overstates your actual return multiple.
SAFE Conversions
When a SAFE converts into equity during a priced round, the mechanics affect your position but not your cash investment.
Key points:
- Your total invested amount does not change at conversion (you already invested the money)
- Your ownership percentage is determined by the conversion terms (cap, discount)
- The new round's share price divided into your SAFE investment amount determines your share count
- Post-conversion, track the equity value based on share count times current share price
Watch for: Pre-money vs post-money SAFE differences. A $10 million pre-money cap produces more shares for you than a $10 million post-money cap, which can mean a 15 to 25 percent difference in your converted position.
Partial Exits
When you sell part of your position (through secondary sales or partial distributions), the calculation splits into realized and unrealized components.
Tracking approach:
- Record the partial distribution as a positive cash flow with its date and amount
- Reduce the current estimated value of your remaining position
- MOIC = (distributions received + remaining value) / total invested
- IRR includes the partial distribution as a cash flow at its actual date
Write-Offs
When an investment goes to zero, record it as a current value of $0. Do not remove it from your portfolio calculations.
Why this matters: Excluding failed investments from your portfolio metrics overstates your actual performance. Your portfolio MOIC, IRR, and ROI should reflect the reality of all capital deployed, including losses.
Currency Considerations
For investments denominated in foreign currencies, decide on a consistent approach:
- Option A: Convert everything to your home currency at current exchange rates. This reflects your actual economic position but introduces currency fluctuation into your return calculations.
- Option B: Track investments in their original currency and separately calculate currency impact. This is more complex but separates investment performance from currency effects.
Most individual angels use Option A for simplicity.
Building Your Calculation Workflow
Step 1: Compile All Cash Flows
For each investment, list every cash movement with its exact date:
- Initial investment date and amount
- Any follow-on investments with dates and amounts
- Any distributions received with dates and amounts
- Current estimated value as of today's date
Step 2: Calculate Individual Investment Metrics
For each investment, compute MOIC, ROI, and IRR. Use the XIRR function for IRR, feeding it the complete list of date-amount pairs.
Step 3: Aggregate to Portfolio Level
Portfolio MOIC: Sum of all current values and distributions divided by sum of all investments.
Portfolio IRR: Run XIRR on the combined cash flows from all investments, treating the portfolio as a single entity. This produces a time-weighted return that accounts for when capital was deployed and when value was created.
Important: Portfolio IRR is not the average of individual IRRs. It is a separate calculation on combined cash flows and typically differs from the arithmetic average.
Step 4: Separate Realized and Unrealized
Report your metrics in three categories:
- Realized returns (from actual exits and distributions)
- Unrealized returns (based on current estimated values)
- Combined returns (total portfolio)
This transparency is important because unrealized returns are estimates that may not materialize.
Step 5: Validate Against Intuition
If your calculated returns seem surprisingly high or low, validate the underlying data. Common errors include:
- Missing a follow-on investment from the total invested amount
- Using a stale valuation that does not reflect a recent round
- Incorrectly calculating SAFE conversion shares
- Double-counting a partial distribution
Automating the Process
Manual return calculation is error-prone and time-consuming, especially for portfolios with follow-on investments, SAFE conversions, and partial exits. Portfolio management platforms like AngelHub calculate MOIC, IRR, ROI, and annualized returns automatically, updating in real-time as you add new valuations or record transactions.
The value of automation goes beyond time savings. It eliminates the formula errors that plague spreadsheet-based calculations and ensures that every metric reflects your complete, current data.
Conclusion
Calculating your true angel investment returns requires careful tracking of every cash flow, consistent handling of complex scenarios like follow-ons and conversions, and disciplined separation of realized and unrealized performance. The effort is worthwhile because accurate return data is the foundation for every meaningful portfolio decision. Whether you calculate manually or use automated tools, the key is consistency and completeness in your data.
Frequently Asked Questions
How do I value unrealized investments for return calculations?
Use the most recent independently validated valuation, typically the share price from the last priced round. If no recent round has occurred, use a conservative estimate based on company progress. Always note which investments are marked at cost versus marked up.
Should I include written-off investments in my portfolio IRR?
Yes. Excluding write-offs overstates your actual performance. Include the initial investment as a negative cash flow and a current value of zero. This ensures your IRR and MOIC reflect the real cost of failed investments.
How does the holding period affect which metric I should use?
For short holding periods (under 2 years), MOIC is more reliable because IRR becomes hypersensitive to timing. For longer holding periods, IRR provides useful context about capital efficiency. Always report both for a complete picture.
Can I benchmark my angel returns against public market returns?
Yes, using IRR. Compare your portfolio IRR against the annualized return of a relevant index (like the S&P 500) over the same period. This comparison shows whether your angel investing is generating returns above what you could have earned in public markets with the same capital.