Home        Online Calculators        Personal Finance        Corporate Finance        Spreadsheet Models        Derivatives   
APR Calculator
Payday Loan Calculator
Savings Calculator
EMI Calculator
EMI Rate Calculator
EMI Comparison Tool
Mortgage Calculator
Interest Rate Converter
FD Calculator
RD Calculator
CD Calculator
Present Value Calculator
IRR Calculator
XIRR Calculator
NPV Calculator
Bond YTM Calculator
Zero Coupon Bond Yield
Option Price Calculator
Implied Volatility Calculator
UK Tax Calculator

XIRR Calculator

Use this calculator to calculate IRR of cash flows with non uniform intervals i.e., cash flows occurring at irregular intervals. Enter cash flows below with cash flow dates and corresponding cash flow amounts and the calculator calculates annualized internal rate of return (IRR) of the cashflows. The result produced by this calculator is equivalent to the one you get when using Micorsot Excel's XIRR function.

Cash flow date Amout of cash flow

The first two cash flow dates and cash flow values are mandatory for XIRR calculation. After entering the initial cash flow date, make sure that the subsequent cash flow dates are later than the first cash flow date; however they need not be sequential. The first cash flow value has to be entered with negative sign (being cash outflow). Subsequent cash flows values can be negative but there has to be at least one positive value (cash inflow). The calculator uses iterative process to calculate IRR and therefore it may sometimes fail to find an IRR if the cashflow dates and values have extreme values.

XIRR Calculation logic explained

MIRR Calculation in Excel

IRR Calculation in Excel

Use IRR Calculator for cash flows with uniform intervals