Investors

Internal rate of return calculator (IRR calculator)

August 4, 2022
Stephen Prihoda

Calculating the internal rate of return (IRR) is a way for VCs and investors to track the performance of private companies before other profitability metrics are available. The easiest way to determine IRR is with a spreadsheet-based internal rate of return calculator.   

What is IRR?

The internal rate of return (IRR) shows the annualized percent return an investor’s portfolio company or fund has earned (or expects to earn). 

Gross IRR vs. net IRR

There are two ways to measure IRR:

  • Deal IRR (also known as gross IRR): Measures the return from a fund’s portfolio. This is a common way to determine how successful the general partners’ (GPs’) investments are to date. 
  • Net IRR: Measures the return from limited partners (LPs) minus any management fees or carried interest. This is used to measure the value of the investment. 

How to calculate IRR

Using a spreadsheet-based IRR calculator or dedicated fund administrator like Carta is the best way to quickly calculate IRR. 

IRR calculator illustration


Download the IRR calculator

Internal rate of return formula

The formula to calculate IRR looks like this:

IRR calculation formula

You can calculate IRR by setting NPV to zero and solving for the discount rate. However, doing complex calculations manually leaves more room for error.

Why is IRR important?

Benchmarking is comparing your IRR to the industry comparables to see your relative performance against your peers. This helps funds measure the effectiveness of their deals and their performance against other funds.

Unlike other forms of performance measurement, like return on investment (ROI) and net present value (NPV), IRR allows you to make apples-to-apples comparisons across asset classes and public market indexes—no matter the time frame.

IRR is also an important metric that LPs look at when you’re raising money for your fund—if you consistently show excellent returns on your investments, it may be easier to attract investors.

What is a good IRR?

What’s considered a “good” IRR can vary based on the type of investment you’re making. In general, many early-stage investors target a 30% net IRR, while many later-stage investors target a net IRR of around 20% (both, over an average period of eight years). However, some investors aim higher.

Get help calculating your IRR

While an IRR calculator is more efficient than calculating your IRR manually, it still leaves room for errors. Some of the most common mistakes people make include entering the dates and amounts wrong.

Go beyond our IRR calculator and automate the process with Carta’s fund admin service. We sync our general ledger daily and calculate everything for you so you can access your real-time IRR.

Learn more about Carta for Venture Capital, or talk to an expert about Carta fund admin today.

This blog post was originally published on October 24, 2019.

DISCLOSURE: This communication is on behalf of eShares Inc., d/b/a Carta Inc. (“Carta”). This communication is for informational purposes only, and contains general information only. Carta is not, by means of this communication, rendering accounting, business, financial, investment, legal, tax, or other professional advice or services. This publication is not a substitute for such professional advice or services nor should it be used as a basis for any decision or action that may affect your business or interests. Before making any decision or taking any action that may affect your business or interests, you should consult a qualified professional advisor. This communication is not intended as a recommendation, offer or solicitation for the purchase or sale of any security. Carta does not assume any liability for reliance on the information provided herein.

©2019–2022 eShares Inc., d/b/a Carta Inc. (“Carta”). All rights reserved. Reproduction prohibited.