NPV
Calculates net present value of investment.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=NPV(0.1, 100000, 120000, 140000) Result 295266.71675432
=NPV(A1, B1:B10) | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 4 | |
| 3 | 6 | |
| 4 | 8 | |
| 5 | 10 |
Result 0.21999242475985867
Syntax
NPV(rate, value…)rate- number required
value…- number required
Related
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.