Enter premiums (outflows) and benefits/maturity amounts (inflows). The IRR is the rate r where NPV = 0. Choose the cashโflow frequency; weโll show the period IRR and the equivalent annual effective rate.
Add repeated premiums automatically
Premiums are entered as negative cash flows. Weโll add #periods rows: period t = start, start+1, โฆ
How IRR is computed
NPV equation
NPV(r) = ฮฃ cft/(1+r)t. We solve for r where NPV = 0 using Newtonโs method with a bisection fallback. If all cash flows are the same sign, IRR is undefined.
Annual effective
If you choose monthly frequency and the period IRR is i, we show annual effective = (1+i)12 โ 1. Likewise for other frequencies.
โ
Enter cash flowsStatus
Add at least one negative (premium) and one positive (benefit) cash flow.
Tips
Multiple sign changes can produce multiple valid IRRs. We report the principal root we bracket. For irregular dates (XIRR), tell me and Iโll add a dateโbased mode.
Manual copy (clipboard blocked)
Your browser blocked clipboard access. You can manually copy the summary below or download it as a text file.