How to calculate
Solve the NPV equation for a periodic rate. Cash flows with several sign changes can have more than one valid rate.
Worked example
Use Signed cash flows starting at period zero (USD) -1000, 0, 1210. The result is ≈ 10 %.
Input and result notes
Use equally spaced cash flows. The search ranges from about −99.999999 percent to 10 billion percent. Use up to 33 entries for cash flows with multiple sign changes.
OpenStax on internal rate of return