Formulas and Functions
ह्या कंट्रोलमध्ये बदल केल्यामुळे हे पेज ऑटोमॅटिकली अपडेट होईल

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

17/05/2019

4

1,000

26/08/2019

5

2,000

27/10/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.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.