How to use this calculator
- Enter Initial investment ($)。
- Enter Annual cash flow ($)。
- Enter Project years (years)。
- Enter Hurdle rate (%)。
Leave any field blank and the calculator solves for it from the remaining values — every quantity is reversible.
The calculator then returns: IRR、Excess over hurdle。
What is it
Project Internal Rate of Return — Enter Initial investment, Annual cash flow, Project years and Hurdle rate to get IRR and Excess over hurdle — or leave any field blank to solve for it. Business and operations calculators convert cost, price, volume and efficiency data into profit, break-even points and utilisation rates. The core question it answers is: IRR and Excess over hurdle. With Initial investment = 500,000 $, Annual cash flow = 150,000 $ and Project years = 5 years, IRR is 15.24 %.
Formula
| Variable | Inputs | Unit |
|---|---|---|
initialInvestment | Initial investment | $ |
annualCashFlow | Annual cash flow | $ |
projectYears | Project years | years |
hurdleRate | Hurdle rate | % |
irr | IRR | % |
irrAboveHurdle | Excess over hurdle | % |
(function(){var lo=-0.9;var hi=1;var mid=0;for(var i=0;i<100;i++){mid=(lo+hi)/2;var pv=0;for(var t=1;t<=projectYears;t++){pv=pv+annualCashFlow/Math.pow(1+mid,t);}if(pv>initialInvestment){lo=mid;}else{hi=mid;}}return (lo+hi)/2*100;})()irr - hurdleRateThe relationship is solved in every direction, so any one unknown field can be derived.
Worked example
Using the default inputs:
- Initial investment = 500000 $
- Annual cash flow = 150000 $
- Project years = 5 years
- Hurdle rate = 12 %
Formula used: (function(){var lo=-0.9;var hi=1;var mid=0;for(var i=0;i<100;i++){mid=(lo+hi)/2;var pv=0;for(var t=1;t<=projectYears;t++){pv=pv+annualCashFlow/Math.pow(1+mid,t);}if(pv>initialInvestment){lo=mid;}else{hi=mid;}}return (lo+hi)/2*100;})()
Answer:
- IRR = 15.24 %
- Excess over hurdle = 3.24 %
Example 1 (default inputs):Suppose Initial investment = 500,000 $, Annual cash flow = 150,000 $, Project years = 5 years, Hurdle rate = 12 %; then giving IRR = 15.24 %, Excess over hurdle = 3.24 %.
Example 2 (one input changed):If you change Initial investment to 375,000,giving IRR = 28.65 %, Excess over hurdle = 16.65 %.
Additional information
Assumptions and limitations
- These models assume unit variable cost and price stay stable over the relevant range; scale effects, tiered pricing and seasonality push real results away from the linear estimate.
- Good for: getting a directionally correct order of magnitude quickly, or comparing two scenarios.
- Not good for: using it as the sole basis for a decision, or for official filings, contract pricing and legal documents — those need a full model with your actual clauses and local rules.