What the calculator returns
A unique result is labeled IRR (annualized, Actual/365). Monetary outputs use USD formatting. The result also includes a cash-flow table and convergence information; it does not display a formula, assumptions panel, or intermediate discounted-value column.
Enter dated cash flows
Use the Cash-flow table to enter a date and numeric amount for each cash flow. The Label (optional) field can identify a row, and Amount ($) accepts the cash-flow value.
- Enter a valid date and numeric amount for each cash flow. Add a label if it helps identify the row.
- Use negative values for outflows and positive values for inflows.
- Select Add cash flow for another row. Select Remove row to delete an unwanted row.
- Select Calculate IRR when you have at least two valid cash flows, including at least one negative and one positive amount.
Fully empty rows are skipped. A row with only a date or only an amount is not skipped and triggers a validation message.
Review the result and convergence report
Timing uses the actual number of days from the earliest date, divided by 365. For a unique result, review the annualized IRR, the residual NPV at IRR, and the number of recorded iterations. The convergence summary states whether the solver reached its tolerance; the displayed count is not always a successful-convergence count.
The visible Cash-flow table contains Date, Label, Amount (sign convention), Days from t=0, and Time (years, Actual/365).
The Convergence report lists iteration, method, candidate rate, and NPV at the candidate rate for a unique result. It can state that tolerance was not reached within 100 iterations while still showing the best estimate. Multiple-root and no-solution results do not show iteration rows.
Understand multiple-root and no-solution results
A multiple-root result means more than one candidate rate was found in the scanned range. The notice recommends comparing NPV at your required rate because no single IRR is reported.
A no solution result means that no sampled sign-change bracket was found in the scanned range. It does not establish that no root exists outside that range or between samples.
Calculation scope and limitations
The script scans from -99.99% to 10,000% in 4,000 sampled intervals and refines brackets where sampled NPV values change sign. It uses a safeguarded Newton step. Bisection is used when the derivative is zero or non-finite, or when the Newton step leaves the current bracket.
The inspected calculator script uses the dates and amounts entered in the form for the calculation. Broader page-level data handling is not established by this script.
Export or reset the calculation
- Select Copy result to copy the generated result.
- Select Download result (.txt) to download the result as plain text.
- Select Reset to clear the current entries and result.
Frequently Asked Questions
What is IRR and how is it calculated here?
IRR is the annualized rate that makes the net present value of the entered cash-flow series equal to zero. The calculator solves for it numerically with safeguarded Newton steps and a bisection fallback when the derivative is zero or non-finite, or the Newton step leaves its bracket.
What day-count convention does this calculator use?
It uses Actual/365. Each cash flow's time is the actual number of days from the earliest entered date divided by 365.
What is shown in the convergence report?
For a unique result, it shows each recorded iteration with its method, candidate rate, and NPV. The summary states whether tolerance was reached within 100 iterations. Multiple-root and no-solution results omit iteration rows.
Why does IRR sometimes have no solution or more than one solution?
The calculator scans only -99.99% through 10,000% and looks for sampled sign changes in NPV. A no-solution result means it found no such bracket in that range. A multiple result means it found more than one distinct root bracket there; multiple sign changes in the cash-flow sequence alone do not guarantee that result.
Does this tool use live rates or personal data?
The calculator script uses the dates and amounts entered in the form to perform the IRR calculation. The result is a mathematical calculation, not personalized financial or investment advice. Broader data-handling behavior is not established by this calculator script.