IRR

FinancialExcel 2007

The internal rate of return of periodic cash flows.

Syntax

IRR(values, [guess])

How it works

`values` must include at least one negative (outflow) and one positive. Assumes equal spacing — use XIRR for real dates.

Examples

=IRR(C2:C14)

→

Related functions

XIRR NPV RATE

More Financial functions

ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.