Formula Library

IRR

financial

Returns the Internal Rate of Return for a series of cash flows — the discount rate that makes NPV equal to zero.

Syntax

=IRR(values, [guess])

Example

Excel
=IRR(A2:A7)

Calculates the IRR for cash flows in A2:A7, where A2 is typically the initial investment (negative) and A3:A7 are returns.

Tips & Notes

  • →First value should be negative (the initial investment)
  • →Result is a rate per period — annualize if needed
  • →Use XIRR for irregular (non-periodic) cash flows

See Also

NPVFVPMT

Need a custom IRR formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.