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:
| Variable | Type | Example value |
|---|---|---|
| Initial Investment | Input (you provide) | $50,000 |
| Cash Flow Year 1 | Input (you provide) | $15,000 |
| Cash Flow Year 2 | Input (you provide) | $18,000 |
| Cash Flow Year 3 | Input (you provide) | $20,000 |
| Cash Flow Year 4 | Input (you provide) | $22,000 |
| Discount Rate (WACC) | Input (you provide) | 10 % |
| PV of Year 1 Cash Flow | Result (calculated) | — |
| PV of Year 2 Cash Flow | Result (calculated) | — |
| PV of Year 3 Cash Flow | Result (calculated) | — |
| PV of Year 4 Cash Flow | Result (calculated) | — |
| Total Present Value | Result (calculated) | — |
| Net Present Value (NPV) | Result (calculated) | — |
Step-by-Step Method
- 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).
- 2Substitute your known values into the formula: NPV = Sigma(Ct/(1+r)^t).
- 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
- 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
- 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 Investment | 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) |
|---|---|---|---|---|---|---|
| $10,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | 48564.99 |
| $30,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | 28564.99 |
| $40,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | 18564.99 |
| $50,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | 8564.99 |
| $60,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | -1435.01 |
| $80,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | -21435.01 |
| $100,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.99 | -41435.01 |
| $200,000 | 13636.36 | 14876.03 | 15026.30 | 15026.30 | 58564.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
Use the Interactive Calculator
Skip the manual math — get instant results with our free NPV & IRR calculator.
