CalcUnit Logo

How to Calculate NPV & IRR

Calculate Net Present Value and Internal Rate of Return for investment project evaluation.

The Formula

NPV = Sigma(Ct/(1+r)^t)

The npv & irr formula uses the mathematical relationship: NPV = Sigma(Ct/(1+r)^t). Each variable in the formula represents a measurable quantity that affects the final result.

What Each Variable Means

Every value in the npv & irr formula, what it measures, and the value used in the worked example on this page:

VariableTypeExample value
Initial InvestmentInput (you provide)$50,000
Cash Flow Year 1Input (you provide)$15,000
Cash Flow Year 2Input (you provide)$18,000
Cash Flow Year 3Input (you provide)$20,000
Cash Flow Year 4Input (you provide)$22,000
Discount Rate (WACC)Input (you provide)10 %
PV of Year 1 Cash FlowResult (calculated)—
PV of Year 2 Cash FlowResult (calculated)—
PV of Year 3 Cash FlowResult (calculated)—
PV of Year 4 Cash FlowResult (calculated)—
Total Present ValueResult (calculated)—
Net Present Value (NPV)Result (calculated)—

Step-by-Step Method

  1. 1Write down the values you know: Initial Investment, Cash Flow Year 1, Cash Flow Year 2, Cash Flow Year 3, Cash Flow Year 4, Discount Rate (WACC).
  2. 2Substitute your known values into the formula: NPV = Sigma(Ct/(1+r)^t).
  3. 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
  4. 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
  5. 5Verify your answer with the interactive NPV & IRR Calculator — it solves the same formula instantly.

Worked Example

Take a concrete case: initial investment = $30,000, with the other inputs at the typical values from the variables table above. Substituting into the formula gives pv of year 1 cash flow = 13636.36, pv of year 2 cash flow = 14876.03, pv of year 3 cash flow = 15026.30, pv of year 4 cash flow = 15026.30, total present value = 58564.99, net present value (npv) = 28564.99. These numbers are solved by the same engine that powers the NPV & IRR calculator, so you can reproduce them exactly by entering the same inputs there.

Initial InvestmentPV of Year 1 Cash FlowPV of Year 2 Cash FlowPV of Year 3 Cash FlowPV of Year 4 Cash FlowTotal Present ValueNet Present Value (NPV)
$10,00013636.3614876.0315026.3015026.3058564.9948564.99
$30,00013636.3614876.0315026.3015026.3058564.9928564.99
$40,00013636.3614876.0315026.3015026.3058564.9918564.99
$50,00013636.3614876.0315026.3015026.3058564.998564.99
$60,00013636.3614876.0315026.3015026.3058564.99-1435.01
$80,00013636.3614876.0315026.3015026.3058564.99-21435.01
$100,00013636.3614876.0315026.3015026.3058564.99-41435.01
$200,00013636.3614876.0315026.3015026.3058564.99-141435.01

How each result changes as initial investment changes, holding the other inputs constant.

Practice Problems

1. Business investment: With Initial Investment $50,000, Cash Flow Year 1 $15,000, Cash Flow Year 2 $18,000, Cash Flow Year 3 $20,000, Cash Flow Year 4 $22,000, and 1 more more inputs, what are the results?

Answer: With Initial Investment $50,000, Cash Flow Year 1 $15,000, Cash Flow Year 2 $18,000, Cash Flow Year 3 $20,000, Cash Flow Year 4 $22,000, and 1 more more inputs, the results are PV of Year 1 Cash Flow $13,636.36, PV of Year 2 Cash Flow $14,876.03, PV of Year 3 Cash Flow $15,026.30, and 3 more more results.

2. Initial Investment $125,000, Cash Flow Year 1 $30,000, Cash Flow Year 2 $35,000, Cash Flow Year 3 $40,000, Cash Flow Year 4 $45,000, and 1 more more inputs — work it out, then check the answer.

Answer: Entering Initial Investment $125,000, Cash Flow Year 1 $30,000, Cash Flow Year 2 $35,000, Cash Flow Year 3 $40,000, Cash Flow Year 4 $45,000, and 1 more more inputs gives PV of Year 1 Cash Flow $27,777.78, PV of Year 2 Cash Flow $30,006.86, PV of Year 3 Cash Flow $31,753.29, and 3 more more results.

Frequently Asked Questions

What is the formula for npv & irr?

The formula is: NPV = Sigma(Ct/(1+r)^t). Calculate Net Present Value and Internal Rate of Return for investment project evaluation.

What values do I need to calculate npv & irr?

You need initial investment, cash flow year 1, cash flow year 2, cash flow year 3, cash flow year 4, discount rate (wacc). The calculator produces pv of year 1 cash flow, pv of year 2 cash flow, pv of year 3 cash flow, pv of year 4 cash flow, total present value, net present value (npv) from those inputs.

What is the npv & irr when initial investment is $30,000?

With initial investment = $30,000, the result is pv of year 1 cash flow = 13636.36, pv of year 2 cash flow = 14876.03, pv of year 3 cash flow = 15026.30, pv of year 4 cash flow = 15026.30, total present value = 58564.99, net present value (npv) = 28564.99. This is worked through in full in the example on this page.

Related Topics

NPVIRRnet present valueinternal rate of return

Use the Interactive Calculator

Skip the manual math — get instant results with our free NPV & IRR calculator.

Open Calculator

Related Calculators