Calculates the net present value of an investment based on a series of cash flows and a discount rate.
Sample Usage
NPV([Discount Rate]14, [Cash Flow]14, [Future Cash Flows]14:[Future Cash Flows]18)
Syntax
NPV(
-
discount_rate
-
number
-
range1
-
[
- range2
- ...
-
discount_rate—Percentage or decimal value to determine the discount.
-
number—Current cash flow.
-
range1—The group of future cash flows.
-
- range2
- ...
Additional ranges of future cash flows.