IRR Calculator: method, checked example and practical limits
Solve the periodic internal rate of return that sets a series of cash flows to net present value zero. IRR summarizes a cash-flow pattern; the period of the answer is the period represented by successive entries.
Inputs used by this calculator
IRR Calculator uses the fields below. The starting values reproduce the page example; replace them with values from the same units and time period before using the result.
| Input | Starting example | Accepted value | How it is used |
|---|---|---|---|
| Cash flows from period 0 | -10000, 2500, 3000, 3500, 4000 | Text or a list in the format shown | Selects the unit or conversion path used by IRR Calculator. |
| Initial guess (%) | 10 | -99.9 to 1000 | Supplies the initial guess (%) quantity used by the published equation or result breakdown. |
Inputs and measurement conventions
The quantities used on this page are Cash flows from period 0, Initial guess (%). Start with values for the same situation and read the units attached to each field. The field reference below shows supported choices and numerical limits.
Mixed positive and negative flows can create multiple roots. An annual interpretation is valid only when entries are annual.
Method and equation
Find a periodic discount rate at which the entered equally spaced cash flows have zero net present value.
IRR Calculator uses the following stated relationship: 0=Σ CFₜ/(1+IRR)^t. Its assumptions determine which question the answer can resolve.
0=Σ CFₜ/(1+IRR)^tWorked calculation with the starting values
Cash flows from period 0: -10000, 2500, 3000, 3500, 4000; Initial guess (%): 10. These starting values give 10.48452948 % periodic IRR. The calculation breakdown is Cash-flow periods: 4; NPV at solved rate: 0.000000000004547473509; Cumulative undiscounted cash flow: 3,000.
An initial −$10,000 followed by four positive cash flows is solved for the discount rate where NPV equals zero.
Reading the answer
IRR summarizes a cash-flow pattern; the period of the answer is the period represented by successive entries.
Cash-flow periods: 4; NPV at solved rate: 0.000000000004547473509; Cumulative undiscounted cash flow: 3,000. These intermediate quantities make the stated IRR Calculator model inspectable; they should be read together with the main answer rather than treated as independent guarantees.
Common errors and model boundaries
Mixed positive and negative flows can create multiple roots. An annual interpretation is valid only when entries are annual.
Cash-flow patterns with more than one sign change can have multiple IRRs or none; compare NPV at an appropriate hurdle rate.
Independent verification and next decision
Yes. More than one sign change can produce multiple solutions, so compare NPV at a relevant hurdle rate.
For the IRR Calculator method, compare 0=Σ CFₜ/(1+IRR)^t with the starting inputs and the calculation table. The linked Consumer Financial Protection Bureau: consumer tools and Investor.gov (SEC): compound interest calculator references identify the relevant definitions, conventions or domain limitations. Retain intermediate precision when comparing a manually worked answer.
IRR Calculator worked-example ledger
| Quantity | Example value | Role |
|---|---|---|
| Cash flows from period 0 | -10000, 2500, 3000, 3500, 4000 | Entered assumption |
| Initial guess (%) | 10 | Entered assumption |
| Main answer | 10.48452948 % periodic IRR | Calculated from the starting inputs |
| Cash-flow periods | 4 | Intermediate or contextual output |
| NPV at solved rate | 0.000000000004547473509 | Intermediate or contextual output |
| Cumulative undiscounted cash flow | 3,000 | Intermediate or contextual output |
Frequently asked questions
Can a project have more than one IRR?
Yes. More than one sign change can produce multiple solutions, so compare NPV at a relevant hurdle rate.
Which relationship does the IRR Calculator use?
Find a periodic discount rate at which the entered equally spaced cash flows have zero net present value. The displayed relationship is 0=Σ CFₜ/(1+IRR)^t.
What do the starting values produce in the IRR Calculator?
Cash flows from period 0: -10000, 2500, 3000, 3500, 4000; Initial guess (%): 10. These starting values give 10.48452948 % periodic IRR. The calculation breakdown is Cash-flow periods: 4; NPV at solved rate: 0.000000000004547473509; Cumulative undiscounted cash flow: 3,000.
How should I interpret this IRR Calculator answer?
IRR summarizes a cash-flow pattern; the period of the answer is the period represented by successive entries.
Which input mistake most affects the IRR Calculator?
Mixed positive and negative flows can create multiple roots. An annual interpretation is valid only when entries are annual.
What is outside this IRR Calculator model?
Cash-flow patterns with more than one sign change can have multiple IRRs or none; compare NPV at an appropriate hurdle rate.
What to keep in mind
Cash-flow patterns with more than one sign change can have multiple IRRs or none; compare NPV at an appropriate hurdle rate.
Results are rounded for display in US format, with money in dollars and cents; CSV exports keep full calculation precision. This is a calculation summary, not an official certificate.