NPV with Salvage Value Calculator
Account for the residual market or scrap value of machinery, vehicles, and real estate assets at the end of their useful life.
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 | -$2,500,000 | 1.0000 | -$2,500,000 | -$2,500,000 |
| Year 1 | $600,000 | 0.9050 | $542,986 | -$1,957,014 |
| Year 2 | $700,000 | 0.8190 | $573,289 | -$1,383,725 |
| Year 3 | $750,000 | 0.7412 | $555,872 | -$827,853 |
| Year 4 | $800,000 | 0.6707 | $536,588 | -$291,265 |
| Year 5 | $1,100,000 | 0.6070 | $667,700 | $376,435 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 6.5% | -400 bps | $726,156 | +$349,721 | Accept |
| 8.5% | -200 bps | $543,605 | +$167,170 | Accept |
| 9.5% | -100 bps | $458,203 | +$81,769 | Accept |
| 10.5%Active | Base Case (Active) | $376,435 | — (Base) | Accept |
| 11.5% | +100 bps | $298,103 | -$78,331 | Accept |
| 12.5% | +200 bps | $223,027 | -$153,408 | Accept |
| 14.5% | +400 bps | $81,961 | -$294,473 | Accept |
| 15.7%IRR | Break-Even (IRR) | $0 | -$376,435 | 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 + Σ [Operating CF_t / (1+r)^t] + [Salvage Value / (1+r)^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
- Accounts for end-of-life asset liquidation
- Net present value boost from residual value
- Detailed yearly breakdown table
Frequently Asked Questions
How is NPV calculated step-by-step?
To calculate NPV step-by-step: 1. Identify the Year 0 initial investment outlay ($I_0$). 2. Estimate the expected net cash flow ($CF_t$) for each period $t = 1, 2, \dots, n$. 3. Determine the appropriate annual discount rate ($r$). 4. For each period, calculate the discount factor: $1 / (1 + r)^t$. 5. Multiply each cash flow by its discount factor to obtain its Present Value ($PV_t$). 6. Sum all present values: $PV_{\text{inflows}} = \sum PV_t$. 7. Subtract initial investment: $NPV = PV_{\text{inflows}} - I_0$.
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.
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.