Financial Calculators
NPV & IRR Calculator - Net Present Value & Internal Rate of Return
Calculate the Net Present Value (NPV) and Internal Rate of Return (IRR) of any cash-flow series. Includes payback period, sensitivity analysis, and sample project presets.
Cash Flows
| Period (years) | Cash Flow ($) | |
|---|---|---|
NPV @ 10%
$6,073.54
IRR
12.3373%
Payback Period
4 years
NPV Sensitivity
| Discount Rate | NPV |
|---|---|
| 5.0% | $21,204.76 |
| 7.5% | $13,242.59 |
| 12.5% | -$402.04 |
| 15.0% | -$6,269.06 |
Understanding NPV and IRR
Net Present Value (NPV) and Internal Rate of Return (IRR) are the two most important metrics in capital budgeting. NPV tells you the absolute dollar value an investment creates above your cost of capital. A positive NPV means the investment is worth pursuing. IRR tells you the percentage return the investment generates. Compare it to your hurdle rate to decide.
How NPV is calculated
NPV sums all future cash flows discounted to today's dollars using the formula: NPV = Σ CFt / (1 + r)t. The discount rate r reflects the opportunity cost of capital (what you could earn in an alternative investment of similar risk). The higher the discount rate, the less future cash flows are worth today.
The multiple IRR problem
When a project has unconventional cash flows (outflows in the middle of the project or multiple phases), the NPV equation can have more than one solution, meaning there are multiple valid IRRs. This calculator detects that situation and warns you. In such cases, rely on NPV rather than IRR for your decision.
MIRR - Modified Internal Rate of Return
MIRR solves the multiple-IRR problem by making explicit assumptions about reinvestment rates. Traditional IRR implicitly assumes positive cash flows are reinvested at the IRR itself - an often unrealistic assumption. MIRR instead assumes positive cash flows are reinvested at the cost of capital (or a specified reinvestment rate), producing a single, unambiguous result.
The formula: MIRR = (FV of positive flows / PV of negative flows)^(1/n) − 1
Where FV is computed at the reinvestment rate and PV at the finance rate.
Worked example
| Year | Cash flow | PV at 10% |
|---|---|---|
| 0 | −$100,000 | −$100,000 |
| 1 | +$40,000 | +$36,364 |
| 2 | +$50,000 | +$41,322 |
| 3 | +$60,000 | +$45,079 |
NPV at 10% = −$100,000 + $36,364 + $41,322 + $45,079 = +$22,765 (positive -> accept the investment).
IRR ≈ 23.4% (the discount rate at which NPV = 0). Since 23.4% > 10% hurdle rate -> accept.
Discount rate selection guide
The discount rate represents the opportunity cost of capital - what you could earn on an alternative investment of similar risk. Common choices:
- WACC (Weighted Average Cost of Capital): used for corporate capital budgeting. Reflects the blended cost of debt and equity financing.
- Risk-free rate + risk premium: for personal or project-level investments. Start with the current 10-year Treasury yield and add a premium for the specific risks of the project.
- Next-best alternative rate: if the alternative is a 7% index fund, use 7% as the minimum acceptable return. Any NPV-positive project at that rate beats leaving the money invested.