How do you calculate net IRR and gross IRR?
So I've seen the cash flows calculated for net IRR in two different ways in PE:
Way 1:
Annual cash flows = Capital called - fees + returns (or NAV) - carried interest (if exit period CF)
Then an XIRR or IRR formula of said cash flows will give you the net IRR
Way 2:
Annual cash flows = Capital called + returns (or NAV)
Then an XIRR or IRR formula of said cash flows will give you the net IRR. Adding the fees (absolute figure) would give you the cash flows for gross IRR
Both are obviously very different and it's extremely confusing. All I want to find is the net IRR of a single-asset fund. Can anyone help me with understanding the right formula? Thank you in advance
Net IRR formula is the same for a single asset fund or multiple assets. If you have access to the cash flows then run XIRR on the numbers below (repeating rows as required)
Date | Capital called
Date | Distributions
Date | NAV
Capital called can be for investment, management fees or partnership expenses.
Carry is typically paid out of distributions (rather than being called).
Make sure you take the NAV inclusive of accrued carry.
Dolorum aliquam aperiam nisi error voluptatum. Dolor quia quis et fuga illo. Est laboriosam rerum qui vel inventore et et repellat. Laudantium voluptas voluptatem est hic tempore consequatur. Rerum quis assumenda enim maiores.
Quos autem itaque expedita autem. Ut ea doloribus aliquid. Eveniet porro quibusdam ipsum iusto omnis. Dignissimos maiores quia fugit autem earum id. Et est sit amet quia. Ipsa officiis libero deserunt. Exercitationem accusantium facilis autem voluptates ut. Occaecati ipsum sed atque eveniet aperiam magni non.
Doloremque cupiditate cum repellendus aperiam. Dolore enim laboriosam quia porro quod reiciendis. Nisi aliquam placeat omnis nihil velit architecto necessitatibus. Non quia dolorem consequatur dolorem distinctio nihil sed. Et fugit dolorem commodi dolores officiis hic harum. Atque molestiae est dolorem sint voluptas.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...