Your files stay on your device

# XIRR calculator

Get the annualised return for dated cash flows on the actual/365 convention, with a discounted flow table and the solver's steps shown.

Paste dated flows to solve the annualised return.

This is the spreadsheet XIRR definition: each flow is discounted at an actual/365 day count from the first date, and the rate that brings the discounted column to zero is the annualised return. It is not CAGR, which needs one in and one out on fixed dates, and it is not a calendar-year return. Rates above 100,000,000 percent are refused; one-day windfalls annualise to numbers that large anyway.
Options

## More unit & math tools

- [API cost estimator](/ai/cost-estimator)
- [Average and median](/converters/statistics)
[All unit & math tools](/converters)

Was this tool useful?
YesNo

---

Canonical HTML: https://nutter.tools/converters/xirr-calculator
Markdown version: https://nutter.tools/converters/xirr-calculator.md
Plain-text version: https://nutter.tools/converters/xirr-calculator.txt
Agent index: https://nutter.tools/llms.txt