Better Sheets

How to Use XIRR() in Google Sheets

Description

Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.

How To Actually Use XIRR() in Sheets

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

Try XIRR yourself

Use the XIRR formula to calculate the internal rate of return for the cash flows in the range A1:A5 and their corresponding dates in B1:B5. The result should be displayed in cell C1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the XIRR() formula:

Generate a XIRR() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses XIRR(). 2 free AI generations, no signup. Members get unlimited use.

Generate a XIRR() formula