How this instrument works
Net present value takes every cash flow a project is expected to pay out, discounts each one back to today at a chosen rate, and subtracts the upfront cost of starting the project at all. The formula shape is the one behind present value and discounted cash flow work — divide each future dollar by (1 + r) raised to the year it arrives — but NPV goes a step further by folding the initial outlay in as a negative and summing the whole schedule into a single figure. A positive result means the projected cash flows are worth more today, at that rate, than the money it took to start; a negative one means they fall short.
Corporate finance teams run this exact calculation to screen capital projects before a committee signs off — a new production line, a fleet of delivery vans, a five-year equipment lease — anything with a defined cash-flow schedule and a finite life, as opposed to pricing an entire ongoing business, which is what a discounted cash flow model with a terminal value is built for instead. The discount rate entered here typically stands in for the company's cost of capital or hurdle rate: the return the same money could earn elsewhere, so a positive NPV means the project is expected to beat that alternative, not merely turn a profit.
The dollar figure this instrument returns is easy to misread when comparing two projects of different sizes: a project needing a $500,000 outlay that nets a $60,000 NPV can look better than one needing $10,000 that nets $8,000, purely because the first number is larger, even though the second used far less capital to get there. Ranking by raw NPV alone ignores that difference — comparing NPV per dollar invested, a profitability index, is what catches it. The formula also assumes nothing exists past year five; stretch a project's real life beyond that horizon and this sheet's dollar answer stops representing the whole story.
- Enter the day-one outlay in Initial investment (year 0), $ — everything spent before the project returns a dollar.
- Fill in Cash flow, year 1, $ through Cash flow, year 5, $ with the net cash the project is expected to produce each year, entering 0 where there is none.
- Set Discount rate, % to the return the capital could otherwise earn — the hurdle rate or cost of capital you are weighing the project against.
- Read Net present value, $ — positive means the project is projected to clear that hurdle rate; negative means it falls short.
Worked example — $10,000 upfront, $3,000 a year for five years
Set Initial investment (year 0), $ to 10,000, and Cash flow, year 1, $ through Cash flow, year 5, $ each to 3,000, with Discount rate, % at 10. Year one's $3,000 is divided by 1.10 once, year two's by 1.10 squared, and so on through year five's division by 1.10 to the fifth power; summing those five discounted years gives $11,372.36, and subtracting the $10,000 outlay leaves Net present value, $ at 1,372.36.
That $1,372.36 is positive, which is the entire verdict NPV exists to deliver: the project is projected to return more than the 10% discount rate demands, so accepting it is expected to add value rather than merely break even. Raise Discount rate, % to 15 with the same cash flows and Net present value, $ falls to roughly $56 — still positive, but barely, which shows how sensitive the accept-or-reject line is to the rate chosen.
Questions
What does a positive NPV actually mean?
It means the project's cash flows, discounted at the rate you entered, are worth more today than the money it costs to start — the project is expected to clear that discount rate and add value beyond it. A negative NPV means the cash flows fall short of what the discount rate demands, even if the project is nominally profitable in raw dollars.
How is NPV different from IRR?
NPV reports a dollar amount at a discount rate you supply; IRR instead solves for the single rate that would make NPV equal zero, reporting a percentage rather than a dollar figure. The two usually agree on accept-or-reject for one project, but they can rank competing projects differently, especially when the projects require very different amounts of capital.
Why isn't there a terminal value or a sixth year?
This sheet is built for a project with a defined, finite life — five years of cash flow and nothing assumed beyond it, which suits equipment purchases, leases, and fixed-term contracts. Pricing an entire ongoing business instead needs a terminal value standing in for everything past the forecast, which is a different calculation built for a different question.
Can a project with a bigger NPV actually be the worse choice?
Yes, when capital is limited. A $500,000 project netting $60,000 of NPV beats a $10,000 project netting $8,000 in raw dollars, but the smaller project returned far more value per dollar committed. Comparing NPV per dollar invested, a profitability index, catches that difference; comparing raw NPV alone does not.
What discount rate should I use?
This instrument does not choose one for you. Corporate finance teams typically use the company's weighted average cost of capital or a stated hurdle rate — the return the same money could earn elsewhere — so the NPV answer reflects whether the project beats that alternative, not merely whether it turns a nominal profit.
What happens if a cash flow is negative, like a mid-project repair?
The formula handles it without any change — a negative entry in a Cash flow, year, $ field simply subtracts its discounted value from the total instead of adding to it, exactly as the initial investment does at year zero. A costly repair in year three, for instance, is discounted and netted out the same as any other year.
References
- NYU Stern (Damodaran) — corporate finance and capital budgeting resources
- SEC Investor.gov — investing basics and valuation glossary
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.