ganak.appNPV Calculator
Calculate Net Present Value (NPV), IRR, Profitability Index, and payback period for investment projects. Compare equal or unequal cash flows, view year-by-year discounted breakdown, and make data-driven investment decisions.
Period-by-Period NPV Breakdown
Discount factor and present value for each period
| Period | Cash Flow | Discount Factor | Present Value | Cumulative NPV |
|---|---|---|---|---|
| 0 | -$100,000 | 1.0000 | -$100,000 | -$100,000 |
| 1 | $30,000 | 0.9091 | $27,273 | -$72,727 |
| 2 | $30,000 | 0.8264 | $24,793 | -$47,934 |
| 3 | $30,000 | 0.7513 | $22,539 | -$25,394 |
| 4 | $30,000 | 0.6830 | $20,490 | -$4,904 |
| 5 | $30,000 | 0.6209 | $18,628 | $13,724 |
What is Net Present Value (NPV)?
Understanding the core metric for investment analysis
Net Present Value (NPV) is the difference between the present value of future cash inflows and the initial investment cost. It tells you whether an investment will create or destroy value based on a required rate of return (discount rate).
A positive NPV means the investment is expected to generate more value than it costs, making it a good opportunity. A negative NPV means the project is expected to lose value and should typically be rejected.
NPV is considered the gold standard of capital budgeting techniques because it accounts for the time value of money, provides a dollar amount of value created, and can be used to compare projects of different sizes and durations.
How to Calculate NPV
Step-by-step formula breakdown with examples
C₀ = Initial investment (cash outflow at time 0)
CFₜ = Cash flow at period t
r = Discount rate (required rate of return, as a decimal)
n = Total number of periods
t = Time period (1, 2, 3, ...)
Example Calculation
NPV = -$100,000 + $30,000/1.1 + $30,000/1.21 + $30,000/1.331 + $30,000/1.4641 + $30,000/1.6105
NPV = -$100,000 + $27,273 + $24,793 + $22,539 + $20,490 + $18,628
NPV = $13,724(Positive: Accept the project)
NPV Decision Rules
How to interpret NPV results for investment decisions
| NPV Result | Meaning | Decision |
|---|---|---|
| NPV > 0 | Investment creates value; returns exceed the required rate | Accept |
| NPV = 0 | Investment breaks even at the discount rate; earns exactly the required return | Indifferent |
| NPV < 0 | Investment destroys value; returns fall short of the required rate | Reject |
NPV vs IRR vs Payback Period
Compare the three most common investment analysis methods
| Feature | NPV | IRR | Payback Period |
|---|---|---|---|
| What it measures | Dollar value created | Breakeven return rate | Time to recover cost |
| Time value of money | Yes | Yes | No (simple) / Yes (discounted) |
| Best for | Comparing projects of different sizes | Quick rate comparison | Liquidity-focused decisions |
| Recommended? | Gold standard | Good supplement | Use with caution |
When to Use NPV Analysis
Real-world applications of NPV in investment decisions
Capital Budgeting
Evaluate whether to purchase new equipment, build a factory, or invest in infrastructure by comparing NPV of each option.
Project Selection
When choosing between multiple projects with limited capital, select the combination with the highest total NPV.
Real Estate Investment
Analyze rental properties by discounting future rental income and sale proceeds against purchase price and renovation costs.
Business Valuation
Value a business or acquisition target by calculating the NPV of its projected free cash flows using an appropriate discount rate (WACC).
Common NPV Mistakes to Avoid
Pitfalls that lead to incorrect investment decisions
Wrong Discount Rate
Using a discount rate that is too low inflates NPV and can lead to accepting bad projects. Use your actual cost of capital or required return.
Ignoring Opportunity Cost
The discount rate should reflect what you could earn elsewhere with similar risk, not just inflation or a risk-free rate.
Overly Optimistic Cash Flows
Be realistic with cash flow projections. Use conservative estimates and run sensitivity analysis with different scenarios.
Forgetting Working Capital
Include changes in working capital (inventory, receivables) in your cash flows, not just revenue and expenses.
Frequently Asked Questions
Common questions about NPV, discount rates, and investment analysis