Calculate Net Present Value (NPV) of investments. Evaluate project profitability with discounted cash flow.
Three years ago, a friend pitched me on a food truck. The numbers looked solid on a napkin: $45,000 to buy and outfit the truck, $28,000 a year in revenue after expenses, growing steadily. He said we'd make our money back in under two years. I believed him. I wrote the check.
What neither of us bothered to do was discount those future cash flows back to present value. We looked at raw numbers — $28,000 times five years equals $140,000, minus $45,000 initial cost, that's $95,000 profit! — and thought we'd discovered a gold mine. The reality was messier. Revenue in year one was $19,000, not $28,000. By year two, a brake repair ate $4,000. Year three brought a health inspector fine and a competitor three blocks over. When I finally ran an ROI calculation at the end of year three, my actual annualized return was about 4% — barely keeping pace with inflation.
Had I run the NPV calculation upfront with a 12% discount rate (reasonable for a risky small business), the food truck's NPV would have been negative $8,200. The math was literally screaming "don't do it," and I ignored it because the raw dollar totals looked impressive.
That's what NPV does: it tells you the truth about future money. A dollar today is worth more than a dollar tomorrow — not because of some abstract economic theory, but because a dollar today can be invested, can earn returns, can be used. NPV accounts for that reality by converting all future cash flows into today's dollars, using a discount rate that reflects what your money could be earning elsewhere.
The calculator above does this instantly. Plug in your discount rate, your initial investment, and your expected cash flows. If the result is positive, the investment creates value above and beyond your required return. If it's negative, you're better off putting the money somewhere else. That's it. No spreadsheet gymnastics required.
Every investment decision comes down to one question: is the money I'll get back in the future worth more than the money I'm putting in today? NPV answers this with a single number.
The formula is straightforward:
NPV = -C₀ + C₁/(1+r)¹ + C₂/(1+r)² + ... + Cₙ/(1+r)ⁿ
C₀ = your initial investment (negative because it's money going out)
C₁, C₂...Cₙ = cash flows you expect in year 1, year 2, through year n
r = your discount rate (the return you'd require to bother with this investment)
Think of the discount rate as your "should I bother?" threshold. If you can earn 8% in an index fund with basically no effort, why would you invest in a project that returns 5%? You wouldn't. The discount rate captures that opportunity cost.
Here's a concrete example. Say you're considering investing $50,000 in a small marketing agency. You expect the following cash distributions: $12,000 in year one, $15,000 in year two, $18,000 in year three, and $22,000 in year four when you plan to sell your share. Using a 10% discount rate:
Year 1: $12,000 / 1.10 = $10,909
Year 2: $15,000 / 1.21 = $12,397
Year 3: $18,000 / 1.331 = $13,524
Year 4: $22,000 / 1.4641 = $15,027
Total present value of future cash: $51,857. Subtract the $50,000 investment, and your NPV is $1,857. Positive, but barely. This investment generates about $1,857 more in value than your 10% hurdle rate. It's a "maybe" — it depends on how confident you are in those projections and whether there are better options on the table.
Now change the discount rate to 15%, reflecting higher risk. The NPV drops to -$3,372. Same cash flows, same investment, but now the deal doesn't clear your bar. That's the power of the discount rate — it's the dial that turns a "yes" into a "no," and getting it right matters more than getting the cash flow estimates right.
If you want to see the annualized return instead of the dollar value, try our IRR calculator. IRR is the discount rate that makes NPV exactly zero — the break-even rate of return. Both tools are useful; NPV tells you how much value you create, IRR tells you the percentage return.
I see people plug 10% into NPV calculators the way they salt food — automatically, without tasting first. This is the single most dangerous habit in financial analysis. Your discount rate should reflect reality, not tradition.
Your discount rate is your opportunity cost: the return you'd expect from your next best alternative with similar risk. Here's how I think about it:
If you're evaluating a business investment: Use your weighted average cost of capital (WACC) if you know it. For most small businesses, that's 12-18%. Why so high? Because small businesses fail at alarming rates, and your money is illiquid. If you can earn 10% in the stock market with full liquidity, a private business investment needs to offer substantially more to compensate for the risk and lock-up.
If you're a corporate finance manager: Your company's WACC is the starting point. For riskier projects, add 2-5%. A new product launch in an unfamiliar market? WACC + 4%. Replacing existing equipment with more efficient versions? WACC + 0-1%. The range matters more than the exact number.
If you're evaluating real estate: Your discount rate should reflect the property type and market. Stable rental property in a growing city? 8-10%. Fix-and-flip in a volatile market? 15-20%. Raw land development? 20-25%. These aren't arbitrary — they reflect actual risk levels and what competing investments offer. Our investment return calculator can help you benchmark against other options.
If you're making personal investment decisions: Start with what you'd earn in a diversified stock portfolio — historically about 7-10% annualized over long periods. Add 2-5% for illiquidity and uncertainty. A friend's startup? Probably 20%+. A Treasury bond? 4-5%.
Small changes in the discount rate produce surprisingly large changes in NPV, especially for long-duration projects. Take a 10-year project with a $100,000 initial investment and $18,000 in annual cash flow:
At 8% discount rate: NPV = +$20,740
At 10%: NPV = +$10,602
At 12%: NPV = +$1,749
At 14%: NPV = -$5,984
Same project, same cash flows. But depending on which discount rate you pick, it's either a clear "yes" or a clear "no." This is why I always run NPV at three rates: my best estimate, then 2% above and 2% below. If the project is positive at all three, it's robust. If it flips from positive to negative, you need to think harder about the risk.
The textbook answer is simple: accept projects with positive NPV, reject projects with negative NPV. The real answer is more nuanced, because NPV is only as good as the assumptions behind it.
A positive NPV means the math works — given your inputs. But your inputs are estimates, and estimates can be wrong. I'd be cautious about a positive NPV project when:
The positive NPV is small relative to the investment. If you're investing $500,000 for an NPV of $5,000, you're earning a 1% premium over your discount rate. One small cost overrun or revenue shortfall wipes that out. As a rule of thumb, I want NPV to be at least 5-10% of the initial investment to feel confident.
The cash flows are back-loaded. A project that generates $5,000 in years 1-4 and $200,000 in year 5 might have a positive NPV, but you're making a big bet on that final year. If it doesn't materialize, you're underwater. Early cash flows are more reliable than distant ones.
The discount rate is aggressive (low). If you used a 6% discount rate for a risky venture, your positive NPV might disappear at 8%. Always test sensitivity.
Sometimes negative NPV projects are worth pursuing for reasons the formula can't capture:
Strategic value. Entering a new market might lose money for three years but position you for a dominant market share later. Amazon operated at negative NPV for over a decade. The NPV model doesn't capture option value — the value of having the choice to expand later.
Synergies with existing operations. A standalone NPV analysis might show a negative result, but if the project reduces costs in another division by $50,000/year, the combined effect could be strongly positive. NPV works best when you can capture all the cash flow effects in one analysis.
Regulatory or compliance requirements. Some investments aren't optional. Installing safety equipment, meeting environmental standards, or upgrading aging infrastructure might have negative NPV — but the alternative (fines, shutdowns, lawsuits) is worse. Frame these as "least negative NPV" decisions rather than profit-seeking ones.
The point isn't to ignore NPV. It's to remember that NPV is a tool, not an oracle. It gives you information. What you do with that information still requires judgment. If you're comparing multiple options, our break-even calculator can complement NPV by showing you the minimum performance needed to avoid losing money.
If you've spent any time around business decisions, you've probably heard all three metrics thrown around. Let me explain what each one actually tells you — and where each one fails.
NPV tells you how much value an investment creates in today's dollars, above and beyond your required return. A $50,000 NPV means you'll end up $50,000 richer (in present value terms) than if you'd invested at your discount rate instead. This is the most reliable metric for decision-making because it measures absolute value creation.
Strength: Handles any pattern of cash flows. Gives you a dollar answer that's directly comparable across projects of different sizes and durations.
Weakness: Doesn't tell you the return percentage. A $50,000 NPV on a $1,000,000 investment is very different from a $50,000 NPV on a $100,000 investment. People instinctively understand percentages better than dollar amounts.
IRR (Internal Rate of Return) is the discount rate that makes NPV exactly zero. It's the project's effective rate of return. If your IRR is 18% and your required return is 12%, the project clears your hurdle.
Strength: Easy to communicate. "This project returns 18%" is a sentence that makes sense to everyone, from the CEO to your spouse.
Weakness: Breaks when cash flows change sign more than once. A project that requires additional investment in year 3 can have multiple IRRs — mathematically valid but useless for decision-making. IRR also assumes reinvestment at the IRR rate, which is often unrealistic. A project returning 40% probably can't be replicated at 40%. NPV assumes reinvestment at the discount rate, which is usually more conservative and realistic.
Payback Period measures how long it takes to recover your initial investment. If you invest $100,000 and get $25,000/year, payback is 4 years. Simple.
Strength: Incredibly intuitive. Useful for businesses that care about liquidity — how long until we get our cash back?
Weakness: Ignores the time value of money (the discounted version fixes this but adds complexity). More critically, it ignores everything that happens after the payback point. A project that pays back in 2 years and generates nothing after looks better than one that pays back in 4 years but generates cash for 15 more years. That's obviously wrong.
Use NPV as your primary decision metric. It's the most mathematically sound. Calculate IRR alongside it for communication purposes — executives and investors respond to percentages. Use Payback Period as a secondary filter for liquidity risk, but never as your primary decision tool. If a project passes NPV but has a 12-year payback, ask whether your organization can tolerate that cash flow timeline.
For a deeper dive into rate-of-return calculations, our CAGR calculator helps you understand compound growth rates, which is closely related to what IRR measures.
Real estate is where NPV shines, because the cash flows are complex — rental income, tax benefits, maintenance costs, vacancy, appreciation, and a big lump sum when you sell. Trying to evaluate all that with gut feel is how people end up underwater on investment properties.
Let's say you're looking at a condo listed at $220,000. You'd put 25% down ($55,000) and finance the rest at 7% for 30 years. Monthly rent is $1,800. Here's how I'd set up the NPV:
Initial investment: $55,000 down payment + $6,600 closing costs = -$61,600
Annual cash flows (years 1-9): Rent $21,600 minus mortgage payment ($13,452), property tax ($2,420), insurance ($1,400), maintenance reserve ($1,800), HOA ($2,400), vacancy allowance ($1,080). That leaves annual net cash flow of about -$952. Yes, negative. Most rental properties lose money on a cash basis in the early years. The mortgage pays down principal and the property (hopefully) appreciates, but your bank account is lighter each month.
Year 10 (sale): Assume the property appreciates 3% per year to about $296,000. After selling costs (6%), you net about $278,240. Remaining mortgage balance is roughly $120,600. So your sale proceeds are about $157,640. Add the negative annual cash flows, and your total year-10 cash flow is roughly $156,688.
Using a 10% discount rate, the NPV comes out to roughly +$4,200. Barely positive. This property generates slightly more value than your 10% required return over 10 years — but you'd be cash-flow negative for nine of those years. Is that worth it? Depends on your tolerance for negative monthly cash flow and your confidence in 3% annual appreciation.
Change appreciation to 2%? NPV drops to about -$12,000. Change it to 4%? NPV jumps to about +$20,000. The entire investment thesis hinges on that one assumption. That's the insight NPV gives you — it shows you exactly which variables matter most.
For comparing this to other investment options, try running the same $61,600 through a compound interest calculator at your expected stock market return. If the NPV of the rental property barely beats what you'd earn passively in an index fund, the property might not be worth the headache of being a landlord.
When someone offers to sell you their business — or you're thinking about buying into one — NPV is your best friend. Small business valuation is full of emotional nonsense from sellers who "put $200,000 into the buildout" and want that back. NPV cuts through it.
Treat the purchase price as your initial investment. Project the business's annual free cash flow (what's actually left after operating expenses, taxes, and required reinvestment) for the next 5-10 years. Add a terminal value if you plan to sell. Choose a discount rate that reflects the risk — for small businesses, that's 15-25%.
Yes, 15-25%. Not 8%. Small businesses have high failure rates, concentrated customer risk, key-person dependency, and limited liquidity. A 15% discount rate isn't pessimistic — it's realistic.
Purchase price: $180,000 (includes equipment and lease transfer). The laundromat generates about $42,000/year in net cash flow. It's been stable for three years. You expect modest growth (3%/year) and plan to sell in 7 years for roughly $200,000.
Year 1: $42,000 / 1.18 = $35,593
Year 2: $43,260 / 1.18² = $31,038
Year 3: $44,558 / 1.18³ = $27,098
Year 4: $45,894 / 1.18⁴ = $23,672
Year 5: $47,271 / 1.18⁵ = $20,688
Year 6: $48,689 / 1.18⁶ = $18,088
Year 7: $249,149 (sale + cash flow) / 1.18⁷ = $78,139
Total present value: $234,316. NPV = $234,316 - $180,000 = +$54,316.
That's a solid positive NPV at an 18% discount rate. The laundromat is worth more than the asking price, given the risk. But here's the thing: the seller probably used a 10% discount rate and got an NPV of $100,000+. That's why they're asking $180,000. The discount rate disagreement is where negotiations happen. If you can both agree on the cash flows (the hard part), the rest is just arguing about risk tolerance.
One more consideration: small businesses often have personal value that doesn't show up in NPV. Maybe you've always wanted to run a bakery. Maybe the laundromat is two blocks from your house and you can manage it between school drop-offs. NPV can't quantify lifestyle benefits, but they're real. Just don't pay a premium for them — the numbers need to work on their own.
Inflation erodes the purchasing power of future cash flows, and if you're not accounting for it in your NPV analysis, your results are wrong. Full stop.
There are two valid ways to handle inflation in NPV, and mixing them up is one of the most common mistakes I see:
Method 1: Nominal cash flows with nominal discount rate. Project your cash flows in future dollars (including expected price increases), and use a discount rate that includes inflation. If you expect 3% inflation and need a 7% real return, your nominal discount rate is about 10% (not exactly 10%, but close enough for most purposes). This is the most common approach in corporate finance.
Method 2: Real cash flows with real discount rate. Strip inflation out of both your cash flow projections and your discount rate. If you expect $50,000 in year-3 revenue with 3% inflation, the real value is $50,000 / 1.03³ = $45,757. Use a real discount rate (roughly nominal rate minus inflation). This is cleaner for long-term comparisons.
Never mix them. If your cash flows are in nominal dollars, use a nominal discount rate. If they're in real (inflation-adjusted) dollars, use a real rate. Get this wrong and you'll either overestimate or underestimate NPV by a significant margin.
Over 10 years at 3% inflation, a dollar loses about 26% of its purchasing power. Over 20 years, it loses 46%. Over 30 years, 60%. If you're evaluating a long-term project with fixed cash flows (like a bond or annuity), inflation is eating away at the real value every year.
Let's say you're evaluating a 20-year annuity that pays $10,000/year. At a 7% nominal discount rate with 3% inflation, the NPV is about $105,940. But the real purchasing power of those payments in year 20 is only $5,537. If you used a 4% real discount rate with real cash flows, you'd get the same $105,940 answer — but you'd see the declining real value more clearly in your projections.
For planning how much future dollars will actually buy, our inflation calculator shows you the real purchasing power erosion over any time period.
Here's the process I use every time I evaluate an investment. It takes about 15 minutes once you're comfortable with it.
Include everything. Not just the purchase price, but closing costs, setup fees, working capital requirements, and any money you need to put in before the investment starts generating returns. Be honest — optimism bias in this number is how people get into trouble. If you think you'll need $80,000, budget $90,000.
Estimate the net cash you'll receive (or pay) in each year. Be specific: "I think the business will do okay" is not a cash flow projection. Build it from the bottom up — revenue minus expenses minus taxes minus reinvestment. For long-duration investments, you don't need to project every year individually. Years 1-5 should be detailed; years 6-10 can be more approximate; beyond that, use a terminal value assumption.
This is where most people stumble. Use the guidelines I outlined earlier: match your discount rate to the risk level and your opportunity cost. When in doubt, use a higher rate. It's better to reject a marginal project than to accept one that looked good because you were too optimistic about the discount rate.
Use the calculator above. Enter your discount rate, initial investment as a negative number, and cash flows separated by commas. Hit Calculate. The result tells you whether the investment creates or destroys value at your chosen discount rate.
Run the NPV at three discount rates: your base case, then 2-3% higher and lower. Reduce your cash flow projections by 10-20% and see what happens. Delay the cash flows by a year. If the NPV stays positive across reasonable scenarios, you've got a robust investment case. If it flips negative easily, you need more confidence in your assumptions — or a higher margin of safety in the price.
This five-step process works for everything from stock investments to business acquisitions to equipment purchases. The savings calculator can also help you model what happens if you skip the investment and just save the money instead — that's your true opportunity cost.
$10,000 invested, $3K/$4K/$5K/$6K annual returns at 10% discount rate
→ NPV: $3,689.67 (profitable — investment returns 36.9% above the 10% hurdle)
$50,000 invested, $5K/$10K/$15K/$20K/$25K returns at 20% discount rate
→ NPV: $682.12 (barely profitable — very sensitive to assumptions)
$100,000 invested, $12K/year for 5 years at 5% discount rate
→ NPV: $51,977.40 (strong positive — but confirm the 5% discount rate matches your actual alternatives)
1. Enter your discount rate (%): This is your required rate of return or cost of capital. See the guide above for choosing the right rate.
2. Enter your initial investment: Use a negative number (money going out). Include all upfront costs.
3. Enter cash flows: Separate each period's expected net cash flow with commas. Year 1 first, then year 2, and so on.
4. Click Calculate: The result shows NPV. Positive = value-creating. Negative = value-destroying at your chosen discount rate.
5. Test different rates: Run the calculation at 2-3 different discount rates to see how sensitive the result is to your assumptions.
NPV (Net Present Value) is the sum of all future cash flows discounted back to today, minus the initial investment. The formula is: NPV = -C₀ + C₁/(1+r) + C₂/(1+r)² + ... + Cₙ/(1+r)ⁿ, where C₀ is your initial investment, C₁ through Cₙ are future cash flows, and r is the discount rate. A positive NPV means the investment creates value above your required return; negative means it destroys value. The calculator above handles the math — you just plug in the inputs.
Your discount rate should reflect your opportunity cost — what you could earn elsewhere with similar risk. For corporate projects, use WACC (typically 8-12%). For small business investments, use 12-18%. For personal investments, start with your expected stock market return (7-10%) and add 2-5% for illiquidity. For real estate, 8-12% for stable properties, 15-20% for speculative ones. The key is to think about it rather than defaulting to 10%. A 2% change in discount rate can flip a project from positive to negative NPV.
A negative NPV means the investment's future cash flows, when discounted to present value, don't cover the initial cost plus your required return. In other words, you'd earn more by putting the money into your next best alternative. However, check your discount rate — setting it too high makes good projects look bad. Also consider strategic value that isn't captured in cash flows, like market positioning or learning opportunities. NPV is a tool for decision-making, not a replacement for judgment.
NPV is more reliable for decisions because it measures actual dollar value created and handles unconventional cash flows correctly. IRR can produce multiple answers when cash flows change sign more than once, and it assumes reinvestment at the IRR rate (often unrealistic). Use NPV for the go/no-go decision, IRR for communication — executives and investors respond to percentage returns. If you need the IRR for a project, try our IRR calculator.
Inflation reduces the purchasing power of future cash flows. Use either nominal cash flows with a nominal discount rate (that includes inflation), or real cash flows with a real discount rate (inflation stripped out). Never mix them. At 3% inflation over 10 years, a dollar loses 26% of its purchasing power; over 20 years, 46%. For long-term investments, this is too significant to ignore. Use our inflation calculator to see the real value erosion over time.
Yes. Treat the purchase price plus closing costs as your initial investment, project annual net rental income (rent minus all expenses including mortgage, taxes, insurance, maintenance, and vacancy), and include a terminal value (expected sale price minus selling costs) in the final year. Use a discount rate of 8-12% for stable properties. NPV is particularly useful for comparing different properties or deciding between buying and investing elsewhere.
Payback Period measures how long until you recover your initial investment — it ignores the time value of money and any cash flows after the payback date. NPV accounts for the time value of every dollar across the entire project life. Payback Period is quick and intuitive but misleading for long-term investments. A project that pays back in 2 years but generates nothing after could look better than one that pays back in 4 years but generates cash for 20 more years. Always prefer NPV for actual decision-making.
Not necessarily. A $1,000,000 NPV on a $100,000,000 investment (1% return premium) is worse than a $100,000 NPV on a $200,000 investment (50% return premium). Compare NPV relative to investment size using the Profitability Index (NPV divided by initial investment). A higher PI means more value created per dollar invested. Also consider risk — a certain $100,000 NPV is usually preferable to a risky $150,000 NPV.