XIRR(G, V, D)

 

Description

This function returns the internal rate of return for a series of cash flows (V) with variable intervals (D).  V and D must be one-dimensional ranges and have the same size.

 

Parameters

 

G

An estimated value of the result.

 

V

A range containing a series of cash flows.

 

D

A range containing the dates of cash flows in V.

 

Examples

 

Given:

 

 

XIRR(0.5, B1:B5, A1:A5) = 0.3632