Net Present Value Calculator
Analyze the profitability of an investment. A positive NPV indicates the projected earnings (in present dollars) exceed the anticipated costs.
$
$
%
%
Years
👨🏫
By Prof. David Anderson
Finance Professor | CFA Charterholder
“In the boardroom, opinions don’t matter—math does. While metrics like ROI or Payback Period are popular, they are flawed. The Net Present Value (NPV) is the only metric that accounts for the most fundamental rule of finance: the Time Value of Money. If you are a business owner deciding on a new machine, or an investor evaluating a rental property, the NPV tells you exactly one thing: Will this investment make you richer or poorer?”
Net Present Value (NPV) Calculator & Guide: The Gold Standard of Investment Analysis
Capital Budgeting Masterclass: Formulas, Excel Hacks & Decision Rules
1. What is NPV? (The “Value Creation” Metric)
Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.
Think of it this way: You spend money today (Outflow) to get money in the future (Inflow). Because future money is worth less than today’s money (due to inflation and risk), you must “discount” those future flows back to today to see if the project is actually worth it.
The NPV Decision Rule
✅ NPV > 0 (Positive): ACCEPT. The project is expected to add value to the firm. Wealth increases.
❌ NPV < 0 (Negative): REJECT. The project will destroy value. You would be better off investing elsewhere.
⚪ NPV = 0 (Neutral): INDIFFERENT. The project earns exactly the required rate of return, but creates no extra wealth.
2. The Mathematical Engine: NPV Formula
While it looks intimidating, the summation formula is just adding up a series of Present Value calculations.
The Standard Formula
$$ NPV = \sum_{t=1}^{n} \frac{R_t}{(1 + i)^t} – C_0 $$
- $R_t$: Net cash inflow-outflows during a single period $t$.
- $i$: Discount rate (or return that could be earned in alternative investments).
- $t$: Number of time periods.
- $C_0$: Initial Investment cost (usually negative).
Expanded Version (Visualized)
$$ NPV = \frac{Cash_1}{(1+r)^1} + \frac{Cash_2}{(1+r)^2} + \dots – \text{Initial Cost} $$
3. Manual Calculation Case Study
Scenario: You are considering buying a coffee machine for $10,000. It will generate $4,000 in profit for the next 3 years. Your required rate of return (Discount Rate) is 10%.
| Year (t) | Cash Flow | Discount Factor $(1.10)^t$ | Present Value (PV) |
|---|---|---|---|
| 0 (Now) | -$10,000 | 1.000 | -$10,000.00 |
| 1 | +$4,000 | 1.100 | $3,636.36 |
| 2 | +$4,000 | 1.210 | $3,305.79 |
| 3 | +$4,000 | 1.331 | $3,005.26 |
| Net Present Value (NPV): | -$52.59 | ||
Verdict: The NPV is -$52.59. Even though you make a nominal profit of $2,000 ($12k revenue – $10k cost), in today’s value, you actually LOSE money compared to investing that $10k elsewhere at 10%. REJECT the project.
4. The “Excel Trap”: Don’t Make This Mistake!
This is the most common error I see in MBA students and junior analysts.
⚠️ The Period 1 Problem
Excel’s =NPV() function assumes that the first value you select occurs at the END of Period 1.
If you include your Initial Investment (Year 0) inside the function, Excel will wrongly discount it by one year.
The Wrong Way ❌
# Assuming A1 is rate (10%), A2 is -$10,000, A3-A5 are $4,000
=NPV(A1, A2:A5)
>> Result: -$47.81 (WRONG!)
# Excel discounted the initial $10k, reducing the cost artificially.
The Correct Way ✅
# Initial Investment must be ADDED outside the function
=NPV(A1, A3:A5) + A2
>> Result: -$52.59 (CORRECT)
# Logic: Discount the future flows (Yr 1-3), then subtract start cost.
5. The Great Debate: NPV vs. IRR
Internal Rate of Return (IRR) calculates the percentage return of a project. It is popular because managers love percentages. But NPV is scientifically superior.
- The Reinvestment Assumption: IRR assumes cash flows are reinvested at the project’s own high rate (often unrealistic). NPV assumes reinvestment at the cost of capital (realistic).
- Scale Problem: A project with 50% IRR that earns $10 is worse than a project with 10% IRR that earns $1,000,000. NPV captures the magnitude of wealth.
Professor’s Rule: If NPV and IRR ever disagree (which happens with mutually exclusive projects), always follow NPV. You can spend dollars; you cannot spend percentages.
6. Advanced: Choosing the Discount Rate
Garbage in, garbage out. If your “r” (Discount Rate) is wrong, your NPV is worthless.
- For Individuals: Use your Opportunity Cost. What could you earn in the stock market (e.g., 7-8%)?
- For Companies: Use WACC (Weighted Average Cost of Capital). This is the blended cost of paying interest on debt and satisfying equity shareholders.
- For Risky Projects: Add a risk premium. A sure-thing bond might use 4%, while a risky tech startup valuation might use 20%.
7. Professor’s FAQ Corner
Q: Can a project have a positive NPV but be rejected?
Yes. This happens in “Capital Rationing.” If a company has limited cash, it might reject a positive NPV project to fund a higher NPV project.
Q: What is the “Payback Period” vs NPV?
Payback Period simply counts how many years it takes to get your money back. It ignores the time value of money and cash flows after the payback date. It is a crude metric compared to NPV.
Q: How do I handle uneven cash flows?
That is the beauty of NPV! Unlike simple annuity formulas, the NPV summation $\sum$ allows every single year ($t=1, t=2…$) to have a completely different cash flow amount. Just discount each one individually and sum them up.
References
- Brealey, R. A., Myers, S. C., & Allen, F. (2019). Principles of Corporate Finance. McGraw-Hill Education.
- Damodaran, A. (2012). Investment Valuation. Wiley Finance.
- Investopedia. “Net Present Value (NPV) Rule”.
Ready to Analyze Your Investment?
Jump back to the top to calculate your Net Present Value.
Calculate