NPV with Inflation Calculator
High inflation erodes future cash flow purchasing power. This tool ensures your discount rate properly reflects real vs nominal rates.
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,000,000 | 1.0000 | -$1,000,000 | -$1,000,000 |
| Year 1 | $320,000 | 0.8929 | $285,714 | -$714,286 |
| Year 2 | $380,000 | 0.7972 | $302,934 | -$411,352 |
| Year 3 | $420,000 | 0.7118 | $298,948 | -$112,404 |
| Year 4 | $460,000 | 0.6355 | $292,338 | $179,934 |
| Year 5 | $500,000 | 0.5674 | $283,713 | $463,647 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 8.0% | -400 bps | $633,900 | +$170,253 | Accept |
| 10.0% | -200 bps | $545,158 | +$81,510 | Accept |
| 11.0% | -100 bps | $503,547 | +$39,900 | Accept |
| 12.0%Active | Base Case (Active) | $463,647 | — (Base) | Accept |
| 13.0% | +100 bps | $425,369 | -$38,278 | Accept |
| 14.0% | +200 bps | $388,629 | -$75,019 | Accept |
| 16.0% | +400 bps | $319,451 | -$144,197 | Accept |
| 28.0%IRR | Break-Even (IRR) | $0 | -$463,647 | 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
Real Rate = (1 + Nominal Rate) / (1 + Inflation Rate) - 1. NPV uses real cash flows discounted at real rate.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
- Fisher equation rate adjustment
- Purchasing power erosion tracker
- Comparison of nominal vs real present values
Frequently Asked Questions
What discount rate should I use for NPV?
Choosing the right discount rate depends on who is investing: 1. **Corporations:** Typically use the Weighted Average Cost of Capital (WACC), which blends the after-tax cost of debt and cost of equity. 2. **Individual Investors:** Use target required rate of return or the return available on alternative investments of similar risk (opportunity cost of capital). 3. **High-Risk Projects / Startups:** Adjust the hurdle rate using divisional CAPM beta calibration or formal cost-of-capital frameworks rather than ad-hoc additions. 4. **Public Infrastructure:** Often use government social discount rates (typically 3% to 8%).
Does NPV include inflation?
Inflation is properly handled in NPV modeling through consistent pairing: 1. **Nominal Approach (Standard):** Forecast cash flows in actual expected future dollars/rupees (inflated) and discount using a nominal discount rate that includes an inflation premium. 2. **Real Approach:** Forecast cash flows in constant base-year purchasing power (un-inflated) and discount using a real discount rate (calculated via the Fisher equation: $1 + r_{\text{nominal}} = (1 + r_{\text{real}})(1 + i)$). Mixing nominal cash flows with a real discount rate (or vice versa) is a common financial error that severely distorts project valuations.