What is an internal rate of return

Key takeaways

  • The IRR is a measure of investment performance commonly used by finance professionals to assess and compare different investment opportunities.
  • It is usually calculated through an Excel spreadsheet function and can be loosely defined as the annual rate of growth that an investment is expected to generate.
  • Financial instruments are inherently risky, and target investment goals can be missed in both public and private market investments.

What is an IRR

The targeted IRR – or internal rate of return – can be utilized as a standard metric to evaluate and compare different investment opportunities. Financial textbooks define it as the discount rate for which the net present value of an investment’s cash flows is equal to zero. In other words, if you discount the future projected income from an investment by the IRR, your investment returns would be equal to zero.

The tables below provide a more intuitive explanation. 

Investment A:

InvestmentYear 1 incomeYear 2 incomeYear 3 incomeYear 4 incomeYear 5 income
-10,000+700+500+700+750+10,000+700

IRR = 6.67%

Investment B:

InvestmentYear 1 incomeYear 2 incomeYear 3 incomeYear 4 incomeYear 5 income
-10,000+1000+1000+450+200+10,000+700

IRR = 6.89%

For both investments, the Year 1-4 cash inflows are the incomes generated each year by the investment. The last inflow is the principal – the value of the investment – at maturity plus the 5th income payment. 

Notice, however, that these two investments have different internal rates of return. The reason is the timing of the cash flows – for the second investment, earlier cash flows increase the compounding rate – and therefore final returns. 

The IRR value cannot be manually calculated. It is obtained by using a financial calculator, or an Excel formula. If you want to try it at home, here’s the Excel formula:

=IRR({-10000,700,500,700,750,10700}) for Investment A.

=IRR({-10000,1000,1000,450,200,10700}) for Investment B.

What are the benefits of using IRR

Calculating the IRR of an investment provides an intuitive way to compare potential returns with the prevailing risk-free rate, and quickly understand whether the allocation of capital is likely to offer positive returns. For instance, if the prevailing risk-free rate for an investor is 7%, neither investment A nor investment B appear to be viable options – rather, the investor will lend his money at 7% risk-free. Additionally, by comparing IRRs from different assets, the investor can decide which return is projected to be higher and select the likely best opportunity. 

This is usually easier said than done: in reality, most investors cannot lend at the prevailing rate – a bank normally lends money from investor deposits, earning the return and passing on just a fraction of it to its customers. But despite the practical blunders, the IRR remains a good benchmark to see if an investment is delivering, compared with other opportunities. 

It is important to remember that an IRR does not take into account the time value of money. Indeed the “risk-free” rate, which is the rate used to discount future cash flows, is the benchmark against which the IRR can be assessed. It is also worth mentioning that this metric provides only a snapshot of the expected investment performance, and does not give investors any indication of its volatility or price fluctuations.

Yieldstreet’s “target rate of return”

While investors or analysts can carefully vet the risk-return profile of an investment, and make a recommendation based on their best knowledge and information, the risk of the investment not performing according to projections is inherent to any investment opportunity – regardless of whether the allocation is in private or public markets. As we’ve seen repeatedly in the past, publicly traded stocks can go to zero, Argentina can default on a sovereign issue, oil can go negative and even the most respected names in the hedge fund industry can suffer heavy losses.  

As the investment memorandum for one of our real estate opportunities recites: 

“The target internal rate of return of investors in the Issuer (“Investors”) is {a certain percentage}, net of Management Fees, Flat Expense and structuring fees, with an expected {x} equity multiple…”

The IRR is typically just a target, a calculation based on cash inflows expected from a certain investment. 

As we mention in our investment documentation: 

Any projected return or estimate for an Issuer’s investment is only a target … The Issuer and the Manager have no way of knowing or predicting whether such target return is realistic and achievable or whether such return will ever be realized for an investment. 

While Yieldstreet cannot guarantee that investments will perform as expected, it has so far returned over $1.5 billion dollars, and the net annualized IRR of its matured investment as of April 2022 is 9.71%



How helpful is this content?

Was this content helpful?

Sign up with Yieldstreet and be the first to know about our latest offerings, recent news, upcoming events, and more.

Your email will never be shared and will only be used for Yieldstreet updates. Already a Yieldstreet member? You're already set up to be notified.

Share this article:

Join a community of 350,000+ members

  • Gain access to unique offerings previously reserved for the ultra-wealthy

  • Customize your portfolio for income, growth, or a balance of both

  • Get started today and earn an average IRR of over 8%

What investors are saying about Yieldstreet

Apr 2022

The due diligence, risk management, and product education materials are thorough, excellent, and easy to use and understand.

Manoj J
Member since 2019
Apr 2022

Excellent and unique selections that I can't find elsewhere.

Jonathan S
Member since 2019
Apr 2022

The platform delivers in a very concise manner. Easy to get a clear understanding at a glance from the web or mobile app.

Tim S
Member since 2021
The testimonials presented on this page have been provided by actual investors in Yieldstreet funds without compensation. Yieldstreet has selected the testimonials, and certain testimonials have been edited to remove personally identifiable information and for brevity. Testimonials were not selected based on objective or random criteria, but rather were selected based on Yieldstreet's understanding of its relationship with the providers of the testimonials. The uncompensated testimonials presented here may not be representative of other investors' experiences, and there can be no guarantee that investors will experience future performance or success consistent with the testimonials presented.

The Yield

Our weekly podcast providing ideas about how to make money work for you and bring you closer to your dreams.

Since inception, over $2.5B has been invested on Yieldstreet

Join today for free to access alternative investment opportunities.