NPV Calculator

Calculate Net Present Value for investment analysis. Evaluate project profitability using discounted cash flows.

%

Cash Flows

Quick Facts

Decision Rule
NPV > 0 = Accept
Positive NPV adds value
Typical Discount Rate
8-12%
Corporate WACC range
Time Value of Money
$1 today > $1 tomorrow
Core NPV principle
Risk Premium
+2-5% for risk
Add for riskier projects

Analysis Results

Calculated
Net Present Value
$0
Investment decision
Total Cash Inflows
$0
Sum of all inflows
Initial Investment
$0
Year 0 outflow

Cash Flow Breakdown

Year Cash Flow Present Value Cumulative PV

Key Takeaways

  • NPV measures the dollar value an investment adds to your wealth
  • NPV > 0: Accept the investment (adds value)
  • NPV < 0: Reject the investment (destroys value)
  • Higher discount rates result in lower NPV values
  • NPV accounts for the time value of money

What is Net Present Value (NPV)?

Net Present Value (NPV) is a fundamental financial metric used to evaluate the profitability of an investment or project. It calculates the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV accounts for the time value of money - the principle that a dollar today is worth more than a dollar in the future.

NPV is widely used in capital budgeting and investment planning to analyze the profitability of projected investments. A positive NPV indicates that the projected earnings exceed the anticipated costs, making the investment potentially profitable. A negative NPV suggests the investment would result in a net loss.

NPV Formula

NPV = Σ [CFt / (1 + r)t]
CFt = Cash flow at time t
r = Discount rate (required rate of return)
t = Time period

Understanding the Discount Rate

The discount rate is crucial in NPV calculations. It represents the minimum acceptable rate of return, also known as the hurdle rate or required rate of return. Several factors influence the choice of discount rate:

Common Discount Rate Choices

  • Weighted Average Cost of Capital (WACC): The average rate a company pays to finance its assets, commonly used for corporate projects
  • Required Rate of Return: The minimum return an investor expects from an investment
  • Opportunity Cost: The return that could be earned on an alternative investment with similar risk
  • Risk-Adjusted Rate: A base rate plus a premium for project-specific risk

Interpreting NPV Results

NPV > 0 (Positive)

A positive NPV means the investment is expected to generate more value than its cost. The project adds value to the firm or investor. Generally, investments with positive NPV should be accepted, assuming the discount rate accurately reflects the required return and risk.

NPV = 0 (Zero)

A zero NPV means the investment is expected to break even - it will return exactly the discount rate. The project neither adds nor destroys value. At this point, the actual rate of return equals the required rate of return.

NPV < 0 (Negative)

A negative NPV indicates the investment is expected to lose value. The returns don't compensate for the risk and time value of money. Generally, negative NPV projects should be rejected unless there are strategic non-financial reasons.

Example: Equipment Purchase Decision

Initial investment: $100,000

Expected annual cash flows: $30,000 for 5 years

Discount rate: 10%

Year 0: -$100,000 / (1.10)^0 = -$100,000

Year 1: $30,000 / (1.10)^1 = $27,273

Year 2: $30,000 / (1.10)^2 = $24,793

Year 3: $30,000 / (1.10)^3 = $22,539

Year 4: $30,000 / (1.10)^4 = $20,490

Year 5: $30,000 / (1.10)^5 = $18,628

NPV = $13,723 (Positive - accept the investment)

NPV vs. Other Investment Metrics

NPV vs. IRR (Internal Rate of Return)

While NPV gives you an absolute dollar value of expected profit, IRR gives you a percentage return. NPV is generally preferred because:

  • NPV assumes reinvestment at the discount rate (more realistic)
  • NPV handles changing discount rates better
  • NPV always gives a unique answer (IRR can have multiple values)
  • NPV directly measures value creation

NPV vs. Payback Period

Payback period tells you how long until you recover your initial investment. Unlike NPV, payback period ignores cash flows after the payback point and doesn't account for the time value of money. NPV provides a more complete picture of investment value.

Limitations of NPV

Estimation Challenges

NPV relies on estimated future cash flows and discount rates. Inaccurate projections lead to unreliable NPV calculations. Use conservative estimates and sensitivity analysis.

Size Bias

NPV favors larger projects. A $1 billion project with 5% return has higher NPV than a $1 million project with 50% return. Use profitability index (NPV/Investment) for comparing projects of different sizes.

Ignores Non-Financial Factors

NPV doesn't capture strategic value, learning opportunities, or competitive positioning. Some negative NPV projects may still be worthwhile for non-financial reasons.

Frequently Asked Questions

What discount rate should I use?

Use your company's WACC for typical projects, or a rate that reflects the specific risk of the investment. Add a risk premium for riskier projects. For personal investments, use your required rate of return or opportunity cost.

Should I always choose the highest NPV project?

Not necessarily. Consider capital constraints, strategic fit, risk levels, and non-financial factors. The profitability index (NPV/Investment) helps compare projects of different sizes when capital is limited.

How do I handle uncertain cash flows?

Use expected values (probability-weighted averages) for uncertain cash flows. Perform sensitivity analysis with best-case, worst-case, and most likely scenarios. Consider using Monte Carlo simulation for complex projects.

Can NPV be used for personal financial decisions?

Yes. NPV can evaluate buying vs. renting, education investments, or major purchases. Use an appropriate personal discount rate reflecting your opportunity cost of capital.