Net Present Value (NPV) Calculator
Print| Present Value of Cash Inflows | $0.00 |
| Recommendation | - |
When evaluating a major capital investment—such as purchasing new factory equipment, launching a new software product, or acquiring a commercial building—simply adding up future projected cash inflows isn’t enough. Because money loses purchasing power over time due to inflation and opportunity costs, you must discount future cash flows back into today’s dollars using **Net Present Value (NPV)**.
Our free NPV Calculator (Net Present Value Calculator) allows corporate analysts, investors, and business owners to evaluate project profitability. By discounting future annual cash flows at your company’s hurdle rate or WACC, you can determine if a project adds real wealth to your business.
How to Calculate Net Present Value
NPV calculates the difference between the present value of all future cash inflows and the initial upfront capital investment.
The NPV Formula:
NPV = Σ [ Cash Flowᶙ / (1 + r)ᶙ ] - Initial Investment
- Cash Flowᶙ: Net cash inflow generated in year t.
- r: Discount rate / Cost of Capital (as a decimal).
- t: Time period (Year 1, Year 2, … Year n).
- Initial Investment: Total upfront capital outlay at Year 0.
The Capital Budgeting Decision Rules
| NPV Calculator Result | Decision Rule | Financial Value Creation |
|---|---|---|
| Positive NPV (NPV > $0) | ACCEPT PROJECT | The project exceeds the hurdle rate and adds net dollar wealth to shareholders. |
| Zero NPV (NPV = $0) | NEUTRAL | The project earns exactly the cost of capital, adding no net extra value. |
| Negative NPV (NPV < $0) | REJECT PROJECT | The project fails to meet the required discount rate, destroying company capital. |
Step-by-Step Multi-Year Example
Imagine a company evaluating a new equipment purchase costing $200,000 upfront (Initial Investment) with a 10% Discount Rate (r = 0.10) over a 3-year lifespan.
- Year 1 Cash Flow: $80,000
- Year 2 Cash Flow: $100,000
- Year 3 Cash Flow: $90,000
| Year | Nominal Cash Inflow | Discount Factor (1 / 1.10ᶙ) | Present Value (PV) |
|---|---|---|---|
| Year 1 | $80,000 | 0.9091 | $72,727 |
| Year 2 | $100,000 | 0.8264 | $82,645 |
| Year 3 | $90,000 | 0.7513 | $67,618 |
| Total Present Value of Cash Inflows | $222,990 | ||
| Net Present Value (PV Inflows – $200k Initial Cost) | +$22,990 (ACCEPT) | ||
The project yields a positive NPV of +$22,990 above the 10% cost of capital. The company should accept the project.
Frequently Asked Questions (FAQ)
What is the difference between NPV and IRR?
NPV (Net Present Value) measures the absolute total dollar wealth added to the company (e.g., +$22,990). IRR (Internal Rate of Return) measures the percentage return rate that sets NPV to zero. Financial managers prefer NPV when ranking projects under capital constraints.
How does discount rate choice impact NPV?
Higher discount rates reduce the present value of future cash flows, lowering NPV. If a project has cash flows far into the future, selecting a high discount rate can turn a positive NPV into a negative NPV.
Can NPV handle negative cash flows in future years?
Yes. If a project requires overhaul maintenance in Year 3 (a negative cash flow), simply discount that negative inflow back to Year 0 using the same formula and subtract it from total present value.