NPV
Σ period cash flow ÷ (1 + rate)^period, including the investment
- Formula
Σ period cash flow ÷ (1 + rate)^period, including the investment- Unit
- RUB
- Aggregation rule
- Sum
- Source system
- Plan and budget model
- Owning role
- Chief financial officer
- Frequency
- Quarterly
Passport
- Grain
- Project × cash-flow period
- At zero or no data
- No cash flows: “—”.
- Limits
- The rate and the discounting period are consistent in length. Investment enters as a negative flow in period zero. The rate is an assumption of the model owner.
- Check example
- Investment in period zero, RUB: 1000000; Cash flow of period 1, RUB: 600000; Cash flow of period 2, RUB: 600000; Discount rate, %: 10.
-a+b/(1+r/100)+c/Math.pow(1+r/100,2). Result: RUB 41,322 - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: NPV and payback
- Calculation: Investment project: NPV, IRR and payback
Definition
NPV is the project’s value in today’s money; payback is how soon the investment returns. The project’s return (IRR) is covered separately.
An NPV above zero and an IRR above the discount rate mean the project earns more than required. To test robustness use a scenario with flows cut by 20–30% (a conventional stress; set your own).