NPV
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.
FinancialFinance & Accounting
What it does
Calculates Net Present Value.
Syntax
NPV(rate, value1, [value2], ...)
Arguments
rate(number) — Discount rate.value1(value) — Cash flows.
Examples
Calculate NPV
NPV of cash flows.
FORMULA
=NPV(0.1, -1000, 500, 700)
RESULT
33.06
SAMPLE DATA
| A | |
|---|---|
| 1 | Flows |
| 2 | -1000 |
| 3 | 500 |
| 4 | 700 |