Annual NPV Calculator (Multi-Year Cash Flows)
Optimized specifically for discrete multi-year capital budgeting, corporate fiscal-year evaluations, and long-term CapEx projects with annual compounding schedules. If you require multi-frequency compounding (monthly, quarterly) or irregular payment dates, use our flagship multi-frequency NPV Calculator.
The project earns more than the required return at the selected discount rate. Value is expected to be added to the firm.
Bars: present value of each period (Year 0 is initial outlay). Polyline: running cumulative total. When the line crosses zero, the project achieves economic break-even in today's money.
| Year | Cash flow | Discount factor | Present value | Running total |
|---|---|---|---|---|
| Year 0 | -$1,500,000 | 1.0000 | -$1,500,000 | -$1,500,000 |
| Year 1 | $400,000 | 0.9132 | $365,297 | -$1,134,703 |
| Year 2 | $550,000 | 0.8340 | $458,706 | -$675,997 |
| Year 3 | $600,000 | 0.7617 | $456,992 | -$219,005 |
| Year 4 | $650,000 | 0.6956 | $452,123 | $233,118 |
| Year 5 | $700,000 | 0.6352 | $444,659 | $677,778 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 5.5% | -400 bps | $944,549 | +$266,771 | Accept |
| 7.5% | -200 bps | $805,314 | +$127,536 | Accept |
| 8.5% | -100 bps | $740,164 | +$62,386 | Accept |
| 9.5%Active | Base Case (Active) | $677,778 | — (Base) | Accept |
| 10.5% | +100 bps | $618,007 | -$59,771 | Accept |
| 11.5% | +200 bps | $560,713 | -$117,065 | Accept |
| 13.5% | +400 bps | $453,041 | -$224,737 | Accept |
| 24.3%IRR | Break-Even (IRR) | $0 | -$677,778 | Break-Even |
Sensitivity analysis reveals how NPV shifts when corporate borrowing costs or inflation vary. As the discount rate increases, present value decreases.
Formula & Calculation Logic
NPV = -I_0 + Σ [CF_t / (1 + r)^t], where t represents discrete annual operating years (t = 1, 2, ..., n).This financial model applies precise periodic compounding to establish the exact present economic value of future cash inflows against the required initial investment.
Key Capabilities & Features
- Discrete annual compounding and discount factor schedule
- Multi-year corporate capital budgeting breakdown
- Annual payback timeline and break-even year tracking
- Direct companion to the flagship multi-frequency NPV calculator
Frequently Asked Questions
What is Net Present Value (NPV)?
Net Present Value (NPV) is a core financial metric used in capital budgeting to analyze the profitability of a projected investment or project. NPV calculations take into account the time value of money by discounting expected future cash flows back to their present value using a specified discount rate (such as WACC or required rate of return). If the NPV is positive, the project is projected to generate surplus value over and above its cost of capital.
What is a good NPV?
A good Net Present Value is any figure strictly greater than zero ($NPV > 0$), confirming that the investment yields cash flows beyond the required cost of capital and adds net shareholder wealth. When comparing mutually exclusive projects, the proposal with the highest positive NPV is optimal because it creates the greatest absolute monetary value. To gauge project efficiency and margin of safety across varying budget sizes, evaluate your NPV alongside the [Profitability Index (PI)](/profitability-index-calculator/) and explore our [Capital Budgeting Decision Guide](/what-is-net-present-value/).
Is a higher NPV better?
A higher NPV is generally preferred because Net Present Value quantifies the absolute currency surplus added to enterprise equity after covering all financing and capital costs. A higher positive figure represents greater total wealth creation for equity holders. However, critical exceptions exist: when comparing mutually exclusive projects with unequal lifespans, proposals must be converted into an Equivalent Annual Annuity (EAA) using our [Annuity NPV Calculator](/npv-annuity-calculator/). Similarly, under strict capital rationing constraints, selecting projects by Profitability Index (PI) maximizes total wealth creation per dollar invested. For a detailed breakdown of absolute dollar value versus percentage returns, read our [NPV vs IRR Guide](/npv-vs-irr/) and explore our [Capital Budgeting Comparison Table](/compare/).
Can NPV be negative and what does it mean?
A negative Net Present Value indicates that the projected cash inflows, when discounted at the selected hurdle rate, fail to recover the initial investment outlay and capital costs. It does NOT necessarily mean the project loses nominal money—it means the investment earns a rate of return strictly lower than the required discount rate. For instance, if your discount rate is 12% and the project earns 8%, the nominal cash flow may be positive, but the NPV will be negative.
At what discount rate is NPV zero?
When NPV equals zero ($NPV = 0$), the project's discounted cash inflows exactly match its initial capital expenditure, meaning the project earns precisely the required hurdle rate without adding or destroying surplus value. By mathematical definition, the exact discount rate that drives NPV to zero is the project's Internal Rate of Return (IRR). You can solve for this exact break-even rate using our interactive [IRR Calculator](/irr-calculator/) or explore our [NPV vs IRR Comparison](/npv-vs-irr/).