How to Calculate Your Real Net IRR After Fees in a Private Fund: A Step-by-Step Guide

    A step-by-step guide to calculating your real net IRR using XIRR, capital account data, and an illustrative fee breakdown.

    ByJeff Barnes, MBA
    ·11 min read
    Reviewed by Jeff Barnes — CEO of Angel Investors Network · MBA · $1B+ in Capital Formation
    How to Calculate Your Real Net IRR After Fees in a Private Fund: A Step-by-Step Guide
    TL;DR: Fund marketing decks report gross IRR, which ignores management fees, carried interest, and fund expenses. Cambridge Associates has found that fund-level fees cost private equity investors an average of 616 basis points of annualized drag over a fund's life, and the gap widens further in strong-performing vintages. If you only read the headline IRR on a pitch deck, you are very likely looking at a number you will never actually receive. This guide walks through how to pull your real cash flows and calculate your own net IRR using XIRR, step by step.

    Key Takeaways

    • Gross IRR measures fund-level cash flows into and out of underlying portfolio companies before any fund-level fees are deducted. It is not what lands in your account.
    • Cambridge Associates data shows average fee drag of 616 basis points annually across PE vintages since 1986, and close to 959 basis points in the best-performing vintages, where carried interest eats more of the upside.
    • Net IRR requires XIRR, not simple IRR, because your capital calls and distributions almost never land on evenly spaced dates.
    • Your capital account statement and Schedule K-1, not the fund's pitch deck, are the only reliable sources for your actual net cash flows.

    You got the annual letter. It says the fund returned 22% gross IRR. You feel good about it for four minutes, until you open your Schedule K-1 and try to reconcile it against what you actually put in and got back. The two numbers rarely match, and the gap is not a rounding error. It is management fees, carried interest, fund expenses, and sometimes an entire second layer of fees if you accessed the fund through a feeder vehicle.

    This is not a criticism of any single manager. Gross IRR is a legitimate, standardized way to measure how well a general partner picked and managed underlying investments. It is also, by design, not the number that determines your bank balance. Institutional limited partners have pushed for years to standardize this distinction. The Institutional Limited Partners Association released an updated Reporting Template in January 2025, plus a companion Performance Template standardizing gross versus net IRR reporting, because GPs disclosed fees inconsistently enough that LPs could not calculate their own net position. If institutional LPs with dedicated back-office teams needed standardized templates to force this transparency, do not assume the deck in front of you is doing the math for you.

    What Gross IRR Actually Measures

    Gross IRR is the internal rate of return on the fund's cash flows to and from its underlying portfolio companies, before the fund deducts anything for running itself. It captures capital deployed into deals and capital returned from exits, sales, and dividends at the investment level. It ignores the management fee the GP charges to cover salaries and overhead, the carried interest the GP keeps once the fund clears its preferred return, and the legal, audit, and administrative expenses charged to the partnership.

    Cambridge Associates makes this distinction explicit in its own benchmarking methodology. Its research on private investment performance measurement notes that gross returns are "before any fees, expenses, or carried interest are deducted," while the net-to-LP figures it has published for decades are calculated after all three are removed. Two funds can report the identical gross IRR and hand their LPs meaningfully different net outcomes, because fee structures and the timing of calls and distributions are not identical.

    The Fee Layers Between Gross and Net

    Four things separate the number on the deck from the number in your account.

    Management fee. Typically 1.5% to 2.5% of committed capital during the investment period, sometimes stepping down to a lower rate or shifting to a percentage of invested, rather than committed, capital once the fund stops making new investments. Cambridge Associates' 2024 survey of private fund terms found management fees generally ranged from 1.0% to 2.5% of commitments, many with a step-down feature partway through the fund's life.

    Carried interest, or promote. The GP's share of profits, standard at 20%, paid only after the fund clears a preferred return, commonly 8% annually, owed first to LPs. Most funds use a "soft hurdle" with a 100% catch-up. As Carta explains in its guide to hurdle rates, once the 8% pref is paid, the GP receives 100% of the next distributions until its cumulative take equals 20% of profits distributed so far, at which point everything splits 80/20. The manager eventually earns carry on the entire profit, including the first 8%, not just the portion above the hurdle. A "hard hurdle," where the GP only earns carry above 8%, is rarer and more investor-friendly. Do not assume you have one without checking your limited partnership agreement.

    Fund expenses. Legal, fund administration, audit, and organizational costs charged to the partnership. Individually small, typically well under 1% annually, but real, and easy to overlook because they surface as a line item on the capital account statement rather than a headline percentage.

    Platform or feeder-fund fee. If you accessed the fund through a special purpose vehicle, feeder fund, or access platform, common on many online alternative investing platforms, there is often an additional fee layer on top of what the underlying fund already charges: its own management fee, often 0.5% to 1.5%, sometimes its own carry, and administrative costs for running the SPV. This layer is easy to miss because it sits between you and the fund, not inside the fund's own reporting.

    The Step-by-Step Method: Building Your Own XIRR

    The only way to know your real net IRR is to build the actual cash flow ledger between you and the fund, and run it through XIRR rather than a simple IRR calculation.

    A basic IRR function assumes cash flows happen at regular, evenly spaced intervals, typically annually. Capital calls and distributions in a private fund almost never work that way. You might get called for $125,000 in January, another $125,000 in July, then wait two full years for your first distribution. Microsoft's documentation describes XIRR as calculating the internal rate of return for a schedule of cash flows that is not necessarily periodic. It pairs your exact cash flow amounts with the exact calendar dates they occurred, then solves for the discount rate that zeroes out the net present value of that irregularly timed series. Feed a simple IRR function cash flows with uneven spacing and you get a number that looks plausible but misstates your actual holding period.

    Building your own XIRR takes four steps. List every capital call you funded, as a negative number, on the exact date the wire left your account, not the date on the call notice. List every distribution you received, as a positive number, on the date it hit your account, not the date on the distribution notice. If you came in through a secondary purchase or late closing, your first cash flow is your actual purchase price on your actual purchase date, not the fund's day-one economics. Your net IRR is specific to you, not the fund's earliest investors. Finally, drop the dated cash flows into a spreadsheet and run =XIRR(values, dates), which replaces the gross IRR you were handed with the one reflecting money that actually moved into and out of your account.

    Where to Find Your Real Numbers

    None of this works if you pull numbers from a pitch deck or an annual letter's headline stats page. Those are curated summaries, usually of gross performance or a hypothetical "model LP." The documents that show your actual net cash flows are your quarterly and annual capital account statements and your Schedule K-1. The capital account statement should show your beginning balance, contributions, distributions, allocated management fees, allocated fund expenses, and allocated carried interest for the period, rolling forward to your ending balance. ILPA's reporting template calls this the Capital Account Statement through the NAV roll structure, built because LPs could not reconstruct their own net economics from prior-generation reporting formats.

    If your GP does not send a document with dated, itemized contributions and distributions, ask for one, or reconstruct it from bank statements and wire confirmations. Your K-1 confirms profit and loss allocations for tax purposes but is not always date-granular enough on its own for an XIRR calculation. Combine both.

    A Worked Example: 22% Gross IRR to What, Net

    The following table is entirely illustrative: a hypothetical $500,000 commitment to a private fund with a 2% annual management fee on committed capital, $15,000 in cumulative fund expenses, an 8% preferred return with a 100% GP catch-up, and 20% carried interest under a European, whole-fund waterfall. None of the figures describe any real fund, sponsor, or investment.

    DateEventGross cash flow to LPFees / carry deductedNet cash flow to LP
    Jan 2019Capital call 1-$125,000None-$125,000
    Jul 2019Capital call 2-$125,000None-$125,000
    Jan 2020Capital call 3-$125,000None-$125,000
    Jul 2020Capital call 4-$125,000None-$125,000
    Jun 2022Distribution 1$190,000Mgmt fee + carry, pro-rata$158,667
    Jun 2023Distribution 2$280,000Mgmt fee + carry, pro-rata$233,825
    Jun 2024Distribution 3$370,000Mgmt fee + carry, pro-rata$308,982
    Dec 2024Final distribution$300,000Mgmt fee + carry, pro-rata$250,526
    Totals / results$1,140,000 in, MOIC 2.28x, IRR 21.59%$188,000 total drag$952,000 in, MOIC 1.90x, IRR 16.46%

    Run the gross cash flow column through XIRR and you get 21.59%, close enough to the "22% gross IRR" a marketing deck might round to and headline. Run the net cash flow column, after $60,000 in cumulative management fees, $15,000 in fund expenses, and $113,000 in carried interest earned through the waterfall, and XIRR returns 16.46%. That is a gap of roughly 513 basis points, consuming $188,000, or about 37.6% of committed capital, out of what would otherwise have been gross profit. The multiple moved from 2.28x to 1.90x on the same underlying deals. This spread sits inside the 300 to 500-plus basis point range that shows up repeatedly across real fee structures, and it would run wider still in a fund charging 25% or 30% carry, common in venture and growth equity, or with an added feeder-fund fee layer on top.

    The Risk of Skipping This Exercise

    Investors who anchor on gross IRR are not making a small rounding mistake. They are systematically overestimating what they will actually receive, often by hundreds of basis points a year compounded over a multi-year hold. That gap compounds into a real difference in ending wealth, not just a reported percentage. Cambridge Associates' research puts average fund-level fee drag at 616 basis points annually since 1986, and notes the drag runs even larger, near 959 basis points a year, across the five best-performing vintages it studied, because stronger performance hands the carry mechanism more profit to capture. A gross IRR figure quoted on a fundraising call tells you almost nothing about your own outcome until you know the fee structure, your entry timing, and how much profit sits above the preferred return hurdle. Build the XIRR yourself, from your own capital account statements, before you commit capital and again with every distribution. It is the only version of the number that actually appears in your bank account.

    Frequently Asked Questions

    What is the typical gap between gross and net IRR in a private fund?

    There is no fixed number because it depends on the fee structure, fund size, and how much profit the fund generates above its preferred return hurdle. Cambridge Associates has measured average fund-level fee drag around 616 basis points annually across private equity vintages since 1986, widening to nearly 959 basis points in the strongest-performing vintages, since more profit means more carried interest for the GP to collect.

    Why do I need XIRR instead of a simple IRR calculation?

    Simple IRR functions assume evenly spaced, typically annual, cash flows. Private fund capital calls and distributions almost never land on a neat annual schedule. XIRR uses the exact dates of every cash flow alongside the exact amounts, the only way to get an annualized return that reflects your actual holding period rather than an approximation based on a regular calendar.

    Where do I find the actual cash flow numbers I need, if not the fund's marketing materials?

    Use your quarterly and annual capital account statements and your Schedule K-1, not the pitch deck or the annual letter's headline performance page. The capital account statement should itemize contributions, distributions, allocated management fees, allocated expenses, and allocated carried interest for each period. If your GP's reporting does not break out dated, itemized cash flows, request one or reconstruct the ledger from your wire confirmations and bank statements.

    Does it matter if I invested through a secondary purchase or a late closing instead of the fund's first close?

    Yes, materially. Your net IRR is calculated from your own actual cash flows on your own actual dates, not the fund's day-one economics. If you bought into the fund on the secondary market or joined a later closing, your first cash flow is your actual purchase price on your actual purchase date. Investors who entered at different points in the same fund's life will calculate different net IRRs from the same portfolio.

    Author Disclosure: Jeff Barnes, MBA has no personal position in any company, fund, or platform named in this article. Angel Investors Network has no current commercial relationship with any party mentioned. AIN provides marketing and education services, not investment advice. Past performance does not guarantee future results. All investments involve risk, including loss of principal.

    Looking for investors?

    Browse our directory of 750+ angel investor groups, VCs, and accelerators across the United States.

    Share
    J

    About the Author

    Jeff Barnes, MBA