Discount Factor Calculator & Table Schedule
A discount factor is a decimal multiplier used to discount a future value back to its present value for a specific year and interest rate.
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 | -$100,000 | 1.0000 | -$100,000 | -$100,000 |
| Year 1 | $25,000 | 0.9259 | $23,148 | -$76,852 |
| Year 2 | $30,000 | 0.8573 | $25,720 | -$51,132 |
| Year 3 | $35,000 | 0.7938 | $27,784 | -$23,348 |
| Year 4 | $40,000 | 0.7350 | $29,401 | $6,054 |
| Year 5 | $45,000 | 0.6806 | $30,626 | $36,680 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 4.0% | -400 bps | $54,069 | +$17,389 | Accept |
| 6.0% | -200 bps | $44,982 | +$8,302 | Accept |
| 7.0% | -100 bps | $40,738 | +$4,058 | Accept |
| 8.0%Active | Base Case (Active) | $36,680 | — (Base) | Accept |
| 9.0% | +100 bps | $32,797 | -$3,883 | Accept |
| 10.0% | +200 bps | $29,079 | -$7,601 | Accept |
| 12.0% | +400 bps | $22,104 | -$14,575 | Accept |
| 19.7%IRR | Break-Even (IRR) | $0 | -$36,680 | 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
Discount Factor = 1 / (1 + r)^tThis 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
- Instant 4-decimal precision factor table
- Multi-year schedule generation
- Compounding frequency adjustments
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$.
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%).