CalculatorVilla

NPV & IRR Calculator

Evaluate capital budgeting proposals and commercial investment viability. This calculator models discounted cash flows over five annual periods to determine whether an investment adds net shareholder value above your hurdle rate.

Net Present Value (NPV): 0
$

Initial upfront capital investment required

%

Cost of capital or minimum acceptable rate of return

$

Net expected cash inflow in year 1

$

Net expected cash inflow in year 2

$

Net expected cash inflow in year 3

$

Net expected cash inflow in year 4

Net Present Value (NPV)
$0.00

How to Use This Calculator

  1. Enter the upfront cash outlay required to fund the project at Year 0.
  2. Set your required hurdle rate or cost of capital as the discount rate percentage.
  3. Provide estimated net annual cash receipts across consecutive periods.
  4. Examine the resulting NPV and IRR to assess whether project returns surpass hurdle criteria.

Formula & Calculation Methodology

NPV = ∑ [CFₜ / (1 + r)ᵗ] - C₀ | IRR: r where NPV = 0

NPV discounts future expected cash inflows back to present value using the hurdle rate, subtracting the initial outlay. IRR is the unique discount rate yielding an NPV of zero.

CFₜCash inflow generated in period t
rDiscount rate or weighted average cost of capital (WACC)
tTime period in years
C₀Initial investment cost at period 0
IRRInternal Rate of Return percentage

Worked Example

Machinery acquisition requiring $50,000 outlay with a 10% discount rate and 4 annual cash returns

initialInvestment: 50000
discountRate: 10
cfYear1: 15000
cfYear2: 18000
cfYear3: 20000
cfYear4: 15000
Result: NPV: $3,799.64 | IRR: 13.56%

Frequently Asked Questions

What does a positive Net Present Value (NPV) signify?↓

A positive NPV indicates that the present value of all expected future cash inflows exceeds the initial investment expenditure, demonstrating that the project is projected to generate returns superior to the cost of capital.

How do I interpret the Internal Rate of Return (IRR)?↓

If the IRR exceeds your enterprise hurdle rate or cost of capital, the opportunity is generally considered financially viable. However, mutually exclusive projects should prioritize NPV over IRR when project scales differ.

What limitations exist when calculating IRR on unconventional cash flows?↓

When cash flows fluctuate between positive and negative across consecutive years, the polynomial formula may yield multiple internal rates of return or fail to converge, making NPV the more reliable benchmark.

Does this calculator incorporate continuous or annual period discounting?↓

This engine operates on standard annual end-of-period discrete compounding, which represents the established international benchmark in corporate valuation and capital budgeting analysis.

Related Calculators

Source Citation & Disclaimer

Informational tool only; not licensed tax, legal, or financial advice.