Net present value (NPV) estimates how much value an investment adds or destroys today by discounting its expected cash flows and including the initial investment. A positive NPV means the investment is expected to earn more than the selected required return; a negative NPV means it falls short. Use NPV as a decision framework based on stated assumptions, not as a guarantee of future results.
Why NPV matters
A dollar received today can be invested or used to reduce debt, while a dollar received later cannot be put to work until it arrives. NPV accounts for this time value of money by translating cash flows from different periods into present-value dollars. The discount rate also reflects the return required for the risk and opportunity cost of the investment.
NPV is not the same as accounting profit, revenue, or the payback period. It measures the present value of a project’s cash flows net of its investment and other outflows.
NPV formula
For regularly spaced periods, calculate NPV as:
NPV = CF0 + CF1/(1 + r) + CF2/(1 + r)2 + … + CFn/(1 + r)n
#1 Best Overall
- Profitability calculations; cash flow function Calculates NPV and IRR for uneven cash flows
- Time-value-of-money and Amortization keys solve problems including: pension calculations, loans, mortgages, etc.
- Ideal calculator for students, managers and statisticians
- Built-in functionality : List-based one- and two-variable statistics with four regression options: linear, logarithmic, exponential and power
- The BA II Plus calculator is approved for use on the following professional exams: Chartered Financial Analyst exam. GARP Financial Risk Manager (FRM) exam. Certified Management Accountants exam
Here, CF0 is the time-zero cash flow, usually a negative initial investment; CFt is the net cash flow in period t; r is the discount rate per period; and n is the number of periods. The initial investment is not discounted when it occurs at time zero.
Steps to calculate NPV
- Define the decision and valuation date. Identify the investment being considered and the date from which its cash flows will be measured.
- Estimate incremental cash flows. Include costs and benefits caused by taking the project: the initial outlay, operating cash flows, taxes where relevant, working-capital changes, maintenance or replacement costs, and any salvage or terminal proceeds. Do not substitute accounting earnings for cash flow without appropriate adjustments.
- Assign each cash flow to a period or date. For a standard annual calculation, put the initial investment at period 0 and subsequent cash flows at periods 1, 2, and so on. For irregular dates, use a date-based method such as XNPV.
- Choose a compatible discount rate. The rate depends on the cash flow being valued and its risk. Cash flow to equity is generally discounted at the cost of equity; cash flow to the firm is generally discounted at the weighted average cost of capital (WACC). Pair nominal cash flows with a nominal rate and real cash flows with a real rate.
- Discount each future cash flow. Divide each period’s cash flow by (1 + r)t, where t is its period number.
- Add the discounted cash flows. Include the time-zero outflow and keep the sign convention consistent: costs and investments are negative; receipts and benefits are positive.
- Interpret the result. A positive NPV indicates expected value above the chosen hurdle rate; zero means the expected return equals that rate; a negative NPV means the project falls short on the stated assumptions.
Worked NPV example
Suppose an investment costs $10,000 today and is expected to generate $4,000 at the end of each of the next three years. At a 10% annual discount rate:
NPV = -$10,000 + $4,000/(1.10) + $4,000/(1.10)2 + $4,000/(1.10)3
Rank #2
- PROFESSIONAL FINANCIAL CALCULATOR : Built-in TVM, IRR, NPV. Engineered for business analysts, real estate investors, accountants, and finance students.
- ADVANCED CASH FLOW & AMORTIZATION : Execute time value of money, break-even analysis, depreciation schedules, and bond pricing. Trusted for professional exam prep", MBA coursework, and banking certifications.
- CATIGA CF-300 : Flip-open hard case with a snap-close design for a secure fit. Compact and portable: designed for daily professional use in office, classroom, or on-site.
- ALL-IN-ONE FOR PROFESSIONALS : From NPV/IRR for real estate analysis to statistical calculations for business analysts. Handles probability, linear regression, and complex financial formulas.
- MORTGAGE, LOAN & INVESTMENT CALCULATOR : Covers bond pricing, loan amortization, investment analysis, and exam-level computations. Your go-to accounting calculator, business calculator, and real estate calculator in one device.
| Period | Cash flow | Present value at 10% |
|---|---|---|
| 0 | -$10,000 | -$10,000 |
| 1 | $4,000 | About $3,636 |
| 2 | $4,000 | About $3,306 |
| 3 | $4,000 | About $3,005 |
| Total NPV | About -$53 |
The NPV is approximately -$53, so this project falls slightly short of the 10% required return under these assumptions. A different forecast, discount rate, tax treatment, or terminal value would change the result.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Calculate NPV in Excel
For regularly spaced, end-of-period cash flows, Excel’s NPV function discounts the listed values as successive period-end payments. Add a separate time-zero investment outside the function:
=NPV(discount_rate, year1:yearN) + initial_investment
Rank #3
- HP 10BII+ FOR STUDENTS & PROFESSIONALS – This HP calculator is built for business, finance, accounting, and statistics courses. Perfect for learners and professionals who need to solve common financial problems quickly without memorizing formulas or relying on spreadsheets.
- 100+ FUNCTIONS FOR REAL WORLD MATH – Quickly solve time value of money, interest rates, loan payments, NPV, IRR, cash flows, and more. The 10bII+ also includes probability distributions for statistics courses—a feature not often found in financial calculators.
- ALGORITHMIC INPUT WITH DEDICATED KEYS – This high-school/college calculator uses algebraic and chain logic with minimal keystrokes. Layout appears the same as standard calculators for easy learning. Dedicated keys give quick access to commonly used financial and statistical functions
- APPROVED FOR MAJOR EXAMS – The HP 10bII+ algebra calculator is permitted for use on SAT, PSAT/NMSQT, and AP tests. An ideal statistics calculator and business calculator for school finance and accounting students preparing for class, coursework, or standardized exams.
- INCLUDES TRAVEL CASE, CLEANING CLOTH & BATTERIES– Slim, durable, and easy to keep on hand or store in a backpack or locker. Includes a protective case, cleaning cloth, and batteries so it’s ready out of the box. Large screen with clear contrast (non-backlit) is easy to read during exams or lectures.
Enter the initial investment as a negative value. Do not put it in the first value position inside NPV as if it occurred at the end of period 1. Microsoft documents the timing convention for its NPV function.
For cash flows on irregular dates, Excel’s XNPV function uses the supplied dates and discounts succeeding payments using a 365-day year. Its values should include at least one positive and one negative cash flow. See Microsoft’s XNPV function documentation.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →How to interpret NPV
| Result | Meaning | Typical interpretation |
|---|---|---|
| Positive | Expected discounted benefits exceed costs. | Advance or accept if the assumptions and risk adjustments are appropriate. |
| Zero | Expected return equals the selected required return. | Economically indifferent on the stated assumptions. |
| Negative | Expected discounted benefits fall short of costs. | Reject or revise, unless strategic, nonfinancial, or option-value factors warrant more analysis. |
NPV expresses value in currency, while internal rate of return (IRR) is the discount rate that makes NPV equal zero. IRR can be ambiguous when cash flows change sign more than once, so it should not be treated as interchangeable with NPV. Payback period focuses on how quickly the initial outlay is recovered and may not account fully for timing or later cash flows.
Rank #4
- Solves time-value-of-money calculations such as annuities, mortgages, leases, savings, and more
- Performs cash-flow analysis for up to 32 uneven cash flows with up to 4-digit frequencies
- Calculates various financial functions: Net Future Value Net present Value Modified Internal Rate of Return Internal Rate of Return Modified Duration Payback Discounted Payback
- The Texas Instruments BAII Plus Professional features an Automatic Power Down (APD) function for extended battery life
- Prompted display guides you through financial calculations showing current variable and label. Ten-digit display
Common NPV mistakes
- Misplacing the initial investment in Excel NPV. Add the time-zero outflow separately when using the standard NPV function.
- Mixing nominal and real assumptions. Match the inflation basis of projected cash flows and the discount rate.
- Discounting the wrong cash flow with a rate. Match cash flow to equity with the cost of equity and cash flow to the firm with WACC.
- Using accounting earnings instead of incremental cash flow. Consider cash effects such as taxes, capital expenditures, and working capital.
- Omitting end-of-project cash flows. Include applicable salvage proceeds and recoverable working capital.
- Treating a calculated NPV as certain. It depends on forecasts, timing, and the chosen discount rate; test important assumptions with sensitivity or scenario analysis.
- Assuming NPV alone resolves every comparison. Capital constraints, different project lives, or strategic flexibility may require additional analysis.
For more detail on the assumptions and judgment involved in discounted cash-flow valuation, see Aswath Damodaran’s DCF valuation discussion.
FAQ
What does a positive NPV mean?
It means the expected cash flows, discounted at the selected rate, exceed the investment and other outflows. It indicates expected value above the hurdle rate, not a guarantee of profit.
Should the initial investment be discounted?
Usually not, if it occurs at time zero, because it is already expressed in present-date dollars. In Excel’s NPV function, add that immediate outflow separately.
Free tools Windows power users keep installed
One-click scans. No signup required.
Best Value
- Brand New in box; The product ships with all relevant accessories
- Dedicated keys allow easy access to common financial and statistics functions
- Easy-to-use design provides business, finance and statistical calculations fast
- Specially designed to meet the mathematical needs
What discount rate should I use?
There is no universal rate. Choose one that fits the cash flow’s risk and financing context, and keep its inflation basis consistent with the cash-flow forecast. For business valuation, match the rate to whether the model uses cash flow to equity or to the entire firm.
Can NPV be used for cash flows on irregular dates?
Yes. Use a date-based calculation such as Excel XNPV rather than treating irregularly timed payments as equally spaced periods.
Is NPV better than IRR?
They answer different questions: NPV estimates value in currency at a selected discount rate, while IRR is the rate that makes NPV zero. NPV is the direct measure of value added, and IRR can be ambiguous for some cash-flow patterns.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →
