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.

The result is —

Inputs

Results

IRR (%) —
Excess over hurdle (%) —

Fill in enough known values and the rest are solved automatically.

Quick answer: With Initial investment = 500,000 $, Annual cash flow = 150,000 $ and Project years = 5 years, IRR is 15.24 %.

How to use this calculator

  1. Enter Initial investment ($)。
  2. Enter Annual cash flow ($)。
  3. Enter Project years (years)。
  4. 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

VariableInputsUnit
initialInvestmentInitial investment$
annualCashFlowAnnual cash flow$
projectYearsProject yearsyears
hurdleRateHurdle rate%
irrIRR%
irrAboveHurdleExcess over hurdle%
IRR(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;})()
Excess over hurdleirr - hurdleRate

The relationship is solved in every direction, so any one unknown field can be derived.

Worked example

Using the default inputs:

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:

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

Back to category:Business & Ratios

FAQ

What is Project Internal Rate of Return?

With Initial investment = 500,000 $, Annual cash flow = 150,000 $ and Project years = 5 years, IRR is 15.24 %.

How do I use the Project Internal Rate of Return?

Enter values for Initial investment, Annual cash flow, Project years, Hurdle rate; the tool instantly computes IRR, Excess over hurdle.

When should I use the 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. Use it whenever you need a quick estimate for planning or comparing options. Results are for reference only.

How accurate is this calculator?

The number is the exact solution of the standard formula for your inputs, with no error beyond rounding. How well it matches reality depends on the model's assumptions. 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.

Can I calculate it backwards?

Yes. This is a multi-directional calculator: fill in every field except one, and the blank one — whether IRR and Excess over hurdle — is solved automatically.

When should I not use it?

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.