NPV with Terminal Value Calculator
In corporate valuations, 60-80% of project value often resides in the Terminal Value beyond the explicit forecast period.
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 | -$5,000,000 | 1.0000 | -$5,000,000 | -$5,000,000 |
| Year 1 | $800,000 | 0.9091 | $727,273 | -$4,272,727 |
| Year 2 | $950,000 | 0.8264 | $785,124 | -$3,487,603 |
| Year 3 | $1,100,000 | 0.7513 | $826,446 | -$2,661,157 |
| Year 4 | $1,250,000 | 0.6830 | $853,767 | -$1,807,390 |
| Year 5 | $7,500,000 | 0.6209 | $4,656,910 | $2,849,520 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 6.0% | -400 bps | $4,118,348 | +$1,268,828 | Accept |
| 8.0% | -200 bps | $3,451,589 | +$602,070 | Accept |
| 9.0% | -100 bps | $3,142,960 | +$293,440 | Accept |
| 10.0%Active | Base Case (Active) | $2,849,520 | — (Base) | Accept |
| 11.0% | +100 bps | $2,570,371 | -$279,148 | Accept |
| 12.0% | +200 bps | $2,304,677 | -$544,843 | Accept |
| 14.0% | +400 bps | $1,810,583 | -$1,038,937 | Accept |
| 23.5%IRR | Break-Even (IRR) | $0 | -$2,849,520 | 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] + [TV / (1+r)^n], where TV = CF_n * (1+g) / (r - g)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
- Includes explicit terminal year lump sum
- Gordon Growth Model compatibility
- Total Enterprise Value estimate
- Discounted terminal contribution metric
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/).
How do working capital and terminal salvage value impact NPV?
In capital budgeting, projects frequently require working capital and yield residual salvage value: 1. **Net Working Capital (NWC):** Upfront inventory and receivables investment increases Year 0 cash outflow (e.g. -₹2,00,000). At the end of the project lifecycle, this working capital is liquidated and added back as a cash inflow in Year $n$. 2. **Salvage / Residual Value:** When project machinery is sold at termination, after-tax salvage value (Market Price - [Tax Rate $\times$ (Market Price - Book Value)]) is added to Year $n$ cash inflow. 3. **Straight-Line Depreciation Tax Shield:** While depreciation is a non-cash expense, its annual tax savings ($\text{Depreciation} \times \text{Tax Rate}$) represent real annual cash inflows that increase NPV.