NPV
calculates net present value of investment · from excel · excel: not yet compared · sheets: not yet compared
signature
NPV(rate, value…)
returns: number
| argument | required |
|---|---|
| rate | required |
| value… | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=NPV(0.1, 100000, 120000, 140000) 295266.71675432 | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 4 | |
| 3 | 6 | |
| 4 | 8 | |
| 5 | 10 |
fx
=NPV(A1, B1:B10) 0.21999242475985867 related
- ACCRINT accrued interest for a security paying periodic interest
- ACCRINTM accrued interest for a security paying at maturity
- AMORDEGRC depreciation per period, French accounting, degressive
- AMORLINC depreciation per period, French accounting, linear
- COUPDAYBS days from coupon period start to settlement
- COUPDAYS days in the coupon period containing settlement