XIRR

The XIRR function returns the internal rate of return for an investment that is based on a series of irregularly spaced cash flows.

XIRR(payments, dates, guess)

payments: A range of cells that contain the payments for the investment.

dates: A range of cells that contain dates that correspond to the cash flows in payments.

guess: An optional value that indicates an estimate for the internal rate of return.

Example

Given the following table:

Cash flow

Date

A

B

1

-7,000

01/01/2019

2

3,000

03/02/2019

3

2,500

05/17/2019

4

1,000

08/26/2019

5

2,000

10/27/2019

=XIRR(A1:A5,B1:B5) returns the approximate internal rate of return of 58.496548%.

See alsoXNPVIRRNPERPVNPV
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.