NPV Function

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
    • ...
    —[optional]
    Additional ranges of future cash flows.