Function Type: Financial


Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

Function Structure:

=XIRR(values, date, [guess]).

Argument Breakdown:

values – This is the array of values that represent the series of cash flows. Instead of an array, it can be a reference to a range of cells containing values.

date – This is a series of dates that correspond to the given values. Subsequent dates should be later than the first date, as the first date is the start date and subsequent dates are future dates of outgoing payments or income.

guess – This is an initial guess – or estimate – of what the IRR will be. If omitted, Excel takes the default value of 10%.


If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: