How to Calculate XIRR for Angel Investments with Follow-Ons and Partial Exits

Why Regular IRR Falls Short for Angel Investors

XIRR calculation for angel investing is one of those topics that seems simple until you actually try it. If you have ever plugged your angel investment returns into a standard IRR formula and gotten a result that felt wrong, you are not alone. The standard IRR function assumes that cash flows occur at equal intervals - monthly, quarterly, or annually. Angel investing does not work that way.

You might write a $50,000 check in January, make a follow-on investment fourteen months later, receive a partial distribution from a secondary sale the following summer, and finally exit three and a half years after your initial investment. Nothing about that timeline is evenly spaced. Standard IRR forces your irregular cash flows into a rigid periodic structure, distorting the result.

XIRR solves this problem. The XIRR calculation accounts for the exact dates of each cash flow, giving angel investors an accurate annualized return that reflects what actually happened.

XIRR vs IRR: What Is the Difference?

The distinction is straightforward but critical.

IRR calculates the annualized return assuming all cash flows are equally spaced. If you provide five cash flows, it assumes they are five consecutive periods apart - regardless of whether those periods are months, quarters, or years.

XIRR calculates the annualized return using the actual dates of each cash flow. It weights each dollar by the precise amount of time it was deployed or received.

For angel investors who deploy capital irregularly, make follow-on investments at unpredictable intervals, and receive distributions on no fixed schedule, the XIRR calculation is the only approach that produces a meaningful annualized return. MOIC tells you the multiple on your money. XIRR tells you how fast your money grew.

The XIRR Formula

XIRR finds the annualized discount rate (r) that makes the net present value of all cash flows equal to zero:

NPV = Sum of [Cash Flow_i / (1 + r) ^ ((Date_i - Date_0) / 365)] = 0

Where each cash flow is discounted by the exact fraction of a year between its date and the first date. The function solves for r iteratively - there is no closed-form solution. Most implementations use the Newton-Raphson method, making successive approximations until the NPV converges to zero within a small tolerance.

You do not need to understand the iterative math to use XIRR. Excel, Google Sheets, and platforms like AngelHub handle the computation for you. What matters is understanding what goes in and how to interpret what comes out.

Worked Example 1: Simple Investment and Exit

Now that we have covered the theory behind XIRR calculation for angel investing, let us walk through concrete examples. Start with the simplest case - a single investment followed by a single exit.

The MOIC here is 3.5x ($175,000 / $50,000). That tells you the multiple but nothing about the time dimension.

The XIRR calculation yields approximately 41.2% annualized. Your capital was deployed for about 3.5 years, and the 3.5x multiple translates to a 41.2% compound annual return.

Now consider the same 3.5x multiple over different time horizons. If the exit had occurred after 7 years instead of 3.5, the XIRR would drop to roughly 19.2%. Same multiple, half the annualized return. This is why XIRR matters - it forces you to account for the time value of your capital.

Worked Example 2: Follow-On Investments

Most active angels make follow-on investments. Here is a more realistic scenario with multiple capital deployments.

Total invested: $90,000. Total received: $350,000. MOIC: 3.89x.

The XIRR for this set of cash flows is approximately 55.8%.

Notice that the XIRR is higher than the simple case even though the overall timeline is similar. Why? Because the follow-on capital was deployed for shorter periods. The $25,000 invested in March 2023 only worked for 2.3 years before exit, and the $15,000 bridge capital worked for less than a year. Shorter deployment periods for those follow-on dollars amplify the annualized return.

This is an important insight for portfolio construction. Follow-on investments into winners that exit relatively quickly can dramatically improve your portfolio XIRR, even if they do not change the total dollar profit by much. Every additional dollar you invest later in the timeline increases the denominator for a shorter duration, pulling the XIRR upward when the exit is favorable.

Worked Example 3: Partial Exits and Unrealized Positions

Real angel portfolios rarely have clean single-exit outcomes. Secondary sales, tender offers, and partial distributions create complex cash flow patterns. Here is how to handle them.

Total invested: $50,000. Total received (realized): $90,000. Unrealized: $80,000. Combined value: $170,000. MOIC: 3.4x.

The XIRR for this set of cash flows is approximately 42.7%.

The critical question: how do you handle the unrealized $80,000? The standard approach is to treat it as a hypothetical cash flow on the valuation date - in this case, today. You include it as a positive cash flow on the date of your most recent valuation.

This is a necessary simplification, but you should understand its limitations. The unrealized position is not cash in your pocket. The actual exit value could be higher, lower, or zero. When reporting your XIRR, distinguish between fully realized XIRR (using only actual cash flows) and blended XIRR (including unrealized positions at estimated value).

For this example, the fully realized XIRR using only the $30,000 and $60,000 distributions would be approximately 30.1% - materially lower than the blended figure. Both numbers are useful. The realized XIRR tells you what you have actually earned. The blended XIRR tells you what you are on track to earn if current valuations hold.

Common XIRR Calculation Mistakes Angel Investors Make

1. Incorrect cash flow signs. Outflows (investments) must be negative. Inflows (distributions, exits) must be positive. Reversing the signs will either produce an error or a nonsensical result.

2. Using periodic IRR for irregular cash flows. If your spreadsheet has an IRR function and an XIRR function, use XIRR. The periodic IRR will misstate your return unless your cash flows genuinely occur at equal intervals.

3. Ignoring fees and carry in net XIRR. If you invest through a fund or SPV that charges management fees or carried interest, your gross XIRR and net XIRR will differ. Always calculate your net XIRR by using the actual cash flows you sent and received, after all fees.

4. Treating unrealized gains as certain. As discussed above, unrealized positions introduce estimation risk. A startup's last-round valuation may not reflect what you would receive in an actual sale. Be conservative with unrealized marks, and always report your realized XIRR alongside the blended figure.

5. Ignoring currency conversion timing. If you invested in a company denominated in euros but track your portfolio in dollars, the exchange rate on the date of each cash flow matters. Use the actual conversion rate on each transaction date, not the current rate applied retroactively. For more on which metrics to track monthly, see our metrics guide.

XIRR in Excel and Google Sheets

Setting up the XIRR calculation in a spreadsheet takes about two minutes.

Step 1: Create two columns - one for dates, one for cash flows.

Step 2: In any empty cell, enter the formula:

=XIRR(B1:B4, A1:A4, 0.1)

The third argument (0.1) is an initial guess for the solver. In most cases, the default of 0.1 (10%) works fine.

Step 3: Format the result as a percentage.

Troubleshooting #NUM! errors: XIRR returns a #NUM! error when it cannot converge on a solution. Common causes include all cash flows having the same sign (no investments or no returns), dates that are not in chronological order, or extreme return scenarios. Try adjusting the guess parameter - use 1.0 for high-return investments or -0.5 for loss scenarios. If the investment is a total loss, XIRR will return -100%, which is correct.

Portfolio-Level XIRR

Individual XIRR calculations are useful, but portfolio-level XIRR tells you how your entire angel investing program is performing. Understanding how to calculate your true angel investment returns at the portfolio level is essential.

How to calculate it: Aggregate every cash flow across all investments into a single chronological list. Every check you wrote is a negative cash flow on its date. Every distribution you received is a positive cash flow on its date. For unrealized positions, add a positive cash flow for each position's current estimated value, all dated as of your valuation date.

Apply XIRR to this entire list to get your portfolio-level annualized return.

Why portfolio XIRR differs from averaging individual XIRRs: Averaging the XIRR of each investment ignores the relative size and timing of each position. A 200% XIRR on a $5,000 investment matters far less to your portfolio than a 30% XIRR on a $100,000 position. Portfolio-level XIRR automatically weights each cash flow by its dollar amount and timing, giving you a single figure that reflects your actual capital-weighted performance.

Tools like AngelHub calculate portfolio XIRR automatically, aggregating all your cash flows and unrealized positions without requiring manual spreadsheet work.

Key Takeaways

• XIRR calculation is essential for angel investors. Standard IRR assumes equal periods between cash flows. Angel investing cash flows are inherently irregular, making XIRR the only accurate annualized return metric.

• Follow-on investments compress the time dimension. Capital deployed later in a deal's lifecycle is at work for a shorter period, which can significantly increase XIRR when the outcome is positive.

• Partial exits create complex but manageable cash flows. Treat each distribution as a separate positive cash flow on its actual date. XIRR handles multiple inflows and outflows naturally.

• Always distinguish realized from blended XIRR. Unrealized positions are estimates, not guaranteed returns. Report both figures to maintain intellectual honesty about your performance.

• Portfolio XIRR is more meaningful than individual averages. Aggregate all cash flows across your entire portfolio for a single capital-weighted annualized return that reflects how your angel program is actually performing.

• The spreadsheet setup takes two minutes. Two columns (dates and cash flows), one formula. There is no reason to rely on MOIC alone when XIRR is this accessible.

Frequently Asked Questions

Can XIRR be negative?

Yes. If your total distributions and current unrealized value are less than your total invested capital, XIRR will return a negative percentage. A total write-off returns -100%. Partial losses return a negative XIRR between 0% and -100%.

How often should I recalculate portfolio XIRR?

Quarterly is standard practice for most angel investors. Recalculate whenever you make a new investment, receive a distribution, or update the estimated value of an unrealized position. Automated tools recalculate in real time as you enter new data.

Does XIRR account for the J-curve in early-stage investing?

XIRR reflects whatever cash flows you provide. Early in an angel portfolio's life, XIRR will typically be negative or low because you have deployed capital with no exits yet. As exits occur, XIRR adjusts upward. This naturally captures the J-curve pattern without any special handling.

What XIRR should angel investors target?

Once you have your XIRR calculation for angel investing set up correctly, you will want benchmarks. Top-quartile angel portfolios generate net XIRRs in the 20% to 35% range over a full cycle (7 to 10 years). Individual investments in a strong portfolio may range from -100% (write-offs) to several hundred percent. The portfolio-level figure is what matters for assessing your overall program.