NPV Calculator
Calculate Net Present Value (NPV $), Profitability Index (PI), discounted cash flows, and capital project feasibility based on target discount rates.
Calculate Net Present Value (NPV & Profitability Index)
Enter initial capital investment (Year 0 Outflow), discount rate %, and cash inflows for Years 1 through 4.
NPV Calculation Output
Quick Summary
Our NPV calculator net present value discount rate evaluates the current dollar value of future cash inflows generated by a business investment or project. By discounting future cash flows at a target interest rate or Weighted Average Cost of Capital (WACC), this calculator determines whether a capital project creates or destroys value.
How It Works: Net Present Value (NPV) & Time Value of Money
A dollar received today is worth more than a dollar received in the future due to inflation and lost investment opportunity.
1. **Present Value ($PV$):** Future cash flows are discounted back to today using formula $PV = \CF_t / (1 + r)^t$.
2. **Net Present Value ($NPV$):** Sum of all discounted cash inflows minus initial capital expenditure ($NPV = PV_{inflows} - CF_0$).
3. **Profitability Index ($PI$):** Measures bang-for-buck efficiency by dividing total present value of inflows by initial cost ($PI = PV_{inflows} / CF_0$).
Formula Explanation
Your Net Present Value ($NPV$) and Profitability Index ($PI$) are calculated as follows:
Step-by-Step Worked Example
Here is a detailed 5-step breakdown for a $100,000 initial investment at a 10.0% discount rate with annual inflows of $30,000 (Yr 1), $40,000 (Yr 2), $50,000 (Yr 3), and $60,000 (Yr 4):
- Step 1 (Discount Year 1 Inflow): $\$30,000 / 1.10^1 = \$30,000 / 1.10 = \mathbf{\$27,272.73}$.
- Step 2 (Discount Year 2 Inflow): $\$40,000 / 1.10^2 = \$40,000 / 1.21 = \mathbf{\$33,057.85}$.
- Step 3 (Discount Year 3 Inflow): $\$50,000 / 1.10^3 = \$50,000 / 1.331 = \mathbf{\$37,565.74}$.
- Step 4 (Discount Year 4 Inflow): $\$60,000 / 1.10^4 = \$60,000 / 1.4641 = \mathbf{\$40,986.27}$.
- Step 5 (Sum PV of Inflows & Compute NPV):
Total PV of Inflows $= \$27,272.73 + \$33,057.85 + \$37,565.74 + \$40,986.27 = \mathbf{\$138,882.59}$.
$NPV = \$138,882.59 - \$100,000 = \mathbf{+\$38,882.59 \text{ positive NPV}}$ ($PI = 1.39x$ return multiplier)!
Calculation Examples: Real-World Scenario Comparison
Compare Net Present Value (NPV) across discount rates ($100k initial outlay):
| Discount Rate (WACC) | Annual Cash Inflows (Yrs 1-4) | Total PV of Inflows | Net Present Value (NPV) | Profitability Index (PI) |
|---|---|---|---|---|
| 8.0% Low Discount Rate | $30k, $40k, $50k, $60k | $146,134.85 | +$46,134.85 NPV | 1.46x PI (Accept) |
| 10.0% Standard WACC Rate | $30k, $40k, $50k, $60k | $138,882.59 | +$38,882.59 NPV | 1.39x PI (Accept) |
| 15.0% High Risk Discount Rate | $30k, $40k, $50k, $60k | $123,546.72 | +$23,546.72 NPV | 1.24x PI (Accept) |
| 25.0% Venture Hurdle Rate | $30k, $40k, $50k, $60k | $97,152.00 | -$2,848.00 NPV | 0.97x PI (Reject!) |
Benefits of Using the NPV Calculator
Utilizing this calculator provides fundamental corporate finance advantages:
- Gold Standard Capital Budgeting Metric: NPV is universally recognized by corporate CFOs as the single best metric for evaluating capital projects.
- Directly Measures Wealth Creation: A positive NPV represents the exact dollar amount added to shareholder value.
- Ranks Mutually Exclusive Projects: Profitability Index ($PI$) allows managers to rank competing projects when capital is constrained.
- Factors in Opportunity Cost & WACC: Ensures projects earn more than the company's cost of capital.
Frequently Asked Questions (FAQ)
What is Net Present Value (NPV)?
NPV is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.
What does a positive NPV mean?
A positive NPV indicates that the projected earnings generated by a project (in today's dollars) exceed the anticipated costs, making the project profitable.
What does a negative NPV mean?
A negative NPV means the project fails to generate enough cash flow to cover its cost of capital, resulting in a net loss of wealth.
How is discount rate determined in NPV calculations?
The discount rate is typically set equal to a firm's Weighted Average Cost of Capital (WACC) or an investor's required rate of return including a risk premium.
What is the Profitability Index (PI)?
Profitability Index is calculated as Present Value of Inflows divided by Initial Investment. A PI > 1.0 indicates a positive NPV project.
How does NPV compare to IRR?
NPV measures absolute dollar value added to a firm, whereas IRR measures percentage rate of return. NPV is superior when choosing between mutually exclusive projects of different scale.
What happens to NPV when the discount rate increases?
As the discount rate increases, the present value of future cash inflows decreases, lowering the overall NPV.
Can NPV be used for real estate investment analysis?
Yes! Real estate investors discount projected annual rental cash flows and final property resale value to determine if a purchase price is justified.
What is Terminal Value in NPV models?
Terminal Value represents the estimated present value of all cash flows beyond the explicit forecast period (often estimated using Gordon Growth Model).
Why is NPV preferred over Payback Period?
Payback period ignores the time value of money and all cash flows received after the payback threshold. NPV accounts for all cash flows across the entire project life.