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